Contents
Quick access to online references
Errata, updates, & book support
Important: How to use this book to study for the exam
Chapter 1 Consume and transform data by using Microsoft Excel
Skill 1.1: Import from data sources
Connect to and import from databases, files, and folders
Connect to Microsoft SQL Azure and Big Data
Link to data from other sources
Skill 1.2: Perform data transformations
Design and implement basic and advanced transformations
Change data format to support visualization
Handle data received as a report
Skill 2.1: Create and optimize data models
Understanding the Excel data model
Skill 2.2: Create calculated columns, measures, and tables
Skill 2.4: Create Performance KPIs
Calculate actual-to-target values
Skill 3.1: Create and manage PivotTables
Skill 3.2: Create and manage PivotCharts
Skill 3.3: Interact with Power BI
Import Excel data from Power BI