3 Month: Mentorship Program (Data Analytics)

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course Content

Expand All

Study Material of Mentorship Program

Week 1: Basics Of Ms Excel 16 Topics | 15 Quizzes

Expand

Lesson Content

0% Complete 0/16 Steps

Introduction of Ms Excel

Class 1: Basic Functions of Excel Part 1

Quiz 1

Class 2: Basic Functions of Excel Part 2

Quiz 2

Class 3: Text Function Part 1

Quiz 3

Class 4: Text Function Part 2

Quiz 4

Class 5: Date Function Part 1

Quiz 5

Class 6: Date Function Part 2

Quiz 6

Class 7: Date Function Part 3

Quiz 7

Class 8: Date Function Part 4

Quiz 8

Class 9: Date Function Part 5

Quiz 9

Class 10: Data Base Function Part 1

Quiz 10

Class 11: Data Base Function Part 2

Quiz 11

Class 12: Information Function Part 1

Quiz 12

Class 13: Information Function Part 2

Quiz 13

Class 14: Information Function Part 3

Quiz 14

Class 15: Information Function Part 4

Quiz 15

Week 2: Going Advance in Ms Excel 16 Topics | 16 Quizzes

Expand

Lesson Content

0% Complete 0/16 Steps

Class 16: Count Function Part 1

Quiz 16

Class 17: Count Function Part 2

Quiz 17

Class 18: Count Function Part 3

Quiz 18

Class 19: Lookup & Reference Functions Part 1

Quiz 19

Class 20: Lookup & Reference Functions Part 2

Quiz 20

Class 21: Lookup & Reference Functions Part 3

Quiz 21

Class 22: Lookup & Reference Functions Part 4

Quiz 22

Class 23: Lookup & Reference Functions Part 5

Quiz 23

Class 24: Sorting and Filteration (Feature) Part 1

Quiz 24

Class 25: Sorting and Filteration (Feature) Part 2

Quiz 25

Class 26: Sorting and Filteration (Feature) Part 3

Quiz 26

Class 27: Macros Part 1

Quiz 27

Class 28: Macros Part 2

Quiz 28

Class 29: Macros Part 3

Quiz 29

Class 30: Macros Part 4

Quiz 30

Class 31: Macros Part 5

Quiz 31

Week 3: Advance Ms Excel Part 1 15 Topics | 7 Quizzes

Expand

Lesson Content

0% Complete 0/15 Steps

Class 32: Logical Function Part 1

Class 33: Logical Function Part 2

Class 34: Logical Function Part 3

Quiz 34

Class 35: Logical Function Part 4

Class 36: Logical Function Part 5

Quiz 36

Class 37: Logical Function Part 6

Quiz 37

Class 38: Logical Function Part 7

Quiz 34

Class 39: Data Validation Part 1

Class 40: Data Validation Part 2

Class 41: Data Validation Part 3

Class 42: Data Validation Part 4

Class 43: Data Validation Part 5

Class 44: What If Analysis Part 1 (Goal Seek)

Quiz 44

Class 45: What If Analysis Part 2 (Data Table)

Quiz 45

Class 46: What If Analysis Part 3 (Solver)

Quiz 46

Week 4 : Advance Ms Excel Part 2 17 Topics | 17 Quizzes

Expand

Lesson Content

0% Complete 0/17 Steps

Class 47: Filtration Function Part 1

Quiz 47

Class 48: Filtration Function Part 2

Quiz 48

Class 49: Filtration Function Part 3

Quiz 49

Class 50: Auditing Part 1

Quiz 50

Class 51: Auditing Part 2

Quiz 51

Class 52: Auditing Part 3

Quiz 52

Class 53: Auditing Part 4

Quiz 53

Class 54: Data Protection Part 1

Quiz 54

Class 55: Data Protection Part 2

Quiz 55

Class 56: Data Protection Part 3

Quiz 56

Class 57: Data Protection Part 4

Quiz 57

Class 58: Financial Functions Part 1

Quiz 58

Class 59: Financial Functions Part 2

Quiz 59

Class 60: Financial Functions Part 3

Quiz 60

Class 61: Financial Functions Part 4

Quiz 61

Class 62: Financial Functions Part 5

Quiz 62

Class 63: Financial Functions Part 6

Quiz 63

Week 5 : Starting with PowerBI 15 Topics | 12 Quizzes

Expand

Lesson Content

0% Complete 0/15 Steps

Study Material For PowerBi

PowerBI software Installation

Introduction Of Data Analytics expert and Course Flow

Class 1: Introduction To Power BI

Quiz 5.1

Class 2: Power BI Architecture

Quiz 5.2

Class 3: Components

Quiz 5.3

Class 4: Power Bi Desktop

Quiz 5.4

Class 5: Formatting the chart

Quiz 5.5

Class 6: Formatting Inserting Textbox and Image

Quiz 5.6

Class 7: Data From Excel & Stacked File

Quiz 5.7

Class 8: Data hierarchy

Quiz 5.8

Class 9: Maps and User defined Hierarchy

Quiz 5.9

Class 10: Cards interaction

Quiz 5.10

Class 11: Scatter & interactions chart

Quiz 5.11

Class 12: Filters pane

Quiz 5.12

Week 6: Going Advance in Power BI 12 Topics | 12 Quizzes

Expand

Lesson Content

0% Complete 0/12 Steps

Class 13: Themes

Quiz 6.13

Class 14: Different Charts

Quiz 6.14

Class 15: Introduction Power Query( data transformation)

Quiz 6.15

Class 16: Split Column

Quiz 6.16

Class 17 : Group By

Quiz 6.17

Class 18 : Data cleansing Activity

Quiz 6.18

Class 19 : Appént Data

Quiz 6.19

Class 20: Merge Queries

Quiz 6.20

Class 21 : Replace value

Quiz 6.21

Class 22 : Transform and add column

Quiz 6.22

Class 23 : Data Profiling & Column profiling

Quiz 6.23

Class 24 : pivot and unpivot

Quiz 6.24

Week 7: Advance Power BI 12 Topics | 12 Quizzes

Expand

Lesson Content

0% Complete 0/12 Steps

Class 25: Data Modeling concept

Quiz 7.25

Class 26: Data Modeling Implement

Quiz 7.26

Class 27: Cross filter Direction

Quiz 7.27

Class 28: Dax

Quiz 7.28

Class 29: Dax Time Intelligence and Map shorting

Quiz 7.29

Class 30: DAX SWITCH AND IF

Quiz 7.30

Class 31: Dax measures and calculate

Quiz 7.31

Class 32: Dax Time Intelligence

Quiz 7.32

Class 33: Power Bi Service

Quiz 7.33

Class 34: Power gateways and workspace

Quiz 7.34

Class 35: Row level Security

Quiz 7.35

Class 36: Connection to sequel server

Quiz 7.36

Week 8: Starting with SQL 18 Topics | 15 Quizzes

Expand

Lesson Content

0% Complete 0/18 Steps

Introduction & Software Installation

Introduction Of SQL Server

Study Material For SQL

Class 1: How to Launch SSMS and Create Database

8.1

Class 2: Create and Drop database

8.2

Class 3: Create Table

8.3

Class 4: Insert Into

8.4

Class 5: DDL DML DQL Commands

8.5

Class 6 – Data Modelling Theoretical concept

8.6

Class 7. Data Modelling SQL

8.7

Class 8: Database Diagram

8.8

Class 9: DDL concept

8.9

Class 10: Select command and data import

8.10

Class 11: Select clauses distinct top

8.11

Class 12: Quick Practice

8.12

Class 13: Delete and update

8.13

Class 14: Set Operators

8.14

Class 15: Concept of joins

8.15

Week 9: Advance SQL 8 Topics | 7 Quizzes

Expand

Lesson Content

0% Complete 0/8 Steps

Class 16: Joins in SQL

9.1

Class 17: Join Simple Exercise

9.2

Class 18: Joins Exercise

9.3

Class 19: Sub-Query

9.4

Class 20: Numeric and Text functions

9.5

Class 21: Date Functions

9.6

Class 22: Rank Function

9.7

Class 23: Practice

Week 10 : Basics of Python 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Installation of Python

Class 1: Python First Program

Class 2: Operators in Python

Class 3: Python Variables

Class 4: Python Data Types

Class 5: Python Inputs

Class 6: Python Simple Programs 1

Python Conditional Statement 3

Week 11: Advance Python

Week 12: Powerpoint (Bonus) 7 Topics | 6 Quizzes

Expand

Lesson Content

0% Complete 0/7 Steps

Week 13: Advance Powerpoint (Bonus) 6 Topics | 6 Quizzes

Expand

Lesson Content

0% Complete 0/6 Steps

Hire From Us

3 Month: Mentorship Program (Data Analytics)

Course Content

Get In Touch With Us

Quick Links

Services

Courses

Courses

OTP Verification

Enquire Now