Microsoft Power BI Business Scenarios
4.3 (247 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,968 students enrolled

Microsoft Power BI Business Scenarios

Intermediate course for Power BI users to create real world Business Scenarios step-by-step using Microsoft free tools.
4.3 (247 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,968 students enrolled
Created by BizticsCom King
Last updated 5/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 27.5 hours on-demand video
  • 32 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn how to use DAX (Data Analysis Expressions) to get Business Performance, Patterns and Trends from Data
  • Master Power BI Best Practices, Tip, Tricks and Case Studies that you won't find in ANY other course
  • Learn to Create advanced powerful calculations using Measures, calculated columns & DAX Formulas
  • Build business intelligence solutions to Explore and Analyze data like never before
  • Learn DAX TIME-INTELLIGENCE to support the needs of Business Intelligence analysis by manipulate data using time periods
  • Learn to combine multiple data sources for enhanced data analysis
  • Learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS.
  • Import, consolidate and create relationships from your data and perform enhanced analysis
  • Get LIFETIME access to project files, quizzes and homework exercises, and 1-on-1 expert support
  • Learn to use the easiest Business Intelligence tool to create stunning reports and dashboards.
  • learn how, with Power BI, to connect to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services etc....
  • Learn Dataflows (new CDM base, Azure Data Lake gen2), what it is and how to use and configure databases in it.
  • Learn how to turn data into insight and interactive visualizations to tell a story
  • Learn and develop data modeling skills
  • Learn how to collaboration and sharing of content on Microsoft's Powerful platform
  • This hands on course will prepare you to start your data analytics career
Requirements
  • You need to be able to use Microsoft Power BI, at least at a basic level.
  • Your willingness to learn, follow the course and explore new opportunities.
  • Power BI can be downloaded for free, no additional costs involved.
  • All additional files, checklists and material will be provided
  • We highly recommend to check out "Microsoft Power BI - Business Intelligence for Beginners" first (Our beginners course in Power BI).
Description

Description

**** Life time access to course materials. 100% money back guarantee ****

Companies are gathering more and more data everyday. Skills in data analysis, Business Intelligence / Business Analytics are highly in demand in today's job market. Microsoft Power BI is an advanced yet easy to use self service Business Intelligence / Business Analytics tool for that. It is same B.I. tools used by professional analysts and data scientists.

In this course together we will go over business scenarios where you will learn, how to use Power BI and advanced / complex DAX calculations further to derive more insights from data. We are using SQL Server Adventure Works Data warehouse as a sample database. We will hold your hand and walk you thru each scenario Step-by-step.

Not only you will learn Power BI Best Practices, Tip, Tricks and Case Studies that you won't find in ANY other course but also learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. All of the exercises are designed by keeping the practical aspects of Power BI and DAX in mind. All exercises are 100% hands-on.

25+ hours of HD videos of building Business Scenarios using DAX and 10 interactive Business Intelligence Reports and Dashboards from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning . You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements.

By the time you complete this course, You'll be a highly proficient in DAX and Power BI user. You'll be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease.

Why should you consider a career as a Business Data Analyst?

  • Salary. A Business Data Analyst is a well-paid career

  • Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.

  • Advancement in Career : Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them.

#microsoft #powerbi #data #business #intelligence #analysis #DAX

We are covering the following in this course.

Section 1: Advanced Microsoft Power BI Introduction

  • Advanced Microsoft Power BI Course Introduction

  • Why Microsoft Power BI

  • Microsoft Power BI Family

  • Microsoft Power BI Desktop

  • Microsoft Power BI Service (Cloud) 1

  • Microsoft Power BI Service (Cloud) 2

  • What is Descriptive, Predictive and Prescriptive Analytics

  • How to take the quizzes


Section 2: Advanced Microsoft Power BI - Collect , In-jest and Import Data

  • Import Data from CSV files in Microsoft

  • Import Data from Excel files in Microsoft Power BI Desktop

  • Import Real-time Streaming Data in Microsoft Power BI Service (Cloud)

  • Import Data from OData Feed REST-API in

  • Microsoft Power BI Desktop

  • Import Data from Folders in Microsoft Power BI Desktop


Section 3: Download and Install SQL Server and Sample Databases

  • Download and Install SQL Server

  • Download and Install Sample Database

  • Import Data from SQL Server in Microsoft Power BI Desktop


Section 4: Introduction to Power BI Dataflows

  • Power BI Dataflows - Introduction

  • Power BI Dataflows - Create Gateway from Scratch

  • Power BI Dataflows - Create Entities from CSV file

  • Power BI Dataflows - Create Entities using SQL Server


Section 5: Introduction to Data Modeling

  • Modeling Basics 0

  • Modeling Basics 1

  • Modeling Basics 2

  • Modeling and Relationships 0

  • Modeling and Relationships 1

  • Other ways to create Relationships

  • Normalization - Denationalization 0

  • Normalization - Denationalization 1

  • OLTP vs OLAP

  • Star Schema vs Snowflake Schema 0

  • Star Schema vs Snowflake Schema 1



Section 6: DAX Basics

  • DAX Basics - Importing Data for Dax Learning

  • DAX Basics - Resources for Dax Learning

  • DAX Basics - What is Dax

  • DAX Basics - Dax Data Types

  • DAX Basics - DAX Operators and Syntax

  • DAX Basics - M vs Dax

  • DAX Basics - Create a Column

  • DAX Basics - Rules to Create Measures

  • DAX Basics - Calculated Columns vs Calculated Measures-0

  • DAX Basics - Calculated Columns vs Calculated Measures-1

  • DAX Basics - Sum()

  • DAX Basics - AVERAGE()-MIN()-MAX()

  • DAX Basics - SUMX()

  • DAX Basics - DIVIDE()

  • DAX Basics - COUNT()-COUNTROWS()

  • DAX Basics - CALCULATE()-0

  • DAX Basics - CALCULATE()-1

  • DAX Basics - FILTER()

  • DAX Basics - ALL()



Section 7: Hands-on Real-word Projects

  • Procurement Spend Analysis

  • Products Analysis

  • Regional Analysis

  • IT Tickets Analysis

  • Human Resources Analysis 1

  • Human Resources Analysis 2

  • Human Resources Analysis 3

  • Financial Analysis

  • Sales/Marketing Analysis

  • Bank Demographic Report



Section 8: Personal - Enterprise Gateway On-Premises Gateway

  • Personal vs Enterprise Gateway

  • Install and Configure Personal Gateway

  • Install and Configure Enterprise Gateway

  • Manage SQL Server Data Source thru Enterprise Gateway


Section 9: Advanced Time-Intelligence

  • Create Date Table in DAX-0

  • Create Date Table in DAX-1

  • Dax Date Code

  • Create Date Table in M (important) 11min

  • Date Table Code in M

  • How to use PREVIOUS Function

  • How to use SAMEPERIODLASTYEAR Function

  • How to calculate Cumulative or Running totals TOTALXXX()

  • How to use DATEADD Function

  • How to add column DateLastPurchase in Customer Table

  • How to calculate Days to Ship and Delivery Status

  • How to calculate Spring-Summer-Autumn-Winter Sales for 2012

  • How to Calculate Customer Age and use it in charts and graphs

  • How to calculate Days till last purchase

  • How to calculate Month-Over-Month values

  • How to calculate Previous Week Sales

  • How to calculate Running Total 1

  • How to calculate Running Total 2

  • How to calculate sales for last N days

  • How to calculate Weekend - Weekday sales 1

  • How to calculate Weekend - Weekday sales 2

  • How to calculate Year-Over-Year Growth

  • How to calculate Year-To-Date with Different Fiscal Year

  • How to Calulate Thanksgiving-BlackFriday-CyberMonday 2 we…

  • How to compare Quarter over Quarter 01

  • How to compare Quarter over Quarter 02

  • How to compare Years-Quarters-Month better way

  • How to create Short Month Name for Fiscal Year

  • How to do Grouping and Segmenting 1

  • How to do Grouping and Segmenting 2

  • How to use specific relationships if you have more than 1 relationship

  • DAX - Quick Measures

  • Display Last Refresh Date



Section 10: Advanced Scenarios

  • Create new table for Scenarios Measures

  • How to calculate number of order per customers

  • How to add calculated column in Employee table

  • How to add calculated column in Resellers table

  • How to calculate Customers (using TOPN) for Target Marketing

  • How to calculate and display Profit Margins

  • How to calculate and display sales growth

  • How to calculate how many items bought by Customers Multple times

  • How to calculate how many Resellers sold specific Item more than 5 times

  • How to calculate Moving Average 1

  • How to calculate Moving Average 2

  • How to calculate number of Products - Customers Sales Trend

  • How to calculate Profit or Margin Variance Month-Over-Month

  • How to calculate Trend on Profit for Internet Sales

  • How to categorize Employees on Sales

  • How to categorize Re-sellers

  • How to create Product Segment

  • How to export measures from Power BI file

  • How to see top N Products 01 Statically

  • How to see top N Products 02 Dynamically

  • How to calculate and show Profits

  • How to calculate Best Product Sales Day

  • How to calculate Dynamic TOPN product or Customers

  • How to calculate Hot Selling Products

  • How to calculate how many unique Customers bought specific Product

  • How to calculate how many unique Products bought by each Customer

  • How to calculate product sales growth

  • How to calculate Re-seller 01 Sales Growth Year-Over-Year

  • How to calculate Re-seller 02 Sales Growth Year-Over-Year

  • How to calculate Revenue Forecast using Analytics Tab

  • How to calculate Revenue Forecast using What If Parameter

  • How to calculate Top Employees

  • How to calculate which Re-seller selling what Products

  • How to show Products quantity forecast using Analytics Tab

  • How to show Products quantity forecast using using What If Parameter

  • How to smooth the trend using Moving Averages



Section 11: Sharing and Collaboration in Power BI

  • Sharing and Collaboration

  • Sharing Dashboards

  • Sharing Workspaces

  • Sharing Apps

  • Publish to web


Section 12: Bonus - Power BI Best Practices

  • Power BI Best Practices 0

  • Power BI Best Practices 1

  • Power BI Best Practices 2

  • Power BI Best Practices 3

  • Power BI Best Practices 4

  • Power BI Best Practices 5


Section 13: Bonus - Dashboard-in-a-day (Same as actual Microsoft class)

  • Power BI Dashboard-in-a-day class 0 - Introduction

  • Power BI Dashboard-in-a-day class 1 - Accessing Data

  • Power BI Dashboard-in-a-day class 2 - Data Preparation

  • Power BI Dashboard-in-a-day class 3 - Data Preparation

  • Power BI Dashboard-in-a-day class 4 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 5 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 6 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 7 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 8 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 9 - Visualization

  • Power BI Dashboard-in-a-day class 10 - Visualization

  • Power BI Dashboard-in-a-day class 11 - Publishing Report

  • Power BI Dashboard-in-a-day class 12 - Creating Dashboards

  • Power BI Dashboard-in-a-day class 13 - Creating Dashboards

  • Power BI Dashboard-in-a-day class 14 - Creating Dashboards

Best Regards

Biztics Team

Who this course is for:
  • Anyone looking to get a job and prepare to start data analytics career.
  • Entrepreneurs/CEO/Founders looking to master the Data Analysis process.
  • If you want to impress your boss and STANDING OUT from your colleagues and peers
  • Students learning in the field of  Data.
  • You want to extend your knowlege in advanced DAX calculations .
  • Data scientists.
  • Business Analyst and aspiring Business Analyst.
  • You want your reports stand out and "WOW" your audience.
  • Business Analyst in charge of automation efforts.
  • Enthusiastic quality professionals who are NEW to the Business.
  • Analysis and want to take their skills to the next level.
  • Business Analyst who want to advance their skill set.
  • Anyone wanting to transition into Business Analyst.
Course content
Expand all 201 lectures 27:33:49
+ Advanced Microsoft Power BI - Collect , In-jest and Import Data
5 lectures 27:02
Import Data from CSV files in Microsoft Power BI Desktop
04:30
Import Data from Excel files in Microsoft Power BI Desktop
04:15
Import Real-time Streaming Data in Microsoft Power BI Service (Cloud)
09:35
Import Data from OData Feed REST-API in Microsoft Power BI Desktop
02:30
Import Data from Folders in Microsoft Power BI Desktop
06:12
+ Download and Install SQL Server and Sample Databases
3 lectures 23:56
Download and Install SQL Server
07:56
Download and Install Sample Database
08:22
Import Data from SQL Server in Microsoft Power BI Desktop
07:38
+ Introduction to Power BI Dataflows
4 lectures 37:56
Power BI Dataflows - Introduction
05:31
Power BI Dataflows - Create Gateway from Scratch
08:14
Power BI Dataflows - Create Entities from CSV file
13:17
Power BI Dataflows - Create Entities using SQL Server
10:54
+ Introduction to Data Modeling
11 lectures 01:24:03
Modeling Basics 0
10:21
Modeling Basics 1
06:24
Modeling Basics 2
04:51
Modeling and Relationships 0
08:53
Modeling and Relationships 1
07:27
Other ways to create Relationships
04:34
Normalization - Denationalization 0
09:44
Normalization - Denationalization 1
06:41
OLTP vs OLAP
08:02
Star Schema vs Snowflake Schema 0
08:36
Star Schema vs Snowflake Schema 1
08:30
+ DAX Basics
19 lectures 02:13:39
DAX Basics - Importing Data for Dax Learning
06:31
DAX Basics - Resources for Dax Learning
06:00
DAX Basics - What is Dax
05:09
DAX Basics - Dax Data Types
04:07
DAX Basics - DAX Operators and Syntax
08:21
DAX Basics - M vs Dax
08:32
DAX Basics - Create a Column
05:39
DAX Basics - Rules to Create Measures
06:37
DAX Basics - Calculated Columns vs Calculated Measures-0
08:48
DAX Basics - Calculated Columns vs Calculated Measures-1
06:19
DAX Basics - Sum()
06:06
DAX Basics - AVERAGE()-MIN()-MAX()
04:22
DAX Basics - SUMX()
06:27
DAX Basics - DIVIDE()
06:48
DAX Basics - COUNT()-COUNTROWS()
09:42
DAX Basics - CALCULATE()-0
08:42
DAX Basics - CALCULATE()-1
05:51
DAX Basics - FILTER()
10:51
DAX Basics - ALL()
08:47
+ Hands-on Real-word Projects
42 lectures 06:13:15
Adv - Procurement-Spend Analysis-0
08:00
Adv - Procurement-Spend Analysis-1
08:01
Adv - Procurement-Spend Analysis-2
08:27
Adv - Procurement-Spend Analysis-3
07:31
Adv - Procurement-Spend Analysis-4
09:13
Adv - Product Analysis-0
09:17
Adv - Product Analysis-1
08:45
Adv - Product Analysis-2
11:52
Adv - Product Analysis-3
05:51
Adv - Regional Analysis-0
09:16
Adv - Regional Analysis-1
11:21
Adv - Regional Analysis-2
09:44
Adv - Regional Analysis-3
09:54
Adv - Regional Analysis-4
06:35
Adv - IT-Tickets Analysis-0
09:15
Adv - IT-Tickets Analysis-1
10:06
Adv - IT-Tickets Analysis-2
11:23
Adv - IT-Tickets Analysis-3
09:52
Adv - IT-Tickets Analysis-4
14:10
Adv - Human Resources 1-0
09:22
Adv - Human Resources 1-1
11:21
Adv - Human Resources 1-2
08:16
Adv - Human Resources 1-3
13:41
Adv - Human Resources 2-0
06:33
Adv - Human Resources 2-1
10:37
Adv - Human Resources 2-2
09:30
Adv - Human Resources 3-0
07:45
Adv - Human Resources 3-1
09:29
Adv - Human Resources 3-2
08:53
Adv - Financial Report-0
09:16
Adv - Financial Report-1
08:52
Adv - Financial Report-2
09:31
Adv - Financial Report-3
09:25
Adv - Financial Report-4
05:49
Adv - Sales Report-0
10:33
Adv - Sales Report-1
09:00
Adv - Sales Report-2
04:42
Adv - Bank Report-0
05:18
Adv - Bank Report-1
07:37
Adv - Bank Report-2
08:05
Adv - Bank Report-3
05:35
6.18 Adv - Bank Report-4
05:32
+ Personal - Enterprise Gateway
5 lectures 37:54
On-Premises Gateway
07:41
Personal vs Enterprise Gateway
03:23
Install and Configure Personal Gateway
09:45
Install and Configure Enterprise Gateway
06:00
Manage SQL Server Data Source thru Enterprise Gateway
11:05
+ Advanced Time-Intelligence
31 lectures 04:12:47
Create Date Table in DAX-0
07:36
Create Date Table in DAX-1
07:59
Create Date Table in M (important)
10:47
How to use PREVIOUS Function
05:58
How to use SAMEPERIODLASTYEAR Function
06:27
How to calculate Cummulative or Running totals TOTALXXX()
06:35
How to use DATEADD Function
10:32
How to add column DateLastPurchase in Customer Table
05:11
How to calculate Days to Ship and Delivery Status
05:27
How to calculate Spring-Summer-Autumn-Winter Sales for 2012
05:31
How to Calculate Customer Age and use it in charts and graphs
08:29
How to calculate Days till last purchase
09:17
How to calculate Month-Over-Month values
08:11
How to calculate Previous Week Sales
08:02
How to calculate Running Total 1
05:33
How to calculate Running Total 2
04:45
How to calculate sales for last N days
15:40
How to calculate Weekend - Weekday sales 1
07:08
How to calculate Weekend - Weekday sales 2
07:04
How to calculate Year-Over-Year Growth
13:37
How to calculate Year-To-Date with Different Fiscal Year
09:22
How to Calulate Thanksgiving-BlackFriday-CyberMonday 2 weeks sales
11:14
How to compare Quarter over Quarter 01
09:51
How to compare Quarter over Quarter 02
06:56
How to compare Years-Quarters-Month better way
08:04
How to create Short Month Name for Fiscal Year
05:32
How to do Grouping and Segmenting 1
07:45
How to do Grouping and Segmenting 2
14:50
How to use specific relationships if you have more than 1 relationship
08:49
DAX - Quick Measures
06:07
Display Last Refresh Date
04:28
+ Advanced Scenarios
36 lectures 05:00:01
Create new table for Scenarios Measures
02:21
How to calculate number of order per customers
09:03
How to add calculated column in Employee table
07:23
How to add calculated column in Resellers table
08:49
How to calculate Customers (using TOPN) for Target Marketing
09:34
How to calculate and display Profit Margins
10:56
How to calculate and display sales growth
06:40
How to calculate how many items bought by Customers Multple times
08:37
How to calculate how many Resellers sold specific Item more than 5 times
10:25
How to calculate Moving Average 1
05:33
How to calculate Moving Average 2
06:18
How to calculate number of Products - Customers Sales Trend
07:03
How to calculate Profit or Margin Variance Month-Over-Month
15:58
How to calculate Trend on Profit for Internet Sales
08:12
How to categorize Employees on Sales
06:41
How to categorize Resellers
09:04
How to create Product Segment
07:18
How to export measures from Power BI file
08:09
How to see top N Products 01 Statically
05:10
How to see top N Products 02 Dynamically
07:53
How to calculate and show Profits
09:09
How to calculate Best Product Sales Day
05:59
How to calculate Dynamic TOPN product or Customers
11:47
How to calculate Hot Selling Products
07:44
How to calculate how many unique Customers bought specific Product
06:39
How to calculate how many unique Products bought by each Customer
06:52
How to calculate product sales growth
11:19
How to calculate Reseller 01 Sales Growth Year-Over-Year
09:42
How to calculate Reseller 02 Sales Growth Year-Over-Year
10:00
How to calculate Revenue Forecast using Analytics Tab
05:41
How to calculate Revenue Forecast using What If Parameter
12:32
How to calculate Top Employees
06:29
How to calculate which Reseller selling what Products
09:23
How to show Products quantity forecast using Analytics Tab
07:54
How to show Products quantity forecast using using What If Parameter
11:13
How to smooth the trend using Moving Averages
06:31