MBA504 Business - Since visualization plays an important role in business

MBA504

Business Question

Overview

Since visualization plays an important role in business communication between consultants and stakeholders, Power BI is a popular tool to use with Excel data analysis worksheets. In this scenario, you will continue to work as a business consultant trainee with the TC Ice Cream client.
Your manager has advised you to use Power BI to recreate multiple charts that you initially generated in Module Two for the TC Ice Cream Management team. Remember that the team is interested in whether specific trends are identified that can help grow its business through improved operations and sales. TC Ice Cream uses Power BI as its main data visualization tool; therefore, you believe that using this tool will help you communicate your analysis in a familiar and meaningful way.

Prompt

Your task is to create multiple charts using Power BI as part of your continued analysis to help TC Ice Cream grow its business through improved operations and sales. Follow the directions in the Module Seven Power BI Assignment User Manual to create a trend chart and a column chart in Power BI.

Specifically, you must address the following rubric criteria:

1. Create a trend chart to represent the subcategories of the data.
   • Use Power BI on the virtual desktop infrastructure (VDI) to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a trend chart in Power BI from your completed TC Ice Cream “Division Analysis” worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert it to a PDF.
   • Name the PDF as follows: Power_BI_Chart3.
2. Create a column chart to represent the subcategories of the data.
   • Use Power BI on the VDI to complete this step.
   • Use the TC Ice Cream Excel Workbook available to you on the VDI.
   • Recreate a column chart in Power BI from your completed TC Ice Cream “Division Analysis” worksheet.
   • Articulate and appropriately label the chart you created in Power BI.
   • Take a screenshot of the chart, paste it in a Microsoft Word document, and convert it into a PDF.