Power BI Introduction
One day course
Course Overview
This Microsoft Power BI course teaches you how to connect to a range of data sources, create dashboards and reports, and collaborate with others. The course works with data from Excel, csv files, and websites. You will learn how to check data accuracy, create charts, maps, and tables, and compile them into user-friendly report dashboards. Gain insight into data model relationships, and writing DAX (Data Analysis Expressions) formulas to enhance a report’s capabilities. You will also learn how to share your reports with others.
Prerequisite
You should have a reasonable understanding of Excel, for example you know how to filter and sort data, create a basic chart, and run sum totals.
Course Content
Lesson 1. Getting Started
1.1. The Power BI environment
1.2. Different views in Power BI
Lesson 2. Connecting 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 environment
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. Basics of DAX measures
8.2. Insert a SUM function
8.3. Adding measures to visuals
8.4. COUNTROW function
8.5. DISTINCTCOUNT function
8.6. DAX formula rules
8.7. CALCULATE function
8.8. The syntax of CALCULATE
Lesson 9. Time Intelligence
9.1. A date table
9.2. Time intelligence functions
9.3. Insert a TOTALYTD function
9.4. Time intelligence visuals
Lesson 10. Visual Hierarchies
10.1. Drilling into data
10.2. Use hierarchies in visuals
