SHAWN BAK
London,SURREY
Summary
Data Analyst skilled in Python, SQL, Power BI, Tableau and Excel, with experience turning complex datasets into dashboards, forecasts and actionable insights. Data Analyst with expertise in Python, SQL, Power BI, Tableau, and Excel. Transformed complex datasets into actionable insights through dashboard creation and forecasting. Delivered accurate reports that informed strategic decision-making.
Overview
5
5
years of professional experience
Work History
Data & Reporting Analyst
Freelance
London
01.2026 - Current
- Cleaned retail, warehouse, and transfer datasets; developed Excel and Power BI dashboards to visualise trends, moving averages, seasonality, and stock discrepancies.
- Conducted analysis of retail sales data to identify trends and performance metrics.
- Created Tableau dashboard to highlight seasonal spend patterns, top categories, and identify inventory and marketing opportunities.
- Created a dashboard in Tableau to visualise customer shopping trends and seasonal behaviours.
- Cleaned eDNA and stream datasets; modelled effects of discharge, velocity, and depth; produced conservation report and Power BI-ready dataset for biodiversity assessment.
- Conducted analysis of environmental DNA data to assess biodiversity and ecosystem health.
Housing Support Worker
Servol Community Services
London
01.2022 - 01.2025
- Managed support-plan, risk, and compliance data, producing KPI/trend reports and audit-ready documentation to ensure regulatory adherence.
- Participated in team meetings and training sessions to enhance professional development and service delivery.
- Built trusting relationships with clients, offering emotional support and guidance through challenges.
- Conducted regular welfare checks and risk assessments to maintain safety and well-being of clients.
Education
HND Business Information Technology -
Leeds Metropolitan & Brunel University
Skills
- Excel
- Power BI
- Tableau
- SQL
- Python
- R
- Azure
- Git
- Jupyter
- Power Query
- EDA
- Regression
- Forecasting
- Hypothesis testing
- Anomaly detection
- Data validation
- Reporting
- Strong reporting skills
- Large dataset experience
- Analytical mindset
- Problem-solving
- Accuracy
- High accuracy
- Stakeholder communication
- Clear communication
Portfolio
- linkedin.com/in/shawn-a-b31042174
- sites.google.com/view/portfoliosite-shaunbak/home
- https://github.com/Analyst797824/BootCamp5projects-
Timeline
Data & Reporting Analyst
Freelance
01.2026 - Current
Housing Support Worker
Servol Community Services
01.2022 - 01.2025
HND Business Information Technology -
Leeds Metropolitan & Brunel University