Walter Boateng

dashboard Businesses need data specialists now more than ever. With a surge in demand for data professionals, many people are undergoing self training to fill the vacancies in the data space. There are many roles in the field of data. Data scientists, data engineers and data analysts are some roles in data analytics with high demand for skilled workers.  Many people are willing to dive into the field of data analytics. However, the question remains, 'how can one become a self-trained data analyst'? In this article, we shall look at the essential skills that are needed to get started as a data analyst. Having gone through this process myself, I have noted some key things that may be essential to every aspiring data analyst.  TECHNICAL SKILLS  There are different schools of thought on which technical skills are necessary and in which order one should learn them. Having been here myself and after making so many mistakes in my journey before finding my foot, these are the tec...

Introduction This project was an analysis of a Bike Selling Company`s dataset of its potential customers. This project was undertaken as a challenge by my mentor,  Alex the Analyst. The purpose of this project was to, among others; Find the correlation between income of citizens and their ownership of bikes. The relationship between marital status and owning a bike. If the distance people commute to work affect their bike purchase. How the education level of people influence their willingness to buy bikes. The relationship between different age groups and their purchase of bikes. Any other insight that may arise from the analysis. Data Gathering and Transformation The dataset was downloaded from Github. The link to the dataset was provided by Alex the Analyst , a mentor in the data community. To get the data, I simply clicked the link provided under his Youtube video and was taken to his Github Repository. The dataset was downloaded and converted to excel sheet. Cleaning the Data T...

An ecosystem, to put it simply, is a collection of components that communicate with one another. The jungle in a tropical rainforest or the amazon rain forest are examples of vast ecosystems. The germs on your skin may also be small, like tadpoles in a puddle. Additionally, data has its own ecology, just like the kangaroos and koala bears that reside in the Australian desert. Data is produced, managed, stored, organized, analyzed, and shared through the interaction of many different parts that make up data ecosystems. These components include the people who use the tools, as well as the technology and software. The cloud is another place where data can be found. Instead of storing data on a computer hard disk, you can use the cloud. So, data is accessed through the internet rather than being stored somewhere inside your company's network. As a data analyst, it is your responsibility to make the most of the cloud's role in the data ecosystem, locate the pertinent data, and offer...

The dataset was scrapped from kaggle.  This analysis was undertaken by Walter Boat, Lead Data Analyst at Data Driven Consult. Purpose The purpose of this analysis is to  determine the top selling product categories of the business.  The analysis is to determine the percentage of revenue that resulted in profit.  The company wants to find out the geographical location of their customers in order to determine where to invest their advertising budget.  The profit trend over the 4 years period was another paramount insight needed by the company to forecast future revenue. Getting the dataset This dataset was scrapped from kaggle.com  in csv format.  Cleaning the data Data cleaning was done using Microsoft Power Query. The data was moderately clean for analysis except for some few fields that do not affect the analysis. Fields such as customer name, customer ID and product ID were deleted. A new field (Year) was created from the order date to extract only t...