Resources. Learn faster with practical guides and examples.
8 resources
How to Clean Data in Excel: Formulas, Tools, and What to Watch Out For
A practical guide to cleaning messy Excel data — covering TRIM, duplicates, capitalisation, date formats, blank rows, and when a macro saves you hours.
Read →
How to Clean Messy Excel Data in One Click
A full walkthrough — enabling macros, pasting your data, running Clean All or individual steps, and standardising date formats. No formulas required.
Read →
When Does a Live Clock Actually Add Value in Power BI?
Not every dashboard needs one. A look at the real use cases, design considerations, and when a live clock genuinely earns its place.
Read →
How to Add a Live Clock to Power BI Using Deneb
A full walkthrough — installing Deneb, pasting the spec, customising colours, timezone offsets, labels, digital time, and publishing to Power BI Service.
Read →
How to Make Power BI Dashboards Look More Modern
Background colours, visual clutter, colour discipline, whitespace, custom Deneb visuals, and animation — what actually moves the needle on dashboard design.
Read →
How to Set Up a Power BI Dashboard for a TV or Office Screen
Layout, legibility, dark themes, ambient motion, auto-refresh, and how to get Power BI onto a display screen — everything that changes when you design for a wall rather than a browser.
Read →
How to Add a Particle Text Visual to Power BI Using Deneb
A full walkthrough — installing Deneb, pasting the spec, setting phrases, customising particle style, glow, animation, and canvas size, and publishing to Power BI Service.
Read →
How to Add a Particle Screen to Power BI Using Deneb
A full walkthrough — installing Deneb, pasting the spec, customising particles, connections, interactions, and canvas size, and publishing to Power BI Service.
Read →