Sale!
ecommerce-data-mastery-adam-ziolkowski-march-2024

[GroupBuy] Ecommerce Data Mastery – Adam Ziolkowski (March 2024)

$37 $21

Category:

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

Module #2: Intro To Google BigQuery

●  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

Related products