![\"\"](\"https:\/\/www.isbr.in\/blogs\/wp-content\/uploads\/2021\/02\/aaa-300x187.png\")
<\/p>\n<\/p>\n
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.
\nBrief 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.
\nThe 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.
\nOn 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.
\nOn 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 \u2013 material shared along with the other material was taught to the students.
\nFrom 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
A two-day workshop was organized for the students of PGDM and MBA batch 2018-20, by the Department of Business Analytics<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,7,4,26],"tags":[102,103],"class_list":["post-2684","post","type-post","status-publish","format-standard","hentry","category-business-school","category-career","category-career-advice","category-isbr","tag-advanced-excel","tag-iim-calcutta"],"yoast_head":"\n