d) A descriptive comment before each function/method Assignment Details: As an Information Technology professional, much of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
d) A descriptive comment before each function/method Assignment Details: As an Information Technology professional, much of your decisions are derived by Information Technology (IT). IT provides knowledge based on data that help business professionals to take better and more informed decisions. In this project, you are to utilize Python's Data Visualization packages to make a number of visualizations that will help to make some specific managerial decisions. The focus of this assignment is the creation of visualization dashboard using Python programming. It is important that your visualization dashboards show presentations nicely by adding the necessary elements (i.e., include title, annotations, sorting, coloring/highlighting, etc. as you see fit to best communicate your message). Task: Using the Customer Service Call dataset provided with this assignment, you are to design different plots and a dashboard using Python programming with the following specifications: Performance Analysis Dashboard a) Make a visualization graph (bar chart) showing total number of calls separated by incoming and outgoing call serviced (Call Type) by each sales representative (Rep ID). Save the graph as "plot1.jpg". b) Make a visualization graph (line chart) showing incoming and outgoing call volumes by time (Time Block). Save the graph as "plot2.jpg". c) Make a visualization histogram for time (Time Block) showing call frequency (both incoming and outgoing) by time. Save the graph as "plot3.jpg". d) Make a visualization graph (pie chart) showing percentage of calls for each call purpose (Call Purpose). Save the graph as "plot4.jpg". e) Create a dashboard with the above four image files and name dashboard as "Dashboard for Customer Service Calls Performance Analysis". Feel free to decorate the plots and dashboard using different fonts, colors, and other functionalities learnt previously in this course. Specific Details 1. callAnalysisByRep: this function should implement task (a) by performing mathematical computation to calculate number of incoming and outgoing calls handled by each representative. The computed data should be used to plot a bar chart showing number of incoming and outgoing calls by each customer service representative. Make sure to label both x- and y-axis properly and provide legend box to indicate color representation. Provide title for the plot and label each axis with respective values. This function should also save the file as "plotl.jpg". The bar chart may look similar to the following. Total Number of Calls by Representative Number of Cal Numer of Cal 2. callAnalysisByTime: this function should implement task (b) by performing mathematical computation to calculate number of incoming and outgoing calls by time. The computed data should be used to plot a line chart showing number of incoming and outgoing calls by each time block. Make sure to label both x- and y-axis properly and provide legend box to indicate color representation. Provide title for the plot and label each axis with respective values. This function should also save the file as "plot2.jpg". The line chart may look similar to the following. 2 8 6 Outgoing Calls 3 Total Number of Calls by Time Block Time Sk Incoming Calls Outgoing Cats 5:00 PM 3. timeHistogram: this function should implement task (c) to plot histogram for time block data. Make sure to label both x- and y-axis properly, provide title for the plot, and label each axis with respective values. This function should also save the file as "plot3.jpg". The histogram chart may look similar to the following. Histogram of Time Block 120- 100 4. callAnalysisBy Purpose: this function should implement task (d) by performing mathematical computation to calculate number of incoming and outgoing calls by call purpose. The computed data should be used to plot a pie chart showing the volume of calls (both incoming & outgoing) in percent for each type of purpose. Make sure to label each wedges of the pie chart properly and provide title for the plot This function should also save the file as "plot4.jpg". The pie chart may look similar to the following. Volume of Calls by Call Purpose Sales Support 35.42% Product Support 3.12% Complaint 5. createDashboard: using knowledge from Graphical User Interface (GUI) design concepts, this function should create an interface of size 1200 by 900 pixel. This function should then design a dashboard using all four images saved by previous functions. Make sure to nicely align the images on the dashboard. Feel free to resize the images to fit the dashboard window size. Provide a meaningful title for the dashboard. The dashboard may look similar to the following. Take a screenshot of your dashboard and include in your output file for Canvas submission. Dashboard for Customer Service Performance Analysis by Dr. Rahman Dashboard for Customer Service Performance Analysis by Dr. Rahman Total Number of Calls by Representativ Total Number of Calls by Time Block Grading Breakdown: Volume of Calls by Call Purpose 6. main: this function should be used to call all other functions. Submission Guidelines: Submit your code (.py file) and screenshot of four plots and the dashboard (a total of 5 screenshots) in a PDF file using Canvas before the due date. You should have two files (.py for code and .pdf with GUI screenshot) for submission. d) A descriptive comment before each function/method Assignment Details: As an Information Technology professional, much of your decisions are derived by Information Technology (IT). IT provides knowledge based on data that help business professionals to take better and more informed decisions. In this project, you are to utilize Python's Data Visualization packages to make a number of visualizations that will help to make some specific managerial decisions. The focus of this assignment is the creation of visualization dashboard using Python programming. It is important that your visualization dashboards show presentations nicely by adding the necessary elements (i.e., include title, annotations, sorting, coloring/highlighting, etc. as you see fit to best communicate your message). Task: Using the Customer Service Call dataset provided with this assignment, you are to design different plots and a dashboard using Python programming with the following specifications: Performance Analysis Dashboard a) Make a visualization graph (bar chart) showing total number of calls separated by incoming and outgoing call serviced (Call Type) by each sales representative (Rep ID). Save the graph as "plot1.jpg". b) Make a visualization graph (line chart) showing incoming and outgoing call volumes by time (Time Block). Save the graph as "plot2.jpg". c) Make a visualization histogram for time (Time Block) showing call frequency (both incoming and outgoing) by time. Save the graph as "plot3.jpg". d) Make a visualization graph (pie chart) showing percentage of calls for each call purpose (Call Purpose). Save the graph as "plot4.jpg". e) Create a dashboard with the above four image files and name dashboard as "Dashboard for Customer Service Calls Performance Analysis". Feel free to decorate the plots and dashboard using different fonts, colors, and other functionalities learnt previously in this course. Specific Details 1. callAnalysisByRep: this function should implement task (a) by performing mathematical computation to calculate number of incoming and outgoing calls handled by each representative. The computed data should be used to plot a bar chart showing number of incoming and outgoing calls by each customer service representative. Make sure to label both x- and y-axis properly and provide legend box to indicate color representation. Provide title for the plot and label each axis with respective values. This function should also save the file as "plotl.jpg". The bar chart may look similar to the following. Total Number of Calls by Representative Number of Cal Numer of Cal 2. callAnalysisByTime: this function should implement task (b) by performing mathematical computation to calculate number of incoming and outgoing calls by time. The computed data should be used to plot a line chart showing number of incoming and outgoing calls by each time block. Make sure to label both x- and y-axis properly and provide legend box to indicate color representation. Provide title for the plot and label each axis with respective values. This function should also save the file as "plot2.jpg". The line chart may look similar to the following. 2 8 6 Outgoing Calls 3 Total Number of Calls by Time Block Time Sk Incoming Calls Outgoing Cats 5:00 PM 3. timeHistogram: this function should implement task (c) to plot histogram for time block data. Make sure to label both x- and y-axis properly, provide title for the plot, and label each axis with respective values. This function should also save the file as "plot3.jpg". The histogram chart may look similar to the following. Histogram of Time Block 120- 100 4. callAnalysisBy Purpose: this function should implement task (d) by performing mathematical computation to calculate number of incoming and outgoing calls by call purpose. The computed data should be used to plot a pie chart showing the volume of calls (both incoming & outgoing) in percent for each type of purpose. Make sure to label each wedges of the pie chart properly and provide title for the plot This function should also save the file as "plot4.jpg". The pie chart may look similar to the following. Volume of Calls by Call Purpose Sales Support 35.42% Product Support 3.12% Complaint 5. createDashboard: using knowledge from Graphical User Interface (GUI) design concepts, this function should create an interface of size 1200 by 900 pixel. This function should then design a dashboard using all four images saved by previous functions. Make sure to nicely align the images on the dashboard. Feel free to resize the images to fit the dashboard window size. Provide a meaningful title for the dashboard. The dashboard may look similar to the following. Take a screenshot of your dashboard and include in your output file for Canvas submission. Dashboard for Customer Service Performance Analysis by Dr. Rahman Dashboard for Customer Service Performance Analysis by Dr. Rahman Total Number of Calls by Representativ Total Number of Calls by Time Block Grading Breakdown: Volume of Calls by Call Purpose 6. main: this function should be used to call all other functions. Submission Guidelines: Submit your code (.py file) and screenshot of four plots and the dashboard (a total of 5 screenshots) in a PDF file using Canvas before the due date. You should have two files (.py for code and .pdf with GUI screenshot) for submission.
Expert Answer:
Answer rating: 100% (QA)
Based on the provided assignment details heres an outline of the required functions and their descriptions python Copy import matplotlibpyplot as plt ... View the full answer
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0134065823
16th edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan
Posted Date:
Students also viewed these programming questions
-
The Sweet Basil just borrowed $700,000 [PV] to build a new restaurant. The loan terms call for equal annual payments at the end of each year. The loan is for 15 years at an APR of 8.35 percent. How...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Perform the indicated operations. (3k + q)
-
A business buys two identical tangible personal property assets for the same identical price. It buys one at the beginning of the year and one at the end of year. Under what conditions would the...
-
Let x be a continuous random variable that follows a normal distribution with a mean of 200 and a standard deviation of 25. a. Find the value of x so that the area under the normal curve to the left...
-
What is the effect on the current period statement of earnings and the statement of financial position when inventories are written down using the lower of cost and net realizable value method? What...
-
Potter's Home Goods sells furniture and electronic items. The majority of its business is on credit, and the following information is available relating to sales transactions for 2010, 2011, and...
-
Find the limit or indicate that it does not exist. lim t -> It sin at it cos ? it ( tan of k Select the correct choice below and, if necessary, fill in the answer boxes in your choice. O A. lim sin...
-
Copy Fast Services was opened by Jarenz on January 1, 2008 with a cash investment of P 10,000. Additional transactions for the month are as follows: Jan 245678 6 7 8 9 14 15 19 20 25 6456 33333 30 31...
-
Find solution to the differential equation as same way as attached photo example
-
JoeCo, a coffee company, has generated $100mm in last twelve months ("LTM") Revenue and this figure is expected to grow $10mm annually. JoeCo's LTM EBITDA was $20mm and its EBITDA margin should...
-
Merrill Lynch's cost of retained earnings is 12%, cost of preferred stock is 47% and its cost of debt is 10%. the optimal capital structure is 20% common stock, 50% preferred stock and 30% debt. The...
-
The m = 3 fringe is located 3.4cm from the central m = O fringe when monochromatic radiation illuminates a double slit. The screen is 33cm from the slits. The slit spacing is 0.2mm. (a) What must be...
-
The company will install the printing machine in an existing building, which is currently being rented out for $ 3 0 , 0 0 0 a year under a 1 0 year lease agreement signed 6 years ago. The next lease...
-
Given an array of bird sightings where every element represents a bird type id, determine the id of the most frequently sighted type. If more than 1 type has been spotted that maximum amount, return...
-
Required information Problem 14-59 (LO 14-5) (Algo) [The following information applies to the questions displayed below.] Natalie owns a condominium near Cocoa Beach in Florida. This year, she incurs...
-
For the vector whose polar components are (Vr = 1, Vθ = 0), compute in polars all components of the second covariant derivative Vα;μ;ν. To find...
-
Describe factors the auditor should consider in developing an expectation for depreciation while performing a substantive analytical procedure for depreciation expense.
-
This problem requires you to access PCAOB Auditing Standard No. 12, Identifying and Assessing Risks of Material Misstatements (pcaobus.org). Use this standard to answer each of the questions below....
-
Provide two examples of factors that might increase the risk of material misstatement at the overall financial statement level.
-
On September 1, 20x6, A Company purchased 100 percent of the voting stock of B Company for $480,000 in cash. The separate condensed balance sheets immediately after the purchase were as follows:...
-
Dale Company experiences heavy sales in the summer and early fall, after which time it has excess cash to invest until the next spring. On November 1, 20x6, the company invested $194,000 in U.S....
-
Scattergraph method Using the data in E4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2....
Study smarter with the SolutionInn App