Projects that look like real work
Plan–Fact Analysis for Orion Retail Stores
The Head of Retail reviews every store monthly against the sales plan approved by Finance. Until now the comparison has been assembled by hand and nobody agrees which stores are really behind.
Variable-based Bonus Calculator
Orion People's sales department pays a quarterly variable bonus. Managers want a calculator they can audit, adjust and explain to staff.
Lead Generation and Lead Behaviour
Orion Telecom's acquisition team generates ~18 leads per day across six sources. Sales complains that many leads are poor quality; marketing says sales does not follow up fast enough.
ABC/XYZ Inventory Classification
Orion Retail's buyers treat all 108 products the same: same review frequency, same safety stock rule. Stock-outs and overstock happen at the same time.
RFM Customer Segmentation
Marketing sends the same email to all 4,000 customers. They want to target loyal customers differently from lapsing ones.
Linear Prediction of Monthly Revenue
Finance needs a quick, explainable projection of monthly revenue for the next six months to sanity-check the budget.
TTC Analysis
Placeholder scenario pending definition. Candidate data: leads.createdat → convertedat (time to convert) and supporttickets.openedat → resolvedat (time to close).
Like-for-Like (LFL) Sales Analysis
Orion Retail reports 12.5% revenue growth for 2025. The CFO asks how much of that is genuine growth of existing stores versus the effect of opening Ankara and closing Baku Airport.
Profit and Loss Analysis
The CFO needs a management P&L pack for 2025 with margins and budget variance explained, ready for the board.
Balance Sheet and Working Capital Analysis
A lender is reviewing Orion's credit line and asks for an analysis of liquidity and working capital trends.
Cross-sell and Upsell Opportunities
Orion Retail sells Basic, Plus and Pro variants of every product family. Commercial wants to grow revenue per customer through cross-category purchases and variant upgrades.
Lead Conversion Analysis
Orion Telecom's sales director wants to reallocate call-centre capacity to the lead sources that convert best.
Sales versus Leads
Management sees new subscriptions and leads moving differently month to month and asks whether more leads actually produce more sales.
Tenure Prediction
Orion Telecom wants to anticipate how long new subscribers will stay, to set acquisition spend per customer.
Coefficient Prediction
Placeholder pending definition. Candidate data: orderitems.discountpct and volumes in retail; regression lessons in Module 7 cover coefficient estimation.
Three-Scenario Financial Model
Orion is considering opening two new stores in 2026. The board wants to see the P&L impact under base, upside and downside assumptions.
HR Analytics: Attrition and Workforce
The HR director believes attrition in Sales and Customer Service is costing the company heavily and wants evidence before proposing a retention programme.
Sales Performance Analysis
A new Commercial Director joins Orion Retail and asks for a factual overview of sales over the last three years.
Market Share Analysis
Orion's leadership claims to be 'the leading electronics retailer in Baku'. The board wants evidence.
TAM / SAM / SOM for a New Service
Orion Telecom considers launching a home-internet bundle in three regions and needs a market sizing for the investment committee.
Market Basket Analysis
Merchandising wants to know which products are bought together to design bundles and shelf placement.
Stock and Inventory Analysis
The COO suspects capital is tied up in slow-moving stock while best-sellers run out.
CAGR and Growth Analysis
Investor relations wants growth figures for an investor presentation.
Campaign Effectiveness Analysis
Marketing spent heavily on Black Friday and summer sales. Finance asks which campaigns paid back.
Stock (Demand) Prediction
Buyers want a monthly unit forecast per product for the next quarter to plan purchase orders.
Insurance Renewal Rate Analysis
Orion Insurance's renewal rate for travel policies is far below other lines. The head of insurance asks why and whether it matters.
Power BI to Tableau: Rebuild and Compare
Orion's parent company uses Tableau; the retail team built its dashboard in Power BI. Leadership wants one sales dashboard available in both tools for a transition period.
Excel Files to SQL Views
Each store manager sends a monthly Excel file with stock counts. An analyst copies them into one workbook by hand — slow and error-prone.
Mail-based Orbis Workflow
Placeholder pending definition.
Professional Dashboard Design
The Orion Telecom executive committee has a 40-visual dashboard nobody reads. You are asked to replace it.
Python to Power BI
Churn scores are produced in a Python notebook and pasted into Excel for the BI team.
Desktop Cleaner Automation
Analysts' Downloads and Desktop folders fill with exports. Files get lost and old reports are reused by mistake.
Power Automate: Logs and Automated Emails
Store managers must be emailed when their daily sales file is missing, and the team wants a log of every report sent.
Commission Management in Streamlit
Sales commissions are calculated in a fragile spreadsheet. Disputes take days to resolve.