Download Workshops

Download the presentation

About Data Analysis and Business Intelligence

Overview on Power BI

Get Data from Excel - Example 1

Get Data from Excel - Example 2

Get Data from Excel - Example 3

Get Data from Web

Get Data from Access Database

Get Data from SQL Server

Get Data from Folder

Get Data from Onedrive

Transform Data

Conditional Column

Group by

Transform vs. Add

Append Queries

Merge Queries

Review Get and Transform Data

Overview on Model View

Model View Table Properties

Model View Field Properties

Model View Create and Manage Relationships

Model View Table Properties

Analyze Data - Summarize Values by and Show Values as

Understanding DAX Measures and Calculated Columns

Practicing DAX Functions

Insert Visual and Format - Column Chart

Insert Visual and Format - Line Chart

Insert Elements - Text Box Buttons Shapes and Images

Page Format Tooltip Themes and Advanced Visual Features

HR Training - Get and Clean Data

HR Training - Formatting Data and Manage Relationships

Column Quality Column Distribution and Column Porfile

HR Training - Reports Part 1

HR Training - Reports Part 2

HR Training - Reports Part 3

Sales Case Study - Get Data and Transform

Sales Case Study - Format data and Manage Relationships

Sales Case Study - Reporting and Visualization - Part 1

Sales Case Study - Reporting and Visualization - Part 2

Sales Case Study - Slicers and Filters settings

Review Case Studies

Create Bookmarks

Design Mobile Layout

Publish Report to Power BI Service

Create Dashboard

Get Quick Insights

Q&A Feature

On-Premises-Gateway setup and configuration

Final Assessment

Congratulations