SIDI31377: Business Intelligence- Tableau Doctors- Data Visualization- Business Assignment Help

Internal Code: 2IBJ

Business Assignment Help:

Task: PART I 1. Create the connections to the Excel files (extracts are not needed – use live connections). Modify the dimensions and measures as needed, and create the hierarchies. (For Region, choose the geographic role “State/Province”). 2. Create the visualizations answering the following questions (name your sheets and dashboard explicitly using the number of the question, e.g. Q2.1, Q2.2, ...): 2.1. Create a text table showing by department, for year 2014, the total number of doctors and the total number of doctors by inhabitant. The table should be ordered by decreasing order of number of doctors by inhabitant. (Hint: Create a calculated field for the number of doctors by inhabitant). 2.2. Create a text table showing, for year 2014, the total number of doctors by specialty and by department, for the five least populated departments. All the cells of the cross-tab such that the number of doctors is zero, should be highlighted in red. 2.3. Create a bar chart illustrating, over a two-year period (2013 and 2014), the total number of activities by age sub-category (make sure that the age sub-categories are sorted properly). Complete this bar chart with a reference line with an explicit meaning. 2.4. Create a scatter plot showing, for a year that the user may choose interactively, the total number of doctors and the total number of activities for each specialty. 2.5. Create a dashboard with a map showing the total number of doctors by region, for a year chosen by the user. This map will be synchronized with a bar chart detailing the number of doctors by specialty and a pie chart detailing the number of doctors by gender, for the current region. PART II Tell your story of the situation of doctors in France, as if you were a journalist. Let the data speak! Build nice and convincing data visualizations, to share your findings. To do this, use Tableau stories, built upon sheets and dashboards. Apply the data visualization principles and guidelines seen in class. You may reuse some of the sheets and the dashboard from Part I, but you do not have too, and of course, you should add new sheets and dashboards. If you reuse some of the sheets or the dashboard form Part I (improving their aesthetics), do not modify them directly, but make a copy of them and modify the copy. Make the names of your sheets, dashboards and story explicit.