This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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 to help us understand performance trends such as Sale...
Analytical Need There are cases where our data arrives in aggregate form, like in Google Analytics (where the lowest granularity level is daily). If we wish to free up clutter in the dashboard and prevent the user from figuring out which field com...
Analytical NeedIn many cases a hierarchy appears in the data structured as 2 levels - A parent and a child. The business user would like to see the entire hierarchy and analyze the data according to the different levels, but can't do that since they...
Analytical Need For different use cases, it can be relevant to present a timeframe of different business entities and the relations between them. For examples, such use cases can be: Present hotel vacancies by room number or typeAnalyze ticket...
Analytical Need We may encounter a situation in which a table has several fields that together identify each record. Each of them may appear several times but their combination is unique. Modeling Challenge In our data model, we have 2 tables that ...
Analytical Need We have one central source for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis?We will need to connect all of our table...
Analytical Need There are cases where we need to define an association between two entities. This association is comprised of the entities and not by each of them separately. For example, students & courses. We need to have a list of each student...
Use Case:Sometimes, we would like to create calculations from the fact table and we need to have a continuous range of dates or in other cases, we need to count the number of employees (just as an example) that we have in the company.We strongly reco...
Analytical NeedA common use case is to know the number of new users in the system. It could be that same user appear in various months but we want to count each unique user only once.If we will use a simplistic approach of count distinct calculation ...
Analytical NeedThere are many cases where our data comes in with different granularity levels. For instance, Actual vs. Target where the actuals are at the product level and the targets are per sub category (higher hierarchy of the product). How can...
Analytical Need‘Funnel analysis’ describes process flow, where in its beginning the number that we measure is relatively big, and in each step within the process this number is getting smaller along the way till the end point.The most common example...
Analytical Need Working with 2 fact tables which have a direct 1:M relationship, and fetching measures from both. A common example from the retail industry is Order Header and Order Line Items tables Modeling Challenge A standard connection could c...
Analytical NeedFact tables may include multiple dates per record. For instance, a record can have an open date, a closed date, an updated date etc. Modeling Challenge We need one time dimension since we don’t want the user to use multiple date fiel...
Analytical Need We have multiple sources for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis? We will need to connect all of our t...
Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in...
Analytical Need A common requirement in data analysis is to be able to view and compare slices of data from different time periods to current date. Business applications for this vary, from identifying trends to predicting future behavior, requir...
Analytical Need In a dashboard, we wish to analyze how our entities (sales, inventory, tickets etc.) behave and break them by several categories. However, not all entities share the same categories. We wish to avoid a situation in which selecting...
Analytical Need The data is stored in a certain currency and you would like to present it in the dashboard converted to different currencies. Modeling Challenge As a designer, I would like to have a dashboard filter of currencies in order to s...
If you want each date to “belong” to its “actual year” you can use the ISO way to calculate the week number.For example, if 1/1/2016 is on Wednesday and you want the 1th ,2nd and 3rd to belong to the first week of 2016 and the 4th to belong to the se...
Analytical Need I have historical transactional data starting from 2012. Some are recorded in USD, others in EUR. I need to convert these values to USD based on the exchange rate on the date of the transaction. My Elasticube is built on a daily bas...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
