Search

Search
- Search

analysis

14 posts

transformation powerbi

Transformation tools for easier analysis

Data Analysis & SQL

Ten Ways To Transform Data With Power BI

blogging vanity metrics marketing

Big numbers can be misleading

Data Analysis & SQL

What’s Wrong With Vanity Metrics

aws redshift analytics

New and exciting Redshift features

Data Technology

Amazon Redshift: 7 New Features for Data Analysts

excel tips and tricks

Excel for quick analysis and cleansing

Data Analysis & SQL

The 25 Best Ways To Excel in Excel

sql window functions

Window Functions are incredibly powerful

Data Analysis & SQL

SQL Window Functions: NTILE, LAG, and LEAD

window-functions-sql

Window functions are incredibly powerful

Data Analysis & SQL

SQL Window Functions: RANK and Running Totals

sql aggregates

Aggregates bring your data to life

Data Analysis & SQL

SQL Aggregate Functions and Mariah Carey

sql system diagrams

Not just a spaghetti mess

Data Analysis & SQL

Entity-Relationship Diagrams With Sonic the Hedgehog

sql server search system tables

Your database doesn’t just contain your data

Data Analysis & SQL

A Guide to Searching With System Tables

database dance class

Ballerinas and database concepts.

Data Analysis & SQL

Databases Are Like Dance Classes

sql concepts database

SQL concepts that pop up during training

Data Analysis & SQL

SQL Concepts From A to Z

sql indexes

Have you checked your indexes?

Data Analysis & SQL

Improve SQL Query Performance by Using Indexes

sql server join

Joining tables is a big learning curve.

Data Analysis & SQL

Relational Joins Without Venn Diagrams

customise sql server ssms

10 ways to make it work best for you.

Data Analysis & SQL

10 Ways To Customise SQL Server Management Studio (SSMS)