Contra - A professional network for the jobs and skills of the future

Contra - A professional network for the jobs and skills of the futureCleaned Sales Data and Built an Excel KPI Dashboard

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

Camila Schmith

• Oct 3

Cleaned and transformed a messy sales dataset into a structured Excel workbook, removing duplicates, standardising data and identifying missing values. I then created key business KPIs and visual reports, resulting in a clean, analysis-ready dashboard.

Data Analysis Microsoft Excel Data Engineering

Promise Esemuede

• Oct 18

How I Built an End-to-End Sales Analytics Dashboard in Excel for an E-commerce Company I recently completed an end-to-end sales analytics project using Microsoft Excel, transforming raw e-commerce sales data into an interactive dashboard that provides meaningful business insights. In this project, I explored the data, performed analysis, identified key sales trends, and built an interactive dashboard to help businesses make data-driven decisions. I documented the entire process, including the approach, tools, analysis, and dashboard development.

Read the full project walkthrough on Medium: https://medium.com/@Refino/how-i-built-an-end-to-end-sales-analytics-dashboard-in-excel-for-an-e-commerce-company-e8692d81f354

Completed work

Data Analysis Microsoft Excel Data Engineering Product Data Analytics MySQL Python

Muhammad Wasim

• Oct 19

Excellent work! Turning raw data into actionable business insights is a valuable skill.

Ella Nwosu-Oluchukwu

• Oct 18

PROJECT Analyzed a telecom customer churn dataset of 7,043 customers and built five Excel deliverables: a churn count chart, a monthly charges histogram, a gender-based churn comparison, a tenure vs monthly charges heatmap, and sorted and filtered dataset views.

PROBLEMS SOLVED • Identified that saving the raw file as .csv was causing data loss, then moved all work to an .xlsx workbook to protect multi-sheet analysis • Investigated blank Total Charges values and traced them to new customers with 0 months of tenure who had not yet been billed • Turned hundreds of unique tenure and charge values into readable bands (12-month tenure groups, 20-unit charge groups) so a heatmap could be built • Used pivot tables to compare churn counts across categories instead of counting manually

RESULTS • Overall churn: 1,869 of 7,043 customers (about 26.5%) • Gender: churn was nearly equal, 26.9% for female and 26.2% for male customers • Tenure: 999 of the 1,869 churned customers (about 53%) left within their first 12 months • Heatmap: churn was most concentrated among short-tenure customers paying mid-to-high monthly charges • Delivered formatted charts with titles, axis labels, data labels and distinct colors, plus a video walkthrough

SKILLS: Excel, Pivot Tables, Conditional Formatting, Data Cleaning, Data Visualization, Data Interpretation, Churn Analysis

Data Entry Virtual Assistance Data Analysis Microsoft Excel

Sai Motupalli

• Oct 18

This project demonstrates my approach to preparing reliable data for analysis using Microsoft Excel.

I worked on identifying duplicate order IDs, checking missing values, correcting data formats, and validating calculated profit metrics. These quality checks helped improve data consistency and prepare the dataset for further analysis.

Key activities

Identified duplicate order IDs.

Reviewed missing values in important columns.

Standardized data formats, including discount percentages.

Validated calculated profit and profit variance.

Prepared the dataset for accurate reporting and analysis.

Data Analysis Microsoft Excel