Data Analysis & Visualization
with Power BI

In the Foundational Phase, you will learn to prepare and model data. Where do you even start when the data you need for a single report lives in a bunch of different files and software systems? This is where preparing and modelling data becomes essential! This course is a crucial step in Power BI for anyone who needs to mash together multiple data sources, clean them, restructure them, and harmonize them into a single and efficient data model to support reporting. We’ll cover Power BI’s built-in Extract-Transform-Load (ETL) tool, Power Query, learn foundational data modelling principles, cover some introductory DAX (Data Analytics Expressions), and touch on troubleshooting and optimization.

The Nanodegree Program Phase allows you to master the in-demand skills necessary to become a successful data analyst like data pre-processing, visualization and analysis using Power BI as the primary tool. The course is centered around building a solid foundation and intuition of analytics so that students can take their skills beyond simply aggregating data in Power BI and into the realm of statistics, forecasting, and strategy. After taking the introductory lessons on data analytics, the course focuses on M, the language of Power Query, and learning to build custom formulas as part of the data transformation process. The overarching goal of the course is to help students become effective at the process of retrieving, analyzing, and visualizing data to answer questions and draw conclusions.