Oz Soreq

Current Rank out of Total Indicator

1. Knowledge Base
2. Dashboard Design

 Analytical Need  On certain scenarios, one would like to show an indicator that presents the ranking of a current selection(filter) out of all the items in the pool.This allows the viewer to quick...

• Oz Soreq
• Edited June 13, 2019 17:25
• 1 follower
• 0 comments
• 2 votes

Enabling Timezone by User

1. Knowledge Base
2. Data Modeling

 Analytical Need  Often times, you would have the need to support user across the globe that are digesting data from your dashboards. At these scenarios, the timestamp that was recorded and stored ...

• Oz Soreq
• Edited March 24, 2019 17:43
• 1 follower
• 0 comments
• 0 votes

Target on Gauge

1. Knowledge Base
2. Dashboard Design

 Analytical Need  Gauges are types of widgets that are very helpful in presenting progress or whether a KPI is met such as current state vs. expected state based on previous, calculated value. At t...

• Oz Soreq
• Edited October 16, 2018 06:09
• 3 followers
• 0 comments
• 2 votes

Modifying Text Files Using Python

1. Knowledge Base
2. REST API

At times, we are using flat files as a source to rely on for our data analysis.As flat files can be generated by another program or manually, it is often hard to control and expect the data structu...

• Oz Soreq
• Edited August 29, 2018 11:52
• 1 follower
• 0 comments
• 1 vote

Resend Invitations to Inactive Users in Bulk

1. Knowledge Base
2. REST API

This article shows how to ease the process of resending activation emails to inactive users.Upon a user creation, the user receives an email, requesting it to log in and activate his Sisense user.I...

• Oz Soreq
• Edited July 19, 2018 12:55
• 1 follower
• 0 comments
• 0 votes

Highlighting Max Value in a Pivot

1. Knowledge Base
2. Dashboard Design

 Analytical Need  When designing our dashboards and widgets, we should always consider the visuals and UI to convey the message of our widgets and help our users to consume the data easily, and tak...

• Oz Soreq
• Edited August 02, 2018 09:26
• 1 follower
• 0 comments
• 6 votes

Dynamic Pulse Alerts

1. Knowledge Base
2. Dashboard Design

 Analytical Need  Sisense Pulse is a centralized location where you can stay on top of your most important KPIs across multiple dashboards or manage your data and build alerts. In order to create a...

• Oz Soreq
• Edited May 17, 2018 15:59
• 3 followers
• 0 comments
• 3 votes

Calculating Time differences Flexibly

1. Knowledge Base
2. Data Modeling

 Analytical Need  Certain business questions might require us to determine the time that has passed between two status in a flexible manner.Calculating differences between two events often will req...

• Oz Soreq
• Edited March 27, 2019 10:33
• 4 followers
• 0 comments
• 5 votes

Time Dimension

1. Knowledge Base
2. Data Modeling

 Analytical Need  Many times we would like to deep dive into our data and view it in a more granular fashion to conclude from it.Certain business needs might require us to use date-time hierarchies...

• Oz Soreq
• Edited April 30, 2019 11:24
• 1 follower
• 0 comments
• 4 votes

Pareto Analysis

1. Knowledge Base
2. Dashboard Design

 Analytical Need  Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be...

• Oz Soreq
• Edited February 07, 2018 15:35
• 2 followers
• 0 comments
• 8 votes