1

Overview, refreshers, and best practices

• Refresher on the design cycle of a Power BI report.
• Connecting and preparing data.
• Understanding the structure of a star schema, fact tables, and dimension tables.
• Expression of need and identifying sources of data.
• Organizing tables and relationships, defining measures, visualization.

2

Using queries to design an appropriate model

• Merging requests to reduce snowflakes.
• Aggregating and stacking sources.
• Importing data from a list of sources.
• Customizing functions and passing parameters in M.
• Managing errors.

3

Working with the Time dimension

• Using variables in DAX to produce a calendar, lists, and functions to produce a calendar in M.
• Cumulative sum by period. Comparing periods. Cumulative sum over sliding periods.
• Using Time Intelligence functions to create period comparisons, cumulative sums, and sliding periods.
• Using the functions: DATEADD, DATESYTD, DATESBETWEEN, DATESINPERIOD, CLOSINGBALANCE.
• Working with multiple date columns and double relationships with USERELATIONSHIP.
• Filtering data over the current period.

4

Using advanced DAX functions

• Calculating a cumulative sum with the EARLIER function.
• The CALCULATE function with multiple conditions and the FILTER function.
• The function of managing blank values: ISBLANK.
• DAX table creation functions: FILTER, CALCULATETABLE, ADDCOLUMNS, SUMMURIZE, UNION, etc.

5

Display, navigation, and visualizations

• Creating a background, a theme, a report template.
• Using bookmarks for navigation and storytelling.
• Representing with images. Preparing dynamic comments and customizing tooltips.
• Defining a personalized visual with the Synoptic Panel.
• Creating Master Detail reports using drillthrough filters.
• Using the filter pane and selection pane.