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.

Beginner 4(3 Ratings) 109 Students enrolled English-hindi
Created by Jobaaj Learnings
Last updated Thu, 24-Mar-2022
+ View more
Course overview

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 

What will i learn?

Requirements
  • No prerequisites
Curriculum for this course
44 Lessons 09:35:09 Hours
Welcome Kit
2 Lessons 00:30:13 Hours
  • Discord Community Bonus
    .
  • Orientation
    00:30:13
Getting Started
12 Lessons 02:10:31 Hours
  • 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
Data Literacy
18 Lessons 03:14:08 Hours
  • 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
Miscellaneous Concepts
8 Lessons 01:40:41 Hours
  • 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
Module 2
1 Lessons 00:00:00 Hours
  • How to access further Modules?
    .
Live Sessions
3 Lessons 01:59:36 Hours
  • Live Session 1
    00:48:52
  • Live Session 2
    00:27:56
  • Live Session 3
    00:42:48
+ View more
Other related courses
03:10:45 Hours
Updated Wed, 06-Apr-2022
5 84 ₹3999 ₹2499
07:44:18 Hours
5 35 ₹25000 ₹21000
08:09:35 Hours
Updated Fri, 13-May-2022
5 739 Free
About instructor

Jobaaj Learnings

Pioneer of personalised micro-learning model of education in India.

200 Reviews | 2646 Students | 48 Courses
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 companie...
Student feedback
4
3 Reviews
  • (0)
  • (0)
  • (0)
  • (3)
  • (0)

Reviews

  • HRITIK GUPTA
  • Devanuru Goutham
  • Jyoti Gupta
₹15000 ₹9000
Includes: