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.
We all have a resume. Some people consider the resume to be the most important part of their job application—they think that if their resume is impressive enough it will carry them through the interview process. However, while having an outstanding resume will certainly help your chances at landing a job, it will not land … Continue reading Speaking to the points on your resume.
Use these Microsoft Word templates to build your resume: Current Students Recent Graduates & Current Professionals
Today we’ll briefly discuss SQL joins—the method used to join two tables in a database together based on a given column (key) that they have in common. By the end of this article you should be able to explain the concept of a join as it applies to SQL and querying a relational database, as … Continue reading Overview: SQL Joins
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)
If you've ever been in an interview you know firsthand the feeling you get when the words "Let's go over a few technical questions." hit the deck. If the above sentence makes you want to run and hide, don't worry! We'll have lots of resources coming your way in the next few weeks on all … Continue reading Acing the SQL portion of an analytics interview.