Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Are You a Real Data Analyst ?
Rating: 4.4 out of 5(161 ratings)
2,446 students

Are You a Real Data Analyst ?

"Unlock Your Data Destiny: Discover if Data Analysis is Your Perfect Path with this Free Course!"
Created byReem Alashhab
Last updated 8/2023
English
English [Auto],

What you'll learn

  • Learn About The Data Analysis Process
  • Implementing Data Analysis Skills on Real Data
  • Learn How To Ask Questions and Write Recommendations About Data
  • Deciding If Data Analysis Is the Perfect Career Path

Course content

1 section • 10 lectures • 52m total length

  • Introduction2:49

    Learn the data analysis process and tasks using Excel, and assess whether you fit as a real data analyst, supported by practical guidance and inspiration.

  • Data Analysis Process3:38

    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.

  • What's the Last Step in Data Analysis ?
  • Data Gathering3:41

    Explore data gathering by sourcing bike sales data from Kaggle, importing into Google Sheets, distinguishing raw from clean data, and noting issues like missing values and duplicates.

  • Data Cleaning Part 16:08

    Inspect data to identify issues such as missing values, typos, and inconsistent formats. Clean and normalize fields like date, gender, country, and quantities to enable accurate analysis.

  • Data Cleaning Part 27:27

    Learn to inspect and fix columns, remove duplicates, and standardize fields such as date, age, gender, country, and product category through step-by-step edits in data cleaning part 2.

  • Data Cleaning Part 36:34

    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.

  • Data Exploration Part 16:28

    Begin data exploration after cleaning by creating and aggregating charts for orders, revenue, and quantity per day, adding labels, and considering marketing campaigns based on daily trends.

  • Data Exploration Part 28:00

    Explore user data through age group, gender, country, and state, using charts and pivot tables to identify marketing segments and top products for inventory planning.

  • Data Visualization and Recommendations6:39

    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.

  • Thank you and Good Bye0:50

    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.

Requirements

  • Basic Knowledge of Google Sheets

Description

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 !

Who this course is for:

  • Beginner Data Analysts
  • Anyone Interested to Enter Data Analysis Field

Report abuse