UrbanPro
true

Tableau Training

LIVE
24 Hours

Course offered by Vimal Gupta

3 reviews

GETTING STARTED WITH TABLEAU

  • What is Tableau
  • Architecture of Tableau
  • Introduction of Data Source and Connecting to Data
  • Understanding of Tableau Interface
  • Dimensions and Measures in Tableau
  • Data Types in Tableau
  • Tour of Shelves & Marks Card
  • Building Basic Views

 

BUILDING VIEWS OR REPORTS IN TABLEAU

  • Understanding and Creating Cross tab & Tabular charts
  • Creating Bar Charts and Stacked Bars
  • Understanding and Creating Scatter Plots
  • Creating Line Graphs with Date & Without Date
  • Individual Axis, Dual Axis and Combination Chart
  • Trend Lines, Reference Lines and Forecasting
  • Filters and Context Filters
  • Understanding Sets (In/Out Sets, Combined Sets)
  • Creating Bins/Histograms

 

CALCULATED FIELDS AND TABLE CALCULATIONS

  • Working with Disaggregate data and Aggregate data
  • Basic Functions like String, Date and Numbers etc.
  • Working with Logical Conditions
  • Scope and Directions in Table Calculation
  • Calculation of Percent of Total (Running and Cumulative Calculations)

 

ADVANCED DASHBOARDS and DATA ANALYSIS IN TABLEAU

  • Create What-if-Analysis
  • Dynamic Dimension and Measure Selection (Display Options)
  • Usage of Parameters in Calculated Fields, Reference Lines and Filters
  • Combining Multiple Reports\Visualizations to Create Dashboard
  • Customizing Dashboards
  • Interactive Reports by using Actions for Filters, URL, Highlight etc.

About the Trainer

V.K. picture

5 Avg Rating

3 Reviews

5 Students

3 Courses

Vimal Gupta

M.Sc (IT)

4 Years of Experience

11 Years of Experience in MS Excel, Advance Excel, VBA, Macro and Automations.

Excel and Advanced Excel Section :

Over view of Pivot table
Various Methods and Options of Pivot Table
Inserting calculated field in Pivot table and working with slicer
Pivot Charts (Creation of Chart, Altering of Chart, Filtering A Pivot Chart)
Creating and updating subtotals - Subtotal Analysis
Data Sorting and Filter techniques
Advance Filter and Unique Filter
Various Methods of Text to Column options
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Uses of Goal Seek and Scenarios Manager and Table - Data Analysis
Data Consolidation Techniques and linking of sheets and excel files
Data Analysis techniques using more than one features of MS Excel
Creating, Formatting and Modifying Chart
Creating Dynamic charts and Dashboards (including one project of KPI Dashboard)
Uses of Advance Excel Formulas
VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, OR, AND, SEARCH, INDEX, MATCH,
REPT etc.
Conditional Formatting (including one project on live procurement and sales data)
Project Tracking and Project Management in Excel
Basic concept of Macro
Creating Sorting and Running your first Macro
View and Edit Macro Code
Tips and Magic Tricks of Advance Excel with Advance Shortcut Keys

VBA Section :

Writing and Editing Macro
Writing Functions and Procedures and Subroutines using VBA in Excel
Working with Objects (Application, Workbook, Worksheet, Range and Cell)
Writing VBA Program for ActiveCell, ThisWorkbook & ActiveWorkbook
Writing VBA Program for Inserting Row, Column and finding next available blank row etc.
Writing VBA Program for Importing and Exporting Data from One Sheet to Another Sheet
Using Excel Functions via VBA Code
Event Programming
Forms and Active X Controls
Creating User Form and Interacting Excel Sheet
Loops and Logic
Handling Errors in VBA programs and Macros
Object-Oriented Programming
Creating Programs to interact with Users
One Project for Excel and VBA programming

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Tableau Training by Vimal Gupta

V.K. picture
LIVE

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Tableau Training by Vimal Gupta

V.K. picture
LIVE

Class
starts in

00

Days

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more