Monthly Archives: November 2020

Project Status Report #4

Meeting via: Zoom

Meeting Date: 11/29/2020

Attendees

  • Ashley Jaiprashad
  • Petros Papadakos
  • Ksenia Bochkova

Discussion Points

  • is ETL completed/any points from ETL
  • any issues/changes needed to be made from ETL process
  • plan for dashboard programming

Action Items / Decisions Made

  • updated blog with our ETL process (transformation, step metrics, sample data)
  • set next team deadline for Dashboard programming
Posted in Uncategorized | Comments Off on Project Status Report #4

Project Status Report #3

Meeting via: Zoom

Meeting Date: 11/14/2020

Attendees

  • Ashley Jaiprashad
  • Petros Papadakos
  • Ksenia Bochkova

Discussion Points

  • how is the ETL process going
  • any issues we see arising for the remaining steps
  • progress towards group deadline

Action Items / Decisions Made

  • added steps to our ETL process
  • set up next meeting to speak about dashboard programming
Posted in Uncategorized | Comments Off on Project Status Report #3

Project Status Report #2

Meeting via: Zoom

Meeting Date: 11/04/2020

Attendees

  • Ashley Jaiprashad
  • Petros Papadakos
  • Ksenia Bochkova

Discussion Points

  • how can we finalize our DM
  • next steps for tackling the ETL
  • goals of our project

Action Items / Decisions Made

  • made final changes to our DM
  • updated our blog page
  • delegated ETL process
  • set deadlines within our group
Posted in Uncategorized | Comments Off on Project Status Report #2

Project Status Report #1

Meeting via: Zoom

Meeting Date: 10/24/2020

Attendees

  • Ashley Jaiprashad
  • Petros Papadakos
  • Ksenia Bochkova

Discussion Points

  • what topics should we do for this project
  • what are some datasets we can use
  • which business problem are we aiming to solve

Action Items / Decisions Made

  • found the datasets
  • we decided on the topic of correlation between weather and crime
  • start to work on our model
  • start to build our works in the blog
Posted in Uncategorized | Comments Off on Project Status Report #1

Project Milestone 5: Dashboard Programming

Dashboard Image 1Dashboard Image 2

Posted in Uncategorized | Comments Off on Project Milestone 5: Dashboard Programming

Project Milestone 4: ETL Programming

Transformation Screen

ETL Transformation

Step Metrics

Step metrics

Sample of Table (first columns)

Sample data

Sample of Table (last columns)

Sample data

Posted in Uncategorized | Comments Off on Project Milestone 4: ETL Programming

Project Milestone 3: Dimensional Model

Dimensional Model draft.

 

Posted in Uncategorized | Comments Off on Project Milestone 3: Dimensional Model