Data Science A-Z™: Hands-On Exercises & ChatGPT Bonus [2023]
What you'll learn
- Successfully perform all steps in a complex Data Science project
- Create Basic Tableau Visualisations
- Perform Data Mining in Tableau
- Understand how to apply the Chi-Squared statistical test
- Apply Ordinary Least Squares method to Create Linear Regressions
- Assess R-Squared for all types of models
- Assess the Adjusted R-Squared for all types of models
- Create a Simple Linear Regression (SLR)
- Create a Multiple Linear Regression (MLR)
- Create Dummy Variables
- Interpret coefficients of an MLR
- Read statistical software output for created models
- Use Backward Elimination, Forward Selection, and Bidirectional Elimination methods to create statistical models
- Create a Logistic Regression
- Intuitively understand a Logistic Regression
- Operate with False Positives and False Negatives and know the difference
- Read a Confusion Matrix
- Create a Robust Geodemographic Segmentation Model
- Transform independent variables for modelling purposes
- Derive new independent variables for modelling purposes
- Check for multicollinearity using VIF and the correlation matrix
- Understand the intuition of multicollinearity
- Apply the Cumulative Accuracy Profile (CAP) to assess models
- Build the CAP curve in Excel
- Use Training and Test data to build robust models
- Derive insights from the CAP curve
- Understand the Odds Ratio
- Derive business insights from the coefficients of a logistic regression
- Understand what model deterioration actually looks like
- Apply three levels of model maintenance to prevent model deterioration
- Install and navigate SQL Server
- Install and navigate Microsoft Visual Studio Shell
- Clean data and look for anomalies
- Use SQL Server Integration Services (SSIS) to upload data into a database
- Create Conditional Splits in SSIS
- Deal with Text Qualifier errors in RAW data
- Create Scripts in SQL
- Apply SQL to Data Science projects
- Create stored procedures in SQL
- Present Data Science projects to stakeholders
Requirements
- Only a passion for success
- All software used in this course is either available for Free or as a Demo version
Description
Extremely Hands-On... Incredibly Practical... Unbelievably Real!
This is not one of those fluffy classes where everything works out just the way it should and your training is smooth sailing. This course throws you into the deep end.
In this course you WILL experience firsthand all of the PAIN a Data Scientist goes through on a daily basis. Corrupt data, anomalies, irregularities - you name it!
This course will give you a full overview of the Data Science journey. Upon completing this course you will know:
- How to clean and prepare your data for analysis
- How to perform basic visualisation of your data
- How to model your data
- How to curve-fit your data
- And finally, how to present your findings and wow the audience
- SQL
- SSIS
- Tableau
- Gretl
This course has pre-planned pathways. Using these pathways you can navigate the course and combine sections into YOUR OWN journey that will get you the skills that YOU need.
Or you can do the whole course and set yourself up for an incredible career in Data Science.
The choice is yours. Join the class and start learning today!
See you inside,
Sincerely,
Kirill Eremenko
Who this course is for:
- Anybody with an interest in Data Science
- Anybody who wants to improve their data mining skills
- Anybody who wants to improve their statistical modelling skills
- Anybody who wants to improve their data preparation skills
- Anybody who wants to improve their Data Science presentation skills
Featured review
![Christos Asvestopoulos](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructors
- 4.5 Instructor Rating
- 618,820 Reviews
- 2,339,154 Students
- 59 Courses
My name is Kirill Eremenko and I am super-psyched that you are reading this!
Professionally, I come from the Data Science consulting space with experience in finance, retail, transport and other industries. I was trained by the best analytics mentors at Deloitte Australia and since starting on Udemy I have passed on my knowledge to thousands of aspiring data scientists.
From my courses you will straight away notice how I combine my real-life experience and academic background in Physics and Mathematics to deliver professional step-by-step coaching in the space of Data Science. One of the strongest sides of my teaching style is that I focus on intuitive explanations, so you can be sure that you will truly understand even the most complex topics.
To sum up, I am absolutely and utterly passionate about Data Science and I am looking forward to sharing my passion and knowledge with you!
- 4.5 Instructor Rating
- 638,720 Reviews
- 2,350,442 Students
- 149 Courses
Hi there,
We are the Ligency team. You will be hearing from us when new Ligency courses are released, when we publish new podcasts, blogs, share cheatsheets and more!
We are here to help you stay on the cutting edge of Data Science and Technology.
See you in class,
Sincerely,
Ligency Team!
- 4.5 Instructor Rating
- 613,578 Reviews
- 2,293,212 Students
- 104 Courses
Hi there,
We are the Ligency PR and Marketing team. You will be hearing from us when new courses are released, when we publish new podcasts, blogs, share cheatsheets and more!
We are here to help you stay on the cutting edge of Data Science and Technology.
See you in class,
Sincerely,
The Real People at Ligency