Posts on ad hoc analysis and reporting.
Topics to explore as you begin your journey as a data analyst – project scoping, organisational context, and being curious about the data you are interpreting. Start wherever it feels good, and get excited about learning something new.
Vanity metrics often involve big numbers and as a standalone measure can be misleading and sometimes harmful
Scoping sessions help us to understand the problem so we can deliver what the stakeholder needs, not what they think they need
On first glance, Entity Relationship Diagrams may look like a spaghetti mess. This post hopes to demystify how they fit together with Sonic the Hedgehog
This post covers the SQL concepts that pop up during training. If you have a junior analyst in your life, keep reading
Scanning millions of rows each time you run a query is going be time-consuming and tedious. That’s where SQL indexes come in
SQL Joins are the first big learning curve after getting your head around the basics