As of the time of writing this post, there is no native connector in Power BI for Google Trends API to pull data directly a report. However, we can easily do this with just a few lines of Python code. This will allow you to bring in multiple keywords to compare trends over time. We […]
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 […]
Data analysis is among the most in-demand skills in 2021. It is a field with many facets – from working with raw data to uncover actionable insights to knowing how to showcase these in a way that’s easy to consume, data analysis can help any project – big or small.As someone who has worked in […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]