Tag: analysis
-
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
-
Amazon Redshift: 7 New Features for Data Analysts
New and exciting Redshift features to improve the data warehouse service and add interoperability with other AWS
-
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
-
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
-
Pearl Jam, Nirvana and Beautiful Data Visualisations
This is the story of the Seattle music scene of the 90s, Throwback Thursday, and some beautiful data visualisations