Data Analysis and Visualization with Microsoft Power BI

Welcome to Data Analysis and Visualization with 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.

Getting Help

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

Introduction to Preparing and Modeling Data

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.

Key Concepts in Data Modeling

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.

Getting Your Data & Initial Transformations

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.

Bigger Transformations & Date Tables

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.

Relationships and Relationship-Related DAX

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.

Reports and DAX for Common Reporting Needs

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 for Seven Sages Brewing Company

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

Welcome to Creating Visualizations with Power BI

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.

Building Compelling Data Visualizations

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.

Designing User-Friendly Reports

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

Creating Interactive Reports for Data Exploration

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.

Elevating Reports with Advanced Report Features

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.

Building a PowerBI Report for Waggle

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.

Introduction to the Advanced Data Analytics Course

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.

Advanced Data Analytics

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.

Power Query Transformations

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.

DAX Functions

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.

Advanced Visualizations

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.

Project: Market Analysis Report for National Clothing Chain

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.

Congratulations!

Congratulations on your graduation from this program! Please join us in celebrating your accomplishments.

Take 30 Min to Improve your LinkedIn

Find your next job or connect with industry peers on LinkedIn. Ensure your profile attracts relevant leads that will grow your professional network.

Optimize Your GitHub Profile

Other professionals are collaborating on GitHub and growing their network. Submit your profile to ensure your profile is on par with leaders in your field.