Synopses & Reviews
Master the business intelligence tools in the latest release of Microsoft SQL Server
Fully updated for the new version of SQL Server, Delivering Business Intelligence with Microsoft SQL Server XXXX, Third Edition is a complete BI course in a book. It begins with a discussion of BI, defining what it is and why it is important in today's business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering the BI. Several analysis databases are built and used for examples throughout the book. The examples give a complete description of each process, so you will able to complete similar tasks on your own data using all the BI tools available in SQL Server.
Delivering Business Intelligence with Microsoft SQL Server XXXX, Third EditionProvides a complete understanding of the BI lifecycle and the Microsoft tools designed to handle each step in that lifecycleFeatures step-by-step, start-to-finish instructions that lead you through the creation of complete processes and solutionsIncludes example scenarios that place the BI concepts and Microsoft tools in a real-world context and assist you in applying this knowledge to particular business situationsOffers free downloadable code
Synopsis
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
Synopsis
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