Skip to main content

Power BI Administration and Development, Metropolitan Transportation Authority

Overview

The Metropolitan Transportation Authority (MTA) is a public benefit corporation responsible for public transportation in the New York City metropolitan area of the U.S. state of New York. The MTA is the largest public transit authority in the United States, serving 12 counties in Downstate New York, along with two counties in southwestern Connecticut under contract to the Connecticut Department of Transportation, carrying over 11 million passengers on an average weekday systemwide, and over 850,000 vehicles on its seven toll bridges and two tunnels per weekday.

Project Scope

MTA required a vendor for troubleshooting and resolving issues in a timely manner related to Microsoft Power BI Administration.


Solution

As prime vendor, V Group Inc. provided the following services to MTA:

  • Power BI Administration and Development
  • SQL Query Writing (SP, View, Tuning)
  • Creation Power BI datasets and dataflows
  • Writing and understanding PowerShell Scripting
  • Provisioning and setting up OnPrem Gateways and managing updates

Technology

  • Power BI
  • SQL Query
  • DAX and M
  • PowerShell