Here are some important things for preparing for the 12th week:
Weekly Quiz (you can click the highlights to get the related content)
- Please read the reading materials for Week 12 (three readings)
- Please finish the week 12 quiz before the class on 11/8 (Tuesday)
- We almost finished all of the weekly quizzes. This is the penultimate!
Second Individual Assignment
- The due date is 11/10
- Please finish it asap and use me or Anna to help you check your answers.
- You can check with us multiple times.
- Don’t feel shy! We are glad to help!
- Please send us your answers and excel via email.
Guest Speaker
- Jim from The Hilltop Institute will come to our class to give a virtual talk!
- Please try to come in person (we may continue some content from 12.1 if we didn’t finish then)
- You can also join over zoom: https://temple.zoom.us/j/2292311746
Your final group project
- Please form 4-5 members of your team.
- Please send me an email with the names and emails of your team members after you finalize your team.
Week 11 key takeaways
- Dashboards
- Multiple perspectives to the data rather than just one scorecard
- A well-designed dashboard can provide a powerful overview of a phenomenon
- Dashboards are often interactive
- customize visualizations
- drill deeper into the data.
- Dashboards are not easy to design
- Recommendations for better data discovery using dashboards
- Link KPIs to detailed views
- Create dynamic reports
- Give users an ‘information scent’
- Pivot Table
- A pivot table is a table of statistics that summarizes the data of a more extensive table.
- This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
- All related data must be in the same table to be pivoted
- It can entail lots of redundant fields
Leave a Reply