Microsoft Power Bi

Prerequisites:

There are no prerequisites for this course.

Summary:

This 1 day course covers the essential skills in Power B: Connecting, Extracting & Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards.

Learning Outcomes:

• Produce visually compelling, intuitive Dashboards & presentations of your corporate data with Power BI
• Blend data from multiple sources into a single data stream for analysis
• Create basic ‘aggregates’ and ‘calculated columns’ and use them to manipulate data in the data model 
• Build various reports / dashboards using the extensive range of charting tools
• Share reports / dashboards with colleagues and people outside of the organisation

Course Content:

An Overview of Power BI :

• What is Power BI?
• Why Power BI?
• The Building Blocks of Power BI
• Power BI Updates The Power BI Desktop Interface
• Views: Report, Data, Relationships
• Overview of Query Editor
• Fields Pane
• Visualisations Pane
• Query Pane Connecting to Data Sources with Power BI Desktop
• Connecting to an Excel Workbook
• Connecting to a CSV File
• Optional: Connecting to an Access Database
• Optional: Connecting to a SQL Database
• Viewing Connection Options
• Managing Data Sources
• Refresh Report Creating a Report with Visualisations
• Creating a Visualisation
• Interacting with Visualisations
• Changing the Visualisation Type
• Moving and Resizing Visualisations Doing More with Visualisations
• Formatting Visualisations
• Viewing Visualisation Data
• Using Focus Mode and Spotlight
• Understanding Interactivity Between Visualisations Using Data View
• Formatting Data
• Managing Columns
• Sorting Table Data
• Filtering Table Data Creating Calculated Columns
• What is DAX?
• Creating New Calculated Colum