Skip to content Skip to site navigation Skip to service navigation

Fundamentals of Microsoft Power BI

Class Sessions

Date Location Cost
  • Tue Mar 17, 9:00 am to 4:00 pm
Birch Hall 105 (Birch Lab A) $400

Class Code

ITS-1268

Class Description

This course will introduce you to the Power BI (Business Analytics Tool, Power BI Desktop and Power BI) service from Microsoft allowing you to discover how to build beautiful and informative dashboards and reports.

Prerequisite: Basic knowledge of computers

In this class we will cover a real world project, including how to collect, clean, shape and explore your data to find performance, trends, patterns and correlations in your data. 

We will be covering Power BI visuals, Data modeling Power BI desktop features and Power BI service features. After building the reports and dashboards we will publish these to cloud, allowing you to share and collaborate with your colleagues. 

 

In this course, you will have an opportunity to:

- Install Power BI Desktop on personal computer

- Learn Power BI desktop features

- Lean Power BI Service features

- Learn how to clean the messy data, model your data as per your requirement, and format your report to make it look beautiful and professional

- Lean and understand to use different and custom visualizations

- Learn to use the easiest Business Intelligence tool to create stunning reports and dashboards

- Learn how to do collaboration and sharing of content on Microsoft's Powerful platform

 

Topic Outline:

- Course Introduction

- Overview Power BI

   - Why Power BI

   - Evolution of BI Stages

   - User Workflow

   - Power BI Lifecycle

   - Natural Language Query

   - Quick Insights

   - Cortana Integration

   - Live Dashboards

   - Content Packs

   - Power BI Platforms

- Installation of Power BI Desktop

- Basic Operations

- Power BI Desktop Walk-thru

- Working with Data

   - Collecting data from text file

   - Collecting data from Excel

   - Collecting data from Databases

- Working with Power BI Query Editor

   - Renaming columns

   - Removing columns

   - Removing Rows

   - Make Row as header

   - How to create calculate column by example

   - How to create custom column

   - How to create conditional column

   - How to change data types

   - How to replace values

   - How to rearrange columns

   - Merge queries

   - Append queries

- Power BI Visualizations

   - Bar Charts

   - Pie Charts

   - Donut Charts

   - Combo Charts

   - Other Custom Charts

   - Visuals Cards

   - Visuals Gauges

   - Visuals KPIs

   - Visuals Tables

   - Visuals Matrix

   - And other custom visuals

- Data Modeling

   - Modeling Basics

   - Modeling and Relationships

   - Normalization ¿ DE normalizations

   - Star Schema vs Snowflake Schema

- Hands on Real-world Projects

   - Demographics report for Bank

- Introduction to Dax

   - What is Dax?

   - M vs Dax

   - Rules to create Measures

   - Calculate Columns vs Calculate Measures

- Power BI Service

   - Workspaces

   - Reports

   - Datasets

   - Dashboards

   - How to create Workspaces

   - Create Dashboards six different ways

   - Favorite dashboards, reports, and apps

   - Dashboard menus

   - Quick Insights

   - Q-A in Power BI

   - Analyze in Excel

   - File and View Options

   - Printing dashboards and reports

   - Row Level Security

- Sharing and Collaboration

   - Sharing Dashboards

   - Sharing Workspaces

   - Sharing Apps

   - Publish to web
 


 

 

University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.