Implement a Robust BI Solution with Microsoft SQL Server 2012
Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive resource.
- Understand the goals and components of successful BI
- Design, deploy, and manage data marts and OLAP cubes
- Load and cleanse data with SQL Server Integration Services
- Manipulate and analyze data using MDX and DAX scripts and queries
- Work with SQL Server Analysis Services and the BI Semantic Model
- Author interactive reports using SQL Server Data Tools
- Create KPIs and digital dashboards
- Use data mining to identify patterns, correlations, and clusters
- Implement time-based analytics
- Embed BI reports in custom applications using ADOMD.NET
About the Author
Brian Larson, MCSD, served as a member of the Reporting Services development team and has contributed to the code base. He is the Chief of Technology for Superior Consulting Services (SCS), a Microsoft Certified Partner currently developing a client solution that uses Microsoft Reporting Services for report production and distribution. Brian has been invited to speak on Reporting Services at several conferences, including SQL Server Magazine Connections, and has written articles for SQL Server Magazine.