Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Sisense Compose SDK

Sisense Compose SDK The Future is ComposableIn the fast-paced world of data-driven applications, developers are constantly seeking innovative ways to create customized data products that seamlessly integrate into their projects. Sisense has stepped u...

Screenshot 2023-09-06 at 3.16.04 PM.png
spuma by Sisense Team Member
  • 81 Views
  • 0 comments
  • 2 kudos

BloX - A Technical Introduction

BloX - A Technical Introduction To start, download the attached file ‘BloXTutorial-Styling.dash’ file and import this into your Sisense environment. This dashboard uses the ‘Sample Ecommerce’ data model and contains all iterations of the BloX widget....

alexfrisbie_0-1675282038054.png alexfrisbie_1-1675282038020.png alexfrisbie_2-1675282038037.png

Sankey Diagrams With Plot.Ly In Periscope

Sankey diagrams are a very easy-to-digest way to look at the flow of objects between different points. The example we will walk through here is a basic Sankey overview, leveraging data from a fictional gaming company. The emphasis of this post is foc...

Community_Admin_0-1635245516505.png

Text Mining With SQL

One of the recent questions I had to answer focused on analyzing text data. How have you solved this problem in the past? I was not sure how to create an optimized solution for both efficiency and completeness. My solution I came up with used a join ...

Generate Series Of Dates In Snowflake

As Snowflake doesn't have a native generate_series function, here is our solution to generating a table of incrementing dates, starting from the current date, in Snowflake. It is currently set to generate 1095 rows (3 years) of dates. select dateadd(...

Loose String Matching (Levenshtein For Redshift?)

Perhaps a bit tangential to text mining, but has anyone found a way to efficiently do string analysis in Redshift? Ideally something like levenshtein() or levenshtein_less_distance() in postgres to return string similarity. There must be a better way...

Chart Type - Radial Bar Chart In Matplotlib (Python)

Here's a script that takes a data frame with two values, the current and benchmark, and returns radial bar charts to plot progress toward a goal. You can also choose a color using the color_theme parameter that takes values 'Grey', 'Purple, 'Blue', '...

Community_Admin_0-1635242545447.png

Calculating Trimmed Means (SQL And Python Variations)

Data can oftentimes have extreme outliers, which can heavily skew certain metrics, such as the mean. One way to get around this is to use a trimmed mean. Using a trimmed mean, users will remove the top and bottom x percent of their data and take the ...

Community_Admin_1-1635242219218.png

Funnel Charts In Python

Funnel charts are a great way to represent any drop-offs in sample size throughout a series of steps. Using a little bit of Python handiwork in Sisense for Cloud Data Teams' R/Python integration, we can easily create this chart type. A common use cas...

Community_Admin_0-1635241790831.png

Confidence Interval Printout - Python

Let's say we want a printout of our confidence interval for an entire sample (Note, if you're looking for a visual of a confidence interval over time, check out the post here!) The solution here requires Periscope Data's Python/R Integration as we'll...

Community_Admin_0-1635241572949.png

Get Yesterday's Date

Often times, we want to analyze data with the date from yesterday. How do we auto-populate yesterday's date? There are a few formats that we can use! The syntax below lets us get yesterday's date with timestamp: select dateadd(day,-1,getdate()) To on...

Community_Admin_0-1635241370626.png Community_Admin_1-1635241380771.png Community_Admin_2-1635241389789.png Community_Admin_3-1635241396834.png

CASE WHEN Statements

Overview CASE WHEN statements provide great flexibility when dealing with buckets of results or when you need to find a way to filter out certain results. You can think of these almost as IF-THEN statements similar to other coding languages. Below yo...

Filters In Case When Statements

I came across an interesting use case with a customer where they had a name and ID column on a dataset: Select a filter value for name, and not id -> show results for name Select a filter value for id, and not name -> show results for id If values ar...

Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com