| Relevance in industry & need of the hour |
| Types of analytics – Marketing, Risk, Operations, etc |
| Business & Technology drivers for analytics |
| Future of analytics & critical requirement |
| Types of problems and business objectives in various industries |
| Different phases of Analytics Project |
| Introduction to Excel |
| Working with Formulas and functions |
| Formating & Conditional Formating |
| Filtering, sorting, paste special etc |
| Functions (Logical & Text, Mathematical, Statistical etc) |
| Data Manipulation & Data Aggregation |
| Data Analysis using functions |
| Analyzing Data using Pivots |
| Descriptive Statistics |
| Creating Charts & Graphics |
| Data analytics tool (What -if analysis, Goal seek, Data Table, Solver) |
| Protecting Workbooks, worksheets and formulas |
| Working with VBE (Visual Basic Editor) |
| Introduction to Excel Object Model |
| Understanding of Sub and Function Procedures |
| Key Component of Programming Language |
| Understanding of If, Select Case, With End With Statements |
| Looping with VBA |
| User Defined Function |
| Some Commonly Used Macro Examples |
| Error Handling |
| Object and Memory Management in VBA |
| User Form Controls |
| ActiveX Controls |
| Communicating with Database MS Access through ADO - Exporting /Importing Data |
Learn from our comprehensive collection of project case-studies, hand-picked by industry experts, to give you an in-depth understanding of how data science moves industries like telecom, transportation, e-commerce & more.
|
| You will be having the opportunity of 10-15 Hrs e-learning exercises along with instructor-led-training which enable candidates to get the maximum out of the subjects and empowering them to build logics to hand any new requirement. |
This program has been designed in collaboration with some of the most influential analytics leader and top academician in data science.
|
Thanks to the digital revolution that is sweeping the world and India in particular, data scientists are now the most sought-after professionals by big corporations as well as startups. And companies across industries are rewarding good data analysts and scientists with desirable career growth and salaries.
|
