Categories
BI Big Data

Using Multiple R servers for distributed processing

Purpose of this blog is to demonstrate how to use R-servers in a distributed manner i.e how to access multiple R servers simultaneously for reasons of distributed processing, performance enhancement. We Read More[...]
Categories
BI Big Data

Loading Large Data files in R

To start working with large data sets in R, the first question is how to load the data for further analysis. Our data tests consisted of large CSV files having data as matrices, which was needed for further Read More[...]
Categories
Paxcel Labs BI Big Data

Finding the optimum partition size while parallelizing large matrix operation in R

Problem Statement: Finding the optimum partition size while parallelizing large matrix operation in R Description: How R’s parallel system works? Before moving to analysis, we must know how Read More[...]
Categories
BI

The new SpagoBI (version 3.6.0) – Installation instructions and Troubleshooting

SpagoBI released their new version i.e. 3.6.0 with more enhancements and bug fixes on Oct 22 last month. This tool is becoming more popular worldwide now, and user will get the new version more attractive and stronger from the last version. Read More[...]
Categories
Paxcel Labs BI

KickStart to ETL using Talend

We had already discussed the basic concepts of ETL in a previous blog. Lets see how ETL can be achieved through the powerful open source tool "Talend" Read More[...]
Categories
Paxcel Labs BI

SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

It is not surprising for Business owners to think of taking business decisions right from their gadgets with which they spend most of their time these days. Be it I-Pads, Tablets or the Smart phones, they are all part of our life now. What if those BI Reports you see in your browsers are made available on your I-Pad!.... I know you must be thinking there are many such applications, but what about an Open Source application which has provision for rich controls. Lets see what SpagoBIMobileEngine offers. Read More[...]
Categories
Paxcel Labs BI

Things to know about ETL in Business Intelligence(BI)

ETL is shortened form of EXTRACT, TRANSFORM, LOAD. It is a process or method in which data gets extracted from a source through different means, changed (transformed ) as per specific need and the changed ( transformed ) data is loaded to another system, mostly known as target system. Read More[...]
Categories
Paxcel Labs BI

How to design and develop an interactive Cockpit or Dashboard in SpagoBI?

Dashboard is a one page visualization of business performance data which keeps senior managers in-line and proactive. This helps in taking better business decisions and planning future business needs. The key here is to present business performance data efficiently so that it can benefit business owners and help them analyze different aspects of their business. Lets see how this can be done in SpagoBI. Read More[...]
Categories
Paxcel Labs Java Microsoft Tech BI Big Data

Expectations from Hadoop On Azure

Microsoft has launched hadoop on its cloud platform Azure. So I , along with Pushpinder Singh and Sukhjot Singh here in our Paxcel Labs ,analyzed what hadoop on Azure offers to the market. Right now Microsoft has not launched HOA(Hadoop on Azure) for all, but they give access to use it in their test environments through invitation only. After getting access we started exploring it. Read More[...]
Categories
Paxcel Labs BI

Develop multidimensional analysis reports using Jpalo engine in SpagoBI

SpagoBI allows multidimensional analysis through OLAP engines, i.e. JPalo which are more flexible and user-friendly, compared to structured reports. Read More[...]