Microsoft Power BI Part 1
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI online and Power BI desktop. This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
- Power BI Overview
- Power BI Desktop User Interface and Navigation
- Connecting, importing and preparing data for use
- Merging, Grouping, Summarizing, and Calculating Data
- Visualizing & Creating Reports
- Publishing reports for online consumption
This module explains how the class will be structured and introduces course materials
and additional administrative
- Course Materials
- What We'll Be Discussing
In this module, we will explain what Power BI provides, examine the products available
and what they bring to the
table, and cover how Power BI updates are provided.
- What is Power BI?
- Examining Power BI Suite of Products
- Identifying Differences Between Products
- Understanding Power BI Updates
In this module, we will examine the steps necessary to install Power BI Desktop, explore
the interface, discuss the
available file types, and data sources, and discuss how to configure data refresh settings. We will also cover the
available data types and discuss best practices in utilizing them.
- Installing Power BI Desktop
- Exploring the Power BI Desktop Interface
- Utilizing File Types; PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
In this module, we will examine importing data, transforming data, loading data, and
manipulating data using CSV,
TXT, and Excel Worksheets. Power BI handles these files types with ease.
- Importing Data
- Transforming Data
- Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
In this module, we will discuss why merges have been difficult in the past, examine
how much easier they are to
utilize today, and explore grouping, summarizing and calculating options.
- Understanding the Issues with Merges
- Performing Merges
- Grouping Options
In this module, we will create a report and examine the visualization options.
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online