1 / 15

Microsoft Business Intelligence Environment Overview

Microsoft Business Intelligence Environment Overview. BI Environment Overview. Business Intelligence Suite consisting of Office 2010, Sharepoint 2010 and SQL Server 2010. Designed to provide easy access to the wealth of information contained in your data.

kavindra-gaurhari
Télécharger la présentation

Microsoft Business Intelligence Environment Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Business Intelligence Environment Overview

  2. BI Environment Overview • Business Intelligence Suite consisting of Office 2010, Sharepoint 2010 and SQL Server 2010. • Designed to provide easy access to the wealth of information contained in your data. • “Business Intelligence solutions enable IT departments to proactively empower users with self-service capabilities while retaining the ability to monitor, manage, and govern the data and solutions that users create.”

  3. BI Environment Overview • Institutional Analysis and Planning’s (IAP) implementation of the BI Suite • Report User Experience • Demonstration of the reporting environment the user sees and the export functionality • Cube User Experience • Demonstration of the Cube environment • Developer Experience • Construction and Structure of cubes

  4. Report User Experience • What does the end user see? • What are Reports?

  5. Cube User Experience • Accessed through Excel pivot tables • Leverages already existing user experience in Excel • Drill through for detailed comparisons • Excel does not directly access the data, data is provided through Analysis Services.

  6. Cube Demo • How many students are in a specific class? • What was the average grade of the class? • How many students were in housing and were their grades different?

  7. Developer Experiences • Reports • Cubes • Database structure

  8. Report Creation • Database connection (Data Source) • Queries on the Data Source (Datasets) • Tables of data like pivot tables (Tablix) • Charts • Report Parameters • Reuse of created content (Report Parts and Sub-reports)

  9. Cube Creation • Dimensions, Measures, Calculated Measures, KPIs • Relationships between measures and dimensions • How the cube deals with many-to-many joins

  10. SQL Server Integration Services SSIS

  11. SSIS in BI Developer Studio

  12. Database Structure • Snowflake Schema – Lessons Learned • Fact and Dimension tables • Foreign Key Constraints for Data Integrity

  13. Database Structure

  14. Server Architecture Campus Web and Excel Access SSIS Oracle Server SSAS Shared SQL Server SSRS Web Reporting and Analysis Services

  15. Questions?

More Related