In-Demand Data Analytics Job - Become Amazon Data Analyst

Become a HIGH EARNING Amazon Data analyst in just 1 course - Learn the core skills with real-life exercises!

What you'll learn

Manipulate raw data from Amazon and get core insights for your clients

Import and manage data between multiple Amazon reports

Create custom tables and views for your client's specific needs

Turn data into beautiful, insightful graphs and charts

Requirements

Basic knowledge of Amazon and how to access the basic reports

Description

Are you looking for an easy Data Analyst Job?Do you have just basic knowledge of Excel or Google Sheets?Then this course is for you!In this free course, you will learn the following:• The 14 most-used formulas you NEED to know to process 90% of Amazon product sales & product info data• How to turn a raw (and ugly) Amazon business report into an understandable and presentable table• How to bundle different products' data together to get an overview of their performance as a single category (Which category sells best? What are the top sellers for which category? Should you drop a category of products?) • How to easily connect/import data from one sheet to another (e.g. link ALL your clients' costs from start to finish (manufacturer costs, shipping costs, FBA fees, etc.) - An absolute requirement for any serious Amazon business!) • Analyze and estimate profits, margins, breakdown costs on a per-unit basis (How much are you REALLY making for each unit sold? Which products are worth the time invested? What's your real margin? Which products should you focus your optimization efforts on first?) •  Create your own custom reports and personalized views to display any data the way you (or your clients) want to see it • Custom filters and criteria so you can access exactly the kind of data you want (Want to know which of your products in category A are costing your client the most money? Easy!)  • Charts and graphs to represent the data that you want in a visually appealing way - (e.g. Revenue over time, Cost-per-unit breakdown, etc.) NOTE: Since March 2020, Udemy only allows free courses to be up to 2h long - this course condenses the most important in just that time!––––––––––––––––-Don’t worry – if somehow the course isn’t to your liking, you can always get your full money back, that’s Udemy policy – there’s zero risk for you, so just grab a cup of tea or coffee, get comfortable and let’s get going!––––––––––––––FAQ:Do I need to purchase anything for this course?You only need a version of Microsoft Excel (2016 and above) or create an account for Google Sheets (free). While the exact steps might be different, it is understanding the principles that's important - so don't worry, you do not need to spend a single cent!Do I need any prior knowledge or experience?As this course is designed for Amazon sellers, the only requirement here is for you to be somewhat familiar with Amazon Seller Central to download the reports. If you do not know what or where these reports are, you can easily check out a free tutorial on Udemy or another platform (e.g. Youtube) and then come back to the course afterwards. This should take no longer than 30 minutes at most.

Overview

Section 1: Introduction

Lecture 1 Introduction / Format of course

Lecture 2 14 Most Important Excel/Gsheet Functions for Amazon Reports

Lecture 3 Exercise #1 - Aggregating Sales Data

Lecture 4 Exercise #2 - Splitting Data into Categories

Lecture 5 Exercise #3 - Importing Data

Lecture 6 Exercise #4 - Product Details (Pricing & Margins)

Lecture 7 Exercise #5 - Custom Views & Formatting

Lecture 8 Exercise #6 - Multiple Criteria

Lecture 9 Exercise #7 - Graphs & Visual Data

Any aspiring data analyst looking for an easy-entry job into the e-commerce giant's 6 million sellers market