home
techred home > dat-203 sequence

DAT-203: Visualization and warehousing Course schedule | CCAC | Spring 2020 | West Hills Center

The following table maps course session dates, lesson topics, references, and content links for all three Data Analytics courses in the series.

course date wk no. session links learning objectives out-of-class work
DAT-203 Thursday
30-JAN-2020
1

Indicies

Creating indicies to aggregate several measures

Create a sharable directory

      Create a spreadsheet to compute index values for wikipedia and non-wikipedia sources
      Sample a handful of sites around three different topics
      Create a directory in our shared drive linked below and upload your findings. Use first names only.
DAT-203 Thursday
6-February-2020
2

Categorical data I:
Country-level development indicies

  1. Create a git repository dedicated to your work for this course, DAT-203. Email Eric a link to your repo, please.
  2. Compile a multi-country comparison of two or more development index values as described in our index mini-project.
DAT-203 Thursday
13-Februrary-2020
3

Categorical data II:
Visualizing categorical data over time

table_chart Shared google doc of index explorations

      Prepare a final, fully-baked version of a figure showing change in your chosen indexes during the end of the cold war. Include a beefy title, source attribution, well-formatted lines, and a caption discussing what changes are visible.
DAT-203 Thursday
20-Februrary-2020
4

Synchronous Zoom only @
6:00pm; Don't drive to North!

Zoom meeting info
Time: Feb 20, 2020 06:00 PM Eastern Time (US and Canada)
Join Zoom Meeting
https://ccac.zoom.us/j/328278689
Meeting ID: 328 278 689
Phone audio: 646.558.8656

Continuous quants I:
Manipulations in spreadsheets

    DAT-203 Thursday
    27-Februrary-2020
    5

    Synchronous Zoom only @
    6:00pm; Don't drive to North!

    Zoom meeting info
    Time: Feb 27, 2020 06:00 PM Eastern Time (US and Canada) Join Zoom Meeting https://ccac.zoom.us/j/803721757
    Meeting ID: 803 721 757
    Dial by your location
    +1 646 558 8656 US (New York)

    Continuous quants II:
    Visualizing with pandas & R

      DAT-203 Thursday
      5-March-2020
      6

      Mid-term grade proposals: Meet in person at North

      Time-series data I: Manipulating in spreadsheets

        DAT-203 Thursday
        12-March-2020
        7

        Time-series data II: Visualizing in pandas and R

          DAT-203 Thursday
          19-March-2020
          8

          Qualitative analysis in a whirlwind

            DAT-203 Thursday
            26-March-2020
            9

            Part I: Confidence intervals & hyp testing: Visualizing statistical relationships

            Part II: Confidence intervals & hyp testing:
            Quantitative underpinnings

              DAT-203 Thursday
              2-April-2020
              10

              Visualization minin project: sharing

                DAT-129 Thu
                9-April-2020
                XXX

                Break

                No class meeting!

                XXX

                Go play!

                DAT-203 Thursday
                16-April-2020
                11

                Part A: Data warehousing basics: Diagramming data chains

                DW part A: Data warehousing basics

                Diagramming data pipelines at the macro level from acquisition to managerial dashboarding

                DW part B: Databases to warehouses

                What is the relationship between operational relational databases, such as point-of-sale systems, and a data warehouse?

                  DAT-203 Thursday
                  23-April-2020
                  12

                  DW part C: Configuring and migrating a warehouse chain

                  DW part D: Business "intelligence" in dashboards

                  With data dashboards springing up in the most unlikely of industries, we must distill best practices in their design

                    DAT-203 Thursday
                    30-April-2020
                    13

                    Data warehouse and dashboard group project

                    Work with your peers to create a mini tool-chain from multiple discrete sources into a warehouse and into a simple dashboard for visualization and manipulation

                      DAT-203 Thursday
                      7-May-2020
                      14

                      Share final projects