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 superstore client.
Your manager has advised you to use Power BI to recreate multiple charts that you initially generated in Module One 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 way and result in more meaningful analysis.
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 Four Power BI Assignment User Manual to create a pie chart and a column chart in Power BI.
Specifically, you must address the following rubric criteria:
-
Create a pie chart to represent the key attributes 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 pie chart from your completed TC Ice Cream “Overall 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 the document to a PDF.
- Name the PDF as follows: Power_BI_Chart1.
-
Create a column chart to represent the key attributes 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 from your completed TC Ice Cream “Overall 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_Chart2.
What to Submit
Submit each Power BI chart screenshot in a PDF format. Name the charts as instructed in the prompt: Power_BI_Chart1 and Power_BI_Chart2.