Fill Blank Cell with Previous Cell

Excel has a lot of great functions and shortcuts that will make data cleaning and manipulation easier. Not knowing these techniques will add frustration and a lot of time to your current workload and analysis. You can follow the instructions below to figure out how to fill blank cells with previous cell values. Check out […]

Pandas Crosstab

Let’s talk about how to do some bi-variate analysis using the Crosstab function from pandas. The Crosstab function is very flexible and allows us to compare two categories. As usual, we’ll work on this practically using a sample dataset. We’re going to analyze a BankChurn dataset to see when our customers left and the different categories […]

Pandas Group By Function

Grouping data is one of the most important skills that you would require as a data analyst. Luckily, Pandas has a great function called GroupBy which is extremely flexible and allows you to answer many questions with just one line of code. In this tutorial, we’re going to understand the GroupBy function and subsequently answer […]

Word Frequency with Python

One of the key steps in NLP or Natural Language Process is the ability to count the frequency of the terms used in a text document or table. To achieve this we must tokenize the words so that they represent individual objects that can be counted. There are a great set of libraries that you […]

Python Data Science Interview Questions and Answers

Honestly, knowing Python and knowing how to answer interview questions with Python can be two separate skills. I have bombed interviews due to not explaining my thought process when approaching a problem. Often interviewers are not concerned that you arrive at a perfect answer in the limited time that you are given. They put more […]

Statistical Tables in Power BI with Python

One of the best things about Python is the sheer number of libraries that can easily be used. You can create correlation tables and statistic summary tables similar to what you find in the data analysis tool kit or in the Pandas library in Python with the native functions. How to create a correlation table:1. […]

Power BI Interview Questions

Here is a list of common Power BI interview questions that are open ended and use to demonstrate the overall knowledge of the applicant. These questions are real and allow you to find intermediate level Power BI practitioners. Answering 6 out of the 10 question would demonstrate a confident familiarity with Power BI.  1. Where […]

Calculate Totals Month to Date & More in Power BI

How to Calcuate MTD, QTD and YTD in Power BI Calculating the month to date, year to date, or quarter to date is not as daunting as you think in DAX. However, there are few stepst that are needed before you can get these function to provide the information that you are looking for.  These […]

Format all the Font in Power BI

You can quickly get uniform text accross your visuals by using the Power BI themes customization. In just a few steps you will be able to quickly alter the text family.  Step 1: Go to Theme Options The first step you will need to take is to navigate to the top ribbon in Power BI […]

1 6 7 8 9 10 17