pro
Tanra Johnson
Data & Spreadsheet Specialist | Excel, Data Cleaning, Report
Created an Excel sales reporting workbook to turn transaction data into a clear snapshot of business performance. Built KPI calculations for total revenue, units sold, average revenue per sale, and top-performing category, then used a PivotTable and chart to analyze revenue by...
Cleaned and validated a large real-world online retail dataset to create a more reliable, analysis-ready transaction set. The process included identifying and removing 5,268 duplicate records, identifying 9,251 cancelled transactions, reviewing non-positive quantity and price...
Grocery Customer Behavior Analysis dashboard created using Power BI, Excel, and MySQL to analyze customer spending, shopping frequency, product preferences, basket behavior, and overall sales trends.
Multi-Store Retail Sales Performance dashboard created using Excel, Power BI, and MySQL to analyze revenue, units sold, average selling price, store performance, department performance, and monthly sales trends.
