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