Data Analyst

Boost your Data analytics career with powerful new Microsoft® Excel skills by taking this Data Analytics course, which includes training on Business Analytics. This combined with an official certificate will put you on the path to a successful career.

– Lesson 01: Course Introduction
– Lesson 02: Introduction to Business Analytics
– Lesson 03: Data Cleaning and Preparation
– Lesson 04: Formatting, Conditional Formatting, and Important Functions
– Lesson 05: Spotlight
– Lesson 06: Analysing Data with Pivot Tables
– Lesson 07: Dashboarding
– Lesson 08: Business Analytics with Excel
– Lesson 09: Spotlight
– Lesson 10: Data Analysis Using Statistics
– Lesson 11: Using Macros for Analytics
– Lesson 12: Spotlight

This course gives you the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn the concepts of fundamental SQL statements, conditional statements, commands, joins, subqueries, and various functions to manage your SQL database for scalable growth.

– Lesson 01: Course Introduction
– Lesson 02: Introduction to SQL
– Lesson 03: Database Normalization and Entity Relationship (ER) Model
– Lesson 04: MySQL – Installation and SetUp
– Lesson 05: Working with Database and Tables
– Lesson 06: Working with Operators Constraints and Data Types
– Lesson 07: Functions in SQL
– Lesson 08: Subqueries, Operators, and Derived Tables in SQL
– Lesson 09: Windows Functions in SQL
– Lesson 10: Working with Views
– Lesson 11: Stored Procedures and Triggers in SQL
– Lesson 12: Performance Optimization and Best Practices in SQL

Learn how to perform data analysis with Python using multi-dimensional arrays in NumPy, manipulate DataFrames in pandas, use SciPy library of mathematical routines, and perform machine learning using Scikit-learn. You will utilise the basics of Python to explore and analyse many different types of data. Learn how to prepare data for analysis, perform simple statistical analyses, create meaningful data visualisations, predict future trends from data, and more.
Section 1:

– Lesson 1: Learning Objective
– Lesson 2: Introduction
– Lesson 3: Data Wrangling
– Lesson 4: Exploratory Data Analysis
– Lesson 5: Model Development
– Lesson 6: Model Evaluation

Section 2:
– Lesson 1: Course Introduction
– Lesson 2: Introduction to Programming
– Lesson 3: Programming Environment Setup
– Lesson 4: OOPs Concept with Python
– Lesson 5: Programming Fundamentals of Python
– Lesson 6: File handling, Exception handling, and Package handling
– Lesson 7: Data Analytics Overview
– Lesson 8: Statistical Computing
– Lesson 9: Mathematical Computing using NumPy
– Lesson 10: Data Manipulation with Pandas
– Lesson 11: Data visualisation with Python
– Lesson 12: Introduction to Model Building

Section 3:

– Practice Projects

Discover R Programming with this introductory course. Learn how to write R code, utilise R data structures, and create your own functions.

– Lesson 1: R Programming for Data Science

The next step to becoming a Data Analyst is learning R—the most in-demand open-source technology. R is a powerful Data Science and analytics language, which has a steep learning curve and a very vibrant community. This is why it is quickly becoming the technology of choice for organisations that are adopting the power of analytics for competitive advantage.

– Lesson 01: Course Introduction
– Lesson 02: Introduction to Data Analytics
– Lesson 03: Introduction to R Programming
– Lesson 04: Programming Fundamentals of R
– Lesson 05: Data Manipulation Using R
– Lesson 06: Data Visualization in R
– Lesson 07: Hypothesis Testing
– Lesson 08: Introduction to Machine Learning
– Lesson 09: Classification
– Lesson 10: Clustering
– Lesson 11: Association Mining

This Tableau certification course helps you master Tableau Desktop, a world-wide utilised data visualisation, reporting, and business intelligence tool. Advance your career in analytics through our Tableau training and gain job-ready skills. A skill in Tableau is highly regarded by companies for data-related jobs and this course prepares you to use the tool effectively for preparing data, creating interactive dashboards, adding different dimensions, and analysing outliers.

– Lesson 1: Course Introduction
– Lesson 2: Introduction to Data Visualisation and Tableau
– Lesson 3: Connecting to Various Data Sources and Preparing Data
– Lesson 4: Working with Metadata
– Lesson 5: Spotlight One
– Lesson 6: Filters in Tableau
– Lesson 7: Structuring Data in Tableau
– Lesson 8: Creating Charts and Graphs
– Lesson 9: Spotlight Two
– Lesson 10: Calculations in Tableau
– Lesson 11: Advanced Visual Analytics
– Lesson 12: Dashboards and Stories
– Lesson 13: Spotlight Three

Simplilearn’s Data Analyst Capstone project will give you an opportunity to implement the skills you learned in the Data Analyst course. With dedicated mentoring sessions, you’ll know how to solve a real industry-aligned problem. The project is the final step in the learning path and will help you to showcase your expertise to employers

– Lesson 1: Introduction

Optional electives are available as part of this Data Analyst Online Bootcamp Program. These are not mandatory to complete, but are available as additional courses to study if you are interested in expanding your knowledge and further implementing your skills.

Elective 1 – PL-300 Microsoft Power BI Certification Training
Elective 2 – Industry Master Class – Data Analytics