
Learn the data analysis process from gathering data from sources to cleaning, exploring, visualizing with charts and dashboards, and presenting findings with recommendations using tools like Excel, SQL, and Tableau.
Tackle missing values by deleting rows or dropping columns and highlight blanks in blue. Validate unit cost, unit price, revenue, and profit to confirm clean data.
Visualize the data to identify the most profitable segment and present a final dashboard with a recommendation to target USA adults and females from California.
This mini course helps you decide if data analytics is the right field for you and supports your learning and growth. Please consider leaving a review.
Data analyst is a broad term for someone who analyzes data and creates insightful visualizations that decision makers can act on. Skilled data analysts are some of the most sought-after professionals in the world. Due to this high demand, many professionals move to this field without taking time to explore the skills and challenges faced while performing this job. For this reason, I created this mini course to give you a real idea about the data analyst job. I chose Google Sheets because it will be easier for you to get to know this field by using familiar tool.
This mini course will help you to decide if data analysis field is the one for you. It's best to take a practical approach when deciding to pursue any scientific field under IT and Business. In this course, you will go through the process any data analyst goes through by working on real data mini project using Google Sheets.
You don't need specific skills other than knowing how to use excel or Google Sheets in general. The data source will provided for you to apply what you learned at your own device.
Feel Free to ask questions. I will be happy to help you with answers !