1
Business Analytics & SQL
Separate revenue from profit, build KPI driver trees, and write SQL to compute category margins and join regional data into a single source of truth.
A 3-week business-analytics sprint. As a junior analyst you investigate why Bosch revenue rose (€82bn → €96bn) while operating profit nearly halved (€11bn → €5bn) — forming hypotheses, auditing data, running SQL, building an executive dashboard, isolating root causes via a Pareto profit bridge, forecasting a recovery, and delivering a boardroom verdict. Capped by a real-world case study on Robert Bosch GmbH using public annual-report data.
Step into the role of a Junior Business Analyst at Bosch. Meet the executive team, understand the crisis — revenue is up 17% but operating profit collapsed 55% — and lock in your initial hypothesis for the Veridian profit paradox.
Build the analyst foundations: separate revenue from profit, frame testable hypotheses, construct a KPI driver tree, audit the data for quality, and surface first insights with Excel-style pivots.
Go deep with the toolkit: write SQL to compute category margins and join regional data, design and build a dashboard, run a Pareto deep-dive on root causes, forecast the trajectory, and apply AI-assisted analytics.
Turn analysis into action: move from prescriptive recommendations to a boardroom deck, handle a live stakeholder Q&A, and complete a capstone workday culminating in the executive verdict.
Apply everything to real Bosch Group financials, judge whether the company is in structural decline or deliberately investing through a downturn, and submit your executive case report.
Separate revenue from profit, build KPI driver trees, and write SQL to compute category margins and join regional data into a single source of truth.
Run Pareto deep-dives to isolate the true drivers of a margin collapse, then forecast the trajectory to pressure-test your conclusions.
Translate analysis into prescriptive recommendations, a boardroom-ready deck, and a confident live stakeholder Q&A.