Leverage the power of SQL and Office to build a complete enterprise BI solution
The business intelligence world is changing. Hardware is getting more powerful, platforms are getting more capable, and decision timeframes are getting shorter. Microsoft's SQL Server and Office products provide powerful core BI technologies that allow decision makers who rely on Office for basic analytics to tap into a sophisticated BI toolset for both analysis and reporting. Applied Microsoft Business Intelligence reveals the best practices for building complete BI solutions using SQL Server, Reporting, and Analysis Services along with Excel and SharePoint for a more robust business intelligence framework.
This book shows you how to use the Microsoft business intelligence building blocks to construct synergetic and complete solutions to suit any organization. Organized chronologically by implementation order, it guides you through the data layer, data transformation and quality, the semantic layer, and the presentation layer, and ties it all together with comprehensive case studies. Focusing on best practices rather than specific tools keeps your skills relevant beyond the 2014 SQL release. Comprehensive explanations including architecture, strengths and weaknesses, and practical applications bring you fully up to speed quickly.
Applied Microsoft Business Intelligence shows you how to:
Design an effective BI architecture that best fits your organization
Develop flexible, scalable, tabular and multi-dimensional models
Create interactive visualizations with Power View
Explore geographic and temporal data with Power Map
Implement self-service delivery and an efficient deployment strategy
Patrick LeBlanc is a Data Platform Technical Solution Professional at Microsoft, working directly with customers on the business value of SQL Server. He co-authored SharePoint 2010 Business Intelligence 24-Hour Trainer and Knight’s Microsoft Business Intelligence 24-Hour Trainer, and founded www.sqllunch.com, a website devoted to teaching SQL Server technologies.
Dejan Sarka is MCT and MCDBA certified and a Microsoft® MVP for SQL Server®. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.