Power BI MasterClass: Learn Data Analytics with Power BI

Get started quickly with Visualization, Joins, DAX, Data Modelling with Microsoft Power BI

3.85 (37 reviews)
Udemy
platform
English
language
Development Tools
category
instructor
170
students
12.5 hours
content
Apr 2021
last update
$39.99
regular price

What you will learn

Automate Manual reporting Process using Microsoft Power BI

Master DAX for Power BI Desktop

Create Stunning reports for stakeholders

Form Relationships in your data and learn about Data Modelling

Transform Datasets from Multiple sources

Build Dashboard using COVID_19 Dataset and set up for daily refresh

Description

Have you heard that Data Science is the sexist job of the 21st century? That is because Data Analysts, Business Intelligence Analysts and pretty much anyone working with Data is in high demand. Companies are constantly searching for ways to make better and faster decisions and to do this, they rely heavily on data. This Power BI course is designed to arm you with the knowledge you need to go from raw data to insights and taught in a way that explains complex concepts in a simplified manner.

In this course, we utilize Adventure works Database and will download SQL Server and we will cover the following

  1. Data Connections where we bring in Data from different sources (Facebook, website, Odata, Csv,excel and Databases)

  2. Data Transformations where we actually cleanse the data

  3. Data Joins where we join data from multiple table into one source

  4. Charts where we try to create as many beautiful visuals as we can

  5. Filtering Data

  6. Data Modelling where we talk about Cardinality, Relationships and Data Models

  7. DAX in Power BI where we talk about different functions to create calculations

  8. CAPSTONE Project where we analyze COVID_19 data set

This course is action packed and over 12 hours long. I hope you enjoy the course as much as I enjoyed teaching it.


Cheers!

Sandra

Content

Introduction

Welcome to the course
Course Overview

Environment Setup

Installing Power BI
Installing Microsoft SQL Server
Installing Microsoft SQL Server 2
Installing Management Studio and Adventure works Database

Connecting to Different Sources

Connecting to CSV/Text Files
Connecting to Excel Files
Connecting to Webpage
Connecting to OData
Connecting to SQL Server
Connecting to Facebook

Performing Power BI Transformations

Change Data type, Enter Data and Renaming Tables
Duplicate, Rename, Remove, Reorder and Split columns
Merge Columns
Formating Dates in Power BI
Combine Multiple Dates
Grouping using Bins 1
Grouping using Bins 2
Grouping using Lists 1
Grouping using Lists 2
Creating Hierarchies
Utilizing Drill up and Drill Down to analyze data
Creating Query Groups
Pivot and Unpivot Tables

Joining and Blending Data

Utilizing Left outer Join
Right Outer Join
Inner Join and Full Join
Left Anti and Right Anti Join
Using Append Queries

All About Charts

Area Charts
Area Charts 2
Bar Charts
Line and Stacked Charts
Waterfall and Ribbon Charts
Tree Map, Scatter Chart
Pie and Donut Chart
Funnels and Matrices
Cards and Maps
Column Charts

Filtering Data Using Power BI

Using Slicers
Using Slicers 2
Visual Level filters
Filters on Measures
Page level and Report level filters
Drill through filters
Guage and KPIs
Key Influencer Visuals

Data Modelling Using Power BI

Introduction to Data Modelling (Star Vs Snowflake Schema)
Cardinality Introduction
Creating Relationships Part 1
Creating Relationships Part 2
Bidirectional Filtering

Using DAX in Power BI

Creating Calculated Columns
Calculated Tables and Conditional Columns
DAX Date Functions
DAX Aggregate Functions
DAX Logical functions
DAX Text Functions
DAX Text Functions 2
DAX Filter Functions
DAX Time Intelligence Functions

CAPSTONE PROJECT: Using COVID-19 Data Set

Connecting and Shaping COVID_19 Data
Adding DAX Functions to COVID_19 Data
Visualizing COVID_19 Data

Screenshots

Power BI MasterClass: Learn Data Analytics with Power BI - Screenshot_01Power BI MasterClass: Learn Data Analytics with Power BI - Screenshot_02Power BI MasterClass: Learn Data Analytics with Power BI - Screenshot_03Power BI MasterClass: Learn Data Analytics with Power BI - Screenshot_04

Reviews

S
August 17, 2023
Many times it gets tough to understand what she is saying. I have tried starting this course many times but could never complete it for same reason.
Kathleen
March 25, 2023
I wish I would have known that you cannot do this course on a Mac book because of having to download an application based Power BI software. I previously took a separate course that teaches PowerBI and SQL and it provided a site-based application that operates as Power BI. I would recommend the requirements be stated in the course description prior to a person purchasing this. Also, and most importantly, I feel like the instructor is not clear on certain aspects of the course as she often mentions, "I don't know if I mentioned this earlier, but this screen is called this __," or "I don't know if I said this earlier, but you can only use expand on tables that have relationships," and she doesn't mention it until several minutes later, or further into the course. It's very confusing for someone who is learning. The transcript also is not good. So many words are off and I cannot fully understand the instructor, so I am relying on captions or transcript and they are so ridiculously off. I do not like leaving negative reviews, but the teaching style could use enhancing and more clarity in terms of having a structured sequence to follow, touching on all aspects relevant to each section when applicable. I cannot emphasize enough how unhappy I am that I paid for this course because I should have selected a different one.
Jesse
May 26, 2021
This is the best course on Power BI I have encountered! She makes it really easy to understand such complex topics and it trains you as you go along so that once you're finished with the course you are confident enough to work on your own. I totally recommend this course to anyone who is interested in Power BI or Business Inteligence.

Charts

Price

Power BI MasterClass: Learn Data Analytics with Power BI - Price chart

Rating

Power BI MasterClass: Learn Data Analytics with Power BI - Ratings chart

Enrollment distribution

Power BI MasterClass: Learn Data Analytics with Power BI - Distribution chart
3954280
udemy ID
4/2/2021
course created date
4/19/2021
course indexed date
Bot
course submited by