Microsoft Power BI Desktop Masterclass [2023 EDITION]

Focused View

Andreas Exadaktylos

6:49:18

65 View

1. Getting Started with Power BI Course

1. Introduction.mp4

03:39

2. Important Notes for New Students.html

3.1 Project Files.zip

3. Download Course Resources.html

4. Setting Expectations.mp4

03:08

2. Introducing Power BI

1. A Tour of Power BI.mp4

04:33

2. Microsoft Power BI Tools.mp4

03:00

3. Install Power BI Desktop.mp4

05:24

4. Launch Power BI Desktop.mp4

03:17

5. Introducing Power BI.html

3. Power BI Data Sources

1. Introduction.mp4

03:08

2.1 median age years.xlsx

2. Getting Data from Excel file.mp4

04:05

3.1 gdp per capita yearly growth.csv

3. Getting Data from csv file.mp4

03:38

4.1 List of countries by GDP (PPP).html

4. Connect to a Web Data Source.mp4

02:45

5. Power BI Data Sources.html

4. Design Your First Dashboard with Power BI

1. Introduction.mp4

01:50

2.1 EmployeeData.xlsx

2. Getting your Data.mp4

03:28

3. Getting familiar with the Power BI Interface.mp4

03:37

4. Adding Stacked Column Chart & Pie Chart.mp4

08:00

5. Adding Interactions with Visuals.mp4

14:08

6. Line Charts & Drill Down.mp4

08:43

7.1 gettingstarted final v2.zip

7.2 gettingstarted final.zip

7. Matrix & Card Titles.mp4

15:42

5. Power Query Transforming & Shaping Data

1.1 mygdp.zip

1. Using the Power Query Editor.mp4

09:32

2. Reducing Rows & Extracting Data.mp4

04:54

3. Filtering, Setting Data Type and Replacing Values.mp4

07:56

4. Unpivoting Columns.mp4

02:53

5. Transforming Columns.mp4

04:04

6.1 rank state 2023 population.html

6. PROJECT US Population Data Analysis with Power BI Part 1.mp4

07:04

7. PROJECT US Population Data Analysis with Power BI Part 2.mp4

12:36

8. Power Query Transforming & Shaping Data.html

6. Power Query Combining & Merging Data

1.1 Continents.xlsx

1.2 GrowthRate.xlsx

1. Combining Multiple Tables.mp4

09:05

2. Appending Data to a Single Query.mp4

04:15

3. Index Column & Cleaning Data.mp4

04:06

4. Model Relationships.mp4

05:23

5.1 all countries.zip

5. Merging Data.mp4

07:02

6.1 coffeechain.zip

6. PROJECT Create a Sales Dashboard Part1.mp4

14:32

7.1 coffeechain final.zip

7. PROJECT Create a Sales Dashboard Part2.mp4

10:40

8. Power Query Combining & Merging Data.html

7. Reports, Visualizations, Filters and Q&A

1.1 all countries.zip

1. The Report View.mp4

05:41

2. Format Visualizations.mp4

03:49

3. Cards, Tables and Matrix.mp4

06:00

4. Conditional Formatting.mp4

03:17

5. Title Formatting.mp4

03:18

6. Using Slicers.mp4

05:58

7. Filter Reports and Pages.mp4

04:11

8. Q&A Create Visuals by Typing a Normal Sentence.mp4

10:51

9. Publish from Power BI Desktop.mp4

02:32

10. Reports, Visualizations, Filters and Q&A.html

8. Data Model Tour

1. Data Model Section Overview.mp4

03:09

2. The Basics of Data Modeling.mp4

03:36

3. Getting Data & Setting up the Data Model.mp4

01:49

4. Relationships.mp4

03:20

5. Data Model Tour.html

9. DAX Functions

1. Create your first Measure using SUM Function.mp4

03:36

2. DAX syntax.mp4

02:00

3. Add a Matrix using Measures.mp4

02:57

4. Count Products with COUNTA and COUNTROWS.mp4

03:43

5. Edit or Delete Measures.mp4

05:13

6. Find Empty Fields with COUNTBLANK.mp4

02:05

7. DISTINCTCOUNT Function.mp4

03:18

8. PROJECT Build DAX understanding (Part1).mp4

13:18

9. PROJECT Build DAX understanding (Part2).mp4

05:52

10. DAX Functions.html

10. Calculated Columns & Measures

1. Add a Calculated Column.mp4

04:40

2. Explicit vs. Implicit Measures.mp4

02:31

3. Summarization Methods.mp4

03:54

4. DIVIDE Function.mp4

04:41

5. SUMX Function.mp4

04:20

6. Date & Time DAX Functions.mp4

04:58

7. PROJECT Build DAX understanding (Part3).mp4

07:27

8. PROJECT Build DAX understanding (Part4).mp4

06:35

9. PROJECT Build DAX understanding (Part5).mp4

03:29

10. PROJECT Build DAX understanding (Part6).mp4

07:13

11. Calculated Columns & Measures.html

11. Logical & Filter Functions

1. FIND Function.mp4

02:31

2. IF Function.mp4

02:14

3. OR Function.mp4

03:18

4. The Powerful CALCULATE Function.mp4

03:45

5. SWITCH Function.mp4

02:54

6. DEMO Story-telling with Power BI Part1.mp4

07:44

7. DEMO Story-telling with Power BI Part2.mp4

14:08

8. Logical & Filter Functions.html

12. Milestone Project Create a Budget vs Actual Dashboard

1. Introduction.mp4

07:57

2. Designing the Relationships between Tables.mp4

05:11

3. Loading our Data into Power Query Editor.mp4

04:50

4. Data Cleanup Process.mp4

09:18

Description

Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query

What You'll Learn?

Build professional-quality business intelligence reports from a best selling Udemy instructor in FULL HD 1080p Video
This is a project-based course designed for students looking for a practical, hands-on, and highly engaging approach to learning Power BI Desktop
Learn how to connect and manipulate data using Power Query
Learn how to calculate anything and analyze data with Power Pivot and DAX
Learn how to tell rich, interactive, and immersive data stories through Power Bi visuals and storytelling experiences

Who is this for?

Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant

All Excel users who work with data, reports or dashboards

Enthusiastic quality professionals who are NEW to the Business Analysis and want to take their skills to the next level.

What You Need to Know?

Microsoft Power BI Desktop (free download)

Are you new to Power BI? Welcome! This Power BI course will guide you from the beginning – blank canvas – until a completed report & dashboard

No prior knowledge needed, covers Power BI end to end, while providing a wealth of practical tips for those that already know Power BI.

More details

Description
If youâ€™re a data professional or analyst looking to learn the top business intelligence platform on the market, or new to Power BI, or want to fill in some gaps in your knowledge, THIS is the course for you.
This course has been recorded for 2023 in full HD video quality, so you will learn about the latest Power BI interface.

You are not just going to learn Power BI, but you will be learning the technical skills necessary to use Power Bi.
That is, how to connect and manipulate data using Power Query, calculate anything and analyze data with Power Pivot, and tell rich, interactive, and immersive data stories through Power Bi visuals and storytelling experiences.

In this course, I will be teaching all about how to collect your data, how to analyze it, how to visualize it, and how to share your insights with the world.
My approach is designed to use Power BI at work on day one.

WHAT YOU CAN EXPECT:
When you join my course you are going to enter the Power BI fast track. You are going to learn the most important parts of a Power BI project and design your first dashboard in as short a time as possible.
You are going to install, launch, and get data into Power BI fast. Then you are going to create your first report and use Power BI at work immediately.
Once you graduate from the fast track you will level up to the expert track.
Weâ€™ll start by transforming and shaping data with Power Query, and explore profiling tools, extracting and filtering data, unpivoting, and many more. Weâ€™ll create our first project: Analyze the US population data
Next, weâ€™ll dive into combining and merging data, index column, cleaning data, and model relationships. And we are going to create our second project: a sales dashboard.
After that, weâ€™ll learn all about data modeling: cardinality, normalization, and star schemas.
With our model configured, we will start by creating measures and learning DAX functions and calculated columns.
We are going to learn Sum and Count functions, date, and time functions, logical and filter functions in three different sections. Each section has a project so you can fully understand the theory.
Finally, weâ€™ll bring our data to life with milestone projects, like this budget versus actual dashboard.

Itâ€™s time to futureproof and accelerate your career by learning Power BI.
So, if you are an analyst, data professional, or a user ready to leave the excel safe zone, then sign up today and get immediate access to high-quality video content, downloadable resources, course projects and assignments, and one-on-one expert support.

This is a project-based course designed for students looking for a practical, hands-on, and highly engaging approach to learning power BI desktop for business intelligence.
All the files that are included in the lectures, so you can follow along with me
Quizzes and Assignments so can help you reinforce key concepts and simulate real-world scenarios.
And downloadable pdf files containing course and reference materials

Make the Shift to Power BI and enroll now!
Thank you and Iâ€™ll see you inside!
Who this course is for:
Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant
All Excel users who work with data, reports or dashboards
Enthusiastic quality professionals who are NEW to the Business Analysis and want to take their skills to the next level.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Andreas Exadaktylos

Instructor's Courses

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can.I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school. I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well. I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I am a professional Forex Trader for over 5 years. I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.