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
Elevate Academy stands at the forefront of data analysis education, delivering a well-rounded program designed to help you analyze, interpret, and utilize data effectively. This comprehensive course covers core areas including statistical analysis, data visualization, machine learning, and data-driven decision-making. Through hands-on projects and real-world applications, students gain practical experience under the guidance of expert instructors. Join us at our Anna Nagar, Madurai campus—recognized as one of the top computer training centers—to begin your journey in data analysis.
This course is part of our top-rated curriculum, selected by businesses worldwide to train and upskill their teams in data analysis and visualization.
The Python for Data Analysts (R, Tableau & Power BI) program from Elevate Academy equips learners with the essential tools and techniques required to succeed in modern data analysis roles. Through hands-on learning and expert mentorship, participants master key platforms—Python, R, Tableau, and Power BI—while also gaining exposure to machine learning and automation. This course prepares graduates to handle real-world data challenges and contribute effectively in data-driven environments.
This program is designed to help you develop a deep understanding of Python programming within the context of data analysis. You’ll gain skills in statistical analysis, visualization, machine learning, NLP, and web scraping. You’ll also learn to use essential tools like R, Tableau, and Power BI to make sense of complex datasets and communicate insights effectively.
1. R Introduction
Introduction to R Studio
R installation
R Advantage & Disadvantage
R Hadoop Integration
R Packages
List of R Packages
2. R Basics
Basic Syntax
Comments
Data Types
Data Structures
Variables
Keywords
Operators
Input/Output
3. Variables
R variables
Scope of Variables
Dynamic Scoping
Lexical Scoping
1. Control Statements
R if Statement
If-else Statement
Else if Statement
R Switch Statement
R Next Statement
R Break Statement
2. R Loops
R For Loop
R Repeat Loop
R While Loop
3. R Functions
Create Functions
Function Arguments
Types of Function
Recursive Function
Conversion Functions
Local and global variable
1. Data Structures
Strings
Lists
Arrays
Matrix
Data Frame
2. Object-Oriented Programming
Classes
Objects
Encapsulation
Polymorphism
Inheritance
Abstraction
Looping Over Objects
S3 class
Explicit
R Debugging
Error Handling
3. File Handling
Reading Files
Writing Files
Working with Binary Files
4. Data Interfaces
R CSV File
R Excel File
R Binary File
R JSON File
R XML File
R Database
5. Data Visualization
R Data Visualization
R Pie Charts
R Boxplot
R Histogram
R Line Graphics
R Scatterplots
1. Manipulating Data
Selecting rows/observations
Selecting columns/fields
Merging data
Relabeling the column names
Converting variable types
Data sorting
Data aggregation
2. R Regression
Linear Regression
Multiple Regression
Logistic Regression
Poisson Regression
3. R Statistics
Normal Distribution
Binomial Distribution
R Classification
Time Series Analysis
R Random Forest
T-Test in R Chi-Square Test
1. Introduction to Tableau
What is Tableau
Architecture of Tableau
Features of Tableau
Installation of Tableau Desktop/Public
Navigation
Design Flow
File System
Data Types
2. Data Sources
Data Source Connection
Import Excel File
Data Cleaning
Join Database
Data Blending
Split the Text to Columns
Displaying data in worksheet
Adding Renaming and Duplicating
3. Data Visualization/Graph
Pivot Table and Heat Map
Highlight Table
Bar Chart
Line Chart
Area Chart
Pie Chart
Scatter Plot
Word Cloud
Tree Map
Blended Axis
Dual Axis
1. Introduction to Tableau
What is Tableau
Architecture of Tableau
Features of Tableau
Installation of Tableau Desktop/Public
Navigation
Design Flow
File System
Data Types
2. Data Sources
Data Source Connection
Import Excel File
Data Cleaning
Join Database
Data Blending
Split the Text to Columns
Displaying Data in Worksheet
Adding, Renaming, and Duplicating
3. Data Visualization/Graph
Pivot Table and Heat Map
Highlight Table
Bar Chart
Line Chart
Area Chart
Pie Chart
Scatter Plot
Word Cloud
Tree Map
Blended Axis
Dual Axis
4. Advance Data Visualization/Graph
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
1. Building View Advance Map Option
2. Data Preparation
1. Advanced Data Preparation
Joins
Inner
Left
Right
Outer
Complex Join
Referential Integrity
Union
Data Blending and When Required
Cross DB Join
2. Data Visualization Principles
Why Visualization Came into the Picture?
Importance of Visualizing Data
Poor Visualization vs Perfect Visualization
vPrinciples of Visualization
Goal of Data Visualization
3. Basic Filter/Managing your Data
Filter
Types of Filter
Quick Filter
Global Filter
Normal Filter
Relevant Filter
Dimension Filter
Measure Filter
Condition Based Filter
Advanced Filter Using Wild Card
Right Click Filtering
Top & Bottom N Filter
Filtering Order of Operation
Extract Filter
Data Source Filter
Context Filter
4. Building Interactive Dashboard/Advanced Filtering and Action
Action Filter
Filter
Highlight
Go to URL
Go to Sheet
Set Action
Parameter Action
Action Jumps
Viz in Tool Tip
1. Basic Calculation
Sorting
Calculation - String, Basic, Date and Logical
Continuous and Discrete data
Working with Dates
Creating calculated Field
Logical Function
Case in Function
ZN Function
Else if Function
Ad-hoc Function
Manipulating Text - Left and Right Function
2. Advance Calculation
Table Calculation
Running Total
Percent
Percent Total
Year Over Year Growth
LOD
Include
Exclude
Fixed
1. Grouping Data/Dynamic Representation
Groups
Sets
In/Out Sets
Combined Sets
Top and Bottom In Single View Parameters
Dynamic Measure
Dynamic Dimension
Hierarchies
Bins
Combined Field
2. Analytical Topic/Capability
Trend Line
Forecasting
C luster
Reference Line
Box Plot (Understanding Outliers In Data)
Distribution Band
Reference Band
3. Formatting
Size
Updating Axis
Colors
Borders
Transparency
Chart Line
Reference Time
Mark Label
Annotation
Responsive Tool Tip
4. Dashboard Design
Canvas Selection
Tiled Object
Floating Object
Pixel Perfect Alignment
Summary Box
Chart Titles and Captions
Adding Image and Text
Adding Shading
Adding Separator Lines
Dynamic Chart Title
Information Icons
Creating a Story
5. Sharing Your Dashboard
Publishing to PDF
Exporting to Pivot Table and Images
Exporting Packaged Workbooks
Tableau Reader
Tableau Online
Tableau Server
Tableau Public
Version Control
Introduction To Power BI
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 Edition
Report Rendering Options and End User Access
Power View and Power Map, Power BI Licenses
Creating Power BI Reports, Auto Filters
Report Design with Legacy & DAT Files
Report Design With Database Tables
Understanding Power BI Report Designer
Report Canvas; Report Pages: Creation, Renames
Report Visuals, Fields and UI Options
Experimenting Visual Interactions: Advantages
Reports with Multiple Pages and Advantages
Pages with Multiple Visualizations Data Access
PUBLISH Options and Report Verification in Cloud
GET DATA Options and Report Field
Report View Options: Full, Fit to Page, Width Scale
Report: Design using Databases & Queries
Query Settings and Data Preloads
Navigation Options and Report Refresh
Stacked Bar Chart, Stacked Column Chart
Clustered Bar Chart, Clustered Column Chart
Adding Report Titles, Report Format Options
Focus Mode, Explore and Export Settings
1. REPORT VISUALIZATIONS and PROPERTIES
Power BI Design: Canvas, Visualizations, and Fields
Import Data Options with Power BI Model, Advantages
Direct Query Options and Real-time (LIVE) Data Access
Drag Fields and Filters with Visualizations
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing Testing Sets
Creating Customized Tables With Power BI
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
2. 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 usages in visualization
Preordered attribute collection - advantages
Using field hierarchies with chart reports
Advanced query mode connection settings options
Direct import and in-memory loads, advantages
3. HIERARCHIES and DRILLDOWN REPORTS
Hierarchies and Drilldown Options
Hierarchy Levels and Drill Modes - Usage
Drill thru 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
Dependant Aggregations, Independent Aggregations
Automated Records Selection with Tabular Data
Report Parameters: Creation and Data Type
Available Values and Default Values, Member Values
Parameters for Column Data and Table Query Filters
Parameters Creation - Query Mode 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 QUERY & M LANGUAGE
Understanding Power Query Editor - Options
Power BI Interface and Query/Dataset
Working with Empty Tables and Load/IIRS 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 - Nested Join and Joinkind Functions
REPLACE, REMOVE ROWS, REMOVE COL BLANK M Language
Column Splits and Filled Up / Filled Down 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 within Power Query
Power Query Expressions and Usage
Blank Queries and Enumeration Value Generation
M Language Semantics and Syntax, Transform Types
IF ELSE Conditions, Transform Column() 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
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
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
DAX: DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
CLOSINGBALANCEYEAR, CLOSINGBALANCEQTR
SAMEPERIOD and PREVIOUSMONTH, QUARTER
KRIS with DAX, Vertipaq Queries in DAX
IF ELSE 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 Deployment & Cloud
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 PBI Files with Power BI - Usage
Visual Data Imports and Visual Slicers
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 @ Report
Need for Data Streams and Cloud
Power BI Cloud Operations
Report Publish Options and Verifications
Working with Power BI Cloud Interface & Options
Navigation Paths with "My Workspace" Screen
BILE 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 Value
Title, Media, Usage Metrics & Favorites
Subscription Option and Reports with Mobile View
Options with Report Page Print and Subscribe
Report Actions: Usage Metrics, Analyze 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
Publish Power BI Report Templates
Import and Export Options with Power BI
Dataset Navigations and Report Navigations
Quick Navigation Options with "My Workspace"
Dashboards, Workbooks, Reports, Datasets
Working with My Workspace Group
Installing the Power BI Personal Gateway
Automatic Refresh - Possible Issues
Adding Images in the Dashboard
Reading & Editing Power BI Views
Power BI Templates (pbit) - Creation, Usage
Managing Report in Power BI Services
Power BI Gateway - Download and Installation
Personal and Enterprise Gateway Features
Power BI Settings Dataset Gateway Integration
Configuring Dataset for Manual Refresh of Data
Configuring Automatic Refresh and Schedules
Workbooks and Alerts with Power BI
Dataset Actions and Refresh Settings with Gateway
Insights And Subscriptions
Data Navigation Paths and Data Splits
Getting data from existing systems
Data Refresh and LIVE Connections
pbit and pbix: differences, Usage Options
Quick insights for Power BI Reports
Quick insights for Power BI Dashboards
Generating insights with Cloud Datasets
Generating Reports with Cloud Datasets
Using relational databases on-premises
Using relational databases in the cloud
Consuming a service content pack
Creating a custom data set from a service
Creating a content pack for your organization
Consuming an organizational content pack
Updating an organizational content pack
Adding Tiles: Images, Videos, Data Streams
Creating New Reports from Cortana, Advantages
Gain expertise in leading tools such as Python, R, Tableau, and Power BI for in-depth data analysis and visualization.
Work on real-world projects to apply your skills and build confidence in analyzing diverse datasets.
Develop proficiency in manipulating and preparing data using Python and R to derive meaningful insights.
Learn to create impactful visualizations and dynamic dashboards with Tableau and Power BI.
Deepen your understanding of statistical methods and data modeling using R programming.
Receive a recognized certification upon course completion, along with career support to help you grow in data analysis roles.
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!
