Course Code: lwfpbiint
Duration: 14 hours
Overview:

A 2 day course created for data ananlysts to develop skills in core features, functionality and use of Microsoft Power BI.

Course Outline:

Introduction to Power BI

  • What is Power BI?
  • Core components:
    • Power BI Desktop
    • Power BI Service
    • Other (mobile, gateway, report builder ...)
  • Licensing:
    • Free features
    • Power BI Pro
    • Power BI Premium
  • Strengths and limitations

Developing Reports in Power BI Desktop

  • Connecting to and loading data
  • Creating and configuring report visuals:
    • Column/bar
    • Line
    • Tables / Matrices
    • Cards
    • Gauges
    • Basic maps
    • Text boxes and images
  • Report themes and templates
  • Using the filter pane, slicers and cross-filtering
  • Preparing, transforming and cleaning data (Power Query) – e.g.:
    • Choose Columns
    • Renaming
    • Filtering
    • Change Types
    • Add columns (simple text/number, conditional, calculate durations)
    • Grouping
    • Replace Values
    • Split Column
    • Merging data
    • Appending
  • Data modelling
    • Relationships
    • Star Schema - Facts and Dimensions
    • Date tables
  • Introduction to DAX:
    • Calculated Columns – e.g. RELATED( ), LOOKUPVALUE( ), DATEDIFF( )
    • Measures – e.g. SUM( ), AVERAGE( ), DISTINCTCOUNT( ), CALCULATE( ), DATESYTD( )
    • Tables – e.g. SUMMARIZECOLUMNS( ), CALENDAR( )
    • DAX Formatter
    • Using Variables (VAR ; RETURN)
  • Drill-down / hierarchies
  • Drill-through

Power BI Service:

  • Navigating Power BI Service
  • Workspaces
  • Publishing reports
  • Sharing reports
  • Data refresh in Power BI Service
  • Subscriptions
  • Dashboards
  • Apps
  • Introduction to Row-Level Security