Where to Find Data?

It’s often a struggle to find the good data that you really need to help enhance your data projects. However, Let’s continue to build a comprehensive list of sources that hopefully provide you with a wealth of datasets to work with. Check Out Data Camp to Practice Real-World Data Analysis Data Analysis Project Datasets: You […]

Get Google Trends Data into Power BI with Python

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 […]

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 […]

Best Power BI Courses

​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 […]

Filter Data with Python Query

I believe there a several Python functions that every data analyst should learn. VALUE_COUNTS, GROUPBY and QUERY is also on the list. Of course all these are part of the PANDAS library. So Let’s explore the query function. This function allows for filtering data frames using a concise and readable syntax. What is the basic […]

3 Ways to Calculate Percent Change in Python

Percent change using Pandas is one of the easiest ways to get the percent change formula. This can be done with a single line of code. However, you will need to use a data frame from the Pandas package to do this. I will show you multiple ways to calculate percent change with ease. Do […]

Python List Concatenation: Best Practices

In Python programming, the most used data structure is a list. It allows us to manipulate and organize data elements efficiently. Lists are particularly useful in data analysis, machine learning, and game development. As a data analyst, we apply different functions using lists. From those concatenation is an important function that involves joining multiple lists […]

Tableau vs. Power BI in 2023

Power BI and Tableau are the two most important data visualization tools. Both tools are used for data analysis, manipulation, and visualization to get insight from the data. However, both have their own unique selling point. Diving under the hood will tell you which solution is best for your specific use-case. In this blog, we […]

Handling Nulls in Python: A Hands-On Tutorial

Handling-Nulls-in-Python

When no value is assigned to a variable, it is referred to as a null value. In the world of data science and data analysis dealing with missing values is common but a challenging problem. It is difficult to analyze data with null values and to achieve accurate results. So, in this tutorial, we will […]

Extracting Zip Codes from Data in SQL

When dealing with large datasets, particularly those related to addresses or geographical locations, there’s a good chance you’ll need to extract or work with zip codes. SQL, as a powerful language for managing and querying databases, offers a range of tools and techniques to help you handle zip codes efficiently. 1. Basics of Zip Codes […]

SQL Union vs Union ALL

Union and Union All are two of the most important functions you will come across in SQL. There are must-to learn and easy to master. So I am going to provide you with a a few examples of using these SQL functions. Here’s what we’ll cover: What is the Difference between Union and Union All […]

How to Use Python FOR LOOPS

Python’s for loop is a versatile tool for iterating over data, essential for any business dealing with datasets. Let’s dive right into how businesses can leverage this. Basic Syntax for variable in iterable: This is the fundamental syntax of the “for” loop in Python . What’s an iterable? An iterable is any Python object you […]

3 Ways to RANK Data in SQL

What are the Ranking Functions in SQL There are 3 simple functions that you can use to rank data in SQL. If you are in a rush and want to dive right into learning how to use these ranking functions in SQL. Check out the YouTube short: Here are the ranking functions that will show […]

1 2 3 17