Skip to content

BronzeKnuckles/DATA_WAREHOUSE_SEC

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Building and Implementing a Robust Data Warehouse of SEC Public Dataset on BigQuery

Executive Summary

This project aims to address the challenge of extracting, cleaning, and analyzing financial form submissions from the SEC's website. These forms hold rich financial data, under-utilized due to the complexity of handling it. By leveraging Google Big-Query's capabilities, we propose developing a data warehouse solution to efficiently organize and analyze this data, enabling better decision-making for stakeholders in the financial sector.


Project Deliverables:

  1. A fully functional data pipeline of SEC.gov public dataset into Big-Query.
  2. A transformed, custom tables and views suitable for analysis.
  3. Implementation of custom procedures and views for quick and robust access of relevant data.
  4. Documents:
    • Quick access guide
    • Documentation of system and query usage.

Vision and Mission

Data Model:

Data Model

Big Query Screen Shot:

Big Query Screen Shot

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors