Power BI Introduction
Duration: 1 day
Course Overview
This course will help 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
Module 1: Getting Started
1.1. The Power BI environment
1.2. Different views in Power BI
Module 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
Module 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
Module 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. The treemap visual
4.6. Insert a table and matrix
4.7. Insert a card for KPIs
4.8. Insert an image
4.9. Filter a report with a slicer
Module 5: Power BI Service
5.1. Power BI service UI
5.2. Pin visuals to a dashboard
5.3. Share report dashboards
Module 6: The Data Model
6.1. Concept of data models
6.2. Relationship properties
Module 7: DAX New Column
7.1. Basics of new columns
7.2. Add column calculations
Module 8: DAX Measures
8.1. Insert a SUM measure
8.2. Add measures to visuals
8.3. COUNTROW measure
8.4. DISTINCTCOUNT
8.5. DAX formula rules
Module 9: CALCULATE Measure
9.1. Syntax of CALCULATE
9.2. The CALCULATE function
Module 10: Time Intelligence
10.1. Using a date table
10.2. View cumulative totals
10.3. The TOTALYTD measure
10.4. Time intelligence visuals
Module 11: Visual Hierarchies
11.1. Drilling into data
11.2. Visual hierarchies