实现数据仓库模式。为ETL过程采用SSIS,并结合用于动态数据传输的渐变维度(SCD)。利用SSAS进行了分析。利用Power BI和Tableau创建交互式仪表板。
implementing data warehouse schema. Employed SSIS for ETL processes, incorporating Slowly Changing Dimension(SCD) for dynamic data transfer. Used SSAS to make some analysis. Utilized Power BI and Tableau to craft an interactive dashboard. (2024-03-16, TSQL, 0KB, 下载0次)