Microsoft Power BI Certification: DA-100 Exam Prep

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