Power BI Introduction
1-day course
Course Overview
This introduction course helps you to understand the processes of creating reports and analysing data in Microsoft Power BI. It looks at importing source files from: Excel, csv files and data from the web. then how to transform those into an interactive, user-friendly dashboard containing maps, charts and table visualisations.
You will gain insights into data modelling and writing DAX (Data Analysis Expressions) formulas to enhance a report’s capabilities. It also takes you through the process of sharing your reports with others.
Prerequisite
You should have a reasonable understanding of Excel, for example you know how to filter and sort tables, create basic charts, and sum up numbers.
Course Content
Lesson 1. Getting Started
1.1. The Power BI environment
1.2. Different views in Power BI
Lesson 2. Importing Files
2.1. Process of importing data
2.2. Import an Excel file
2.3. Import a CSV/Text file
2.4. Import from a webpage
2.5. Managing file connections
Lesson 3. Power Query Editor
3.1. Process of cleaning data
3.2. What are applied steps?
3.3. Managing data types
3.4. Filters and filling data
Lesson 4. Inserting Visuals
4.1. What is storytelling?
4.2. Things to keep in mind
4.3. Insert and format a map
4.4. Insert and format a chart
4.5. Insert and format a treemap
4.6. Insert a table and a matrix
4.7. Insert a card for KPIs
4.8. Insert an image
4.9. Filter a report with a slicer
Lesson 5. Power BI Service
5.1. Power BI service UI
5.2. Pin visuals to a dashboard
5.3. Share report dashboards
Lesson 6. The Data Model
6.1. The concept of data models
6.2. Relationship properties
Lesson 7. DAX New Column
7.1. Basics of new columns
7.2. Adding column calculations
Lesson 8. DAX Measures
8.1. Insert a SUM measure
8.2. Adding measures to visuals
8.3. COUNTROW measure
8.4. DISTINCTCOUNT measure
8.5. DAX formula rules
Lesson 9. CALCULATE Measure
9.1. The syntax of CALCULATE
9.2. The CALCULATE function
Lesson 10. Time Intelligence
10.1. Importance of a date table
10.2. View cumulative totals
10.3. The TOTALYTD measure
10.4. Compare historical totals
10.5. Insert a DATEADD measure
10.6. Time intelligence in visuals
Lesson 11. Visual Hierarchies
11.1. Drilling into data
11.2. Use hierarchies in visuals