Marketing Analysis Project

5
Marketing Analysis Project
Digital Product
9Sales

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.

What are people saying

Nitish having strong technical background and one of the best technology person and his knowledge is out of the world!
Neha
Jul 2025
It was a pleasure connecting with Nitish through Topmate for a quick and insightful session. He provided clear and practical guidance on my upcoming interview preparation, as well as valuable advice regarding my career path. He is approachable and the willingness to share his experience made the conversation both productive and encouraging. I truly appreciate the clarity he brought to my queries and look forward to staying connected with him for future guidance and mentorship.
Anonymous
Jun 2025
I had an incredible experience working with Nitish for career guidance in the data field. His deep understanding of the data industry, combined with personalized advice, helped me gain clarity on my career path. Looks forward to another meeting.
Vivek Kumar
Apr 2025
I truly enjoyed our session. It was amazing to hear you share insights on a project that resonates more with my field. Your expertise was outstanding, and I’m most grateful for your time. Knowing that you are always available to guide and support me throughout my learning journey means a lot.
Anonymous
Mar 2025
I recently had my CV reviewed, and the experience was incredibly beneficial. The feedback provided was constructive and insightful, highlighting both my strengths and areas for improvement. The reviewer took the time to understand my career goals and helped me tailor my CV to better reflect my skills and experiences. I now feel more confident in presenting my qualifications to potential employers. I highly recommend seeking a CV review for anyone looking to enhance their job application materials.
Anonymous
Jan 2025
399