1 / 36

Spreadsheet Design for Data Analytics & Controls for Big Data

Spreadsheet Design for Data Analytics & Controls for Big Data. Module S & Supplemental Resources on Class Website. Concept Map. Data Analytics. Implementation. Design. Excel Features. Simplicity. Verifiability. Clarity. Objectives. Define e-commerce & Data Analytics.

emmly
Download Presentation

Spreadsheet Design for Data Analytics & Controls for Big Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet Design for Data Analytics & Controls for Big Data Module S & Supplemental Resources on Class Website

  2. Concept Map Data Analytics Implementation Design Excel Features Simplicity Verifiability Clarity

  3. Objectives • Define e-commerce & Data Analytics. • Explain the Simplicity, Clarity & Verifiability Principles. • Demonstrate Excel features often used with large spreadsheets.

  4. E-Commerce • Conducting business transactions over a network

  5. REI Web Store

  6. Second Life American Apparel Adidas

  7. E-Commerce & Apparel • Digital sales only represent about 10% of all apparel sales each year • Roughly 40% of retailers’ online sales are returned due to unflattering fits

  8. Fashionista http://www.youtube.com/watch?v=ZnBcqV9POkY&feature=player_embedded#

  9. TrueFit House of Fraser - http://www.truefit.com/about-us/how_it_works

  10. Data Analytics Supports fact-based decision making in data-rich environments

  11. Find http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  12. Spreadsheet Design Goals • Simplicity • Clarity • Verifiability • Accuracy • Efficiency

  13. Simplicity – Part 1 One idea per row & one idea per column

  14. Header & Footer Select VIEW, NORMAL to return to regular worksheet display http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  15. Rename Worksheet Double-click sheet tab to change text http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  16. Clarity • Unity* • Delineation • Order • Emphasis

  17. Printing Problem

  18. Print Titles http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  19. Display Problem

  20. Freeze Panes First position cursor below & to the right of headings http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  21. Basic Formatting to Support Unity & Delineation • Fonts • Background Colors • Borders

  22. Clarity • Unity • Delineation • Order* • Emphasis

  23. Sort First, select data range. Sort by Last Name. If two students have the same last name, sort by First Name as well. http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  24. Conditional Format First, select data range. http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  25. Conditional Formatting Example Emphasize Accounting majors. First, select data range. http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  26. Simplicity – Part 2 Numbers to be compared should align vertically in columns

  27. Deliniate Worksheet Zones • Heading • Data • Calculations

  28. Verifiability • Minimize data entry errors • Data Validation for Data Zone • Worksheet Protection for Heading & Calculation Zones

  29. Data Validation Decisions • Which data cells may require data validation? • What rules can I establish to identify incorrect data? • Is this rule accurate 100% of the time? • What should my error message be?

  30. Data Validation Error Message

  31. First, select data range. Data Validation http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  32. Worksheet Protection Decisions • Which cells require protection? • Which cells need to be unlocked?

  33. Worksheet Protection Error Message

  34. Worksheet Protection (Step 1) http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  35. Worksheet Protection (Step 2) http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

More Related