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.
Ah, Microsoft Excel—the bicycle for the mind. Excel is an amazing tool for working with smaller datasets. As you’re probably already aware, there is a myriad of functions and tools available to you in excel, but today we’re going to take a look at pivot tables—what they’re for, how they work, and what to expect … Continue reading Excel: Mastering Pivot Tables
“It’s a trap! Wait, is it a trap?” Today we’ll be discussing the topic of logic questions as they pertain to interviews—We’ll look at what they’re for and how they work. Then, we’ll go over how to break them down and respond to them quickly and accurately. Last, we’ll cover how to save yourself if … Continue reading Handling logic questions in an interview
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.