Mastering Excel: Power Pivot – Mark Moore

Description:

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

Category:Computer Technology, Nonfiction