NMIMS BBA – B.Com Data Visualization with Tableau Solved Answer Assignment
11
Oct
2024
Data Visualization with Tableau
Question 1: Consider you are working as a business analyst with Elizabeth Hospitals, a UK-based hospital chain across different cities in the United Kingdom. You have been tasked with building presentations for executive management using critical business data. Explain the different geographic charts you can make across various departments. Mention how charts add value to the business. (You can use the output of Tableau tool to explain the kind of graphs)
Introduction
As a business analyst at Elizabeth Hospitals, one of the many things you can do to illustrate essential business data is to build various geographic charts that some different departments can utilize. You have numerous options available, and this is only one of them. These charts can provide important information on geographical patterns, trends, and opportunities that may be used to improve an organization’s performance.
Concept and Application
A choropleth map is a type of chart that illustrates the different data values of regions by coloring or shading the areas that are in dispute. This method is advantageous because it allows for the presentation of data that may be categorized by geographic location. For example, hospital admissions, bed occupancy rates, and patient demographics might all be displayed using this method. The demographics of patients and their admissions to hospitals are two examples of the types of information that fall under this data category.
Conclusion
The business analysts at Elizabeth Hospitals have access to these geographic charts, enabling them to detect regional patterns and trends across various departments swiftly. In turn, this may assist executives in making decisions on allocating resources, strategic planning, and efforts to enhance more informed performance.
Question 2: The learning department of an IT organization collected data on the registration of courses such as “Mindfulness”, “Growth Mindset”, “Team Building”, “Unconscious Bias”, “Smart Dressing”, “Email Etiquettes”, “Cross Cultural Sensitivity”, etc. They have data for the year 2019 and 2020. They would like to analyze the percentage of registration (increase/decrease) for the mentioned courses. This will help them to better plan the number of offerings for each course. The data on the courses and the percentage difference is given below. Use an appropriate graph to display the data. When it is appropriate to use a scatter plot and density maps? (Use Tableau to present the graph)
Introduction
The number of people searching for “Email Etiquette” and “Cross-Cultural Sensitivity” has shown a minor increase in one direction and a minimal decrease in the other. According to this number, it is clear that there has been a rise in the number of persons signing up for classes with the titles “Mindfulness” and “Growth Mindset.”
Concept and Application
We need to use a density map to accurately portray the distribution of registration throughout many diverse places or locations, such as the distribution of course registration across the numerous divisions that comprise the corporation. For instance, we could show how the number of course registrations is distributed among the different divisions that include the organization.
Conclusion
In conclusion, while evaluating the data for the learning department of the IT business, one has access to a wide variety of visual representations from which to choose the option(s) that best suit one’s needs and preferences. Each method for representing data can deliver one-of-a-kind insights and meet a broad range of requirements in many contexts.
Q 3. A. Differentiate between measures and Dimensions. A popular management institute in Mumbai wants to use Tableau as its tool for data visualization project. Discuss in detail atleast 5 measures and 5 dimensions that are critical for the college. (5 Marks)
Ans:
Introduction:
Both dimensions and measurements are considered to be fundamental ideas in the field of data visualization. The categorical variables that contribute to data organization and offer a context for analysis are called dimensions. On the other hand, measures are numerical variables that may be summed up and statistically examined.
Concept & Application:
Measures:
Enrollment: Enrollment is one of the most critical metrics for a management institute since it indicates the total number of students enrolled in its various programs. It helps determine which classes are in high demand and which types have room for development in terms of their content and methods of instruction.
Placement rate: The placement rate is another critical metric for a management institute to consider, as it represents the employability of program graduates once they have finished their education. A high placement rate is a good indicator of the quality of education offered at an institution, and it also contributes to the institution’s ability to recruit new students and enhance its reputation.
Conclusion:
In conclusion, measures and dimensions are crucial concepts in data visualization, and they play a critical part in delivering insights into a management institute’s performance. This is because measures and dimensions may be divided into more granular levels.
Question 3. B:Assume you are working as a financial analyst with the Federal Bank of Australia and you need to present the important business data to senior management. Elaborate the best practice followed when using a Tree map and a Heat map to represent the data.
Introduction
When attempting to illustrate financial data to senior management with a Treemap and a Heat map, some best practices should be followed to guarantee that the information is effectively communicated and comprehended. This is done to ensure that the knowledge is disseminated and learned efficiently.
Concept and Application
Before anything else, it is necessary to ensure that the information conveyed is pertinent and essential to the audience. When discussing finances, this could reference critical performance criteria like the number of sales, the percentage of profits earned, and the total costs. If the audience focuses on the most important metrics, not only will they be able to comprehend the state of the bank’s finances quickly, but they will also be able to recognize the areas that require further attention and take appropriate action.
Conclusion
Financial analysts may guarantee that the data is appropriately presented and grasped by adhering to these best practices, which results in better-informed decision-making and higher financial performance for the bank.
Dr. Aravind Banakar prepares two types of Assignments. General assignments & Customized assignments. Both assignments are 100 % Plagiarism-free.
Dr. Aravind Banakar is the number 1 NMIMS Academic Writing Professional. He is a highly experienced academic professional and a reputable and reliable academic content writer with over 24 years of experience. You can obtain ready-made, customized, plagiarism-free MBA, BBA, EMBA, and B.Com assignments.
Important Notice for NMIMS Assignments:
To ensure your NMIMS assignments meet the university’s standards, The NMIMS Assignments must be 100% customized, plagiarism-free, and unique.
Copying from Google, AI tools, blogs, books, or any other sources is strictly prohibited, and if you copy answers, you will get ZERO marks.
Before purchasing assignments from any academic writer, always demand the following verification:
Remember, these reports are not just a formality. They are your shield against ZERO marks. Take charge of your grades by ensuring your work is original and meets NMIMS standards.
Dr. Banakar leads a team of over 100 PhD-qualified professionals dedicated to creating high-quality, plagiarism-free assignments tailored to meet the exact standards and requirements of NMIMS. With a proven track record, students who have used his services often score 25+ marks out of 30, highlighting the level of detail, precision, and thorough research into every assignment. This emphasis on research instills confidence in the quality of the work.
