Index

A

Access

connecting to 12

actual-to-target values 162

actual value calculation 160

Add Conditional Column dialog box 72–73

Advanced Editor 45, 49

AdventureWorks2016 Database 5

aggregate functions 126–127

ALL 147

Analysis Services 13–17, 141

AND 129

Append transformation 55–57

area charts 206–207

arithmetic operators 123

automatic relationships 104–105

AVERAGE 126

AVERAGEX 128

Azure

data sources, connecting to 24–26

subscription 24

Azure Data Lake 25–27

Azure SQL

connecting to 24

Azure SQL Data Warehouse

connecting to 24

B

bar charts 202–203, 205

Blank Query 30

box and whisker plots 216–217

bubble charts 207

business hierarchies 156–157

business rules

applying 71

C

CALCULATE 135–136, 147

calculated columns 90, 116–118, 128, 158

Calculation ...

Get Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial