Data Analysis and Visualization with Microsoft Power BI

Welcome! We're so glad you're here. Join us in learning a bit more about what to expect and ways to succeed.

You are starting a challenging but rewarding journey! Take 5 minutes to read how to get help with projects and content.

Meet your instructor, get an overview of the course, and learn some fundamental concepts about how Power BI is used to prepare data and generate easy-to-understand visual reports.

Learn core concepts of data modeling in Power BI, including how to make your data model more efficient by splitting it into fact tables and dimension tables.

Learn how to gather your data using the Get Data feature and tidy it up using basic transformations, so that it is ready for more advance transformations and data modeling.

Learn different ways we can take the data we have at our fingertips and use bigger transformations to morph it into what we need for our data model and, ultimately, our reporting.

This lesson is all about relationships and filters. We'll cover relationship cardinality and direction, filter direction, implicit DAX, quick measure, and custom DAX functions that rely on filters.

Go into greater depth on reports and DAX that is specifically helpful for reporting, including how to add basic components to your report and group the data using measures and calculated columns.

Create a data model to help Seven Sages Brewing Company better understand their sales and profitability.

This lesson will just quickly make sure you've covered everything you need to know and then we'll introduce the topic of data visualization and why it's important.

In this lesson, we're going to kick things off with an overview of common data visualizations you will use in Power BI such as bar charts, line charts, and advanced visuals like scatter plot and maps.

In this lesson, we're going to discuss useful design principles that can help those data visuals really shine.

In this lesson, we'll talk about tools like filters and slicers that will help your users explore data by searching for specific items that interest them.

In this lesson, we are going to explore a couple of advanced Power BI features that will tie our previous lessons together and test all the skills you have learned up to this point.

In this project, you will design and build a Power BI report for Waggle, a start-up company that builds smart devices and apps that help pet owners monitor the health of their pets.

In this first lesson, we'll introduce data analytics and the need for it. We'll take a brief look a each of the lessons to give students a feel for where we will be spending our time.

This lesson focuses on the steps of data analysis. We'll also look at specific tools and techniques for analysis including how to construct and interpret histograms and linear regressions.

In this lesson, we’ll dive deep into Power Query to retrieve and organize data. We'll take an in-depth look at M, the language of Power Query that helps in the data cleanup process.

This lesson focuses on the DAX language to measure, analyze and understand data, including custom formulas, calculated measures, columns, and tables, and common DAX errors.

The focus of this lesson will be learning to create or edit advanced visualizations to analyze and present information, with the goal of drawing conclusions.

You'll use your analytics skills to create a market analysis report for an online clothing retailer using real-world data to better understand different population groups and industries.