Dave-s-Portfolio
Dave Williams — Data Portfolio
Welcome! I’m Dave Williams, a Data Analyst and Visual Storyteller specialising in:
- SQL, R programming and data cleaning
- Tableau dashboards and narrative storytelling
- Clear documentation and annotated case studies
This portfolio showcases how I clean data, build insights, and communicate findings visually.
Overview
A glimpse of my work clean data, uncover insights, and tell compelling visual stories.
 |
 |
 |
 |
 |
 |
Highlights
- End-to-end SQL case studies with annotated screenshots
- Interactive Tableau dashboards for exploration
- Modular, well-documented projects for easy review and reuse
Sports Analytics Projects
| Project | Tools | Highlights |
|---|---|---|
| Fan Engagement Case Study | SQL | Multi-step analysis, joins, filtering, aggregation |
| IPL Fan Survey Analysis | R | Data visualization, data wrangling, ggplot2 |
Project Index
| Project | Area | Tools | Highlights |
|---|---|---|---|
| Support Ticket Analysis | Operations | SQL, Tableau | Cleaned support data, calculated response times, dashboard insights |
| Hotel Operations Analysis | Hospitality | SQL | Joined booking tables, filtered active records, occupancy metrics |
| Grocery Sales Analysis | Retail | SQL | Category aggregation, top products by revenue |
| Motorcycle Sales Analysis | Retail | SQL | Net revenue calculation and grouping |
| Customer Churn Analysis | Product | Tableau | Churn drivers, storytelling dashboard |
| Support Ticket Dashboard | Operations | Tableau | Interactive ticket resolution monitoring |
| Beauty Industry Sales Analysis | Retail | Tableau | Sales trends and category performance |
Tip: Each project folder includes a README with context, methods, visuals, and key takeaways.
Skills
- SQL: Data cleaning, joins, filtering, aggregation, revenue calculations
- Tableau: Dashboard design, storytelling, interactive actions
- Documentation: Modular case studies, annotated visuals, teaching takeaways
How to Explore
- Browse the Project Index above and click into a project of interest.
- Open the project README for context, methods, and visuals.
- Review scripts (SQL/R) and dashboards linked within each project.
Links
- Tableau Public: Profile
- LinkedIn: Dave Williams
Contact
- Email: ks24dave@hotmail.com