Organization Description:

Project Overview:

This project focuses on analyzing customer behavior and developing a data dashboard to visualize business insights that support strategic decision-making. Learners will clean and prepare data, conduct exploratory analysis, and design an interactive dashboard using a tool such as Notion. Final deliverables will include a dashboard, a business insights report, and a summary presentation.

Project Duration: 6 Weeks

Project Hours: 150

Project Hours Per Learner: 30

Project Scope & Expectations:

Learners will engage in:

• Cleaning and preparing customer interaction datasets (e.g., website activity, sales, engagement, or surveys)
• Conducting exploratory data analysis (EDA) to identify trends, correlations, and outliers
• Defining key performance indicators (KPIs) and designing dashboard wireframes
• Developing an interactive dashboard using a common visualization platform
• Presenting insights and data-driven recommendations for business strategy

Project Timeline & Deliverables:

Week 1: Project Kickoff & Data Cleaning (~2 hours per learner)

• Review project goals, data sources, and formatting needs
• Clean dataset by removing duplicates, handling missing values, and validating structure
• Create a data dictionary defining variables and fields

Week 2: Exploratory Data Analysis (EDA) (~4 hours per learner)

• Use Notion or Excel to perform summary statistics and trend discovery
• Visualize key variables and investigate patterns or outliers 

Deliverable: Exploratory Data Analysis Report

Week 3: Dashboard Wireframing & KPI Selection (~6 hours per learner)

• Define Key Performance Indicators (KPIs) based on employer goals
• Sketch a draft layout of the dashboard and plan visualizations 

Deliverable: Dashboard Wireframe & KPI Plan

Week 4: Dashboard Development (~6 hours per learner)

• Use Looker Studio, Tableau, or Power BI to build an interactive dashboard
• Integrate filters, drill-downs, and key charts

Deliverable: Draft Interactive Dashboard

Week 5: Business Insights & Recommendations (~6 hours per learner)

• Interpret data visuals to develop actionable insights
• Link insights to business goals such as customer retention, marketing, or sales

Deliverable: Business Insights & Recommendations Report

Week 6: Final Presentation & Dashboard Demonstration (~6 hours per learner)

• Finalize the dashboard and insights
• Present dashboard functionality and key findings to stakeholders

Deliverables: Final Dashboard (shared via link or export), Final Business Insights Report, and Project Presentation Deck

Final Deliverables:

• Cleaned Dataset & Data Dictionary
• Exploratory Data Analysis Report
• Dashboard Wireframe & KPI Plan
• Interactive Dashboard
• Business Insights & Recommendations Report
• Final Presentation

Working Expectations:

Learners are expected to receive practical, real-world job experience in exchange for the completion of tangible deliverables of a completed project. Employers are expected to provide mentorship, guidance, and clear expectations to students and regular communication with the AscentUP team.