Power BI: Level 1 – Basics

Do you want to understand the basics of Power BI and, learn how to combine data from different sources into one single dashboard report?

In this course you will learn how to use Power BI cloud service and free Power BI desktop application. You will learn how to create data model, reports, visualizations and make calculations.

Goal

The goal of this course is that you know how to create data model and visualizations. Furthermore, you will learn to publish your reports in Power BI cloud service.

Target audience

This training is for those who has Office 365 Power BI service in use and wants to create basic reports with it.

Software requirements

Latest version of Power BI Desktop.

Content

Introduction: What is Power BI?

• Power BI concept
• User interface
• Power BI licenses
• What I need to know about the data sources

Power BI Desktop: First steps

• Power BI Desktop, what and why
• Criteria for data sources
• Importing data from other sources
• Creating a data model
• Visualization
• Publishing

Power BI -cloud: You only need a internet browser

• Power BI cloud service

What is Power Query: Useful data from bad source

• How is Power Query used?
• What you can do with Power Query?

DAX calculation

• What is measure?
• What is DAX?
• Examples about DAX calculations

Keywords

Power BI, Desktop, Business Intelligence, Microsoft Office 365, O365, data model, visualization, data analyzing, DAX, function, Query Editor