Silicon Valley Big Data Project Data Warehouse 5.0 Preview Edition

Silicon Valley Big Data Project Data Warehouse 5.0 Preview Edition

Silicon Valley Big Data Project Data Warehouse 5.0 Preview Edition

Introduction to the advance version of Data Warehouse 5.0 of the Silicon Valley Big Data Project:

Course Catalog

Data collection of Silicon Valley big data technology

1. Data warehouse demand analysis.mkv

2_Cluster Building Notes.mkv

3_Cluster Planning.mkv

4_Physical machine memory planning.mkv

5_Alibaba Cloud Server Basic Configuration.mkv

6_JavaInstallation.mkv

7_Alibaba Cloud Framework Installation.mkv

8_The source of log data in the production environment.mkv

9_Simulation log generation module usage guide.mkv

10_awk processes text.mkv

11_Kafka cluster deployment.mkv

12_Kafka producer performance test.mkv

13_kafka consumer performance test.mkv

14_Kafka server and partition number calculation.mkv

1_Script preparation.mkv

2_Hadoop framework configuration.mkv

3_Datanode multi-directory configuration.mkv

4_Data storage balance.mkv

5_Hadoop LZO compression format supports .mkv

6_Test HDFS read and write performance.mkv

7_Test HDFS sorting performance.mkv

8_Cluster Parameters Tuning.mkv

9_Zookeeper installation.mkv

Extra Chapter_xcall Explanation.mkv

1_Alibaba Cloud Security Group.mkv

2_Collect Flume architecture selection.mkv

3_Customize FlumeInterceptor.mkv

4_Collect Flume configuration files and scripts.mkv

5_Change logban configuration.mkv

6_Downstream Flume architecture selection.mkv

7_Write downstream Flume timestamp interceptor.mkv

8_Downstream Flume configuration.mkv

9_Log collection cluster overall test and switch script.mkv

08-Collection Project-Review-Business Data-Data Synchronization Overview.mp4

09-Collection Project-Review-Business Data-Data Synchronization Strategy Selection.mp4

10-Collection Project-Review-Business Data-Data Synchronization Tool Selection.mp4

11-Collection Project-Collection Tool-DataX-Overview.mp4

12-Collection Project-Collection Tool-DataX-Design Concept.mp4

13-Collection Project-Collection Tool-DataX-Operation Process.mp4

14-Collection Project-Collection Tool-DataX-Sqoop Comparison.mp4

15-Collection Project-Collection Tool-DataX-Deployment.mp4

16-Collection Project-Collection Tool-DataX-Usage Overview.mp4

17-Collection Project-Collection Tool-DataX-Mysql to HDFS Case 1.mp4

01-Collection Project-Business Data-Synchronization Tool-DataX-Review.mp4

02-Collection Project-Business Data-Synchronization Tool-DataX-Mysql to HDFS Case 2.mp4

03-Collection Project-Business Data-Synchronization Tool-DataX-Parameter Transfer Function.mp4

04-Collection Project-Business Data-Synchronization Tool-DataX-MysqlReader Two Modes Comparison.mp4

05-Collection Project-Business Data-Synchronization Tool-DataX-HDFS to MySQL Case-Parameter Description.mp4

06-Collection Project-Business Data-Synchronization Tool-DataX-HDFS to MySQL Case-Test.mp4

07-Collection Project-Business Data-Synchronization Tool-DataX-Optimization-Flow Control.mp4

08-Collection Project-Business Data-Synchronization Tool-DataX-Optimization-Memory Adjustment.mp4

09-Collection Project-Business Data-Synchronization Tool-Maxwell-Overview.mp4

10-Collection Project-Business Data-Synchronization Tool-Maxwell-Output Format.mp4

11-Collection Project-Business Data-Synchronization Tool-Maxwell-Principle.mp4

12-Collection Project-Business Data-Synchronization Tool-Maxwell-Installation Instructions.mp4

13-Collection Project-Business Data-Synchronization Tool-Maxwell-mysql Start Binlog.mp4

14-Collection Project-Business Data-Synchronization Tool-Maxwell-MySQL Database Construction.mp4

15-Collection Project-Business Data-Synchronization Tool-Maxwell-Configuration.mp4

16-Collection Project-Business Data-Synchronization Tool-Maxwell-Channel Test.mp4

17-Collection Project-Business Data-Synchronization Tool-Maxwell-Start and Stop Script.mp4

18-Collection Project-Business Data-Synchronization Tool-Maxwell-Full Synchronization.mp4

01-Collection Project-Business Data-Full Scale Synchronization-Data Channel.mp4

02-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Description.mp4

03-Collection Project-Business Data-Full Scale Synchronization-DataX Data Synchronization Test.mp4

04-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Generation Script Instructions.mp4

05-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Generation Script Test.mp4

06-Collection project-Business data-Full table synchronization-DataX configuration file one-click generation script.mp4

07-Collection Project-Business Data-Full Scale Synchronization-Data Synchronization Script.mp4

08-Collection Project-Business Data-Full Scale Synchronization-Data Synchronization Script-Test.mp4

09-Collection Project-Business Data-Full Scale Synchronization-Summary.mp4

10-Collection Project-Business Data-Full Table Synchronization-Supplement-Python-MySQL Driver Installation Instructions.mp4

11-Collection Project-Business Data-Incremental Table Synchronization-Data Channel Description.mp4

12-Collection Project-Business Data-Incremental Table Synchronization-Maxwell Configuration-Description.mp4

13-Collection Project-Business Data-Incremental Table Synchronization-Maxwell Configuration-Test.mp4

14-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration Instructions.mp4

15-Collection Project-Business Data-Incremental Table Synchronization-Flume Solution Finalization.mp4

16-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Configuration File Description.mp4

17-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Practical Operation.mp4

18-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Test.mp4

19-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Start and Stop Scripts.mp4

20-Collection Project-Business Data-Incremental Table Synchronization-Full Synchronization on the First Day.mp4

21-Collection Project-Business Data-Incremental Table Synchronization-Summary.mp4

Silicon Valley Big Data Technology: E-commerce Data Warehouse

01-Data Warehouse-Overview.mp4

02-Collection Project-Review-User Behavior Log-Log Content.mp4

03-Collection Project-Review-User Behavior Log-Log Structure.mp4

04-Collection Project-Review-User Behavior Log-Data Channel.mp4

05-Collection Project-Review-User Behavior Log-Replace Simulator.mp4

06-Collection Project-Review-User Behavior Log-Collection Channel Demonstration.mp4

07-Collection Project-Review-Business Data-E-commerce Terms-1.mp4

01-Collection Project-Review-Business Data-Common Sense-2.mp4

02-Collection Project-Review-Business Data-Familiarity with Data-Overview.mp4

03-Collection Project-Review-Business Data-Familiar with Data-First Step.mp4

04-Collection Project-Review-Business Data-Familiarize Yourself with the Data-Step 2-1.mp4

05-Collection Project-Review-Business Data-Familiarize Yourself with the Data-Step 2-2.mp4

06-Collection Project-Review-Business Data-Familiarize Yourself with the Data-Step 3.mp4

07-Collection Project-Review-Business Data-Replace Simulator.mp4

08-Collection Project-Review-Business Data-Data Synchronization Overview.mp4

09-Collection Project-Review-Business Data-Data Synchronization Strategy Selection.mp4

10-Collection Project-Review-Business Data-Data Synchronization Tool Selection.mp4

11-Collection Project-Collection Tool-DataX-Overview.mp4

12-Collection Project-Collection Tool-DataX-Design Concept.mp4

13-Collection Project-Collection Tool-DataX-Operation Process.mp4

14-Collection Project-Collection Tool-DataX-Sqoop Comparison.mp4

15-Collection Project-Collection Tool-DataX-Deployment.mp4

16-Collection Project-Collection Tool-DataX-Usage Overview.mp4

17-Collection Project-Collection Tool-DataX-Mysql to HDFS Case 1.mp4

01-Collection Project-Business Data-Synchronization Tool-DataX-Review.mp4

02-Collection Project-Business Data-Synchronization Tool-DataX-Mysql to HDFS Case 2.mp4

03-Collection Project-Business Data-Synchronization Tool-DataX-Parameter Transfer Function.mp4

04-Collection Project-Business Data-Synchronization Tool-DataX-MysqlReader Two Modes Comparison.mp4

05-Collection Project-Business Data-Synchronization Tool-DataX-HDFS to MySQL Case-Parameter Description.mp4

06-Collection Project-Business Data-Synchronization Tool-DataX-HDFS to MySQL Case-Test.mp4

07-Collection Project-Business Data-Synchronization Tool-DataX-Optimization-Flow Control.mp4

08-Collection Project-Business Data-Synchronization Tool-DataX-Optimization-Memory Adjustment.mp4

09-Collection Project-Business Data-Synchronization Tool-Maxwell-Overview.mp4

10-Collection Project-Business Data-Synchronization Tool-Maxwell-Output Format.mp4

11-Collection Project-Business Data-Synchronization Tool-Maxwell-Principle.mp4

12-Collection Project-Business Data-Synchronization Tool-Maxwell-Installation Instructions.mp4

13-Collection Project-Business Data-Synchronization Tool-Maxwell-mysql Start Binlog.mp4

14-Collection Project-Business Data-Synchronization Tool-Maxwell-MySQL Database Construction.mp4

15-Collection Project-Business Data-Synchronization Tool-Maxwell-Configuration.mp4

16-Collection Project-Business Data-Synchronization Tool-Maxwell-Channel Test.mp4

17-Collection Project-Business Data-Synchronization Tool-Maxwell-Start and Stop Script.mp4

18-Collection Project-Business Data-Synchronization Tool-Maxwell-Full Synchronization.mp4

01-Collection Project-Business Data-Full Scale Synchronization-Data Channel.mp4

02-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Description.mp4

03-Collection Project-Business Data-Full Scale Synchronization-DataX Data Synchronization Test.mp4

04-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Generation Script Instructions.mp4

05-Collection Project-Business Data-Full Table Synchronization-DataX Configuration File Generation Script Test.mp4

06-Collection project-Business data-Full table synchronization-DataX configuration file one-click generation script.mp4

07-Collection Project-Business Data-Full Scale Synchronization-Data Synchronization Script.mp4

08-Collection Project-Business Data-Full Scale Synchronization-Data Synchronization Script-Test.mp4

09-Collection Project-Business Data-Full Scale Synchronization-Summary.mp4

10-Collection Project-Business Data-Full Table Synchronization-Supplement-Python-MySQL Driver Installation Instructions.mp4

11-Collection Project-Business Data-Incremental Table Synchronization-Data Channel Description.mp4

12-Collection Project-Business Data-Incremental Table Synchronization-Maxwell Configuration-Description.mp4

13-Collection Project-Business Data-Incremental Table Synchronization-Maxwell Configuration-Test.mp4

14-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration Instructions.mp4

15-Collection Project-Business Data-Incremental Table Synchronization-Flume Solution Finalization.mp4

16-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Configuration File Description.mp4

17-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Practical Operation.mp4

18-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Test.mp4

19-Collection Project-Business Data-Incremental Table Synchronization-Flume Configuration-Start and Stop Scripts.mp4

20-Collection Project-Business Data-Incremental Table Synchronization-Full Synchronization on the First Day.mp4

21-Collection Project-Business Data-Incremental Table Synchronization-Summary.mp4

01-Review of the problem.mp4

02-Data Warehouse-Overview.mp4

03-Data Warehouse-Data Modeling Overview-Significance.mp4

04-Data Warehouse-Data Model-ER Model-Overview.mp4

05-Data Warehouse-Data Model-ER Model-Conceptual Description.mp4

06-Data warehouse-data model-ER model-relational model correspondence.mp4

07-Data warehouse-Data model-ER model-Database normalization.mp4

08-Data warehouse-Data model-ER model-Three paradigms-Functional dependency.mp4

09-Data Warehouse-Data Model-ER Model-Three Paradigms-Description.mp4

10-Data warehouse-data model-ER model-example analysis.mp4

11-Data warehouse-data model-dimensional model.mp4

12-Data Warehouse-Data Model-Dimensional Model-Fact Table-Overview.mp4

13-Data warehouse-data model-dimensional model-fact table-transaction fact table-overview.mp4

14-Data warehouse-data model-dimensional model-fact table-transaction fact table-design process.mp4

15-Data warehouse-data model-dimensional model-fact table-transaction fact table-deficiencies.mp4

16-Data warehouse-data model-dimensional model-fact table-periodic snapshot fact table-overview.mp4

17-Data warehouse-data model-dimensional model-fact table-periodic snapshot fact table-design process.mp4

18-Data warehouse-Data model-Dimensional model-Fact table-Periodic snapshot fact table-Fact type.mp4

19-Data warehouse-data model-dimensional model-fact table-cumulative snapshot fact table-overview.mp4

20-Data warehouse-data model-dimensional model-fact table-cumulative snapshot fact table-design process.mp4

21-Data warehouse-data model-dimensional model-fact table-summary.mp4

01-Data Warehouse-Dimensional Modeling-Fact Table-Review.mp4

02-Data warehouse-Dimensional modeling-Fact table-Periodic snapshot fact table-Synchronization strategy description.mp4

03-Data Warehouse-Dimensional Modeling-Dimensional Table-Overview.mp4

04-Data warehouse-dimensional modeling-dimensional table-design process.mp4

05-Data warehouse-dimensional modeling-dimensional table-design points-normalization & denormalization.mp4

06-Data warehouse-dimensional modeling-dimensional table-design points-dimensional changes-full snapshot table.mp4

07-Data warehouse-Dimensional modeling-Dimensional table-Design points-Dimensional changes-Zipper table.mp4

08-Data warehouse-dimensional modeling-dimensional table-design points-multi-value dimension.mp4

09-Data warehouse-dimensional modeling-dimensional table-design points-multi-value attributes.mp4

10-Data warehouse-dimensional modeling-impact on synchronization strategy.mp4

11-Data Warehouse-Design-Hierarchical Planning.mp4

12-Data warehouse-design-data warehouse construction process.mp4

13-Data warehouse-design-data warehouse construction process-data research.mp4

14-Data warehouse-design-data warehouse construction process-clarify data domain.mp4

15-Data warehouse-design-data warehouse construction process-construction bus matrix.mp4

16-Data warehouse-design-data warehouse construction process-clarify statistical indicators-indicator system concept.mp4

17-Data warehouse-design-data warehouse construction process-clarify statistical indicators-significance for modeling.mp4

01-Data Warehouse-Design-Process Review.mp4

02-Data warehouse-design process-clarify statistical indicators-supplement.mp4

03-Data Warehouse-Design Process-Summary.mp4

04-Data Warehouse-Environment Preparation-Design Process-Supplement.mp4

05-Data warehouse-environment preparation-operating environment-computing environment description.mp4

06-Data Warehouse-Environment Preparation-Operation Environment-Compatibility Issue Description.mp4

07-Data Warehouse-Environment Preparation-Operation Environment-Hive Environment Detection.mp4

08-Data Warehouse-Environment Preparation-Operation Environment-Hive-on-Spark Environment Configuration.mp4

09-Data Warehouse-Environment Preparation-Operation Environment-Hive-on-Spark Environment Test.mp4

10-Data warehouse-environment preparation-operating environment-yarn environment configuration.mp4

11-Data warehouse-environment preparation-operating environment-Hive-on-spark error troubleshooting ideas.mp4

12-Data Warehouse-Environment Preparation-Development Environment-DataGrip Instructions.mp4

13-Data Warehouse-Environment Preparation-Data Preparation-Part 1.mp4

14-Data Warehouse-Environment Preparation-Data Preparation-Part 2.mp4

15-Data Warehouse-Development-ODS Layer-Design Points.mp4

16-Data warehouse-development-ODS layer-log table-design ideas.mp4

17-Data Warehouse-Development-ODS Layer-Log Table-JSONSerde Description.mp4

18-Data Warehouse-Development-ODS Layer-Log Table-JSON Table-Demo.mp4

19-Data Warehouse-Development-ODS Layer-Log Table-JSON Table-Nested Structure Description-Part 1.mp4

20-Data Warehouse-Development-ODS Layer-Log Table-JSON Table-Nested Structure Description-Next.mp4

21-Data Warehouse-Development-ODS Layer-Log Table-Create Table Statement.mp4

22-Data Warehouse-Development-ODS Layer-Log Table-Data Loading.mp4

01-Data Warehouse-Hive Complex Data Types-Review.mp4

02-Data Warehouse-Hive-get_json_object-Function Description.mp4

03-Data Warehouse-Development-ODS Layer-Log Table-Data Loading Script.mp4

04-Data Warehouse-Development-ODS Layer-Business Table-Data Structure Review.mp4

05-Data warehouse-Development-ODS layer-Business table-Full table-Create table statement.mp4

06-Data Warehouse-Development-ODS Layer-Business Table-Incremental Table-Creating Table Statement.mp4

07-Data Warehouse-Development-ODS Layer-Business Table-Table Creation Operation.mp4

08-Data warehouse-Development-ODS layer-Business table-Data loading script.mp4

09-Data Warehouse-Development-HiveServer2 Problem Description.mp4

10-Data Warehouse-Development-DataGrip metadata display abnormal problem description.mp4

11-Data warehouse-Development-DIM layer-Business bus matrix-Significance for dimensional modeling.mp4

12-Data Warehouse-Development-DIM Layer-Design Points.mp4

13-Data warehouse-development-DIM layer-dimensional design process-review.mp4

14-Data warehouse-Development-DIM layer-Product dimension table-Determine the main dimension table and related dimension tables.mp4

15-Data warehouse-Development-DIM layer-Product dimension table-Determine dimension attributes.mp4

16-Data warehouse-Development-DIM layer-Product dimension table-Data loading.mp4

17-Data warehouse-Development-DIM layer-Product dimension table-Table creation statement.mp4

18-Data warehouse-Development-DIM layer-Commodity dimension table-Data loading.mp4

gmall-0701.sql

01-Hive comment garbled problem description.mp4

02-Data Warehouse-Development-DIM Layer-Activity Dimension Table-Table Creation Statement.mp4

03-Data Warehouse-Development-DIM Layer-Activity Dimension Table-Data Loading.mp4

04-Data Warehouse-Development-Hive-on-Spark-Description of Insufficient Resources.mp4

05-Data Warehouse-Development-DIM Layer-Regional Dimension Table.mp4

06-Data Warehouse-Development-DIM Layer-Date Dimension Table-Table Creation Statement.mp4

07-Data Warehouse-Development-DIM Layer-Date Dimension Table-Data Loading.mp4

08-Data Warehouse-Development-DIM Layer-User Dimension Table-Creating Table Statement.mp4

09-Data warehouse-Development-DIM layer-User dimension table-Data loading-Loading process analysis.mp4

10-Data warehouse-Development-DIM layer-User dimension table-Data loading-Loading process supplement.mp4

11-Data warehouse-Development-DIM layer-User dimension table-Data loading-Data flow.mp4

12-Data warehouse-Development-DIM layer-User dimension table-Data loading-First day.mp4

13-Data warehouse-Development-DIM layer-User dimension table-Data loading-Daily-Thought analysis.mp4

14-Data warehouse-Development-DIM layer-User dimension table-Data loading-Daily-Thought analysis-Supplement.mp4

15-Data warehouse-Development-DIM layer-User dimension table-Data loading-Daily.mp4

16-Data warehouse-Development-DIM layer-User dimension table-Data loading-Age problem description.mp4

gmall-0701.sql

01-Data warehouse-Development-DIM layer-Data loading script.mp4

02-Data Warehouse-Development-DWD Layer-Design Points.mp4

03-Data Warehouse-Development-DWD Layer-Transaction Domain-Purchase Transaction Fact Table-Create Table Statement.mp4

04-Data warehouse-Development-DWD layer-Transaction domain-Purchase transaction fact table-Data loading-Data flow.mp4

05-Data warehouse memory allocation requirements.mp4

06-Data Warehouse-Development-DWD Layer-Transaction Domain-Add-Purchase Transaction Fact Table-Data Loading-First Day.mp4

07-Data Warehouse-Development-DWD Layer-Transaction Domain-Purchase Transaction Fact Table-Data Loading-Daily-Part 1.mp4

08-Data Warehouse-Development-DWD Layer-Transaction Domain-Purchase Transaction Fact Table-Data Loading-Daily-Download.mp4

09-Data Warehouse-Development-DWD Layer-Transaction Domain-Order Transaction Fact Table-Create Table Statement.mp4

10-Data warehouse-Development-DWD layer-Transaction domain-Order transaction fact table-Data loading-First day.mp4

11-Data warehouse-Development-DWD layer-Transaction domain-Order transaction fact table-Data loading-Daily.mp4

12-Data Warehouse-Development-DWD Layer-Transaction Domain-Cancel Order Transaction Fact Table-Create Table Statement.mp4

13-Data Warehouse-Development-DWD Layer-Transaction Domain-Cancel Order Transaction Fact Table-Data Loading-First Day.mp4

14-Data Warehouse-Development-DWD Layer-Transaction Domain-Cancel Order Transaction Fact Table-Data Loading-Daily-Top.mp4

15-Data Warehouse-Development-DWD Layer-Transaction Domain-Cancel Order Transaction Fact Table-Data Loading-Daily-Next.mp4

16-Data Warehouse-Development-DWD Layer-Transaction Domain-Payment Success Transaction Fact Table-Create Table Statement.mp4

17-Data Warehouse-Development-DWD Layer-Transaction Domain-Payment Success Transaction Fact Table-Data Loading-First Day.mp4

18-Data Warehouse-Development-DWD Layer-Transaction Domain-Payment Success Transaction Fact Table-Data Loading-Daily.mp4

gmall-0701.sql

01-DWD layer transaction fact table-review.mp4

02-Data Warehouse-Development-DWD Layer-Transaction Domain-Return Order Fact Table-Create Table Statement.mp4

03-Data warehouse-Development-DWD layer-Transaction domain-Return order fact table-Data loading-Data flow.mp4

04-Data Warehouse-Development-DWD Layer-Transaction Domain-Return Order Fact Table-Data Loading-First Day.mp4

05-Data Warehouse-Development-DWD Layer-Transaction Domain-Return Order Fact Table-Data Loading-Daily.mp4

06-Sublime usage tips.mp4

07-Data Warehouse-Development-DWD Layer-Transaction Domain-Refund Success Fact Table-Table Creation Statement.mp4

08-Data Warehouse-Development-DWD Layer-Transaction Domain-Refund Success Fact Table-Data Loading-First Day.mp4

09-Data Warehouse-Development-DWD9 Layer-Transaction Domain-Refund Success Fact Table-Data Loading-Daily.mp4

10-Data Warehouse-Development-DWD9 Layer-Transaction Domain-Shopping Cart Cycle Snapshot Fact Table.mp4

11-Data Warehouse-Development-NVL Problem Description.mp4

12-Data Warehouse-Development-DWD Layer-Tool Domain-Coupon Collection Fact Table.mp4

13-Data Warehouse-Development-DWD Layer-Tool Domain-Coupon Usage (Order) Fact Table.mp4

14-Data Warehouse-Development-DWD Layer-Tool Domain-Coupon Usage (Payment) Fact Table.mp4

15-Data Warehouse-Development-NVL Question Supplement.mp4

16-Data Warehouse-Development-DWD Layer-Interactive Domain-Collection Fact Table.mp4

17-Data Warehouse-Development-DWD Layer-Interactive Domain-Evaluation Fact Table.mp4

18-Data Warehouse-Development-DWD Layer-Traffic Domain Description.mp4

19-Data Warehouse-Development-DWD Layer-Traffic Domain-Page Browsing Fact Table-Creating Table Statement.mp4

20-Data Warehouse-Development-DWD Layer-Traffic Domain-Page View Fact Table-Data Loading-Requirements.mp4

gmall-0701(1).sql

gmall-0701.sql

01-Data warehouse-Development-DWD layer-Traffic domain-Page browsing fact table-Data loading-Thought analysis.mp4

02-Data warehouse-Development-DWD layer-Traffic domain-Page browsing fact table-Data loading-Session division-Solution 1.mp4

03-Data warehouse-Development-DWD layer-Traffic domain-Page browsing fact table-Data loading-Session division-Solution 2.mp4

04-Data Warehouse-Development-DWD Layer-Traffic Domain-Page View Fact Table-Data Loading-Final Version.mp4

05-Data Warehouse-Development-DWD Layer-Traffic Domain-Start Fact Table-Create Table Statement.mp4

06-Data Warehouse-Development-DWD Layer-Traffic Domain-Start Fact Table-Data Loading.mp4

07-Data warehouse-Development-DWD layer-Traffic domain-Fact table-Partitioning ideas mp4.mp4

08-Data Warehouse-Development-DWD Layer-Traffic Domain-Action Fact Table-Create Table Statement.mp4

09-Data warehouse-Development-DWD layer-Traffic domain-Action fact table-Data loading-Thought analysis.mp4

10-Data Warehouse-Development-DWD Layer-Traffic Domain-Action Fact Table-Data Loading.mp4

11-Data Warehouse-Development-DWD Layer-Traffic Domain-Exposure Fact Table.mp4

12-Data Warehouse-Development-DWD Layer-Traffic Domain-Error Fact Table.mp4

13-Data Warehouse-Development-DWD Layer-User Domain-User Registration Fact Table-Create Table Statement.mp4

14-Data warehouse-Development-DWD layer-User domain-User registration fact table-Data loading-Thought analysis.mp4

15-Data Warehouse-Development-DWD Layer-User Domain-User Registration Fact Table-Data Loading-First Day.mp4

16-Data Warehouse-Development-DWD Layer-User Domain-User Registration Fact Table-Data Loading-Daily.mp4

17-Data Warehouse-Development-DWD Layer-User Domain-User Login Fact Table-Create Table Statement.mp4

18-Data Warehouse-Development-DWD Layer-User Domain-User Login Fact Table-Data Loading.mp4

19-Data Warehouse-Development-DWD Layer-Data Loading Script.mp4

20-Data Warehouse-Development-DWD Layer-Data Loading-Testing.mp4

gmall-0701(1).sql

gmall-0701.sql

01-Data Warehouse-Development-DWS Layer-Design Theory-Review.mp4

02-Data Warehouse-Development-DWS Layer-Design Practice-Requirements.mp4

03-Data Warehouse-Development-DWS Layer-Design Practice-Requirement Analysis.mp4

04-Data Warehouse-Development-DWS Layer-Design Practice-Extracting Derived Indicators of Common Granularity.mp4

05-Data Warehouse-Development-DWS Layer-Design Practice-Recent 1-Day Table Design.mp4

06-Data Warehouse-Development-DWS Layer-Design Practice-Recent n-Day Table Design.mp4

07-Data warehouse-Development-DWS layer-Design practice-Processing of the number of people placing orders.mp4

08-Data Warehouse-Development-DWS Layer-Design Practice-Description of Reducing the Granularity of Summary Tables.mp4

09-Data Warehouse-Development-DWS Layer-Design Practice-Supplement.mp4

10-Data Warehouse-Development-DWS Layer-Design Practice-Summary.mp4

11-Data warehouse-Development-ADS layer-Requirement description-Traffic topic-Traffic statistics of each channel.mp4

12-Data warehouse-Development-ADS layer-Requirement description-User theme-User change statistics.mp4

13-Data warehouse-Development-ADS layer-Requirement description-User theme-User retention rate.mp4

14-Data Warehouse-Development-ADS Layer-Requirement Description-User Theme-Newly Added Active Statistics.mp4

15-Data warehouse-Development-ADS layer-Requirement description-User theme-Funnel analysis.mp4

16-Data Warehouse-Development-ADS Layer-Requirement Description-User Theme-New Transaction User Statistics.mp4

17-Data warehouse-Development-ADS layer-Requirement description-User theme-Number of people placing orders by age group.mp4

18-Data warehouse-Development-ADS layer-Requirement description-Product theme-Repurchase rate.mp4

19-Data warehouse-Development-ADS layer-Requirement description-Product theme-Transaction statistics of each brand category.mp4

20-Data Warehouse-Development-ADS Layer-Requirements-Transaction Theme.mp4

21-Data Warehouse-Development-ADS Layer-Requirements-Coupon & Event Theme mp4.mp4

22-Data Warehouse-Development-Task Description.mp4

gmall-0701-dws.sql

01-Data warehouse-Development-DWS layer-Design-Requirement analysis-Traffic statistics of each channel.mp4

02-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-User Change Statistics.mp4

03-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-User Retention Rate.mp4

04-Data warehouse-Development-DWS layer-Design-Requirement analysis-User new active statistics.mp4

05-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-Funnel Analysis-Part 1.mp4

06-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-Funnel Analysis-Part 2.mp4

07-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-New Transaction User Statistics.mp4

08-Data warehouse-Development-DWS layer-Design-Requirement analysis-Number of people placing orders by age group.mp4

09-Data Warehouse-Development-DWS Layer-Design-Requirement Analysis-Repurchase Rate.mp4

10-Data warehouse-development-DWS layer-design-demand analysis-comprehensive transaction statistics.mp4

11-Data warehouse-development-DWS layer-design-demand analysis-transaction statistics of each province.mp4

12-Data warehouse-Development-DWS layer-Design-Requirement analysis-Coupon-Activity-Subsidy rate.mp4

13-Data warehouse-development-DWS layer-design-demand analysis-organization of derived indicators.mp4

14-Data warehouse-Development-DWS layer-Transaction domain user commodity granularity order summary table for the last day-Table creation statement.mp4

15-Data warehouse-Development-DWS layer-Transaction domain user commodity granularity order summary table for the last day-Data loading.mp4

16-Data warehouse-Development-DWS layer-Transaction domain user commodity granularity order summary table for the last n days-Table creation statement.mp4

17-Data warehouse-Development-DWS layer-Transaction domain user commodity granularity order summary table for the last n days-Data loading.mp4

18-Data warehouse-Development-DWS layer-Transaction domain user commodity granularity return order summary table.mp4

19-Data Warehouse-Development-DWS Layer-Transaction Domain User Granularity Order Summary Table.mp4

20-Data Warehouse-Development-DWS Layer-Transaction Domain User Granularity Purchase Summary Table.mp4

21-Data Warehouse-Development-DWS Layer-Transaction Domain User Granularity Payment Summary Table.mp4

22-Data Warehouse-Development-DWS Layer-Transaction Domain Province Granularity Order Summary Table.mp4

23-Data Warehouse-Development-DWS Layer-Transaction Domain User Granularity Return Order Summary Table.mp4

24-Data Warehouse-Development-DWS Layer-Traffic Domain Session Granularity Page Browsing Summary Table.mp4

25-Data warehouse-Development-DWS layer-Traffic domain visitor page granularity page browsing summary table.mp4

26-Data Warehouse-Development-DWS Layer-Transaction Domain Activity & Coupon Granularity Order Summary Table.mp4

01-Data warehouse-Development-DWS layer-Transaction domain user granularity order history summary table to date-Table creation statement.mp4

02-Data warehouse-Development-DWS layer-Transaction domain user granularity order history summary table to date-Data loading.mp4

03-Data Warehouse-Development-DWS Layer-Transaction Domain User Granularity Payment History Summary Table to Date.mp4

04-Data warehouse-Development-DWS layer-TD table daily loading supplement ideas.mp4

05-Data Warehouse-Development-DWS Layer-User Domain User Granularity Login History Summary Table to Date-Part 1.mp4

06-Data Warehouse-Development-DWS Layer-User Domain User Granularity Login History Summary Table to Date-Download.mp4

07-Data Warehouse-Development-DWS Layer-Design Idea Summary.mp4

08-Data Warehouse-Development-DWS Layer-Latest Day Summary Table-Data Loading Script.mp4

09-Data Warehouse-Development-DWS Layer-Summary Table of the Last N Days-Data Loading Script.mp4

10-Data warehouse-Development-DWS layer-Historical summary table-Data loading script.mp4

11-Data warehouse-Development-ADS layer-Traffic topic-Traffic statistics of each channel-Requirement description.mp4

12-Data warehouse-Development-ADS layer-Traffic topic-Traffic statistics of each channel-Demand explanation-Idea 1.mp4

13-Data warehouse-Development-ADS layer-Traffic topic-Traffic statistics of each channel-Demand explanation-Idea 2.mp4

14-Data warehouse-Development-ADS layer-Traffic topic-Traffic statistics of each channel-Requirement explanation-Notes on data import.mp4

15-Data warehouse-Development-ADS layer-Traffic topic-User path analysis-Requirement description.mp4

16-Data warehouse-Development-ADS layer-Traffic topic-User path analysis-Thought analysis.mp4

17-Data warehouse-Development-ADS layer-User theme-User change statistics-Requirements description.mp4

18-Data warehouse-Development-ADS layer-User theme-Path analysis-Requirements explanation.mp4

gmall-0701-ads(1).sql

gmall-0701-ads.sql

01-Data Warehouse-Development-ADS Layer-User Path Analysis-Problem Description.mp4

02-Data warehouse-Development-ADS layer-User change statistics-Requirements explanation.mp4

03-Data Warehouse-Development-ADS Layer-User Retention-Requirements.mp4

04-Data Warehouse-Development-ADS Layer-User New Active Statistics-Requirements.mp4

05-Data Warehouse-Development-ADS Layer-User Funnel Analysis-Requirements.mp4

06-Data warehouse-Development-ADS layer-User retention-Requirements explanation.mp4

07-Data warehouse-Development-ADS layer-New active statistics-Requirements explanation.mp4

08-Data Warehouse-Development-ADS Layer-User Funnel Analysis-Requirements Explanation-Part 1.mp4

09-Data Warehouse-Development-ADS Layer-User Funnel Analysis-Requirements Explanation-Part 2.mp4

10-Data warehouse-Development-ADS layer-Added active statistics-Requirements explanation-Data problem description.mp4

11-Data Warehouse-Development-ADS Layer-New Transaction User Statistics-Requirements.mp4

12-Data warehouse-Development-ADS layer-Statistics of users placing orders by age group-Requirements.mp4

13-Data warehouse-Development-ADS layer-Repurchase rate of each brand-Requirement description.mp4

14-Data warehouse-Development-ADS layer-New transaction user statistics-Requirements explanation.mp4

15-Data warehouse-Development-ADS layer-Statistics of users placing orders by age group-Demand explanation.mp4

16-Data warehouse-Development-ADS layer-Fact table-Dimension table-Time association description.mp4

gmall-0701-ads.sql

01-Data warehouse-Development-ADS layer-Repurchase rate of each brand-Demand explanation.mp4

02-Data warehouse-Development-ADS layer-Transaction statistics of each brand-Requirements description.mp4

03-Data warehouse-Development-ADS layer-Top 3 shopping cart inventory of each category-Requirement description.mp4

04-Data Warehouse-Development-ADS Layer-Transaction Comprehensive Statistics-Requirements.mp4

05-Data warehouse-Development-ADS layer-Comprehensive statistics of transactions in each province-Requirements.mp4

06-Data warehouse-Development-ADS layer-Transaction statistics of each brand-Requirements explanation.mp4

07-Data warehouse-Development-ADS layer-Top 3 shopping cart inventory of each category-Requirement explanation.mp4

08-Data warehouse-Development-ADS layer-Transaction comprehensive statistics-Requirements explanation.mp4

09-Data warehouse-Development-ADS layer-Comprehensive statistics of transactions in each province-Requirements explanation.mp4

10-Data Warehouse-Data Quality Description.mp4

11-Data warehouse-development-ADS layer-subsidy rate-demand explanation.mp4

12-Data Warehouse-Development-ADS Layer-Data Loading.mp4

13-Data Warehouse-Development-Report Data Export Instructions.mp4

14-Data warehouse-development-report data export-MySQL database and table creation.mp4

15-Data warehouse-development-report data export-DataX review.mp4

16-Data warehouse-development-report data export-DataX configuration file writing.mp4

17-Data warehouse-Development-Report data export-DataX configuration file batch generation.mp4

18-Data warehouse-development-report data export-daily synchronization script.mp4

19-Data Warehouse-Development-Data Warehouse Workflow Analysis.mp4

20-Data warehouse-development-report data export-empty file problem description.mp4

gmall-0701-ads.sql

Workflow.pdf

01-Data Warehouse-Workflow Scheduling-Overview.mp4

02-Data Warehouse-Workflow Scheduling-DolphinScheduler Overview.mp4

03-Data Warehouse-Workflow Scheduling-DolphinScheduler-Core Architecture.mp4

04-Data Warehouse-Workflow Scheduling-DolphinScheduler-Deployment Instructions.mp4

05-Data Warehouse-Workflow Scheduling-DolphinScheduler-Deployment-Preparation.mp4

06-Data Warehouse-Workflow Scheduling-DolphinScheduler-Deployment-Initialize Database.mp4

07-Data warehouse-workflow scheduling-DolphinScheduler-deployment-configuration one-click deployment script.mp4

08-Data warehouse-Workflow scheduling-DolphinScheduler-Deployment-One-click deployment.mp4

09-Data Warehouse-Workflow Scheduling-DolphinScheduler-Deployment-Start and Stop Instructions.mp4

10-Data warehouse-workflow scheduling-DolphinScheduler-deployment-standalone mode description.mp4

11-Data Warehouse-Workflow Scheduling-DolphinScheduler-Use-Security Center Management.mp4

12-Data Warehouse-Workflow Scheduling-DolphinScheduler-Use-Workflow-Conceptual Description.mp4

13-Data Warehouse-Workflow Scheduling-DolphinScheduler-Use-Workflow-Define Workflow.mp4

14-Data Warehouse-Workflow Scheduling-DolphinScheduler-Use-Workflow-Run Workflow.mp4

15-Data warehouse-workflow scheduling-DolphinScheduler-Use-Workflow-Timed scheduling workflow.mp4

16-Data Warehouse-Workflow Scheduling-DolphinScheduler-Advanced-Parameter Passing-Part 1.mp4

17-Data Warehouse-Workflow Scheduling-DolphinScheduler-Advanced-Parameter Passing-Part 2.mp4

18-Data Warehouse-Workflow Scheduling-DolphinScheduler-Advanced-Reference Resources.mp4

19-Data warehouse-Workflow scheduling-DolphinScheduler-Advanced-Alarm notification-Email account preparation.mp4

20-Data Warehouse-Workflow Scheduling-DolphinScheduler-Advanced-Alarm Notification-Test.mp4

21-Data warehouse-Workflow scheduling-DolphinScheduler-Advanced-Alarm notification-Third-party platform integration instructions.mp4

22-Data Warehouse-Workflow Scheduling-DolphinScheduler-Advanced-Failure Rerun.mp4

23-Data Warehouse-Workflow Scheduling-DolphinScheduler-Insufficient Memory Problem Description.mp4

01-DolphinScheduler-Problem Description.mp4

02-Data warehouse-scheduling-planning workflow.mp4

03-Data warehouse-Scheduling-New data preparation-User behavior log mp4.mp4

04-Data warehouse-Scheduling-New data preparation-Business data.mp4

05-Data Warehouse-Scheduling-Instructions.mp4

06-Data warehouse-scheduling-practical operation-upload script file.mp4

07-Data warehouse-scheduling-practical-distribution script dependent components & environment variable description.mp4

08-Data warehouse-scheduling-practice-defining workflow.mp4

09-Data warehouse-scheduling-practical operation-submit workflow.mp4

10-Data warehouse-scheduling-practical operation-single machine mode precautions.mp4

11-Data warehouse-scheduling-practical-snapshot instructions.mp4

12-Data warehouse-scheduling-practical operation-workflow execution result viewing.mp4

13-Data Warehouse-Visualization-Superset-Overview.mp4

14-Data Warehouse-Visualization-Superset-Deployment-Miniconda.mp4

15-Data Warehouse-Visualization-Superset-Deployment-Creating Python Environment.mp4

16-Data Warehouse-Visualization-Superset-Deployment.mp4

17-Data Warehouse-Visualization-Superset-Start and Stop.mp4

18-Data Warehouse-Visualization-Superset-Use-MySQL Driver Installation.mp4

19-Data warehouse-visualization-Superset-use-connection data source.mp4

20-Data Warehouse-Visualization-Superset-Use-Trend Chart.mp4

21-Data Warehouse-Visualization-Superset-Use-Sankey Diagram & Map.mp4

22-Data warehouse-visualization-Superset-use-dashboard layout adjustment.mp4

23-Data Warehouse-Summary.mp4

<<:  Are those 9-yuan WeChat group courses that are all over the place worth buying?

>>:  Qutoutiao advertising cases and advertising forms, advertising effects!

Recommend

How to get traffic on the Internet - tips on how to attract traffic

You know a lot of ways to attract traffic . You h...

How to effectively deliver short video information flow?

This article mainly introduces the preparations b...

Public account fission: 0 budget, 3 times the number of fans in 3 days

A good fission method can be reused. The number o...

How should business owners choose the right promotion channels!

If we want to achieve better development, we must...

How to fully plan a screen-sweeping event?

In this era of mobile Internet where the focus of...

3 elements of APP operation and promotion strategy!

All resources have a focusing effect. For product...

Internet Advertising: Real-time Bidding RTB Process!

At present, all kinds of advertisements are every...

With all the dividends lost, how to use competitors to increase user growth?

Now many products are facing the dilemma of sever...

Douyin training: How to make a live broadcast warm-up plan?

For newbies doing live broadcasts, they don’t nee...

How much does it cost to customize a watch mini program in Handan?

How much does it cost to customize the Handan wat...

Want to improve retention? Activate your user first!

Whether in the PC era or the mobile era, the most...