search

LouisvilleMetro / WazeCCPProcessor

Waze WARP takes your CCP data feed and processes it into your cloud provider for access, analysis, and visualization. An Open Government Coalition (OGC) project. @govintheopen
https://www.govintheopen.com/
MIT License
79 stars 25 forks source link

Create PowerBI templates around good use cases and save files to repo #28

Open schnuerle opened 6 years ago

schnuerle commented 6 years ago

Once the RDS is complete in Phase 1, we'd like to support more data visualization integrations. If you use Power BI, you can make a pull request to add support for it with examples to this repo so everyone can benefit. Use this issue as a place to discuss and collaborate.

mjhampton12182 commented 6 years ago

Here are some instructions on connecting Power BI to your AWS Waze Data: https://docs.google.com/document/d/1RGMSmYBg7TwT4uV9Q6XAiGFjU3Rf2wFEkAMrUFkDHA4/edit

Here is a first pass template for re-timing analysis. This template is intended to show if there is a change in jams after signal re-timing efforts. The query that pulls the data can be edited to pull a specific time frame and a specific square area to focus your analysis. Instructions on using the tool are in progress. Also, still working on a graph for direction.

Power BI template (download it): https://drive.google.com/file/d/1uJzDcZ9nnBCQm1DS68Xqzs7YjcPhDSfC/view?usp=sharing

The SQL query used in the above Power BI template with some explanation is posted here: https://github.com/LouisvilleMetro/WazeCCPProcessor/issues/43.