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.
Dashboarding and Automation Using Advanced Excel
Introduction to MS Excel, Cell Ref, Basic Functions and Usage
Sorting, Filtering, Advance Filtering, Subtotal
Pivot Tables and Slicers
Goal Seek and Solver
Different Charts Graphs – Which one to use and when
Vlookup, Hlookup, Match, Index
Conditional Formatting
Worksheet & Workbook Reference, Error Handling
Logical Operators & Functions – IF and Nested IF
Data Validation
Text Functions
Form Controls
Dashboard
6 Case Studies from App Cab Aggregators, Insurance, Sports, Sales, Marketing, Web Analytics Industry
SQL Queries & Relational Database Management
Relational Database Fundamentals
Steps to Design Efficient Relational Database Models
Case Studies on Designing Database Models
Case Study Implementation on Handling Data
Importing / Exporting Large Amount of Data into a database
In today’s rapidly evolving business landscape, organizations and SMEs are more data-driven than ever before. The need to extract valuable insights from vast amounts of data has become paramount. In this fiercely competitive era, analytics plays a pivotal role in guiding decision-making, enabling companies to harness insights for crafting innovative strategies and ensuring a robust return on investment (ROI). The job opportunities in the field of data analytics are also set to grow significantly in the next two years, with an expected increase of over 20% in data-related job openings, making it a promising career choice for many.
