Home Page Icon
Home Page
Table of Contents for
Cover Page
Close
Cover Page
by Chris Sorensen
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Cover Page
Title Page
Copyright Page
Dedication Page
Contents at a Glance
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
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset