课程: Microsoft Project for the Web: Reporting with Power BI

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Building report tables

Building report tables

课程: Microsoft Project for the Web: Reporting with Power BI

开始一个月试用 购买团队方案

Building report tables

“

- [Instructor] To streamline the Staging tables into reporting tables, we need to duplicate each table, then rename it and remove and rename the columns that exist in that table so that others will understand how we built our dataset. To do that, I'm going to start off in duplicating the Programs table. So I'm going to select, right-click on it and select Duplicate. And I'll move it to the Report Tables group. And I'll right-click on it again. And this time I'll get rid of everything that says Staging. The last part I will want to do is right-click on it and select Properties and say Enable load on report and press OK. And we'll leave the Import function. Now I need to make sure that this Programs table uses the Programs Staging data. So I'm going to go to the source here and eliminate this common data source step and change that to pound sign, double quote, Programs Staging, double quote again. And I'll hit the…

内容