1 / 14

Business Intelligence

Business Intelligence. Agenda. Business Intelligent - Microsoft Solution Business Intelligent Integrated Solutions in MOSS 2007. BI Modeling. Cubes. Source Systems/OLTP. Clients. SQL Server Data Warehouse. Analysis Services. Query Tools Reporting Analysis. 2. 1. 3. 4.

macon-guerrero
Download Presentation

Business Intelligence

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. Business Intelligence

  2. Agenda Business Intelligent - Microsoft Solution Business Intelligent Integrated Solutions in MOSS 2007

  3. BI Modeling Cubes Source Systems/OLTP Clients SQL ServerData Warehouse Analysis Services Query Tools Reporting Analysis 2 1 3 4 Design the Populate Create Query Data Warehouse Data Warehouse OLAP Cubes Data

  4. Table vs Cube • A simplified example: A typical relational table Make it into a cube Data are organized by rows Data are organized by intersections Sales table Region dim Product dim

  5. A Logical Cube - Example North South East West Products, Year, Price in South Products, Region, Price by 2000 Product Donut Sandwich Region The Sales$ by Soda by West in Yr of 2001 Milk North South $18.00 Soda East Beer West 1999 2000 2001 2002 Time

  6. Client Server Architecture Excel OLEDB ADOMD TCP Client Apps Analysis Server XMLA MOSS IIS AMO BIDS HTTP SSMS ADOMD .NET SSRS

  7. Analysis Services Database • An Analysis Services database is the top level container for other dependent objects: • A database includes • Data Source • Data Source View • Cube • Dimension • Security Role

  8. Creating an Analysis Services Database • You can use one of the following to create a new empty database on an instance of SQL Server 2005 Analysis Services. • SQL Server Management Studio • Business Intelligence Development Studio.

  9. Tools to connect to Cubes SQL Server Management Studio (SSMS) Business Intelligence Development Studio (BIDS) Query Analyzer (SSMS) – To write MDX Excel 2007 – Uses MDX

  10. Demo

  11. Analytic Applications End-user Tools BI Platform SQL Server 2005 Business IntelligenceIntegrated Solutions Business Scorecarding (Business Scorecard Manager) Portal (SharePoint Server 2007) End-user Analysis (Excel) Analysis Services (SSAS) Reporting Services (SSRS) Integration Services (SSIS) RDBMS

  12. Business Intelligence • Microsoft Office SharePoint Server is the “BI Portal and Report Center” for end users • Dashboards & Web components • Common filtering (“slicing”) across web parts • KPIs, Excel workbooks, and SQL 2005 Reporting Services reports • Report Center Websites • Out of the box website optimized for report access and management • Consistent management of reports, spreadsheets, and data connection • Integrated with SQL Server 2005 Reporting Services • Data Connection Libraries & Business Data Catalog • Centralize storage of important data connections

  13. Demo

  14. Thanks for your attention

More Related