Exam Ref DA-100 Analyzing Data with Microsoft Power BI

Description

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 Cover Title Page Copyright Page Dedication Contents at a glance Contents Introduction Organization of this book Preparing for the exam Microsoft certifications Companion files Quick access to online references Errata, updates, & book support Stay in touch Chapter 1 Prepare the data Skill 1.1: Get data from different data sources Skill 1.2: Profile the data Skill 1.3: Clean, transform, and load the data Chapter 2 Model the data Skill 2.1: Design a data model Define the tables Configure table and column properties Define quick measures Flatten out a parent-child hierarchy Define role-playing dimensions Define a relationship’s cardinality and cross-filter direction Design the data model to meet performance requirements Resolve many-to-many relationships Create a common date table Define the appropriate level of data granularity Skill 2.2: Develop a data model Skill 2.3: Create measures by using DAX Skill 2.4: Optimize model performance Chapter 3 Visualize the data Skill 3.1: Create reports Skill 3.2: Create dashboards Skill 3.3: Enrich reports for usability Chapter 4 Analyze the data Skill 4.1: Enhance reports to expose insights Skill 4.2: Perform advanced analysis Chapter 5 Deploy and maintain deliverables Skill 5.1: Manage datasets Skill 5.2: Create and manage workspaces Index A B C D E F G-H-I J-K L M N O-P Q R S T U-V W X-Y-Z Page vierge