These questions cover what data analysts would face at an entry-level to the intermediate range for SQL. Depending on the organization and role, the requirement for SQL knowledge may increase. However, these will cover the main concepts from joins, subqueries, grouping, alias, and filtering. You can practice all these SQL queries on our free platform: […]
The dictionary (short form dict) is a fundamental data structure in Python. It uses key-value pairs to store the data in an efficient manner. Creating dictionary is a simple task in python however, we can use different ways to create a dictionary that fits our real data. In this article, we will learn three methods […]
As the volume of data triples each year, businesses are challenged to make sense of it. Many will turn to use data visualization software to gain a deeper understanding of their key performance indicators and derive insights. Using business intelligence software allows one to interact with, interpret, and display the data, among many other great […]
Often we we want to show the size differences for groups, we can use things like a tree map. A tree map plot doesn’t come out out the box with the traditional plots such as Matplotlib and Seaborn. The tree map provides a visual representation of the various proportions of categories, much as a pie […]
Data Analytics vs Data Science Let’s first help you to define the difference between these two terms. Data analytics is a strategy-based science that can help you analyze raw data, allowing for trend detection and answering questions. Data analysis helps you to draw the right conclusions from a huge batch of data. Moreover, it helps […]
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 […]
One of the easiest projects that you can do in Python is creating a dataset by scraping a particular website In this project , we will use the PyGoogleNews library to extract Google News elements. We will optimize this this web scrapper to focus on a particular keyword, language and search engine location. Additionally, you […]
One of the easiest ways, to compare this is using the lag function. The lag function will allow you to shift the rows downward so that you can view these rows as one observational row. Here is a simple example of how to use the lag function to shift rows downward. You can Practice FANG […]
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 […]
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 […]