Page Comparison

Use this Setup Guide to install and configure your Chronic Absenteeism solution using test data. At the end of this Setup Guide you'll have a test environment which closely mimics a staging or production environment. This test environment allows your tech team, administrators and stakeholders to test configuration changes being considered for the production environment without an impact on end-users. It is important to note that this test environment is separate and distinct from the sample environment you accessed during the Quick Start.

It is important to note that this Setup Guide assumes that you have access to a certified Student Information System (SIS), which provides the data to power the dashboard.

The following steps to get this test environment up and running are very similar to the steps for setting up a production or staging environment.

Summary

Solution Overview

In this section you'll get a general understanding of the components of your Chronic Absenteeism solution to provide context for completing the remainder of the Setup Guide. The diagram below depicts the high level architecture and component interactions.

Once you complete this Setup Guide:

• Data from your Student Information System "SIS" will flow into your Operational Data Store (ODS) via the Ed-Fi ODS / API.
• Credentials and connections between your SIS and the ODS / API will be managed using the Ed-Fi ODS / API Admin App.
• The Chronic Absenteeism Power BI Starter Kit connects directly to the Ed-Fi ODS database and the Analytics Middle Tier to retrieve the data and use it to generate your Chronic Absenteeism Dashboard and Reports.

The core components involved in this solution are:

• A Student Information System (SIS).
• The Ed-Fi ODS / API & Tools, which include Ed-Fi ODS / API, Ed-Fi Admin App, and the Ed-Fi Swagger Documentation. 
• The Ed-Fi Analytics Middle Tier.
• Power BI Desktop, the application chosen to model, create and deliver the Chronic Absenteeism Dashboards.
• Power BI Online, which allows you to publish the dashboard and manage the different users and roles.

The rest of this guide will instruct you on:

• Installing these components.
• Connecting your SIS to the Ed-Fi ODS via the ODS / API.
• Connecting the Chronic Absenteeism Starter Kit application to your ODS.
• Using the Chronic Absenteeism Starter Kit to engage and support your staff, superintendent, principals, and teachers with your data.

Step 1. Install the Ed-Fi Solution

Step 2. Configure your SIS and Load Test Data

In this step you will load test data from your SIS to the Ed-Fi ODS / API so it can be available to the Chronic Absenteeism Power BI Dashboard. A pre-requisite for this step is that you have access to an an certified Student Information System (SIS), capable of sending data to the Ed-Fi ODS/API. 

Add Your Student Information System in the Admin App

Once you have successfully installed the Admin App following the instructions provided above you can continue to configure and add your "SIS" so that it can consume and write student data to the Ed-Fi ODS / API

• Follow the Admin App - Next Steps to configure your first Vendor and Application entry for your Student Information System. 
• Once you create an Application in the Admin App, you will store and use the generated "Key" and "Secret" in the next section.
  • Note: Treat the Key and Secret as secure information for your organization (because it will control student data exchange from your SIS).
  • Store it according to your local IT Security policy. Often this will be in a password keeper app, or on a secure file server, or similar method (check with your IT department).
• Note that other applications you may add over time, for example Assessment applications used in other Ed-Fi Starter Kits, will each have their own API Client credentials ("key" and "secret").

Configure Your Student Information System

Each SIS provider has its own vendor-specific configuration tool and steps to connect to the Ed-Fi ODS / API, perform basic data mapping, provide descriptors, and to enable you to begin loading data into your ODS / API. You will connect your SIS to your ODS / API using the URL, key and secret you generated in the Admin App. 

• Verify that your SIS supports Ed-Fi data interoperability, and is certified to use the ODS / API to allow you to use this starter kit: Registry of Ed-Fi Certified Products - Student Information Systems. 
• Submit a technical support ticket request with your SIS vendor to enable the Ed-Fi API client functionality for your district, and to provide you with their product configuration guide or instructions for configuring it. 
• Follow your SIS vendor's configuration guide to configure the product to connect to your ODS / API and prepare for loading your data.

See the General Reference page for a list of publicly known vendor configuration guides.

Map Your District Codes to the Ed-Fi ODS / API Descriptors

• Once your SIS is configured to connect with the Ed-Fi ODS / API, the next step to getting your data to the ODS / API is to map "code sets", or Descriptors, as they are known in the Ed-Fi data standard, from the data elements and codes used in your district's SIS to those you will use in the Ed-Fi ODS / API. To do this: 
  • Refer to your SIS vendor configuration guide you used above to locate and use the data mapping tools in your SIS application.
  • Proceed with your SIS vendor's data mapping instructions, referring to their configuration guide and the dependency chart provided above to work through the data mapping and loading in the right sequence.
• In the next step of this setup guide, you will use these descriptors to understand how your data is displayed in the Chronic Absenteeism Dashboard.
• Review the Best Practices for Descriptors presentation if you would like more background explanation of descriptors and why they're relevant to your needs.

Let the Data Flow from Your SIS into the Ed-Fi ODS / API

Quick recap:

• Using the Ed-Fi Admin App you configured and granted access to your SIS to be able to access the Ed-Fi ODS / API.
• Using the SIS configuration screen for E-Fi interoperability you added the Ed-Fi ODS / API URL, Key and Secret so that it could connect to the API.
• Using the SIS configuration screen for codes and descriptors you mapped your District's codes to the Ed-Fi Standard Descriptors.

Now you are ready to let the data flow into Ed-Fi. Contact your SIS vendor support team and together launch the necessary processes to let the data flow into the Ed-Fi ODS / API. 

Note: That it is always a good idea to do this together with your SIS vendor support team so that both of you can see if there are any issues preventing data from the SIS to flow to the API. Some of the most common issues are: Network connectivity issues, Data quality issues among others.

If you run into any issues, please do not hesitate to contact your Ed-Fi Alliance representative via one of the support channels provided in the /wiki/spaces/SK/pages/21992742 for troubleshooting guidance.

Step 3. Install and Test the Chronic Absenteeism Dashboard

In this step, you'll install Power BI prerequisites and download and run the Chronic Absenteeism Dashboards. 

Prerequisites

• At this point you should have an operational Ed-Fi ODS / API with data flowing from your SIS.
• Additionally, you installed the AMT views on your ODS database.
• You will also need a machine that has access to the ODS database and has Power BI Desktop installed.

Install Power BI Desktop

The Chronic Absenteeism Dashboard was built with Microsoft's Power BI Desktop application.

To run the dashboard you will need a machine with:

• Access to the database server where you installed the Ed-Fi ODS database
• Power BI Desktop that can be downloaded at this link: https://powerbi.microsoft.com/en-us/downloads/

Download and configure the Chronic Absenteeism Dashboard

The latest version of the Chronic Absenteeism Power BI Dashboard file is located in a GitHub repository.

Use the machine that has Power BI and create the following folder structure: C:\Ed-Fi\QuickStarts\CHRAB\.

Save this file onto that location by clicking this link: https://github.com/Ed-Fi-Exchange-OSS/Chronic-Absenteeism-Dashboard/raw/main/ChronicAbsenteeismDashboard.pbix.

Once the download completes, navigate to the folder where you downloaded the file and double-click it. This should open Power BI and load the Chronic Absenteeism Dashboard as depicted below:

The data that is pre-populated is the sample "Grand Bend ISD" Populated template.

To connect to your Ed-Fi ODS, use the top menu and navigate to Home and then Transform Data. Click the dropdown arrow and select "Data source settings".

When the modal opens click on the "Change Source..." button.

A second modal will popup with inputs to configure your SQL Server server connection. Use the IP address or the hostname of the server that contains the database. Then input the name of your Ed-Fi ODS database. Usually the name of your database will be Ed-Fi_ODS.

Depending on the kind of security that is configured in your organization you can use integrated or SQL server security. 

Once you click OK it might show you a few screens with SQL statements that it will ask you to run. Say OK or Run on them.

Additionally, it might show you the following screen:

This is where you can switch from Windows Integrated Security to MsSQL security if you desire.

Proceed to click on connect and accept the defaults.

You will see a screen that will load data from your ODS like the one bellow. Note that it might take a minute or two to finish loading. This depends on the amount of data and students you have in your Ed-Fi ODS.

Once it finishes loading you will be presented with the Chronic Absenteeism Dashboard and it will be displaying your data. 

If you haven't already done so, visit the Chronic Absenteeism Dashboard Walkthrough to learn more about how to use the Chronic Absenteeism Dashboard.

Step 4. Publish the Chronic Absenteeism Dashboard

The goal of this step is to publish the Chronic Absenteeism Dashboards to the Power BI Online service so that your users can login and view the reports. 

Basic Power BI Online Setup 

We will guide you through some of the basics around Power BI Online.

For this dashboard to work you will need:

• A subscription to Power BI Online
• A few users created in Office 365 
• A Workspace to be able to publish the dashboard

Creating Users in Power BI Online

If you already have users created in your Power BI account you can skip to the next section.

To create users follow these simple steps:

• Login to Power BI Online
• Click on the menu on the top left of the screen and select  as depicted below.

• This will open the 365 admin center. From here click on  button indicated on the image below.

• This will open a modal window that will allow you to add a user. Follow the instruction on that modal to create a user.
• It is important to note that the users email address in Power BI should be the same as the ones in you SIS and in the Ed-Fi ODS. This is how we match the user that is logged in with a role in the Ed-Fi ODS.
• You can repeat this process to add all the users that will be accessing the Chronic Absenteeism Dashboard on Power BI

Creating a Workspace to Hold the Dashboard

Back on the main screen of Power BI Online click on the menu icon and then on the "Workspaces" subsection. This will expand a side modal where at the bottom you have a "Create a workspace" button. Click that button and on the right a slide out form will appear. This is slide out form allows you to create the workspace. Name it something meaningful. For sake of this demo we named it "Ed-Fi Demonstration Workspace".

At this point you are done with this step.

Publishing the Dashboard

Open Power BI Desktop and Sign in with the account that has access to publish to Power BI online.

Proceed to locate and click on the "Home → Publish" menu entry as depicted below.

This will open a modal popup window. Select the workspace you created in the section above and click on the "Select" button.

In a few seconds you will see the modal popoup indicating that ti is publishing. When done you will see a "Success!" message.

To confirm, we recommend that you login into Power BI Online and ensure you can see the Dashboard.

To do this open your favorite browser and navigate to https://powerbi.microsoft.com/ and login.

Click on your workspace and you should see the "ChronicAbsenteeismDashboard" in the list.

Enabling Security on the Report

The report comes configured with a "Dynamic Security Role". To enable it in Power BI Online follow these steps:

Open your browser and navigate to Power BI Online. Then proceed to open the workspace where you published the "Chronic Absenteeism Dashboard" report. Ensure that the "All" submenu has been selected and click on the context menu for the row showing the "Dataset". In the context menu select the security option.

In the row level security page ensure you click the "Dynamic Role" and then add either a role or individual users that will be able to view the report.

Once you are done adding groups or users to the members section click on the "Save" button.

To test the security hover over the "Dynamic Role" and click on the context menu then select "Test as role"

This will load the report and you should see the widgets show blank data as most likely the user you are using will not be part of the security.

On the top blue menu click on "Now viewing as: Dynamic Role" and enter an email of a user that you configured previously. In this case we are going to use David Wilson who is a District Superintendent for Grand Bend ISD. This is our sample data set. Upon selecting the user you should see the report refresh and show only the data that that user can see. 

Explore by impersonating other users.

Here is a screenshot impersonating "Alicia Cameron" who is a principal at "Grand Bend Highschool"

As you can see this user's widget numbers are reduced as she can only see students associated at the Highschool level.

Once a real user logs in the will see the data filtered out to only what they have access too.

Inviting/Sharing the Workspace with Users

There are a few ways you can allow users to see the dashboard you previously published to Power BI Online. The easiest 2 are to grant individual users or groups to be able to visualize. Here are the steps you need to follow to grant users access:

Back in Power BI Online navigate to Workspaces and select the workspace you created previously. Make sure that you select
"All" in the working panel submenu this way you will see the "Report" and the "Dataset" listed in the grid.

Hover on top of the "Report" and a share icon will appear. Clicking on it will show a right slide out form. In this form you can search for the users by name or email and share the report with them.

Please note that there are a few checkboxes that give you additional options. Review them carefully as they allow for additional sharing and editing options. 

Continue adding users by searching for them by name or email.

Once done click on the "Share" button.

In a few seconds you will see a confirmation modal mentioning that the report has been shared successfully!

Additional Recommended Reading and Live Dataset Connectivity

We recommend reading the following articles. They explain how to setup a live database connection from Power BI Online to your Ed-Fi ODS SQL Server database.

• Establish a Power BI service live connection to the published dataset
• Connect to on-premises data sources with a Power BI gateway
• Azure SQL Database with DirectQuery

Success! You are Ready to Plan Your Rollout and Production Deployment with your Team.

At this point you have completed all the steps required to launch your "Chronic Absenteeism Dashboard" with your organization.

We always recommend doing a small pilot group so that they help by looking at data and provide feedback on the displayed metrics.

Exploring the Dashboard

Follow the use cases and guide described in: v1-Chronic Absenteeism Dashboard Walkthrough.