What did the developer say to the DBA? It doesn’t matter, the answer is “no.” I’ve never worked with a database administrator (DBA) before but know they play an important part in the data lifecycle at a company. Sean Scott stumbled into the DBA world and has been in this field for 25+ years. He […]
When you need to capture some data in a structured way, you’ll open up an Excel file or Google Sheet and just start throwing data into the spreadsheet. Not much thinking; just copy and paste. As that dataset grows, the original structure you had set up for that spreadsheet may not be ideal. Specifically, the […]
The QUERY() function in Google Sheets gives you the ability to quickly filter and sort your data similar to how you might get data from a database. If you write SQL queries, the QUERY() function feels easy and natural to use. There are a few caveats as I discuss in this episode. If you want […]
PivotTables in Excel are a great way to visualize your data. However, in order to easily query and summarize your data in the PivotTable, you need to properly structure your data set before building the PivotTable. Not only is the practice of streamlining your dataset into fewer columns good for PivotTables for different dimensions, this […]
Excel for the Real World I studentI use Excel and basic formulas already but there were basic techniques that I missed so this was great to fill in those gaps. On to class 2!
