Databases Reference
In-Depth Information
Note
Microsoft announced in the last SQL PASS that Power View will be able to build on
top of existing multidimensional cube data. This is evidence of Microsoft's commitment
to support multidimensional data.
Working together: SQL Server 2012 + SharePoint 2013 +
Office 2013
Microsoft SQL Server has traditionally been a one-stop shop for customers seeking to implement BI
solutions. As a corporate BI solution, companies use SQL Server to move data from disparate sources
in an extract, transform, and load (ETL) process; develop solutions to make multidimensional and tab-
ular data available; and use products such as SQL Server Reporting Services and Excel to build reports
from relational, tabular, and multidimensional databases. Figure 3-2 shows a variation of a down-
loadable poster on TechNet (
http://www.microsoft.com/downloads/details.aspx?familyid=FC97D587-
FFA4-4B43-B77D-958F3F8A87B9&displaylang=en
)
. The illustration shows the larger picture of how
SQL Server 2012, SharePoint 2013, and Microsoft Office 2013 work together to deliver data that helps
business users.
Note
Microsoft BI authoring tools are available in all three layers shown in the Figure 3-2.
Some tools come from SQL Server, such as Report Builder; some, like PerformancePoint, are
in SharePoint; and others are in Office, including Excel and Visio. To learn more about these
tools, see Chapter 2, “Planning for business intelligence adoption.”
You use SharePoint Server in conjunction with SQL Server Reporting Services, Visio, Performance-
Point, and Excel to show BI data in meaningful and productive ways. SQL Server provides the primary
data infrastructure and BI platform that gives report authors and business users trusted, scalable, and
secure data.
Note
You can now use PowerPivot in Excel 2013 when you need to “mash-up” data; that
is, when your data comes from disparate sources, such as SQL, Teradata or Oracle, spread-
sheets, the cloud, and SharePoint lists.
Search WWH ::
Custom Search