These five “unorthodox principles for dashboard success” are
1.Definitions don’t always help
2.Visuals matter
3.Users always want more
4.Beware of end-users and large data sets
5.Knowing is nothing, doing is everything
And, they are explained in detail in a new Antivia eBook.
Together, the 5 principles provide a bit of a sideways look at the world of dashboards, and although they might seem a little tongue in cheek at times, each principle contains advice that I believe will genuinely help you to deliver dashboards more successfully and more valuably across your organization.
Courtesy by Xcelsius Gurus...
Friday, June 17, 2011
Monday, June 6, 2011
BI-Qlikview Compared to other BI tools
I came across the discussion about compare Qlikview features with other BI tools.
Brief View about the Qlikview:
>>Qlikview is a new kind of business intelligence software that changes your world. Its BI software that lets you stop guessing and start knowing how to make faster and smarter decisions
>>QlikView is an in memory BI tool with a limitation of the amount of data based on the RAM size; where as other tools are highly scalable.
>>The performance of QlikView is mind blowing, and works best for users looking for instant analysis.
>>QlikView has a unique drill feature which is called Associative Search
>>Best tool for doing What If Analysis.Users can actually start doing the analysis with limited trainings
>>The concept of QVDs (QlikView Data files) is amazing for replacing ETL tools.
>>QlikView is User & Insight Driven and not IT & Data Driven.Supports Heterogeneous Data Sources Enforce group, role-based and individual user policies from individual documents to granular row and value restrictions.
>>Offline Analysis – Once data is refreshed, users can do their analysis offline also.
>>Set Analysis – logics which takes months to implement in other tools takes minutes in QlikView
>>QlikView Scripting – gives you the power to transform your data the way you want and incorporate the Outside objects into Qliview.
>>It is very User friendly and Installation is in minutes of time,Other tools takes time to install.
>>If you are looking for pure adhoc reporting where users would be using the tool just to extract/fetch data in excel format BusinessObjects serves the purpose.
>>I know Business Objects is capable of doing a lot more, but most of the users use it just to extract/fetch data and feed it into their charts.
>>Complicated logics can be put on to the BusinessObjects Universe (Meta data Layer) making it easy for users just to select the objects and creating their own reports. These reports can be saved, scheduled or used in a dashboard.
>>If the users have licenses of Xcelsius, then they can leverage the Query as a web service to feed data to Xcelsius from the already existing BusinessObjects Universe.
>>Business Objects also has LiveOffice as a plugin which enables users to Import WebI report into excel without actually logging into Info View.
>>QlikView is a completely different tool. There is no comparison between QlikView and BusinessObjects.
>>In QlikView the dashboard would be pre built by the developers, users can change the filters to do their analysis.
>>They cant really add more data on the fly as QlikView scripting is not that easy when large volumes of data and complicated logic comes in.
Brief View about the Qlikview:
>>Qlikview is a new kind of business intelligence software that changes your world. Its BI software that lets you stop guessing and start knowing how to make faster and smarter decisions
>>QlikView is an in memory BI tool with a limitation of the amount of data based on the RAM size; where as other tools are highly scalable.
>>The performance of QlikView is mind blowing, and works best for users looking for instant analysis.
>>QlikView has a unique drill feature which is called Associative Search
>>Best tool for doing What If Analysis.Users can actually start doing the analysis with limited trainings
>>The concept of QVDs (QlikView Data files) is amazing for replacing ETL tools.
>>QlikView is User & Insight Driven and not IT & Data Driven.Supports Heterogeneous Data Sources Enforce group, role-based and individual user policies from individual documents to granular row and value restrictions.
>>Offline Analysis – Once data is refreshed, users can do their analysis offline also.
>>Set Analysis – logics which takes months to implement in other tools takes minutes in QlikView
>>QlikView Scripting – gives you the power to transform your data the way you want and incorporate the Outside objects into Qliview.
>>It is very User friendly and Installation is in minutes of time,Other tools takes time to install.
>>If you are looking for pure adhoc reporting where users would be using the tool just to extract/fetch data in excel format BusinessObjects serves the purpose.
>>I know Business Objects is capable of doing a lot more, but most of the users use it just to extract/fetch data and feed it into their charts.
>>Complicated logics can be put on to the BusinessObjects Universe (Meta data Layer) making it easy for users just to select the objects and creating their own reports. These reports can be saved, scheduled or used in a dashboard.
>>If the users have licenses of Xcelsius, then they can leverage the Query as a web service to feed data to Xcelsius from the already existing BusinessObjects Universe.
>>Business Objects also has LiveOffice as a plugin which enables users to Import WebI report into excel without actually logging into Info View.
>>QlikView is a completely different tool. There is no comparison between QlikView and BusinessObjects.
>>In QlikView the dashboard would be pre built by the developers, users can change the filters to do their analysis.
>>They cant really add more data on the fly as QlikView scripting is not that easy when large volumes of data and complicated logic comes in.
Thursday, May 19, 2011
How to display current Date and Time in Crystal Xcelsius
Xcelsius is a nice presentation tool to design and display dashboards. I was recently working on a the requirement of showing current time on the dashboard.At Finally I discover solution to this.
First I tried using Excel's NOW() function.The problem with now function is that it only displays the static time when you first open the dashboard. The time won't change after that even when you refresh dashboard connections.
There is a trick using History component to achieve this functionality.
>> Use now() function to populate current date and time in a cell (say A1) and format the cell to display time in HH:MM:SS format
>> In another cell (say E1) put the formula "=A1". Now E1 displays the current time as A1.
>> Drag history component (under other) on to the canvas
>> Put the formula "=E1+TIME(0,0,1)" in a cell say C1
>> Map data filed of history component to C1 and map Data Insertion field to E1 and select on interval 1 second option.
>> The E1 cell displays the current time. Map E1 cell to a text label component to display it on the dashboard.
First I tried using Excel's NOW() function.The problem with now function is that it only displays the static time when you first open the dashboard. The time won't change after that even when you refresh dashboard connections.
There is a trick using History component to achieve this functionality.
>> Use now() function to populate current date and time in a cell (say A1) and format the cell to display time in HH:MM:SS format
>> In another cell (say E1) put the formula "=A1". Now E1 displays the current time as A1.
>> Drag history component (under other) on to the canvas
>> Put the formula "=E1+TIME(0,0,1)" in a cell say C1
>> Map data filed of history component to C1 and map Data Insertion field to E1 and select on interval 1 second option.
>> The E1 cell displays the current time. Map E1 cell to a text label component to display it on the dashboard.
Subscribe to:
Posts (Atom)
