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 MoreFollowing 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 MoreLearn 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 MorePower 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 MoreData 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 MoreIntegrating 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 MoreWhat 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