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

4.68 (48 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
411
students
29 hours
content
Apr 2023
last update
$84.99
regular price

What you will 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

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.

Content

Instructor & Topic Introduction

Instructor & Topic Introduction

BI 101: Introduction to Business Intelligence

Part 1: Introduction to Business Intelligence
Part 2: What Does a BI Professional Actually Do?
Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 1)
Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 2)

BI 101: The Business Intelligence Career Toolkit

The Business Intelligence Career Toolkit
Career Topic: What Makes a Great BI Resume?

BI 101: Introduction To Microsoft Power BI

Introduction to Microsoft Power BI
Walkthrough of a Microsoft Power BI Report Example
Career Topic: Let's Talk About Business Intelligence Careers

Data Modeling 101: Transforming Data with the Power Query Editor

Transforming Data with the Power Query Editor
Tutorial: Applying Power Query Editor Transformations to a Dataset
Tutorial: Building a Date Table with the Power Query Editor

Data Modeling 101: Data Modeling Concepts

Data Modeling Concepts with the Power Query Editor
Tutorial: Modeling an HR Dataset into a Star Schema
Career Topic: What Makes a Great Power BI Portfolio?

Front-End BI Design 101: Data Visualization 101

Choosing the Right Data Visual
Tutorial: Bar Charts
Tutorial: Line Charts
Tutorial: Area Charts
Tutorial: Donut Charts & Cards
Tutorial: Maps
Tutorial: Tables & Matrices
Tutorial: Scatter Plots
Bonus Tutorial: Slicers

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

Design Techniques for Power BI
Introduction to Data Storytelling
Tutorial: Applying Gestalt Techniques

Front-End BI Design 101: Data Visualization 102

Applying Design Techniques to Data Visualization in Power BI
Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 1)
Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 2)

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

Building Power BI Tools for Interactivity
Tutorial: Deploying Buttons in Power BI
Tutorial: Introduction to Power BI Bookmarks
Clarification: Navigating Bookmark Settings
Tutorial: Unlocking the Magic of Hovering with Tooltip Report Pages
Tutorial: Get Drilling with Drill-Through Pages

Intermediate Topics: Data Analysis Expression (DAX)

The One About DAX
Tutorial: Basic Measures
Tutorial: Filter Functions
Tutorial: Logical Functions
Tutorial: Calculated Columns
Tutorial: Text Functions
Tutorial: Date Functions
Tutorial: Time-Series Analysis Part 1
Tutorial: Time-Series Analysis Part 2
Tutorial: Advanced Aggregations
Tutorial: Quick Measures

Intermediate Topics: Smart Visuals and Intermediate Design Techniques

Introduction
Smart Visuals: Key Influencers
Smart Visuals: Decomposition Tree
Smart Visuals: Q&A Visual
Smart Visuals: Smart Narrative
Design Technique: Building a Slicer Panel
Design Technique: Understanding Disconnected Slicers
Design Technique: Field Parameters
Design Technique: BYOB (Build Your Own Buttons)
Design Technique: Building a Data Sandbox for Your Users

Applying Power BI: Publishing Reports to the Power BI Service

Publishing to the Power BI Service
Tutorial: Walkthrough of the Power BI Service
Career Topic: Preparing for the BI Interview

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

Toy Company Sales Data Overview
Designing Our Layout
Importing Our Color Theme
Modeling the Toy Company Sales Datasets
Handling Background Images
Building Our DAX Measure Tables
Writing our DAX Sales Performance Measures
Formatting Our Sales Performance Page
Building a Product Performance Page
Building a Store Performance Page
Projecting Sales Performance Against an Annual Target

Course Summary & Next Steps

Course Summary & Wrap-Up
Continuing Your Journey: The Microsoft Power Platform & Azure Synapse Analytics

Screenshots

Power Pivoting:  Microsoft Power BI for Career Changers - Screenshot_01Power Pivoting:  Microsoft Power BI for Career Changers - Screenshot_02Power Pivoting:  Microsoft Power BI for Career Changers - Screenshot_03Power Pivoting:  Microsoft Power BI for Career Changers - Screenshot_04

Reviews

Leo
May 11, 2023
Sean Does a great job in explaining Power BI and it capabilities. He starts of with the basics but builds up to an intermediate level and in some cases more advanced levels. I would recommended the course for sure.

Charts

Price

Power Pivoting:  Microsoft Power BI for Career Changers - Price chart

Rating

Power Pivoting:  Microsoft Power BI for Career Changers - Ratings chart

Enrollment distribution

Power Pivoting:  Microsoft Power BI for Career Changers - Distribution chart
5276130
udemy ID
4/16/2023
course created date
5/26/2023
course indexed date
Bot
course submited by