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.
-
Ten Ways To Transform Data With Power BI
If you are new to Power BI or upgrading your analysis from Excel getting acquainted with transformation tools will make it easier to perform analysis
-
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
-
The 25 Best Ways To Excel in 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
-
Six Tips for Scoping Data Requests
How to run successful projects, manage expectations and gather stakeholder requirements without burning out or ending up doing nothing well
-
SQL Window Functions: NTILE, LAG, and LEAD
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers
-
SQL Window Functions: RANK and Running Totals
SQL window functions allow us to see the rows in a table with a new column showing a running total, rank or moving average
-
SQL Aggregate Functions and Mariah Carey
SQL aggregate functions bring your data to life. They allow you to take a standard table and use a function or two to build metrics and answer questions about the data
-
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