2120 - 从电子表格到数据立方体：分解开发流程以提供更佳的业务洞察力.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Wilson O.Quiles VazquezSr.IT Applications Analyst,Century CommunitiesSession 2120 Spreadsheets to cubes:Breaking down the development process to provide better business insightAgenda010203040506Problem Scenarios Key Players Challenges Development Process Summa

2、ry IBM TechXchange|2025 IBM CorporationWhat will you learn?010203Common Scenarios Breakdown of Development Process Tips and Tricks IBM TechXchange|2025 IBM CorporationWhat is the problem?Transitioning from spreadsheet-based models to multidimensional models in IBM Planning Analytics 4IBM TechXchange

3、|2025 IBM CorporationScenario 1File ExplorerIBM TechXchange|2025 IBM Corporation5Scenario 2Email threadIBM TechXchange|2025 IBM Corporation6Scenario 3Spreadsheet tabsIBM TechXchange|2025 IBM Corporation7Who are the key players?IBM TechXchange|2025 IBM Corporation8AccountingFinanceMarketingSalesCXOsP

4、A DeveloperProject ManagerBusiness AnalystDev/IT OpsDBABusinessITUnderstanding their point of viewIBM TechXchange|2025 IBM Corporation9ReportsInputsSpreadsheetsKPIsSystemsCubesDimensionsCode(MDX,SQL,Python)Turbointegrator processesDataBusinessITChallenges with spreadsheetsNo version controlUser main

5、tainedHeavy manual stepsError prone and isolatedIBM TechXchange|2025 IBM Corporation10Benefits of using cubesDynamicCan be organized by functional areas,purposeCentralizedIBM TechXchange|2025 IBM Corporation11Single source of truthData from multiple sourcesMutiple levels to view data(rollups,histori

6、cal,etc.)Status QuoCubesSpreadsheetsIBM TechXchange|2025 IBM Corporation12How do we go from spreadsheets-based models to multidimensional cubes?IBM TechXchange|2025 IBM Corporation13Development ProcessPrototypingTechnical DesignAutomationIBM TechXchange|2025 IBM Corporation14UX DesignReportingDocume