Finish the Crio.Do DA-201 capstone
The data analytics programme has one big project left. It goes on this site as entry 07 when it is done.
The lab log
Scientists keep a lab log: dated, short, honest entries about what they tried, what happened and what they learned. This is mine. It includes the courses I’ve finished, because learning is part of the work.
Log entries, newest first
- next
Crio.Do DA-201 (data analytics) in progress
The capstone comes after the coursework. It will become entry 07 on this site.
- built
MF4 Log Analytics goes public
Open-sourced the pipeline and dashboard, with a synthetic demo recording so anyone can run it, plus an interactive workflow page. See more →
- built
Global IT spend dashboard in Power BI
Plan versus forecast versus actual on 93,729 rows, with DAX measures, Power Query prep and a Python EDA notebook. See more →
- wrote
Twelve new UnFogIt explainers
Between 23 and 26 October: dark energy, quantum error correction, plant biosensors and more. Each takes a paper too dense for headlines and says what it found, in plain words. See more →
- built
ChatGPT review analysis
Sentiment and aspect analysis on 193,148 app reviews. Learned the hard way that star ratings and review text disagree more than you would expect. See more →
- built
Coca-Cola sales dashboard in Excel
SUMIFS, heatmaps and a dropdown explorer. The biggest market was not the most profitable one. See more →
- learned
Power BI and Tableau
Crio.Do course completed.
- learned
Data analysis with Python
Crio.Do course completed: pandas, cleaning, exploration.
- learned
Intermediate Python
Crio.Do course completed.
- learned
Python foundations
Crio.Do course completed.
- learned
Excel foundations
Crio.Do course completed.
- built
DSA learning log updated
Nine interactive note pages and 26 practice files so far. See more →
- learned
SQL foundations
Crio.Do course completed.
- built
pytest + Allure + CI for CAN tests
A small framework that publishes its own report to GitHub Pages on every push. See more →
- built
First experiments in public
Prompt collections, an n8n workflow idea, a D3 dashboard. Some of them are only placeholders, and they live on the Sketches shelf. See more →
Course dates are shown by month. Certificates are on LinkedIn.
On the bench
What’s next
A second analytics project on public telemetry data
Same habits as the MF4 work (two methods, a clear verdict, honest caveats), but on data anyone can download and check.
A chart in every UnFogIt piece
Pull one number out of each paper and draw it, so a reader can see the claim as well as read it.
Contact
Got a messy dataset or a science question?
I read everything and answer when I can. The quickest way is email, and LinkedIn works too.