Business Intelligence

What have you always wanted to do with contracting data but never been able to?

Maybe… Interact with a dashboard? Get a text message notification base on a trigger (like, “your unit just passed 50% of last year’s spend”)? Compare data to another database?

2 Likes

I would like a database we could use to provide real-time status of acquisitions to our requirement owners. The database would pull data from the PR so it doesn’t have to be manually entered by the contract specialist or CO. It would also update automatically as actions are taken in CON-IT.

I also would like to generate memos and templates from the database with a tool like https://www.hotdocs.com/ or https://www.templafy.com/.

Since we are talking business intelligence, AFBIT Lite is a nice tool we already have that is probably underutilized:

1 Like

Trust it. Manually entered data is often unreliable; many tools report data that is incomplete or otherwise inaccurate.

I would like to maximize data lake and source data through dashboards. If the dashboard is incorrect then fix the source (no manual reports or explanations).

Relational databases can limit the data calls and give decision-makers fidelity in the information they base their decisions on.

Is it possible to tailor the workbooks for my agency? I have Tableau on my desktop.

I’m not sure if that is possible. At this point, I’ve just seen the AFBIT Lite results from Tableau. I have’t seen the data pipeline or data visualization process.

There’s an automatic feed to a SQL Server database. I am unable to break the link and load my agency’s data. Do you know who “owns” this? Perhaps if I were to speak with them they’d be willing to provide the dashboards without the data source. That would
allow me to load extracts from my agency and edit the fields.

All - for those of you following, I’m headed to Fort Collins, CO to work with the CON-IT contractors on BI efforts on the 12th and I’m taking this thread with me. If you have more questions of things you would like to do with BI - keep the comments coming. Thanks.

1 Like

Just a small tip - algorithms are subjective and can be easily fixed. Data organizaiton (data structures) and its relationships is king. Inversely, its poor data organization (poor usage and design of data structures) can screw up data.

Part of that organizaiton can be an audit table to go alongside with whatever data you’re messing with to capture who is making changes in the database that is of error.

This should help leave breadcrumbs to ensure corrective guidance and action is taken to correct bad manual entry. It also leaves breadcrumbs for faulty algorithms that results in poor automated entries too.

1 Like