Comparison between SAS BI vs. Tableau

Following are the Comparison of popular BI tool SAS and Tableau. BI Product SAS BI Tablueu BI OverView SAS Business Intelligence is a part of SAS Enterprise Solutions. It combines business intelligence and analytics to discover and collect enterprise-level data. With SAS Business Intelligence, you get user-friendly, self-service business intelligence tools and solutions. On top…

Read More

Single Configurator of Qlik Sense Dev Hub

The Single configurator is a tool that provides an easy way of building light weight mashup pages without writing any code. It enables a Qlik Sense object, which is in form of an URL. The Qlik Sense object is normally a visualization of an existing app of Qlik sense desktop. It could be a a…

Read More

Incremental Extract in Tableau

Incremental Extract Incremental extract is an approach where rather than refreshing the entire extract, you can configure a refresh to add only the rows that are new since the previous time you extracted the data. For example, you may have a data source that is updated daily with new sales transactions. Rather than rebuild the…

Read More

QlikView IntervalMatch Function

QlikView IntervalMatch: IntervalMatch is a powerful function used to match distinct numeric values to numeric intervals. It is useful in analyzing how the events actually happened versus the planned events. The example of a scenario where it is used is in the assembly lines of the production houses where the belts are planned to run…

Read More

How to get Rolling Month using Set Analysis in Qlik

I have a requirement to retrive data from Last 6 Month to Till date. How we can achieve this? Yes! we can achieve this by using Qlik Sense Set Analysis. Step1: You have to create a variable say “vLastSixMonth” in Qlik Sense Step2: You need to define the dynamic methods in variable. Such as AddMonth(YourDateField,…

Read More

Overview of Qlik NPrinting NewsStand

Introduction to Qlik NPrinting NewsStand Qlik NPrinting NewsStand is the web portal for users. In the NewsStand a user can see the reports he/she is authorized to view, download and it is possible to trigger reports refresh. In this case they will be published in the NewsStand. Opening NewsStand The NewsStand web portal uses the…

Read More

Learn Power BI DAX in 30 minutes

Learn Power BI DAX in 30 minutes What is DAX in POwer BI? Data Analysis Expressions (DAX) in power BI is a set of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from…

Read More

DAR Methodology of Qlik Sense

What is DAR? The Dashboard, Analysis, Reporting (DAR) is a methodology. DAR is followed to be creative and meet the varying requirements of clients. In a nutshell you lead with a Dashboard page, followed by Analysis pages, and finish with Reporting pages. Applying DAR methodology to build an application During design of a dashboard, when…

Read More

How to use Templates of Power BI Desktop

Power BI Templates Templates is a new feature of Power BI Desktop. Power BI Templates allow users to export a Power BI Desktop report as a template (PBIT file). This can be instantiated as a new Power BI Desktop report (PBIX file). A Power BI Report Template contains the definition of the Report (pages, visuals,…

Read More

Data modeling best practices of Qlik Sense

Data modeling best practices of Qlik Sense This post describes number of ways to load your data into the Qlik Sense app, depending on how the data is structured and which data model you want to achieve. Following are the best practice approach followed in Qlik Sense App. A) Turning data columns into rows: My…

Read More