• LOGIN
  • No products in the cart.

Build the dashboards companies ask for: Power Query, star-schema data models, DAX measures and time intelligence, report design, row-level security and publishing to the Power BI Service.

Course Curriculum

1. Getting Data
1.1 Power BI Desktop tour 00:09:00
1.2 Connecting to Excel, SQL and web sources 00:10:00
1.3 Power Query transformations 00:15:00
2. Data Modeling
2.1 Fact and dimension tables, star schema 00:14:00
2.2 Relationships and cardinality 00:10:00
2.3 Date table 00:08:00
3. DAX
3.1 Calculated columns vs measures 00:10:00
3.2 CALCULATE and filter context 00:15:00
3.3 Iterators: SUMX, AVERAGEX 00:10:00
3.4 Time intelligence: YTD, MTD, YoY 00:14:00
3.5 Variables and DAX best practices 00:09:00
4. Visualization
4.1 Choosing visuals and report layout 00:10:00
4.2 Drill-through, tooltips and bookmarks 00:12:00
4.3 Dashboard design principles 00:10:00
5. Sharing
5.1 Publishing to Power BI Service and workspaces 00:09:00
5.2 Scheduled refresh and gateways 00:09:00
5.3 Row-level security 00:09:00
5.4 Final project: executive dashboard for a multi-branch company 00:30:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.