Microsoft Office Tutorials and References
In Depth Information
You already know that data can be migrated from different data sources—such as databases,
flat files, XML, Excel, and so forth—to a single OLAP system of your choice. OLAP tools
provide the necessary framework to accomplish this.
Migrating data from OLTP to OLAP is as good as copying and pasting your enterprise
database. Clean up the data either during staging or during the transformation process to
avoid unwanted data.
What you have in many tables in your OLTP database might be aggregated into a single table
or even one column.
Move to more sophisticated and structured cubes. Review decision support systems and
data-mining systems, and choose your model accordingly.
Use the features of ETL tools efficiently for migration.
SQL Server 2012 Analysis Services Tabular Model
With SQL Server 2012, Microsoft introduced a new data model called Tabular Model. Tabular models are in-memory
databases in Analysis Services. They are simpler than the conventional Multidimensional models (which we have
discussed so far) and do not support all of the advanced multidimensional model features. If you are familiar with
PowerPivot, you might not find tabular modeling a completely new concept. In fact, Tabular Model can also be
viewed as an enhancement of the current PowerPivot data model experience. Tabular Model employs the xVelocity
in-memory analytics engine (the next generation of the VertiPaq engine that was introduced in SQL Server 2008 R2,
with PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010) which enables it to perform complex analytics
on data, in-memory. The engine delivers fast access to Tabular Model objects and data, with minimal IO operations.
If you have a relational database background, you might find Tabular Model easier to build than the conventional
We will explore Tabular Model further in later chapters when we discuss Power View and PowerPivot.
SharePoint and Business Intelligence
What do you have so far?
SharePoint Server 2010 has decent capabilities relating to BI integration. Major components include Visio
Services, Reporting Services and Power View, PerformancePoint Services, Excel and PowerPivot and Business
SSIS components can extract information from various data sources, and load it into Excel.
It then can be published back into SharePoint. This opens up possibilities for seamless end-to-end
integration and collaboration using the portals.
Business applications use powerful out-of-the-box web parts that can display their KPIs
(Key Performance Indicators).
BCS (Business Connectivity Services) provides a mechanism for integrating external data
sources into the system.
What’s New in SharePoint 2013?
SharePoint 2013 adds significantly more BI functionality. In the following chapters, we will cover each of the
SharePoint 2013 BI components in depth. Here’s a preview.
Search JabSto ::