If you’ve worked with Excel and/or with data for a while, you’ve probably dealt with pesky date formats. Dates come in a variety of makes and models including “d/m/y”, “mm/dd/yy”, “yyyy-mm-dd” and on and on. There’s nothing worse than opening Excel, applying filters, then dropping the filter menu down to find that Excel is reading … Continue reading Pesky Date Formats
As you set out to learn a new skill, it’s often to difficult to pinpoint where you need to begin. Many times we do not know what we don’t know. Having read many articles discussing the skills needed for successful Data Analysts, I know tools like SQL, R, and Python are heavily used in the … Continue reading Twitter
Scheduling R Scripts on Windows
When I first started hearing and learning about R, it was presented to me as more of a “statistical language.” Admittedly, my statistical knowledge is still growing and I questioned whether learning R would be useful for me. However, as I dove in, I quickly learned that R is a powerful tool for many tasks … Continue reading Scheduling R Scripts on Windows
IN and Subqueries
I’d like to share my current favorite SQL "combo," if you will. The database I use on a daily basis is designed such that there are several main tables that hold IDs and metrics followed by several tables that act as libraries and hold the values that are paired with each ID. Here is a … Continue reading IN and Subqueries