Hi, I'm Andrew.
My Projects
UK Property Market Analysis
An interactive Power BI dashboard analysing the UK Land Registry's public dataset to identify regional price trends, affordability metrics, and property type performance.
In Progress
Japanese Kanji Frequency Analysis
A Power BI dashboard analysing Kanji frequency across various Japanese media, providing insights into character usage by JLPT level and media type.
Up Next
Certifications & Learning
Microsoft Certified: Azure Data Fundamentals
- Core data concepts
- Relational & non-relational data on Azure
- Modern data warehouse analytics
Earned
Microsoft Power BI Data Analyst
- Data preparation and modeling
- DAX for advanced calculations
- Data visualisation and reporting
In Progress
Microsoft Fabric Analytics Engineer
- End-to-end analytics with Fabric
- Data warehousing & lakehouse design
- Data ingestion with pipelines
Up Next
Skills
BI & Visualisation
Data ModelingDAX StudioPower BI DesktopPower BI ServiceStar Schema Power QueryData Engineering
Data WarehousingMicrosoft FabricSynapseAzure Data FactoryAzure Logic AppsLanguages & Databases
T-SQLPythonDAXPowerQuery MAzure SQLVisual Studio VBADevelopment & Tools
Agile DevelopmentJiraConfluenceGit & GitHubAzure DevOpsCI/CDAbout Me
I'm a BI Developer with a decade of experience in data-focused roles. My journey began with automating and solving complex problems in Excel using VBA and Power Query, and has progressed to maintaining and creating enterprise level data pipelines in the Microsoft Azure ecosystem.
My background in production support has given me a crucial advantage, in that I don't just see the data, I understand the business processes and real world context behind it. This allows me to move beyond simply fulfilling requirements and instead build robust, efficient data solutions that solve the right problems.
As a firm believer in continuous learning, I am Microsoft Certified in Azure Data Fundamentals (DP-900) and actively studying for my next certifications (PL-300: Power BI Data Analyst & DP-600: Fabric Analytics Engineer) to deepen my expertise in building end to end data solutions.
Get In Touch
I'm always keen to connect with other data professionals and collaborate on interesting challenges.
If you'd like to talk about data, technology, or anything in between, feel free to get in touch.