9-Week Growth Mentorship Program[Data Analytics]

0% Complete

Last activity on September 28, 2024 9:27 pm

Course Content

Expand All

Welcome, Watch me first!

Study Material for the mentorship program

Week 1: Starting with Microsoft Excel 8 Topics | 8 Quizzes

Expand

Lesson Content

0% Complete 0/8 Steps

Class 1: How to start MS Excel

Quiz 1.1

Class 2: File option (Home & New)

Quiz 1.2

Class 3: Save and publish option in MS Excel

Quiz 1.3

Class 4: Formula Part 1(Sum, Average, Minimum, Maximum, Count)

Quiz 1.4

Class 5: Formula Part 2(Small, Large, Basic Charts)

Quiz 1.5

Class 6: Conditional Formatting

Quiz 1.6

Class 7: Filter & Sorting

Quiz 1.7

Class 8: Data Validation

Quiz 1.8

Week 2: Going Advance in Microsoft Excel 9 Topics | 9 Quizzes

Expand

Lesson Content

0% Complete 0/9 Steps

Class 9: Subtotal

Quiz 2.9

Class 10: Text Function

Quiz 2.10

Class 11: Vlookup

Quiz 2.11

Class 12: Pivot Part 1

Quiz 2.12

Class 13: Pivot Part 2

Quiz 2.13

Class 14: Pivot Part 3

Class 17: Date & Time

Quiz 2.17

Week 3: Advance Microsoft Excel 8 Topics | 8 Quizzes

Expand

Lesson Content

0% Complete 0/8 Steps

Class 18: Database -Dsum

Class 23: Vlookup Advance-Approx Match

Quiz 3.23

Class 24: Payment formula (PMT)

Quiz 3.24

Class 25: Text to Coloumn

Quiz 3.25

Week 4 : Bonus Advance Ms Excel 15 Topics | 15 Quizzes

Expand

Lesson Content

0% Complete 0/15 Steps

Class 28: Index Part 2

Quiz 4.28

Class 29: Lookups-Match

Quiz 4.29

Class 30: Lookups – Match Part 2

Quiz 4.30

Class 31: Using Index & Match

Quiz 4.31

Class 32: Using Index & Match Part 2

Quiz 4.32

Class 33: Using Index & Match Part 3

Quiz 4.33

Class 34: Approx Match

Quiz 4.34

Class 35: Approx Match Part 2

Quiz 4.35

Class 36: Choose – Industry Oriented Scenario

Quiz 4.36

Class 37: Nested (Multiple) Vlookups

Quiz 4.37

Class 38: Consolidate

Quiz 4.38

Class 39: Vlookup Approch Part 1

Quiz 4.39

Class 40: Vlookup Approch Part 2

Quiz 4.40

Macros 5 Topics | 5 Quizzes

Expand

Lesson Content

0% Complete 0/5 Steps

Study Material For PowerBi

Week 5: Starting With Power BI 14 Topics | 9 Quizzes

Expand

Lesson Content

0% Complete 0/14 Steps

Class 1: Introduction To Power BI

Quiz 7.1

Introduction Of Data Analytics expert and Course Flow

Class 2: Power BI Architecture

Quiz 7.2

Class 3: Components

Quiz 7.3

Class 4: Power Bi Desktop

Quiz 7.4

Class 5: Formatting the chart

Quiz 7.5

Class 6: Formatting Inserting Textbox and Image

Quiz 7.6

Class 7: Data From Excel & Stacked File

Quiz 7.7

Class 8: Data hierarchy

Quiz 7.8

Class 9: Maps and User defined Hierarchy

Quiz 7.9

Class 10: Cards interaction

Class 11: Scatter & interactions chart

PowerBI software Installation

Class 12: Filters pane

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

Expand

Lesson Content

0% Complete 0/12 Steps

Class 13: Themes

Quiz 8.13

Class 14: Different Charts

Quiz 8.14

Class 15: Introduction Power Query( data transformation)

Quiz 8.15

Class 16: Split Column

Quiz 8.16

Class 17 : Group By

Quiz 8.17

Class 18 : Data cleansing Activity

Quiz 8.17

Quiz 8.18

Class 19 : Appént Data

Class 20: Merge Queries

Class 21 : Replace value

Class 22 : Transform and add column

Class 23 : Data Profiling & Column profiling

Class 24 : pivot and unpivot

Week 7: Advance Power BI 13 Topics | 11 Quizzes

Expand

Lesson Content

0% Complete 0/13 Steps

Class 25: Data Modeling concept

Quiz 9.25

Class 26: Data Modeling Implement

Quiz 9.26

Class 27: Cross filter Direction

Quiz 9.27

Class 28: Dax

Quiz 9.28

Class 29: Dax Time Intelligence and Map shorting

Quiz 9.29

Class 30: DAX SWITCH AND IF

Quiz 9.30

Class 31: Dax measures and calculate

Quiz 9.31

Class 32: Dax Time Intelligence

Quiz 9.32

Class 33: Power Bi Service

Quiz 9.33

Class 34: Power gateways and workspace

Class 35: Row level Security

Quiz 9.35

Class 36: Connection to sequel server

Quiz 9.36

Hands-on: Projects

Week 8: Starting With PowerPoint 7 Topics | 6 Quizzes

Expand

Lesson Content

0% Complete 0/7 Steps

Week 9: Advance PowerPoint 6 Topics | 5 Quizzes

Expand

Lesson Content

0% Complete 0/6 Steps

Week 9.2: 3Ds Max (BONUS) Copy

Microsoft 365 (Office)

Microsoft 365 (Office)

Professional Certificate Program In Data Science Using Machine Learning & AI

Professional Certificate Program In Data Science Using Machine Learning & AI

Master Communication Skills and influence the world

Master Communication Skills and influence the world

Master English Speaking skills

Master English Speaking skills

Learn Solidworks: Basics To Advance Level

Learn Solidworks: Basics To Advance Level

Learn Interior Designing: Learn To Make Realistic 3D Interior & Exterior View

Learn Interior Designing: Learn To Make Realistic 3D Interior & Exterior View

Professional Certificate Program In Data Analytics Using AI & ChatGPT

Professional Certificate Program In Data Analytics Using AI & ChatGPT

Learn PowerPoint : Basics To Advance (Recorded)

Learn PowerPoint : Basics To Advance (Recorded)

Hire From Us

9-Week Growth Mentorship Program[Data Analytics]

Course Content

Get In Touch With Us

Quick Links

Services

Courses

Courses

Enquire Now