Projects

Projects demonstrating Data Analyst skills: data preparation, SQL analysis, KPI reporting, Tableau dashboards, Power BI dashboards, pivot-based summaries, and clear visuals. Each project is documented and reproducible.

Tableau Sales & Customer Dashboard

Tableau dashboard project comparing 2023 sales and customer performance against the previous year, with KPI cards, trend analysis, subcategory performance, customer distribution, and top-customer profit insights.

Tableau
Screenshot of Tableau sales dashboard
  • Sales dashboard with total sales, profit, quantity, subcategory performance, and trend comparisons
  • Customer dashboard with total customers, sales per customer, order volume, distribution, and top customers
  • Packaged Tableau workbook and dashboard PDF included for review and download

Power BI & SQL Pizza Sales Analysis

End-to-end business intelligence project analyzing pizza sales revenue, total orders, best/worst sellers, category performance, size performance, and daily/monthly trends.

Power BI + SQL
PDF export included Dashboard visuals are provided through the project PDF, not separate image exports.
  • SQL KPI calculations for revenue, orders, quantity, and average order value
  • Power BI dashboard with product, category, size, daily, and monthly analysis
  • Business insights on high-performing and low-performing pizza items

Data Roles Analytics (Excel)

Workbook analyzing data-related roles, salary benchmarks, in-demand skills, and the relationship between skills requested and pay.

Excel
Excel analytics workbook Documented on GitHub with workbook analysis, salary benchmarks, and skills-demand summaries.
  • Skills demand analysis (job count by skill)
  • Top skills: average salary vs demand (combo chart)
  • Salary benchmarks across common data roles
  • Skills-per-job vs median salary analysis (scatter + trendline)

Salary Dashboard (Excel)

Interactive dashboard with filters and KPIs to explore how salaries vary by role, location, and schedule type.

Excel
Interactive Excel dashboard Built for filtered salary comparison across role, country, and schedule type.
  • Dropdown filters (job title, country, schedule type)
  • KPIs (e.g., median salary, posting volume)
  • Comparison charts with highlighted selections