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 […]
Power BI’s user-base is growing daily. In just a few years, the adoption of Power BI into data productivity suites has exponentially grown. The team at Microsoft provides monthly updates that increase Power BI’s functionality and customization. If you are familiar with the field of data visualization, you would have heard of Power BI as […]
I thought this might be helpful. I have been working in data. I get a lot of DMs on LinkedIn on what makes a good data analyst CV. I’ve hired about 30 analyst in my career and interviewed a many. Here are the things I think really work and get the attention of HR, CV […]
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 […]
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 […]
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 […]