Search

Search
- Search

Data Analysis & SQL

15 posts

Posts on ad hoc analysis and reporting.

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

data dashboards scoping

Deliver what they need, not what they think they need

Data Analysis & SQL

Are You Really Going To Use a Dashboard?

excel tips and tricks

Excel for quick analysis and cleansing

Data Analysis & SQL

The 25 Best Ways To Excel in Excel

data projects

How to gather requirements

Data Analysis & SQL

Six Tips for Scoping Data Requests

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)