Welcome! This is a collection of my data analytics projects showcasing skills in SQL, Excel, Power BI, Tableau, and data cleaning.
- Goal: Analyzed customer demographics to find factors influencing bike purchases.
- Skills: Excel (Pivot Tables, Charts, Slicers), Data Cleaning, Dashboard Design
- Repo: excel-bike-sales-dashboard
- Goal: Analyzed Vrinda Store’s sales data for 2022 to identify customer demographics, channel performance, and order trends, helping the store plan for growth in 2023.
- Skills: Excel (Pivot Tables, Charts, Slicers, Conditional Formatting, Dashboard Design)
- Dataset: Farainzia Store sales dataset (2022, Excel)
- Repo: Farainzia-Store-Sales-Analysis
- Goal: Analyzed Superstore dataset to uncover sales and profitability patterns across regions, categories, and customer segments.
- Skills: Excel (Pivot Tables, Charts, Slicers), Data Cleaning, Dashboard Design
- Repo: Superstore-Sales-Analysis
- Goal: Tracked income, expenses, and savings to analyze cash flow and identify spending patterns.
- Skills: Excel (Pivot Tables, Charts, INDEX-MATCH, Conditional Formatting), Data Cleaning, Dashboard Design
- Repo: excel-expense-tracker-dashboard
- Goal: Analyzed Tesla’s stock performance to assess returns, volatility, and risk-reward profile.
- Skills: Excel (Returns, Volatility, Moving Averages, Histograms, Dashboards)
- Repo: tesla-stock-analysis
- Goal: Analyzed patient appointment data to find factors causing no-shows and measure the impact of SMS reminders on attendance.
- Skills: Excel (Pivot Tables, KPI Cards, Slicers), Data Cleaning, Dashboard Design, Healthcare Analytics
- Repo: excel-healthcare-appointment-analysis
- SQL (SQLite, BigQuery, MySQL)
- Excel (Data Cleaning, Pivot Tables, Dashboards)
- Power BI
- Python (Pandas, Matplotlib)
- R (tidyverse, ggplot2)
- Email: madeself845@gmail.com
- LinkedIn: linkedin.com/in/i-farainzia
- Kaggle: kaggle.com/ishukverma