Category: Data Analysis
Posts on ad hoc analysis and reporting.
-
Data Analyst Roadmap: more than just the tools
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.
-
The Trouble With Vanity Metrics
Vanity metrics often involve big numbers and as a standalone measure can be misleading and sometimes harmful
-
Are You Really Going To Use a Dashboard?
Scoping sessions help us to understand the problem so we can deliver what the stakeholder needs, not what they think they need
-
Entity-Relationship Diagrams With Sonic the Hedgehog
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
-
SQL Concepts From A to Z
This post covers the SQL concepts that pop up during training. If you have a junior analyst in your life, keep reading
-
Improve SQL Query Performance by Using Indexes
Scanning millions of rows each time you run a query is going be time-consuming and tedious. That’s where SQL indexes come in
-
Relational Joins Without Venn Diagrams
SQL Joins are the first big learning curve after getting your head around the basics
