Analytics Mentor Data Analytics Professional Certificate
Learn the real-world skills necessary to get a career in Data Analytics. In this program, you'll learn real-world analytics skills, build a portolifo, and prepare yourself to pass your interivew. Learn at your own pace, no degree or experience required.
Taught by an industry leader, Brandon Southern from Amazon, eBay, VMWare, and more. With 25 years' in analytics and 15 years' experience hiring and educating data analysts.
Only $99.99 for lifetime access!
You won't find a more comprehensive course package or better value anywhere else!
12 course series
End-to-end training package!
Instructor Experience
25 years - Amazon, eBay, & more
Beginner Level
Experience recommended
Flexible Schedule
Learn at your own pace
What you'll learn
Learn in-depth and real-world practices that you'll use on a daily basis as a data analyst.
Understand how to write code with SQL the way that companies want you to use it. Learn the best practices and how to write high-quality, and high performance code.
Learn to create real-world dashboards and visualizations that recruiters and hiring managers are impressed by.
Learn how to perform in-depth analysis and work like a highly-valued data analyst, using real-world case studies.
Explore the 12 course series
Learn the real-world skills necessary to get a career in Data Analytics. In this program, you'll learn real-world analytics skills, build a portfolio, and prepare yourself to pass your interview. Learn at your own pace, no degree or experience required. Get the professional training from one of the most experienced leaders in the industry. Receive the most value at the lowest cost for training out there!
What you'll learn
- Introduction to your instructor and opening statements about the field of data analytics and what we will cover in this course on your journey to becoming a data analyst.
- What does an analyst do? How what is the salary of a data analyst? How much can a data analyst make? How do I get started in this field?
- Live demo using Excel, pivot tables, Tableau, SQL, and a Database.
What you'll learn
- Learn the common functions to navigate Excel with sheets, sorting, filtering, grouping, hiding, and basic formula usage.
- Learn to use the most common functions including sum, sumif, count, countif, min, max, xlookup, vlookup, quartiles, mean, median, mode, and more.
- Learn to use the most common charts including bar chart, line charts, scatter plots, pie charts, dual axis charts, and Pareto charts.
- Learn to use and navigate Pivot tables with ease.
What you'll learn
- Installing PostgreSQL
- Datatypes
- Creating Tables
- Dropping Tables
- Adding Columns to Tables
- Dropping Columns from Tables
- Altering Column Datatypes
- Renaming Column
- Inserting Individual Records
- Deleting and Updating Records
- Adding Unique ID Fields
- Working with Multiple Tables
- Importing CSV Data
- Inner and Left Joins
- Right Joins
- Full Outer Joins
- Why Use Outer Joins
- Self Joins
- Changing Output Field Names
- Cross Joins
- Primary and Foreign Keys
- Introduction to Conditional Filters
- 'ILike' Condition
- 'IN' Statement
- 'Distinct' values
- 'Upper' and 'Lower' Conversions
- Special Column Output Options
- Aggregating Data Using 'Having' and 'Group by'
- Aggregate Functions 'Min', 'Max', 'Sum', 'Avg'
- 'Coalesce' Function
- 'Concatenate' Function
- Understanding and Handling Null Values
- Casting Datatypes
- 'Case' Statements
- Sub-Queries
- 'Union' and 'Union All' Statements
What you'll learn
- Indentation
- Lines Between Sections, Wrapping Text
- Aliases
- One Item per Line
- Multiple Case Conditions
- Capitalization
- Leading Commas
- Comma Confusion
- Aggregate Function Placement
- Aligned Joins
- Block Code Comments
- In-line Code Comments
- Poor Code Comments
- Common Table Expressions (CTEs)
- Group by
- Parama
- Timestamp Field Names
- 'In' Statements
- Temp Tables
- Select *
- Where 1=1
- Generic CTE Names
What you'll learn
- Challenges with Excel
- About Tableau
- Challenges with Tableau
- Tableau Compared to Excel
- Tableau Terminology
- Tableau Overview
- Installing Tableau
- Course Learning Tips
- Tasks Overview
- Thinking About What to Build
- Building the Revenue Dashboard
- Adding Graphs to the Revenue Dashboard
- Dashboard Documentation
- Saving Your Workbook
- Creating the Products Dashboard
- Creating the Store Performance Dashboard
- Debugging the Dashboard
- Fixing Bugs in the Dashboard Data
- Sales Overview Dashboard
- Building the Sales Overview Dashboard
- Cleaning Up the UI
What you'll learn
- Database Setup
- Common Table Expressions (CTEs)
- Data Params
- Aggregate Window Functions
- Row Number
- Lead & Lag
- Dense Rank
- Percent Rank
- Quartiles
- Median / Percentiles
- Stastical Summary
- Advanced Window Functions
- Date Functions
- Split Part
- Length and Trim
- Regular Expressions
- Intersect
- Update from Select
- Insert from Select
- Views
- Understanding Performance
- Indexes
- Partitions
- Auto Increment Primary Key
- Constraints
- Functions
- Stored Procedures
What you'll learn
- All about your employer, what do they want, what results are they looking for, and how do they choose the best resume and candidate.
- What a resume is and what it isn't, what story you're telling, and how to align with your prospective employer.
- Specific categories, items of what needs to be on your resume, how to format them, and create a resume that stands out from everyone else.
- What to avoid listing on your resume that will almost certainly cause it to be rejected.
- Additional points of consideration and caution to avoid being screened out of the process.
- Live analysis and feedback on example resumes
What you'll learn
- Learn the stages of the interview, what the interviewer is looking for, how to prepare for the interview.
- Live demo of a mock interview question and how to prepare.
- Learn more best practice tips to succeed in your interview. Also, learn to use the valuable templates that have been provided!
What you'll learn
- Test your skills on real-world practice questions.
- Live simulation of what a real interview will feel like
What you'll learn
- Overview of Being a Data Analyst
- Day in the Life of a Data Analyst
- Handling Stakeholder Requests
- How to Solve Problems
- Communicating Results
- Fun Parts of Being a Data Analyst
- Challenging Parts of Being a Data Analyst
- Getting Started and Working Successfully
- Onboarding Overview
- Goals of Onboarding and Your Plan
- Organization Chart
- Learn the Teams
- Meeting the Teams
- Onboarding Wrap-up
- Getting Organized
- Challenges & Results of Poor Organization
- How to Stay Organized
- Handling Technical Tasks
- Handling Other Tasks
- Saving Code and Files
- Naming Conventions
- Getting Organized Wrap-up
- Communications Overview
- Assuming Positive Intent
- Disagreements
- How to Disagree
- Giving Proper Context
- Getting Too Technical
- Making Stakeholders Chase You
- Shorthand Messages
- Office Gossip
- Acronyms
- Pick Your Battles
- Invalidating Words
- Quality of Work
- Words of Honesty
- Weasel Words
- Clear Needs
- Escalations
- Building Connections
- Communications Wrap-up
- Doing the Job
- Handling Requests
- Formal & Informal Requests
- Quality of Requested Work
- Prioritization of Requests
- Getting Clarification
- Prioritization & Pushing Back
- Doing the Work
- Documenting Your Tasks
- Documenting Your Work
- Performing Quality Assurance Checks
- Communicating with Stakeholders
- Getting Promoted
- What it Takes to Get Promoted
- Building Trust
- Providing Status Updates
- 1 on 1 Meetings
- Monthly Career Development Meetings
- The Promotion Process
What you'll learn
- Live coding demostration
- Proper SQL writing practices
- How to properly approach an analytics problem
- Performation quality assurance checks
- Understanding query performance
- Performing a real-world analysis
What you'll learn
- How to think like a high-value data analyst
- Proper ways of approaching analytics problems
- Quality assurance checks
- Developing business acumen
- Understanding stakeholder requests
- Dealing with ambiguity
Frequently Asked Questions
Will I build a portfolio?
Yes, you will build a real-world Tableau project that consists of 4 dashboards and 27 worksheets. This work is based on a custom built dataset of 300k customers, 1M transactions, 6.4M transaction line items, 3k products, and more! Also, it's exactly like what you would see being used at companies like Amazon, eBay, and more!
After building your dashboards, you can publish to Tableau public and make it part of your portfolio of work. You can also use this data to perform more practice!
Who is this course designed for?
This course is designed for anyone that is interested in becoming a data analyst or business analyst. It's also a prerequisite for becoming a data scientist or data engineer.
How long is this course and can I complete it at my own pace
This is a self-paced course so you can start and stop as needed and take the course all at once or in small increments. This course has over 13hrs of video content. Completion time will vary as students will be performing homework and other exercises during the course. Watching and performing the lessons for ~ 10hr/wk may take about 6 weeks to complete to ensure that you understand the material.
Will I need any prior knowledge or experience in data analytics?
No. Prior knowledge is not required for this course. You should have basic computer skills such as installing software.
What kind of support is available to me while taking this course
You can email your instructor with questions about this course and content. You can also leverage the FREE Discord community to ask questions. One-on-one coaching is available where you can discuss any topic of your choosing for an additional fee.
What certification will I receive upon completion of this course?
You will receive a certificate of completion for the Analytics for Beginners course from Analytics Mentor. This is an educational item that you can add to your resume potentially to improve your chances of obtaining a job in the field of analytics.
How should I take this course?
First, I recommend that you take a course from the course package and simply watch it from start to finish. Don't try to do the demo work or feverishly take notes. Just watch, listen, learn, and get the 10,000ft view of what we're working on.
I've seen people try to "do" at the same time that they are trying to learn new material, and it tends to reduce understanding and applied knowledge.
Second, after you watch the course, go back a second time and perform the exercises. This time, watch the course module, pause when we get to the lesson work. Try to complete the lesson without the video. This will give you more of those "ah-ha" moments of success! You can always click the play button if you get stuck.
What order should I take the courses in?
I recommend that you completed the courses in the order that they are listed above. However, some may find the Advanced SQL course to be too advanced.
If you find this to be the case, I recommend watching the course to develop context and awareness, then move on to the other courses. After practicing and gaining sufficient experience with the skills taught in the SQL for Beginners course, I recommend coming back to the Advanced SQL course.
