Bridge the gap between "Learning Power BI" and "Working as a Data Analyst."
Stop practicing on perfect, "clean" datasets. This project kit puts you in the driver’s seat of TechGadget Inc., a company facing a high-stakes marketing disaster. You aren't just building charts; you are decoding a business crisis through data to save a failing Q1 strategy.
The Scenario:
TechGadget Inc. increased their marketing budget by 40%, yet total revenue only grew by 12%. With the CFO threatening to freeze the Q2 budget , the CMO needs you to identify exactly where the money is "bleeding".
What You Will Build & Solve:
The Creative Mystery: Prove why expensive video ads drive clicks but result in "abysmal" conversion rates compared to images.
The Cost Crisis: Identify the specific impact of Google Search CPCs spiking by 50% due to competitor bidding.
The Profitability Floor: Build a tracker to flag any campaign falling below the 3.0x ROAS "absolute floor".
KPI Mastery: Apply professional formulas for CTR, CVR, CPC, CPA, and ROAS to evaluate efficiency.
What’s Included in Your Project Kit:
Executive Briefing: Raw transcript and meeting notes from the CMO, CFO, and Lead Analyst.
Business Knowledge Guide: A foundational "cheat sheet" defining core marketing metrics and the logic behind them.
Strategic Objectives: A clear roadmap detailing the three core issues the business needs you to solve.
Raw Data Access: Performance datasets and transaction records designed for advanced dimensional modeling.