Project 2 – Dynamic Financial Model Building

📌 Topics Covered

• Cleaning and organizing Excel and GA data
• Revenue trend analysis and financial performance metrics
• Customer behavior analysis
• Creating dynamic financial models using Excel formulas
• Building interactive dashboards for visualization

📝 Project Summary
In this project, you will integrate Excel and Google Analytics data to build a dynamic financial model. The model allows you to analyze revenue, customer behavior, and business performance, supporting forecasting, planning, and strategic decision-making. Interactive dashboards provide a clear view of key metrics and financial insights.

✅ What You Will Learn

• Clean and organize data from multiple sources
• Analyze revenue trends and customer behavior
• Build dynamic financial models using Excel formulas
• Create interactive dashboards for visualization
• Support financial planning and data-driven decision-making

Note to Students –

Live Classes will held on Google Meet.
Mentor will provide files, dataset in the Google Clasroom.
Class video will be provided on Google Classroom.

Click “Mark as Complete” button.

Good Luck.