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. Data Analysis Project Datasets: You can click and download these files in your browser: […]
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 […]
What is the COALESCE Function in SQL? Coalesce is essentially a NULL killer. If you have a dataset in SQL that has a lot of NULL values, we can use COALESCE function to replace the NULL values. However, COALESCE is a versatile SQL function that can be used in a wide range of scenarios where […]
The hardest part of data analysis is sometimes knowing how or what to analyze. This a make or break skill for any data analyst. However, it can be challenging to know where to start and how to ensure you’re making the right conclusions. In this blog post, we will guide you through the six steps […]
As a data analyst or data scientist, knowing the right SQL queries can help you get the data you need from your database tables quickly and easily. Whether you’re a new user or a pro, you need to know how to use the basic SQL queries to analyze and change data. In this blog post, […]
There is no way to really know what questions you will be asked at an interview for a Tableau developer job. However, you do need to master some the concepts so that you inherently posses the flexibly to answer whatever the interviewer happens to throw at you. In this comprehensive post, you are going to […]
What is list Comprehension? This is a method in Python that It allows you to create a new list by transforming and filtering elements from an existing list. The beauty of this is its done in a single line of code. We can use a list and the word iterable interchanged due to a list […]
How Many Rows of Data Can Excel Handle? Excel spreadsheet can handle 1,048,576 rows and 16,384 columns at a time. If you are dealing with large datasets, it’s inherent that you will have limitations using Excel Power Query. If you haven’t heard of Power Query is a tool that is built into Microsoft Excel and […]
XLOOKUP is a relatively new lookup function that has advantages in terms of flexibility and simpler syntax over VLOOKUP. We will explore why these advantages and why VLOOKUP is more prone to issues that XLOOKUP escapes. Also, there may be a specific need for the user to choose XLOOKUP. First, let’s dive into a quick […]
Pandas is a powerful Python library for data manipulation and analysis, and one of its most useful features is the ability to create pivot tables. Pivot tables can help you summarize and analyze large datasets quickly and efficiently, and Pandas makes it easy to create them using the pivot_table() function. You can check out the […]
Find outlier is essential for a host of reasons from not skewing your averages to ensuring that machine learning algorithms function properly. In this tutorial, I am going show you several ways in which you can remove outliers from your data. We explore a few traditional methods such as Z-score and IQR. In addition, we […]
Table formatting is an awesome feature in Excel that allows you to sort and treat a range of data as a whole table. However, it does add some complications when you are trying to preform certain actions in Excel. So in this tutorial I am going to show you how to remove table formatting in […]