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