Skip to main content

Awarded

This bid has been awarded to Sierra Systems Group Inc..

Thank you for your submission!

Download Investigations and Enforcement Tabular Model Description

Additional Files

Description

The BC Oil and Gas Commission is inviting vendors with standing offers under RFSO 21021001 to design and develop an ETL process and a tabular model within the Commission’s data warehouse.

Amendments

There are no Ammendments at this time.

Questions and Answers

If you have any questions about this posting, please email procurement@bcogc.ca.

  • 1. How does the Commission plan to test this model? Who will perform the UAT and who will read the UAT results?

    We have a test BI environment, where we are hoping to use for development and testing. Usually we load the model in Power BI Desktop to analyze the model.

    Initial UAT will be performed by the BI team (most likely Jason and me). Once we think the model is working as expected, we will bring in functional users to confirm the data, measures, etc.

    We also have some existing reporting that will be used as a comparison.

  • 2. Will the excel spreadsheet that captures the investigations and enforcement information is one-time or re-occurring?

    The spreadsheet is the legacy “database” that have some ongoing investigations. Over time as these “ongoing” investigations are resolved (some can take years), the spreadsheet will be deprecated. However, for reporting, we would still need access to data from the spreadsheet for at least a decade.

  • 3. What program does the Commission use for data modeling?
    • The Commission generally uses Oracle data modeller for operational system work (our primary operational database in Oracle)
    • Our previous contractor, used SQL Server Management Studio to model data for the data warehouse (and should be available on our BI developer workstations)
    • The BI team uses Power BI to mock up quick data models for ad-hoc reporting purposes

Competition ID: RFQ21421010