10 ways to transform data in Power BI
If you are new to PowerBI or upgrading your analysis from Excel getting acquainted with transformation tools will make it easier to perform analysis
Category: Data Analysis & SQL
Posts on ad hoc analysis and reporting.
The trouble with vanity metrics
Vanity metrics often involve big numbers and as a standalone measure can be misleading and sometimes harmful
Do you really need a dashboard?
Scoping sessions help us to understand the problem so we can deliver what the stakeholder needs, not what they think they need
25 ways to excel with Excel
It doesn’t replace databases and BI tools for reporting, but Excel is just what you need for quick analysis and cleansing of small data sets
Conditional logic with the CASE expression
CASE is SQL’s equivalent to IF-ELSE statements in other programming languages. This expression allows you to test a condition and return a value.
Tips for successful data projects
How to gather stakeholder requirements and run successful projects without burning out or ending up doing nothing well.
