Data warehousing and Business Intelligence

Expert Talk by Mr. Anshul Mohan 8 April, 2015 10:30 AM E2 Seminar Hall, Amity University
DBMS Club and Amity ACM Student Chapter of Department of Computer Science & Engineering, Amity School of Engineering & Technology organized a Guest Lecture by Mr. Anshul Mohan on 8th April 2015.

With over 16+ years of comprehensive and in-depth experience in the Information Technology with specialization and experience in Data Warehousing and Business Intelligence, Mr Anshul presently serves Genpact as its Assistant Vice President, Business Intelligence where he is responsible for end to end of BI Business Growth and Delivery. Prior to joining Genpact. Mr Anshul worked with Mahindra Satyam for more than 10 years as their senior BI Leader. He has extensive experience in implementing technology initiatives that have generated million dollar impacts, reduce costs and increase revenue for customers. He has led 300+ associates in a BI practice with a revenue base of over 20 million. As a BI Practice Leader, he has experience handling responsibilities like Strategy, Operations, Pre-sales, Delivery Management, Mining and Farming.


Dr. Abhay Bansal, Director, DICET and HoD, CSE, ASET, Amity University, Noida, inaugurated the event by presenting a bouquet of flowers to welcome Mr Anshul Mohan. The event was also graced by the presence of the faculty members of department of Computer Science, ASET. Mr Anshul Mohan delivered an informative lecture on Data warehousing and Business Intelligence. He talked about what data warehouses were, the various different types of warehouses, the key factors of data warehousing. The most important factors of warehousing are planning and strategy. Another key aspect that needs to be kept in mind while doing date warehousing is execution. He spoke about the ingredients of data warehousing and business intelligence which are strategy, scalability and the fact that it should not be a data dump. He then spoke about independent data marts, the challenges faced in data warehousing and business intelligence and the different roles and responsibilities. He explained what the FACT table is and where it comes into use and the data warehouse design. The 4 types of reporting- diagnostic reporting, description reporting, predictive and perspective and the role which mobile phones play in Business Intelligence was discussed. He then talked about emerging trends in cloud business Intelligence and what a vital role cloud plays in the world of computer science presently. The Gartner Magic Quadrant on BI tools was also explained by Mr Anshul.