{"sectionGroup":{"sections":null},"DashboardExample":{"display_title_text":"Cyber Security Team Analytics Dashboard","display_title_icon":false,"dashboard_icon":false,"show_on_category_page":true,"category_page_summary":"Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk.","solution_page_title":"","solutions_page_summary":"","cloud_trial_dashboard_id":"5d6fc86ecc6db20b8c805731","dashboard_screenshot":false,"has_implementation_kit":true,"technical_content":"

<\/p>\n

Goals<\/h3>\n
Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n

Objectives<\/h3>\n
\n
Monitor Number of Security incidents and Tickets over time<\/li>\n
Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/li>\n
Monitor Response teamwork and Average Time to Resolution<\/li>\n
Discover the correlation between Number of Incidents and Security Rating<\/li>\n<\/ul>\n
KPIs Architecture<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n<\/td>\n \n
Objective<\/strong><\/p>\n<\/td>\n
\n
KPI’s<\/strong><\/p>\n<\/td>\n
\n
Measures<\/strong><\/p>\n<\/td>\n
\n
Data source<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n
Monitor Number of Security Incidents and Tickets over time<\/p>\n<\/td>\n
\n
Number of Incidents<\/p>\n<\/td>\n
\n
count([Incident ID])<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Average Incidents per Employee<\/p>\n<\/td>\n
\n
AVG([Employee ID],[# of unique Incident ID])<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
DIM Employee<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Number of Tickets<\/p>\n<\/td>\n
\n
count([Ticket ID])<\/p>\n<\/td>\n
\n
FACT Tickets<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Number Of Incidents per Ticket<\/p>\n<\/td>\n
\n
count([Incident ID])\/[# of unique Ticket ID]<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
FACT Tickets<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Open Security Incidents<\/p>\n<\/td>\n
\n
(count([Incident ID]),[Status]=”Open”)<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
DIM Response Team<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Resolved Security Incidents<\/p>\n<\/td>\n
\n
(count([Incident ID]),[Status]=”Closed”)<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
DIM Response Team<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Open Tickets<\/p>\n<\/td>\n
\n
([# of unique Ticket ID],[TicketStatus]=”Open”)<\/p>\n<\/td>\n
\n
FACT Tickets<\/p>\n
DIM Response Team<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n
Resolved Tickets<\/p>\n<\/td>\n
\n
([# of unique Ticket ID],[TicketStatus]=”Closed”)<\/p>\n<\/td>\n
\n
FACT Tickets<\/p>\n
DIM Response Team<\/p>\n<\/td>\n
\n<\/td>\n<\/tr>\n
\n<\/td>\n \n
Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n
\n
Number Of Incidents per Incident Type and Malware Type<\/p>\n<\/td>\n
\n
count([Incident ID])<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
DIM Incident<\/p>\n<\/td>\n<\/tr>\n
\n<\/td>\n \n
Number Of Incidents per Malware Type and broken by Risk Level<\/p>\n<\/td>\n
\n
count([Incident ID])<\/p>\n<\/td>\n
\n
FACT Incidents<\/p>\n
DIM Incident<\/p>\n<\/td>\n<\/tr>\n
\n<\/td>\n \n
Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n
\n
Number of Incidents per State<\/p>\n<\/td>\n
\n
count([Incident ID])<\/p>\n<\/td>\n
\n
DIM Incident<\/p>\n<\/td>\n<\/tr>\n
\n<\/td>\n \n
Discover the correlation between Number of Incidents and Security Rating<\/p>\n<\/td>\n
\n
Number Of Incidents Vs. Security Rating Over Last Quarters<\/p>\n<\/td>\n
\n
count([Incident ID])<\/p>\n
AVG([Quarters in Date],[# of unique Incident ID])<\/p>\n
MEDIAN([Security Rating])<\/p>\n<\/td>\n
\n
DIM Date<\/p>\n
FACT Incidents<\/p>\n<\/td>\n<\/tr>\n
\n<\/td>\n \n
Monitor Response teamwork and Average Time to Resolution<\/p>\n<\/td>\n
\n
Average Number of Incidents Per Response Team Member Over the 15 Months (Full)<\/p>\n<\/td>\n
\n
count([Incident Owner]),<\/p>\n
AVG([Team Member ID],[# of unique Incident ID])<\/p>\n
AVG([Months in Date],AVG([Team Member ID],[# of unique Incident ID]))<\/p>\n<\/td>\n
\n
DIM Date<\/p>\n
DIM Response Team<\/p>\n
FACT Incidents<\/p>\n<\/td>\n<\/tr>\n
\n<\/td>\n \n<\/td>\n \n
Response Time (Days) by Sub Response Team, Broken by Risk Level<\/p>\n<\/td>\n
\n
(avg([Response Dwell ( Days)]),[Risk Level]=”Critical”)<\/p>\n
(avg([Response Dwell ( Days)]),[Risk Level]=”High”)<\/p>\n
(avg([Response Dwell ( Days)]),[Risk Level]=”Medium”)<\/p>\n
(avg([Response Dwell ( Days)]),[Risk Level]=”Low”)<\/p>\n<\/td>\n
\n
DIM Response Team<\/p>\n
FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Plugins and Scripts<\/h3>\n
Blox<\/u><\/p>\n
https:\/\/www.sisense.com\/marketplace\/blox-widgets\/<\/a><\/p>\n
Image Widget<\/u><\/p>\n
https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard<\/a><\/p>\n
Add Custom Palette<\/u><\/p>\n
https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0<\/a><\/p>\n

Widget Background Script<\/u> <\/u><\/p>\n
widget.on(‘processresult’,function(w,e){<\/p>\n
     e.result.plotOptions.series.dataLabels.style.color = “white”;<\/p>\n
     e.result.plotOptions.series.dataLabels.style.fontSize = “12px”;<\/p>\n
     e.result.plotOptions.series.dataLabels.style.fontWeight = “light”;<\/p>\n
})<\/p>\n
widget.on(‘domready’, function(se, ev){<\/p>\n
$(‘.widget-body’ ,element).css(‘fill’,’#2D5874′);<\/p>\n
$(element).css(‘background-color’,’#2D5874′);<\/p>\n
     $(‘.highcharts-axis-labels text’).css(‘fill’,’white’);<\/p>\n
     $(‘.highcharts-legend-item text’).css(‘fill’,’white’);<\/p>\n
})<\/p>\n","implementation_kit_download":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/CyberSecurityAnalytics.zip","documentation_link":"https:\/\/documentation.sisense.com\/latest\/content\/verticals.htm","kpi":false,"dashboard_example_categories":[{"category":{"isSticky":false,"id":25717,"title":"IT","uri":"\/dashboard-examples\/it-oem\/","content":"
\r\n
What is an IT dashboard?<\/h3>\r\n
An IT dashboard provides users with an instant visual representation of their IT KPIs. Sisense\u2019s IT operations analytics<\/a> dashboard examples allow CIOs and IT experts to measure the performance of an IT organization\/department, identify what improvements are needed and which solutions are not working properly. At the end of the day, an IT dashboard will present IT data in a clear way that will ultimately help save money and improve performance.<\/p>\r\n
Learn More About Dashboard Examples<\/a><\/p>\r\n<\/div>","excerpt":"Track the metrics that matter to your IT department.","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":""}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png"}}}}],"dashboard_roles":"IT Manager, Cyber Security Manager, Data Engineer, Analyst","connector":[{"connector":{"isSticky":false,"id":16861,"title":"SQL Server","uri":"\/data-connector\/sql-server\/","content":"\r\n
Ad-hoc reporting for SQL Server has never been easier.<\/h2>\r\n\r\n\r\n
Sisense's native connectivity to Microsoft SQL Server enables you to quickly import all the data you need, run ad-hoc queries, join SQL Server tables with other databases, and create dashboards and data visualizations - without taxing your production database and without having to write endless lines of code.<\/p>\r\n\r\n\r\n
Why Sisense is the perfect BI tool for SQL Server users:<\/h3>\r\n\r\n\r\n
\r\n\t
Instant deployment:<\/b> Connect Sisense BI to your SQL Server instantly and with zero IT involvement or custom development. The SQL Server connector is available out-of-the-box upon downloading Sisense, and you can try it on your data today<\/a>.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
EDW reporting:<\/b> Already have a single source of organizational truth? Use Sisense on top of your enterprise data warehouse to save IT resources and give business analysts and users the ability to perform agile, exploratory data analysis.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
Built-in analytical data mart:<\/b> Quickly and easily import your data from SQL Server into the Elasticube - a proprietary, high-performance columnar database that lets you query complex datasets at 100 times the speed of OLAP or in-memory solutions.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
Cross-database joins with the click of a button:<\/b> Want to join tables from multiple sources? No big deal: our automated ETL makes it as simple as dragging-and-dropping. Need to cleanse or enrich data? Do so by creating custom tables, columns and SQL statements.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
Visual analytics:<\/b> The days of writing hundreds of lines of code to produce ad-hoc analysis<\/a> & reports for business users are over. Manage your data in a visual environment and let our patent-pending technology do all the rest. Joins performed on-the-fly at query execution time, simplifying the lengthy data modeling and query optimization processes that would otherwise be required.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
SQL Server dashboards keep everyone in the loop:<\/b> Use dozens of data visualization options to bring your data to life in impressive web dashboards that anyone in the business can access and explore at any time, bringing everyone relevant stakeholder closer to their data.<\/li>\r\n<\/ul>\r\n\r\n\r\n
\r\n\t
Single-Stack solution:<\/b> Sisense takes you from ETL to visualization in a single BI tool<\/a>, with every step in the process streamlined for maximal simplicitiy and efficiency. Give business users the ability to explore data independently within a governed environment, without slowing down your production database or bothering IT for every new query.<\/li>\r\n<\/ul>\r\n\r\n\r\n
Video: Connecting to SQL Server in seconds<\/h2>\r\n\r\n\r\n
<\/iframe><\/p>\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To get started with the Sisense-SQL Server connector, follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/sql-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Microsoft_SQL_Server_Logo1.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Microsoft_SQL_Server_Logo1.png"}}}},{"connector":{"isSticky":false,"id":16840,"title":"Oracle","uri":"\/data-connector\/oracle\/","content":"\r\n<h2>Expand Your Analytics\u2019 Reach With Sisense and Oracle<\/h2>\r\n\r\n\r\n<p>Oracle makes the world\u2019s most connected and well-integrated hardware-software solutions and systems designed for business. With such comprehensive tools come extensive data gathering and analysis needs that many systems aren\u2019t capable of handling out of the box. By combining Oracle\u2019s solutions with Sisense <a href=\"\/product\/\">data analytics tools<\/a>, you can create more accurate reports and visualizations based on <a href=\"https:\/\/www.sisense.com\/glossary\/real-time-analytics\/\">real-time data<\/a>.<\/p>\r\n\r\n\r\n<p>Sisense lets you share Oracle systems data much faster, gaining better <a href=\"\/product\/impact\/\">bi insights<\/a> with interactive and intuitive analytic tools alongside easy-to-use interfaces.<\/p>\r\n\r\n\r\n<h2>The Benefits of Sisense and Oracle<\/h2>\r\n\r\n\r\n<p>Integrating Oracle and Sisense tools grants you a variety of key advantages:<\/p>\r\n\r\n\r\n<ul>\r\n\t<li><strong>Organize Real-Time Data With ElastiCube: <\/strong>With massive data streams, organization and ease of access become vital. Sisense\u2019s <a href=\"https:\/\/www.sisense.com\/product\/mash-up\/elasticube\/\">ElastiCube<\/a> structures allow you to organize, store, and access data in a simpler and more granular way for better visualizations and insights.<\/li>\r\n\t<li><strong>Connect to Powerful Visualization Tools:<\/strong> Large data sets are unwieldy and can be hard to properly understand in many cases. By connecting with Sisense <a href=\"\/dashboard-examples\/\">dashboards<\/a>, you can simplify the discovery process by building accurate, real-time visualizations that can provide enhanced insights.<\/li>\r\n\t<li><strong>Access and Create Reports When They Happen:<\/strong> A major issue with large data sets is the wait to convert them from raw figures into actionable insights. By feeding Oracle data into Sisense analytics tools, you can speed up the process of generating reports to gain access to the most up-to-date information.<\/li>\r\n\t<li><strong>Improve Dashboards With Real-Time Data:<\/strong> Dashboards are only as good as the insights they deliver. Connecting Oracle tools to Sisense dashboards gives you a more accurate view in real time of what is happening with your software and hardware.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-6 col-md-offset-1\">\r\n<h2>Getting Started<\/h2>\r\n\r\n\r\n<p>To get started with the Sisense-Oracle connector, follow the instructions listed <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/oracle-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-oracle1-11.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-oracle1-11.png"}}}},{"connector":{"isSticky":false,"id":16835,"title":"MySQL","uri":"\/data-connector\/mysql\/","content":"\r\n<h2>Seamless End-to-End Analytics and Reporting<br \/>\r\nfor MySQL with Sisense BI<\/h2>\r\n\r\n\r\n<p>Using Sisense with your MySQL database is the perfect solution for business intelligence, data visualization and <a href=\"\/reporting\/\">ad-hoc SQL reporting<\/a>. The built-in connector will allow you to connect to data stored in your MySQL <a href=\"\/glossary\/relational-database\/\">relational database<\/a> with the click of a button and immediately start importing data into Sisense's ultra-fast, ultra-scalable <a href=\"https:\/\/www.sisense.com\/product\/analyze\/technology\/\">In-Chip data engine<\/a> - and proceed to combine MySQL data with a multitude of structured and unstructured data sources, and quickly create analytical reports and dashboards for rapid insights.<\/p>\r\n\r\n\r\n<h2>Benefits of Sisense on MySQL<\/h2>\r\n\r\n\r\n<p>Some of the unique advantages of using Sisense to prepare, analyze and visualize data stored in MySQL include:<\/p>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Native Connectivity:<\/b> Import all your data into the Sisense Elasticube, or only the specific tables you need, all with the click of a button and without any scripting or coding.<\/li>\r\n\t<li><b>Simplify business analytics for complex data<\/b>: Easily access relational data stored in MySQL and combine it with tables from various other <a href=\"https:\/\/www.sisense.com\/data-connectors\/\">databases, flat files and cloud sources<\/a>, then visualize and share the results for a complete analytical solution.<\/li>\r\n\t<li><b>Immediate query retrieval:<\/b> Skip past MySQL limitations for working with Big Data and always get immediate answers to ad-hoc questions, regardless of data size or complexity.<\/li>\r\n\t<li><b>Visual data preparation with built-in ETL:<\/b> Manage highly complex data models via an intuitive visual environment, and use <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/using-sql.htm\">custom SQL<\/a> for data manipulation, custom tables and advanced data preparation. Connect multiple data sources without altering the original structure or model of the data to minimize data preparation and skip straight to the insights.<\/li>\r\n\t<li><b>MySQL dashboard builder<\/b>: Create beautiful interactive dashboards that refresh automatically at near real-time, empowering any business user to create immediate value out of your MySQL data.<\/li>\r\n\t<li><b>Minimal IT \\ internal scripting:<\/b> Enjoy all the regular benefits of Sisense\u2019s intuitive, end-user oriented interface to quickly get up and running without mass investment in IT or technical resources.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n\r\n\r\n<p>To start using the Sisense-MySQL connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/mysql-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Nick","lastName":"Arcuri","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-mysql1.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-mysql1.png"}}}},{"connector":{"isSticky":false,"id":16842,"title":"PostgreSQL","uri":"\/data-connector\/postgresql\/","content":"\r\n<h2>Boost your Postgres database reporting and analytics with a complete BI tool<\/h2>\r\n\r\n\r\n<p>Storing your data in Postgres can carry unique advantages in terms of speed, stability and support for large data volumes. However, to fully leverage the potential of your organization's data you need an <a href=\"\/why-sisense\/\">agile BI tool<\/a> that can enable busines users to connect directly to your database, create cross-database joins and allow you to iteratively ask and answer questions in a visual environment, without having to write SQL queries or overloading the IT pipeline.<\/p>\r\n\r\n\r\n<p>Sisense provides reporting tools and analytics for any SQL-based database, including Postgres, <a href=\"\/data-connectors\/sql-server\/\">SQL Server<\/a> and others. Use Sisense to connect to your organizational databases, data warehouses or directly to the raw data, create ad-hoc data mashups and models and then visualize the results directly on the web.<\/p>\r\n\r\n\r\n<h2>Benefits of Choosing Sisense for Postgres Reporting<\/h2>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li>Create new data models on the fly and according to the business questions you want answered, with minimal scripting and coding.<\/li>\r\n\t<li>Transform data with built-in ETL functionality and simple SQL.<\/li>\r\n\t<li>Give more power to the business units that need the data, without going through IT to generate reports from the database or data warehouse.<\/li>\r\n\t<li>Create a secure data repository for business units, either on-premises or in the cloud, without taxing your production resources.<\/li>\r\n\t<li>Leverage the most <a href=\"\/product\/\">powerful analytical technology<\/a> in the market.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-6 col-md-offset-1\">\r\n<h2>Connecting to Postgres<\/h2>\r\n\r\n\r\n<p>To learn how to start pulling data from PostgreSQL databases to your Sisense Elasticube, check out the following item in our documentation: <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/postgres-online.htm\">Connecting to PostgreSQL<\/a><\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Nick","lastName":"Arcuri","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-postgresql11.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-postgresql11.png"}}}},{"connector":{"isSticky":false,"id":16757,"title":"Amazon Redshift","uri":"\/data-connector\/redshift\/","content":"\r\n<h2>Optimize Your Cloud Investments with Sisense and Redshift<\/h2>\r\n\r\n\r\n<p>Sisense offers a native data connector to Amazon Redshift, a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Store data in <a href=\"https:\/\/www.sisense.com\/glossary\/redshift-database\/\">Redshift database<\/a> and query this data in Sisense to optimize performance, improve cost control and deliver greater ease of use.<\/p>\r\n\r\n\r\n<p>As well, Sisense provides the ability to prepare, govern, analyze and <a href=\"https:\/\/www.sisense.com\/product\/mash-up\/\">mashup data<\/a> from multiple sources. The powerful In-Chip\u00ae engine unifies decentralized data and balances workloads. Use Sisense to optimize your investment in the cloud and build faster, more flexible analytical apps with reduced management overhead and cost.<\/p>\r\n\r\n\r\n<p>In addition to Redshift, Sisense has data connectors <a href=\"https:\/\/www.sisense.com\/data-connectors\/amazon-kinesis\/\">to Kinesis<\/a> Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, and many more out of the box. With Sisense, the benefits of Amazon Web Services empower more builders and analysts at every step of the BI workflow.\u00a0<\/p>\r\n\r\n\r\n<h2>Benefits of Amazon Redshift<\/h2>\r\n\r\n\r\n<p>Integrating your <a href=\"https:\/\/www.sisense.com\/blog\/5-advantages-using-redshift-data-warehouse\/\">Redshift data warehouse<\/a> with Sisense\u2019s toolkit presents several noteworthy benefits including:<\/p>\r\n\r\n\r\n<ul class=\"checkmarks\">\r\n\t<li>Best for frequent queries, real-time queries using columnar storage, complex data aggregations, already an AWS customer<\/li>\r\n\t<li>If currently running on AWS, Redshift should be your first choice. \u00a0Redshift integrates with a variety of AWS services such as Kinesis Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, Database Migration Service (DMS), Schema Conversion Tools (SCT), CloudWatch, etc.<\/li>\r\n\t<li>In Redshift you are given control over how to tune your <a href=\"https:\/\/www.sisense.com\/blog\/two-approaches-scalable-database-design\/\">big data database<\/a>. Enables you to tweak the data model and fine tune the cluster for the best performance and lowest infrastructure cost<\/li>\r\n\t<li>Fastest for real-time queries using columnar storage<\/li>\r\n<\/ul>\r\n\r\n\r\n<p><strong>Amazon Redshift introduces RA3 nodes with managed storage enabling independent compute and storage scaling<\/strong><\/p>\r\n\r\n\r\n<p>Amazon Redshift RA3 nodes with managed storage are generally available and enable you to scale and pay for compute and storage independently, allowing you to size your cluster based only on your compute needs. Now you can analyze even more data cost-effectively.<\/p>\r\n\r\n\r\n<p>RA3 nodes are built on the AWS Nitro System and feature high bandwidth networking and performance indistinguishable from bare metal. RA3 nodes use very large, high performance SSDs as local caches. RA3 nodes leverage your workload patterns and advanced data management techniques, such as automatic fine-grained data eviction and intelligent data pre-fetching, to deliver the performance of local SSD while scaling storage automatically to S3. RA3 nodes remain fully compatible with all your existing workloads.<\/p>\r\n\r\n\r\n<p>To get started with RA3 nodes see the\u00a0<a href=\"https:\/\/docs.aws.amazon.com\/redshift\/latest\/mgmt\/working-with-clusters.html#rs-about-clusters-and-nodes\" target=\"_blank\" rel=\"noreferrer noopener\">cluster management guide<\/a>. You can find more information on pricing by visiting the\u00a0<a href=\"https:\/\/aws.amazon.com\/redshift\/pricing\/\" target=\"_blank\" rel=\"noreferrer noopener\">Amazon Redshift pricing<\/a>\u00a0page.<\/p>\r\n\r\n\r\n<h2>Benefits of Sisense and Amazon Redshift<\/h2>\r\n\r\n\r\n<p><strong>Instant Insights with Native Connection to Redshift<\/strong><\/p>\r\n\r\n\r\n<p>The Sisense live connection uses Amazon Redshift to power queries and <a href=\"https:\/\/www.sisense.com\/glossary\/real-time-dashboard\/\">dashboards in real time<\/a>. Connect and create relationships to quickly prepare complex live data models for any purpose. Run live analysis on any dataset to make well-supported decisions on the spot.<\/p>\r\n\r\n\r\n<p><strong>Hybrid Architecture to Integrate Data from Redshift and Other Data Sources<\/strong><br \/>\r\nBeyond live analysis, Sisense delivers easy-to-use analytics that seamlessly blends live data from Redshift and other data sources to make more informed decisions. Sisense\u2019s high-performance In-Chip\u00ae engine and Elastic Data Hub analyze other data alongside real-time queries from Redshift. Whether you want to a connect a multi-cloud environment, combine data that\u2019s not yet in Redshift, or keep pace with rapidly changing requirements, Sisense provides a hybrid solution to manage, prepare, combine, and analyze distributed data.<\/p>\r\n\r\n\r\n<p><strong>A True Single Version of the Truth<\/strong><br \/>\r\nPerennial growth in data often leaves data sources outside of Redshift. Sisense eradicates these data silos by providing a single <a href=\"http:\/\/sisense.com\">data analytics software<\/a> for all data models and sources. Teams and departments can easily create multiple high-performance data models in the Sisene Elastic Data Hub that can be analyzed alongside live data from Redshift. This increases the adoption of Redshift and also brings all data into a unified governed platform reducing management overhead.<\/p>\r\n\r\n\r\n<p><strong>Quickly Migrate to the Cloud<\/strong><br \/>\r\nSisense enables you to connect and analyze data before and during your migration to Redshift. Native data models can be used to enable analysis and after migration; taking seconds to redirect any analysis to query live data in Redshift. This provides business continuity and enables you to get value from data instantly without waiting for a lengthy migration process.<\/p>\r\n\r\n\r\n<p><strong>Remove Bottlenecks for Ultimate Service Flexibility<\/strong><br \/>\r\nSisense ease of use matched with Redshift allows anybody to model and analyze complex data. Business users don\u2019t need to seek technical assistance every time they want to query live data connections. Offer the right service model based on user needs and skills to provide analytics on demand.<\/p>\r\n\r\n\r\n<p><strong>Balance Complex Workloads for Operational Excellence<\/strong><br \/>\r\nShift data exploration and analysis to Elastic Data Models to optimize performance and lower TCO. Sisense\u2019s In-Chip\u00ae engine gives you a time-saving, cost-efficient way to cache existing data. Instead of refreshing the whole database every time you add something new, query cached data for historical insights and connect live to Redshift for more timely questions.<\/p>\r\n\r\n\r\n<p><strong>Integrate Further with Managed Cloud BI<\/strong><br \/>\r\nFocus on what matters and Sisense managed Cloud. With Sisense Managed Cloud, you don't need to worry about hardware or IT. Get Sisense fully-managed, secure, and scalable cloud service.<\/p>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To start using the Redshift Connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/redshift-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/aws-redshift-connector.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/aws-redshift-connector.png"}}}},{"connector":{"isSticky":false,"id":29417,"title":"Snowflake","uri":"\/data-connector\/snowflake\/","content":"\r\n<p>Sisense connects directly to the Snowflake data warehouse using a connector officially certified by Snowflake to deliver an optimized customer experience, flexibly delivering access to all of your present and future data for detailed data exploration and insights. Sisense\u2019s Elastic Data Engine provides the flexibility to prepare, query and manage data within Snowflake using both code and a web-based, visual data modeling experience.<\/p>\r\n\r\n\r\n<p>Organizations can harness the power and elasticity of Snowflake by using Sisense\u2019s advanced data pipelines, SQL-based materialized views and live data models to power complex ad-hoc analysis, dashboards and analytic apps.<\/p>\r\n\r\n\r\n<p>Snowflake & Sisense\u2019s Elastic Data Engine Features:<\/p>\r\n\r\n\r\n<ul>\r\n\t<li>Securely connect and ingest data into Snowflake to create a single store for your data using SQL, Python and R<\/li>\r\n\t<li>Explore both modeled and raw data to easily answer complex and ambiguous business questions without having to rebuild any upfront models<\/li>\r\n\t<li>Optimize raw data stored in Snowflake with materialized views that further powers self-service analytics and query performance from Snowflake\u00a0<\/li>\r\n\t<li>Connect, prepare and combine together dozens of tables directly in Snowflake into a single live model that can be accessed, queried and reused by all users across multiple dashboards<\/li>\r\n\t<li>Mashup data into a cached data model from Snowflake with other data that has not, or can not be migrated, to Snowflake due to data ownership, regulatory or other concerns\u00a0<\/li>\r\n<\/ul>\r\n\r\n\r\n<p>Sisense enables organizations to integrate with Snowflake\u2019s existing systems of record and authentication systems to ensure users have adaptive governance to support the distribution of data to any organizational policy. Multi-level security from a system, object, role, and row-level that can be programmatically automated ensures to ensure organizations can quickly scale the integration between Snowflake + Sisense.\u00a0<\/p>\r\n\r\n\r\n<p> <\/p>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To start using the Snowflake Connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/snowflake-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/snowflake1.jpg","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/snowflake1.jpg"}}}}],"kpis_without_links":"Number of Incidents, Number of Tickets, Open Security Incidents, Number Of Incidents per Incident Type and Malware Type, Number Of Incidents Vs. Security Rating Over Last Quarters, "},"MarketplaceApp":{"technical_content":"<p><\/p>\n<h3>Goals<\/h3>\n<p>Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n<h3>Objectives<\/h3>\n<ul>\n<li>Monitor Number of Security incidents and Tickets over time<\/li>\n<li>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/li>\n<li>Monitor Response teamwork and Average Time to Resolution<\/li>\n<li>Discover the correlation between Number of Incidents and Security Rating<\/li>\n<\/ul>\n<h3>KPIs Architecture<\/h3>\n<table width=\"649\" class=\"table table-bordered\">\n<tbody>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p><strong>Objective<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p><strong>KPI’s<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p><strong>Measures<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p><strong>Data source<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" rowspan=\"8\" width=\"198\">\n<p>Monitor Number of Security Incidents and Tickets over time<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Average Incidents per Employee<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>AVG([Employee ID],[# of unique Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Employee<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Ticket ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Ticket<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])\/[# of unique Ticket ID]<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" rowspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Incident Type and Malware Type<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Malware Type and broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents per State<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Discover the correlation between Number of Incidents and Security Rating<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents Vs. Security Rating Over Last Quarters<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<p>AVG([Quarters in Date],[# of unique Incident ID])<\/p>\n<p>MEDIAN([Security  Rating])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Response teamwork and Average Time to Resolution<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Average Number of Incidents Per Response Team Member Over the 15 Months (Full)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident  Owner]),<\/p>\n<p>AVG([Team Member ID],[# of unique Incident ID])<\/p>\n<p>AVG([Months in Date],AVG([Team Member ID],[# of unique Incident ID]))<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Response Time (Days) by Sub Response Team, Broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Critical”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”High”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Medium”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Low”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Plugins and Scripts<\/h3>\n<p><u>Blox<\/u><\/p>\n<p><a href=\"https:\/\/www.sisense.com\/marketplace\/blox-widgets\/\">https:\/\/www.sisense.com\/marketplace\/blox-widgets\/<\/a><\/p>\n<p><u>Image Widget<\/u><\/p>\n<p><a href=\"https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard\">https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard<\/a><\/p>\n<p><u>Add Custom Palette<\/u><\/p>\n<p><a href=\"https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0\">https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0<\/a><\/p>\n<p><u><br \/>Widget Background Script<\/u><u> <\/u><\/p>\n<p>widget.on(‘processresult’,function(w,e){<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.color = “white”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontSize = “12px”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontWeight = “light”;<\/p>\n<p>})<\/p>\n<p>widget.on(‘domready’, function(se, ev){<\/p>\n<p>$(‘.widget-body’ ,element).css(‘fill’,’#2D5874′);<\/p>\n<p>$(element).css(‘background-color’,’#2D5874′);<\/p>\n<p>     $(‘.highcharts-axis-labels text’).css(‘fill’,’white’);<\/p>\n<p>     $(‘.highcharts-legend-item text’).css(‘fill’,’white’);<\/p>\n<p>})<\/p>\n"},"dashboardExample":{"kpi":false,"dashboard_example_categories":[{"category":{"isSticky":false,"id":25717,"title":"IT","uri":"\/dashboard-examples\/it-oem\/","content":"<div class=\"container\">\r\n<h3>What is an IT dashboard?<\/h3>\r\n<p>An IT dashboard provides users with an instant visual representation of their IT KPIs. Sisense\u2019s <a href=\"\/solutions\/it\/\">IT operations analytics<\/a> dashboard examples allow CIOs and IT experts to measure the performance of an IT organization\/department, identify what improvements are needed and which solutions are not working properly. At the end of the day, an IT dashboard will present IT data in a clear way that will ultimately help save money and improve performance.<\/p>\r\n<p><a class=\"animarrow font-black font-bold\" href=\"https:\/\/www.sisense.com\/dashboard-examples\/\">Learn More About Dashboard Examples<\/a><\/p>\r\n<\/div>","excerpt":"Track the metrics that matter to your IT department.","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/498cb05a2494b30959548721201e98f3?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/498cb05a2494b30959548721201e98f3?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png"}}}}],"connector":[{"connector":{"isSticky":false,"id":16861,"title":"SQL Server","uri":"\/data-connector\/sql-server\/","content":"\r\n<h2>Ad-hoc reporting for SQL Server has never been easier.<\/h2>\r\n\r\n\r\n<p>Sisense's native connectivity to Microsoft SQL Server enables you to quickly import all the data you need, run ad-hoc queries, join SQL Server tables with other databases, and create dashboards and data visualizations - without taxing your production database and without having to write endless lines of code.<\/p>\r\n\r\n\r\n<h3>Why Sisense is the perfect BI tool for SQL Server users:<\/h3>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Instant deployment:<\/b> Connect Sisense BI to your SQL Server instantly and with zero IT involvement or custom development. The SQL Server connector is available out-of-the-box upon downloading Sisense, and you can <a href=\"\/get\/free-trial\/\">try it on your data today<\/a>.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>EDW reporting:<\/b> Already have a single source of organizational truth? Use Sisense on top of your enterprise data warehouse to save IT resources and give business analysts and users the ability to perform agile, exploratory data analysis.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Built-in analytical data mart:<\/b> Quickly and easily import your data from SQL Server into the Elasticube - a proprietary, high-performance columnar database that lets you query complex datasets at 100 times the speed of OLAP or in-memory solutions.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Cross-database joins with the click of a button:<\/b> Want to join tables from multiple sources? No big deal: our automated ETL makes it as simple as dragging-and-dropping. Need to cleanse or enrich data? Do so by creating custom tables, columns and SQL statements.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Visual analytics:<\/b> The days of writing hundreds of lines of code to produce <a href=\"\/glossary\/ad-hoc-analysis\/\">ad-hoc analysis<\/a> & reports for business users are over. Manage your data in a visual environment and let our patent-pending technology do all the rest. Joins performed on-the-fly at query execution time, simplifying the lengthy data modeling and query optimization processes that would otherwise be required.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>SQL Server dashboards keep everyone in the loop:<\/b> Use dozens of data visualization options to bring your data to life in impressive web dashboards that anyone in the business can access and explore at any time, bringing everyone relevant stakeholder closer to their data.<\/li>\r\n<\/ul>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Single-Stack solution:<\/b> Sisense takes you from ETL to visualization in a single <a href=\"https:\/\/www.sisense.com\/bi-tools\/\">BI tool<\/a>, with every step in the process streamlined for maximal simplicitiy and efficiency. Give business users the ability to explore data independently within a governed environment, without slowing down your production database or bothering IT for every new query.<\/li>\r\n<\/ul>\r\n\r\n\r\n<h2>Video: Connecting to SQL Server in seconds<\/h2>\r\n\r\n\r\n<p><iframe title=\"YouTube video player\" src=\"\/\/www.youtube.com\/embed\/pSb4UzjPnfU\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To get started with the Sisense-SQL Server connector, follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/sql-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Microsoft_SQL_Server_Logo1.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Microsoft_SQL_Server_Logo1.png"}}}},{"connector":{"isSticky":false,"id":16840,"title":"Oracle","uri":"\/data-connector\/oracle\/","content":"\r\n<h2>Expand Your Analytics\u2019 Reach With Sisense and Oracle<\/h2>\r\n\r\n\r\n<p>Oracle makes the world\u2019s most connected and well-integrated hardware-software solutions and systems designed for business. With such comprehensive tools come extensive data gathering and analysis needs that many systems aren\u2019t capable of handling out of the box. By combining Oracle\u2019s solutions with Sisense <a href=\"\/product\/\">data analytics tools<\/a>, you can create more accurate reports and visualizations based on <a href=\"https:\/\/www.sisense.com\/glossary\/real-time-analytics\/\">real-time data<\/a>.<\/p>\r\n\r\n\r\n<p>Sisense lets you share Oracle systems data much faster, gaining better <a href=\"\/product\/impact\/\">bi insights<\/a> with interactive and intuitive analytic tools alongside easy-to-use interfaces.<\/p>\r\n\r\n\r\n<h2>The Benefits of Sisense and Oracle<\/h2>\r\n\r\n\r\n<p>Integrating Oracle and Sisense tools grants you a variety of key advantages:<\/p>\r\n\r\n\r\n<ul>\r\n\t<li><strong>Organize Real-Time Data With ElastiCube: <\/strong>With massive data streams, organization and ease of access become vital. Sisense\u2019s <a href=\"https:\/\/www.sisense.com\/product\/mash-up\/elasticube\/\">ElastiCube<\/a> structures allow you to organize, store, and access data in a simpler and more granular way for better visualizations and insights.<\/li>\r\n\t<li><strong>Connect to Powerful Visualization Tools:<\/strong> Large data sets are unwieldy and can be hard to properly understand in many cases. By connecting with Sisense <a href=\"\/dashboard-examples\/\">dashboards<\/a>, you can simplify the discovery process by building accurate, real-time visualizations that can provide enhanced insights.<\/li>\r\n\t<li><strong>Access and Create Reports When They Happen:<\/strong> A major issue with large data sets is the wait to convert them from raw figures into actionable insights. By feeding Oracle data into Sisense analytics tools, you can speed up the process of generating reports to gain access to the most up-to-date information.<\/li>\r\n\t<li><strong>Improve Dashboards With Real-Time Data:<\/strong> Dashboards are only as good as the insights they deliver. Connecting Oracle tools to Sisense dashboards gives you a more accurate view in real time of what is happening with your software and hardware.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-6 col-md-offset-1\">\r\n<h2>Getting Started<\/h2>\r\n\r\n\r\n<p>To get started with the Sisense-Oracle connector, follow the instructions listed <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/oracle-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-oracle1-11.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-oracle1-11.png"}}}},{"connector":{"isSticky":false,"id":16835,"title":"MySQL","uri":"\/data-connector\/mysql\/","content":"\r\n<h2>Seamless End-to-End Analytics and Reporting<br \/>\r\nfor MySQL with Sisense BI<\/h2>\r\n\r\n\r\n<p>Using Sisense with your MySQL database is the perfect solution for business intelligence, data visualization and <a href=\"\/reporting\/\">ad-hoc SQL reporting<\/a>. The built-in connector will allow you to connect to data stored in your MySQL <a href=\"\/glossary\/relational-database\/\">relational database<\/a> with the click of a button and immediately start importing data into Sisense's ultra-fast, ultra-scalable <a href=\"https:\/\/www.sisense.com\/product\/analyze\/technology\/\">In-Chip data engine<\/a> - and proceed to combine MySQL data with a multitude of structured and unstructured data sources, and quickly create analytical reports and dashboards for rapid insights.<\/p>\r\n\r\n\r\n<h2>Benefits of Sisense on MySQL<\/h2>\r\n\r\n\r\n<p>Some of the unique advantages of using Sisense to prepare, analyze and visualize data stored in MySQL include:<\/p>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li><b>Native Connectivity:<\/b> Import all your data into the Sisense Elasticube, or only the specific tables you need, all with the click of a button and without any scripting or coding.<\/li>\r\n\t<li><b>Simplify business analytics for complex data<\/b>: Easily access relational data stored in MySQL and combine it with tables from various other <a href=\"https:\/\/www.sisense.com\/data-connectors\/\">databases, flat files and cloud sources<\/a>, then visualize and share the results for a complete analytical solution.<\/li>\r\n\t<li><b>Immediate query retrieval:<\/b> Skip past MySQL limitations for working with Big Data and always get immediate answers to ad-hoc questions, regardless of data size or complexity.<\/li>\r\n\t<li><b>Visual data preparation with built-in ETL:<\/b> Manage highly complex data models via an intuitive visual environment, and use <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/using-sql.htm\">custom SQL<\/a> for data manipulation, custom tables and advanced data preparation. Connect multiple data sources without altering the original structure or model of the data to minimize data preparation and skip straight to the insights.<\/li>\r\n\t<li><b>MySQL dashboard builder<\/b>: Create beautiful interactive dashboards that refresh automatically at near real-time, empowering any business user to create immediate value out of your MySQL data.<\/li>\r\n\t<li><b>Minimal IT \\ internal scripting:<\/b> Enjoy all the regular benefits of Sisense\u2019s intuitive, end-user oriented interface to quickly get up and running without mass investment in IT or technical resources.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n\r\n\r\n<p>To start using the Sisense-MySQL connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/mysql-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Nick","lastName":"Arcuri","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-mysql1.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-mysql1.png"}}}},{"connector":{"isSticky":false,"id":16842,"title":"PostgreSQL","uri":"\/data-connector\/postgresql\/","content":"\r\n<h2>Boost your Postgres database reporting and analytics with a complete BI tool<\/h2>\r\n\r\n\r\n<p>Storing your data in Postgres can carry unique advantages in terms of speed, stability and support for large data volumes. However, to fully leverage the potential of your organization's data you need an <a href=\"\/why-sisense\/\">agile BI tool<\/a> that can enable busines users to connect directly to your database, create cross-database joins and allow you to iteratively ask and answer questions in a visual environment, without having to write SQL queries or overloading the IT pipeline.<\/p>\r\n\r\n\r\n<p>Sisense provides reporting tools and analytics for any SQL-based database, including Postgres, <a href=\"\/data-connectors\/sql-server\/\">SQL Server<\/a> and others. Use Sisense to connect to your organizational databases, data warehouses or directly to the raw data, create ad-hoc data mashups and models and then visualize the results directly on the web.<\/p>\r\n\r\n\r\n<h2>Benefits of Choosing Sisense for Postgres Reporting<\/h2>\r\n\r\n\r\n<ul class=\"sisense\">\r\n\t<li>Create new data models on the fly and according to the business questions you want answered, with minimal scripting and coding.<\/li>\r\n\t<li>Transform data with built-in ETL functionality and simple SQL.<\/li>\r\n\t<li>Give more power to the business units that need the data, without going through IT to generate reports from the database or data warehouse.<\/li>\r\n\t<li>Create a secure data repository for business units, either on-premises or in the cloud, without taxing your production resources.<\/li>\r\n\t<li>Leverage the most <a href=\"\/product\/\">powerful analytical technology<\/a> in the market.<\/li>\r\n<\/ul>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta\">\r\n<div class=\"container\">\r\n<div class=\"row \">\r\n<div class=\"text-center col-md-6 col-md-offset-1\">\r\n<h2>Connecting to Postgres<\/h2>\r\n\r\n\r\n<p>To learn how to start pulling data from PostgreSQL databases to your Sisense Elasticube, check out the following item in our documentation: <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/postgres-online.htm\">Connecting to PostgreSQL<\/a><\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Nick","lastName":"Arcuri","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/368bbdbf8a4c98048ed096d02c18f2bc?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-postgresql11.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/logo-connector-postgresql11.png"}}}},{"connector":{"isSticky":false,"id":16757,"title":"Amazon Redshift","uri":"\/data-connector\/redshift\/","content":"\r\n<h2>Optimize Your Cloud Investments with Sisense and Redshift<\/h2>\r\n\r\n\r\n<p>Sisense offers a native data connector to Amazon Redshift, a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Store data in <a href=\"https:\/\/www.sisense.com\/glossary\/redshift-database\/\">Redshift database<\/a> and query this data in Sisense to optimize performance, improve cost control and deliver greater ease of use.<\/p>\r\n\r\n\r\n<p>As well, Sisense provides the ability to prepare, govern, analyze and <a href=\"https:\/\/www.sisense.com\/product\/mash-up\/\">mashup data<\/a> from multiple sources. The powerful In-Chip\u00ae engine unifies decentralized data and balances workloads. Use Sisense to optimize your investment in the cloud and build faster, more flexible analytical apps with reduced management overhead and cost.<\/p>\r\n\r\n\r\n<p>In addition to Redshift, Sisense has data connectors <a href=\"https:\/\/www.sisense.com\/data-connectors\/amazon-kinesis\/\">to Kinesis<\/a> Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, and many more out of the box. With Sisense, the benefits of Amazon Web Services empower more builders and analysts at every step of the BI workflow.\u00a0<\/p>\r\n\r\n\r\n<h2>Benefits of Amazon Redshift<\/h2>\r\n\r\n\r\n<p>Integrating your <a href=\"https:\/\/www.sisense.com\/blog\/5-advantages-using-redshift-data-warehouse\/\">Redshift data warehouse<\/a> with Sisense\u2019s toolkit presents several noteworthy benefits including:<\/p>\r\n\r\n\r\n<ul class=\"checkmarks\">\r\n\t<li>Best for frequent queries, real-time queries using columnar storage, complex data aggregations, already an AWS customer<\/li>\r\n\t<li>If currently running on AWS, Redshift should be your first choice. \u00a0Redshift integrates with a variety of AWS services such as Kinesis Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, Database Migration Service (DMS), Schema Conversion Tools (SCT), CloudWatch, etc.<\/li>\r\n\t<li>In Redshift you are given control over how to tune your <a href=\"https:\/\/www.sisense.com\/blog\/two-approaches-scalable-database-design\/\">big data database<\/a>. Enables you to tweak the data model and fine tune the cluster for the best performance and lowest infrastructure cost<\/li>\r\n\t<li>Fastest for real-time queries using columnar storage<\/li>\r\n<\/ul>\r\n\r\n\r\n<p><strong>Amazon Redshift introduces RA3 nodes with managed storage enabling independent compute and storage scaling<\/strong><\/p>\r\n\r\n\r\n<p>Amazon Redshift RA3 nodes with managed storage are generally available and enable you to scale and pay for compute and storage independently, allowing you to size your cluster based only on your compute needs. Now you can analyze even more data cost-effectively.<\/p>\r\n\r\n\r\n<p>RA3 nodes are built on the AWS Nitro System and feature high bandwidth networking and performance indistinguishable from bare metal. RA3 nodes use very large, high performance SSDs as local caches. RA3 nodes leverage your workload patterns and advanced data management techniques, such as automatic fine-grained data eviction and intelligent data pre-fetching, to deliver the performance of local SSD while scaling storage automatically to S3. RA3 nodes remain fully compatible with all your existing workloads.<\/p>\r\n\r\n\r\n<p>To get started with RA3 nodes see the\u00a0<a href=\"https:\/\/docs.aws.amazon.com\/redshift\/latest\/mgmt\/working-with-clusters.html#rs-about-clusters-and-nodes\" target=\"_blank\" rel=\"noreferrer noopener\">cluster management guide<\/a>. You can find more information on pricing by visiting the\u00a0<a href=\"https:\/\/aws.amazon.com\/redshift\/pricing\/\" target=\"_blank\" rel=\"noreferrer noopener\">Amazon Redshift pricing<\/a>\u00a0page.<\/p>\r\n\r\n\r\n<h2>Benefits of Sisense and Amazon Redshift<\/h2>\r\n\r\n\r\n<p><strong>Instant Insights with Native Connection to Redshift<\/strong><\/p>\r\n\r\n\r\n<p>The Sisense live connection uses Amazon Redshift to power queries and <a href=\"https:\/\/www.sisense.com\/glossary\/real-time-dashboard\/\">dashboards in real time<\/a>. Connect and create relationships to quickly prepare complex live data models for any purpose. Run live analysis on any dataset to make well-supported decisions on the spot.<\/p>\r\n\r\n\r\n<p><strong>Hybrid Architecture to Integrate Data from Redshift and Other Data Sources<\/strong><br \/>\r\nBeyond live analysis, Sisense delivers easy-to-use analytics that seamlessly blends live data from Redshift and other data sources to make more informed decisions. Sisense\u2019s high-performance In-Chip\u00ae engine and Elastic Data Hub analyze other data alongside real-time queries from Redshift. Whether you want to a connect a multi-cloud environment, combine data that\u2019s not yet in Redshift, or keep pace with rapidly changing requirements, Sisense provides a hybrid solution to manage, prepare, combine, and analyze distributed data.<\/p>\r\n\r\n\r\n<p><strong>A True Single Version of the Truth<\/strong><br \/>\r\nPerennial growth in data often leaves data sources outside of Redshift. Sisense eradicates these data silos by providing a single <a href=\"http:\/\/sisense.com\">data analytics software<\/a> for all data models and sources. Teams and departments can easily create multiple high-performance data models in the Sisene Elastic Data Hub that can be analyzed alongside live data from Redshift. This increases the adoption of Redshift and also brings all data into a unified governed platform reducing management overhead.<\/p>\r\n\r\n\r\n<p><strong>Quickly Migrate to the Cloud<\/strong><br \/>\r\nSisense enables you to connect and analyze data before and during your migration to Redshift. Native data models can be used to enable analysis and after migration; taking seconds to redirect any analysis to query live data in Redshift. This provides business continuity and enables you to get value from data instantly without waiting for a lengthy migration process.<\/p>\r\n\r\n\r\n<p><strong>Remove Bottlenecks for Ultimate Service Flexibility<\/strong><br \/>\r\nSisense ease of use matched with Redshift allows anybody to model and analyze complex data. Business users don\u2019t need to seek technical assistance every time they want to query live data connections. Offer the right service model based on user needs and skills to provide analytics on demand.<\/p>\r\n\r\n\r\n<p><strong>Balance Complex Workloads for Operational Excellence<\/strong><br \/>\r\nShift data exploration and analysis to Elastic Data Models to optimize performance and lower TCO. Sisense\u2019s In-Chip\u00ae engine gives you a time-saving, cost-efficient way to cache existing data. Instead of refreshing the whole database every time you add something new, query cached data for historical insights and connect live to Redshift for more timely questions.<\/p>\r\n\r\n\r\n<p><strong>Integrate Further with Managed Cloud BI<\/strong><br \/>\r\nFocus on what matters and Sisense managed Cloud. With Sisense Managed Cloud, you don't need to worry about hardware or IT. Get Sisense fully-managed, secure, and scalable cloud service.<\/p>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To start using the Redshift Connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/redshift-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/aws-redshift-connector.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/aws-redshift-connector.png"}}}},{"connector":{"isSticky":false,"id":29417,"title":"Snowflake","uri":"\/data-connector\/snowflake\/","content":"\r\n<p>Sisense connects directly to the Snowflake data warehouse using a connector officially certified by Snowflake to deliver an optimized customer experience, flexibly delivering access to all of your present and future data for detailed data exploration and insights. Sisense\u2019s Elastic Data Engine provides the flexibility to prepare, query and manage data within Snowflake using both code and a web-based, visual data modeling experience.<\/p>\r\n\r\n\r\n<p>Organizations can harness the power and elasticity of Snowflake by using Sisense\u2019s advanced data pipelines, SQL-based materialized views and live data models to power complex ad-hoc analysis, dashboards and analytic apps.<\/p>\r\n\r\n\r\n<p>Snowflake & Sisense\u2019s Elastic Data Engine Features:<\/p>\r\n\r\n\r\n<ul>\r\n\t<li>Securely connect and ingest data into Snowflake to create a single store for your data using SQL, Python and R<\/li>\r\n\t<li>Explore both modeled and raw data to easily answer complex and ambiguous business questions without having to rebuild any upfront models<\/li>\r\n\t<li>Optimize raw data stored in Snowflake with materialized views that further powers self-service analytics and query performance from Snowflake\u00a0<\/li>\r\n\t<li>Connect, prepare and combine together dozens of tables directly in Snowflake into a single live model that can be accessed, queried and reused by all users across multiple dashboards<\/li>\r\n\t<li>Mashup data into a cached data model from Snowflake with other data that has not, or can not be migrated, to Snowflake due to data ownership, regulatory or other concerns\u00a0<\/li>\r\n<\/ul>\r\n\r\n\r\n<p>Sisense enables organizations to integrate with Snowflake\u2019s existing systems of record and authentication systems to ensure users have adaptive governance to support the distribution of data to any organizational policy. Multi-level security from a system, object, role, and row-level that can be programmatically automated ensures to ensure organizations can quickly scale the integration between Snowflake + Sisense.\u00a0<\/p>\r\n\r\n\r\n<p> <\/p>\r\n\r\n\r\n<section class=\"bg-grey free-trial-cta text-center\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4 col-md-offset-2\">\r\n<h2>Getting Started<\/h2>\r\n<p>To start using the Snowflake Connector, simply follow the instructions <a href=\"https:\/\/documentation.sisense.com\/latest\/managing-data\/connectors\/snowflake-online.htm\">here<\/a>.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/section>\r\n","excerpt":"","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/1ad2257c0c27663ae2cf4d89cce5090d?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/snowflake1.jpg","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/snowflake1.jpg"}}}}],"displayTitleText":"Cyber Security Team Analytics Dashboard","displayTitleIcon":false,"dashboardIcon":false,"showOnCategoryPage":true,"categoryPageSummary":"Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk.","solutionPageTitle":"","solutionsPageSummary":"","cloudTrialDashboardId":"5d6fc86ecc6db20b8c805731","dashboardScreenshot":false,"hasImplementationKit":true,"technicalContent":"<p><\/p>\n<h3>Goals<\/h3>\n<p>Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n<h3>Objectives<\/h3>\n<ul>\n<li>Monitor Number of Security incidents and Tickets over time<\/li>\n<li>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/li>\n<li>Monitor Response teamwork and Average Time to Resolution<\/li>\n<li>Discover the correlation between Number of Incidents and Security Rating<\/li>\n<\/ul>\n<h3>KPIs Architecture<\/h3>\n<table width=\"649\" class=\"table table-bordered\">\n<tbody>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p><strong>Objective<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p><strong>KPI’s<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p><strong>Measures<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p><strong>Data source<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" rowspan=\"8\" width=\"198\">\n<p>Monitor Number of Security Incidents and Tickets over time<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Average Incidents per Employee<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>AVG([Employee ID],[# of unique Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Employee<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Ticket ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Ticket<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])\/[# of unique Ticket ID]<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" rowspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Incident Type and Malware Type<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Malware Type and broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents per State<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Discover the correlation between Number of Incidents and Security Rating<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents Vs. Security Rating Over Last Quarters<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<p>AVG([Quarters in Date],[# of unique Incident ID])<\/p>\n<p>MEDIAN([Security  Rating])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Response teamwork and Average Time to Resolution<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Average Number of Incidents Per Response Team Member Over the 15 Months (Full)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident  Owner]),<\/p>\n<p>AVG([Team Member ID],[# of unique Incident ID])<\/p>\n<p>AVG([Months in Date],AVG([Team Member ID],[# of unique Incident ID]))<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Response Time (Days) by Sub Response Team, Broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Critical”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”High”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Medium”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Low”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Plugins and Scripts<\/h3>\n<p><u>Blox<\/u><\/p>\n<p><a href=\"https:\/\/www.sisense.com\/marketplace\/blox-widgets\/\">https:\/\/www.sisense.com\/marketplace\/blox-widgets\/<\/a><\/p>\n<p><u>Image Widget<\/u><\/p>\n<p><a href=\"https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard\">https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard<\/a><\/p>\n<p><u>Add Custom Palette<\/u><\/p>\n<p><a href=\"https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0\">https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0<\/a><\/p>\n<p><u><br \/>Widget Background Script<\/u><u> <\/u><\/p>\n<p>widget.on(‘processresult’,function(w,e){<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.color = “white”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontSize = “12px”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontWeight = “light”;<\/p>\n<p>})<\/p>\n<p>widget.on(‘domready’, function(se, ev){<\/p>\n<p>$(‘.widget-body’ ,element).css(‘fill’,’#2D5874′);<\/p>\n<p>$(element).css(‘background-color’,’#2D5874′);<\/p>\n<p>     $(‘.highcharts-axis-labels text’).css(‘fill’,’white’);<\/p>\n<p>     $(‘.highcharts-legend-item text’).css(‘fill’,’white’);<\/p>\n<p>})<\/p>\n","implementationKitDownload":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/CyberSecurityAnalytics.zip","documentationLink":"https:\/\/documentation.sisense.com\/latest\/content\/verticals.htm","dashboardExampleCategories":[{"category":{"isSticky":false,"id":25717,"title":"IT","uri":"\/dashboard-examples\/it-oem\/","content":"<div class=\"container\">\r\n<h3>What is an IT dashboard?<\/h3>\r\n<p>An IT dashboard provides users with an instant visual representation of their IT KPIs. Sisense\u2019s <a href=\"\/solutions\/it\/\">IT operations analytics<\/a> dashboard examples allow CIOs and IT experts to measure the performance of an IT organization\/department, identify what improvements are needed and which solutions are not working properly. At the end of the day, an IT dashboard will present IT data in a clear way that will ultimately help save money and improve performance.<\/p>\r\n<p><a class=\"animarrow font-black font-bold\" href=\"https:\/\/www.sisense.com\/dashboard-examples\/\">Learn More About Dashboard Examples<\/a><\/p>\r\n<\/div>","excerpt":"Track the metrics that matter to your IT department.","tags":false,"categories":{"edges":[]},"author":{"node":{"firstName":"Sisense","lastName":"Team","avatar":{"url":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/498cb05a2494b30959548721201e98f3?s=96&d=blank&r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/498cb05a2494b30959548721201e98f3?s=192&d=blank&r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy'\/>"}}},"featuredImage":{"node":{"sourceUrl":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png","guid":"https:\/\/cdn.sisense.com\/wp-content\/uploads\/Technology-Hero-Visual-min.png"}}}}],"dashboardRoles":"IT Manager, Cyber Security Manager, Data Engineer, Analyst","kpisWithoutLinks":"Number of Incidents, Number of Tickets, Open Security Incidents, Number Of Incidents per Incident Type and Malware Type, Number Of Incidents Vs. Security Rating Over Last Quarters, "},"marketplaceApp":{"technicalContent":"<p><\/p>\n<h3>Goals<\/h3>\n<p>Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n<h3>Objectives<\/h3>\n<ul>\n<li>Monitor Number of Security incidents and Tickets over time<\/li>\n<li>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/li>\n<li>Monitor Response teamwork and Average Time to Resolution<\/li>\n<li>Discover the correlation between Number of Incidents and Security Rating<\/li>\n<\/ul>\n<h3>KPIs Architecture<\/h3>\n<table width=\"649\" class=\"table table-bordered\">\n<tbody>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p><strong>Objective<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p><strong>KPI’s<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p><strong>Measures<\/strong><\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p><strong>Data source<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" rowspan=\"8\" width=\"198\">\n<p>Monitor Number of Security Incidents and Tickets over time<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Average Incidents per Employee<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>AVG([Employee ID],[# of unique Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Employee<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Ticket ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Ticket<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])\/[# of unique Ticket ID]<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>FACT Tickets<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Security Incidents<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(count([Incident ID]),[Status]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Open Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Open”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"84\">\n<p>Resolved Tickets<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>([# of unique Ticket ID],[TicketStatus]=”Closed”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Tickets<\/p>\n<p>DIM Response Team<\/p>\n<\/td>\n<td width=\"1\">\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" rowspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Incident Type and Malware Type<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents per Malware Type and broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>FACT Incidents<\/p>\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Number of Incidents and Tickets by Malware Type, Risk Level, Location<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number of Incidents per State<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Incident<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Discover the correlation between Number of Incidents and Security Rating<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Number Of Incidents Vs. Security Rating Over Last Quarters<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident ID])<\/p>\n<p>AVG([Quarters in Date],[# of unique Incident ID])<\/p>\n<p>MEDIAN([Security  Rating])<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<p>Monitor Response teamwork and Average Time to Resolution<\/p>\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Average Number of Incidents Per Response Team Member Over the 15 Months (Full)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>count([Incident  Owner]),<\/p>\n<p>AVG([Team Member ID],[# of unique Incident ID])<\/p>\n<p>AVG([Months in Date],AVG([Team Member ID],[# of unique Incident ID]))<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Date<\/p>\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"1\">\n<\/td>\n<td colspan=\"2\" width=\"198\">\n<\/td>\n<td colspan=\"2\" width=\"84\">\n<p>Response Time (Days) by Sub Response Team, Broken by Risk Level<\/p>\n<\/td>\n<td colspan=\"2\" width=\"258\">\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Critical”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”High”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Medium”)<\/p>\n<p>(avg([Response  Dwell ( Days)]),[Risk Level]=”Low”)<\/p>\n<\/td>\n<td colspan=\"2\" width=\"108\">\n<p>DIM Response Team<\/p>\n<p>FACT Incidents<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Plugins and Scripts<\/h3>\n<p><u>Blox<\/u><\/p>\n<p><a href=\"https:\/\/www.sisense.com\/marketplace\/blox-widgets\/\">https:\/\/www.sisense.com\/marketplace\/blox-widgets\/<\/a><\/p>\n<p><u>Image Widget<\/u><\/p>\n<p><a href=\"https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard\">https:\/\/support.sisense.com\/hc\/en-us\/community\/posts\/221224568-Adding-Logo-Image-to-a-dashboard<\/a><\/p>\n<p><u>Add Custom Palette<\/u><\/p>\n<p><a href=\"https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0\">https:\/\/documentation.sisense.com\/latest\/creating-dashboards\/additional-widget-designs\/change-dashboard-pallette.htm#gsc.tab=0<\/a><\/p>\n<p><u><br \/>Widget Background Script<\/u><u> <\/u><\/p>\n<p>widget.on(‘processresult’,function(w,e){<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.color = “white”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontSize = “12px”;<\/p>\n<p>     e.result.plotOptions.series.dataLabels.style.fontWeight = “light”;<\/p>\n<p>})<\/p>\n<p>widget.on(‘domready’, function(se, ev){<\/p>\n<p>$(‘.widget-body’ ,element).css(‘fill’,’#2D5874′);<\/p>\n<p>$(element).css(‘background-color’,’#2D5874′);<\/p>\n<p>     $(‘.highcharts-axis-labels text’).css(‘fill’,’white’);<\/p>\n<p>     $(‘.highcharts-legend-item text’).css(‘fill’,’white’);<\/p>\n<p>})<\/p>\n"}}</article></body></html>

Goals<\/h3>\nMonitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n

Why Sisense is the perfect BI tool for SQL Server users:<\/h3>\r\n\r\n\r\n

Goals<\/h3>\n
Monitor and analyze overall cyber threats and response team performance in order to plan prevent actions for offices which considered to be at risk<\/p>\n

Cyber Analytics

High Level Design

Overview

Explore Dashboard