Creating A Dashboard Using the Tools and Techniques Required
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Creating A Dashboard Using the Tools and Techniques Required
Project Information
Due Date: March 3, 2014
Key Resources:
Power Pivot Sample Data Sources:
- Microsoft Azure Web Service (https://datamarket.azure.com)
- Statistics Canada Key Resources (CANSIM) (http://www.statcan.gc.ca/start‐debut‐eng.html)
- Sample Database (TBD)
The Project
Your job is to create a dashboard using the tools and techniques you have learned in class. Make use of
pivot tables to create a spreadsheet using information found online and use the best practices you’ve
learned in class to make your spreadsheet easy to use and easy to understand.
Project Criteria
Part 1
Create a short one page memo addressed to your instructor that includes a brief description of your
data set along with a summary of your analysis and the results yielded. As part of your summary and
analysis section, your memo should include 4 to 6 questions (max 10) that you intend to answer with the
data provided in your workbook. Submit this file as a Word document to D2L with the full name and
student numbers in the header.
Total: 15 Marks
Part 2
Minimum Requirements
Create a workbook that is able to at the very minimum answer the questions you defined in the memo
you created in Part 1.
Structure your Workbook as follows:
Create at least 5 worksheets and re‐name the worksheets appropriately to match the information
contained within.
Your workbook should include a minimum of:
- 1 Dashboard worksheet · 4 Pivot Tables worksheets · 2 Chart/Pivot Chart worksheets
For example, your workbook structure might end up looking something like this:
Project –John Doe A001234567.xlsx
- Dashboard · Q 1 – Profit over Time Pivot Table · Q 2 – Customers by Education Pivot Table · Q 3 – Sales by Promotion Pivot Table · Q 4 – Product Type Pivot Table · Q 1 & 2 – Graph · Q 3 & 4 – Graph
Dashboard Worksheet – 45 Marks
Your dashboard should meet the following minimum criteria:
- Easy to read
- Combines data from different tables or datasets. If you chose to work with one large data set
ensure that you are making use of and measuring all of the information provided.
- Provides an at‐a‐glance understanding of key measures (i.e. your questions)
- The dashboard should be interactive – make use of Slicers to allow the user to change
information for their own needs
- Make use of Data Validation and/or Worksheet Protection where needed.
Figure 1. Example Dashboard
Pivot Table Worksheets – 5 Marks ea. (30 Total)
Your Pivot Tables should include the following:
- Contain at least 2 Calculated Fields · Be customizable with use of Filters and/or Slicers · Easy to Read and Understand · Answer the Question you Defined
Chart/Pivot Chart Worksheets – 5 Marks ea. (20 Total)
Your Pivot Charts should include the following:
- A visual representation of the information defined in your Pivot Tables · Clearly labeled XY Axis and presented in an easy to read format · Include a data legend where appropriate · Include Slicers or Filters so that it can be modified
Total: 100 Marks
Grand Total: 100 Marks, Weight 30% of overall grade.
Additional Resources:
For a good explanation of Dashboards along with examples, visit the website below:
http://www.pivotdashboard.com/Pages/DashboardIntroduction.aspx
Creating A Dashboard Using the Tools and Techniques Required
Creating A Dashboard Using the Tools and Techniques Required
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow