A two-day workshop was organized for the students of PGDM and MBA batch 2018-20, by the Department of Business Analytics and Department of Marketing.
Brief Profile of Speaker: Rishiraj Dasgupta possesses a Bachelor of Engineering from Jadavpur University, Kolkata, and a Post Graduate Diploma in Management from IIM Calcutta. He brings in close to 20 years of industry experience and exposure in Banking, Consulting, and Learning & Development. He had corporate stints with ICICI Bank (Corporate Banking, Risk) and KPMG Advisory Services as a Senior Risk Consultant.
The event started with the welcome by Prof. Sheetal Mahender, HoD, Department of Business Analytics, and introduction of the resource person by Dr. K.S.Lakshmi, HoD, and Department of Marketing. The first day was a warm-up session in which the resource person touched on the basics of analytics. Students were made to work out the problems/situations that were put to them using advanced EXCEL on their laptops.
On Saturday, the students were taught random number generation, descriptive statistics, discrete and continuous probability distribution, Chi-square test and goodness of fit, finding outliers, class boundaries, and Data visualization with the use of box plots.
On Sunday, Simulated predictive models using Monte Carlo Simulation: Russian roulette rule, predictive model using simulation for sales data, Trend analysis /demand forecasting using CAGR, time series and simulation bases, Inventory planning and stock out using chi-square analysis, Decision tree analysis, Stochastic models to predict the share prices in recent NIFTY shares data, and a brief introduction into conjoint analysis – material shared along with the other material was taught to the students.
From this workshop, the students learned the predictive models that are used in various functionalities, the use of EXCEL for various situations and scenario analysis, and coming to decisive conclusions by the use of a particular tool. They found it very informative and enriching their analytics base.