Newly Launched: Data Visualization in Power BI

My latest DataCamp course has soft launched: Data Visualization in Power BI. This course takes you through the different visuals offered in Power BI, but it does a lot more than simply iterate through a list. Throughout the course, we will mix insights of psychology with practical implementation in Power BI. If you've seen my…

A Slice of Time: Good Use Cases

This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we've looked at five classes of window function in SQL Server. I've given you a couple of solid use cases, but for the most part, we've focused on what the classes of window functions are.…

A Slice of Time: Statistical Functions

This is part five in a series on window functions in SQL Server. Reviewing the Statistical Functions The next set of window functions we will look at are the statistical functions. There are four of them: PERCENT_RANK(), CUME_DIST(), PERCENTILE_CONT(), and PERCENTILE_DISC(). PERCENT_RANK and CUME_DIST PERCENT_RANK() is a fairly straightforward function: rank each window based on…

Interesting Resources for Chapter 1

For each chapter in Finding Ghosts in Your Data, I'll include a few resources that I found interesting. This isn't a bibliography, strictly speaking, as I might not use all of these in the course of writing, but they were at least worth noting. Books Anomaly Detection Principles and Algorithms by Mehrotra, et al. I'll…