Power Pivoting: Microsoft Power Bi For Career Changers

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

Requirements

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

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.

Overview

Section 1: Instructor & Topic Introduction

Lecture 1 Instructor & Topic Introduction

Section 2: BI 101: Introduction to Business Intelligence

Lecture 2 Part 1: Introduction to Business Intelligence

Lecture 3 Part 2: What Does a BI Professional Actually Do?

Lecture 4 Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 1)

Lecture 5 Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 2)

Section 3: BI 101: The Business Intelligence Career Toolkit

Lecture 6 The Business Intelligence Career Toolkit

Lecture 7 Career Topic: What Makes a Great BI Resume?

Section 4: BI 101: Introduction To Microsoft Power BI

Lecture 8 Introduction to Microsoft Power BI

Lecture 9 Walkthrough of a Microsoft Power BI Report Example

Lecture 10 Career Topic: Let's Talk About Business Intelligence Careers

Section 5: Data Modeling 101: Transforming Data with the Power Query Editor

Lecture 11 Transforming Data with the Power Query Editor

Lecture 12 Tutorial: Applying Power Query Editor Transformations to a Dataset

Lecture 13 Tutorial: Building a Date Table with the Power Query Editor

Section 6: Data Modeling 101: Data Modeling Concepts

Lecture 14 Data Modeling Concepts with the Power Query Editor

Lecture 15 Tutorial: Modeling an HR Dataset into a Star Schema

Lecture 16 Career Topic: What Makes a Great Power BI Portfolio?

Section 7: Front-End BI Design 101: Data Visualization 101

Lecture 17 Choosing the Right Data Visual

Lecture 18 Tutorial: Bar Charts

Lecture 19 Tutorial: Line Charts

Lecture 20 Tutorial: Area Charts

Lecture 21 Tutorial: Donut Charts & Cards

Lecture 22 Tutorial: Maps

Lecture 23 Tutorial: Tables & Matrices

Lecture 24 Tutorial: Scatter Plots

Lecture 25 Bonus Tutorial: Slicers

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

Lecture 26 Design Techniques for Power BI

Lecture 27 Introduction to Data Storytelling

Lecture 28 Tutorial: Applying Gestalt Techniques

Section 9: Front-End BI Design 101: Data Visualization 102

Lecture 29 Applying Design Techniques to Data Visualization in Power BI

Lecture 30 Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 1)

Lecture 31 Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 2)

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

Lecture 32 Building Power BI Tools for Interactivity

Lecture 33 Tutorial: Deploying Buttons in Power BI

Lecture 34 Tutorial: Introduction to Power BI Bookmarks

Lecture 35 Clarification: Navigating Bookmark Settings

Lecture 36 Tutorial: Unlocking the Magic of Hovering with Tooltip Report Pages

Lecture 37 Tutorial: Get Drilling with Drill-Through Pages

Section 11: Intermediate Topics: Data Analysis Expression (DAX)

Lecture 38 The One About DAX

Lecture 39 Tutorial: Basic Measures

Lecture 40 Tutorial: Filter Functions

Lecture 41 Tutorial: Logical Functions

Lecture 42 Tutorial: Calculated Columns

Lecture 43 Tutorial: Text Functions

Lecture 44 Tutorial: Date Functions

Lecture 45 Tutorial: Time-Series Analysis Part 1

Lecture 46 Tutorial: Time-Series Analysis Part 2

Lecture 47 Tutorial: Advanced Aggregations

Lecture 48 Tutorial: Quick Measures

Section 12: Intermediate Topics: Smart Visuals and Intermediate Design Techniques

Lecture 49 Introduction

Lecture 50 Smart Visuals: Key Influencers

Lecture 51 Smart Visuals: Decomposition Tree

Lecture 52 Smart Visuals: Q&A Visual

Lecture 53 Smart Visuals: Smart Narrative

Lecture 54 Design Technique: Building a Slicer Panel

Lecture 55 Design Technique: Understanding Disconnected Slicers

Lecture 56 Design Technique: Field Parameters

Lecture 57 Design Technique: BYOB (Build Your Own Buttons)

Lecture 58 Design Technique: Building a Data Sandbox for Your Users

Section 13: Applying Power BI: Publishing Reports to the Power BI Service

Lecture 59 Publishing to the Power BI Service

Lecture 60 Tutorial: Walkthrough of the Power BI Service

Lecture 61 Career Topic: Preparing for the BI Interview

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

Lecture 62 Toy Company Sales Data Overview

Lecture 63 Designing Our Layout

Lecture 64 Importing Our Color Theme

Lecture 65 Modeling the Toy Company Sales Datasets

Lecture 66 Handling Background Images

Lecture 67 Building Our DAX Measure Tables

Lecture 68 Writing our DAX Sales Performance Measures

Lecture 69 Formatting Our Sales Performance Page

Lecture 70 Building a Product Performance Page

Lecture 71 Building a Store Performance Page

Lecture 72 Projecting Sales Performance Against an Annual Target

Section 15: Course Summary & Next Steps

Lecture 73 Course Summary & Wrap-Up

Lecture 74 Continuing Your Journey: The Microsoft Power Platform & Azure Synapse Analytics

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