The Power BI training course is designed to take a user with a basic understanding of excel and office 365 and introduce them to the opportunities provided for the manipulation and visualisation of data.
To find out more about our SharePoint and Office 365 services get in touch today. call +44 (0) 7739 870 670 or Email us at: contact@solutionsdeveloped.co.uk
Audience: Intermediate
Experience with MS o365 required
The Power BI Training course covers the skills a user will be expected to use to create and maintain Power BI dashboards with visualisation.
Module 1 – Power Bi Introduction
Power BI Programs
Licensing
Limitations
Module 2 – Creation a Data Set for a Report
The difference between a Data set and a Data Source
Connecting to Data Sources
Using Multiple Data Sources
Editing the Data Queries
Linking Multiple Data Sources
Module 3 – Visualizations
Stacked Bar Charts and Stacked Column Charts
Clustered Bar Charts and Clustered Column Charts
100% Stacked Bar and Column Charts
Line Chart, Area Chart and Stacked Area Chart and Ribbon charts
Line and stacked columns, Line and Clustered columns charts
Waterfall Chart
Scatter Chart
Pie Charts and Donut Charts
Treemap
Map, Filled Map and ArcGIS Maps for Power BI
Funnel
Gauge
Slicers, Cards and Multi Row Cards
KPI
Tables and Matrices
Customising the Visualization
Module 4 – Multiple Pages
Filtering
When would you Filter
Module 5 – Publishing a Report and Sharing It
Publishing
Sharing the Report
Scheduling Refreshes
Embedding a Report
Module 6 – Creating a Dashboard
Adding Tiles to a dashboard
Sharing a Dashboard
Module 7 – DAX (Data Analysis Expressions)
What is DAX
What are calculated columns
What are measures
When to use a calculated column
When to use a measure
Using DAX in dynamic reports
Advanced DAX features
Solutions Developed
+44 (0) 7739 870 670