This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI.

Description

We cover the following aspects:

Get Data (bringing in your data for analysis)

• Data Sources in Power BI Desktop

• Connect to web data and web apps

• Import Excel Workbooks

• Connect to enterprise Database

Data Transformation, Power Query and DAX

• Get Data

• Model section of the report builder (Power BI Desktop)

  • Creating Relationships

  • Cardinality

  • Direction

• Data section of the report builder (Power BI Desktop)

  • Data Type

  • Data Format

  • DAX

    • New Column

    • New Measure

    • New Table

    • Must know DAX formulas

    • DAX formula reference guide

  • Row level Security to control report access using roles (dept, function, branch, cost centre etc)

• Report section of the report builder (Power BI Desktop)

  • Report creation

  • Native Visuals

  • Custom Visuals

  • Menu Tools for professional looking reports

  • Edit Interactions

  • Report creation from scratch

• Power Query

  • Transforming and Combining Data before loading to Model

  • Common Power Query tasks

    • Unpivot

    • Pivot

    • Split Column

    • Append Tables

    • Merge Tables

    • Remove rows

    • Use first row as header

    • Merge Columns

    • Add Columns

    • Group By

    • Extract

    • Fill

    • Transpose

    • M Code reference resource

Report Publishing, Dashboards and Power BI Service

• Understanding the concept of Workspaces

• Publishing report (from Power BI desktop to Power BI service for consumption)

• Controlling access to aspects of the report by role (region, department or level)

• Published Report options

  • Exporting to PowerPoint or PDF

  • Embedding in SharePoint

  • Embedding in a website

  • Making it available via a web link

  • Sharing with specific users

  • Editing the report – adding new visuals, changing visuals used and creating new report pages

  • Adding comments and tagging users

  • Scheduling the report to send our daily or weekly to specific people

• Creating a Dashboard

  • Can be created from one or more reports to show management useful analysis

  • Can incorporate data and visuals from other people’s dashboards or reports shared with you

  • Set Alerts to be instantly notified when a KPI is reached or an SLA is breached

  • Add actionable comments

  • Schedule the dashboard to be sent out daily or weekly to specific people

  • Share the dashboard with final users

• Best practices

• Setting automatic/scheduled refresh so new data is ingested automatically

• Data Gateway configuration

  • The type of data sources that require data gateway

AI in Power BI and Settings

• Q&A for autogenerating charts and tables in answer to questions

• Organization wide settings

• Account wide settings

• Workspace settings

• Dashboard settings

• Report settings

• Datasets settings

This is the course to solidify your Power BI proficiency.

• Data Analysts
• MIS Analysts
• Financial Analysts
• Project Managers
• Supply Chain Analysts

Course content

• Introduction and Power BI Setup
  • Introduction to the Course
  • Setting up an account and installing Power BI
• Bringing In Data into Power BI
  • Get Data to bring in the practice data files
  • Connecting to Databases, web sources and cloud apps.
• Data Transformation using Power Query
  • Data Transformation - part 1
  • Data Transformation - part 2
• Data Modeling
  • Data Modeling - part 1
  • Data Modeling - part 2
  • Data Modeling - part 3
  • Data Modeling - part 4
• Report Creation and DAX
  • Report Creation - part 1
  • Report Creation - part 2
  • Report Creation - part 3
  • Report Creation - part 4
  • Report Creation - part 5
  • Report Creation - part 6
  • Report Creation - part 7
  • Power BI Desktop Quiz
• Power BI Service
  • Power BI Service - part 1
  • Power BI Service - part 2
  • Power BI Service - page 3
  • Power BI Service - page 4
  • Power BI Service - part 5
  • Power BI Service - part 6
  • Power BI Service - part 7
• Report Refresh and Scheduling Refresh
  • Report Refresh and Scheduling Refresh - part 1
  • Report Refresh and Scheduling Refresh - part 2
• More DAX formulas
  • SUMMARIZE
  • CALENDAR
  • VALUES
  • CALCULATE
  • CROSSJOIN
  • UNION