Sem: Dec-2024 Maximum Marks: 50 Examination: End Exam Date: 8th Dec 2024 Duration: 2.5hrs
Programme code: 18 Programme: MBA for Working Executive	Class: FY	Semester: III Batch- 2023-24
College: K. J. Somaiya Institute of Management	Name of the department/Section/Center:
Course Code:	Name of the Course: Interactive Dashboards and Data Storytelling
Instructions: Read the case carefully Make suitable assumptions Refer to Salaries datasets Submit Dashboard with key objectives in the Text Box on the Dashboard

Question No.	Max. Marks
CASE Title: Optimizing Workforce Allocation and Salary Structures for a Data-Driven Organization A multinational technology company, DataVista Corp, is undergoing rapid expansion and needs to align its workforce strategy with market trends to attract and retain top talent. The company employs professionals in various roles like data scientists, analysts, and engineers across multiple countries and offers flexible work arrangements (on-site, hybrid, remote). However, they face challenges in optimizing salary structures, understanding regional differences, and aligning their workforce policies with market realities. Despite a competitive hiring strategy, DataVista Corp faces: High Attrition Rates: Talented employees are leaving due to salary dissatisfaction and lack of flexible work options. Budget Allocation Issues: Inefficient salary spending due to under-compensating top regions and overcompensating low-performance areas.
Q1	Create visualizations for the following questions and interpret the results. (any 5) How do average salaries (in USD) change by year? How does salary vary with experience levels (Entry, Mid, Senior, Executive)? Is there a correlation between remote work percentage and salary in USD? What are the most common job titles in the dataset? What are the top 10 countries with the highest average salaries? How are salaries distributed across different employment types (e.g., full-time, contract)? How do salaries differ by company size (Small, Medium, Large)?	30M
Q2	Write four problem statements based on your understanding of the data and create visualizations for the same. Interpret the outputs.	20 M