Walter Boateng

To solve a business problem, data analysts must ask the right questions. Asking effective questions leads to getting the right insights from your analysis. Asking the right questions is the first step in the data analysis process. As data analysts, we ask a lot of questions. However, many beginner data analysts do not pay attention to this important step. The more questions you ask, the more you will learn about your data and generate more powerful insights from your analysis. It is good to ask questions, but some questions are effective while some are ineffective. The ability to ask the right questions is a skill set all data analysts must have. How to Ask Effective Questions Effective questions follow the SMART model. Specific, Measurable, Action-oriented, Relevant and Time-bound.  Specific questions are simple and focus on the most significant thing. Asking specific questions means you will get only the answers that are significant to the project. This will help you avoid being...

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...