IVY Pro School is a Top Ranked Data Science and Analytics schools in the country consistently since the last 5 years (Analytics India magazine, Silicon India Magazine). We are the official training partners of companies like Honeywell, Cap Gemini, Genpact, HSBC, Cognizant, eBay/Paypal etc and more than 100 Analytics companies have recruited our students. Our prized faculty are associated with esteemed organizations like ISI, IIMs IITs and prestigious US universities.
Course Outline
- Introduction to Data Visualization with Tableau
- What is Data Visualization?
- Use of Tableau
- The Visualization Design
- Exporting Data
- Connecting Sheets
- Making Basic Charts like Line, Bar etc.
- Advance Charts and Graphs
- Highlight Tables, Heat Maps, Circle Plots, Side by Side Bars, Continues Lines, Scatter Plots, Dual Charts, Area Charts, Tree Maps
- Data Organization and Scripting
- Calculated Metrics, Sorting, Filtering, Totals and Sub Totals, Various Aggregated Measures, Percentages, Data Spotlighting, Summary Card.
- Date and time functions, String Functions and logical functions
- Data behind your views
- Hierarchies
- Sets
- Groups
- Bins
- Dashboards
- Building a Dashboard
- Layout and Formatting
- Interactivity with Actions
- Best Practices
- Geocoding and Mapping in Tableau
- Latitude and Longitude
- Filled Maps, Symbol Maps
- Geo Coding
- Online Maps
- Sorting in Maps
- Working with Data
- Difference Between Joining and Blending Data
- Working with Large Data Set
- Working with Custom SQL
- Toggle Between Direct Connection and Extracts
- Saving and Sharing the Work
- Integrating Tableau with R
- Industry Projects using Tableau
- Introduction to MS Excel, Basic Functions and Usage
- Sorting, Filtering, Advance Filtering, Subtotal
- Pivot Tables
- Goal Seek & Solver
- Different Charts Graphs – Which one to use and when
- Vlookup, Hlookup, Match, Index
- Style & Number Formatting, Conditional Formatting
- Worksheet & Workbook Reference
- Logical Operators & Functions – IF and Nested IF
- Data Validation
- Text Functions
- Relative & Absolute Macro Recording
- VBA Programming
- Making Macro do Automated Tasks for You
- Record a Macro
- Automate a Task using Macro
- Analysis Using VBA
- Objects
- VBA Collection Objects
- The Application Object
- Workbook and Window Objects
- The Range Objects
- Variable, Data Types, and Constants
- Types of Variables
- Promoting for User Input
- Arrays
- Interacting with Users
- VBA Sub, Event and Function Procedures
- Create Sub Procedures, Event Procedures and Function Procedures
- Ways to Execute these Procedures
- How to Execute Function Procedures
- Control Logic and Loops
- Conditional Logic
- Conditional Statements and the If/Then/Else and Select/Case Code Structures
- Looping
- Creating User Interface with Form Controls
- Dashboard with Excel and VBA
- Industry Projects using VBA
- Objects
- Making Macro do Automated Tasks for You
- Base and Advanced SAS 9 Concepts
- Steps to Design Efficient Relational Database Models
- Case Studies on Designing Database Models
- Case Study Implementation on Handling Data in MS-Access 2007
- Importing / Exporting Large Amount of Data into/from MS-Access
- Intro to SQL Statements
- Writing Transactional SQL Queries, Merging, joining, sorting, indexing, etc.
- Hands-on Exercises on Manipulating Data Using SQL Queries
- Creating Database Models Using SQL Statements
Course Duration
Module II – 42 hours
Module III – 18 hours
Course Fee
INR 17900 plus tax
Detailed course brochure.
Eligibility
Under-grad or Post-grad in Maths/ Stats/ Economics/ Commerce/Finance
MBA Students (All Streams)
3rd and Final Year B.E./ B.Tech
Banking/ Finance/ IT/ KPO Working Professional
Projects
Industry projects based on creating dashboards for various domains
- Marketing Retail, Healthcare, Finance, Education and Aviation Industry