Data & Analytics Consultant
I help businesses unlock the value in their data — through Power BI dashboards, predictive modelling, and analytics that people actually use.
Latest project
Pareto Charts in Power BI
A DAX solution for a gap in Power BI's native visuals
Power BI · DAXMachine learning
House Price Prediction
Top 5% finish on Kaggle leaderboard
Python · XGBoostData visualisation
AdventureWorks Global Sales
End-to-end Power BI report from SQL Server
Power BI · SQLAbout
I'm Michael Pickett, a data and analytics consultant specialising in Power BI and predictive modelling. I work with businesses to turn raw data into clear, actionable insight — whether that's an executive dashboard, a machine learning model, or a custom DAX solution to a tricky reporting problem.
My work spans the full analytics pipeline: connecting to data sources, modelling and transforming data, building reports, and communicating findings to stakeholders. I care as much about whether insights get acted on as I do about the technical quality of the work.
This site is both a portfolio of projects and a space where I write about techniques I find useful — particularly in Power BI and Python.
Selected Work
A selection of recent work across Power BI, machine learning, and technical writeups.
Power BI · Data Visualisation
End-to-end Power BI report on Microsoft's sample SQL Server database. Covers currency conversion, star schema modelling, and DAX measures — with a Pareto analysis revealing that 4% of products drive nearly half of total revenue.
Machine Learning · Python
Predictive regression model for a Kaggle competition. Covers full EDA, feature engineering, log transformation, and a blended model combining 9 algorithms — including XGBoost, LightGBM, and Ridge Regression.
Power BI · DAX · Technical Guide
A detailed guide to building Pareto charts in Power BI using DAX — including a tiebreaker solution that handles the edge case where multiple items share the same value, which breaks the standard approach.
Contact
Whether you have a specific project in mind or just want to explore what better data could do for your business — I'm happy to have a conversation.
I'm available for contract and consulting engagements. I typically respond within one business day.