Foundation of Data Analytics
Enhance your data analytics skills with a Data Analytics foundation course and lab. The course and lab offer interactive learning resources that help candidates learn how to use data typologies, data analytics tools, business statistics, data visualization with the working and value of data, and many more. The course also covers the subject areas like processing, collecting, storing, and analyzing to help you in advancing your professional career. The course will help you in advancing your professional career.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
51+ Pre Assessment Questions |
53+ Post Assessment Questions |
Features
35+ LiveLab |
29+ Video tutorials |
38+ Minutes
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
The Value of Data
- Opening Case
- Introduction
- Managers and Decision Making
- The Business Analytics Process
- Business Analytics Tools
- Business Analytics Models: Descriptive Analytics, Predictive Analytics, and Prescriptive Analytics
- Summary
- Discussion Questions
- Closing Case 1
- Closing Case 2
Lessons 2:
Working with Data
- Some Sample Data
- Moving Quickly with the Control Button
- Copying Formulas and Data Quickly
- Formatting Cells
- Paste Special Values
- Inserting Charts
- Locating the Find and Replace Menus
- Formulas for Locating and Pulling Values
- Using VLOOKUP to Merge Data
- Filtering and Sorting
- Using PivotTables
- Using Array Formulas
- Solving Stuff with Solver
- OpenSolver: I Wish We Didn’t Need This, but We Do
Lessons 3:
Data Typologies and Governance
- Opening Case
- Introduction
- Managing Data
- The Database Approach
- Big Data
- Data Warehouses and Data Marts
- Knowledge Management
- Summary
- Discussion Questions
- Problem-Solving Activities
- Closing Case 1
- Closing Case 2
Lessons 4:
Business Statistics
- Introduction to Probability
- Structure of Probability
- Marginal, Union, Joint, and Conditional Probabilities
- Addition Laws
- Multiplication Laws
- Conditional Probability
- Revision of Probabilities: Bayes’ Rule
- Introduction to Hypothesis Testing
- Testing Hypotheses About a Population Mean Using the z Statistic (σ Known)
- Testing Hypotheses About a Population Mean Using the t Statistic (σ Unknown)
- Testing Hypotheses About a Proportion
- Testing Hypotheses About a Variance
- Solving for Type II Errors
- Summary
- Formulas
- Supplementary Problems
- Analyzing the Databases
- Case – Colgate-Palmolive Makes a “Total” Effort
Lessons 5:
Optimization and Forecasting
- Why Should Data Scientists Know Optimization?
- Starting with a Simple Trade-Off
- Fresh from the Grove to Your Glass…with a Pit Stop through a Blending Model
- Modeling Risk
- Wait, What? You’re Pregnant?
- Don’t Kid Yourself
- Predicting Pregnant Customers at RetailMart Using Linear Regression
- Predicting Pregnant Customers at RetailMart Using Logistic Regression
- For More Information
- Correlation
- Introduction to Simple Regression Analysis
- Determining the Equation of the Regression Line
- Residual Analysis
- Standard Error of the Estimate
- Coefficient of Determination
- Hypothesis Tests for the Slope of the Regression Model and Testing the Overall Model
- Estimation
- Using Regression to Develop a Forecasting Trend Line
- Interpreting the Output
- Summary
- Formulas
- Supplementary Problems
- Analyzing the Databases
- Case – Caterpillar, Inc.
Lessons 6:
Other Data Analytic Tools
- Getting Up and Running with R
- Doing Some Actual Data Science
Lessons 7:
Data Visualization
- Why Do We Visualize Data?
- How Do We Visualize Data?
- Color
- Common Chart Types
- When Our Visual Processing System Betrays Us
- Every Decision Is a Compromise
- Summary