/form-990-powerbi-dashboard

Example PowerBI dashboard for Form 990 data

Primary LanguageJupyter Notebook

Example PowerBI Dashboard for examining Form 990 data

Setup

Executables

Windows

  1. download PowerBI

OSX

  1. Get a Windows Virtual Machine (recommend: Parallels (paid). Free: can try Virtualbox
  2. Download a virtualbox windows virtual machine
  3. Open your Windows virtual machine
  4. Within your Windows virtual machine, download PowerBI

Data

If you wish to re-run data cleaning procedure (unnecessary):

To download into repository root:

  • Sample_Program_Service_Data.csv - Download from Amazon Sample pre-aggregated financial and text data from Form 990s.

In repository:

  • clean.tsv
  • clean_clustered_forBI.tsv
  • clean_res.tsv
  • clean_clustered_forBI.csv
  • clean_meta.txt

Code

If you wish to re-run data cleaning procedure (unnecessary):

  1. pip install -r requirements.txt
  2. jupyter notebook
  3. Open and run DataCleaningAndClustering.ipynb

Note: actual clustering code is not provided, and so cannot be re-run.