• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Tag Archives: Seeking

Seeking a one-line command (v. 10) to solve for x[s_] and y[s_] in the following equation: 3x+4y=1+5s. The answes are x=-1+3s and y=1-s

September 14, 2020   BI News and Info

 Seeking a one line command (v. 10) to solve for x[s ] and y[s ] in the following equation: 3x+4y=1+5s. The answes are x= 1+3s and y=1 s

Let’s block ads! (Why?)

Recent Questions – Mathematica Stack Exchange

Read More

How Tipping Point Is Seeking Financial Justice with TIBCO Analytics

April 30, 2018   TIBCO Spotfire

In March 2018, the San Francisco Municipal Transportation Agency (SFMTA) announced reforms that would alleviate the burden of parking ticket fines on low-income San Franciscans. There is increasing awareness that parking citations can result in disproportionate hardship for low income drivers, from late fees, towing, and even loss of income resulting from the impounding or sale of a vehicle. Tipping Point Community, a non-profit that fights poverty in the Bay Area, has been working hard behind the scenes to promote greater awareness of this issue, sharing statistics and recommendations with the San Francisco city government. They’ve spent the last few months crunching through some pretty big datasets to quantify just how bad the problem is.

Ashley Brown, a manager and analyst on the Impact + Learning team at Tipping Point, used TIBCO’s Spotfire Data Science platform to uncover insights from parking citation data. She took advantage of the collaborative capabilities of the platform to work alongside some of TIBCO’s own data scientists. Together, they used the point-and-click analytics tools to develop an array of statistics and visualizations that highlighted the most burdensome aspects of parking citations. The team also used TIBCO Spotfire to create dashboards for communicating the findings to other members of the organization.

The project started last year when Tipping Point came to TIBCO asking for help with analyzing the large parking datasets that it had acquired from the San Francisco MTA through the SF Sunshine Ordinance and the California Public Records Act. The analysts at Tipping Point were most comfortable with tools like Excel and Stata, so they needed a solution that was equally easy to use, but that could easily handle and clan millions of rows of citations and then combine the citation data with neighborhood attributes, demographics, towing data, and more.

They also wanted to move quickly — San Francisco founded the country’s first Financial Justice Project in early 2017, a new venture in conjunction with San Francisco’s Office of the Treasurer and Tax Collector, and Tipping Point was eager to take advantage of the City’s interest in “assessing and reforming how fees and fines impact our most vulnerable residents.” TIBCO recommended deploying Spotfire Data Science within Amazon Web Services, where it can leverage scalable cloud-based platforms like EMR and Redshift. Within a few hours, the team was able to upload datasets and produce their first data workflows.

dashboard How Tipping Point Is Seeking Financial Justice with TIBCO Analytics

Initially, the data scientists from Tipping Point looked for patterns in the way citations were given in different neighborhoods. But what does it mean to compare one ZIP code to another? How should they take into account the size of the area and the density of parking meters or tow away zones? So they started looking along other dimensions — the type of ticket, the make of the vehicle. And immediately they saw that tickets were actually more expensive for certain vehicle types that were perhaps correlated with low or middle incomes. Even tickets of the same type (e.g. street sweeping) had varying costs, most likely because of late fees. The team wanted to measure just how great a burden came from more expensive tickets (e.g. lapsed registrations) and late fees and tow away fines, and if that burden might be higher for low-income people not just because they had less money, but because the tickets they got were actually — in effect — more expensive.

But there was no easy way to relate the income of a driver to the vehicle listed on the citation. The most reliable way to track a driver’s details was from the VIN number, but only a small proportion of tickets had that information. The analysts could use the make of the vehicle, but that was a very weak proxy for income. Eventually, they realized that California license plates held the key — they are issued sequentially (7ABC111, 7ABC112, etc.) and generally remain with the vehicle when it is sold. So the digits on the plate can be converted into a unitless measure of age. Meanwhile, intuition suggests that vehicle age is directly correlated with income, a hypothesis confirmed by several studies (e.g. UT Austin, U.S. Department of Transportation).

The team now had a simple way to measure the impact of ticket costs on owners of aging vehicles. And the results were quite striking: for older vehicles, citations cost 14% more in general, and certain ticket types (e.g. expired registration) cost 32% more; delinquency rates were more than twice as high as the average.

These findings confirm what we hear anecdotally, of people who cannot pay tickets, who rapidly accumulate fees that can be fully half of the original fine, and who then lose their cars and the ability to get to work. Quantifying this — which tickets are most burdensome, and by how much — is the first step to making the system more fair. So TIBCO is proud to support the analysts of Tipping Point and the City employees working to change the way citations are managed.

workspace How Tipping Point Is Seeking Financial Justice with TIBCO Analytics

Let’s block ads! (Why?)

The TIBCO Blog

Read More
  • Recent Posts

    • C’mon hooman
    • Build and Release Pipelines for Azure Resources (Logic Apps and Azure Functions)
    • Database version control: Getting started with Flyway
    • Support CRM with New Dynamics 365 Field Service Mobile App
    • 6 Strategies for Achieving Your Business Goals in the New Year
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited