Module 5:

Data Wrangling &

Cognos Analytics

1

Welcome to Module 5!

Introduction

  • Congrats on getting to the central content of this course!

  • Now that you have a basic idea of the kinds of data you can collect, you need to know what to do with the data.

  • In this module, we will be wrangling and analyzing data.

  • We will use Excel and IBM Cognos Analytics, but there's no limit to how far you can go! Feel free to use other data wrangling and analytics software if you have a preference.

Objectives

  1. Know how to data wrangle with Excel

  2. Know how to use Cognos Analytics to analyze a dataset

  3. Have fun!

2

Data Wrangling in Excel

5

Learn Cognos Analytics

Screen Shot 2021-05-28 at 4.15.34 AM.png

Assignment

Here are the two assignments for you.

1. Discussion Forum

  • Introduce everyone to your big data project.

  • Do an exercise on data wrangling.

Rubric: https://tinyurl.com/3nd8busk

2. Big Data Project

  • Work on your own project!

  • Complete data wrangling in Excel or Numbers and upload it to Cognos Analytics.

  • Make sure you upload your dataset to Cognos Analytics before you start data wrangling to see how you want to format your data.

Rubric: https://tinyurl.com/cve434yh

Screen Shot 2021-05-28 at 4.19.30 AM.png