Integration Services (SSIS) and Studio Environments Integration Services (SSIS) Packages Integration Services (SSIS) Connections Integration Services (SSIS) Projects Top 10 Common Transformations in SSIS: Additional resources and readings: Module 6: OLAP Core required readings Video introduction What is OLAP from Intricity? What is Business Intelligence and an OLAP Cube from ExcelCentral.com: OLAP tutorial from TutorialsPoint: and also some good visuals from Lutz Database Queries, Data Mining and OLAP, The Encyclopedia of Data Warehousing and Mining, 2nd Edition, Idea Group Publishers, 2008. Lecture with references: olap.pdf SSAS labs and tutorials see lab 6 – Additional readings and resources: The origins of today’s OLAP products: OLAP AND OLAP Server Definitions: Module 7: Multidimensional Data Analysis Required readings Demo: Explore Adventure in Excel by using an OLAP PivotTable report: Using Excel to interact with a SSAS cube (it is for earlier version but very similar in 2013): Excel Cube functions Quick overview: Excel OLAP pivot table extension: Lecture notes with references: olap query.pdf Resources listed in the lab 7, including two tutorials by the instructor on Excel pivot table and cube functions. Additional readings and resources: Layout and format of Excel pivot table: Select data in a pivot table: OLAP server action:
Integration Services (SSIS) and Studio Environments Integration Services (SSIS) Packages Integration Services (SSIS) Connections Integration Services (SSIS) Projects Top 10 Common Transformations in SSIS: Additional resources and readings: Module 6: OLAP Core required readings Video introduction What is OLAP from Intricity? What is Business Intelligence and an OLAP Cube from ExcelCentral.com: OLAP tutorial from TutorialsPoint: and also some good visuals from Lutz Database Queries, Data Mining and OLAP, The Encyclopedia of Data Warehousing and Mining, 2nd Edition, Idea Group Publishers, 2008. Lecture with references: olap.pdf SSAS labs and tutorials – see lab 6 Additional readings and resources: The origins of today’s OLAP products: OLAP AND OLAP Server Definitions: Module 7: Multidimensional Data Analysis Required readings Demo: Explore Adventure in Excel by using an OLAP PivotTable report: Using Excel to interact with a SSAS cube (it is for earlier version but very similar in 2013): Excel Cube functions Quick overview: Excel OLAP pivot table extension: Lecture notes with references: olap query.pdf Resources listed in the lab 7, including two tutorials by the instructor on Excel pivot table and cube functions. Additional readings and resources: Layout and format of Excel pivot table: Select data in a pivot table: OLAP server action:
S119_Li.docx