Building Integrated Business Intelligence Solutions with SQL by Stacia Misner, Philo Janus

By Stacia Misner, Philo Janus

Master Microsoft's enterprise Intelligence Tools

Building built-in company Intelligence ideas with SQL Server 2008 R2 & workplace 2010 explains easy methods to take complete benefit of Microsoft's collaborative company intelligence (BI) instruments. various strong, versatile applied sciences are lined, together with SQL Server research companies (SSAS), Excel, Excel prone, PowerPivot, SQL Server Integration providers (SSIS), Server Reporting prone (SSRS), SharePoint Server 2010, PerformancePoint prone, and grasp information prone. This sensible consultant makes a speciality of deveoloping end-to-end BI recommendations that foster knowledgeable choice making.

• Create a multidimensional shop for aggregating enterprise information with SSAS
• Maximize the research features of Excel and Excel Services
• mix info from various assets and attach facts for research with PowerPivot
• stream facts into the process utilizing SSIS, InfoPath, Streamsight, and SharePoint 2010 exterior Lists
• construct and submit reviews with SSRS
• combine information from disparate purposes, utilizing SharePoint 2010 BI features
• Create scorecards and dashboards with PerformancePoint Services
• Summarize huge volumes of information in charts and graphs
• Use the SSRS map characteristic for complicated visualizations of spatial data
• discover styles and relationships in info utilizing the SSAS facts mining engine
• deal with grasp info administration with grasp facts Services
• post the parts of your BI answer and practice administrative projects

Show description

Read Online or Download Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 PDF

Best microsoft books

Microsoft Excel 2010: Introductory

Microsoft workplace Excel 2010: Introductory presents a project-based, step by step method of effectively train scholars Microsoft Excel 2010 abilities.

VBA and Macros for Microsoft Excel

I acquired the ebook as anticipated. There're no challenge with package deal or maybe with the book.

MCITP Microsoft Windows Vista : desktop support consumer study guide (70-623)

When you are a help specialist who units up, continues, and troubleshoots laptop functions on home windows Vista, you can now construct your abilities and get ready for examination 70-623, MCITP: aiding and Troubleshooting functions on a home windows Vista customer for shopper aid Technicians, the necessary examination for reaching certification as an MCITP: purchaser help Technician.

Beginning SharePoint 2010 Administration: Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010

Written via a four-time SharePoint MVP, Beginning SharePoint 2010 management examines the diversities among SharePoint beginning (SPF) and SharePoint Server (SPS) and exhibits you the way to exploit all SharePoint 2010's many advancements. acceptable for experts and IT pros who have to know the way to plot, enforce, and configure SharePoint, directors and the help group that needs to understand how to control SharePoint, and  IT managers and venture leaders it assumes no past wisdom of SharePoint.

Extra info for Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010

Sample text

Generally, in scorecard tools, KPIs can be rolled up so that the objectives, even though they are not directly linked to data, have scores and indicators. The goal here is that a complex scorecard, perhaps with dozens of KPIs, can still provide an easy way to identify problem areas at a glance. For example, consider the scorecard in Figure 1-13. Note that a quick scan of the objectives will show them all as green (round), except for Profit Margin—that objective is yellow (triangular). Looking at the subordinate KPIs shows a number of metrics in 17 18 Building Integrated Business Intelligence Solutions Figure 1-12 A scorecard showing sales values Figure 1-13 A hierarchical scorecard Chapter 1: What Is Business Intelligence?

The same advice applies here, on top of the initiative. A project group may be tempted to create key performance indicators for every aspect of a business, map out the data requirements in advance, distill the required metrics, and so on. In The Balanced Scorecard: Translating Strategy into Action (Harvard Business Press, 1996) by Drs. Kaplan and Norton, they indicate that a working balanced scorecard can be implemented in 16 weeks. Obviously, with only four months to work with, you’re not going to create metrics for every facet of the company.

There may also be a historic value (last quarter or last year). Next is what brings our scorecard to life—the target value. This KPI has two target values, a short-term and a long-term, but we’ll focus on the short term target. Note that we have a target value (85 percent) and an indicator. Generally, you are able to set thresholds on the indicator as to when it changes from green to yellow to red. NOTE You’re not limited to green, yellow, and red. Most scorecard packages will allow you to select from different indicators or even design your own (we had a customer with a scorecard for a helicopter assembly line—they created an indicator that used red, yellow, and green helicopters).

Download PDF sample

Rated 4.46 of 5 – based on 12 votes