Building reports in Microsoft PowerView and Excel Services
ubipv
Organized by
0 days
Building PivotTables on PowerPivot
- Building pivot tables on top of PowerPivot
- Using PivotCharts
- Working with Slicers
- Building custom sets
- Combine PowerPivot data with Sparklines
- Using CUBE functions in Excel
- Deploying PivotTables to Excel Services
Deploy PowerPivot to SharePoint and Office 365
- PowerPivot in SharePoint: Prerequisites
- Publishing PowerPivot databases
- Deploying reports to Excel Services
- Using Excel Web Parts
- Accessing SharePoint PowerPivot databases in other reporting tools
Introduction PowerView
- From personal BI to corporate BI
- PowerView reports in Excel and SharePoint
Authoring PowerView reports
- Create tables and Matrices
- From table to chart
- Interactive sorting, filtering and highlighting
- Working with buble charts
- Slicers, cards and multiples
- Adding maps to PowerView
- Working with multi-view reports
- Improving PowerPivot models for PowerView reporting
Deploying PowerView reports
- Saving PowerView reports in document libraries
- PowerPivot Gallery functionality
- Printing the report
- Export to PowerPoint functionality
Power Map
- Mapping geographical data
- Exploring visualization options
- Working with multiple scenes
Business Intelligence is a hot topic today: In an information driven society, analyzing and reporting upon the data that lives within an enterprise is crucial. In this course, we focus on the reporting part of PowerBI, a set of add-ins to Microsoft Office Excel 2010 or later.
We focus on how business users can create reports in Microsoft Office Excel, using the native PivotTable functionality in Excel, as well as using the PowerView and PowerMap reporting functionality. We will also focus on how SharePoint or Office365 can be used as a delivery platform for these reports, making it possible to share them within a wider audience. The course contains many exercises, such that students will have a lot of hands-on experience with these tools.
This course is intended for people who frequently use Excel to analyze their data and want to become familiar with the PowerPivot, PowerView and PowerMap technologies to build appealing reports in Excel. Also people who want to share their Excel reports in a more centralized manner via SharePoint or Office365 will benifit from this course.
This course assumes students are familiar with the basic functionality of Excel 2010 or later. We also assume students are already familiar with PowerPivot in Excel, or are used to querying Analysis Services cubes from within Excel. For students who do not meet these prerequisites, we recommend attending the 5 day PowerBI course (UBIPB) instead of this shorter 3 day variant.