This is my data analytics projects, where I analyze insights using tools like Excel, SQL, Power BI, and Tableau. The project focuses on transforming raw data into actionable insights for data-driven decision-making.
- Excel: For data cleaning, basic analysis, and visualizations.
- SQL: For querying, data manipulation, and relational database operations.
- Power BI: For building interactive dashboards and visual reports.
- Tableau: For advanced data visualization and storytelling.
-
Data Collection
- Gathered raw data from various sources including CSV files, databases, and APIs.
-
Data Cleaning
- Cleaned data using Excel and SQL by removing duplicates, handling missing values, and standardizing formats.
-
Data Analysis
- Used SQL for deep analysis, performing queries, joins, and aggregations to identify trends and patterns.
-
Data Visualization
- Developed interactive dashboards in Power BI and Tableau to visualize key metrics such as sales, customer behavior, and revenue trends.
-
Insights & Recommendations
- Key insights were shared with stakeholders, focusing on improving business strategies, customer segmentation, and operational efficiency.
- Sales Performance: Highest sales were observed in Q3, driven by marketing campaigns.
- Customer Segmentation: Urban customers contributed significantly to revenue with frequent purchases.
- Operational Challenges: Notable shipping delays during peak seasons affected customer satisfaction.