Business Intelligence Reading data from single data source(Single SQL Query) for two charts in pentaho CDE By Nikhilesh Hi guys...!!! Community Dashboard Editor is the best reporting/dash boarding tool that I have worked. It's smart functionality made me love to work with it and exploring the things time by time. In this post you'll learn how to fetch...
Business Intelligence Extract year,quarter,month & day from date input control in pentaho CDE using java script – MDX Query Scenario By Nikhilesh Hello guys...!! Some times you need to extract the parts(year,month,day) of Date for some specific use.. For example: Assume you are creating a report with MDX query which has dimension called "Date" having levels "Year", "Quarter","Month" & "Day". (Note :...
Business Intelligence Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubuntu OS By Nikhilesh This post teach you how to install the Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubantu OS. I've gone through many posts but could not find all the stuff in a single place. I just...
Business Intelligence Sorting and limit the bars on bar charts in Pentaho CDE without ORDER BY and limit functions in SQL Query ( Descending order) By Nikhilesh Hi Guys...!!! This post helps you how you can make your bar chart dynamic.. You can limit the number of bars on bar charts with out using the "limit" function in your query as well you can also sort the...
Data Visualization Candlestick Charts By Nikhilesh CANDLESTICK CHARTS What is Candlestick Chart? A candlestick chart is a style of bar-chart used primarily to describe price movements of a security, derivative, or currency over time. It is a combination of a line-chart and a bar-chart, in that...
Data Visualization Radar Charts (Spider Chart) By Nikhilesh RADAR CHARTS (SPIDER CHART) What is Radar Chart? A radar chart graphically shows the size of the gaps among five to ten performance areas. The chart displays the important categories of performance and makes visible concentrations of strengths and weaknesses....
Data Visualization Marimekko Charts – Data Visualization By Nikhilesh MARIMEKKO CHARTS What is Marimekko Chart? A Marimekko chart is a two-dimensional 100% chart, in which the width of a column is proportional to the total of the column's values. Data input is similar to a 100% chart, with data...
Data Visualization BUBBLE GRAPH / BUBBLE CHART By Nikhilesh BUBBLE GRAPH / BUBBLE CHART What is Bubble Chart? A bubble chart is used to visualize a data set with 2 to 4 dimensions. The first two dimensions are visualized as coordinates, the 3rd as color and the 4th as...
Data Visualization Pie Chart – Data Visualization By Nikhilesh PIE CHART What is Pie Chart? A pie chart (or a circle graph) is a circular chart divided into sectors, illustrating proportion. In a pie chart, the arc length of each sector (and consequently its central angle and area), is...
Data Visualization Pareto Chart – Data Visualization By Nikhilesh PARETO CHART What is Pareto Chart? Pareto chart is a data visualization tool which contains both bars & line graphs. In this, individual values are represented in decreasing order by bars & the cumulative total is represented by the line....
Data Visualization Data Visualization – Best Practices & When What Chart to Use By Nikhilesh Data is of no importance until & unless we are able to extract some information from it. Effective data visualization is very important for the decision-making process. This helps decision makers to examine data, see trends, take actions. The key...
Business Intelligence Dashboards & Designing a good Dashboard By Nikhilesh A picture is worth a thousand words & when spoken in IT paradigm, a dashboard is worth thousands of GB of data. A typical definition of dashboard is "An easy to read, often single page, real-time user interface, showing a...