Power BI DAX Functions

Logical functions Logical functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results. In this category Function Description AND Checks whether both arguments are TRUE, and returns TRUE if both…

Read More

Mapping Tables in QlikView

Mapping table in QlikView is a table, which is created to map the column values between two tables. It is also called a Lookup table, which is only used to look for a related value from some other table. With Joining two table you can refer data of one table in another table. By using…

Read More

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

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

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

Integrating Tableau with R for Data Science

Integrating Tableau with R for Data Science Integration of Tableau with R R is a popular open-source environment for statistical analysis. Tableau Desktop can now connect to R through calculated fields and take advantage of R functions, libraries, packages and even saved models. These calculations dynamically invoke the R engine and pass values to R…

Read More