Phase 1 - Data Bootcamp I

Enroll for free

Course curriculum

1. AECC Course Curriculum
2. Helpful Tips
1. A message from the instructor
2. Week 1 Learning Objectives
3. Decision Making
4. Overview of Using Data and Excel Introduction
5. Spreadsheet Basics
6. Types of Data
7. Exploring Data with Excel I
8. Exploring Data with Excel II
9. Exploring Data with Excel IV
10. Pivot Tables
11. Overview of Data Visualization
12. Pivot Charts
13. Recommended Charts
14. Scatter Charts
15. Line Charts
16. Additional Visualizations for Multiple Variables Charts
17. Specialized Visualization - Waterfall Charts
18. Data Dashboards
19. Week 1 Graded Quiz
20. Individual Guided Project
21. Individual Project Submission Portal
22. Weekly Survey
23. Extra Project Resource
1. A Message from the Instructor
2. Week 2 Learning Objectives
3. Exploring Data with Excel III
4. Population vs Sample
5. Point Estimation
6. Hypothesis Tests
7. Errors and Significance Value
8. Performing Hypothesis Testing I
9. Performing Hypothesis Testing II
10. Performing Hypothesis Testing III
11. Performing Hypothesis Testing IV
12. Graded Quiz
13. Case Problem
14. Case Study Submission
15. Individual Guided Project
16. Individual Project Submission Portal
17. Weekly Survey
18. Extra Project Resources
19. Projects Solutions
1. A Message from the Instructor
2. Week 3 Learning Objectives
3. Introduction to Regression Analysis
4. Simple Linear Regression
5. Performing Simple Linear Regression
6. Assessing the Fit of the Simple Linear Regression Model
7. Assessing the Fit of the Simple Linear Regression Equation II
8. Multiple Linear Regression
9. Performing Multiple Linear Regression
10. Assessing the Fit of a Multiple Linear Regression Equation
11. Performing Multiple Linear Regression (with a Categorical Variable)
12. Performing Multiple Linear Regression (with a Categorical Variable) II
13. Graded Quiz
14. Case Problem: Azubi Research, Inc.
15. Case Study Submission
16. Individual Guided Project
17. Individual Project Submission Portal
1. A Message from the Instructor
2. Week 4 Learning Objectives
3. Getting Started
4. Your Coding Home
5. Your Journey to Programming Starts Here!
6. Variables as Tags
7. Names Are Important
8. Lets Do Some Math with Python
9. Working with Strings
10. Working with Strings (some more)
11. Leaving hints in your code (for your future self 😎)
12. Libraries, Packages and Modules
13. Intro to Pandas DataFrame
14. Even More Pandas DataFrame 😎
15. Plotting with a Pandas DataFrame
16. Case Study
17. Case Study Submission
18. Individual Guided Project
19. Individual Project Submission Portal
20. Weekly Survey
1. A message from the instructor
2. Week 5 Learning Objectives
3. Join the Microsoft 365 Insider Program & Installation
4. Using the PY Function in Excel
5. Clean, Dealing with Data in Excel using Pandas
6. Pivoting and Grouping Data in Excel using Pandas
7. Graded Quiz
8. Individual Project
9. Individual Project Submission Portal
10. Weekly Survey
1. Data Querying: Analytics with SQL Course Curriculum
1. A Message from the Instructor
2. Week 6 Learning Objectives
3. What is a Database?
4. What is MySQL? (Install MySQL for Windows)
5. Using SQL Shell
6. Populating and Modifying Tables I
7. Populating and Modifying Tables II
8. The SELECT Clause
9. The FROM Clause
10. The ORDER BY Clause
11. The WHERE clause
12. Querying Multiple Tables
13. Querying Multiple Tables II
14. Graded Quiz
15. Case Study: Wave Database
16. Case Study Submission
17. Individual Guided Project: Northwind Database
18. Individual Guided Project Submission
19. Weekly survey
20. Extra Resources
1. A Message from the Instructor
2. Week 7 Learning Objectives
3. Groupings and Aggregates I
4. Groupings and Aggregates II
5. Subqueries I
6. Subquery II
7. Subquery III - Common Table Expressions
8. Conditional Logic
9. Practice Quiz
10. Graded Quiz
11. Case study
12. Case Study Submission
13. Individual Guided Project
14. Individual Guided Project Submission
15. Weekly Survey
1. Curriculum
1. Learning Objectives
2. Data
3. Roles that uses Data
4. Install Power BI
5. Intro to Power BI
6. Video dataset - Practice Files
7. Basic Data Visualization
8. Graded Quiz
9. Case Study
10. Case Study Submission Portal
11. Individual Guided Project
12. Individual Guided Submission Portal
13. Weekly Survey
1. Learning Objectives
2. Data Prep and transformation with Power BI Query Editor
3. Basic Data Modeling
4. Modelling tables with complex relationships and DAX
5. CRISP-DM Framework
6. Case study
7. Individual Guided Project
8. Weekly Survey
1. Learning Objectives
2. Designing Reports Requirements
3. Principles of UI Design I
4. Principles of UI Design II
5. Ways to collaborate and share in Power BI
6. Configuring Workspaces I
7. Monitoring Usage I
8. Graded Quiz
9. Case study
10. Case Study Submission Portal
11. Individual Guided Project
12. Individual Guided Project Submission
13. Weekly Survey
1. A Message from the Instructor
2. Learning Objectives
3. Outstanding Leaders Use Data
4. Demystifying Data Science
5. Data Science Fundamentals
6. Insights from Google Data Scientist Interview
7. The Importance of the Right Business Understanding (Hunter Dunlap)
8. What Even is Big Data?
9. What Does Big Data Mean and How Can it Help Us See?
10. How Machines Learn
11. Advanced Machine Learning Algorithms
12. Introduction to Deep Learning
13. (Bonus Material) Google Translate Breakthrough
14. (Bonus Resource) An Executive's Guide to AI
15. Gathering Data versus Executing on Data
16. Why good data matters more than great AI
17. Mastering how to tell a story through Data
18. The art of data visualizations
19. Data Science Use Cases
20. Data Insight Drawbacks?
21. Insights from AirBnB Data Science
22. (Case Study) Instacart
23. (Case Study) Booking.com
24. 4 Things For Getting The Most Out of Your Data
25. Graded Quiz
26. Case Study
27. Case Study Submission Portal
28. Individual Guided Project
29. Individual Guided Submission Portal
30. Weekly Survey
1. Learning Objectives
2. The Rapid Advance of AI in Organizations
3. What's the Difference Between a Plan and a Strategy?
4. Managing a Data Science Team
5. What You Should Know to Lead a Data Driven Organization!
6. Data-driven Innovation (Prof. Dr. Michael Bücker)
7. The Value of Data For Your Organization (Prof. Dr. Michael Bücker)
8. Black Box AI and how to deal with this (Prof. Dr. Michael Bücker)
9. Things You Need to Know For Building a Data Product
10. Insights from AirBnb Data Science Pt 2
11. (Case Study) Instacart Part 2
12. (Case Study) Booking.com Part 2
13. (Bonus Material) Lecture on Leading A Data Science Team
14. Graded Quiz
15. Case Study
16. Case Study Submission Portal
17. Individual Guided Project
18. Individual Guided Project Submission
19. End of Phase 1 Survey

About this course

Free
211 lessons
15.5 hours of video content

Discover your potential, starting today

Enroll today

Phase 1 - Data Bootcamp I

Course curriculum

Module 1 - Analytics With Excel Crash Course (AECC)

Week 1

Week 2

Week 3

Week 4

Week 5

Module 2 - Data Querying: Analytics with SQL

Week 6

Week 7

Module 3 - Power BI Dashboarding

Week 8

Week 9

Week 10

Week 11

Week 12

About this course

Discover your potential, starting today