Create and Distribute High-impact Microsoft Power View Reports
Explore data in insightful new ways and transform the way your enterprise uses BI with help from this expert guide. Visualizing Data with Microsoft Power View shows how to effectively analyze and communicate complex information through elegant interactive reports. Discover how to create and populate tables, connect to databases, build multi-view reports in real-time, and publish your results to end-users. BI Semantic Model development and administration are also covered in this comprehensive volume.
- Launch Power View and navigate its user interface
- Load BI from SQL databases and external sources
- Build basic and multi-level table visualizations
- Develop card-, chart-, and matrix-based reports
- Incorporate auto-sizing, filtering, tiling, and slicing
- Securely distribute reports via SharePoint and PowerPivot
- Add functionality with hierarchies, perspectives, and KPIs
- Design, deploy, and support custom BI Semantic Models
- More than four hours of video demonstrations
- A complete package of sample dataa Power View-optimized BI Semantic Model, a SQL Server database, and additional underlying data sources
- Comprehensive instructions for creating a learning environment, including Windows Server, SharePoint Server 2010, and Microsoft SQL Server 2012 with PowerPivot and Reporting Services SharePoint integration
- Six completed Power View Reports that include multiple views, visualizations, and performance dashboards
- BI Semantic Model with advanced extensions using DAX functions, including date and time, mathematical, logical, informational, and statistical functions
|Publisher:||McGraw-Hill Professional Publishing|
|Product dimensions:||7.30(w) x 9.00(h) x 0.90(d)|
About the Author
Brian Larson, MCITP, MCDBA, served as a member of the Reporting Services development team on a contract basis, and has contributed to the code base. He is the Vice President of Technology for Superior Consulting Services (SCS), a Microsoft Certified Partner. Brian has been invited to speak on Reporting Services at several conferences including SQL Server Magazine Connections, has been interviewed as a subject matter expert by Microsoft TechNet, .NET Rocks, and others, and has written articles for SQL Server Magazine.
Mark Davis, MCITP, is Business Intelligence Practice Manager with Superior Consulting Services in Minneapolis. He has created BI solutions for clients across a wide spectrum of industries, including health care, finance, manufacturing, insurance, and numerous others.
Dan English, MVP, MCITP, is a Microsoft SQL Server MVP, a MCITP Business Intelligence Developer for Microsoft SQL Server 2005 and 2008, and an MCTS for Microsoft Office SharePoint Server 2007 – Configuring. Dan is a Principal BI consultant at Superior Consulting Services. He currently helps to lead the Minnesota Business Intelligence User Group and is an avid blogger (http://denglishbi.wordpress.com), Microsoft forums helper, and tweeter (@denglishbi).
Paul Purington, MCITP, is a partner and member of the management team at Superior Consulting Services. As a BI consultant, Paul has experience with both large and small-scale business intelligence environments.
Table of Contents
Part 1: Using Power View
1. Getting Started
2. The Table Visualization
3. Additional Visualizations
5. Bringing Your Data to Life
6. Sharing Reports
Part 2: Creating BI Semantic Models
7. BISM: Getting Started
8. Basic BI Semantic Model Design
9. BI Semantic Model: Additional Model Features
10. Using DAX Expressions
11. Deploying Tabular BI Semantic Models
Part 3: Appendixes
A. Installing and Configuring the Sample Data
B. Creating a Virtual Learning Environment
Most Helpful Customer Reviews