Beginning Power BI for Business Users

INDEX

A

• AAD (Azure Active Directory), 41–42, 219
• accessibility, 209
• accumulated snapshot, as a type of fact, 146
• Ackoff's pyramid, 20
• Add Column ribbon, in Power Query, 105
• adding
  • Card visual, 86–88
  • previous year column, 116–117
  • StateID foreign keys to fact tables, 163–164
  • title text, 86, 87
• Admin role, 222, 223
• advanced filtering, 183
• Advanced Filtering filter, 182
• aggregated data, handling, 109
• aggregating values, 27–28
• AI capabilities, as a benefit of Power BI, 12
• alerts, as a benefit of Power BI, 12
• Amazon Redshift, 209
• analyzing data, 30
• application programming interface (API), 23
• Applied Steps pane, 107–108
• applying changes, 129–131
• Apps icon, 42
• arranging data, 28
• AVERAGE function, 248
• Azure Active Directory (AAD), 41–42, 219
• Azure SQL Database, 209

B

• basic filtering, 183
• Basic Filtering filter, 182
• bidirectional filtering, 179–181
• black banner, in Power BI Service, 45
• bookmarks
  • about, 195–199
  • personal vs. report, 199–200
• building blocks, 61–62
• business-led self-service, 252–253
• buttons, reports and, 193–194

C

• CALCULATE function, 249–250
• calculated columns
  • about, 115–116, 235–236
  • adding previous year column, 116–117
  • creating, 236–240
  • DIVIDE function, 119–120
  • hiding columns, 117
  • LOOKUPVALUE function, 118–119
  • report, 121–122
  • visualizing data, 120–121
• Card visuals
  • adding, 86–88
  • resizing, 88
• changing
  • applying changes, 129–131
  • column data type, 112
  • values in columns, 112–113
• circle arrow, in Power BI Service, 46
• cleaning
  • data, 27, 122–137
  • date columns, ...