Applications of Business Analytics

Task:
Step 1: Create Dashboard with summary of Key Metrics Summary of key metrics with call numbers, trend lines, abandon rate with traffic light status indicator, and orders for all shifts and each shift individually This criterion is linked.
Step 2: Create Calls Handled by Auto Response Chart Column chart for percent of calls handled by auto response, including target line and slicers for day type and date This criterion is linked.
Step 3: Create Additional KPI Displays At least two additional KPIs of your choosing relevant to the strategic objective displayed on the dashboard with appropriate visual representations and clear descriptive labeling This criterion is linked.
Step 4: Finalize Workbook Dashboard is professionally formatted with data and calculation sheets hidden; gridlines, formula bar, and row/column headings not visible on the dashboard sheet; and professional use of colors, fonts, borders, and shape This criterion is linked.
Step 5: Written Opinion Paper & Submission Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Findings and recommendations are relevant to the strategic objective and are supported by the dashboard. 



 Read less