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

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

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

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

Introduction to Data Science

What is Data Science? The realities of Data Science is revealed! Traditionally, the data that we had was mostly structured and small in size, which could be analyzed by using the simple BI tools. Unlike data in the traditional systems which was mostly structured, today most of the data is unstructured or semi-structured. Use of…

Read More

Introduction to Qlik Sense Cloud and Sharing Data Across

Introduction to Qlik Sense Cloud and Sharing Data Across   Introduction to Qlik Sense Cloud Qlik sense makes it easier for business users to analyze data and develop reports and dashboards. Qlik’s biggest challenge for business users in the coming year will be raising its brand profile in an increasingly cloud-centric BI and analytics market.…

Read More