For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

http://catalog.data.gov/dataset/consumer-complaint-database

Available Access Formats

CSV JSON XML

Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Hierarchies

  • Issue > Sub-issue
  • Product > Sub-product

Calculated Columns & Calculations

Name DAX Expression Type
ZIP code key =IF(LEN([ZIP code]) < 5,CONCATENATE(“0”,[ZIP code]),[ZIP code]) Calculated Column
Complaint Count Complaint Count:=COUNTROWS(‘Consumer_Complaints’) Calculation

Examples for Reference

Open Data Bits Post – Consumer Financial Protection Bureau Complaint Database Now Featured at Open Data Bits