文件列表:

Code SQL tham khao.txt (7571, 2023-02-21)
PHL_Project_Analysis Tabular Model (0, 2023-02-21)
PHL_Project_Analysis Tabular Model\Commit.zip (205227, 2023-02-21)
PHL_Project_DataWarehouse (0, 2023-02-21)
PHL_Project_DataWarehouse\Functions (0, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AA_cutoff].sql (13353, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AD_bridge].sql (775, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AD_info].sql (727, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AD_info_raw].sql (810, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AD_structure_bridge].sql (1221, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_AD_structure_wide].sql (866, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agency_bridge_AD_report_cutoff].sql (921, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agency_structure_bridge_report_cutoff].sql (1484, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agency_structure_map_bridge].sql (1226, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agency_structure_wide].sql (1053, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agency_structure_wide_report_cutoff].sql (757, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agent_AD_cutoff].sql (793, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agent_bridge_report_cutoff].sql (815, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agent_info_AD_cutoff].sql (779, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_agent_info_cutoff].sql (1851, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_cal_AD_preminum_cutoff].sql (16179, 2023-02-21)
PHL_Project_DataWarehouse\Functions\[DPO].[udf_month_diff].sql (1321, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures (0, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS (0, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\AD_BONUS_FULL_PROCESS_v2.sql (1100, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_DETAILAA].sql (4300, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_DETAILFYP].sql (8855, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_DETAILRYP].sql (5038, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_PROBATION].sql (7162, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_PY2_RATE].sql (2945, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_PY2_RATE_02.12.2022]_l_y theo report month.sql (2928, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_PY2_RATE_05.12.2022]_lo_i Ter Su.sql (3556, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_PY2_RATE_06.12.2022]_lo_i SFC.sql (4321, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_RADSTD_QTRLY].sql (12361, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_RYP_QTRLY].sql (4473, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_ZDSZD_MTHLY].sql (10478, 2023-02-21)
PHL_Project_DataWarehouse\Stored Procedures\AD_BONUS\[AD_BONUS_ZDSZD_MTHLY_add_INTRODUCTION_BONUS_FOR_SZD].sql (12393, 2023-02-21)
... ...

Summary: - Our company have many data sources from excel (almost), outlook, CORE system,... - With data from excel, outlook,... we conduct ETL by VBA(macro), Power Query, then insert tables to database. - IT provide 11 main tables for my deparment, they will run job insert/delete to refresh table everyday. - From all above data sources, our team build DW, Star Schema, Snowflake Schema model for my deparment based on business rules. - We create Views, Stored procedure, Functions, Table,....Store procedure run job to add data to tables daily. Tool: - Data Processing, ETL: VBA(macro), Power Query, SSMS. - Database: SQL Server - Analysis service: SSAS, Visual Studio (Tabular Model) - Visualization: Power BI Desktop Report Server Data flow: -  Model: - *Due to the company's privacy policy, I cannot share the data details.  

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：