Charts and Graphs: Digging In

Before any dashboards or stories can be communicated, it is necessary to first explore the data to find the noteworthy data points. To do this, the who (the audience or stakeholders), what (what the audience needs to know), and how (the method or means and data to be communicated) must be clearly identified.You work for a large office supply chain store, and the CEO of the company has asked you to create a stakeholder’s report of the company’s overall health. Along with the report, he asked you to create interactive dashboards for on-demand, real-time insight into the data.There are four primary groups—customers, orders, products, and locations—for which you will create data visualizations, interactive dashboards, and story points. To begin, download and connect to the Super Office Mart dataset (Excel file).  Once you have connected to the data source and set up the proper join, create 3 worksheets:  Sales by Product/Region  Sales by Product Subcategory  Negative Profit Comparison ChartUsing filters and color formatting, identify the troublemakers for each region.

In a 10–15-slide PowerPoint presentation, report your findings based on these exploratory charts. Highlight notable data points based on applied filters. Submit your Tableau (.twb) or Excel workbook along with your PowerPoint presentation.