Tutorialspoint
Subscription Includes
 02:32:26 of High Quality Videos
 30  Lectures
 Full Lifetime Access
 Certificate on Completion
$ 25   20

Create a covid-19 Dashboard

Created by Karthik Parthasarathy, Last Updated 30-Jun-2020, Language:English

Create a covid-19 Dashboard

Learn How to Build A Covid-19 Dashbaord In ServiceNow

Created by Karthik Parthasarathy, Last Updated 30-Jun-2020, Language:English

What Will I Get ?

  • Integration With Covid-19 API
  • Create REST Request and Parse the Response
  • Create A load By Script Data Source
  • Create An Import Set - Transform Map
  • Schedule Import Data
  • Create Indicators-Indicator Source- Breakdown- Breakdown source- Breakdown Mapping- Job In PA
  • Create Formula Indicators- Scripts in PA
  • Create Score-Time Series- Breakdown Widgets
  • Create Dashboard - Configure Breakdown Filters

Requirements

  • ServiceNow Fundamentals
  • ServiceNow Scripting
  • Performance Analytics
  • Integration

Description

In this course, you will learn to create a Covid-19 Dashboard.

We will focus first on how to integrate two different Covid-19 api's, import all data (Historical and Daily Summary Data).

Then we will be creating different elements needed in Performance Analytics and finally we will build our dashboard.

The average duration of a lecture is 10 minutes.

By the end of this course, you should be able to build on your own any dashboard using some others API's.

Course Content

  • Introduction

    1 Lectures 00:02:40

    • Let's Me Present You Covid-19 Dashboard

      Preview
      00:02:40

  • Historical Data Integration

    7 Lectures 00:38:06

    • Create A Covid-19 Custom Table

      Preview
      00:03:54

    • Create A Before Business Rule

      Preview
      00:03:20

    • Create A REST Request In Flow Designer

      00:03:33

    • Parse Your Response

      00:09:59

    • Create A Load By Script Data Source

      00:08:22

    • Create A Transform Map

      00:01:54

    • Load All Historical Data To The Target Table

      00:07:04

  • Delete All Records

    1 Lectures 00:02:12

    • Let's Delete All Records and We Will Load Later

      00:02:12

  • Daily Covid-19 Cases Data Integration

    7 Lectures 00:37:46

    • REST Request To Corona API

      00:10:06

    • Create A Flow Designer Action To Send the Rest Request & Parse the Response

      00:10:06

    • Get Deaths Cases and Country

      00:03:40

    • Send a Request to get the Date

      00:01:12

    • Data Source - Load Your Historical Data

      00:01:52

    • Data Source -Load Your Daily Summary Into Your Staging Table

      00:07:54

    • Create and Run A Transform Map To Load The Daily Result

      00:02:56

  • Scheduled Data Import

    1 Lectures 00:01:34

    • Automate The Data Collection Process

      00:01:34

  • Data Cleaning

    1 Lectures 00:06:10

    • Delete Duplicates

      00:06:10

  • Perfomance Analytics

    10 Lectures 00:39:02

    • Theoretical Explanation Of Indicator and Indicators Source In PA

      00:04:00

    • Create Today's Country Summary Indicator Source

      00:01:16

    • Create Your Indicators

      00:02:59

    • Theoretical Explanation For Breakdown- Breakdown Source and Breakdown Mapping

      00:05:00

    • Create Country Breakdown Source and Country Breakdown

      00:02:48

    • Create PA Global Data Collection Job

      00:04:22

    • Create PA Data Collection Job For All Countries

      00:02:21

    • Total Active Cases Indicators -PA scripts-Job

      00:05:17

    • Let's Calculate The Mortality Rate For Some Countries - Create A Breakdown Source, Indicators And A Job

      00:07:17

    • Create A Formula Indicator For The Mortality Rate

      00:03:42

  • Set Up The Dashboard

    2 Lectures 00:24:56

    • Create Global Situation Report - Score Widgets- Chart Widget & Breakdown Widget

      00:11:06

    • Create A Country Specific Report- Score Widget- Time Series Widget

      00:13:50

Karthik Parthasarathy

I am all about exploring, finding new things, as a child I spent time to draw eventually habits were lost but now I am creating applications in servicenow. I am a full time creator. I can find problems that people may not see at first sight and work to find solutions, this isn't something you get from experience but it is more like an inspiration which can strike by looking inwards. I am delivering tailored Courses to incite people to create applications, creating Youtube content, at the moment more than 30 students, more than 600 followers benefit from my content. Explore all my courses and Enjoy The Ride !

More Courses from Karthik Parthasarathy