Prepare for Microsoft Exam 70-778GÇöand help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

• Chapter 1 Consuming and transforming data by using Power BI Desktop
• Skill 1.1: Connect to data sources
• Skill 1.2: Perform transformations
• Skill 1.3: Cleanse data
• Chapter 2 Modeling and visualizing data
• Skill 2.1: Create and optimize data models
• Skill 2.2: Create calculated columns, calculated tables, and measures
• Skill 2.3: Measure performance by using KPIs, gauges, and cards
• Skill 2.4: Create hierarchies
• Skill 2.5: Create and format interactive visualizations
• Skill 2.6: Manage custom reporting solutions
• Chapter 3 Configure dashboards, reports, and apps in the Power BI Service
• Skill 3.1: Access on-premises data
• Skill 3.2: Configure a dashboard
• Skill 3.3: Publish and embed reports
• Skill 3.4: Configure security for dashboards, reports, and apps
• Skill 3.5 Configure apps and apps workspaces

Daniil Maslyuk (MCSA: BI Reporting; MCSE: Data Management and Analytics) is a Microsoft business intelligence consultant who specializes in Power BI, Power Query, and Power Pivot; the DAX and M languages; and SQL Server and Azure Analysis Services tabular models. Daniil blogs at xxlbi.com and tweets as @DMaslyuk.