Data Analytics – Customer Insights & Dashboard Development
Categories
Skills
Project scope
What is the main goal for this project?
Organization Description: [Please share any context around your organization and how this project coincides with wider Organizational goals]
Project Overview:
This project focuses on analyzing customer behavior and developing a data dashboard to visualize 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 Looker Studio, Tableau, or Power BI. Final deliverables will include a dashboard, business insights report, and a summary presentation.
Project Duration: 6 Weeks
Project Hours: 150
Project Hours Per Learner: 30
Organization Description: [Please share any context around your organization and how this project coincides with wider Organizational goals]
Project Overview:
This project focuses on analyzing customer behavior and developing a data dashboard to visualize 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 Looker Studio, Tableau, or Power BI. Final deliverables will include a dashboard, business insights report, and a summary presentation.
Project Duration: 6 Weeks
Project Hours: 150
Project Hours Per Learner: 30
What tasks will learners need to complete to achieve the project goal?
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 Python, SQL, 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 completion of tangible deliverables of a successfully completed project. Employers are expected to provide mentorship, guidance, and clear expectations to students and regular communication with the AscentUP team.
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 Python, SQL, 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 completion of tangible deliverables of a successfully completed project. Employers are expected to provide mentorship, guidance, and clear expectations to students and regular communication with the AscentUP team.