By Alexandra Blanc You read that right. A year into my career at a Big Four consulting firm, I went through a bad burnout. Shocker. While the competitive and fast paced nature of my job pushed me to work harder, faster, better every day, that wasn’t the only factor that led me to burnout. … Continue reading Want to become invaluable to your company? Take your vacation days
There are lots of companies out there, and lots of hiring managers to work for—but how can you tell if they’re any good? Often, we’re so focused on landing a job in the field of our choice that we forget that every industry is filled with bad managers and dysfunctional teams, and Analytics is no … Continue reading Vetting the quality of a hiring manager and their firm.
Today we’re going to talk about the basics of formatting a deck in PowerPoint. Before we start, it’s important to note that many companies have their own philosophies and methodologies around presenting and presentation building—what I am going to try to show here are some fundamental characteristics of a good presentation slide that will serve … Continue reading PowerPoint Basics: Building a slide for your deck.
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)