Tableau Training

No Reviews Yet

Indirapuram, Ghaziabad

Course ID: 36816

Indirapuram, Ghaziabad

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

V.K. picture
V.K.

M.Sc (IT)

9 Years of Experience

About V.K.

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
No reviews currently Be the First to Review

About the Course

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.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Tableau Training Post your requirement now

Enquire

Submit your enquiry for Tableau Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vimal

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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