Microsoft Power Bi Up Running With Power Bi Desktop

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructor

Last updated 2022-01-10 | 4.6

- Build professional-quality business intelligence reports from the ground up
- Blend and transform raw data into beautiful interactive dashboards
- Design and implement the same B.I. tools used by professional analysts and data scientists

What you'll learn

Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer

* Requirements

* Microsoft Power BI Desktop (free download)
* This course is designed for PC/Windows users (currently not available for Mac)
* Experience with Excel Power Query
* Power Pivot & DAX is a plus
* but not required

Description

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place.

Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch -- all for free.


THE COURSE PROJECT:

In this course, you'll be playing the role of Lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? To design and deliver a professional-quality, end-to-end business intelligence solution, armed only with Power BI and a handful of raw csv files.

But don't worry, I'll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way. We'll follow a steady, systematic progression through the Power BI workflow, and break down our project into FOUR KEY OBJECTIVES:


POWER BI OBJECTIVE #1Connect & Transform the Raw Data

  • Intro to the Power BI Query Editor

  • Types of Power BI Data Connectors

  • Basic Table Transformations

  • Text, Number & Date Tools

  • Index & Conditional Columns

  • Grouping & Aggregating Data

  • Pivoting & Unpivoting

  • Modifying, Merging & Appending Queries

  • Connecting to Folders

  • Defining Hierarchies & Categories

  • Query Editing & Power BI Best Practices


POWER BI OBJECTIVE #2: Build a Relational Data Model

  • Intro to Database Normalization

  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables

  • Creating Power BI Table Relationships

  • "Star" vs. "Snowflake" Schemas

  • Active vs. Inactive Relationships

  • Relationship Cardinality

  • Connecting Multiple Data Tables

  • Filtering & Cross-Filtering

  • Hiding Fields from the Power BI Report View

  • Data Modeling & Power BI best Practices


POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

  • Intro to Data Analysis Expressions (DAX)

  • Calculated Columns vs. Measures

  • Row Context vs. Filter Context in Power BI

  • DAX Syntax & Operators

  • Common Power BI Functions

  • Basic Date & Time Formulas

  • Logical & Conditional Statements

  • Text, Math & Stats Functions

  • Joining Data with RELATED

  • CALCULATE, ALL & FILTER Functions

  • DAX Iterators (SUMX, AVERAGEX)

  • Time Intelligence Formulas

  • DAX & Power BI Best Practices


POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

  • Intro to the Power BI Report View

  • Adding Basic Charts to Power BI Reports

  • Formatting & Filtering Options

  • Matrix Visuals

  • Slicers & Timelines

  • Cards & KPIs

  • Power BI Map Visuals (Basic, Fill, ArcGIS)

  • Treemaps, Lines, Areas & Gauges

  • Editing Report interactions

  • Adding Drillthrough Filters

  • Linking to Report Bookmarks

  • Using "What-If" Parameters

  • Managing & Viewing Roles

  • PREVIEW: Publishing to Power BI Service

  • Power BI Data Viz Best Practices


By the end of the Adventure Works project, not only will you have developed an entire business intelligence tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.


For those looking for more opportunities to test their Power BI skills, I've also included an additional set of project files for a bonus Final Project. This is your chance to showcase all of the skills you've developed throughout the course, and apply them to a brand new data set from Maven Market, a global supermarket chain.


Whether you're a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI ROCK STAR -- guaranteed.


Join today and get immediate, lifetime access to the following:

  • 100+ page Power BI ebook

  • Downloadable Power BI project files

  • Homework exercises & quizzes

  • 1-on-1 expert support

  • Course Q&A forum

  • 30-day money-back guarantee


See you in there!

-Chris (Founder, Maven Analytics)


__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


Hear why this is one of the TOP-RATED Power BI courses on Udemy:

"Instructor is top notch - moves at the right pace and keeps it interesting. Best Power BI course on Udemy!"

-Adam Edwards

"Resources are awesome. Presenter is brilliant. I found this course more useful than the offical Power BI course from Microsoft. Things are easy to follow, and presentations are of high quality."

-Jacobus M.

"Chris is a skilled communicator and does a great job of explaining a complex tool like Microsoft Power BI. His 'pro-tips' are great for new user productivity and gaining a sense of the big picture, and I value his best practices on building and managing Power BI queries and reports. I'm feeling much more confident to dig in and use Power BI on my own projects!"

-Bill Jerrow

Who this course is for:

  • Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Aspiring data professionals looking to master the #1 business intelligence tool on the market
  • Students who want a comprehensive, engaging, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence

Course content

9 sections • 122 lectures

Course Structure & Outline Preview 01:43

Walkthrough to cover exactly how the course is structured and what you need to know before diving into Microsoft Power BI Desktop.

READ ME: Important Notes for New Students Preview 02:13

DOWNLOAD: Course Resources Preview 00:25

Introducing the Course Project Preview 03:02

In this lecture, I'll introduce the course project, where you've just been hired to deliver and end-to-end BI solution, and provide a sneak preview of the final project.

Setting Expectations Preview 02:21

In the last Getting Started section, I'll cover exactly what to expect (and what NOT to expect) from this course. 

Introduction Preview 00:26

Meet Microsoft Power BI Desktop Preview 05:30

Meet Microsoft Power BI: one of the industry's top self-service business intelligence platforms. In this lecture we'll discuss the key benefits that make this such a game changing product and discuss the ways Power BI and Power Excel are similar and different.

Downloading Power BI & Adjusting Settings Preview 04:05

In this section we'll cover how to download Power BI Desktop and configure options and regional settings to make sure you're working with the same Power BI setup.

IMPORTANT: Regional Settings Preview 01:50

Exploring the Power BI Desktop Interface & Workflow Preview 02:34

In this lecture we'll introduce the three core views within Power BI Desktop, the Report view, the Data view, and the Relationship view, and I'll cover how these core views fit into the typical business intelligence workflow.

Helpful Power BI Resources Preview 01:44

In this section I'll discuss some of the resources that I find most helpful, like the "Help" section in Power BI Desktop, the Microsoft Power BI blog, and the Microsoft Power BI YouTube channel.

UPDATE: New Power BI Ribbon Preview 07:15

In this lecture we'll introduce the new Power BI Desktop ribbon interface, introduced as a preview feature in November 2019 and rolled out to general availability in early 2020.

QUIZ: Introducing Microsoft Power BI Desktop

Introduction Preview 00:30

Types of Data Connectors in Power BI Desktop Preview 03:53

In this lecture we'll kick things off and cover the robust data connection library where you can connect to just about any data source. I'll highlight some of the available connectors and walk through the Get Data dialogue box.

The Power BI Query Editor (aka Power Query) Preview 04:28

The Query Editor is your cockpit for loading and transforming raw data in Power BI Desktop. In this lecture we'll take a tour of the tools and features that will help us transform and shape our data.

Demo: Basic Table Transformations in Power BI Preview 10:03

In this lecture we'll learn about some of the most important table transformation tools and options in Power BI Desktop, including promote header row, duplicate, move, and rename columns, and keep or remove rows.

Power BI Demo: Working with Text Tools Preview 14:54

In this lecture we'll cover Power BI Desktop tools designed specifically to work with text, including split column, format column, or trim and clean.

Power BI Demo: Working with Numerical Values Preview 08:37

In this lecture we'll review Power BI Desktop tools designed specifically to work with numbers or data fields, such as returning aggregated values like sums or averages, creating new calculated columns, rounding numbers, etc.

Power BI Demo: Working with Date & Time Tools Preview 08:53

In this lecture we'll cover Power BI Desktop tools specifically designed to work with date and time fields, like calculating months, weeks, weekdays, quarters, etc.

PRO TIP: Creating a Rolling Calendar in Power BI Desktop Preview 07:08

In this lecture I'll quickly demonstrate how you can use custom M queries to build a rolling calendar in Power BI Desktop that will always update with dates through the current day.

Power BI Demo: Generating Index & Conditional Columns Preview 08:30

This lecture will show you how to create new unique identifiers using index columns in Power BI, as well as calculated fields based on custom user-defined conditions.

Power BI Demo: Grouping & Aggregating Records Preview 07:33

In this lecture we'll practice using "Group By" tools in the Transform tab of the Query Editor to aggregate or roll up raw data to new levels of granularity.

Power BI Demo: Pivoting & Unpivoting Data Preview 08:04

This lecture demystifies the concept of "pivoting" or "unpivoting" a data table. I'll show you exactly what these tools do, and demonstrate with a sample table in Power BI.

Merging Queries in Power BI Desktop Preview 06:41

This lecture demonstrates how to merge queries together within Power BI Desktop to pull fields from one table into another based on common fields or "keys".

Appending Queries in Power BI Desktop Preview 06:29

In this lecture, I'll show you how to append or "stack" data from multiple Power BI queries that share the same column structure and data types.

PRO TIP: Appending Files from a Folder Preview 07:38

In this lecture, I'll show you a more efficient and scalable method to append or "stack" data from multiple Power BI data sources sotred within a single folder.

Configuring Power BI Data Source Settings Preview 05:05

The Data Source Settings in the Query Editor allows you to manage data source connections and permissions.

Configuring Power BI Query Refresh Settings Preview 03:06

In this lecture, we'll cover how to customize your Query Refresh settings as well as refresh all queries.

Additional Data Types & Categories in Power BI Preview 07:19

In this lecture, we'll explore the Power BI "Modeling" tab in the Data view, where I'll show you how to edit field properties to define specific categories.

Defining Hierarchies in Power BI Desktop Preview 04:35

In this lecture we'll practice creating hierarchies in our Power BI model, which are groups of nested columns that reflect multiple levels of granularity (such as country, state, and city).

PRO TIP: Importing Models from Excel to Power BI Preview 05:40

In the PRO TIP lecture, I'll show you how to import a fully built data model from Excel into Power BI Desktop.

Power BI Data Connection Best Practices Preview 02:09

In this lecture, I'll share some of the best practices, like organizing your datasets and establishing a folder/file structure, when connecting and shaping data in Power BI Desktop.

QUIZ: Connecting & Shaping Data with Power BI Desktop

HOMEWORK: Connecting & Shaping Data with Power BI Desktop Preview 01:10

HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop Preview 12:36

Introduction Preview 00:19

What is a "Data Model"? Preview 05:17

A data model is a group of tables that are connect by a common field or "key". In this lecture, I'll explain the core concept of joining Power BI datasets together with common keys.

Principles of Database Normalization Preview 04:07

This lecture covers one of the most important topics in the course: database normalization. Normalization is all about structuring tables in a way where each table serves a distinct and specific purpose.

Understanding Data Tables vs. Lookup Tables Preview 07:25

In this lecture we'll compare and contrast the two primary types of tables in a Power BI model: data (or "fact") tables and lookup (or "dimension") tables.

Understanding Table Relationships vs. Merged Tables Preview 02:31

In this lecture I'll explain the difference between manually merging fields from multiple tables and creating relationships to connect them using the Power BI data model (which is much more efficient!)

Creating Table Relationships in Power BI Desktop Preview 04:34

In this lecture we'll use Power BI Desktop to create our first table relationships.

"Snowflake" Schemas in Power BI Preview 03:09

In this lecture I'll cover "Snowflake" schemas, which are essentially dimension tables which are "chained" together through common keys.

Managing & Editing Table Relationships in Power BI Desktop Preview 02:44

The Manage & Edit Relationships dialogue allows you to edit, add, or delete table relationships within Power BI Desktop.

Managing Active vs. Inactive Relationships Preview 02:45

In this lecture I'll demonstrate how to create multiple relationships against the same key, and how to determine which relationship is active vs. inactive in Power BI Desktop.

Understanding Relationship Cardinality Preview 05:08

This lecture explores the concept of cardinality, and demonstrates the differences between 1-to-1, 1-to-many, and many-to-many relationships. I'll also show you exactly why 1-to-many relationships are critical when it comes to building normalized data models in Power BI Desktop.

Connecting Multiple Data Tables in Power BI Desktop Preview 08:26

In this lecture I'll demonstrate exactly how to build a Power BI model containing multiple data tables. Rather than connect those tables together, we'll connect them indirectly via relationships to shared lookup tables.

Understanding Filter Flow Preview 06:33

This lecture demonstrates the importance of filter direction within a Power BI data model, and explains the concept of filter context flowing "downstream" to related tables.

Two-Way Filters in Power BI Desktop (USE WITH CAUTION!) Preview 13:16

In this lecture I'll cover examples of how, and when, to use two-way filters (bi-directional filtering) in Power BI Desktop. This technique allows filter context to flow from dimension to fact tables and from dimension to fact tables.

Hiding Fields from the Power BI Report View Preview 04:15

In this lecture, I'll cover how, and when, to hide fields from your Power BI Report view.

UPDATE: New Power BI Desktop "Model" View Preview 08:32

In this lesson I'll walk you through the updated "Model" view in Power BI Desktop, which includes tools to quickly edit model properties, organize fields, and create custom views based on subsets of your full data model.

Power BI Data Model Best Practices Preview 01:34

In this lecture I'll outline my personal favorite Power BI data modeling best practices.

QUIZ: Creating Table Relationships & Data Models in Power BI

HOMEWORK: Creating Table Relationships & Data Models in Power BI Preview 01:34

HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI Preview 14:09

Introduction Preview 00:32

Meet Data Analysis Expressions (DAX) Preview 01:03

Meet DAX, or Data Analysis Expressions, the formula language that drives Power BI.

Intro to DAX Calculated Columns Preview 07:33

In this lecture I'll introduce the first method of using DAX to create new calculated fields: calculated columns. I'll showcase some "good" and "bad" examples, and demonstrate how they can be created within the data model window.

Intro to DAX Measures Preview 02:51

In this lecture I'll introduce the second method of using DAX to create new calculated values: measures. I'll explain how they can be used and why they are so powerful in Power BI Desktop.

RECAP: Calculated Columns vs. DAX Measures Preview 01:34

In this lecture, I'll create a little "cheat-sheet" by recapping the difference between Calculated Columns and Measures and outline how and when they're used.

Adding Columns & DAX Measures in Power BI Desktop Preview 03:12

In this lecture, I'll cover two options for adding columns and measures in Power BI, and highlight the important differences between the two options.

Implicit vs. Explicit DAX Measures Preview 06:27

In this lecture, I'll cover the difference between implicit measures, which are measures that are automatically created by Power BI Desktop when you drag raw numerical fields into the visuals pane, and explicit measures, which are created by entering DAX functions.

Filter Context Examples in Power BI Preview 08:07

In this lecture I'll cover filter context, which allows us to understand exactly how each "cell" is being calculated, and how it impacts DAX measures. 

Step-by-Step DAX Measure Calculation Preview 02:39

In this lecture, I'll guide you through the actual steps that Power BI Desktop takes behind the scenes to calculate each DAX measure. This demonstration will be critical to troubleshooting calculation errors and understanding precisely how measures work within Power BI.

Understanding DAX Syntax & Operators Preview 03:49

In this lecture I'll walk through DAX formula syntax and outline the most common types of operators.

Common DAX Function Categories Preview 03:16

In this lecture I'll outline some of the most common DAX categories in Power BI (Math & Stats, Logical, Text, Filter, and Date & Time), as well as example functions.

DAX Demo: Basic Date & Time Functions Preview 12:24

In this lecture, I'll cover how to add calculated columns with basic date and time functions like WEEKDAY, TODAY, and DATEDIFF.

DAX Demo: Conditional & Logical Functions (IF/AND/OR) Preview 10:06

In this lecture I'll introduce and demonstrate several common logical functions in DAX, including IF, IFERROR, AND, OR, etc.

DAX Demo: Common Text Functions Preview 09:24

In this lecture I'll introduce and demonstrate a number of text-specific functions in DAX, including LEN, CONCATENATE, UPPER/LOWER, LEFT/MID/RIGHT, SEARCH, and SUBSTITUTE.

DAX Demo: Joining Data with RELATED Preview 08:54

In this lecture I'll show you how to use the RELATED function to create new calculated columns that retrieve values from related tables in the Power BI data model.

DAX Demo: Basic Math & Stats Functions Preview 14:01

In this lecture I'll introduce and demonstrate several common math and statistics functions in DAX, such as SUM, DIVIDE, MAX, MIN, and AVERAGE.

DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS) Preview 07:46

In this lecture I'll demonstrate how to use a variety of COUNT functions in DAX, including COUNT, COUNTA, COUNTROWS, and DISTINCTCOUNT.

IMPORTANT: Order Line Items Preview 06:21

In this lecture, I'll discuss an important characteristic of our sample transaction data, and discuss how it impacts our reporting views.

DAX Demo: CALCULATE Preview 13:06

In this lecture I'll introduce arguably the most powerful DAX function of all: CALCULATE. I'll explain exactly how this function can be used, and demonstrate several examples within Power BI Desktop.

DAX Demo: CALCULATE & ALL Preview 09:25

In this lecture I'll explain how to use the ALL function to remove filter context, and demonstrate how it is commonly used for "% of whole" calculations defined by DAX measures.

DAX Demo: CALCULATE & FILTER Preview 09:37

In this lecture I'll explain how to use the FILTER function to return a table that represents a subset of another table, and demonstrate how FILTER can be used within the CALCULATE function.

DAX Demo: Iterator Functions (SUMX, RANKX) Preview 12:27

In this lecture I'll introduce you to iterator, or "X" functions, which operate by repeating a calculation across all rows in a table and aggregating the results. In this demo we'll look at the SUMX function specifically.

DAX Demo: Time Intelligence Formulas Preview 12:29

In this lecture we'll introduce DAX's powerful time intelligence formulas, and demonstrate how to use them to measure performance-to-date, make period-over-period comparisons, and calculate running totals and moving averages.

DAX Best Practices in Power BI Desktop Preview 02:57

In this lecture I'll outline some of my personal favorite DAX best practices.

QUIZ: Analyzing Data with DAX Calculations in Power BI

HOMEWORK: Analyzing Data with DAX Calculations in Power BI Preview 01:57

HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI Preview 15:05

Introduction Preview 00:29

Exploring the "Report" View in Power BI Desktop Preview 05:33

In this lecture we'll discuss the panes, toolbars, and options available within the Power BI Desktop "Report" view.

Adding Simple Objects to the Power BI Report Canvas Preview 03:07

In this lesson, we'll review the basic ways to add objects and charts into the Power BI Report view, via the Home tab or visualizations pane, and kickoff building our Adventure Works report.

Inserting Basic Charts & Visuals in Power BI Preview 05:47

In this lecture I'll walk through adding our first chart to the Power BI Report canvas (a stacked bar chart), and cover the fields and formats options available for this specific chart type.

UPDATE: Conditional Formatting Preview 02:58

In this lecture I'll walk through conditional formatting options in the newer versions of Power BI Desktop (post Nov 2018)

Power BI Report Formatting Options Preview 09:51

In this lecture, I'll cover Power BI report formatting options, which is all about customizing the look and feel of the visualizations, and highlight formatting options for Line & Column Chart, Matrix, and Donut Chart types.

Power BI Report Filtering Options Preview 11:09

I'll cover the incredibly powerfull filtering options within Power BI and outline the four primary filter types: Visual Level, Page Level, Report Level, and Drillthrough.

Power BI Demo: Exploring Data with Matrix Visuals Preview 06:38

In this demo, I'll focus on the Matrix visualization type and customize the visual to make it easily interpretable. 

Power BI Demo: Filtering with Date Slicers Preview 07:14

In this demo, we'll create a Date Slicer and use it to filter the views in our Power BI report.

Power BI Demo: Showing Key Metrics with Cards & KPI Visuals Preview 09:24

In this demo I'll cover the three standard card types in Power BI: single row card, multi-row card, and KPI card. Cards are a great way to draw attention to important values and KPIs.

Power BI Demo: Inserting Text Cards Preview 06:14

In this demo I'll cover how card visuals can be used for text-based fields (not just values) in Power BI, and how to format cards in a clear and effective way.

Power BI Demo: Visualizing Geospatial Data with Maps Preview 07:15

In this lesson, we'll introduce Power BI Desktop's powerful, flexible, and user-friendly mapping tools.

Power BI Demo: Visualizing Data with Treemaps Preview 03:21

In this demo, I'll cover one of the most underrated chart types in Power BI: the Treemap. Treemaps are a very useful way to show composition and provide a very quick picture of relative volume and proportion. 

Power BI Demo: Showing Trends with Line & Area Charts Preview 06:23

In this demo, I'll show you how to visualize trending using line and area charts in Power BI Desktop.

Power BI Demo: Adding Trend Lines & Forecasts Preview 05:36

In this demo, I'll cover how to add trend and forecast lines from the analytics pane, and apply them to a line chart in the Power BI Report view.

Power BI Demo: Goal Pacing with Gauge Charts Preview 06:43

In this demo, I'll show you how to build and customize a gauge chart visual in Power BI Desktop, and use it to show pacing toward our Total Orders goal.

Editing Power BI Report Interactions Preview 06:38

In this lesson we'll cover a very important topic in Power BI Desktop: report interactions. Report interactions allow you to determine exactly how filters applied to one visual impact the other visuals in your report canvas.

Power BI Demo: Adding Drillthrough Filters Preview 05:08

In this lecture we'll introduce Drillthrough filters. This filter type allows users to jump to different report pages in Power BI (like bookmarks), while simultaneously filtering based on the specific item selected. 

Using Power BI Report Bookmarks Preview 05:49

In this lecture we'll cover Power BI report bookmarks, which capture a specific, previously configured view of a report page and allow you return back to that exact view with the click of a button.

PRO TIP: Testing Scenarios with "What-If" Parameters Preview 11:47

In this lecture we'll cover "What-If" Parameters, which are essentially pre-set measures that produce values within a given range, based on user-inputs like data type, min/max, increment, and default.

Managing & Viewing Roles in Power BI Desktop Preview 05:27

I'll use this lecture to cover managing and viewing roles in Power BI Desktop, two features found in the Security tool group of the Modeling tab. These features allow you to define filtered views tailored to specific audiences or user groups.

PREVIEW: Custom Power BI Visuals (Log-in Required) Preview 02:05

In this lecture we'll preview how to access and load custom visuals within Power BI Desktop.

PREVIEW: Designing for Phone vs. Desktop Report Viewers Preview 02:54

In this lecture we'll preview how to design Power BI reports specifically for mobile viewing.

PREVIEW: Publishing to Power BI Service Preview 02:27

In this lecture we'll quickly preview how to publish a report from Power BI Desktop to Power BI Service.

Power BI Data Visualization Best Practices Preview 01:35

In this lecture I'll cover some of my top Power BI data visualization best practices. 

QUIZ: Visualizing Data with Power BI Reports

HOMEWORK: Visualizing Data with Power BI Reports Preview 02:47

HOMEWORK SOLUTION: Visualizing Data with Power BI Reports Preview 07:22

Power BI Demo: Q&A Visual Preview 10:54

In this Power BI demo we'll practice using the Q&A visual to explore our data using natural language queries.

Power BI Demo: Key Influencers Visual (Part 1) Preview 12:34

In this demo we'll explore the Power BI Key Influencers visual, and use it to predict whether or not a Kickstarter project will be successful.

Power BI Demo: Key Influencers Visual (Part 2) Preview 05:11

In this demo we'll explore the Power BI Key Influencers visual, and use it to understand which specific factors impact the amount of money a Kickstarter project is expected to raise.

IMPORTANT: Correlation vs. Causation Preview 04:24

In this demo we'll address one of the most important rules in data science and analytics: correlation does not imply causation. We'll discuss why this concept is so important to grasp when exploring AI-powered visuals like the Key Influencers visual in Power BI.

Power BI Demo: Decomposition Tree Visual Preview 08:59

In this Power BI demo we'll explore the Decomposition Tree visual, and use it to explore the distribution of our sample data and conduct a simple root cause analysis.

Introduction Preview 00:44

In this lecture, I'll be kicking off the bonus course project where you'll be working through the entire business intelligence workflow for a new client, Maven Market.

PART 1: Connecting & Shaping the Data Preview 02:31

In part 1 of the bonus course project you'll be connecting and shaping Maven Market's data.

PART 2: Creating the Data Model Preview 00:52

In part 2, you'll be using the report created in part 1 to build a data model.

PART 3: Adding DAX Measures Preview 02:47

In part 3, you'll be adding all the DAX measures for use in your final report.

PART 4: Building the Report Preview 01:57

In part 4, you'll build the final report visual for Maven Market.

REFERENCE: Monthly Power BI Updates Preview 00:22

BONUS LECTURE: More from Maven Preview 00:59

Complete the full stack of Excel, Power BI, and SQL analytics courses and emerge a certified wizard. Courses include Formulas & Functions, PivotTables, Charts & Graphs, Power Query, Power Pivot & DAX, Publishing to Power BI Service, and MySQL for Data Analysis (Beginner & Advanced).