Download
mis 4346 5346 data warehousing n.
Skip this Video
Loading SlideShow in 5 Seconds..
MIS 4346/5346 Data warehousing PowerPoint Presentation
Download Presentation
MIS 4346/5346 Data warehousing

MIS 4346/5346 Data warehousing

148 Vues Download Presentation
Télécharger la présentation

MIS 4346/5346 Data warehousing

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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