You're reading from Tabular Modeling with SQL Server 2016 Analysis Services Cookbook Create better operational analytics for your users with these business solutions

Product type Paperback

Published in Jan 2017

Publisher Packt

ISBN-13 9781786468611

Length 372 pages

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Business Intelligence

Author (1):

Wilson

Preface

1. Introduction to Microsoft Analysis Services Tabular Mode FREE CHAPTER

2. Setting up a Tabular Mode Environment

3. Tabular Model Building

4. Working in Tabular Models

5. Administration of Tabular Models

6. In-Memory Versus DirectQuery Mode

7. Securing Tabular Models

8. Combining Tabular Models with Excel

9. DAX Syntax and Calculations

10. Working with Dates and Time Intelligence

11. Using Power BI for Analysis

Using analytics in Power BI

Complete the steps in the recipe Adding additional visualizations to Power BI.

Add a new page to the report and rename it Analytics.
Add a line chart to the report and add the count_of_crashes from the CRASH_DATA_T table and the Light_Condition from the LIGHT_T table:
Select the ellipse and change the sort order to Sort by Count_of_Crashes:
While the chart is selected, select the spyglass icon next to the paint roller to see the available analytics. The available choices vary based on the visualization that you select:
To add an Average line, click on the down arrow next to Average Line. Then click + Add to create an average line and rename it Average. Then change the color to red and change the data label slider to On. Finally, change the color to red and change the Text drop down to Name and Value:
The graph now has a horizontal line that shows the average of all value:
The average is 69903. This average is calculated based...