Power BI Sales Data Project
Where in i have worked on the amazon sales data.
0
2
In this project, I worked on raw and unstructured data and transformed it into a clean, structured, and analysis-ready dataset using Microsoft Excel.
š¹ Work Completed:
ā Data Cleaning (removing duplicates, fixing inconsistencies, handling missing values)
ā Data Formatting & Structuring
ā Standardizing columns and data types
ā Data Processing using Excel formulas
ā Creating Pivot Tables for analysis
ā Generating dynamic charts and visual reports
ā Converting raw data into meaningful insights
0
4
In this project, I worked on raw and unstructured data and transformed it into a clean, structured, and analysis-ready dataset using Microsoft Excel.
š¹ Work Completed:
ā Data Cleaning (removing duplicates, fixing inconsistencies, handling missing values)
ā Data Formatting & Structuring
ā Standardizing columns and data types
ā Data Processing using Excel formulas
ā Creating Pivot Tables for analysis
ā Generating dynamic charts and visual reports
ā Converting raw data into meaningful insights
0
20
In this project, I worked on raw and unstructured data and transformed it into a clean, structured, and analysis-ready dataset using Microsoft Excel.
š¹ Work Completed:
ā Data Cleaning (removing duplicates, fixing inconsistencies, handling missing values)
ā Data Formatting & Structuring
ā Standardizing columns and data types
ā Data Processing using Excel formulas
ā Creating Pivot Tables for analysis
ā Generating dynamic charts and visual reports
ā Converting raw data into meaningful insights
š¹ Tools & Functions Used:
Excel formulas (IF, VLOOKUP/XLOOKUP, SUMIF, COUNTIF, etc.)
Pivot Tables
Conditional Formatting
Data Validation
Sorting & Filtering
Charts & Visualization
š¹ Outcome:
The final output was a clean, well-structured dataset with summarized insights through pivot tables and visually clear charts.
0
24