Business Analytics — Winter 2023

KDD (Knowledge Discovery in Databases) is a process that involves the extraction of useful, previously unknown, and potentially valuable information from large datasets. Discuss this process with reference to any one industry of your choice.

Data dashboards are a summary of different, but related data sets, presented in a way that makes the related information easier to understand. Considering yourself as the HR manager of any reputed organization, you are required to design a Dashboard for Employee Payroll. Discuss each component of dashboard with appropriate justification.

The Star Schema data model is the simplest type of Data Warehouse schema. Considering yourself as the operation manager of any reputed manufacturing firm, design the structure with appropriate details.

The future of business data analytics is very bright, with several trends and predictions set to shape the industry. Discuss the descriptive, predictive and prescriptive analytics in brief.

Discuss the importance of OLTP and OLAP with respect to banking industry in brief.

Discuss the characteristics of Semi-Structured Data and differentiate with unstructured data

What do you mean by Data visualization? Discuss any three specialized charts with appropriate example of each.

“Business Performance Management (BPM) is a real-time system that alerts managers to potential opportunities” Discuss the statement in the light of key components of BPM.

What is Text mining? Discuss text mining for the industry of your choice with appropriate example. Page 1 of

Differentiate Star Schema Vs Snowflake Schema in detail.

Discuss the challenges of Natural Language Processing (NLP) in brief.

Siemens is a German company headquartered in Berlin, Germany. It is one of the world’s largest companies focusing on the areas of electrification, automation, and digitalization. It has an annual revenue of 76 billion euros. The visual analytics group of Siemens is tasked with end-to-end reporting solutions and consulting for all of Siemens internal BI needs. This group was facing the challenge of providing reporting solutions to the entire Siemens organization across different departments while maintaining a balance between governance and self- service capabilities. Siemens needed a platform that could analyse their multiple cases of customer satisfaction surveys, logistic processes, and financial reporting. This platform should be easy to use for their employees so that they can use this data for analysis and decision making. In addition, the platform should be easily integrated with existing Siemens systems and give employees a seamless user experience. They started using Dundas BI, a leading global provider of BI and data visualization solutions. It allowed Siemens to create highly interactive dashboards that enabled Siemens to detect issues early and thus save a significant amount of money. The dashboards developed by Dundas BI helped Siemens global logistics organization answer questions like how different supply rates at different locations affect the operation, thus helping them to reduce cycle time by 12% and scrap cost by 25%.

What challenges were faced by Siemens visual analytics group?

Describe the future perspective of Data visualization in mobile service industry.

Describe the future perspective of Data visualization in sports industry.