Data Analytics Portfolio
Expand the toggles below to explore select projects. Skills include data analysis, database design, data visualization, SQL, R programming, and developing strategic recommendations based on findings.
You can also view code and visualizations on my SQL portfolio (on Github) and Tableau portfolio.
Data Analytics Projects
-
Quantified statistics about landing page performance including visitor acquisition, traffic patterns, click-through rates (CTR), conversions, and other insights. Published in Looker Studio to share with client and track KPIs.
-
Quantified sales, profitability, profit ratio, and sales per customer. Visualized profit ratio by city on US map. Quantified monthly sales by segment and category over time by profitable vs. unprofitable orders.
-
Quantified COVID-19 vaccination rates over time, by country, and by income group; published a Tableau dashboard to visualize results.
-
Identified stores with the lowest and highest sales rates, quantified revenue by product, and identified average revenue by account; published a Tableau dashboard to track KPIs.
-
Designed a digital media store database using SQL and analyzed statistics by product. Quantified statistics about customers, sales representatives, albums, tracks, and invoices.
-
Queried a database with multiple tables using SQL to quantify statistics about customer and order data, including details on revenue and order totals by product, month, and location.