Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Zero To Mastery

Power BI Bootcamp: Zero to Mastery

via Zero To Mastery

Go to class Write review

Overview

This Power BI Bootcamp will take you from absolute beginner in Power BI to being able to get hired as a confident and effective Business Intelligence Analyst. You'll learn the full Power BI suite of tools, the M programming language, and the DAX formula language, all while analyzing real-world datasets and building enterprise-level projects.
  • Become a top 10% Business Intelligence Analyst to enhance your skill set and career opportunities
  • Analyze real-world datasets on fun subjects including Bigfoot and UFO sightings
  • Build both guided and independent Power BI projects so that you can put your Power BI skills into practice and deeply understand the material
  • Learn Power Query's built-in graphical tools to fetch data from a variety of external sources, clean and transform it, and load it into Power BI
  • Master the art and science of Power BI Data Modeling
  • Leverage the M programming language to apply and edit advanced transformations that go beyond the functionality built into the Power Query interface
  • How to create and customize Power BI's most useful visualizations
  • How to determine which visualizations are most appropriate for a given data analysis problem
  • Construct a Data Model consisting of multiple distinct datasets, by identifying and establishing appropriate relationships between these datasets
  • Create sophisticated metrics (KPIs) with the Power BI DAX programming language
  • Make DAX code more readable and maintainable using whitespace, comments, and variables, plus using measure tables to organize your measures
  • Learn why Power BI is the premier analysis & visualization tool

Syllabus

  •   Introduction
    • Power BI Bootcamp: Zero to Mastery
    • Exercise: Meet Your Classmates and Instructor
    • ZTM Plugin + Understanding Your Video Player
    • Course Resources
    • Set Your Learning Streak Goal
  •   Section 1: Power BI 101
    • Introducing PowerBI
    • Navigating the Power BI Interface
    • Installing and Configuring Power BI
    • ETL with Power BI
    • Fetching Data from Databases
    • Introducing Power Query
    • Applying Basic Transformations
    • Editing Transformations
    • Introducing the UFO Sightings Project
    • Exercise: UFO Sightings Project - Part 1
    • Solution: UFO Sightings Project - Part I
    • Numeric Transformations
    • Date Transformations
    • Text Transformations
    • Conditional Transformations
    • Exercise: UFO Sightings Project - Part 2
    • Solution: UFO Sightings Project - Part 2
    • Introducing Matrix Visualizations
    • Adding Layers to Matrix Visualizations
    • Navigating Matrix Visualizations
    • Formatting Visualizations
    • Data Bars
    • Conditional Formatting Rules
    • Exercise: UFO Sightings Project - Part 3
    • Solution: UFO Sightings Project - Part 3
    • Introducing Measures
    • Creating Your First Measure
    • Customizing Measures
    • Exercise: UFO Sightings Project - Part 4
    • Solution: UFO Sightings Project - Part 4
    • Let's Have Some Fun (+ Free Resources)
  •   Section 2: Visualizing Data with Power BI
    • Column Charts
    • Column Chart Variations
    • Bar Charts
    • Line and Area Charts
    • Combo Charts
    • Visualizing Proportionality
    • Exercise: UFO Sightings Project - Part 5
    • Solution: UFO Sightings Project - Part 5
    • Unlimited Updates
    • Customizing Chart Interactions
    • Customizing Chart Formatting
    • Map Charts
    • Building Dashboards
    • Formatting the Report Environment.
    • Exercise: UFO Sightings Project - Part 6
    • Solution: UFO Sightings Project - Part 6
    • Filtering Individual Visualizations
    • Filtering Multiple Visualizations
    • Slicers
    • Date Slicers
    • Exercise: UFO Sightings Project - Part 7
    • Solution: UFO Sightings Project - Part 7
    • Course Check-In
  •   Section 3: Advanced Power Query
    • Previewing Data
    • Configuring Refresh Options
    • Merging Datasets
    • Appending Datasets
    • Aggregate Calculations
    • Introducing Oodles of Noodles (Meal Kit Delivery Service Project)
    • Exercise: Meal Kit Delivery Service Project - Part 1
    • Solution: Meal Kit Delivery Service Project - Part 1
    • Introducing the M Language
    • M Behind the Scenes
    • Creating Custom Columns with M
    • Creating Custom Filters with M
    • Using M Functions (Build a Calendar Table)
    • Exercise: Meal Kit Delivery Service Project - Part 2
    • Solution: Meal Kit Delivery Service Project - Part 2
    • Implement a New Life System
  •   Section 4: Modeling Data in Power BI
    • Introducing the Model View
    • Understanding Relationships
    • Relationships in Power BI - Part 1
    • Relationships in Power BI - Part 2
    • Using Related Data in Visuals
    • Exploring Filter Context
    • Calendar Tables
    • Data Modeling Pitfalls
    • Multiple Data Tables
    • Two-Way Relationships
    • Exercise: Meal Kit Delivery Service Project - Part 3
    • Solution: Meal Kit Delivery Service Project - Part 3
    • Exercise: Imposter Syndrome
  •   Section 5: Analyzing Data with DAX
    • Calculated Columns with DAX
    • The IF Function
    • SWITCH 101
    • SWITCH 201
    • The RELATED Function
    • Exercise: Meal Kit Delivery Service Project - Part 4
    • Solution: Meal Kit Delivery Service Project - Part 4
    • Using DAX Functions in Measures
    • The CALCULATE Function
    • Going Deeper with CALCULATE
    • The ALL Function
    • Exercise: Meal Kit Delivery Service Project - Part 5
    • Solution: Meal Kit Delivery Service Project - Part 5
  •   Section 6: Advanced DAX
    • Introducing Time Intelligence Functions
    • The ISBLANK Function
    • The DATEADD Function
    • The DATESINPERIOD Function
    • Solution: Meal Kit Delivery Service Project - Part 6
    • Exercise: Meal Kit Delivery Service Project - Part 6
    • Formatting and Commenting Code
    • Variables
    • The X Functions
    • The RANKX Function
    • The TOPN Function
    • Creating a Measure Table
    • Data Modeling and Analysis Best Practices
    • Exercise: Meal Kit Delivery Service Project - Part 7
    • Solution: Meal Kit Delivery Service Project - Part 7
  •   Section 7: Advanced Visualizations
    • Card Visuals
    • Single-Value Cards
    • KPI Cards
    • Gauge Charts
    • Analyzing Time Series Data
    • Changing Measures Dynamically
    • What-If Parameters
    • Bookmarks
    • Drillthrough
    • Mobile View
    • Exercise: Meal Kit Delivery Service Project - Part 8
    • Solution #1: Meal Kit Subscription Service Project - Part 8
    • Solution #2: Meal Kit Subscription Service Project - Part 8
  •   Where To Go From Here?
    • Thank You!
    • Review This Course!
    • Become An Alumni
    • Learning Guideline
    • ZTM Events Every Month
    • LinkedIn Endorsements

Taught by

Travis Cuzick

Reviews

Start your review of Power BI Bootcamp: Zero to Mastery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.