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
Module I – Data Visualization with Tableau (20 hrs)
- 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
Module II – Advanced Analysis & Reporting on Excel using VBA, Macros (42 hrs)
- 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
Module III – SQL based Relational Database Concepts using MS-Access (18 hrs)
- 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 I – 20 hours
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
Enquire / Enroll for the course
Launch Your Global Analytics Career with IVY
Why Analytics?
As organisations and SMEs become increasingly data-driven, there arises the need to make sense of all that data and convert it into meaningful insights. In a competitive environment, analytics becomes the driving force that facilitates decision making – to leverage the insight for innovative strategies as well as for an effective ROI on investment.