Databases Reference
In-Depth Information
FIGURE 2-2 BI communities.
Organizational BI
Some popular ways to deliver BI to all employees in a company are to provide access to metrics that
show progress toward organizational goals or to compare a current state to historical trends. Ideally,
users of organizational BI can break down this information to see how their individual departments
contribute to current conditions. Because the intended audience of information is the entire company,
you can anticipate that the audience consists largely of information users and information consum-
ers. Therefore, an organizational BI solution needs to support only online viewing, with limited
interaction.
Typically, this information comes from approved data sources that have been staged, transformed,
and restructured into a data warehouse. Ideally, this data has also been incorporated into an Analysis
Services cube or tabular model to provide both faster reporting to all business users and more flexible
analysis for the power analysts.
Whether the data is stored in a relational database, a cube, or a tabular data model, the three
primary tools for consuming this data at the organizational level are Excel Services, PerformancePoint
Services, and Reporting Services, which you learn more about in Chapter 3. Excel Services, Perfor-
mancePoint Services, and Power View require a SharePoint Server 2013 Enterprise installation, with
scalability achieved by setting up a SharePoint farm to distribute the workload. Reporting Services
Search WWH ::




Custom Search