Business Analytics — Summer 2018

Discuss two queries that OLTP cannot answer.

What can BI deliver.

State a scenario where there is a requirement for an OLAP system.

Give an example of data being collected and stored in an unstructured format in your college/university.

What can you say about data in an email ? Give reasons in support of your answer.

What is Data Governance.

State an instance from your daily life where an OLTP system is being used.

Why Big Data is important and who uses big data ?

Why Data Science to be considered as “Discovery of Data Insight ” . Give examples in support of your answer.

Discuss the characteristics of unstructured data ?

Discuss the challenges in Data Driven Decision Making and it’s future.

What is Machine Learning ? Discuss Machine Learning Algorithms.

How to extract information from semi structured data ?

What is semi-structured data ? List three sources of semi-structured data.

List seven examples using descriptive analytics.

Discuss the challenges faced while extracting information from unstructured data ?

Discuss the role of Analytics in Retail Industry.

Discuss the need for Analytics in the Telecom Industry. Page 1 of

CASE STUDY: IN XYZ Retail Store – A Case Study Enhancing the “Quality of Customer Experience” The year 2000 saw the birth of retail store operated only in India. 2010 awarded the honor of “Best Managed MSME” Foohold in China, stores owned cross the 50 mark. Next two years acquiring another 50 stores. In 2017 the group bag the award for the “Best Employer”. Business Segments Initially stocked only grocery items Gradually started piling garments of every age groups, electronic gizmos,cosmetics etc. Set up fresh vegetables, fresh juice corners and fast food joints. Leverages IT , list of premium customers accord special discounts to them. Constantly follow- “Hear Me – Voice of Customer” service. Marketing Advertisements in newspaper, magazine, television, hoardings at prominent locations. Announce promotional scheme. Endorsed by top cine stars and sportperson. Understand “word of mouth” publicity. Supplier Management Strong network of trustworthy and highly reliable supplier partners. Transparent system of communication with all suppliers. Believe in win-win strategy for all. Focus on core business process and outsource others. Quality Management Clear guidelines on how to stock the various products -market basket. Separate sections such as Dairy Product, Electronic Goods, Home Appliances etc. Hire external agencies to garner customer feedback and employee satisfaction feedback. Future Outlook Currently 7,000 employees and looking to growing to 15,000 in the next five years. Studying customer’s buying behavior, customer segment to target, when to announce discounts , Aware of social responsibilities. Practice of using recycled paper bags, conserve energy/power, reducing the use of polythene/plastic bags. “Money/Travellers cheques Exchange” Creating brand ambassadors in the digital space too. Information Technology Excellent web presence: leveranging website, social networking and mobile device. Leverages internet for surveys, targeted mailers , personalized invites , loyalty program management. Self-help portal for online purchases. Front Office Management Customer relationship management PoS , Billing , Charging , Promotion points redemption Customer Help Desk Page 2 of

“Hear Me- Voice of Customer” service. Elaborate how it has been able to do it.