Monitor Government policies with Embedded Analytics
Introduction
Embedded analytics empowers governments to track economic and social progress periodically. In this blog, I will provide a walkthrough of how embedded analytics can help governments improve schools and roads, and assure their constituents of improved educational opportunities and road safety.
What is embedded analytics?
Embedded analytics is the integration of analytical solutions and data visualization capabilities into a software application’s user interface to improve data comprehension and usability. Bold BI helps you easily embed an analytics solution into your everyday work applications using a JavaScript SDK and server application. It also enables you to reduce dependency on IT teams and delivers all the insights you need to improve organizational and workforce outcomes.
Benefits of embedded analytics in government
Embedded analytics helps a government satisfy its citizens’ needs by enabling the insight needed to pursue solutions in areas like education, public safety, public health, budgeting, and demographic-specific needs. Let’s explore how embedded analytics can help a government improve the following:
- Road accident prevention.
- Efficient traffic management.
- School grant distribution.
- School grant monitoring.
Road accident prevention
Embedded analytics can present metrics such as accident count by day of the week and monthly accident numbers to determine the rate of traffic accidents, as well as the locations of accidents. With this analytical information, the government can devise solutions like free educational seminars on traffic rules, free driving lessons for student drivers, and the expansion of specific roads. With these actions taken by the government, backed up by real data, the rate of accidents on roads can be reduced.
Efficient traffic management
Embedded analytics can use metrics such as contributing factors, accident count by vehicle type, and accident count by vehicle manufacture year to analyze the leading causes of road accidents. This analytical dataset gives the government qualitative information on how many pedestrians and travelers are affected by traffic accidents. Analyzing this data can help guide the government resolve some common accidents by building footbridges, increasing the number of traffic police, and designating more crosswalks. These measures assure pedestrians and drivers alike that the government is actively working to reduce traffic accidents, and in turn builds a good rapport between the government and its citizens.
School grant distribution
Embedded analytics can help a government determine the distribution of grants to schools. Using metrics such as total amount granted, recipient schools, and school details by amount granted, the government can analyze the distribution of grants to ensure equity in the distribution process.
School grant monitoring
By using embedded analytics, the government can monitor how schools spend grants. This keeps schools accountable to the government through metrics such as the overall number of schools that benefit from grants and the resulting improvements by school district.
Outside of education, the government can promote improvements in other sectors with embedded analytics by tracking budget spending periodically and allocating more funds when necessary.
How to embed analytics tools into government domain apps
Let’s see how analytics can be embedded into government web applications. Bold BI can embed your dashboards in more than 18 web platforms, including React with ASP.NET Core, React with Go, WinForms, Node.js, Vue with Go, Vue with Core. In the rest of this blog, I am going to explain how to embed dashboards into an Angular application.
Consider a scenario in which your company has a website like the one shown in the following image.
You can embed dashboards easily using Bold BI and avoid building an analytics or BI solution yourself. Follow these steps to embed your dashboard successfully.
Prerequisites
Download and install the Bold BI server in your local machine and create a dashboard. You can find the installation and deployment steps here.
Step 1: Create an Angular application.
To successfully embed a dashboard in your application, you first need to create an Angular application. Create a new Angular project in Visual Studio Code and add the necessary TS files to the project as shown in the following image.
For more guidance, refer to the sample code in the Bold BI documentation.
In this demonstration, the Angular application acts as a client, and an ASP.NET Core application acts as a server. You need to add several properties in the app.component.ts file, as shown in the following table and screenshot.
RootUrl : Bold BI dashboard server URL. Example: http://localhost:58094/bi.SiteIdentifier : For Bold BI, it should follow the format `site/site1`. For Bold BI Cloud Analytics Server, it should be an empty string.Environment : Your Bold BI application environment. If using Bold BI Cloud Analytics Server, you should use `cloud`. If using Bold BI, you should use `enterprise`.apiHost : An ASP.NET Core application would be run on http://localhost:5000/, which needs to be set as `apiHost`.
After adding these properties, we need to create the Bold BI instance.
Step 2: Create a Bold BI instance.
After the Angular web application is created, you need to create a Bold BI instance to communicate between the server side (any web application) and the client side (Angular application), which allows us to embed a Bold BI dashboard in the Angular application.
Step 3: Create an authorization server to authenticate the Bold BI server.
Every application that embeds a Bold BI dashboard or widget must be authorized with the Bold BI server. This authentication step requires sending confidential information to the Bold BI server, such as users’ email addresses, group data, and embed signatures. So, in your server application, implement this authentication flow and provide the URL for connecting to your server in the Bold BI instance.
Step 4: Run the Angular application to view the embedded dashboard.
In the Angular application, update the authorization URL and dashboard URL that were defined in the ASP.NET Core application. Finally, you can that see the dashboard created in the Bold BI server is embedded in your web application.
To learn more about embedding dashboards into your Angular applications, refer to this blog. You can also download the sample code used in the previous steps from our documentation.
Bold BI government solution dashboard examples
School Improvement Grants Dashboard
The School Improvement Grants Dashboard analyzes the benefits of grants awarded to schools using metrics such as total amount granted, number of schools implementing each intervention model, grants by category, the number of schools receiving grants, grants by state, and school details by amount granted. This helps the government come up with solutions for an equitable and rational distribution of grants.
Key metrics and KPIs
- Total amount granted: This shows the total amount of grants issued to schools for improvement.
- Number of schools implementing each intervention model: This presents the number of schools implementing each intervention model.
- Improvement grants by category: This shows improvement grant distribution by category.
- Improvement grants by state: This shows how much grant money each state received.
- School details by amount granted: This shows the list of schools organized by the amount of money received.
To learn more about the metrics and KPIs used in this dashboard example, refer to the Schools Improvements Grant Dashboard demo.
Motor Vehicle Accident Analysis Dashboard
The Motor Vehicle Accident Analysis Dashboard determines the rate of accidents on roads using metrics such as accident count by state, accident count by vehicle manufacture year, monthly accident numbers, contributing factors, accident count by day of the week, and accident count by vehicle type. This helps the government systematically analyze the data and come up with solutions to reduce the rate of accidents on roads.
Key metrics and KPIs:
- Accident count by state: This tracks accident counts in each state in the USA.
- Accident count by manufacture year: This shows the accident count based on the vehicle manufacture year.
- Monthly accident numbers: This shows the number of accidents that occurred monthly.
- Contributing factors: This reflects the number of accidents that happen due to factors like humans, the environment, and vehicles.
- Accident count by day of the week: This shows the accident count over a week.
- Accident count by vehicle type: This shows the accident count by the type of vehicle.
To learn more about the key metrics and KPIs used in the dashboard demo, refer to the Motor Vehicle Accident Analysis Dashboard example.
Conclusion
Bold BI helps you integrate dashboards in your applications written in ASP.NET Core, ASP.NET MVC, ASP.NET, and Ruby on Rails. It will save you time and prevent you from doing redundant work. Click this link to explore its features. To learn more about embedding dashboards into your application, refer to this blog and our help documentation.
I hope you now have a better understanding of Bold BI and how it can help governments be more successful. You can create a dashboard any way you like with Bold BI’s 35 widgets and 130 data sources.
Get started with Bold BI by signing up for a free 15-day trial and create interactive business intelligence dashboards. You can contact us by submitting questions through the Bold BI website or, if you already have an account, you can log in to submit your support question.
Originally published at https://www.boldbi.com on January 13, 2022.
