Chief Data Officer
Carlos Rivero


Data Intelligence-as-a-Solution

Actionable business intelligence derived from data is how successful operational, tactical, and strategic business decisions are made. The Office of the Chief Data Officer Data Intelligence (DI)-as-a-Solution is a value-added component to participating in the Commonwealth Data Trust and provides Commonwealth of Virginia agencies the infrastructure, system lifecycle administration services, and human resources needed to manage the deployment and consumption of business intelligence products. This gives agencies the ability to publish the business intelligence products they need without having to invest valuable resources to develop and manage their own DI infrastructure. Thus, allowing agencies to spend more time focusing on the services they provide to the people they serve.

The Infrastructure

The Office of the Chief Data Officer has invested in a Microsoft PowerBI test and production environment connected to a SQL server enterprise database that serves as the production business intelligence environment. This environment can also connect to other Commonwealth data repositories like the Secure Connected Government Cloud and the Open Data Portal through APIs and other production databases through data adapters on DataSAGE (Secure Analytics and Governance Environment). This service offers three main authentication schemes:

  • Commonwealth of Virginia Account – specifically engineered for COV-named users within the COV network for internal use only.
  • Public – this option offers public-facing, public-access reports, visualizations, and dashboards that leverage Commonwealth data assets increasing public awareness and engagement.
  • Hybrid – this is a solution that combines the public-facing and named users approach. This environment is public-facing and Internet accessible but not anonymous. Users need an authorized non-COV account to login to the environment to access DI products. This is a robust capability that allows agencies with external stakeholders to provide access to privileged datasets, reports, visualizations, and/or dashboards without requiring a COV account.

By providing this infrastructure, agencies can focus on the development of reports, visualizations, and dashboards without having to worry about managing the technologies, infrastructure, or tools.

The Lifecycle Development

When agencies are ready to test what they have built, they simply send the deployment package to the Office of the Chief Data Officer for the BI infrastructure team to deploy it on the test platform. The development team from the agency and associated stakeholders will have access to the test environment to make sure everything works correctly before deploying to the production PowerBI server. This approach aligns well with system development best practices where the development teams do not have access to the test and production environments thus creating clear separation of duties between the various teams. 

The Human Resources

If agencies don’t have the development resources or DI teams in house, the Office of the Chief Data Officer can help identify which statewide contracts agencies can use to engage vendors providing the services and support needed to implement their desired DI solution. In addition, the CDO has partnered with multiple academic institutions through the Commonwealth Data Internship Program to connect talented students and research faculty with state agencies. This program provides students with real-world professional experiences while using data to solve relevant agency issues. 

The Data Intelligence-as-a-Solutions is offered to provide Commonwealth agencies the support and tools they need to make informed, data-driven decisions by leveraging data analytics and business intelligence.

Interested in learning more about PowerBI? Explore the learning paths and modules with step-by-step guidance on the Microsoft website.

Visit the CDO's intelligence reports website for examples of agency reports utilizing the DI solution.

Data Documentation Process

The Data Documentation Process enables data stewards from different agencies to connect to the Enterprise Data Catalog and run a local tool that allows them to connect to their respective databases and then register the metadata for the tables and views they select. This process empowers and engages the data stewards in a meaningful way and gives them the authority to identify and register their highest value data assets.

Once the data stewards register a data asset, a project workflow is initiated, notifying the Data Team Leads on the appropriate documentation team that there are new data assets ready for documentation. The designated Data Team Lead assigns the registered data assets to their team. An example of this process are the apprentices participating in the Rural IT Apprenticeship Program. These individuals work on the data asset documentation including characteristics like descriptions, data types, business glossary tags, NIEM data elements, and data security classification tier, etc. 

Once the data assets are well documented, the student apprentices tag them for review which notifies the agency data steward. If the data asset documentation is approved by the data steward it can be published into the Enterprise Data Catalog. 

This workflow allows the data asset to be automatically harvested by DataSAGE and incorporated into the Enterprise Data Catalog.

Framework for Addiction Analysis and Community Transformation (FAACT)

Secure and appropriate data sharing across government agencies not only allows those agencies to provide better and faster services, but also provides benefits to the communities and residents they serve. During the 2018 legislative session, the General Assembly created the position of the Chief Data Officer (CDO) for the Commonwealth of Virginia mandating the CDO work on a pilot project to demonstrate the value of data sharing and analytics as a response to the opioid crisis. Governor Northam appointed Carlos Rivero as the Commonwealth's first CDO in July 2018. The Virginia Department of Criminal Justice Services worked with the CDO to develop and pilot a data-sharing platform that could respond to the opioid crisis in the Northern Shenandoah Valley. DCJS contracted with Qlarion Inc. to develop the platform built on Tyler Technologies' Secure Connected Government Cloud and Amazon Web Services. The pilot program has now become the Framework for Addiction Analysis and Community Transformation (FAACT) providing a wide-variety of data and powerful self-service analytics supporting community leaders as they respond to the crisis. The organizations that have contributed data so far and are part of the FAACT Data Trust include Federal, State, Local and Private organizations:

  • DCJS
  • Local Corrections
  • Virginia State Police
  • Community Service Board
  • Virginia Dept. of Forensic Sciences
  • Winchester Police Department
  • Private Healthcare System
  • U.S. Census and Bureau of Labor


Due to the success of the program, it has now expanded to the Roanoke Valley and Southwest Virginia. This program proves the value of sharing data across agencies, localities, and community organizations in a way that facilitates responsive, data-driven, evidence-based decision-making leading to better outcomes for our residents. Read the Governor’s press release or the media articles below to learn more about how the program is successfully responding to the opioid crisis in Virginia.