Contents

Acknowledgements

Introduction

Organization of this book

Microsoft certifications

Microsoft Virtual Academy

Quick access to online references

Errata, updates, & book support

Stay in touch

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

Import from Excel workbooks

Link to data from other sources

Privacy Levels

Skill 1.2: Perform data transformations

Design and implement basic and advanced transformations

Apply business rules

Change data format to support visualization

Filter data

Format data

Skill 1.3: Cleanse data

Manage incomplete data

Handle data received as a report

Thought experiment

Thought experiment answers

Chapter summary

Chapter 2 Model data

Skill 2.1: Create and optimize data models

Understanding the Excel data model

Get & Transform

Manually enter data

Manage data relationships

Optimize models for reporting

Skill 2.2: Create calculated columns, measures, and tables

Create DAX formulas

Create DAX queries

Create Excel formulas

Skill 2.3: Create Hierarchies

Create date hierarchies

Create business hierarchies

Resolve hierarchy issues

Skill 2.4: Create Performance KPIs

Calculate the actual value

Calculate the target value

Calculate actual-to-target values

Thought experiments

Thought experiment answers

Chapter summary

Chapter 3 Visualize data

Skill 3.1: Create and manage PivotTables

Format PivotTables

Format calculated measures

Filter data

Group and summarize data

Skill 3.2: Create and manage PivotCharts

Select a chart type

Format PivotCharts

Filter data

Skill 3.3: Interact with Power BI

Power BI overview

Import Excel data from Power BI

Manipulate Excel data in Power BI

Thought experiment

Thought experiment answers

Chapter summary

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
13.58.114.29