Analyst Pro Tip: Consolidate your data in one place before analyzing it.

We picked up this seemingly obvious tip from the software development world--but it applies for data analysis quite nicely. In SD, there is a very precise set of rules which programmers follow to make sure that any changes they have to make while they build are easily trackable and reversible. In web dev in particular,  … Continue reading Analyst Pro Tip: Consolidate your data in one place before analyzing it.

Overview: Relational Databases and Structured Query Languages (SQL)

Today we’re going to go over the concept of relational databases—what they are and how they work. We will also take a look at structured query languages and how they are used to interact with relational databases, including presenting and going over a common sample interview question you may come across. By the end of … Continue reading Overview: Relational Databases and Structured Query Languages (SQL)