FDN-DA.AE1
Foundation of Data Analytics
Kickstart your career with this beginner-friendly Data Analytics course by learning how to use data for making informed decisions.
- Practice in 35 Laboratorios prácticos — nothing to install
- 7 Lecciones interactivas y 87 topics mapped to the official exam objectives
- 102 Preguntas del examen de práctica
Beginner A tu propio ritmo · 1 año de acceso 4.4/5 (27 Revisar)
35 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
7Lecciones interactivas
87Topics
35Laboratorio en vivo
102Preguntas del examen de práctica
112Tarjetas didácticas
112Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
Foundation of Data Analytics is a beginner-friendly certification course that focuses on data science tools for effective analysis and visualization. This introduction to data analytics course teaches you the techniques for transforming raw data into actionable insights that can be used for making informed decisions. Learn how to perform data manipulation and the role of this information in improving business statistics. Understand the dynamics of data optimization, and forecasting techniques using regression analysis, and data visualizations.
- Expertise is using Excel for handling and manipulating data
- Identify issues and perform data clean up
- Expertise in hypothesis testing, regression analysis, and correlation analysis
- Understanding the business landscape and use of data
- Knowledge of business analysis
- Maintain high-quality data for effective data management
- Creating informative charts for visual representation
- Communicate data-driven insights
- Exposure to R for Data science
Course Highlights
-
7 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
35 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
102 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
7 Lecciones interactivas · 87 topics01 The Value of Data 10 topics · 1 Laboratorio en vivo +
- 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
1 Laboratorio en vivo in this lesson — see the labs panel →
02 Working with Data 14 topics · 13 Laboratorio en vivo +
- 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
13 Laboratorio en vivo in this lesson — see the labs panel →
03 Data Typologies and Governance 12 topics · 2 Laboratorio en vivo +
- 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
2 Laboratorio en vivo in this lesson — see the labs panel →
04 Business Statistics 18 topics · 4 Laboratorio en vivo +
- 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
4 Laboratorio en vivo in this lesson — see the labs panel →
05 Optimization and Forecasting 24 topics · 2 Laboratorio en vivo +
- 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.
2 Laboratorio en vivo in this lesson — see the labs panel →
06 Other Data Analytic Tools 2 topics · 14 Laboratorio en vivo +
- Getting Up and Running with R
- Doing Some Actual Data Science
14 Laboratorio en vivo in this lesson — see the labs panel →
07 Data Visualization 7 topics · 3 Laboratorio en vivo +
- 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
3 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
35 Laboratorio en vivos- Summarizing the Aspects of Business Analytics and its Applications
- Freezing the Top Row
- Using the AVERAGE Function
- Using Relative, Absolute, and Mixed References
- Formatting Numbers
- Applying Conditional Formatting
- Using the Paste Special Feature
- Creating a Line Chart
- Creating a PivotTable Automatically
- Calculating the Minimum and Maximum Sales Value
- Using the SUM Function
- Using the MATCH Function
- Using the VLOOKUP Function
- Sorting Data
- Understanding Big Data
- Understanding the Relational Database Model
- Understanding Business Statistics
- Calculating the Statistics
- Using the SUMIF Function
- Using the IF Function
- Using the factor() Function
- Using the str() Function
- Using the sqrt() Function
- Using the matrix() Function
- Using the length() Function
- Using the rbind() and cbind() Functions
- Using the aggregate() Function
- Using the order() Function
- Using the predict() Function
- Using the print() Function
- Using the summary() Function
- Using the which() Function
- Visualizing Data
- Understanding Data Visualization
- Creating and Analyzing Chart Types
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
What is this Foundation of Data Analytics course?+
It is a basic data analytics certification course that teaches how to use data for making informed decisions.
Is this a beginner-friendly course?+
Yes, it is the perfect beginner data analysis course and you don’t need any prior experience for enrollment.
Is there a final assessment included with this Data Analytics fundamentals course?+
Yes, you’ll have to appear for a post assessment at the end of this course to earn your certification.
Go Deeper Into Data!
Gain the practical skills and knowledge needed to use data for making informed decisions.
- 1 año de acceso completo
- 35 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito