Business Intelligence Using Parameters in iReport By admin USING PARAMETERS IN iREPORT Most basic knowledge any new learner would have of word parameter -“ parameter is a limit or boundary which defines the scope of a particular process or activity ”. And technically we can define it...
Business Intelligence Batch Process Implementation in Kettle By Nikhilesh Batch Process Implementation in Kettle (Pentaho Data Integration) In order to implement the batch process we needs to have the looping logic. But I did not find any component or suitable method in kettle to create those loops. Make data...
Business Intelligence Expression Language of Spring (SpEL) By Somen Sarkar Spring Expression Lanaguage (SpEL) There are many expression languages available such as JSP EL, OGNL, MVEL and JBoss EL. SpEL provides some additional features such as method invocation and string templating functionality. The Spring Expression Language (SpEL) supports...
Business Intelligence Slowly Changing Dimension in Pentaho Data Integration(Kettle) By Nikhilesh Slowly Changing Dimension in Pentaho Data Integration(Kettle) Slowly changing dimension(SCD) is a common mechanism in Datawarehousing concepts. The exact definition of SCD is the dimension that changes slowly over a time rather than on a regular schedule. In Data Warehouse...
Business Intelligence Business Intelligence Vs Business Analytics By Nikhilesh What’s the difference between Business Analytics and Business Intelligence? The correct answer is: everybody has an opinion, but nobody knows. For example, when SAP says “business analytics” instead of “business intelligence”, it’s intended to indicate that business analytics is...
Business Intelligence Use Built-In Parameters in Jaspersoft Reports By Nikhilesh Use BuiltIn parameters in Jasper Reports Jasper provides few builtIn parameters which can be used in JRXML. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days Free Trail...
Business Intelligence Crosstab in Jaspersoft By Sohail Beginner’s Guide to Crosstab in Business Intelligence Using Jaspersoft IReport What is Cross Tab? A Table is just of 2 Dimension but at times we do need our table to be represented in a 3 dimensional manner or in a...
Business Intelligence Mongo DB Aggregation – Part II – The Aggregation Framework By Shraddha Tambe Mongo DB Aggregation(Part 2) - The Aggregation Framework The Mongo DB aggregation framework or aggregation pipeline lets you define a data processing pipeline. It takes multiple documents in a collection, puts them through the multiple Stages we define and transforms...
Business Intelligence Is your Business Intelligence tool really Intelligent – Try Helical Insight By Nikhilesh According to Forrester blog a typical BI tool costs $1,50,000/- and ETL costs about the same. Services, hardware and implementation generally scale up to 5 times the software cost. It is after investing so much that most businesses realize that the...
Business Intelligence Full Outer Join by Using tmap in Talend By Nikhilesh Full Outer Join by using tmap in Talend In tMap, the default Join Model is Left Outer Join and also we have Inner Join as another Join Model. Suppose if we need the result for full outer join ,you can...
Business Intelligence MySql case sensitive table names issue on Windows/Linux By Nikhilesh MySql case sensitive table names issue on Windows/Linux Moving a MySQL database from Windows to Linux .Many times we faced the problem that on Linux the names of the tables are case sensitive due to that we can't find...
Business Intelligence Looping and Batch Processing in PDI By Nikhilesh Implementing Loops and batch processing in Kettle What is batch processing? Batch processing is basically a series of execution of jobs from source to destination. Here the data is divided into smaller batches and transferred to the destination. This helps...