Another SQL query

Today, I spent a substantial chunk of the day writing a query. This is the first major report I have created that is specific to the provider data that my team maintains.

I started with a blank tab in SQL Server and slowly pieced it together. I set a record with joining a table five separate times. There happens to be one table that stores affiliations between providers, and the type of affiliation determines how the data need to be displayed.

They have a data warehouse where they are storing the same information, and they are using something called PowerBI that has a user interface that let’s you manipulate the data to export it to a report. I have never used PowerBI, and rather than learn it, I’d rather just create SQL queries and pull the data myself. Sooner or later I may be forced to learn PowerBI, but until then it’s SQL all the way. After all, they need everything yesterday. When you need things fast, no time for training.

Creating this query was my favorite part of the day. It’s nice to have an output that will be useful. Unfortunately, that just means tomorrow I will be catching up on emails that I neglected while I was toiling away.