Visualisation
Power BI
DAX
Power Query
Excel
Data analyst · Business intelligence
Turning complex data into clear decisions.
I build reliable data models, interactive dashboards and focused analysis that help teams see what happened, understand why, and decide what to do next.
Power BIDashboards & DAX
SQL + PythonAnalysis & automation
Business firstDecisions, not decoration
ANALYSIS WORKSPACE
ILLUSTRATIVEGRID INTELLIGENCE
Operational signal
LOW RISK
Carbon signal68gCO₂/kWh
Clean share74%illustrative
Next window14:30planning cue
Intensity profile
00:0006:0012:0018:0024:00
01
Decision cue Shift flexible activity into the forecast low-intensity window.
→POWER BI ✦ SQL SERVER ✦ PYTHON ✦ DAX ✦ POWER QUERY ✦ EXCEL ✦ APIs ✦ DATA MODELLING
01 — About
Data that holds up.
Analysis that moves work forward.
I am a data analyst with experience across energy data, reporting, data quality, system migrations and dashboard development.
I use Power BI, SQL, Excel and Python to reconcile information across systems, automate recurring analysis, identify trends and turn findings into practical recommendations for stakeholders.
01Reliable inputs
Profile, reconcile and document the data before visualising it.
02Useful questions
Start with the decision, then choose the measure and method.
03Clear action
End every analysis with ownership, trade-offs and a next step.
02 — Capabilities
A practical toolkit for the full journey from raw data to decision.
Analysis
Python
pandas
Forecasting
Regression
Data cleaning
Data
SQL Server
SQL
Relational databases
Data modelling
Automation
Power Automate
APIs
GitHub
SharePoint
Jupyter
Business
Stakeholders
KPI development
Recommendations
Process improvement
03 — Selected work
Portfolio blueprints built around real UK data.
Each concept is structured as a full case study: source, preparation, model, analysis, insight and action. Links to live dashboards and code will replace the blueprint labels as each build is completed.
01
Energy-mix trend preview
UK Energy Intelligence
A decision-focused view of electricity demand, generation mix and carbon intensity across Great Britain.
APIPythonSQLPower BIPower Query
Decision enabled
Shift flexible loads into forecast low-intensity periods.
02
Weather impact preview
UK Weather & Business Impact
Weather signals translated into demand, staffing and operational planning scenarios.
APIPythonPower BIForecastingPower Query
Decision enabled
Adjust staffing and inventory when forecast conditions cross tested thresholds.
03
Transport reliability preview
UK Transport Performance
Line reliability, disruptions and time-of-day risk made easier to compare and act on.
APIPythonSQLPower BIDAX
Decision enabled
Prioritise interventions where frequency and customer impact are both high.
04
Housing market preview
UK Housing Market
Regional price, transaction and affordability trends built for evidence-led location comparison.
CSVPythonSQLPower BIData Modelling
Decision enabled
Use a balanced scorecard of growth, liquidity and affordability.
05
Customer performance preview
Sales & Customer Performance
A commercial performance model connecting revenue, margin, product mix and customer value.
SQL ServerSQLPower BIDAXPython
Decision enabled
Prioritise campaigns by margin-adjusted customer value.
04 — Business impact
Beyond charts.
What happened?Why did it happen?What should the business do next?
Reduced manual reporting
Designing repeatable refresh and validation steps.
Improved data quality
Making exceptions, gaps and reconciliation visible.
Identified operational trends
Separating one-off noise from repeat patterns.
Supported decisions
Connecting every KPI to an action or owner.
Automated analysis
Replacing recurring manual tasks with controlled pipelines.
Improved KPI visibility
Giving stakeholders one clear source of truth.
05 — Experience
Operational understanding, analytical discipline.
Previous data role
Data Analyst · Mitie Energy
Energy data, reporting & systems
Analysed half-hourly and AMR meter data, reconciled records across business systems, produced sign-off reporting and supported the migration from eMarket to Orbit.
Power BISQL ServerExcelPythonPower Automate
Applied project work
Data Analyst Level 4 · Portfolio
Statistical analysis & forecasting
Used descriptive statistics, regression, classification and ETS forecasting to evaluate energy-use patterns, assess model performance and communicate recommendations.
pandasstatsmodelsscikit-learnJupyter
Current operations
Warehouse Operations · UK logistics
Process awareness at the front line
Hands-on experience with time-sensitive operational workflows, accuracy, throughput and safety—useful context for building reporting that works in real environments.
Process improvementOperational KPIsQuality
06 — Development
Qualification
Data Analyst Level 4 Apprenticeship
End-to-end analytical project work, modelling, visualisation and stakeholder communication.
Qualification
Level 3 Certificate in Coding Practices
Software practices, quality, risk, collaboration and maintainable code.
Continuous learning
Power BI · SQL · Python
Focused development through hands-on dashboards, database work and automation.
07 — Contact
Have a data problem worth solving?
I'm interested in Data Analyst, BI Analyst and Reporting Analyst opportunities across the UK.
→
Best fit Energy, operations, reporting, data quality and process improvement.