Microsoft Power BI Certification: DA-100 Exam Prep

Microsoft Power BI Certification: DA-100 Exam Prep

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 7.5 Hours | 2.63 GB

Complete, hands-on guide to passing the DA-100 Power BI Exam and becoming a Microsoft Certified Data Analyst Associate

This course is designed to help you build the exact skills you need to ace the Microsoft DA-100 exam, guaranteed.

With hands-on projects, downloadable study guides, and a full-length practice exam, this is the ONLY course you’ll need to prepare for your Power BI certification!

Throughout the course, you’ll play the role of Lead BI Analyst for Maven Cycles, a boutique cycling shop. You’ll use Power BI Desktop and Service, along with the skills you learn throughout the course, to design and build an end-to-end business intelligence solution from the ground up. We’ll guide you each step of the way, with crystal clear explanations and pro tips to help you build expert-level Power BI and DAX skills.

Our project will incorporate all of the skills covered on the DA-100 Exam, including data prep, modeling, visualization, and analysis, along with deploying and maintaining reports and deliverables:

Data Prep: Getting Data From Different Sources

Connect to data sources, choose a storage mode & define data source parameters

Data Prep: Profiling

Explore the view menu & data profiling tools like column quality and distribution

Data Prep: Cleaning, Transforming & Loading

Clean data, apply table transformations, merge & append queries, and modify custom M code

Data Modeling 101

Design data models, identify keys, establish table relationships, and review model optimization tips

Data Modeling: DAX Calculations

Create calculated columns & measures with DAX, including aggregation, table, and time intelligence functions

Data Visualization: Creating Reports & Dashboards

Insert & format visuals, edit report interactions, add filters & tooltips, and create reports and dashboards

Data Analysis: Enhancing Reports

Review chart analytics options, natural language queries, filtering options, and AI visuals

Deploying & Maintaining Deliverables

Implement scheduled & incremental refresh, configure row level security, explore sharing options, and more

We’ll also walk through everything you need to know about the DA-100 certification process itself, including:

  • Exam structure & details
  • Question Types & examples
  • Measured skills
  • Exam rules & results
  • Tips for success

Finally, we’ll wrap things up with a full-length practice exam, with knowledge-based and case study questions designed to mirror the actual exam experience and make sure you’re ready for the real deal.

If you’re ready to level-up your Power BI skills, increase your earning potential, and become a Microsoft Certified Analyst, this is the course for you!

What you’ll learn

  • Develop the exact skills you need to ace the DA-100 Power BI certification exam
  • Extract, profile, clean, transform, and load data from different sources
  • Build and optimize data models and DAX measures
  • Publish reports and dashboards to Power BI Service
  • Create and manage datasets & workspaces to deploy across your organization
  • Learn from a best-selling instructor and Microsoft Certified Data Analyst
Table of Contents

Getting Started
1 Course Structure & Outline
2 READ ME Important Notes for New Students
3 The Course Project
4 Maven Cycles Data Model
5 DOWNLOAD Course Resources
6 Setting Expectations

Preparing for the DA-100 Exam
7 Exam Structure
8 Skills Measured
9 Exam Question Types
10 Example Knowledge-Based Questions
11 Example Case Study Question
12 Exam Rules
13 Helpful Resources
14 Tips for Success

Setting Up Power BI Desktop & Service
15 Installing Power BI Desktop
16 Creating An Account & Free Trial
17 Power BI Service Interface
18 Creating Your First Workspace

Data Prep Getting Data from Different Sources
19 Introduction
20 Connecting to Data
21 The Query Editor
22 Example Connecting to JSON Files
23 Example Connecting to PBDIS Files
24 Example Connecting to the Microsoft Dataverse
25 Example Connecting to SSAS
26 Example Connecting to SharePoint Online
27 Storage Modes
28 Data Source Settings
29 PRO TIP Dynamic Sources with Parameters

Data Prep Profiling
30 Introduction
31 The View Menu
32 Column Quality
33 Column Distribution
34 Column Profile

Data Prep Cleaning, Transforming & Loading
35 Introduction
36 Basic Table Transformations
37 Index Columns
38 Conditional Columns
39 Columns from Example
40 Grouping & Aggregation
41 Pivoting & Unpivoting
42 Merging Queries
43 Appending Queries
44 Modifying Queries
45 Intro to M Code & Editing Applied Steps
46 The Advanced Editor
47 Common M Function Categories
48 M Code Syntax

Data Modeling 101
49 Introduction
50 What is a Data Model
51 Data Tables vs. Lookup Tables
52 Creating Table Relationships
53 Relationship Cardinality & Filter Flow
54 Active & Inactive Relationship
55 Creating Snowflake Schemas
56 Automatic Date Tables
57 Date Table Requirements
58 Model Optimization Tips

Data Modeling DAX Calculations
59 Introduction
60 Meet DAX
61 Calculated Columns
62 Measures
63 Quick Measures
64 Common DAX Function Categories
65 Basic Aggregation Functions
66 Iterator Functions
69 CALCULATE Modifiers
71 ALL
74 Time Intelligence Functions

Data Visualization Creating Reports & Dashboards
75 Introduction
76 Power BI Report View
77 Objects & Basic Charts
78 Editing Report Interactions
79 Drill-through Filters
81 Tooltips
82 Importing Custom Visuals
83 R & Python Visuals
84 Accessibility Features
85 Creating a Dashboard in Power BI Service
86 Dashboard Interface
87 Web vs. Mobile Layout

Data Analysis Enhancing Reports
88 Introduction
89 Chart Types Based on Analysis
90 Chart Analytics Options
91 Q&A Visual
92 Filtering Options
93 Slicers
94 Key Influencers Visual
95 Decomposition Tree Visual

Deploying & Maintaining Deliverables
96 Introduction
97 Scheduled Dataset Refresh
98 Static Row-Level Security
99 Dynamic RLS
100 Apply RLS in Power BI Service
101 PRO TIP Azure Security Groups
102 Subscriptions
103 Sharing Options
104 User Roles & Permissions
105 Publishing Apps
106 Deployment Pipelines
107 Data Lineage
108 Incremental Refresh & Query Folding
109 Configuring Incremental Refresh
110 Large Dataset Storage Format
111 Endorsing Content
112 Sensitivity Labels

Practice Exam
113 Practice Exam Intro
114 DOWNLOAD Practice Exam Resources
115 CASE STUDY #1 Introduction
116 CASE STUDY #2 Introduction

Wrapping Up
117 BONUS LECTURE More from Maven Analytics