Los Angeles Crime Analysis

By: Drew White

Exploring Crime - Los Angeles

My part of a larger project located here: Team Week 2

This repository demonstrates the creation of an ELT pipeline in dbt, using city crime data sourced from public kaggle datasets.

Technologies Used

• Python
• SQL
• BigQuery
• DBT
• Looker Studio

Dashboards and Visualizations

Los Angeles Dashboard

Data Models

Datasets Used

• https://www.kaggle.com/datasets/chaitanyakck/crime-data-from-2020-to-present

Setup/Installation Requirements

• Make new directory:

  mkdir <new-directory>
  cd <new-directory>

• Clone repository:

  git clone https://github.com/Drewrwhite/la_crime_analysis.git

• Set up a virtual environment in your terminal:

  python3.7 -m venv venv

• Activate the environment:

  source venv/bin/activate

• Install requirements.txt:

    pip install -r requirements.txt

• Open directory:

  code .

Known Bugs

• No known bugs

License

MIT

If you find any issues, please reach out at: d.white0002@gmail.com.

Copyright (c) 2023 Drew White