Power BI Essential Training

Get Started with Power Query, Data Preparation, Data Modeling, DAX & Data Visualization and Dashboards

4.50 (108 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
1,060
students
4.5 hours
content
May 2020
last update
$54.99
regular price

What you will learn

Power Query, Data Modeling, DAX, Dashboards & Reports using Power BI

Quick methods for Data Analysis techniques, creating Visualization and Reports

Creative Data connection techniques using Power Query

Data Insights by learning quick and simple techniques

Learn how to automate your Reports and avoid repetitive tasks

Description

Knowledge is Power.

Learn how to use it.

We all are surrounded by data and data is everywhere, but problem is to handle chaotic data to turn into the reports to take business decisions.


WHAT IS POWER BI

  • Power BI is a collection of software services that work together to turn your unrelated sources of data into interactive insights.

  • Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

BIG DATA IS EVERYWHERE

The term “big data” has been around since the 1990s, yet the explosion of data in the past few years has driven home its relevance and importance. The world is already generating an estimated 2.5 exabytes of data every day. That’s expected to rise to 463 exabytes daily by 2025.

Learn Microsoft Power BI (Business Intelligence) which creates useful report quickly and let you improve your Data Analysis techniques. There are many programs you can use to prepare reports and analyze data, but Power BI is the leader in market of business intelligence and easy to acquire the necessary skills.


WHY USE POWER BI

  • Starts from Free and then minimal upfront cots

  • Big Data connectivity, live query connection

  • Automation of tasks and create reports once

  • View Power BI reports across multiple platforms and devices

  • Consolidate multiple data sources through Power BI

  • Drag-and-drop functionality

  • Quick sharing of Dashboards

  • Drill-down functionality

  • Natural Query Language

  • Growing Power BI online community


WHAT YOU WILL LEARN

  • Simple methods to Analyze data with Power BI and gain Insights

  • Automate manual reporting processes with Power BI


PREREQUISITES

  • Fundamental Excel Knowledge is an added advantage

  • Knowledge of Excel Pivot Tables is an added advantage


WHO THIS COURSE IS FOR?

  • Power BI beginners

  • Data Analyst

  • Visualization and Dashboards lovers

  • It is for everybody who want Business Intelligence skills


Content

Introduction

Welcome note
Introduction
Download Power Bi Desktop
Download the Data Resources
Starting with Power BI Desktop
Power BI release
Understanding Data and Data types
Need to combine data from multiple tables
Tools to bring data into shape
Power BI Desktop

Data Connectivity and Power Query

What is Power Query?
Download Data to connect with Power Query
Importing Data in Power Query Desktop
Append Data in Power Query
Merge Query option
Power Query Quiz
Data Transformation in Power Query
Download the pbix file of Append & Merge
Other Key Power Query tools and options
Power Query Editor
Editing Queries & Data Refresh
Data Transformation

Advanced Power Query & M Language

Advanced Power Query Intro
Connect with different file types like Excel, text/csv, Access File, PDF file
Importing Data from Web
Connecting PQ
Connect with multiple Excel Sheets in a Wrokbook
Connecting all files from a folder
Power Query Advance

Using Power BI Desktop

Using Power BI Desktop Canvas
Download Case Study (MS Access File)
Connect Case Study data in Power BI
Selecting different Visuals
Choosing Visuals wisely
Editing your Visuals
Card Visual importance
Using Slicers in Power BI
Power BI
What is covered so far?

Building Data Modeling

Understanding Data Modeling
Difference between Fact table and Dimension tables
What is the Relationshiop concept
Star Schema approach in building Relationship
Testing your Model
Fixing Issues with Model
Data Model
Importance of building a Correct Data Model

DAX and Model Optimization

What is DAX?
Why DAX is necessary
Calculated Field vs Measure
Understanding the Need for Model Optimization
DAX
Time Intelligence feature
Importance of CALENDARAUTO Function
Time Comparison functions YTD, MTD etc.
Use of Quick Measures
DAX optimization

Dashboard Reports and Case Studies

Solving the Case Studies
Case Study 1 (Data Model Optimization)
Case Study 1 (DAX Measures)
Case Study 1 (Dashboard preparation)
Chosing Color Theme
Dashboard Reprort -Case Study 2
Case Study 2 Task
Case Study 2 Data prepartion
Case Study 2 Data Model Complete
Case Study 2 - Assignment
Case Sutdy 2 Dashboard Task

Screenshots

Power BI Essential Training - Screenshot_01Power BI Essential Training - Screenshot_02Power BI Essential Training - Screenshot_03Power BI Essential Training - Screenshot_04

Reviews

Waqas
September 3, 2022
overall course was very good. trainer tried to cover almost every thing possible. obviously at the end it is on me how i practice. thank you very much.
Noaman
January 12, 2022
Good course for beginners and the Instructor was well knowledgeable and experineced while delivering.Thank you for the knowledge.
Muhammad
December 30, 2021
This is first time I go through Power BI and found this course Power BI Essential Training very comprehensive and full of learning. I strongly recommends for those who really wants to learn Power BI.
James
November 3, 2020
It is decent so far. I forgot about this and a reminder would be nice but that has nothing to do with this course. This course uses short videos which is ok for now but I am hoping when it gets more advanced the videos will be longer too.
Pratheesh
August 15, 2020
Good delivery of the course. Well structured with each session having smaller time duration for ease of understanding and if required to go through the sessions again. Ideal for individuals looking to get introduced to Power BI
Joseph
August 15, 2020
Great Job, Asif. The course is really good. Many thanks. What would you suggest as a follow up course ?
Ayushi
August 7, 2020
An excellent course for beginners. Learnt some very useful tricks and formulas. Just wished there was a bit more on DAX. Overall, an informative course!
Anandhan
August 1, 2020
yes, but can advice on the excel file saving such as sales data, got some error while loading but it helped to understand on how to link folder and fetch files from it better
Muhammad
July 7, 2020
I is very very interactive and best of the knowledge course, I must appreciates your approach. Regards
Rajeev
June 21, 2020
Yes it was a good match , but until now the training and the contents which have been shared are almost sub par to some of the youtube tutorials available for free. When we sign up we expect some content , cheat sheet or reusable templates. I feel this was missing. Also , the trainer seems content with touching upon just the basics of a rather intuitive tool like Power BI and hence this rating. He should add some additional resources or links for further read up and advanced topics if they are not being covered here in future. Also , some of the steps are not needed and then we go back and delete and start again.. We waste time with these steps..
Ivan
June 8, 2020
Great course. Although i know all this, it was good option to see another ways of working. P&L report was very helpfull. Not many people know about sequence tricks. I listened on 2x speed and it was clear. Thank you very much.
Salman
May 29, 2020
I started and get amazed after watching few videos such a comprehensive and easy follow interactive course...so far awesome ? I will highly suggest my friends and professional colleagues to go for this course, truly outstanding

Charts

Price

Power BI Essential Training - Price chart

Rating

Power BI Essential Training - Ratings chart

Enrollment distribution

Power BI Essential Training - Distribution chart
3131622
udemy ID
5/15/2020
course created date
5/30/2020
course indexed date
Bot
course submited by