Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Summary


In this chapter, we learned about the features of Power View and how it is an excellent tool for self-service reporting. We talked about PowerPivot and BISM and how they relate to Power View. We covered setting up and using Power View within SharePoint and how to connect to a tabular model as well as a multidimensional model. Then, we talked about using Power View within Excel via data models and how to import data into Excel. We moved on to data visualizations, describing the different types of reports you can create. We covered the Power View user interface and how to enhance the data models. We discussed how to deploy and share reports, the various presentation modes, and reports with multiple views. A large section was on chart highlighting, slicers, and filters. We ended with a discussion on sorting, exporting to PowerPoint, and design tips. In the next chapter, we will show you step-by-step how to create a report in Power View.