Gaelim Holland
Gaelim Holland
End-to-End Data Analysis Project | Product Analytics
Build and End-to-End Data Analysis Porfolio Project with SQL, Power BI and Database creation. You will easlily be able to build a stunning project analyst dashboard.
End to End Data Analysis Project
You’ll take on the role of a data analyst and create an end-to-end analysis using the provided data. Your goal is to build a dashboard that gives insights into various projects and their details. All the data files you need are included, along with video instructions to guide you through each step of the process. […]
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 […]
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 […]
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 […]
How to Use Block Comments in Python
You can easily create multi-line comments in Python with ease by using quotations. The # docustring will only allow you to comment per each line. However triple quotation “””” or ”’ should easily allow you to create multiple-line comments. Using Triple Quotes for Multi-line Python Comments Even though triple quotes are primarily used for docstrings […]