Business Intelligence with Power BI Desktop

Master Power BI, Data analysis, Visualization and designing Dashboard

4.62 (1389 reviews)
Udemy
platform
English
language
Data & Analytics
category
16,956
students
7 hours
content
Oct 2021
last update
$139.99
regular price

What you will learn

Understand the business intelligence workflow

Transform raw data into an interactive dashboards

Build professional-quality business intelligence reports from the ground up

Description

- Power BI is becoming the most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike

- A comprehensive, guide to learning Microsoft Power BI Desktop.

- You can connect to hundreds of data sources, build complex relational models using simple and intuitive tools,

- You can design stunning, interactive dashboards from scratch

- You'll Lead Business Intelligence Analyst for business case, to design and deliver a professional business intelligence solution.

- Don't worry, I'll be with you to get dirty with this project step - by- step

- Whether you're a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI expert, Guaranteed

- Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together


Course Structure :

- Section 1 : Introduction to Data analysis and power Bi Desktop

- Section 2 : Connection and Shaping Data

- Section 3: Table Relationships and Data Model

- Section 4: Analyzing Data with DAX

- Section 5: Data Visualization with Power BI Desktop


Who this course is for:

  • Data Analysts

  • Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills

  • Anyone looking to pursue a career in data analysis or business intelligence

Content

Introduction

Introduction

2. Connection and Shaping Data

Introduction and adjusting settings in Power Bi
2-2.Transform data in power bi
2-3. Dealing with texts - Voice Problem
2-4.Dealing with numbers
2-5.Working with Date & Time
2-6.Index column and conditional column
2-7.Grouping & Aggregating
2-8. Pivot & unpivot Demo 1
2-8. Pivot & unpivot Demo 2
2-9. Merging Queries
2-10. Append Queries
2-11.Connecting a folder
2-12. Data source sitting and refreshing in report
2-13. Data type and categories in PBi
2-14. Hierarchies in PBi

3. Table Relationships and Data Model

3-1.The issue and Data model
3-2. Normalization and understand Data table & Data lookup
3-3. Creating table relationship
3-4. Snowflake schemas
3-5. Editing relationship and Active vs. Inactive relationship
3-6. Connect multiple data table
3-7. Filter flow
3-8. Bi direction ( two-way) direction filter
3-9. Hiding fields from the report view

4. Analyzing Data with DAX

4-1. Intro to DAX and calculated column
4-2. Intro to measures
4-3. Adding measures, Implicit vs. Explicit measures
4-4. DAX Date & Time function 1
4-4. DAX Date & Time function 2
4-5.DAX. IF-OR-AND functions
4-6. DAX, Common text functions
4-7. DAX , Joining Data with related
4-8. DAX, Math functions
4-9. DAX. Count functions ( Count, COUNTA, Countrows, distinctcount)
4-10. important
4-11. DAX, Calculate function
4-12. DAX, Calculate ALL
4-13. DAX, Filter
4-14. DAX, Iterator functions
4-15. DAX, Time intelligence

Data Visualization with Power BI Desktop

5-2. Basics of Visualization Data in Power BI
5-3. Formatting options
5-4. Filter Options
5-5. Explore data with Matrix
5-6. Filter Data with slicers
5-7. Cards and KPI Visuals
5-8. Text Cards
5-9. Visualizing Data with Maps
5-10. Visualizing Data with Tree maps
5-11. Trendline and Area Chart
5-12. Trendline with forecasts
5-13. Goal pacing with gauges chart
5-14. Edit Report Interactions
5-15, Drill Through Filter
5-16. Report Bookmarks
5-17. What if analysis
5-18. Managing and Viewing Roles
5-19. More visuals, Mobile Layout and PBI Service need cut

Screenshots

Business Intelligence with Power BI Desktop - Screenshot_01Business Intelligence with Power BI Desktop - Screenshot_02Business Intelligence with Power BI Desktop - Screenshot_03Business Intelligence with Power BI Desktop - Screenshot_04

Reviews

Oksana
August 30, 2023
Good material, but explanations are messy and hard to follow at times. Logical steps are often mixed up resulting in loosing the train of thought regarding to what and why we are doing. The lecturer should have put more effort in course preparation - there are so many unnecessary steps because of the lack of a structure for each lesson. Also there should be Udemy content quality review before the course gets released. I did it for free and it still made me feel frustrated on how poor the delivery was, but if I paid money for it, I would give up and ask for a return..
Karl
August 30, 2023
The instructor needs to let the student know where they are moving the mouse and after moving the mouse indicate where they are. I am glad I already understand Power BI, otherwise I think I would be lost.
Mohamed
August 2, 2023
the course is very good as you will turn from a normal user to one who can do more and more in power bi, your skill will turn from 0% up to 60% in power bi in my opinion.
Karen
July 17, 2023
So interesting, it could be better, if there are additional material to download and practice while the expositor explain.
Alexander
June 30, 2023
Honestly I didnt knew it was such a in depth course but im glad i took it, this will be very usefull.
Kevin
June 7, 2023
The footage shoot be edited down a bit more. Not everything I would have liked to see was included in the course.
Pablo
May 12, 2023
In some lectures the explanation was a little messy. The whole idea was good, but sometime was confusing follow the lessons. The closure of the course was somewhat abrupt. It is definitely not a course for beginners since much knowledge is previously known. But if you want to improve your knowledge in Power BI, I think is a good option to practice your skills.
Akash
May 11, 2023
This is very well designed course each and every aspect is very smartly in easy anyone can be understand the thing if he is ready to go with content and Vedio. Awesome !!!
Foanoita
November 12, 2022
Your pronounciation make my life like in hell....sorry to say this....very difficult to understand, seriously I'm struggling to understand....
Sheperd
September 18, 2022
I'm a beginner and this course was really simple to follow and well detailed - It touched on formulas you'd normally need and that's pretty helpful.
Gabriela
September 7, 2022
Me parece interesante como enseñan el paso a paso para poder trabajar con Power BI y, cómo esta herramienta se puede poner en la práctica rapidamente.
ZDENKA
May 24, 2022
Great, but Power Query Editor at least basic knowledge is big advantage, I'd say (far from "nice to have")
Michael
May 20, 2022
A huge amount of information I felt the dashboards should have been shown sooner. The last section 5-19 had garbled audio and could not be understood.
Clark
November 24, 2021
To understand business information gives you the the right tools to upscale business potential and turn them into profit.
Fadeke
October 20, 2021
I have previously taken a physical class on power BI and this is just a good way to let it all sink in further

Coupons

DateDiscountStatus
3/21/2021100% OFF
expired
8/30/2021100% OFF
expired

Charts

Price

Business Intelligence with Power BI Desktop - Price chart

Rating

Business Intelligence with Power BI Desktop - Ratings chart

Enrollment distribution

Business Intelligence with Power BI Desktop - Distribution chart
3901012
udemy ID
3/9/2021
course created date
3/20/2021
course indexed date
Bot
course submited by