Data Analytics Corporate Training

This program will expose the learners to the concepts of Data Analytics which is one of the hottest fields with huge demand. Right from the scratch, we will learn python essentials and gradually move to the advanced concepts of Pandas, Numpy, Matplotlib, etc. to manipulate, transform and model data for actionable insights.

(5 reviews)
12 Hours 44 Mins
Join the course
Created by
Jobaaj Learnings

Course description

Corporate Training Program in Data Analytics:

 

Syllabus

     - Data Analytics Core Concepts

     - Python L1, L2

     - SQL L1, L2

     - Power BI L1, L2

 

Data Analytics Core Concepts

     - Covers the core and fundamental concepts to set up a strong foundation in Data & Analytics

     - Exposes the learner to Database, Warehouse, Lake concepts

     - Covers Big Data, Metadata & Statistical Concepts in Data & Analytics 

     - Includes multiple case studies to understand the penetration of Data & Analytics

     - Covers all the Data Analytics terminologies and Data Literacy Concepts

     - Learn how statistics is related to Data & Analytics by using real-world examples

 

Python L1

     - Learn the core concepts of Python using Kaggle right from covering the fundamentals

     - Conditional statements, Loops, List, Tuple, Dictionary, etc,... we have covered it all

     - Learn the beginner to advance level concepts in python the right way

     - Explore control statements and learn the concept of Numpy

     - Advance List Concepts, Object-Oriented Programming, I/O & Exceptions

     - Register to become a Data Analyst

       ( 7 Days Money Back Guarantee )

Python L2

- Deep dive into the core Data Analytics library like Pandas & Numpy

- Learn Dimensional Modelling - The Python Way

  - Work on the real-world datasets to build a clean, optimized & modeled data

  - Learn Dataframe, Series, indexing, grouping, etc. for advanced data analysis

  - Date and time-series, I/O, Visualization using Seaborn will make you job-ready !!!

 

SQL L1

      - Learn the concepts of Relational databases and why SQL is in great demand?

- SELECT, INSERT, UPDATE, DELETE, AGGREGATION...Everything covered from scratch

      - Covers concept of all types of joins & unions

      - Interview famous concepts - Self join, subquery, CTE

 

SQL L2

- Learn how to write long queries in an optimized way

- Master the windows function - rank, dense rank, row number, etc

- Covers advance SQL topics like Stored procedures in an easy to understand way

      - Date-time, mathematical, string functions for data manipulation

- Group by, case-when, conditional statements ...all covered so that you can nail the interview

 

Power BI L1

- Step by step installation and set-up, databases & connections

- Interface walkthrough, data model pane, visualization, filter & fields

- Data Transformation using Power Query, pivot, data imputation

- Append & merge query, data manipulation & data health

- Relationships, parameters, model view

- Tree map, stack chart, decomposition tree, pie & donut map etc

 

Power BI L2

- Calculated columns vs measures, DAX coding language

- Aggregations, conditions, calculate, filter, row context

- Level of details function - ALL, ALLEXCEPT, ALLSELECTED, etc

- Q&A, Advance analytics, dynamic tooltip, drill through

- Bookmark, selection pane, conditional formatting etc

- Custom visuals, marketplace, query foldings and a lot more 

Prerequisite
  • No prerequisites

Lesson List

1

Welcome Kit

Discord Community Bonus
Orientation
00:53:00
2

Getting Started

Know Your Trainer
00:01:43
Data Analytics / Analyst ?
00:14:26
Current & Future State of D&A
00:15:53
Is Your Data Collected?
00:08:27
Why data is the new oil?
00:06:48
Amazon Case Study
00:11:16
Job Roles in Data
00:11:14
Data Providing Companies
00:12:36
Some Stats
00:12:39
What does Gartner Says?
00:11:04
Tasks of a Data Analyst
00:14:25
Types of Data Analysis
00:10:00
3

Data Literacy

Big Data
00:10:17
Metadata
00:07:28
Limitation of excel
00:09:32
Sentimental Analysis
00:11:03
Types of data
00:09:07
Database 1
00:11:46
Database 2
00:16:42
Why RDBMS ?
00:10:21
Cardinality
00:13:06
Database Schema
00:15:53
DB vs Warehouse vs Lake
00:14:51
Data Server
00:08:48
Data Center
00:06:26
Cloud vs on-premises Data Storage
00:12:00
Data Type
00:10:02
Data Wrangling
00:11:00
Outliers
00:05:30
EDA
00:10:16
4

Miscellaneous Concepts

Aggregation & granularity
00:11:12
Measure of Central Tendency
00:15:14
Imputation
00:08:12
Deviation
00:18:38
Distribution
00:13:10
What is KPI
00:08:22
Best Practices for Charts
00:14:13
Best Practices for Charts -2
00:11:40
5

Module 2

How to access further Modules?
6

Live Sessions

Live Session 1
00:48:52
Live Session 2
00:27:56
Live Session 3
00:42:48
Live Session 4
00:52:03
Live Session 5
00:34:15
Live Session 6
00:35:37
Live Session 7
00:44:19
Learn from the best

Jobaaj Learnings

Jobaaj Learnings offer the best in class industry-focused programs to students. 

Our trainers have several years of experience in the respective field and work with leading companies. 

We are the pioneer of a personalised micro-learning education model in India.

Why micro-learning?

A rise in digital devices, fast internet, and a rapidly changing environment has made micro-learning the demand of an hour. 

We consider it the most effective method of consuming learning content & are on a mission of making professionals habitual of upskilling by stealing little time daily from their busy lifestyle.

Very Informative  

PAVAN KALYAN P B E S

More courses like this

Tableau Bootcamp

By Jobaaj Learnings

₹2,999/-₹6,000/-


Top