Data Analysist Training Course (R,Tableau & Power BI)

What the specialist says

Excel, Power BI, Tableau — this stack is still the fastest way into real analytics work.

Ravi Kamat Data & BI Specialist

Gain Essential Python Skills: Excel in Data Analysis, Earn Certification, Advance Your Career! DevLustro Academy leads in Data Analysis, offering a comprehensive program to leverage, interpret, and utilize data innovatively. Our curriculum covers statistical analysis, data visualization, machine learning, and data-driven decision-making. With hands-on projects and real-world applications, students gain practical experience. Expert instructors provide personalized guidance, ensuring confidence in professional settings. Join us at our Madurai campus in Anna Nagar, the best computer center near you, to master data analysis. Course was selected for our collection of top-rated courses trusted by businesses worldwide.

Our Core Highlights

World Class Instructor Mentorship from global experts

1:1 with Industry Expert Personalised coaching tailored to you

Global Hiring Network 400+ hiring partners around the world

Average Salary Hike 55% average hike for our alumni

Course Description

Gain Essential Python Skills: Excel in Data Analysis, Earn Certification, Advance Your Career! Elysium Academy leads in Data Analysis, offering a comprehensive program to leverage, interpret, and utilize data innovatively. Our curriculum covers statistical analysis, data visualization, machine learning, and data-driven decision-making. With hands-on projects and real-world applications, students gain practical experience. Expert instructors provide personalized guidance, ensuring confidence in professional settings. Join us at our Madurai campus in Anna Nagar, the best computer center near you, to master data analysis. Course was selected for our collection of top-rated courses trusted by businesses worldwide.

Data Analysist Training Course (R,Tableau & Power BI)

Data Analyst Course

Course Details

Explore advanced concepts like object-oriented programming (OOP) and error handling.

Utilize powerful libraries such as NumPy and Pandas for data manipulation and analysis.

Visualize data effectively using Tableau and Power BI.

Implement machine learning models with Scikit-learn and R.

High demand for data analysts due to the exponential growth of data generation.

Skills in R, Tableau, and Power BI are relevant across various industries, enhancing employability.

Integration with AI, machine learning, and big data technologies is increasing in importance.

Organizations are adopting data-driven decision-making processes, creating a continuous need for data analysts.

Graduates can pursue diverse roles such as Data Analyst, Business Analyst, Data Scientist, and BI Developer.

Course Goals

Master Python essentials: variables, data types, loops, and functions.
Dive into deep learning techniques using TensorFlow.

Future Scope of this Course

Industry Based Projects
Recognized worldwide

Our Career Service

Personalized coordinator.
Trainer feedback.
Trainer availability post sessions.
Get your staff certified.
Certificate from governing bodies.

Our Training Program Benefits

Hands on assignment
Curriculum that focuses on the learner.
Live, interactive training by DevLustro experts.
Curriculum aligned with current industry practices.
Portfolio / project support for real-world use.

01Chapter-1 R Introduction

01.01Introduction to R Studio
01.02R installation
01.03R Advantage & Disadvantage
01.04R Hadoop Integration
01.05R Packages
01.06List of R Packages
01.07Basic Syntax
01.08Comments
01.09Data Types
01.10Data Structures
01.11Variables
01.12Keywords
01.13Operators
01.14Input/Output
01.15R variables
01.16Scope of Variables
01.17Dynamic Scoping
01.18Lexical Scoping

02Chapter-2 Control Statements

02.01R if Statement
02.02If-else Statement
02.03Else if Statement
02.04R Switch Statement
02.05R Next Statement
02.06R Break Statement
02.07R For Loop
02.08R Repeat Loop
02.09R While Loop
02.10Create Functions
02.11Function Arguments
02.12Types of Function
02.13Recursive Function
02.14Conversion Functions
02.15Local and global variable

03Chapter-3 Data Structures

03.01Strings
03.02Lists
03.03Arrays
03.04Matrix
03.05Data Frame
03.06Classes
03.07Objects
03.08Encapsulation
03.09Polymorphism
03.10Inheritance
03.11Abstraction
03.12Looping Over Objects
03.13S3 class
03.14Explicit
03.15R Debugging
03.16Error Handling
03.17Reading Files
03.18Writing Files
03.19Working with Binary Files
03.20R CSV File
03.21R Excel File
03.22R Binary File
03.23R JSON File
03.24R XML File
03.25R Database
03.26R Data Visualization
03.27R Pie Charts
03.28R Boxplot
03.29R Histogram
03.30R Line Graphics
03.31R Scatterplots

04Chapter-4 Manipulating Data

04.01Selecting rows/observations
04.02Selecting columns/fields
04.03Merging data
04.04Relabeling the column names
04.05Converting variable types
04.06Data sorting
04.07Data aggregation
04.08Linear Regression
04.09Multiple Regression
04.10Logistic Regression
04.11Poisson Regression
04.12Normal Distribution
04.13Binomial Distribution
04.14R Classification
04.15Time Series Analysis
04.16R Random Forest
04.17T-Test in R Chi-Square Test

05Chapter-5 Introduction to Tableau

05.01What is Tableau
05.02Architecture of Tableau
05.03Features of Tableau
05.04Installation of Tableau Desktop/Public
05.05Navigation
05.06Design Flow
05.07File System
05.08Data Types
05.09Data Source Connection
05.10Import Excel File
05.11Data Cleaning
05.12Join Database
05.13Data Blending
05.14Split the Text to Columns
05.15Displaying data in worksheet
05.16Adding Renaming and Duplicating
05.17Pivot Table and Heat Map
05.18Highlight Table
05.19Bar Chart
05.20Line Chart
05.21Area Chart
05.22Pie Chart
05.23Scatter Plot
05.24Word Cloud
05.25Tree Map
05.26Blended Axis
05.27Dual Axis

06Chapter-6 Advance Data Visualization/Graph

06.01What is Tableau
06.02Architecture of Tableau
06.03Features of Tableau
06.04Installation of Tableau Desktop/Public
06.05Navigation
06.06Design Flow
06.07File System
06.08Data Types
06.09Data Source Connection
06.10Import Excel File
06.11Data Cleaning
06.12Join Database
06.13Data Blending
06.14Split the Text to Columns
06.15Displaying Data in Worksheet
06.16Adding, Renaming, and Duplicating
06.17Pivot Table and Heat Map
06.18Highlight Table
06.19Bar Chart
06.20Line Chart
06.21Area Chart
06.22Pie Chart
06.23Scatter Plot
06.24Word Cloud
06.25Tree Map
06.26Blended Axis
06.27Dual Axis
06.28Bar Chart Stacked Bar Chart Bar in Bar Chart Combo Chart
06.29Stacked Bar Chart
06.30Bar in Bar Chart
06.31Combo Chart
06.32Line Chart Single Axis Dual Axis Blended Axis
06.33Single Axis
06.34Dual Axis
06.35Blended Axis
06.36Dual Axis Chart Line Bar Lollipop Chart Donut Bullet Graph Histogram Chart Animated Graph
06.37Line
06.38Lollipop Chart
06.39Donut
06.40Bullet Graph
06.41Histogram Chart
06.42Animated Graph

07Chapter-7 Building View Advance Map Option

07.01Explain latitude and longitude
07.02Default location/Edit locations
07.03Symbol Map & Filled Map
07.04Map Layer
07.05Image in Map
07.06Map Option
07.07Connecting to Different Data Source
07.08Excel
07.09SQL Server
07.10Live vs Extract Connection
07.11Creating Extract
07.12Refreshing Extract
07.13Increment Extract
07.14Refreshing Live
07.15Data Source Editor
07.16Pivoting and Splitting
07.17Data Interpreter: Clean Dirty Data
07.18TWB vs TWBX
07.19How to Create a Packaged Workbook
07.20Difference Between .tde and .hyper File

08Chapter-8 Advanced Data Preparation

08.01Joins
08.02Inner
08.03Left
08.04Right
08.05Outer
08.06Complex Join
08.07Referential Integrity
08.08Union
08.09Data Blending and When Required
08.10Cross DB Join
08.11Why Visualization Came into the Picture?
08.12Importance of Visualizing Data
08.13Poor Visualization vs Perfect Visualization
08.14vPrinciples of Visualization
08.15Goal of Data Visualization
08.16Filter
08.17Types of Filter
08.18Quick Filter
08.19Global Filter
08.20Normal Filter
08.21Relevant Filter
08.22Dimension Filter
08.23Measure Filter
08.24Condition Based Filter
08.25Advanced Filter Using Wild Card
08.26Right Click Filtering
08.27Top & Bottom N Filter
08.28Filtering Order of Operation
08.29Extract Filter
08.30Data Source Filter
08.31Context Filter
08.32Action Filter
08.33Filter
08.34Highlight
08.35Go to URL
08.36Go to Sheet
08.37Set Action
08.38Parameter Action
08.39Action Jumps
08.40Viz in Tool Tip

09Chapter-9 Basic Calculation

09.01Sorting
09.02Calculation - String, Basic, Date and Logical
09.03Continuous and Discrete data
09.04Working with Dates
09.05Creating calculated Field
09.06Logical Function
09.07Case in Function
09.08ZN Function
09.09Else if Function
09.10Ad-hoc Function
09.11Manipulating Text - Left and Right Function
09.12Table Calculation
09.13Running Total
09.14Percent
09.15Percent Total
09.16Year Over Year Growth
09.17Include
09.18Exclude
09.19Fixed

10Chapter-10 Grouping Data/Dynamic Representation

10.01Groups
10.02Sets
10.03In/Out Sets
10.04Combined Sets
10.05Top and Bottom In Single View Parameters
10.06Dynamic Measure
10.07Dynamic Dimension
10.08Hierarchies
10.09Bins
10.10Combined Field
10.11Trend Line
10.12Forecasting
10.13C luster
10.14Reference Line
10.15Box Plot (Understanding Outliers In Data)
10.16Distribution Band
10.17Reference Band
10.18Size
10.19Updating Axis
10.20Colors
10.21Borders
10.22Transparency
10.23Chart Line
10.24Reference Time
10.25Mark Label
10.26Annotation
10.27Responsive Tool Tip
10.28Canvas Selection
10.29Tiled Object
10.30Floating Object
10.31Pixel Perfect Alignment
10.32Summary Box
10.33Chart Titles and Captions
10.34Adding Image and Text
10.35Adding Shading
10.36Adding Separator Lines
10.37Dynamic Chart Title
10.38Information Icons
10.39Creating a Story
10.40Publishing to PDF
10.41Exporting to Pivot Table and Images
10.42Exporting Packaged Workbooks
10.43Tableau Reader
10.44Tableau Online
10.45Tableau Server
10.46Tableau Public
10.47Version Control

11Chapter-11 Introduction To Power Bi

11.01Introduction to Power BI: Need, Importance
11.02Power BI - Advantages and Scalable Options
11.03History - Power View, Power Query, Power Pivot
11.04Power BI Data Source Library and DW Files
11.05Cloud Collaboration and Usage Scope
11.06Business Analyst Tools, MS Cloud Tools
11.07Power BI Installation and Cloud Account
11.08Power BI Cloud and Power BI Service
11.09Power BI Architecture and Data Access
11.10On-Premise Data Access and Microsoft OneDrive
11.11Power BI Desktop - Installation, Usage
11.12Sample Reports and Visualization Controls
11.13Power BI Cloud Account Configuration
11.14Understanding Desktop & Mobile Edition
11.15Report Rendering Options and End User Access
11.16Power View and Power Map, Power BI Licenses
11.17Report Design with Legacy & DAT Files
11.18Report Design With Database Tables
11.19Understanding Power BI Report Designer
11.20Report Canvas; Report Pages: Creation, Renames
11.21Report Visuals, Fields and UI Options
11.22Experimenting Visual Interactions: Advantages
11.23Reports with Multiple Pages and Advantages
11.24Pages with Multiple Visualizations Data Access
11.25PUBLISH Options and Report Verification in Cloud
11.26GET DATA Options and Report Field
11.27Report View Options: Full, Fit to Page, Width Scale
11.28Report: Design using Databases & Queries
11.29Query Settings and Data Preloads
11.30Navigation Options and Report Refresh
11.31Stacked Bar Chart, Stacked Column Chart
11.32Clustered Bar Chart, Clustered Column Chart
11.33Adding Report Titles, Report Format Options
11.34Focus Mode, Explore and Export Settings

12Chapter-12 Report Visualization and Properties

12.01Power BI Design: Canvas, Visualizations, and Fields
12.02Import Data Options with Power BI Model, Advantages
12.03Direct Query Options and Real-time (LIVE) Data Access
12.04Drag Fields and Filters with Visualizations
12.05Visualization Filters, Page Filters, Report Filters
12.06Conditional Filters and Clearing Testing Sets
12.07Creating Customized Tables With Power BI
12.08General Properties: Sizing, Dimensions, and Positions
12.09Alternate Text and Tiles (Header, Column, Row) Properties
12.10Grid Properties (Vertical, Horizontal) and Styles
12.11Table Styles: Alternate Row Colors - Static, Dynamic
12.12Sparse, Flashy Rows, Condensed Table Reports: Focus Mode
12.13Totals Computations, Background, Borders Properties
12.14Column Headers, Column Formatting, Value Properties
12.15Conditional Formatting Options: Color Scale
12.16Page Level Filters and Report Level Filters
12.17Visual-Level Filters and Format Options
12.18Report Fields, Formats, and Analytics
12.19Page-Level Filters and Column Formatting, Filters
12.20Background Properties, Borders, and Lock Aspect
12.21Chart report types and properties
12.22Stacked bar chart, stacked column chart
12.23Clustered bar chart, clustered column chart
12.24100% stacked bar chart, 100% stacked column chart
12.25Line charts, area charts, stacked area charts
12.26Line and stacked row charts
12.27Line and stacked column charts
12.28Waterfall chart, scatter chart, pie chart
12.29Field Properties: Axis, legend, value, tooltip
12.30Field Properties: Color saturation, filter types
12.31Formats: Legend, axis, data labels, plot area
12.32Data Labels: Visibility, color, and display units
12.33Data Labels: Precision, position, text options
12.34Analytics: Constant line, position, labels
12.35Working with waterfall charts and default values
12.36Modifying legends and visual filters - options
12.37Map Reports: Working with map reports
12.38Hierarchies: Grouping multiple report fields
12.39Hierarchy levels and usages in visualization
12.40Preordered attribute collection - advantages
12.41Using field hierarchies with chart reports
12.42Advanced query mode connection settings options
12.43Direct import and in-memory loads, advantages
12.44Hierarchies and Drilldown Options
12.45Hierarchy Levels and Drill Modes - Usage
12.46Drill thru Options with Tree Map and Pie Chart
12.47Higher Levels and Next Level Navigation Options
12.48Aggregates with Bottom/Up Navigations
12.49Multi Field Aggregations and Hierarchies in Power BI
12.50DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
12.51SEE DATA and SEE RECORDS Options Differences
12.52Toggle Options with Tabular Data, Filters
12.53Drilldown Buttons and Mouse Hover Options @ Visuals
12.54Dependant Aggregations, Independent Aggregations
12.55Automated Records Selection with Tabular Data
12.56Report Parameters: Creation and Data Type
12.57Available Values and Default Values, Member Values
12.58Parameters for Column Data and Table Query Filters
12.59Parameters Creation - Query Mode Option
12.60Linking Parameters to Query Columns - Options
12.61Edit Query Options and Parameter Manage Entries
12.62Connection Parameters and Dynamic Data Sources
12.63Synonyms - Creation and Usage Options

13Chapter-13 Power Query and M Language

13.01Understanding Power Query Editor - Options
13.02Power BI Interface and Query/Dataset
13.03Working with Empty Tables and Load/IIRS Edits
13.04Empty Table Names and Header Row Promotions
13.05Undo Headers Options, Blank Columns Detection
13.06Data Imports and Query Marking in Query Editor
13.07JSON Files & Binary Formats with Power Query
13.08JavaScript Object Notation - Usage with M Language
13.09Applied Steps and Usage Options, Revert Options
13.10Creating Query Groups and Query References: Usage
13.11Query Rename, Load Enable, and Data Refresh Options
13.12Combine Queries - Merge Join and Anti Join Options
13.13Combine Queries - Union and Union All as New Dataset
13.14M Language - Nested Join and Joinkind Functions
13.15REPLACE, REMOVE ROWS, REMOVE COL BLANK M Language
13.16Column Splits and Filled Up / Filled Down Options
13.17Query Hide and Change Type Options, Code Generation
13.18Invoke Function and Freezing Columns
13.19Creating Reference Tables and Queries
13.20Detection and Removal of Query Datasets
13.21Custom Columns within Power Query
13.22Power Query Expressions and Usage
13.23Blank Queries and Enumeration Value Generation
13.24M Language Semantics and Syntax, Transform Types
13.25IF ELSE Conditions, Transform Column() Types
13.26RemoveColumns(), SplitColumns(), ReplaceValue()
13.27Table Distinct Options and GROUP BY Options
13.28Table Group(), Table Sort() with Type Conversions
13.29PIVOT Operation and Table Pivot(), List Functions
13.30Using Parameters with M Language (Power Query Editor)
13.31Advanced Query Editor and Parameter Scripts
13.32List Generation and Table Conversion Options
13.33Aggregations using Power Query & Usage in Reports
13.34Report Generation using Web Pages & HTML Tables
13.35Reports from Page Collection with Power Query
13.36Aggregate and Evaluate Options with M Language
13.37Creating High-Density Reports, ArcGIS Maps, ESRI Files
13.38Generating QR Codes for Reports
13.39Table Bars and Drill Thru Filters

14Chapter-14 Dax

14.01Purpose of Data Analysis Expressions (DAX)
14.02Scope of Usage with DAX, Usability Options
14.03DAX Context: Row Context and Filter Context
14.04DAX Entities: Calculated Columns and Measures
14.05DAX Data Types: Numeric, Boolean, Variant, Currency
14.06Date Time Data Type with DAX, Comparison with Excel
14.07DAX Operators & Symbols: Usage, Operator Priority
14.08Parenthesis, Comparison, Arithmetic
14.09DAX Functions and Types: Table Valued Functions
14.10Filter, Aggregation, and Time Intelligence Functions
14.11Information Functions, Logical, Parent-Child Functions
14.12Statistical and Text Functions: Formulas and Queries
14.13Syntax Requirements with DAX, Differences with Excel
14.14Naming Conventions and DAX Format Representation
14.15Working with Special Characters in Table Names
14.16YTD, QTD, MTD Calculations with DAX
14.17DAX Calculations and Measures
14.18Using TOPN, RANKX, RANK EQ
14.19Computations using STDEV & VAR
14.20SAMPLE Function, COUNTALL, ISERROR
14.21ISTEXT, DATEFORMAT, TIMEFORMAT
14.22Time Intelligence Functions with DAX
14.23Data Analysis Expressions and Functions
14.24DAX: DATESYTD, DATESQTD, DATESMTD
14.25ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
14.26FIRSTDATE, LASTDATE, DATESBETWEEN
14.27CLOSINGBALANCEYEAR, CLOSINGBALANCEQTR
14.28SAMEPERIOD and PREVIOUSMONTH, QUARTER
14.29KRIS with DAX, Vertipaq Queries in DAX
14.30IF ELSE Conditions with DAX
14.31Slicing and Dicing Options with Columns/Measures
14.32DAX for Query Extraction, Data Mashup Operations
14.33Calculated Columns and Calculated Measures with DAX

15Chapter-15 PowerBi Deployment & Cloud

15.01Power BI Report Validation and Publish
15.02Understanding Power BI Cloud Architecture
15.03Power BI Cloud Account and Workspace
15.04Reports and Dataset Items Validation
15.05Dashboards and Pins - Real-time Usage
15.06Dynamic Data Sources and Encryptions
15.07Personal and Organizational Content Packs
15.08Gateways, Subscriptions, Mobile Reports
15.09Data Refresh with Power BI Architecture
15.10PBIX and PBI Files with Power BI - Usage
15.11Visual Data Imports and Visual Slicers
15.12Cloud and On-Premise Data Sources
15.13How Power BI Supports Data Model?
15.14Relation between Dashboards to Reports
15.15Relation between Datasets to Reports
15.16Relation between Datasets to Dashboards
15.17Page to Report Mapping Options
15.18Publish Options and Data Import Options
15.19Need for Pins @ Visuals and Pins @ Report
15.20Need for Data Streams and Cloud
15.21Report Publish Options and Verifications
15.22Working with Power BI Cloud Interface & Options
15.23Navigation Paths with "My Workspace" Screen
15.24BILE View, Edit Reports, Access, Drilldown
15.25Saving Reports into PDF, PPTX, etc. Report Embed
15.26Report Rendering and Edit, Save, Print Options
15.27Report Pin and Individual Visual Pin Options
15.28Create and Use Dashboards, Menu Options
15.29Goto Dashboard and Goto Live Page Options
15.30Operations on Pinned Reports and Value
15.31Title, Media, Usage Metrics & Favorites
15.32Subscription Option and Reports with Mobile View
15.33Options with Report Page Print and Subscribe
15.34Report Actions: Usage Metrics, Analyze in Excel
15.35Report Actions: Related Items, Rename, Delete
15.36Dashboard Actions: Metrics, Related Items
15.37Dashboard Actions: Settings for Q&A, Delete
15.38Pin Actions: Metrics, Share, Related Items
15.39Pin Actions: Settings for Q&A, Delete
15.40Edit Dashboard (Cloud): On The Fly Reports
15.41Dataset Actions: Create Report, Refresh
15.42Scheduled Refresh & Related Items
15.43Dashboard Integration with Apps in Power BI
15.44Publish Power BI Report Templates
15.45Import and Export Options with Power BI
15.46Dataset Navigations and Report Navigations
15.47Quick Navigation Options with "My Workspace"
15.48Dashboards, Workbooks, Reports, Datasets
15.49Working with My Workspace Group
15.50Installing the Power BI Personal Gateway
15.51Automatic Refresh - Possible Issues
15.52Adding Images in the Dashboard
15.53Reading & Editing Power BI Views
15.54Power BI Templates (pbit) - Creation, Usage
15.55Managing Report in Power BI Services
15.56Power BI Gateway - Download and Installation
15.57Personal and Enterprise Gateway Features
15.58Power BI Settings Dataset Gateway Integration
15.59Configuring Dataset for Manual Refresh of Data
15.60Configuring Automatic Refresh and Schedules
15.61Workbooks and Alerts with Power BI
15.62Dataset Actions and Refresh Settings with Gateway

16Chapter-16 Insights And Subscriptions

16.01Data Navigation Paths and Data Splits
16.02Getting data from existing systems
16.03Data Refresh and LIVE Connections
16.04pbit and pbix: differences, Usage Options
16.05Quick insights for Power BI Reports
16.06Quick insights for Power BI Dashboards
16.07Generating insights with Cloud Datasets
16.08Generating Reports with Cloud Datasets
16.09Using relational databases on-premises
16.10Using relational databases in the cloud
16.11Consuming a service content pack
16.12Creating a custom data set from a service
16.13Creating a content pack for your organization
16.14Consuming an organizational content pack
16.15Updating an organizational content pack
16.16Adding Tiles: Images, Videos, Data Streams
16.17Creating New Reports from Cortana, Advantages

No FAQ added yet.

Data Analysist Training Course (R,Tableau & Power BI)

Our Core Highlights

Course Description

Course Goals

Future Scope of this Course

Our Career Service

Our Training Program Benefits

Related Courses in Data Science And Analytics Training Course

DevLustro Certified Data Analyst – Training Course

DevLustro Certified Data Analyst – Training Course

Python for Data Scientist Training Course – Machine Learning

Data Analysist Training Course (R,Tableau & Power BI)

Enroll in Data Analysist Training Course (R,Tableau & Power BI)