Expert in Oracle PL SQL Training Crash Course
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
- Tesbo Courses
Slash Courses
Classic Courses
The Elevate Certified Data Analyst Training Program delivers in-depth training in R, Tableau, and Power BI to build strong expertise in data analysis and visualization. Learners can also boost their coding capabilities through our Core & Advanced Python Programming Modules. Upon successful completion, students gain job-ready skills and tools that are in high demand across industries. Elevate Academy ensures 100% placement assistance, helping learners access career opportunities with leading organizations. This program is designed to prepare you for future-ready, high-growth roles in data analytics.
This course is part of our curated collection of high-impact, industry-trusted training programs.
Elevate’s Certified Testing Expert program provides deep expertise and hands-on training in software testing. It includes ISTQB Manual Tester certification (45 hrs), advanced manual testing (90 hrs), plus real-time experience in Selenium Java and Selenium Python. You’ll also gain skills in Cucumber, Soap, Appium, and other testing tools (45 hrs). With 100% placement support, we help you launch your career with confidence.
This course empowers you to master all key testing areas: test planning, test case creation, defect reporting, automation, performance testing, and reporting techniques.
Software testing ensures the quality, safety, and efficiency of digital systems. As a Certified Testing Expert, you’ll play a vital role in evaluating, improving, and securing modern software. This skillset is essential across industries and offers growing opportunities in QA and test automation roles.
R Introduction
Introduction to R Studio
R Installation
R Advantages and Disadvantages
R Hadoop Integration
R Packages
List of R Packages
R Basics
Basic Syntax
Comments
Data Types
Data Structures
Variables
Keywords
Operators
Input/Output
Variables
R Variables
Scope of Variables
Dynamic Scoping
Lexical Scoping
Control Statements
R If Statement
If-else Statement
else if Statement
R Switch Statement
R Next Statement
R Break Statement
R Loops
R For Loop
R Repeat Loop
R While Loop
R Functions
Create Functions
Function Arguments
Types of Functions
Recursive Function
Conversion Functions
Local and Global Variables
Data Structures
Strings
Lists
Arrays
Matrix
Data Frame
Object-Oriented Programming
Classes
Objects
Encapsulation
Polymorphism
Inheritance
Abstraction
Looping Over Objects
S3 Class
Explicit
R Debugging
Error Handling
File Handling
Reading Files
Writing Files
Working with Binary Files
Data Interfaces
R CSV File
R Excel File
R Binary File
R JSON File
R XML File
R Database
Data Visualization
R Data Visualization
R Pie Charts
R Boxplot
R Histogram
R Line Graphs
R Scatterplots
Data Manipulation
Selecting Rows/Observations
Selecting Columns/Fields
Merging Data
Relabeling the Column Names
Converting Variable Types
Data Sorting
Data Aggregation
Regression in R
Linear Regression
Multiple Regression
Logistic Regression
Poisson Regression
R Statistics
Bar Chart
Stacked Bar Chart
Bar in Bar Chart
Combo Chart
Line Chart
Single Axis
Dual Axis
Blended Axis
Dual Axis Chart
Line
Bar
Lollipop Chart
Donut
Bullet Graph
Histogram Chart
Animated Graph
Explain Latitude and Longitude
Default Location/Edit Locations
Symbol Map & Filled Map
Map Layer
Image in Map
Map Option
Data Preparation
Connecting to Different Data Sources
Excel
CSV
SQL Server
Live vs Extract Connection
Creating Extract
Refreshing Extract
Increment Extract
Refreshing Live
Data Source Editor
Pivoting and Splitting
Data Interpreter: Clean Dirty Data
TWB vs TWBX
How to Create a Packaged Workbook
Difference Between .tde and .hyper File
Joins
Joins
Inner Join
Left
Right
Outer
Complex Joins
Referential Integrity
Union
Data Blending and When Required
Cross-Database Join
Data Visualization Principles
Why Visualization Comes into the Picture?
Importance of Visualizing Data
Poor Visualization vs Perfect Visualization
Principles of Visualization
Goal of Data Visualization
Basic Filtering/Managing Your Data
Filter
Types of Filters
Quick Filter
Global Filter
Normal Filter
Relevant Filter
Dimension Filter
Measure Filter
Condition-Based Filter
Advanced Filter Using Wildcards
Right-Click Filtering
Top N / Bottom N Filter
Filtering Order of Operation
Extract Filter
Data Source Filter
Context Filter
Building Interactive Dashboards/Advanced Filtering and Actions
Action Filters
Filter
Highlight
Go to URL
Go to Sheet
Set Action
Parameter Action
Action Jumps
Viz in Tooltips
Sorting
Calculation - String, Basic, Dote and Logic
Continuous and Discrete data
Workinq with Dotes
Creating calculated Fields
Logical Functions
Case If Function
ZN Function
Else If Function
Ad-Hoc Functions
Manipulating Text - left and riqht function
Advanced Calculations
Table Calculation
Running Total
Percent Calculation
Percent of Total
Year over Year Growth
LOD
Include
Exclude
Fixed
Groups and Sets
Groups
Sets
In/Out Sets
Combined Sets
Top and Bottom in Single View Parameters
Dynamic Measure
Dynamic Dimension
Hierarchies
Bins
Combined Field
Analytical Topics/Capabilities
Trend Line
Forecasting
Clustering
Reference Line
Box Plot (Understanding Outliers in Data)
Distribution Band
Reference Band
Formatting
Size
Updating Axis
Colors
Borders
Transparency
Chart Line
Reference Line
Mark Label
Annotation
Responsive Tool Tip
Dashboard Design
Canvas Selection
Tiled Objects
Floating Objects
Pixel Perfect Alignment
Summary Box
Chart Titles and Captions
Adding Image and Text
Adding Shadowing
Adding Separator Lines
Dynamic Chart Titles
Information Icons
Creating a Story
Sharing Your Dashboard
Publishing to PDF
Exporting to Pivot Tables and Images
Exporting Packaged Workbooks
Tableau Reader
Tableau Online
Tableau Server
Tableau Public
Version Control
Introduction to Power BI - Need, Importance
Power BI - Advantages and Scalable Options
History - Power View, Power Query, Power Pivot
Power BI Data Source Library and DW Files
Cloud Collaboration and Usage Scope
Business Analyst Tools, MS Cloud Tools
Power BI Installation and Cloud Account
Power BI Cloud and Power BI Service
Power BI Architecture and Data Access
On-Premise Data Access and Microsoft OneDrive
Power BI Desktop - Installation, Usage
Sample Reports and Visualization Controls
Power BI Cloud Account Configuration
Understanding Desktop & Mobile Editions
Report Rendering Options and End User Access
Power View and Power Map, Power BI Licenses
Power BI Design: Conversions, Visualizations, and Fields
Import Data Options with Power BI Model, Advantages
Direct Query Options and Real-time (LIVE) Data Access
Data Fields and Filters with Visualizations
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing, Testing Sets
Creating Customized Tables with Power BI Editor
General Properties, Sizing, Dimensions, and Positions
Alternate Text and Tiles, Header (Column, Row) Properties
Grid Properties (Vertical, Horizontal) and Styles
Table Styles: Alternate Row Colors - Static, Dynamic
Sparse, Flashy Rows, Condensed Table Reports, Focus Mode
Totals Computations, Background, Borders Properties
Column Headers, Column Formatting, Value Properties
Conditional Formatting Options: Color Scale
Page-Level Filters and Report-Level Filters
Visual-Level Filters and Format Options
Report Fields, Formats, and Analytics
Page-Level Filters and Column Formatting, Filters
Background Properties, Borders, and Lock Aspect
Chart and Map Report Properties
Chart Report Types and Properties
Stacked Bar Chart, Stacked Column Chart
Clustered Bar Chart, Clustered Column Chart
100% Stacked Bar Chart, 100% Stacked Column Chart
Line Charts, Area Charts, Stacked Area Charts
Line and Stacked Row Charts
Line and Stacked Column Charts
Waterfall Chart, Scatter Chart, Pie Chart
Field Properties: Axis, Legend, Value, Tooltip
Field Properties: Color Saturation, Filter Types
Formats: Legend, Axis, Data Labels, Plot Area
Data Labels: Visibility, Color, and Display Units
Data Labels: Precision, Position, Text Options
Analytics: Constant Line, Position, Labels
Working with Waterfall Charts and Default Values
Modifying Legends and Visual Filters - Options
Map Reports: Working with Map Reports
Hierarchies: Grouping Multiple Report Fields
Hierarchy Levels and Usage in Visualizations
Preordered Attribute Collection - Advantages
Using Field Hierarchies with Chart Reports
Advanced Query Mode or Connection Settings - Options
Direct Import and In-memory Loads, Advantages
Hierarchies and Drilldown Reports
Hierarchies and Drilldown Options
Hierarchy Levels and Drill Modes - Usage
Drill-through Options with Tree Map and Pie Chart
Higher Levels and Next Level Navigation Options
Aggregates with Bottom/Up Navigations
Multi-Field Aggregations and Hierarchies in Power BI
DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
SEE DATA and SEE RECORDS Options - Differences
Toggle Options with Tabular Data, Filters
Drilldown Buttons and Mouse Hover Options - Visuals
Dependent Aggregations, Independent Aggregations
Automated Records Selection with Tabular Data
Report Parameters: Creation and DataType
Available Values and Default Values, Member Values
Parameters for Column Data and Table / Query Filters
Parameters Creation - Query Mode, UI Option
Linking Parameters to Query Columns - Options
Edit Query Options and Parameter Manage Entries
Connection Parameters and Dynamic Data Sources
Synonyms - Creation and Usage Options
Power BI Interface and Query / Dataset Edits
Working with Empty Tables and Load / Edits
Empty Table Names and Header Row Promotions
Undo Headers Options. Blank Columns Detection
Data Imports and Query Marking in Query Editor
JSON Files & Binary Formats with Power Query
JavaScript Object Notation - Usage with M Language
Applied Steps and Usage Options. Revert Options
Creating Query Groups and Query References. Usage
Query Rename, Load Enable and Data Refresh Options
Combine Queries - Merge Join and Anti-Join Options
Combine Queries - Union and Union All as New Dataset
M Language: NestedJoin and JoinKind Functions
REPLACE, REMOVE ROWS, REMOVE COL, BLANK - M Language
Column Splits and FilledUp / FilledDown Options
Query Hide and Change Type Options. Code Generation
Power Query & M Language - Part 2
Invoke Function and Freezing Columns
Creating Reference Tables and Queries
Detection and Removal of Query Datasets
Custom Columns with Power Query
Power Query Expressions and Usage
Blank Queries and Enumeration Value Generation
M Language Semantics and Syntax. Transform Types
IF..ELSE Conditions, TransformColumn() Types
RemoveColumns(), SplitColumns(), ReplaceValue()
Table.Distinct Options and GROUP BY Options
Table.Group(), Table.Sort() with Type Conversions
PIVOT Operation and Table.Pivot().List Functions
Using Parameters with M Language (Power Query Editor)
Advanced Query Editor and Parameter Scripts
List Generation and Table Conversion Options
Aggregations using Power Query & Usage in Reports
Report Generation using Web Pages & HTML Tables
Reports from Page Collection with Power Query
Aggregate and Evaluate Options with M Language
Creating High-Density Reports, ArcGIS Maps, ESRI Files
Generating QR Codes for Reports
Table Bars and Drill Thru Filters
Dax Expression
Purpose of Data Analysis Expressions (DAX)
Scope of Usage with DAX, Usability Options
DAX Context: Row Context and Filter Context
DAX Entities: Calculated Columns and Measures
DAX Data Types: Numeric, Boolean, Variant, Currency
Date-time Data Type with DAX, Comparison with Excel
DAX Operators & Symbols, Usage, Operator Priority
Parenthesis, Comparison, Arithmetic, Text, Logic
DAX Functions and Types: Table Valued Functions
Filter, Aggregation, and Time Intelligence Functions
Information Functions, Logical, Parent-Child Functions
Statistical and Text Functions, Formulas and Queries
Syntax Requirements with DAX, Differences with Excel
Naming Conventions and DAX Format Representation
Working with Special Characters in Table Names
DAX Expressions - Level 2
YTD, QTD, MTD Calculations with DAX
DAX Calculations and Measures
Using TOPN, RANKX, RANK.EQ
Computations using STDEV, VAR
SAMPLE Function, COUNTALL, ISERROR
ISTEXT, DATEFORMAT, TIMEFORMAT
Time Intelligence Functions with DAX
Data Analysis Expressions and Functions
DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
CLOSINGBALANCEYEAR, CLOSINGBALANCEQTR
SAMEPERIOD and PREVIOUSMONTH, QUARTER
KPIs with DAX, Vertipaq Queries in DAX
IF..ELSEIF.. Conditions with DAX
Slicing and Dicing Options with Columns, Measures
DAX for Query Extraction, Data Mashup Operations
Calculated Columns and Calculated Measures with DAX
Power BI Report Validation and Publish
Understanding Power BI Cloud Architecture
Power BI Cloud Account and Workspace
Reports and DataSet Items Validation
Dashboards and Pins - Real-time Usage
Dynamic Data Sources and Encryptions
Personal and Organizational Content Packs
Gateways, Subscriptions, Mobile Reports
Data Refresh with Power BI Architecture
PBIX and PBIT Files with Power BI - Usage
Visual Data Imports and Visual Schemas
Cloud and On-Premise Data Sources
How Power BI Supports Data Model?
Relation between Dashboards to Reports
Relation between Datasets to Reports
Relation between Datasets to Dashboards
Page to Report - Mapping Options
Publish Options and Data Import Options
Need for Pins & Visuals and Pins & Reports
Need for Data Streams and Cloud Integration
Power BI Cloud Operations
Report Publish Options and Verifications
Working with Power BI Cloud Interface & Options
Navigation Paths with "My Workspace" Screens
FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
Saving Reports into pdf, pptx, etc. Report Embed
Report Rendering and EDIT, SAVE, Print Options
Report PIN and individual Visual PIN Options
Create and Use Dashboards. Menu Options
Goto Dashboard and Goto LIVE Page Options
Operations on Pinned Reports and Visuals
TITLE, MEDIA, USAGE METRICS & FAVOURITES
SUBSCRIPTION Options and Reports with Mobile View
Options with Report Page: Print and Subscribe
Report Actions: USAGE METRICS, ANALYSE IN EXCEL
Report Actions: RELATED ITEMS, RENAME, DELETE
Dashboard Actions: METRICS, RELATED ITEMS
Dashboard Actions: SETTINGS FOR Q & A, DELETE
PIN Actions: METRICS, SHARE, RELATED ITEMS
PIN Actions: SETTINGS FOR Q & A, DELETE
EDIT DASHBOARD (CLOUD), On-The-Fly Reports
Dataset Actions: CREATE REPORT, REFRESH
SCHEDULED REFRESH & RELATED ITEMS
Dashboard Integration with Apps in Power BI
Improving Power BI Reports
Scripting and Programming Concepts
What is Script, Program?
Types of Scripts
Difference between Script and Programming Languages
Features and Limitations of Scripting
Types of Programming Language Paradigms
Introduction to Python
Python Basics
Execute the Script
Interactive and Script Mode
Python File Extensions
Setting PATH in Windows
Clear screen inside Python
Learn Python Main Function
Python Comments
Quit the Python Shell
Shell as a Simple Calculator
Order of Operations
Multiline Statements
Quotations in Python
Python Path Testing
Joining Two Lines
Python Implementation Alternatives
Subpackages in Python
Uses of Python in Data Science, IoT
Working with Python in Unix/Linux/Windows/Mac/Android
Python New IDEs
PyCharm IDE
How to Work on PyCharm
PyCharm Components
Debugging Process in PyCharm
Python Install Anaconda
What is Anaconda?
Coding Environments
Spyder Components
General Spyder Features
Spyder Shortcut Keys
Jupyter Notebook
What is Conda? And Conda List?
Jupyter and Kernels
What is PIP?
Variables and Constants in Python
What is a Variable?
Variables and Constants in Python
Variable Names and Values
Mnemonic Variable Names and Types
What Does "Type" Mean?
Multiple Assignment
Python's Different Numerical Types
Python Data Types
Lists
Lists are Mutable
Getting to Lists
List Indices
Traversing a List
List Operations, Slices, and Methods
Map, Filter, and Reduce
Deleting Elements
Lists and Strings
Tuples
Advantages of Tuple over List
Packing and Unpacking
Comparing Tuples
Creating Nested Tuples
Using Tuples as Keys in Dictionaries
Deleting Tuples
Slicing of Tuple
Tuple Membership Test
Built-in Functions with Tuple
Dictionary
How to Create a Dictionary?
Python Hashing?
Python Dictionary Methods
Copying Dictionary
Updating Dictionary
Deleting Keys from the Dictionary
Dictionary items() Method
Sorting the Dictionary
Python Dictionary Built-in Functions
Dictionary len() Method
Variable Types
Python List cmp() Method
Dictionary Str(dict)
Set
How to Create a Set?
Iteration Over Sets
Python Set Methods
Python Set Operations Union of Sets
Built-in Functions with Set
Python Frozenset
Strings
Operators
Conditional Statements
How to Use "if condition" in Conditional Structures
if Statement (One-Way Decisions)
if .. else Statement (Two-way Decisions)
How to Use "else condition"
if .. elif .. else Statement (Multi-way)
When "else condition" Does Not Work
How to Use "elif" Condition
How to Execute Conditional Statement with Minimal Code
Nested IF Statement
What is an Operator?
Different Types of Operators
Arithmetic Operators
Assignment Operator
Unary Minus Operator
Relational Operators
Logical Operators
Membership Operators
Identity Operators
Python Loops
How to Use "While Loop" and "For Loop"
How to Use For Loop for Set of Other Things Besides Numbers
Break Statements, Continue Statement, Enumerate Function for For Loop
Practical Example: How to Use For Loop to Repeat the Same Statement Over and Again
Break, Continue Statements
How to define and call a function in Python
Types of Functions
Significance of Indentation (Space) in Python
How Function Return Value?
Types of Arguments in Functions
Default Arguments and Non-Default Arguments
Keyword Argument and Non-keyword Arguments
Arbitrary Arguments
Rules to define a function in Python
Various Forms of Function Arguments
Scope and Lifetime of Variables
Nested Functions
Call By Value, Call by Reference
Anonymous Functions/Lambda Functions
Passing functions to function
map(), filter(), reduce() functions
What is a Docstring?
Lambda Operator, Filter, Reduce and Map
Lambda function
Filter function
Reduce function
Map function
Introduction
Generator Comprehension
Set Comprehension
Modules
Importing module
Math module
Random module
Packages
Composition
Input-Output
Printing on screen
Reading data from keyboard
Opening and closing file
Reading and writing files
Functions
Exception
Exception Handling
Except clause
Try...finally clause
User Defined Exceptions
Regular Expressions
Match function
Search function
Matching VS Searching
Modifiers
Patterns
Predefined Packages
Predefined Packages
User Defined
Packages File Handling
Text Files
Binary Files
Zip and Unzip Files
Pickling
Unpickling
Reading Program from Another Program in Command Prompt
File Handling
Python File Handling
Python Read Files
Python Write/Create Files
Python Delete Files
Constructor
What are Constructors
Is Constructor Mandatory in Python?
Can a Constructor be Called Explicitly?
How Many Parameters Can a Constructor Have?
Parameterized and Non-Parameterized Constructors in Python
Difference Between a Method and Constructor in Python
Difference Between a Method and a Function
Types of Class Variables
Types of Class Variables
Instance Variables
Where Instance Variables Can Be Declared?
Accessing Instance Variables
Static Variables
Declaring Static Variables
Accessing a Static Variable
Local Variables
Types of Class Method
Types of Methods in a Class
Instance Methods
Setter and Getter Methods
Class Methods
Static Methods
Nested Classes
Garbage Collection
Super Function
Super() Function in Python
Which Scenarios Super() Function is Required?
Different Approaches for Calling Method of a Specific Super Class
Different Cases for Super() Function
Polymorphism
Polymorphism
Types of Polymorphism
Overloading
Operator Overloading
Method Overloading
How We Can Handle Overloaded Method Requirements
Constructor Overloading
Overriding
Method Overriding
Constructor Overriding
Abstract Classes
Abstract Classes
What is an Abstract Class in Python?
Types of Methods in Python Based on the Implementation
How to Declare an Abstract Method in Python
Abstract Classes in Python
Exception Handling
Types of Error
Syntax and Runtime Errors
What is an Exception?
Exception Handling in Python
Finally Block
Why do We Need Finally Block?
Finally Block in Python
Why Not ‘try except’ Block for Clean-up Activities?
Different Control Flow Cases of try except finally in Python
Nested try-except-finally Blocks
Nested try-except-finally Blocks in Python
Different Cases and Scenarios
Else Block in Python
Possible Combinations with try-except-else-finally
Files
What is a File?
Types of Files
File Modes
Opening and Closing a File
Properties of File Object
Writing Data to a File
Reading Data from a File
With Keyword
Introduction
What is Multitasking?
Process-based and Thread-based Multitasking
Applications of Multithreading
How to Implement Multithreading?
Different Ways to Create a Thread
Creating a Thread Using Thread Class
Creating a Thread by Inheriting Thread Class
Methods of Thread Class
active_count()
enumerate()
isAlive()
join()
join(seconds)
Synchronization
Synchronization
How to Implement Synchronization?
Synchronization by Using Lock Concept
Synchronization by Using RLock Concept
Difference Between Lock and RLock
Synchronization by Using Semaphore
Bounded Semaphore
Inter Thread Communication
What is Inter Thread Communication?
Inter Thread Communication by Using Event Objects
Inter Thread Communication by Using Condition Object
Inter Thread Communication by Using Queue in Python
Types of Queues
FIFO Queue
LIFO Queue
Priority Queue
Python XML Parser
What is XML?
Difference between XML and HTML, XML, JSON, Gson
How to Parse XML and Create XML Node
Python vs JAVA
XML and HTML
Python - Database Communication
What is Database?
Types of Databases
What is DBMS? RDBMS?
What is Big Data?
Types of Data
Oracle MySQL
SQL Server
DB2
Postgres SQL
Executing the Queries
Bind Variables
Installing Oracle Python Modules
Unit Testing with PyUnit
What is Testing?
Types of Testing and Methods
What is Unit Testing?
What is PyUnit?
Test Scenarios, Test Cases, Test Suites
Networking
Socket
Socket Module
Methods
Client and Server
Internet Modules
Numpy
Introduction to Numpy
Creating Arrays and Indexing Arrays
Array Transposition
Universal Array Function
Array Processing
Array Input and Output
Pandas
What are Pandas?
Where it is Used?
Series in Pandas
Index Objects
Reindex
Drop Entry
Selecting Entries
Data Alignment
Rank and Sort
Summary Statistics
Index Hierarchy
Matplotlib
Data Visualization
Python for Data Visualization
Welcome to the Data Visualization Section
Introduction to Matplotlib
Data Science
What is Data Science?
Data Science Life Cycle
What is Data Analysis, Data Mining?
Analytics vs Data Science
Internet of Things
Impact of the Internet
What is IoT?
History of IoT
What is Network, Protocol, Smart?
How IoT Works?
The Future of IoT
Learn core data analysis methods to interpret, process, and visualize data using tools aligned with industry standards.
Build strong SQL skills to extract, filter, and manipulate data from databases for real-time business applications.
Advance your Excel expertise to organize, analyze, and present data through powerful reports and dynamic dashboards.
Create interactive dashboards with Tableau and Power BI to transform data into clear, actionable business insights.
Apply statistical tools and predictive models to uncover trends and make data-driven decisions with confidence.
Work on live projects that replicate real industry problems, boosting your practical knowledge and analytical ability.
June 13, 2025In today’s fast-paced digital world, the demand for skilled software professionals is higher than ever. Whether you’re a student aiming…
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Master in Oracle DBA Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Core MSSQL Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry Expert 400+…
Refer your friends or colleagues to Elevate and earn gift vouchers worth up to ₹1000 for each successful enrollment.
Help others upskill while you enjoy exclusive rewards—it’s a win-win!
