We developed this course essentially for Students looking to pursue a business analytics career and Professionals who have mastered the skills of model building but now need to implement models with a easy to use front end.
Bangalore, India (PRWEB) October 08, 2014
Jigsaw Academy, the renowned online Analytics and Big Data Training Academy has recently launched a new Advanced Analytics Course. The course titled 'VBA For Reporting And Analytics' teaches how to use the VBA programming functionality of Excel effectively and how to build decision support systems. Participants will also learn how to get data into excel from various places & formats ( i.e. relational databases, flat files (csv, txt)) and how to create Excel Add-Ins and User defined functions.
Participants will get access to about 11 hours of pre-recorded video lectures. The videos can be viewed at any time and as many times as the participant wants for a period of 4 months.
Participants are also given access to Jigsaw Academy's virtual lab -- a unique cloud-based solution to providing the lab experience where they will be able to work on real life business datasets, for a period of 4 months.
“We developed this course essentially for Students looking to pursue a business analytics career and Professionals who have mastered the skills of model building but now need to implement models with an easy to use front end.” says Gaurav Vohra, CEO of Jigsaw Academy. “However this course is also relevant and useful for those working in modern day corporations, on data which resides in numerous places in various formats. This course will teach them to integrate this data, so that reports and models for data mining can be built.” he continues.
The VBA course is divided into five modules, namely:
1. Introduction to VBA
2. Functions and Addins
3. GUI Building
4. Programming in VBA
5. Data Manipulation using VBA
There will also be three case studies that explain how to build a regression tool, simulation in Excel and querying using Excel.
The pre-requisites for the course are Knowledge of Excel- Formulas, Charts, Pivots and Knowledge of data manipulation techniques. It is also recommended that participants have exposure to basic SQL language and programming concepts in any language like SAS, R and Java.
The VBA course is priced at Rs. 20,000 (Indian students) and $500 (Foreign students-Outside India). However as an introductory offer the course can now be purchased for Rs. 15,000 (Indian students) and $375 (Foreign students-Outside India).
For more information about the course and to register please visit the VBA Course Page
You can also experience Jigsaw's courses and get access to some complimentary Analytics and Big Data resources by visiting the Free Trial section of their website
Jigsaw Academy is a Bangalore based analytics training company that is run by analytics professionals. Their courses are designed and delivered by industry experts who have applied analytics to solve business problems in a variety of fields like retail, FMCG, financial services, telecom and health care. The instructors use their real-world experiences to teach analytical skills that are most valuable at the work place. Their flagship course called the Foundation course in analytics has been taken by thousands of students across the globe and has helped launch many careers in this new and exciting field. They have recently completed analytics training workshops in B schools across the country, including IIM Bangalore.