Power Pivoting: Microsoft Power BI for Career Changers

Power Pivoting: Microsoft Power BI for Career Changers, available at $84.99, has an average rating of 4.12, with 74 lectures, based on 76 reviews, and has 599 subscribers.

You will learn about 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 This course is ideal for individuals who are 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 or In addition to Power BI curriculum, this course also includes videos oriented towards helping career changers understand business intelligence roles, resumes, interviews, and more It is particularly useful 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 or In addition to Power BI curriculum, this course also includes videos oriented towards helping career changers understand business intelligence roles, resumes, interviews, and more.

Enroll now: Power Pivoting: Microsoft Power BI for Career Changers

Summary

Title: Power Pivoting: Microsoft Power BI for Career Changers

Price: $84.99

Average Rating: 4.12

Number of Lectures: 74

Number of Published Lectures: 74

Number of Curriculum Items: 74

Number of Published Curriculum Objects: 74

Original Price: $24.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Instructor & Topic Introduction

Lecture 1: Instructor & Topic Introduction

Chapter 2: BI 101: Introduction to Business Intelligence

Lecture 1: Part 1: Introduction to Business Intelligence

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

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

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

Chapter 3: BI 101: The Business Intelligence Career Toolkit

Lecture 1: The Business Intelligence Career Toolkit

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

Chapter 4: BI 101: Introduction To Microsoft Power BI

Lecture 1: Introduction to Microsoft Power BI

Lecture 2: Walkthrough of a Microsoft Power BI Report Example

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

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

Lecture 1: Transforming Data with the Power Query Editor

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

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

Chapter 6: Data Modeling 101: Data Modeling Concepts

Lecture 1: Data Modeling Concepts with the Power Query Editor

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

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

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

Lecture 1: Choosing the Right Data Visual

Lecture 2: Tutorial: Bar Charts

Lecture 3: Tutorial: Line Charts

Lecture 4: Tutorial: Area Charts

Lecture 5: Tutorial: Donut Charts & Cards

Lecture 6: Tutorial: Maps

Lecture 7: Tutorial: Tables & Matrices

Lecture 8: Tutorial: Scatter Plots

Lecture 9: Bonus Tutorial: Slicers

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

Lecture 1: Design Techniques for Power BI

Lecture 2: Introduction to Data Storytelling

Lecture 3: Tutorial: Applying Gestalt Techniques

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

Lecture 1: Applying Design Techniques to Data Visualization in Power BI

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

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

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

Lecture 1: Building Power BI Tools for Interactivity

Lecture 2: Tutorial: Deploying Buttons in Power BI

Lecture 3: Tutorial: Introduction to Power BI Bookmarks

Lecture 4: Clarification: Navigating Bookmark Settings

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

Lecture 6: Tutorial: Get Drilling with Drill-Through Pages

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

Lecture 1: The One About DAX

Lecture 2: Tutorial: Basic Measures

Lecture 3: Tutorial: Filter Functions

Lecture 4: Tutorial: Logical Functions

Lecture 5: Tutorial: Calculated Columns

Lecture 6: Tutorial: Text Functions

Lecture 7: Tutorial: Date Functions

Lecture 8: Tutorial: Time-Series Analysis Part 1

Lecture 9: Tutorial: Time-Series Analysis Part 2

Lecture 10: Tutorial: Advanced Aggregations

Lecture 11: Tutorial: Quick Measures

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

Lecture 1: Introduction

Lecture 2: Smart Visuals: Key Influencers

Lecture 3: Smart Visuals: Decomposition Tree

Lecture 4: Smart Visuals: Q&A Visual

Lecture 5: Smart Visuals: Smart Narrative

Lecture 6: Design Technique: Building a Slicer Panel

Lecture 7: Design Technique: Understanding Disconnected Slicers

Lecture 8: Design Technique: Field Parameters

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

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

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

Lecture 1: Publishing to the Power BI Service

Lecture 2: Tutorial: Walkthrough of the Power BI Service

Lecture 3: Career Topic: Preparing for the BI Interview

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

Lecture 1: Toy Company Sales Data Overview

Lecture 2: Designing Our Layout

Lecture 3: Importing Our Color Theme

Lecture 4: Modeling the Toy Company Sales Datasets

Lecture 5: Handling Background Images

Lecture 6: Building Our DAX Measure Tables

Lecture 7: Writing our DAX Sales Performance Measures

Lecture 8: Formatting Our Sales Performance Page

Lecture 9: Building a Product Performance Page

Lecture 10: Building a Store Performance Page

Lecture 11: Projecting Sales Performance Against an Annual Target

Chapter 15: Course Summary & Next Steps

Lecture 1: Course Summary & Wrap-Up

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

Instructors

Sean Chandler
BI Lead @ Humana & BI Instructor on Udemy and Sweatpants BI

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 5 votes
4 stars: 25 votes
5 stars: 43 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu