What’s inside the Program?
The course consists of 51 lessons (66 if you count bonuses) focused on teaching you how you can use SQL programming & deep analytical skills to dramatically increase the value you can deliver to Ecommerce companies – and therefore, your value in Ecommerce industry.
General rule is – each lesson:
● introduces only one concept
● gives you a context about why it’s important in the Ecommerce industry
● explains it in practical examples
● is created in the most human-friendly & approachable way we could possibly achieve
● pushes you to practice it on exercises attached to each lesson
The lessons are divided into 12 modules:
Module #1: Intro To SQL
● Lesson #1: Intro To SQL
● Lesson #2: Using SQL For Counting
● Lesson #3: GROUP BY
● Lesson #4: ORDER BY
● Lesson #5: Mathematical Operators
● Lesson #6: Enabling Google BigQuery
● Lesson #7: Connecting Sample Ecommerce Data to Google BigQuery
● Lesson #8: Analyzing Sample Ecommerce Data Inside Google BigQuery
● Lesson #9: Feeding Your Actual Ecommerce Data To Google BigQuery
Module #3: Bonus Lessons | Pulling Data From Real-Life Ecommerce Sources
● Lesson #9.A: Feeding WooCommerce Data To Google BigQuery
● Lesson #9.B: Feeding Shopify Data To Google BigQuery
● Lesson #9.C: Feeding Data To Google BigQuery From Other / Custom Ecommerce Platforms
● Lesson #9.D: Feeding Facebook Ads & Google Ads Data To Google BigQuery
● Lesson #9.E: Feeding Universal Analytics Data To Google BigQuery
● Lesson #9.F: Feeding Google Analytics 4 Data To Google BigQuery
Module #4: SQL Level 2 | Data Types & Basic Functions
● Lesson #10: COUNT DISTINCT
● Lesson #11: Setting Conditions & Inequality Signs
● Lesson #12: 5 Most Common Data Types In SQL
Module #5: SQL Level 3 | Working With Dates
● Lesson #13: Working With Dates #1: EXTRACT Function
● Lesson #14: GROUP BY Hack #1: GROUP BY When NOT Aggregated
● Lesson #15: GROUP BY Hack #2: Use Numbers Instead Of Names
● Lesson #16: Working With Dates #2: DATE_DIFF – Customer Lifespan Analysis
● Lesson #17: Working With Dates #3: DATE_DIFF – Recency Analysis
● Lesson #18: Working With Dates #4: TIMESTAMP
Module #6: SQL Level 4 | Working With Text
● Lesson #19: Working With Text #1: LIKE Function
● Lesson #20: Working with Text #2: CONCAT function
● Lesson #21: Working with Text #3: SUBSTR Function
Module #7: SQL Level 5 | Joining Tables
● Lesson #22: Joining Tables #1: Intro
● Lesson #23: Joining Tables #2: Mathematical Functions
● Lesson #24: Joining Tables #1: LEFT JOIN
● Lesson #25: Subqueries
Module #8: BigQuery Level 2 | Automating Queries & Connecting Them To Looker Studio
● Lesson #26: Running Your Queries On Autopilot
● Lesson #27: Intro To Looker Studio Dashboards
Module #9: SQL Level 6 | Window Functions
● Lesson #28: Window Functions #1 | SUM & AVG
● Lesson #29: Window Functions #2 | SUM & AVG
● Lesson #30: Window Functions #3 | RANK | ASC
● Lesson #31: Window Functions #4 | RANK | DESC
● Lesson #32: Window Functions #5 | RANK + Subqueries
● Lesson #33: Window Functions #6 | DATE_DIFF + LAG
● Lesson #34: Window Functions #7 | DATE_DIFF + LAG + Subqueries
● Lesson #35: Window Functions #8 | Bonus Article
Module #10: Ecommerce Data Mastery Dashboard System | Simple Metrics
● Lesson #36: Ecommerce Data Mastery Dashboards #1 | Intro To The Dashboard
● Lesson #37: Ecommerce Data Mastery Dashboards #2 | Custom Queries
● Lesson #38: Ecommerce Data Mastery Dashboards #3 | Simple Ecommerce Metrics
● Lesson #39: Ecommerce Data Mastery Dashboards #4 | Date Range Control
● Lesson #40: Ecommerce Data Mastery Dashboards #5 | Simple Ecommerce Metrics #2
Module #11: Ecommerce Data Mastery Dashboard System | Intermediate Metrics
● Lesson #41: Ecommerce Data Mastery Dashboards #6 | Intermediate Ecommerce Metrics
● Lesson #42: Ecommerce Data Mastery Dashboards #7 | Custom Fields
● Lesson #43: Ecommerce Data Mastery Dashboards #8 | Custom Fields + CASE WHEN
● Lesson #44: Ecommerce Data Mastery Dashboards #9 | Intermediate Ecommerce Metrics #2
● Lesson #45: Ecommerce Data Mastery Dashboards #10 | Intermediate Ecommerce Metrics #3
● Lesson #46: Ecommerce Data Mastery Dashboards #11 | Intermediate Ecommerce Metrics #4
Module #12: Ecommerce Data Mastery Dashboard System | Advanced Metrics
● Lesson #47: Ecommerce Data Mastery Dashboards #12 | Advanced Ecommerce Metrics
● Lesson #48: Ecommerce Data Mastery Dashboards #13 | Advanced Ecommerce Metrics #2
● Lesson #49: Ecommerce Data Mastery Dashboards #14 | Advanced Ecommerce Metrics #3
● Lesson #50: Ecommerce Data Mastery Dashboards #15 | Advanced Ecommerce Metrics #4
● Lesson #51: Ecommerce Data Mastery Dashboards #16 | Summary + Templates
Sales Page:_https://ecommercedatamastery.com/oto-60-day-program/
Delivery time: 12 -24hrs after paid
