Overview
This milestone is directly related to the course project. As a member of the accounting department for a medium-sized company, you have been selected to participate on a task force that will analyze software products through accounting processes. The company is considering one of two software providers, Microsoft Excel Power Query/Power BI and Tableau, so it is asking employees from various departments to test these software options. You have been tasked with doing an in-depth independent analysis of each software to determine which of the two options will be most beneficial for the company given the various accounting tasks that will need to be performed. Using what you have learned from completed lab assignments, you will create a report to outline the differences between Microsoft Excel Power Query/Power BI and Tableau. You will include a summary of your findings for the company to consider relating to which software option you believe would be most beneficial to the company.
Directions
In Modules One and Two, you performed data analytics tasks using Microsoft Excel Power Query/Power BI and Tableau. Use your Evaluation Checklist as a resource to help you develop responses to the items below. Note: Milestone One is a draft of the first five steps found in the course project. Results from this assignment can assist you in completing steps in the course project that is due in Module Seven.
Specifically, you must address the following rubric criteria:
- Identify specific problems that can be solved by data analytics tools.
- Explain techniques for different problem-solving tasks within data analytics tools.
- Include 2–3 examples of problem-solving tasks for Power BI and Tableau
- Analyze ethical issues to be considered when working with data.
- Include 2–3 examples of ethical issues
- Explain why clean data is used in an analysis.
- Justify why identifying anomalies is important when working with data.
- Include a visualization to showcase anomalies for each of the two technologies: Power BI and Tableau.
What to Submit
- Submit your paper as a Microsoft Word document using double spacing, 12-point Times New Roman font, and one-inch margins. This assignment should be 2–3 pages in length (not including title and reference pages), should include visuals, and should include references cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.
- Submit your Evaluation Checklist. (This document will be used for Milestones One and Two and the course project).