1 / 14

MIS 4346/5346 Data warehousing

MIS 4346/5346 Data warehousing. Data Warehouse to BI. Agenda. Review Preparing the DW for Analysis Microsoft BI Platform Overview Building a Cube in SSAS. DW Development Approach: Kimball. Methodology DW Project Lifecycle Business requirements Business Requirements Documentation

gaille
Download Presentation

MIS 4346/5346 Data warehousing

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. MIS 4346/5346 Data warehousing Data Warehouse to BI

  2. Agenda • Review • Preparing the DW for Analysis • Microsoft BI Platform Overview • Building a Cube in SSAS

  3. DW Development Approach: Kimball • Methodology • DW Project Lifecycle • Business requirements • Business Requirements Documentation • Bus Matrix • Design, build and deliver in increments • DWArchitecture • DW Design • ETL system • Cube, Reports, query tools, …

  4. Data Warehouse Project Lifecycle Source: Mundy, Thornthwaite, and Kimball (2006). The Microsoft Data Warehouse Toolkit, Wiley Publishing Inc., Indianapolis, IN.

  5. DW Development Approach: Kimball • Methodology • DW Project Lifecycle • Business requirements • Business Requirements Documentation • Bus Matrix • Design, build and deliver in increments • DWArchitecture • DW Design • ETL system • Cube, Reports, query tools, …

  6. BI Application Specification, Development • Specification • Standard Reports • Layout-led discovery • Enrollments by course and timeframe • Average GPA by course and timeframe • Analytic Applications • Data and Model-led discovery • Year-to-year changes in average GPAs by college • Students most likely to have good overall GPAs • Development • (SSAS, Excel) Multidimensional Cube, Data-led discovery • (SSRS, Excel) Standard Reports • (SSAS, Excel) Mining Model-led discovery

  7. Displaying the Cube • Cube browser—resembles spreadsheet

  8. Displaying the Cube, cont… • Pivot table - a multidimensional spreadsheet

  9. OLAP Models

  10. Microsoft BI Platform RDL MDX, DMX SQL

  11. Microsoft BI Platform: Development Interfaces • SQL Server Database Engine • Interface: SSMS • SQL Server Integration Services • Interface: SSDT • SQL Server Analysis Services • Interface: SSDT • SQL Server Reporting Services • Interface: SSDT • MS Office Excel Data Mining Add-In

  12. Preparing the Data Warehouse for Analysis • Build a multidimensional cube • Refine • Create KPIs… • Design reports • Design mining models • Deploy cube, reports, models to the server

  13. Building an Analysis Services Cube • Create: • Data Source • Data Source View • Cube • Deploy/Process Cube • Use the Cube • OLAP Analysis • Reports • Data Mining Models

  14. Example http://www.accelebrate.com/sql_training/ssas_2008_tutorial.htm

More Related