Data Analysis

Course level:All Levels

About Course

Do you find solving a problem interesting? How about solving it with facts from figures? Or have you been earning data, and data and would like to get into the world of data and data analytics, or probably you just want to refresh your knowledge on some of the basic concepts and skills used in a day to day life as a data analyst? Then this course is for you.

Organizations of all kinds need data analysts to help them improve their processes, identify opportunities and trends, launch new products, and make thoughtful decisions. In this course, you’ll be introduced to the world of data analytics through a hands-on curriculum developed by our experts here.

Current data analyst experts will instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.

By the end of this course, you will: – Gain an understanding of the practices and processes used by data analysts in their day-to-day job. – Learn about key analytical skills (data cleaning, data analysis, data visualization) and tools (Microsoft Excel, SQL Server Reporting Services (SSRS), Power BI, Python ( Programming for Data Analysis) that you can add to your professional toolbox. – Discover a wide variety of terms and concepts relevant to the role of a data analyst.

Course Curriculum

Ms. Excel- Fundamental Master Class

Ms Excel – Fundamental week 1 class 1 date 23/11/2022 materials and video

02:01:29
Lesson: Ms Excel – Fundamental week 2 class 1 date 28/11/2022 materials and video

02:05:22
MS Excel – Fundamental week 2 Class 2 Date:30/11/2022 Materials and Video

02:10:36
MS Excel – Fundamental week 3 Class 1 Date: 5/12/2022 Materials and Video

02:00:07
MS Excel – Fundamental week 3 Class 2 Date: 7/12/2022 Materials and Video

01:26:29
MS Excel – Fundamental week 4 Class 1 Date: 12/12/2022 Materials and Video

01:49:30
MS Excel – Fundamental week 4 Class 2 Date: 14/12/2022 Materials and Video

01:51:28
SQL Download and Installation – Week 1 Class 1 Date: 19/12/2022 Video

02:20:29
SQL Class – Week 1 Class 2 Date: 21/12/2022 Video

01:53:10
SQL Class – Week 2 Class 1 Date: 09/01/2023 Video

02:26:33
SQL Class – Week 2 Class 2 Date: 11/01/2023 Video and Material

01:55:43
SQL Class – Week 3 Class 1 Date: 16/01/2023 Video

02:07:53
SQL Class – Week 3 Class 2 Date: 16/01/2023 Video and Materials

02:00:09
SQL Class – Week 4 Class 1 Date: 23/01/2023 Video

02:04:19
SQL Class – Week 4 Class 2 Date: 25/01/2023 Video

01:48:25
SQL Class – Week 5 Class 1 Date: 30/01/2023 Video and Material

02:01:27
SQL Class – Week 5 Class 2 Date: 01/02/2023 Video and Material

01:58:28
Power BI Class – Week 1 Class 1 Date: 06/02/2023 Video and Material

01:48:17
Power BI Class – Week 1 Class 2 Date: 08/02/2023 Video and Material

01:30:06
Power BI Class – Week 2 Class 1 Date: 13/02/2023 Video

01:28:33
Power BI Class – Week 2 Class 2 Date: 16/02/2023 Video

01:28:16
Machine Learning: Python & MatLab Download and Installation – Week 1 Class 1 Date: 20/02/2023 Video

01:52:58
Machine Learning: Python & MatLab – Week 1 Class 2 Date: 22/02/2023 Video

01:37:33
Machine Learning: Python & MatLab – Week 2 Class 1 Date: 27/02/2023 Video

01:45:19
Machine Learning: Python & MatLab – Week 2 Class 2 Date: 01/03/2023 Video

01:22:51
Introduction to Machine Learning: Week 3 Class 1 Date: 06/03/2023 Video and Material

02:05:14
Machine Learning: Week 3 Class 2 Date: 08/03/2023 Video

01:40:04
Machine Learning: Week 4 Class 1 Date: 13/03/2023 Video

01:19:46

Categories Information Technology

Discover a wide variety of terms and concepts relevant to the role of a junior data analyst
Would have the theory background of operations, methods, and formulas used in for analysis of data
Get familiar with Microsoft Excel Interface
Be able to clean data with both Microsoft Excel, Python, and SQL
Would learn the basics of Python and libraries used for Data Analysis
Would learn all they need to know to execute simple SQL queries for Data analysis task
Would be able to visualize data to get more insight and early communicate findings to stakeholders.
What will you gain from this Introduction to SQL Course?
• Learn how to read SQL
• Learn how to write queries
• Learn how to work with tables and fields
• Learn how to join multiple tables together in a query
• Learn how to output data for analysis
(Python) Programming for Data Analysis
- Introduction and programming environment
- Pandas & Numpy
- Exploratory Data Analysis and Missing Data
- Machine Learning
- Machine Learning Classification
- Visualization
- Neural Networks
- Convolution Neural Networks CNN
- Autoencoders
- Clustering

Data Analysis

About Course

Course Curriculum

Ms. Excel- Fundamental Master Class

Ms Excel – Fundamental week 1 class 1 date 23/11/2022 materials and video

Lesson: Ms Excel – Fundamental week 2 class 1 date 28/11/2022 materials and video

MS Excel – Fundamental week 2 Class 2 Date:30/11/2022 Materials and Video

MS Excel – Fundamental week 3 Class 1 Date: 5/12/2022 Materials and Video

MS Excel – Fundamental week 3 Class 2 Date: 7/12/2022 Materials and Video

MS Excel – Fundamental week 4 Class 1 Date: 12/12/2022 Materials and Video

MS Excel – Fundamental week 4 Class 2 Date: 14/12/2022 Materials and Video

SQL Download and Installation – Week 1 Class 1 Date: 19/12/2022 Video

SQL Class – Week 1 Class 2 Date: 21/12/2022 Video

SQL Class – Week 2 Class 1 Date: 09/01/2023 Video

SQL Class – Week 2 Class 2 Date: 11/01/2023 Video and Material

SQL Class – Week 3 Class 1 Date: 16/01/2023 Video

SQL Class – Week 3 Class 2 Date: 16/01/2023 Video and Materials

SQL Class – Week 4 Class 1 Date: 23/01/2023 Video

SQL Class – Week 4 Class 2 Date: 25/01/2023 Video

SQL Class – Week 5 Class 1 Date: 30/01/2023 Video and Material

SQL Class – Week 5 Class 2 Date: 01/02/2023 Video and Material

Power BI Class – Week 1 Class 1 Date: 06/02/2023 Video and Material

Power BI Class – Week 1 Class 2 Date: 08/02/2023 Video and Material

Power BI Class – Week 2 Class 1 Date: 13/02/2023 Video

Power BI Class – Week 2 Class 2 Date: 16/02/2023 Video

Machine Learning: Python & MatLab Download and Installation – Week 1 Class 1 Date: 20/02/2023 Video

Machine Learning: Python & MatLab – Week 1 Class 2 Date: 22/02/2023 Video

Machine Learning: Python & MatLab – Week 2 Class 1 Date: 27/02/2023 Video

Machine Learning: Python & MatLab – Week 2 Class 2 Date: 01/03/2023 Video

Introduction to Machine Learning: Week 3 Class 1 Date: 06/03/2023 Video and Material

Machine Learning: Week 3 Class 2 Date: 08/03/2023 Video

Machine Learning: Week 4 Class 1 Date: 13/03/2023 Video

Requirements

What I will learn?