Visual reports

…Reports.…Reports are a form of visualization in your dashboard.…If I look at the reports, I look at these two I've created for…you over here, I've got a graph and…then I've got another report down here that is in your standard textual layout.…To create a report, all we need to do is right click > New > Report.…Let's take a look.…Analytic Chart and Analytic Grid, so called because these two reports…are designed to be used by people that are going to do analytics in the dashboard.…

These other reports really I'm just bringing information in.…If we look, Excel Services says create a new view of an Excel Services workbook.…That's essentially the same thing as we did in an earlier chapter where we…created a web part and added it to a page.…I'll come back to details.…Reporting Services.…If you have a Reporting Services report we import it here.…It's important to note, if you are using Reporting Services, the visualizations…that are available currently in reporting services, that is, the different types of…graphs are far more robust than what we have in performance point services.…

Resume Transcript Auto-Scroll

Author

Released

8/20/2014

You've gone over the fundamentals. It's time to get into the Microsoft business intelligence (BI) stack in depth, in this course with Ron Davis. Ron starts in SQL Server Analysis Services, explaining both the traditional multidimensional mode and the new tabular mode for viewing your business's data. Then he moves on to enriching and analyzing your data with Excel's PowerPivot tool, and sharing your Excel workbooks in SharePoint. Finally, Ron covers PerformancePoint Services, which allows you to build dashboards for your data warehouses and other data sources, and explores designing diagrams and data visualizations with Visio Services and data mining with Microsoft BI.

Topics include:

Working with data sources and data views in SQL

Understanding the star and snowflake database schemas

Working with the SQL 2012 semantic model (aka tabular mode)

Using Data Analysis Expressions (DAX)

Using Excel Web Parts to connect to spreadsheets

Building dashboards with key performance indicators (KPIs) and reports