ServiceNow System Administrator Curriculum
Introduction to Business Intelligence

  • Business Intelligence
  • Data Integration
  • Data Processing
  • Data Presentation
  • ETL Architecture
  • Introduction to Data Analytics.
  • Types of Data Analytics.
  • Descriptive Analytics
  • Diagnostic Analytics
  • Predictive Analytics
  • Prescriptive Analytics
  • Analytics & Applications

Introduction to Tableau

  • Introduction to tableau
  • Overview & Features
  • Connecting Tableau to Data Sources
  • Working with Flat files
  • Connecting spreadsheets

Data Extraction

  • Introduction to Database
  • Creating Database & Table
  • CRUD Operation on database tables
  • Basic SQL Operations

Architecture of Tableau

  • Architecture of Tableau
  • Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
  • Tableau field types
  • Saving and publishing a data source
  • Live vs extract connection
  • Various file types
  • Ways to share and export the work done in Tableau

Data Visualization
Charts:-

  • Histograms
  • Box plot
  • Pie
  • Bar
  • Line
  • Bubble
  • Bullet
  • Scatter
  • Tree
  • Heat maps
  • Maps
  • Text table
  • Highlighted table

Working with Metadata and Data Blending

  • Connecting to Data Source
  • Tableau data types
  • Connection to Excel
  • Cubes and PDFs
  • Management of metadata and extracts
  • Joins (Left, Right, Inner, and Outer) and Union
  • Data blending
  • Data preparation


Advanced Data Manipulations

  • Mark and highlight
  • Groups
  • Sets
  • Bins
  • Hierarchies
  • Sorting and Types
  • Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
  • Editing axes and annotations

Working with Filters,Organizing Data & Visual Analytics

  • Working with Filters
  • Filters (addition and removal)
  • Filtering continuous dates, dimensions, and measures
  • Filtering in Tableau
  • Types of filters
  • Filtering the order of operations
  • Organizing Data and Visual Analytics



Working WIth Mapping ,Calculations and Expressions

  • Working on coordinate points
  • Plotting longitude and latitude
  • Editing unrecognized locations
  • Working on the background image
  • Map visualization, custom territories
  • Calculation syntax and functions in Tableau
  • The creation of calculated fields
  • Quick table calculations

Working with Parameters

  • Creating parameters
  • Parameters in calculations
  • Using parameters with filters
  • Column selection parameters
  • Chart selection parameters
  • How to use parameters in the filter session

Dashboards and Stories

Dashboard & Stories
Building and formatting a dashboard using size, objects, views, filters, and legends
Best practices for making creative as well as interactive dashboards using the actions

  • Including the intro of story points
  • Creating as well as updating the story points
  • Adding catchy visuals in stories
  • Adding annotations with descriptions; dashboards and stories
  • Highlight actions, URL actions, and filter actions
  • Selecting and clearing values
  • Dashboard examples using Tableau workspace and Tableau interface

Build Tableau Web Application

  • Introduction to Flask
  • Working with Flask Framework
  • Building application with flask framework
  • Embedding Dashboard & Story with web application