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.
Opening your project
Real company data. Verifiable proof. On its way…
Opening your project
Real company data. Verifiable proof. On its way…
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.
This project helped me understand how business analysts solve real business problems, from forming hypotheses and analyzing data with SQL to building dashboards, validating AI outputs, and presenting executive recommendations. It taught me to think beyond numbers and focus on bu…
I gained valuable hands-on experience using SQL to analyze complex operational datasets, bridging the gap between raw financial metrics and strategic root-cause analysis to identify leaks and drive profitable growth.
Analyzed Bosch profitability using SQL, margin analysis, dashboards, and strategic recommendations.