Data Analyst Training

Envision Learning provides data analyst courses in the field of data analysis, focusing on techniques and tools used to extract insights and make informed decisions based on data.

These courses cover a wide range of topics, including statistical analysis, data visualization, data mining, machine learning, and predictive modeling. They are designed to equip students with the skills and knowledge necessary to work with large datasets, analyze patterns and trends, and communicate findings effectively.

Software Development Life Cycle

• Waterfall

• Agile

• Project life cycle

• Requirement, documentation, and walkthrough

Database and SQL

• Introduction to Relational database

• Basics of SQL

• Advanced SQL e.g joining tables for data, subqueries, common table expressions

• ETL

• Source to target mapping

• Different database vendors

Mastery in Excel

• Introduction to Excel

• Pivot tables in Excel

• Different file types

• Aggregation, functions and cleansing process within Excel

• Charts and statistical modelling using Excel

Data Analysis with Python and R programming

• Basics of python, Python data structures and functions

• Python for data analytics

• Data Wrangling with Python

• Jupyter fundamentals

• Pandas, Matplotlib, Numpy, SciPy, PySpark, and API

• Combining and exporting data

• Data visualization using python

• Excel reporting

Data visualization using PowerBI or Tableau

• Intro to data visualization

• Visual design basics and Tableau/Power BI

• Different charts

• Storytelling with data presentations

• Presentation findings to stakeholders

Big Data

• Introduction to Big Data

• Introduction to Cloud

• Data mining and data warehouse

• Data computation

• Predictive analysis

• Intro to Hadoop and MapReduce

• Intro to Machine Learning

Additional

• Version Control: Git

• Live Project

• Interview Preparation

• Conduct Mock Interviews