Guided projects

Guided SQL projects for business data analysis

Every project combines a business objective, a dataset, several tasks and a SQL environment.

IntermediateSQL Essentials

Manage the margin of an e-commerce catalog

Link orders, lines and products to distinguish revenue, costs and margin by category.

Multiple joinsCTECalculationsGROUP BYControls
75 to 100 minCompare plans
IntermediateSQL Analyst

Track products and risk of shortage

Prepare inventory, revenue and coverage indicators for an operational team.

CASEJOINAggregationsCTE
60 to 90 minCompare plans
IntermediateSQL Analyst

Segment customers according to their orders

Transform order history into useful segments for a marketing team.

JOINCASEDatesCTE
60 to 90 minCompare plans
IntermediateSQL Analyst

Analyze the performance of a contact center

Connect queues, contacts, intervals and schedule to measure volume, abandonment, DMT and SLA without logging agents.

joinsSLADMTRatiosControls
90 to 120 minCompare plans
AdvancedSQL Pro

Measuring SaaS subscriptions and churn

Calculate MRR, revenue movements, logo churn, retention and cohorts from verifiable events.

MRRChurnWindowsCohortsReconciliation
90 to 120 minCompare plans
AdvancedSQL Pro

Analyze delays and delivery quality

Measure lead time, promise fulfillment, carriers, warehouses and time evolution.

DatesLead timeKPIjoinsTemporal analysis
90 to 120 minCompare plans
AdvancedSQL Pro

Studying absenteeism with respectful indicators

Calculate durations, trends and aggregated rates by department without exposing individual data.

DatesAggregationsPrivacyWindowsControls
90 to 120 minCompare plans