Power Pivoting: Microsoft Power BI for Career Changers

Focused View

Sean Chandler

28:45:29

95 View

1. Instructor & Topic Introduction

1. Instructor & Topic Introduction.mp4

32:45

2. BI 101 Introduction to Business Intelligence

1.1 150 Years of Business Intelligence A Brief History by Cristina Lago.html

1.2 Exploring the History of Business Intelligence by Paulo Limp.html

1. Part 1 Introduction to Business Intelligence.mp4

46:52

2.1 Is Business Intelligence Analyst the Right Profession for You by Nasreen Parvez.html

2. Part 2 What Does a BI Professional Actually Do.mp4

25:25

3. Career Topic Interview with BI Career Pivoter, Dr. Nina Marijanovic (Part 1).mp4

17:58

4. Career Topic Interview with BI Career Pivoter, Dr. Nina Marijanovic (Part 2).mp4

25:26

3. BI 101 The Business Intelligence Career Toolkit

1.1 How to Get More from Your BI Tools with SQL by András Novoszáth.html

1. The Business Intelligence Career Toolkit.mp4

42:56

2.1 12 BI Resume Examples - Heres What Works in 2023 by Mike McDonald.html

2. Career Topic What Makes a Great BI Resume.mp4

37:04

4. BI 101 Introduction To Microsoft Power BI

1. Introduction to Microsoft Power BI.mp4

38:20

2. Walkthrough of a Microsoft Power BI Report Example.mp4

14:59

3.1 From Zero to BI Hero Launching Your Business Intelligence Career by Kerem Gülen.html

3. Career Topic Lets Talk About Business Intelligence Careers.mp4

34:21

5. Data Modeling 101 Transforming Data with the Power Query Editor

1.1 Roches Maxim of Data Transformation by Matthew Roche.html

1. Transforming Data with the Power Query Editor.mp4

28:45

2. Tutorial Applying Power Query Editor Transformations to a Dataset.mp4

35:40

3. Tutorial Building a Date Table with the Power Query Editor.mp4

29:37

6. Data Modeling 101 Data Modeling Concepts

1.1 Data Modeling in Power BI by Obalanatosin.html

1.2 More on Data Modeling in Power BI by Obalanatosin.html

1. Data Modeling Concepts with the Power Query Editor.mp4

29:04

2.1 people data.csv

2.2 people employment history.csv

2. Tutorial Modeling an HR Dataset into a Star Schema.mp4

45:12

3. Career Topic What Makes a Great Power BI Portfolio.mp4

25:24

7. Front-End BI Design 101 Data Visualization 101

1.1 Power BI Preview Feature On-Object Interaction with Data Visuals.html

1.2 Visualizations That Really Work by Scott Berinato.html

1.3 What is Data Visualization by Midori Nediger.html

1.4 Why is Data Visualization Important by Antony Unwin.html

1. Choosing the Right Data Visual.mp4

36:36

2. Tutorial Bar Charts.mp4

19:01

3. Tutorial Line Charts.mp4

17:26

4. Tutorial Area Charts.mp4

08:23

5. Tutorial Donut Charts & Cards.mp4

13:24

6. Tutorial Maps.mp4

14:41

7. Tutorial Tables & Matrices.mp4

23:42

8. Tutorial Scatter Plots.mp4

13:11

9. Bonus Tutorial Slicers.mp4

16:11

8. Front-End BI Design 101 The Art of Designing BI Tools

1.1 Choosing a Color Palette For Your Power BI Report by Meagan Longoria.html

1.2 The Fundamentals of Understanding Color Theory by Kris Decker.html

1.3 The Power of Color in Data Visualizations by Marie Lefevre.html

1.4 The Psychology behind Data Visualization Techniques by Elena V Kazakova.html

1. Design Techniques for Power BI.mp4

37:48

2.1 Do People Really Understand Your Data Visualizations by Kiran Ajani, Elsie Lie, Cindy Xiong, Cole Nussbaumer Knaflic, William Kemper, and Steven Franconeri.html

2.2 Why is Storytelling Important in the Design Process by Saransh Sharma.html

2. Introduction to Data Storytelling.mp4

22:04

3. Tutorial Applying Gestalt Techniques.mp4

43:13

9. Front-End BI Design 101 Data Visualization 102

1.1 A Guide to the Golden Ratio for Designers by Emily Esposito.html

1.2 In Pursuit of a New Golden Ratio by Alex Kolokolov.html

1.3 Whats Visual Encoding in Data Viz and Why Is It Important by Sophie Warnes.html

1. Applying Design Techniques to Data Visualization in Power BI.mp4

32:32

2. Tutorial Enhancing a Report with Design & Data Storytelling Techniques (Part 1).mp4

39:53

3. Tutorial Enhancing a Report with Design & Data Storytelling Techniques (Part 2).mp4

43:03

10. Front-End BI Design 101 Building Power BI Tools for Interactivity

1. Building Power BI Tools for Interactivity.mp4

26:59

2. Tutorial Deploying Buttons in Power BI.mp4

18:00

3. Tutorial Introduction to Power BI Bookmarks.mp4

35:19

4. Clarification Navigating Bookmark Settings.mp4

05:45

5. Tutorial Unlocking the Magic of Hovering with Tooltip Report Pages.mp4

20:14

6. Tutorial Get Drilling with Drill-Through Pages.mp4

20:23

11. Intermediate Topics Data Analysis Expression (DAX)

1. The One About DAX.mp4

26:53

2.1 Data Analysis Expressions (DAX) Reference - Microsoft Learn.html

2.2 New DAX Functions - Microsoft Learn.html

2. Tutorial Basic Measures.mp4

21:05

3.1 DAX Filter Functions Overview - Microsoft Learn.html

3. Tutorial Filter Functions.mp4

21:38

4.1 DAX Logical Functions Overview - Microsoft Learn.html

4. Tutorial Logical Functions.mp4

17:13

5. Tutorial Calculated Columns.mp4

13:18

6.1 DAX Text Functions Overview - Microsoft Learn.html

6. Tutorial Text Functions.mp4

28:11

7.1 DAX Date & Time Functions Overview - Microsoft Learn.html

7. Tutorial Date Functions.mp4

13:10

8.1 DAX Time Intelligence Functions Overview - Microsoft Learn.html

8. Tutorial Time-Series Analysis Part 1.mp4

20:28

9. Tutorial Time-Series Analysis Part 2.mp4

31:30

10.1 DAX Aggregations Functions Overview - Microsoft Learn.html

10. Tutorial Advanced Aggregations.mp4

17:24

11. Tutorial Quick Measures.mp4

18:04

12. Intermediate Topics Smart Visuals and Intermediate Design Techniques

1. Introduction.mp4

09:08

2. Smart Visuals Key Influencers.mp4

13:18

3. Smart Visuals Decomposition Tree.mp4

10:37

4. Smart Visuals Q&A Visual.mp4

15:25

5. Smart Visuals Smart Narrative.mp4

10:52

6. Design Technique Building a Slicer Panel.mp4

21:11

7. Design Technique Understanding Disconnected Slicers.mp4

12:34

8. Design Technique Field Parameters.mp4

11:28

9. Design Technique BYOB (Build Your Own Buttons).mp4

07:03

10. Design Technique Building a Data Sandbox for Your Users.mp4

11:52

13. Applying Power BI Publishing Reports to the Power BI Service

1. Publishing to the Power BI Service.mp4

38:11

2. Tutorial Walkthrough of the Power BI Service.mp4

30:50

3.1 13 Business Intelligence Analyst Interview Questions and Answers by Corinne Bernstein.html

3. Career Topic Preparing for the BI Interview.mp4

34:54

14. Applying Power BI Full-Length Tutorial (Toy Company Sales Dataset)

1.1 Toy Company Sales Datasets.zip

1. Toy Company Sales Data Overview.mp4

04:19

2. Designing Our Layout.mp4

09:34

3. Importing Our Color Theme.mp4

05:12

4. Modeling the Toy Company Sales Datasets.mp4

12:12

5. Handling Background Images.mp4

03:12

6. Building Our DAX Measure Tables.mp4

06:11

7. Writing our DAX Sales Performance Measures.mp4

23:01

8. Formatting Our Sales Performance Page.mp4

23:10

9. Building a Product Performance Page.mp4

21:49

10. Building a Store Performance Page.mp4

29:07

11.1 finished report.zip

11. Projecting Sales Performance Against an Annual Target.mp4

44:27

15. Course Summary & Next Steps

1. Course Summary & Wrap-Up.mp4

38:50

2. Continuing Your Journey The Microsoft Power Platform & Azure Synapse Analytics.mp4

30:32

Description

Explore Power BI with tons of tutorials on data modeling, DAX, design, visualization, storytelling & BI career guidance

What You'll Learn?

Learn about what business intelligence professionals do and how their skills complement & overlap with other roles at data-driven companies
Learn how to utilize the Power Query Editor to clean, transform, and model data
Learn how to build and format a variety of different Power BI data visuals
Learn a variety of core design principles such as color theory, Gestalt design techniques, and visual encoding to design more visually impactful data tools
Learn how to make the user experience and interactivity of your tools more effective by utilizing bookmarks, tooltip pages, and drill-through pages
Learn how to write DAX measures utilizing a variety of common functions and apply them to different business scenarios including time-series data
Learn about AI-enabled "smart visuals" that combine the data visualization capabilities of Power BI with data science techniques
Enjoy a complete walkthrough of a Power BI from start to finish, beginning with the ingestion & modeling of data and ending with designing an amazing report

Who is this for?

This course is designed with career pivoters in mind but is designed for anyone who is looking for broad exposure to a wide range of Power BI and business intelligence concepts

In addition to Power BI curriculum, this course also includes videos oriented towards helping career changers understand business intelligence roles, resumes, interviews, and more

What You Need to Know?

There are no requirements for taking this course but it is highly encouraged that you download Power BI Desktop beforehand if you wish to following along with some of the content

More details

Description
In this course, get ready to kick off your business intelligence career with a variety of focused content built to equip you with the skills you will need to break into a rewarding and competitive BI industry. Yes, it's yet another Intro to Power BI courseâ€”but this class will also focus on enhancing your burgeoning Power BI skills with a variety of other areas that are sure to elevate your dashboarding & reporting acumen beyond simple data charts and tables.
Power Pivoting combines in-depth Power BI tutorials with business intelligence career discussion videos, demonstrations of impactful design and data storytelling techniques, intermediate-level tips and tricks for wowing your business users, almost a dozen hands-on DAX demonstrations, and a full-length Power BI walkthrough that will take you all the way from importing your data to building a tool that's ready to publish.
If you are considering getting your hands dirty with data and transitioning from a non-data career into one where transforming data, calculating metrics, and telling complex data stories through simple visualizations are just another day in the office, this is the course for you. The road to a successful BI career transition can be a long and difficult one; this class will walk you through everything you need to know from a Power BI perspective alongside an instructor who went through that transition himself and never looked back.
Who this course is for:
This course is designed with career pivoters in mind but is designed for anyone who is looking for broad exposure to a wide range of Power BI and business intelligence concepts
In addition to Power BI curriculum, this course also includes videos oriented towards helping career changers understand business intelligence roles, resumes, interviews, and more

User Reviews

Rating

average 0

Total votes0

Focused display

Sean Chandler has been working professionally in business intelligence since 2014, specializing in creating solutions of all shapes and sizes on the Microsoft Power Platform. In 2019, he joined Humana, where he currently works as a Business Intelligence Lead building a team focused on advancing clinical analytics for one of the US' largest health insurance providers.As a BI professional, Sean has delivered hundreds of Power BI projects ranging from small ad hoc solutions to enormous tools integrating tens of millions of rows of complex business data. He has won multiple awards for his BI work and has even been featured as a presenter on Microsoft Mechanics to discuss his builds. Over the past several years, his Power BI expertise has allowed him to teach a variety of courses on designing effective solutions and deliver multiple presentations to hundreds of aspiring BI professionalsSean's teaching experience spans more than a decade, beginning in 2010 when he spent more than a year teaching ESL in South Korea. Since then, Sean has helped prepare dozens of Kentucky high school students for college entrance exams and delivered online curriculum & learning content for multiple platforms focused on helping others become better Power BI developers.A proud Kentuckian, Sean is a graduate of Centre College and holds a MA in International Diplomacy and MBA from the University of Kentucky. In his spare time, Sean enjoys yoga, weightlifting, gaming, and spending quality time with his spouse. He also loves to travel, particularly to favorite destinations like Croatia, Bosnia, South Korea, and Switzerland. He currently resides in Louisville, Kentucky.

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.