0%

Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced data analytics professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level.

Focus on the expertise measured by these objectives:

Prepare the data

Model the data

Visualize the data

Analyze the data

Deploy and maintain deliverables

This Microsoft Exam Ref:

Organizes its coverage by exam objectives

Features strategic, what-if scenarios to challenge you

Assumes you are an experienced business intelligence professional or data analyst, or have a similar role

Analyzing Data with Microsoft Power BI About the Exam

Exam DA-100 focuses on skills and knowledge needed to acquire, profile, clean, transform, and load data; design and develop data models; create measures with DAX; optimize model performance; create reports and dashboards; enrich reports for usability; enhance reports to expose insights; perform advanced analysis; manage datasets, and create and manage workspaces.

About Microsoft Certification

Passing this exam earns your Microsoft Certified: Data Analyst Associate certification, demonstrating your ability to help businesses maximize the value of data assets by using Microsoft Power BI.

As subject matter experts, Data Analysts design and build scalable data models, clean and transform data, and enable advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.

See full details at: microsoft.com/learn

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. Contents at a glance
  6. Contents
  7. Acknowledgments
  8. About the author
  9. Introduction
    1. Organization of this book
    2. Preparing for the exam
    3. Microsoft certifications
    4. Companion files
    5. Quick access to online references
    6. Errata, updates, & book support
    7. Stay in touch
  10. Chapter 1. Prepare the data
    1. Skill 1.1: Get data from different data sources
    2. Skill 1.2: Profile the data
    3. Skill 1.3: Clean, transform, and load the data
    4. Chapter summary
    5. Thought experiment
    6. Thought experiment answers
  11. Chapter 2. Model the data
    1. Skill 2.1: Design a data model
    2. Skill 2.2: Develop a data model
    3. Skill 2.3: Create measures by using DAX
    4. Skill 2.4: Optimize model performance
    5. Chapter summary
    6. Thought experiment
    7. Thought experiment answers
  12. Chapter 3. Visualize the data
    1. Skill 3.1: Create reports
    2. Skill 3.2: Create dashboards
    3. Skill 3.3: Enrich reports for usability
    4. Chapter summary
    5. Thought experiment
    6. Thought experiment answers
  13. Chapter 4. Analyze the data
    1. Skill 4.1: Enhance reports to expose insights
    2. Skill 4.2: Perform advanced analysis
    3. Chapter summary
    4. Thought experiment
    5. Thought experiment answers
  14. Chapter 5. Deploy and maintain deliverables
    1. Skill 5.1: Manage datasets
    2. Skill 5.2: Create and manage workspaces
    3. Chapter summary
    4. Thought experiment
    5. Thought experiment answers
  15. Index
  16. Code Snippets
18.189.170.17