Patrick Curtis – Data Analytics Course
In this module, we use 7 video lessons to explain statistics fundamentals such as Standard Deviation and Correlation and their applications. This includes real examples to make sure you understand how to apply the concepts you learn.
In this module, we use 3 video lessons to learn regression analysis to analyze the relationship between two variables. We wrap up this module by exploring the conclusive evidence we can derive from regression analysis.
In this module, we use 4 video lessons to dive into our data analytics Bootcamp by exploring some simple analytics we can concur from the data set. This module also includes a step-by-step walkthrough of using excel to work through the data set.
In this module, we use 3 video lessons to explore how we can use analytics to create a narrative within our data. This module also includes a walkthrough on how to create a histogram distribution to visually show our data.
In this module, we use 4 video lessons to explain how we can use Pareto analysis in order to find inconsistencies within our data. This module also includes a guide on how to use pivot tables to conduct Pareto analysis in Excel.
In this module, we use 3 video lessons to dive into the correlation between gender and salary within our company data set. We wrap up this module by exploring other inferences we can conclude from our data set.
In this module, we use 5 video lessons to revisit regression analysis using a different data set. In this module, we use a new Excel plug-in Analysis Tookpack to create more advanced regressions using our data and create a predictive model using our findings.
In this module, we use 3 video lessons to visit our original data set to look at our data through a different lens. This module also includes a step-by-step guide on how to create a calculated field.
In this module, we use 10 video lessons to combine all the skills from previous modules by applying them in turnover and tenure calculations. This module includes a comprehensive exercise with aggressive benchmarking and a video solution to make sure you have true mastery.
In this module, we use 6 video lessons to explore how we can visually present our conclusions and data in Excel through a Dashboard. We wrap up this module with a guided walkthrough on how to create a dashboard, an excellent skill that can be explored more in the WSO Excel Dashboards & Power BI course.
Below you will find a list of the modules and lessons included in this course.