FPDS data for a long time. I suppose the good news is that the system has changed little over the years, so time invested in learning its quirks is worthwhile. Below, I’ve outlined a few methods for maximizing its value and pitfalls that you may encounter."> FPDS data for a long time. I suppose the good news is that the system has changed little over the years, so time invested in learning its quirks is worthwhile. Below, I’ve outlined a few methods for maximizing its value and pitfalls that you may encounter."/> Getting the Most out of FPDS | Federal Compass

Getting the Most out of FPDS

10/18/2019


As many others in this industry, I’ve worked with FPDS data for a long time. I suppose the good news is that the system has changed little over the years, so time invested in learning its quirks is worthwhile. Below, I’ve outlined a few methods for maximizing its value and pitfalls that you may encounter.

The Basics

For those of you who are new to federal market intelligence, the Federal Procurement Data System (FPDS) is the primary mode of transparency around government contracting. It’s best to think of this data as a running list of transactions, just like transactions in your bank account. Also just like your bank account, there are details like transaction amount and recipient, etc. However, unlike a transaction in your bank account, there is a vast amount of meta data surrounding each transaction in FPDS. For instance, contract details, socioeconomic indicators for the awardee and details on the procurement method, to name a few.

This is all well and good, but how do you make sense of all that information?

Sums and Aggregations

Viewing a single transaction in FPDS is great for a snapshot in history, but in order to derive value, we must look at the aggregate. After rolling up this spending along various dimensions, you begin to answer more meaningful questions:

  • What’s the total obligated amount on this contract?
  • How much did this awardee receive from a particular agency?
  • What’s the total set-aside spending for Navy?

Of course, that’s only of limited value. It’d be much better to know how these figures are changing over time.

Trending

The next level of understanding can come from watching sums and aggregations change over time. Viewing and understanding trends, especially at a granular level (like within an office or a for a specific contractor), can be incredibly valuable. Now, we can begin to see how contracting dollars are moving. How is the dominant contractor performing? Are they losing market share over time? Maybe this particular office is changing their buying patterns and moving dollars away from definitive contracts.

Data Normalization

Now that we can see where money is changing hands and how those hands are changing over time, it’s important to take a step back and consider data quality. What do we mean by data quality? Data quality is really just the consistency of categorization and classification of the data. In the case of FPDS, we need to look into each transaction and understand if things like vendors or programs are represented in a consistent fashion. The short answer is NO.

In order to paint a vivid and accurate picture of the world, these data quality issues must be addressed. For instance, let’s say a contractor, “ABC, Inc.”, is represented inconsistently in the data. Some transactions have names like, “ABC INC”, “ABC, INC”, “ABC Inc.”; we could on and on. Although the data that describes the awardee is different, this is in fact the same vendor, and we want to see all their transactions reported together.

Unfortunately, there’s no shortcut to good data quality. It must be cultivated by dedicated analysts, intent on seeking out every discrepancy.

At Federal Compass, we have expert and dedicated analysts doing this every day. We don’t outsource any data normalization because this is fundamental to quality market intelligence.

The Author

Chad Ganske Federal Compass
Chad Ganske
Changing the perspective of government contractors one market intelligence report at a time.

Recent Posts

Learn What's on the BIC MAC Menu

Learn why everyone is talking about BIC MAC. It's more than just an OASIS 2 recomplete, it's a one-stop shop for solution-centric professional services. BIC MAC is positioned to significantly disrupt the market. We've seen from OASIS trends that contractors can expect widespread adoption across federal agencies. During this webinar we'll explore the broad range of services that can be expected on BIC MAC and the large number of contractors that are sure to participate. We'll also investigate why certain contractors have more post-award success that others, and some of the techniques to finding the right teaming partners.


written by Jim Sherwood, published 06/28/2021


Polaris Recap: We'll Explore What's Changed with Polaris

With other big-ticket vehicles already competed, Polaris offers another onramp for contractors to get in on the action. We'll explore historic Alliant spending and discuss strategies for Polaris.


written by Jim Sherwood, published 05/18/2021


The March Toward GWACS: CIO-SP4, POLARIS, 8(a) STARS III

Is your company prepared for the shifting landscape within Federal IT procurement? For nearly twenty years, GSA Schedules and agency-IDIQs paved the way for the evolution of second-tier competitions. In 2019, GWACs outpaced IDIQs, for the first time, to become the Government's preferred pathway. Every Federal customer interacts with GWACs, and these vehicles continue to lure in new adopters. From the broad range of services to the number of contractors vying for work, the loyalty to IDIQs is waning as customers begin their march towards GWACs. For many, this statement makes sense; however, getting on a GWAC, let alone finding success, creates a challenge unique to these types of vehicles. It isn't enough to know POLARIS, CIO-SP4, and 8(a) STARS III; a clear vision and strategy are critical to determining the right team, surviving the scorecard, and moving into post-award with a proactive plan to capture business, rather than hopelessly reacting.


written by Jim Sherwood, published 03/09/2021


The Small Business Catch-22: Available Resources Limit Critical Processes

Revenue growth is the primary focus of every small business, but in a market as complex and fluid as the federal contracting market, growth can often stall due to the lack of the right resources. And when effectively managing expenditures puts the right resources out of reach, small businesses often get caught in a growth Catch-22.


written by Jim Sherwood, published 01/25/2021