CERTIFIED ADVANCED SQL, EXCEL, POWER BI & TABLEAU MASTERCLASS

Master the Most In-Demand Skills of 2022 by spending less than 30 minutes a day. Get Certified by a Skill Nation & take the next step towards growing in your career.

Get trained and certified by Skill Nation and top-quality professionals

Over 6,294 students trained with 4.8/5 avg rating

Our students work at:

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

What will you learn in the Masterclass?

RELATIONAL-DBMS

  • Insight about Database Management System and File based management system

  • ER modelling and ER Diagrams to represent the relationships existing in the database

  • Normalization to know the evil of redundancy - Normal Forms, Functional, Partial, Transitive Dependencies

ADVANCE QUERY BUILDING

  • Retrieving Data using SQL SELECT Statements and use of various operators in it

  • Substitution variables using single and Double ampersand and their analogies

ANALYTICAL FUCNTIONS & JOINS

  • Analytical functions, its uses, and types for the efficient querying

  • Understanding of grouping concept in Functions to visualize meaningful data

  • Various types of Joins and its purpose to master the decision making when to use it and how to use it

SQL SUB-QUERIES & SET OPERATORS

  • Using Sub-queries to query the database for the requirement

  • Set Operators to solve the challenge of analysis and retrieve a consolidated or required data

OTHER SCHEMA OBJECTS

  • Creating and managing other schema objects

  • Exploring list of schema objects and their functionalities

MANAGING LARGE DATASETS & OTHERS

  • Knowing what you’re up to - A detail study about Data Dictionary Views

  • A drill-through on Large Dataset Processing

  • Recovery of the lost data through FLASHBACK statements

Complete Excel Essentials

Advanced Excel Formulas

Excel Advanced Data Visualisation

Data Analysis With Pivot Tables

Macros & ActiveX Controls

Power BI Dashboards Masterclass

Power Query Transformations

Tableau A - Z Expert

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

"Skill Nation’s mentorship program has literally fastracked my career by 10 years. I can't believe I used to spend hours doing what I can do in minutes after enrolling & learning from Jatan. Thanks to him, I am an expert in SQL, Excel, Power BI, PowerPoint & Tableau!"

Don't Just Take My Word For It, Here's Some More Proof For You To See...

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

Register before midnight of 03 Dec 2022

To Unlock the bonuses worth Rs 92,000 /-

Bonus 1

5 Years Free Office 365 Subscription

Worth Rs 75,000

Bonus 2

Free 100+ Excel templates to reduce work

Worth Rs 20,000

Bonus 3

10,000 plus PPT templates for free

Worth Rs 8,000

Bonus 4

FREE Private Access to Skill Nation’s Expert community

Worth Rs 7,000

To claim your bonuses, register before...

  • 00Hours
  • 00Minutes
  • 00Seconds

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

Detailed Breakdown of Masterclass Curriculum

We cover “Everything” about what it takes to become a Data Analyst in India

  • Database Management Systems (DBMS) is a software tool where you can store, edit, and organize data in your database.
  • Difference between DBMS and RDBMS.

  • An Entity-Relationship (ER) diagram is a blueprint to portray the relationship among entities and their attributes.
  • To know the relationship between the data and group it to define the properties.

  • Schema diagram that specifies the name of record type, data type, and other constraints like primary key, foreign key, etc.
  • It is a logical view of the entire database.

  • Key Constraints are used for uniquely identifying an entity within its entity set, in which you have a primary key, foreign key, etc.
  • In this module, you will learn how and where to use all key constraints and normalization basics.

  • Key Constraints are used for uniquely identifying an entity within its entity set.
  • Normalization is used for organizing data to avoid data redundancy.

  • A join is an operation that combines or joins data or rows from other tables based on the common fields amongst them.
  • Multiple table combined to get the required data output.

  • Sorting is a technique to arrange the records in a specific order for a clear understanding of reported data.
  • To sort data in any hierarchy like ascending or descending.
  • Default is ascending order.
  • Can be applied on multiple columns too.

  • The inner query that is independent of the outer query is known as an independent subquery.
  • The inner query result is used in the outer query.
  • The inner query that is dependent on the outer query is known as a correlated subquery.
  • The outer query is used in the inner query.

  • A function that determines values in a group of rows and generates a single result for every row is known as an Analytic Function.
  • Code is simpler and easier to maintain in long run.

  • The operation that combines two or more queries into a single result is called a Set Operation.
  • Various set operators like UNION, INTERSECT, etc. are used to select the data.

  • Grouping is to arrange the same values into groups using some functions like SUM, AVG, etc.
  • Filtering is a powerful SQL technique, which is used for filtering or specifying a subset of data that matches specific criteria.

  • Large data handling through DML. Like Unconditional insert(ALL), conditional first, conditional else, pivoting insert,etc.
  • This module is to help you understand what kind of DML can be on large data sets.

  • The data dictionary base tables are the first objects created in any Oracle database. All data dictionary tables and views for a database are stored in the SYSTEM tablespace.
  • Because the SYSTEM tablespace is always online when the database is open, the data dictionary is always available when the database is open.

  • A schema is a collection of schema objects.
  • Examples of schema objects which we are going to through this module includes tables, views, sequences, synonyms, indexes, functions. Schema objects are logical data storage structures.

  • Sub-queries, WITH statements, scalar sub-queries, are types of retrieving data.
  • This module is to discuss all the types of retrieval of data using sub-queries.

  • Formatting Options
  • Number Formatting
  • Navigation Shortcuts
  • Format Painter
  • Insert Delete Rows &
  • Columns Easily
  • Autofill Data
  • Sorting Data
  • Text Based Filtering
  • Number Based
  • Filtering
  • Date Based Filtering
  • Wildcard Based
  • Filtering
  • Custom Lists

  • Absolute vs Relative References
  • Types of References
  • Sum Formula
  • IF Formula
  • Nested IF Formula
  • AND & OR Formula
  • IF & AND Combination
  • IF & OR Combination
  • NOT Formula
  • NOT & IF Combination
  • COUNTIF Formula
  • COUNTIFS Formula
  • AVERAGEIF Formula
  • AVERAGEIFS Formula
  • SUMIF Formula
  • SUMIFS Formula
  • 8+ Statistical Formulas
  • SMALL Formula
  • LARGE Formula
  • RANK Formula
  • VLOOKUP Formula
  • HLOOKUP Formula
  • LookUp Practice
  • INDEX Formula
  • MATCH Formula
  • INDEX & MATCH
  • INDEX & MATCH Practice
  • FV Formula (Finance)
  • RATE Formula (Finance)
  • NPER Formula (Finance)
  • PMT Formula (Finance)
  • PV Formula (Finance)
  • SWITCH Formula
  • UPPER Formula
  • LOWER Formula
  • PROPER Formula
  • TRIM Formula
  • 5+ Date Formulas
  • 5+ Time Formulas
  • Common Errors & How to rectify them
  • Practice Files & Solutions

  • Fundamentals of Data Visualization
  • Shortcuts to insert charts
  • Changing Elements in a chart
  • Formatting Elements in a chart
  • Column Charts
  • Bar Charts
  • Line Charts
  • Select Data Method
  • Area Chart
  • Pie Chart
  • Donut Chart
  • Histogram Chart
  • Pareto Chart
  • Scatter Plot Chart
  • TreeMap Chart
  • Sunburst Chart
  • Waterfall Chart
  • Heat Maps
  • Combo Chart
  • Sparkline Chart
  • Dynamic Dropdown Chart
  • Dynamic Spin Button Chart
  • Funnel Chart
  • Slope Chart
  • Dumbbell Chart
  • Actual vs Target Charts
  • Practice Files & Solutions

  • Tables & their benefits
  • Introduction to source data
  • Inserting Pivot Tables
  • Understanding the Field List
  • Clear, Select & Move Functions
  • Refreshing Pivot Tables
  • Number & Conditional Format a Pivot Table
  • Sorting a Pivot Table
  • Filter a Pivot Table (Special Trick)
  • Group a Pivot Table (Special Trick)
  • Pivot Table Layouts
  • Table Styles, Grand & Sub Totals
  • Summarize Values By
  • Show Values By
  • Calculated Fields
  • Pivot Charts
  • Slicers
  • Timelines
  • Case Study #1
  • Case Study #2
  • Case Study #3
  • Mega Case Study

  • Name Manager
  • What If Analysis - Goal Seek
  • IFERROR Formula
  • Freeze Panes
  • Multi Level Sort
  • Hide Data
  • Group Data
  • Page Layout & Setup Options
  • Protecting Workbooks
  • Show Formulas Shortcut
  • Text to Columns
  • Working with CSV Files
  • Transposing your Data
  • Inserting Shapes
  • Inserting Smart Art
  • Inserting Images
  • Tracing Precedents
  • Tracing Dependents
  • Remove Duplicates

  • New Features & Changes in Excel
  • XLOOKUP Formula (VLOOKUP Killer)
  • FILTER Formula
  • SORT Formula
  • SORTBY Formula
  • UNIQUE Formula
  • MAXIFS Formula
  • MINIFS Formula
  • IFS Formula (Nested IF Killer)
  • RANDARRAY Formula
  • Combining ALL formulas (PRO)
  • Filled Map Visual
  • Funnel Visual
  • Get Geographical Data in Excel (Automatically)
  • Import Stock Market Data in Excel (Automatically)

  • Wide table vs Tall table
  • Unpivot & Pivot your data
  • Fill Data
  • Replace Data
  • Splitting Data
  • Formatting data
  • Date & Time based transformations
  • Relationships in Data Model
  • Cardinality
  • Lookup formulas vs Relationships
  • Absence of relationships (common scenario)

  • Installation
  • Understanding the interface
  • Types of connectors
  • Loading Data
  • 3 Ways to create a visual
  • Understanding aggregation
  • Understanding the field box
  • Drilling up & Down your data
  • Advanced Drill Down options
  • Formatting visuals
  • Solving a real life challenge
  • Tables & Matrix
  • Bar & Column Charts
  • Pie & Donut
  • Treemaps
  • Line & Combo Charts
  • Bubble Maps
  • Filled Maps
  • Cards & Multi Row Cards
  • Inserting extra elements
  • Assignment
  • Step by step guide on building a bank dashboard
  • Analysing data the expert way
  • 3 AI Powered Visuals to enhance your dashboard

  • Installation
  • Navigation in Tableau
  • Your first 3 minute challenge
  • Marks Tab
  • Granularity
  • Saving & Formatting Data
  • Understanding Maps
  • Relationships & Joins
  • Data Blending
  • Calculated Fields
  • Actual vs Budget
  • Dual Axis
  • Highlight function
  • Creating Bins
  • Parameters
  • Improving Dashboards
  • Executive Story
  • Executive Dashboard
  • Data Preparation
  • PDF to Visualization
  • Grouping Data Challenge
  • Highlight on Maps
  • Predictability using Clustering
  • Multiple Variable Clustering
  • Powerful Trend Analysis
  • Licenses in Tableau

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

Become a Certified Analytics Expert

Master the top core skills to kickstart your career as a Data Analyst. Get certified by Skill Nation

Official and verified

Receive an instructor signed certificate with institution’s logo to verify your achievements and increase your job prospects.

Easily shareable

Add the certificate to your CV or your Resume or post it directly on Linkedin. You can even post it on Instagram and Twitter.

Career improving

Use your Data Analytical skills to secure a great job & climb up the corporate ladder. Have your certificate act as a proof of your knowledge.

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

How does the Masterclass work?

Step 01

Convenient Video Lessons

Watch interesting bite-sized video modules at your convenience with lifetime access.

Step 02

Live Doubt Solving Sessions

Attend 12 LIVE weekly doubt solving sessions to get all your questions answered.

Step 03

Get Certified by Skill Nation

Get Certified by Skill Nation & make your resume stand out with practical skills.

Meet your trainer

A SQL Trainer, who has 11 years of corporate level training experience and industry work experience in multiple MNCs like Wipro Technologies, Caterpillar India Pvt Ltd., Elait Technologies, etc.

Being versatile in training, have handled 3 levels of audience, Students/Freshers roles, Beginners/Developers/Testers roles and Project Managers role to know and understand SQL in various angles of learning perceptions to equip themselves to master SQL.

With insight, knowledge and experience in practical teaching, I partake to travel further with you.

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000 

Convenient Fees

One Time Fee

Rs 9999 Rs 1,48,500

No Cost EMI

Rs 4999 (Installment x2)

Frequently Asked Questions

I have tried my best to answer all the frequently asked questions. If you still have more questions, please write to us at [email protected] (Give us 24 working hours to respond back).
 

Great question. You get the best of both worlds. Certified Data Analytics Program will have 25 hours of self paced modules that you can watch at your own convenience with lifetime access. You will also have LIVE weekly doubt solving sessions for an entire year where you can ask all your doubts & queries.

There is no time limit for completing the Masterclass. You have lifetime access to it and can watch at your own pace.

Yes! You will have access to all video modules AND the LIVE doubt solving sessions incase you are unable to make it. You can learn post office hours too!

Yes, you will be getting Certified in all 4 softwares by Skill Nation.

Yes! You will get lifetime access to all the video modules.

Please write to us at [email protected] & our awesome support team will get back to you as soon as possible.

No, you can only watch them online on the portal. The access is for lifetime.

Do you work with any kind of data? If yes, learning to analyze & present it efficiently is a no brainer for you.

Register before December 04, 2022 to unlock bonuses worth ₹ 92,000