Audience
Non-technical staff that are wanting to start Power BI Development
Prerequisites
Familiarity with IT concepts
Duration
2 Days
Course Objectives
During this session delegates will be introduced to the Power BI. The main features of Power BI will be explained and hands on labs will be provided to all participants to gain experience of the tool.
After this course, delegates will be able to create Power BI reports and dashboards. Drawing the data from many of the common sources: SharePoint, Excel, SQL. Candidates will have been exposed to the powerful scripting resources to transform data (DAX).
Course Content
Day 1
Course Details
Power BI Introduction
Power BI Programs
Licensing
Limitations
Outlining a Report
What Does a Report Need to Have?
Creating 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
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
Treemapping
Day 2
Map, Filled Map and ArcGIS Maps for Power BI
Funnel
Gauge
Slicers, Cards and Multi Row Cards
KPI
Tables and Matrixes
Customising the Visualization
Multiple Pages
Filtering
Publishing a Report and Sharing it
Publishing
Sharing the Report
Scheduling Refreshes
Embedding a Report
Creating a Dashboard
Adding Tiles to a dashboard
Sharing a Dashboard