Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Thursday, 6 February 2014

Differences between Reporting and Analysis –Theory - Points from Brent Dykes blog

Hi Guys,

Thank you Brent Dykes such a nice explanation .
As a BI developer we ought to know the theoretical concepts hence I've made a notes on the same from the Brent's post. 

Difference between Reporting and Analysis – Theory 

Report­ing and analy­sis are very dif­fer­ent in terms of their pur­pose, tasks, out­puts, deliv­ery, and value
       1. The process of orga­niz­ing data into infor­ma­tional sum­maries     in order to mon­i­tor how dif­fer­ent areas of a busi­ness are per­form­ing.
      1.The process of explor­ing data and reports in order to extract mean­ing­ful insights, which can be used to bet­ter under­stand and improve busi­ness performance.
       2. Report­ing trans­lates raw data into infor­ma­tion
      2. Analy­sis trans­forms data and infor­ma­tion into insights.
      3. Good report­ing should raise ques­tions about the busi­ness from its end users
      3.The goal of analy­sis is to answer ques­tions by inter­pret­ing the data at a deeper level and pro­vid­ing action­able rec­om­men­da­tions
      4. Report­ing shows you what is hap­pen­ing
     4. Analy­sis focuses on explain­ing why it is hap­pen­ing and what you can do about it.
      5.Reporting: Build­ing, con­fig­ur­ing, con­sol­i­dat­ing, orga­niz­ing, for­mat­ting, and sum­ma­riz­ing.
      5. Analy­sis:  focuses on dif­fer­ent tasks such as ques­tion­ing, exam­in­ing, inter­pret­ing, com­par­ing, and con­firm­ing.
      6. Report­ing fol­lows a push approach
        6.Analy­sis fol­lows a pull approach
      7. Reports are pushed to users who are then expected to extract         mean­ing­ful insights and take appro­pri­ate actions for them­selves (i.e., self-serve).
     7.Par­tic­u­lar data is pulled by an ana­lyst in order to answer spe­cific busi­ness ques­tions.

         8. Types
·         Canned reports, dash­boards, and alerts.
·         Dashboard: These custom-made reports com­bine dif­fer­ent KPIs and reports to pro­vide a com­pre­hen­sive, high-level view of busi­ness per­for­mance for spe­cific audi­ences. Dash­boards may include data from var­i­ous data sources and are also usu­ally fairly static.

·         Ad hoc responses
·         Analy­sis pre­sen­ta­tions

Update : 27th April 2015

My personal opinion on CE editions
BI Solutions

Pentaho CE

Jasper CE

I recommend it b’z it has pixel perfect report designer which is standalone (ü)

I recommend it b’z it has pixel perfect report designer Jasper Studio or iReport

I recommend it b’z there is a powerful dashboard tool available. (C-Tools)

NO CE tool available for dashboards so won’t recommend it
Analysis Desktop tool
I recommend it (schema workbench)
I recommend it (schema workbench)
Analysis Server tools

I recommend it – There are new tech 2 to 3 server tools which are new visualization tools on server

I recommend it on less priority b’z on the CE server the old traditional Jpivot server tool only available.
Highly recommend it
I recommend Talend Open studio over Jasper ETL
Ad-hoc Reporting
Recommend it if you have only table kind of reports to be generated ad-hocly
No CE tool is available so won’t recommend it