This course was last updated on 3/2022.
We analyzed factors such as the rating (4.3/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.
✓ Learn about basic formatting in excel.
✓ Learn about sorting and filtering functions in excel.
✓ Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
✓ Learn how to find outliers and missing values in Excel.
✓ Learn how to find standard deviation and percentiles in data using Excel.
✓ Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
✓ Learn about using Color Bars and Color scales in excel.
✓ Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
✓ Learn how to merge datasets using Index and match.
✓ Learn making Pivot Tables and Pivot charts in excel.
✓ Learn making interactive dashboards in excel.
✓ Learn about What-if analysis in excel.
✓ Learn how to perform linear regression in excel.
✓ Learn about creating databases and tables in SQL.
✓ Learn about Numerical, string functions in SQL.
✓ Learn about filtering using LIKE operator in SQL.
✓ Learn about different DDL and DML commands.
✓ Learn about Joins and Subqueries in SQL.
✓ Learn connecting Python and MySQL.
✓ Learn about variables and data types in Python.
✓ Learn about loops and conditionals in python.
✓ Learn about Regular expressions and date time objects in Python.
✓ Learn about the Numpy and the Pandas library.
✓ Learn about creating different chart types using Tableau.
• No prior knowledge required
• Determination and Desire to Learn new things.
• A positive attitude to success.
• A willingness to learn and practice.
• Laptop should meet the requirements of the installation of Python.
• Laptop should meet the requirements of the installation of Tableau.
• Laptop should meet the requirements of the installation of SQL.
• Data Analysts.
• Job-seekers.
• Anyone who wants to explore data science.
• Students and professionals who want to improve the training capabilities.
• This course is for you if you like exciting challenges.
• Take your career to the next level.
• Programming beginners.
• Anyone who wants to learn the most frequently used Excel functions and techniques used by analysts.
The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.
YES, Data Analysis Masterclass (4 courses in 1) has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.
Data Is Good Academy has created 30 courses that got 6,397 reviews which are generally positive. Data Is Good Academy has taught 247,970 students and received a 4.3 average review out of 6,397 reviews. Depending on the information available, we think that Data Is Good Academy is an instructor that you can trust.
An Google, Facebook, Kaggle Grandmasters team
We’re a bootstrapped, “indie” tech education company. Our vision is to Unlock human potential by transforming education and making it accessible and affordable to all.
We are fiercely independent and proud with a sole focus to make world-class tech education a level playing field for anyone on this planet.
Data is Good is on a Mission to create courses that will make our students learn the subject and fall in love with it & become lifelong passionate learners and explorers of that subject.