O'Reilly logo

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel by Chris Sorensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

A

Access

connecting to 12

actual-to-target values 162

actual value calculation 160

Add Conditional Column dialog box 7273

Advanced Editor 45, 49

AdventureWorks2016 Database 5

aggregate functions 126127

ALL 147

Analysis Services 1317, 141

AND 129

Append transformation 5557

area charts 206207

arithmetic operators 123

automatic relationships 104105

AVERAGE 126

AVERAGEX 128

Azure

data sources, connecting to 2426

subscription 24

Azure Data Lake 2527

Azure SQL

connecting to 24

Azure SQL Data Warehouse

connecting to 24

B

bar charts 202203, 205

Blank Query 30

box and whisker plots 216217

bubble charts 207

business hierarchies 156157

business rules

applying 71

C

CALCULATE 135136, 147

calculated columns 90, 116118, 128, 158

Calculation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required