The "Amazon Sales Report" project is an end-to-end data analytics project completed during my internship at InnoByte Services. The project involves comprehensive data cleaning, transformation, and visualization to provide insights into Amazon sales data. The dataset was provided by the company and required significant preprocessing to ensure accurate and meaningful analysis.
-
Data Cleaning and Preprocessing
- Removed irrelevant columns.
- Reformatted the date column for consistency.
- Renamed columns and updated values for better clarity.
- Integrated additional data from a CSV file containing pincode, state, and city information.
- Joined the supplementary data with the original dataset to enhance the data quality and readiness for analysis.
-
Data Analysis and Visualization
- Imported the cleaned dataset into Power BI.
- Created various interactive and insightful visualizations to analyze sales trends, regional performance, and other key metrics.
- Designed an interactive report to provide a comprehensive view of the sales data.
-
Deployment
- Deployed the interactive Power BI report to Microsoft Fabric for seamless access and sharing within the organization.
You can view the deployed Power BI report here: Amazon Sales Report
- Python: Data cleaning and preprocessing.
- Power BI: Data visualization and report creation.
- Microsoft Fabric: Deployment of the final report.
- Advanced data cleaning techniques using Python.
- Data integration and enrichment with supplementary datasets.
- Building interactive dashboards and reports in Power BI.
- Deploying and managing reports in a cloud-based environment (Microsoft Fabric).
This project provided valuable insights into data analytics and visualization, enabling better decision-making based on sales data. The experience gained from working on this project has significantly enhanced my skills in data preprocessing, analysis, and visualization.
Yuvanesh K M - Data Analyst Intern at InnoByte Services.