/UdacityPowerBINanodegree

Data Analysis and Visualization with Microsoft Power BI Nanodegree Program

MIT LicenseMIT

UdacityPowerBINanodegree

Data Analysis and Visualization with Microsoft Power BI Nanodegree Program

Overview

The Data Analysis and Visualization with Microsoft Power BI program will equip any learner who wants to develop in-demand skills in data pre-processing, visualization and analysis using Microsoft Power BI as the primary tool. Students in this program will learn to connect Microsoft Power BI to multiple data sources, process and transform data to prepare it for reporting and visualization, build compelling data visualizations that tell a story and employ best design practices, and draw insights from data dashboards and visualizations that can allow for insights and help a business make critical decisions.

Courses

1. Introduction to Preparing and Modeling Data

LESSON TITLE LEARNING OUTCOMES
INTRODUCTION TO PREPARING AND MODELING DATA
  • Describe the Microsoft Power BI data Pipeline
  • Recognize the range of stakeholders a data modeler should collaborate with
  • Become familiar with the role of Power Query, data modeling and reporting to meet business needs
KEY CONCEPTS IN DATA MODELING
  • Conceptualize data modeling, including fact tables, dimension tables, key columns, and relationships
  • Define the role each component plays in reporting
GETTING YOUR DATA & INITIAL TRANSFORMATIONS
  • Access a range of data sources using Get Data
  • Leverage Power Query to perform initial transformations to make your queries user friendly
  • Develop a familiarity with Data Types and their role in Microsoft Power BI
BIGGER TRANSFORMATIONS & DATE TABLES
  • Correct — and know when to correct — errors and gaps
  • Make more complex column changes within queries
  • Morph data across queries to align with reporting needs
  • Choose and build the right data table for your purposes
RELATIONSHIPS & RELATIONSHIPRELATED DAX
  • Select the correct relationships for your data model
  • Create Implicit and Quick Measures
  • Leverage relationships and filters in common DAX functions
REPORTS AND DAX FOR COMMON REPORTING NEEDS
  • Choose between a Measure and Calculated Column
  • Create basic report visualizations such as Matrixes and Cards
  • Make DAX functions that leverage Conditional Logic
  • Troubleshoot and Organize your Microsoft Power BI file

2. Creating Visualizations with Microsoft Power BI

LESSON TITLE LEARNING OUTCOMES
WELCOME TO CREATING VISUALIZATIONS WITH MICROSOFT POWER BI
  • Describe the learning objective of the course
  • Explain why data visualization is important for business intelligence
  • Identify the main stakeholders that BI analysts interact with
  • Identify when data visualization is useful and when it is not
BUILDING COMPELLING DATA VISUALIZATIONS
  • Identify important business metrics and pair them with appropriate data visuals
  • Build common data visuals, including bar charts & line charts
  • Design complementary visuals, including cards, donut charts & tables
  • Build more complex data visuals, including scatter plots & bubble maps
  • Recognize standard formatting options for Microsoft Power BI visuals and navigate the unique formatting features that vary between visuals
DESIGNING USERFRIENDLY REPORTS
  • Customize Microsoft Power BI themes with unique color palettes
  • Insert elements like images, shapes and buttons to create compelling and versatile layouts for their reports
  • Apply design principles that reduce noise & highlight data stories
  • Maximize accessibility for diverse user groups
CREATING INTERACTIVE REPORTS FOR DATA EXPLORATION
  • Design visuals that interact with one another and help users explore data by filtering and drilling for insights
  • Identify the differences between filters and slicers in a Microsoft Power BI report, including when to use each and differences in functionality
  • Apply filters to data visuals, pages and reports
  • Customize the Filter Pane for reporting needs
  • Help users explore the data with different types of slicers
ELEVATING REPORTS WITH ADVANCED REPORT FEATURES
  • Customize Microsoft Power BI reports in ways that foster interactivity and help users tell compelling data stories
  • Build custom data stories with Microsoft Power BI bookmarks
  • Empower users with navigation buttons
  • Design drill-through pages for deep-dive analysis

3. Advanced Data Analysis

LESSON TITLE LEARNING OUTCOMES
WELCOME TO ADVANCED DATA ANALYSIS IN MICROSOFT POWER BI
  • Describe the learning objectives of the course
  • Explain what data analysis is and why it’s important
  • Identify the main stakeholders that data analysts interact with
  • Identify when data analysis is useful and when it is not
ADVANCED DATA ANALYTICS
  • Define, investigate and analyze data in order to draw conclusions
  • Use historical analysis to investigate, aggregate and describe data
  • Use predictive analysis to understand relationships between data and forecast the probabilities of future outcomes
POWER QUERY TRANSFORMATIONS
  • Compare and contrast Power Query and DAX
  • Use M in Power Query to manually edit table columns
  • Write custom formulas using the advanced editor in order to effectively clean and format imported data
DAX FUNCTIONS
  • Write custom DAX formulas to perform calculations or format data
  • Use DAX to create calculated tables
  • Troubleshoot common DAX errors and fix the underlying issues with their code
ADVANCEDVISUALIZATIONS
  • Use advanced visualizations in order to analyze data and draw conclusions
  • Distinguish between advanced and standard visualizations
  • Customize advanced visualizations with filters, formatting and trend analysis