You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

The answers to every question are sent to the backend SQL Server by a custom log call, and then moved into PowerBI. This log call is called in the Outcome blocks. When you add / change content that affects that log call, you will need to work with the Data Team and test to make sure the changes are coming through correctly. Changes to the Outcome blocks will likely happen when you add questions, add answer choice, remove answer choices, etc. 


Working with the Data Team / Testing Outcomes

After you have finalized the new Outcome block content:

  1. Update the Excel Index-Mapping sheet with the new information
    1. This mapping sheet keeps track of all of the properties in the Outcome block. The properties map to questions, the question answer choices, and for each answer choice the textual content and the index of the choice. 
  2. Send the index mapping Excel file to Ravi and let him know of the changes. He will tell you if there are problems or if he has to make new queries.

  3. Start running through full end-to-end tests using https://covid19healthbot-dev.cdc.gov/.

  4. If Ravi doesn't have to make new queries, or he has finished making them.

    1. Go into PowerBI and refresh the data source

    2. Refresh the page

Make sure you open a new tab for each test. Refreshing the page restarts the bot but it doesn't create a new session. If you don't open on a new tab, it'll use the same session and the data in PowerBI will be useless. 

The current dev instance in PowerBI is labeled DevV4. Ravi will inform you if that changes.


  • No labels