Laws And Myths Of Usability && Interface Design
Dec 12, 2006
Laws and Myths of Usability & Interface Design
Introduction
Usability and relevance have been identified as the major factors preventing mass adoption of
Business Intelligence applications. What we have today are traditional BI tools that don't work
nearly as well as they should, even for analysts and power users. The reason they haven't
reached the masses is because most of the tools are so difficult to use and reveal so little
about the data that only power users are willing to put up with them. Just as Google redefined
the web by making search and therefore access easy … the same needs to occur with the BI
suite.
Overwhelmingly, traditional BI products are designed for the technology expert. The perceived functionality requirements are driven by widget wish lists
rather than actual business user (the BI consumers) needs.
Our design philosophy has been honed through experience and results in a simple equation:
Usability = Simplicity + Unity
This paper is a reflection on some of the design approaches used in the development of
Yellowfin. Its purpose is to provide an insight into what makes web based applications ‘work’
and how Yellowfin will continue to evolve and improve. The principles are defined by 5 laws
and 5 myths.
The laws:
1. Simplicity – the art of Zen and interface design
2. Strive for internal and external unity
3. Innovation stretchs engineering capability
4. Everything changes except change itself
5. First impressions count
The Myths:
1. Form follows function
2. Only users know what they want
3. Involve many people in your design process
4. Usability testing will ensure a great UI
5. You can’t live without rigorous design processes
At Yellowfin we use the principles outlined in this paper to continue to deliver innovation,
improvements and what we hope is an exceptional software experience for our customers.
#1 Simplicity – the art of Zen and interface design
Users want simplicity! They want to do the job they need to do with the minimum of effort and
complexity. Users must be able to perform their most frequent, most important tasks without
any resistance. This means:
1. not having to spend time sifting through an array of irrelevant options, and
2. not having to browse help files or a manual to accomplish simple tasks
The goal, then, is obvious: to maximize performance while minimizing confusion. But as
vendors and users are discovering, that's no small trick. Simplicity is sometimes the least
simple thing to achieve." 1
Simplicity requires that your code does all the hard work, rather than the user. Google, as an
example, maintains the simplest of search interfaces. No distractions from blogs, news or
ads, you simply type in your query and go. Behind this simplicity is up to 500,000 computers
globally linked and participating in answering your query. In essence, one of the most
complex hardware/software systems on the planet is hidden behind a very simple webpage
that is virtually 100% whitespace.
Deliver the right level of blatant functionality to suit user skills
The most common UI issue in report writers is BOS (Button Overuse Syndrome). If there is a
formatting option, or any option for that matter, then traditionally it needs a button. How
wrong can you be! BOS delivers too many options and results in a user confused by choice.
The cure for BOS is UI simplification through minimalism – the art of Zen and interface
design. Focus on what users do 90% of the time. Chances are your users will not mind using
a drop down menu or popup forms if the action they are performing is not regularly repeated.
Provide buttons for those actions that are regularly used and then drop down menus or side
panel menus for all the others. Whatever you do, keep the interface simple and consistent.
Of course the level of competence of your user will influence your design decisions. An
example of a product that is tailored for user sophistication is the video camera. Consumer
versions have lots of functionality but hidden in layers of menus, whilst professional versions
tend to be button centric to allow rapid access to all the functions desired.
Taking this lesson into account we have designed the UI specifically to suit the technical
ability of the average user. The interface is made more flexible through role based access,
where greater control is exposed as technical proficiency increases. For example the report
writer (a business user function is menu driven) but the more technical metadata layer is
panel and options driven.
Simplicity in everything you do
View 4 Replies
ADVERTISEMENT
Jul 20, 2005
Hi EveryoneThis is a data base question so don't switch off thinking it is a DataProtection Act Question.I'm Looking for some general information regarding the UK Law onrights to access data within a database provided by a third partysoftware provider.They are preventing me from ODBC Access to their data base and saythat the only way I can access the data held in the data base isthrough CSV reports that their custom app can provide.I am building a datawarehouse and require the data to be DTS'sed to myOLAP server on a regular basis....but theyt rae denying me access thedatabase is Oracle so their should really be no problems but they arehitting me with all the usual invalidate warranty claims.Does anyone know what UK law has to say in this matter, o0r can youpoint me to a good resource.TIAMaria
View 2 Replies
View Related
Nov 30, 2007
I have a question that I am sure that others have had to deal with in the past. I am writing business requirements for a web application that stores names, addresses, etc. I have hit a bit of a problem in design with allowing users to enter data they need, like the name O'Brien, and developers saying that allowing the single quote in a field could allow for an injection attack.
Developers want to strip out single quotes when they occur in the data, however the users are insistent that names and addresses that have single quotes in them are shown properly.
Is there any middle ground so that the system can be built to avoid an injection, but still allow data to be entered as intended.
View 4 Replies
View Related
Jul 18, 2007
I have been using SSRS2k5 now since early CTP, and one thing that bothers me is the lack of keyboard shortcuts and windows standards.
For example: If I am in the data screen, and want to enter a SQL Query, I cannot use the tab key. So I copy it to SQL Management Studio, but I cant use CTRL-A to select all.
If I am in the layout tab, and want to bold a field, I hit CTRL-B, but that pulls up the breakpoint entry dialog.
If I have a table on a report, and want to add click-thru navigation, I have to:
Right click on cell 1
Click on properties
Select Navigation
Click on Jump to Report
Select the report from the list
Click on parameters
Select parameter 1
Now, if I want a field as the parameter, i can just select from the drop down, but most of the time I am passing parameters from the 1st report to the 2nd report. Then i have to:
Click on the Expression button
Either type the parameter name, or click on it from the list.
Press OK
Repeat number 8 for the number of parameters.
Hit OK.
Hit OK.
REPEAT FOR ALL CELLS
Now, here is the issue... If you have a 20 column table, and have similar click thru functionality, you have to repeat this process for each cell. You cannot multi select. THAT would be a huge timesaver. I would rather set all 20 cells the same, and tweak 1 or 2, rather than kill my wrist mousing thru the above process 20 times. (It hurts, trust me )
These seem like little things, until you are working on 50 reports in a short time frame.
Anyone else find this bothersome?
Is there any improvement on the GUI in the next release?
Thanks!
BobP
View 3 Replies
View Related
Aug 3, 2006
Hi all. I'm not sure if this is the correct place for this question, so my apologies if it should be in another section.
I need to build a simple QA (quality assurance) DB for my company (a small physician group). I have the DB built in Access, but would much prefer to put it in SQL Server for reasons of stability, security, and access control.
What I would like to do is build a web interface to this DB so the users can just click an IE shortcut on their desktop, and be able to enter information via the browser like they would in a form in MS Access.
What would be the best way of going about building something like this? My background is as an analyst, so I'm unsure when it comes to actually building a front-end.
Sorry if this question is simplistic or if it has already been answered, and thank you in advance for any assistance you may lend.
View 3 Replies
View Related
Mar 5, 2008
how can i down load interfaceor fix the problem?
View 2 Replies
View Related
Jan 4, 2008
I am working on the project for Health Care Provider. They use HL7 interface to data sources. Any other interface is not an option. I need to address following scenarios for daily ETL jobs:
Pull analyses results for patients based on certain criteria to my database (SQL2005). Hundreds of results per day.
Verify list of patients against master list thru HL7 and update data elements that has changed. There are millions of patients
I am considering using WEB Services task in SSIS for scenario 1. Scenario 2 is more complicated because of the volume of data. I am considering using BizTalk for this one. Can BizTalk handle this scenario? Is there is more efficient way?
View 2 Replies
View Related
May 13, 2015
I have a scenario like below
Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1
How to design tables in SQL Server for the above.
View 2 Replies
View Related
Jul 17, 2000
I have the following VB function. The stored proc that is being called
("GetList") inside the function does a simple SQL Select statement against
an SQL Server 7 database using OLE DB. I'd like to store the result of the
SQL Select statement in the "Rs" parameter to pass back to the calling
function. Whenever I call this function, I get an error message stating "No
Such Interface Supported". Does anyone know why I cannot do this?
Also, this function is being called from ASP code. That's why the "Rs" is
passed as a variant. It's created in the ASP code before this function is
called.
------------------------------------------
Function GetAddressDropDownList(Rs As Variant, CustomerId As Long)
Dim ProcComm
Dim Parameter
Set ProcComm = CreateObject("ADODB.Command")
ProcComm.CommandType = adCmdStoredProc
ProcComm.CommandText = "GetList"
Set Parameter = ProcComm.CreateParameter("CustomerId", adInteger,
adParamInput)
Parameter.Value = CustomerId
ProcComm.Parameters.Append Parameter
Set Parameter = Nothing
ProcComm.ActiveConnection = BuildConnectionString()
Rs.CursorLocation = adUseClient
Rs.Open ProcComm, , adOpenForwardOnly
Set Parameter = Nothing
Set ProcComm = Nothing
End Function
View 1 Replies
View Related
Jan 15, 2007
Is there an interface that I could use in SQL Server to create queries or tables instead of typing codes in query analyzer? Any help would be appreciated.
View 2 Replies
View Related
Jul 23, 2005
Dear All,SQL-SERVER-DBAccess interface25 usersI want to know how the users are working with the interface:* What forms the use* What routines the run ( commandbuttons)* How long they use the interface* etc.I'll use a public function to add the information.Where should i store the information ? :* in a table in the SQL-DB: 1 table for all users on the server* a text-file for each user on the users computer.What solutions is the quickest?Thanks,Filip
View 1 Replies
View Related
Dec 27, 2005
Hi everyone. I need to be able to query a database in Oracle and thenactually save the data in an MS SQL database, does anyone know what isthe best way to do this? Would it be best to do everything internal(inside MS SQL) or external (with some script: javascript, vbscript,perl)?Thanks in advanced,Mike
View 6 Replies
View Related
Jul 20, 2005
Dear All,I'm looking for a VBA-code to run a sql-sript from the Access.adp-interface.I want to send scripts so my client can add sql-server-objects from theinterface.Thanks,Filip
View 1 Replies
View Related
Jan 13, 2006
I was trying to burn cds when I got thisfda error message stating Interface not Registered what does this mean and can someone tell me how to fix it
-thanks Lequeta
View 3 Replies
View Related
Feb 21, 2006
Hi there,
we have several DWH Load processes running in SSIS, however I want to enable the enduser to have more control and information about the status of these processes. Therefore I plan to write a monitoring interface based on ASP.NET 2.0. However I hardly could find good docu or samples on what is available from within ASP.NET 2.0 to read out or control SSIS.
Anybody having me some good pointers to start with ?
View 2 Replies
View Related
Jan 29, 2007
Good morning,
Well... I'm implementing a clustering algorithm following the examples given on the Managed Plugin Algorithms tutorial. As the samples are in C# and I'm implementing it on C++, I'm facing some problems, but nothing really significant.
But I've some conceptual questions about the implementation:
1) It necessary to implement the IDMClusteringAlgorithm interface in order to implement the ClusterMembership() and the CaseLikelihood() methods, right ?
2) The changes needed to be done on the Navigation class have nothing to do specifically with clustering. These changes are only to set calculated statistics to be shown, and if I want, I can simply don't implement them. Is this correct ?
3) Is there any documentation on the parameters received by the ClusterMembership and CaseLikelihood methods ? What's its inputs and outputs ?
Any clues are wellcome.
Thanks a lot again.
View 10 Replies
View Related
Apr 19, 2007
Dear Friends,
I'm having a problem...
I need to export all the work that I have done in SSIS, but I dont know the option to do it... If I do a printscreen of the ETLs, I dont have all the layout of the ETL... Do you know how can I get it better to create my document?
thanks!
View 5 Replies
View Related
May 30, 2008
I downloaded SQL Server Express 5.0 and would like to know - must I open SQLServer through a studio like SQL Server Management Studio Express, or can it open on its own? Does it come with a GUI inside it?
I clicked Start/All Programs/Microsoft SQL Server 2005 and only submenues were displayed, not the server itself. The submenues were
Configuration Tools
SQL Server Management Studio Express.
Thanks.
View 1 Replies
View Related
Dec 31, 2006
I was just wondering why when i go to burn a cd it says Interface not registered. If somone could help i thank you.. cause i really want to burn cds again. thanks
View 3 Replies
View Related
Dec 4, 2007
I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:
- A dropdown of different connection strings, to connect to different databases
-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)
-A gridview object for results
-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)
I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)
View 2 Replies
View Related
Jun 11, 2001
Hi all
Does any one know abt the web interface for managing SQL SERVER
I would like to create database,create tables create users, modify, insert data etc.. over the web
i belive there are interfaces are available on the net
can any body tell me from where i can download it
Thanks in advance
Prasad
View 2 Replies
View Related
Feb 15, 2001
HELP!!! I've looked at a few, but none of them support insert and update. I hate to say it, but the Access inteface is better, but uses a different SQL than SQL Server. :(
Help,
mike
View 3 Replies
View Related
Dec 14, 2001
Hello everybody,
please advice: what is the fastest standard method of user interface access to SQL database? I am looking for fast display of one master record plus related dependent records, plus fast scrolling through master records with display of dependent records as fast as posible. Perhaps a standard problem with standard solution? At current state of matters, I am still much slower then with my old Access97 database.
thanks for any advice,
Otakar Kverka
Prague
View 1 Replies
View Related
Nov 20, 1998
In the SQL Object manager tools for sql server 4.21 there was a gui interface for running BCP where you could select tables and fields etc.
I haven't beem able to find abnything equivalent in sql 6.5 enterprise manager. Am I missing someting, or was this dropped?
Thanks.
Jerry Dunn
ViaHealth
jerry.dunn@viahealth.org
View 1 Replies
View Related
Dec 17, 2004
I am getting "writing conflict" or "Update or Cancel Update Without AddNew or Edit" errors even though there is nobody else updating the same record. I use Access Form as interface, the DBMS is MS SQL Server 2000 Standart Edition. I did not write any code for the form and its AllowEdits property is set to Yes.
Can anybody tell me what is the problem and how I can fix it?
Thanks... :
View 10 Replies
View Related
Mar 29, 2012
We are looking for a way to have sales data to flow from 1 database to another database on same SQL server. Can we build or have a link between 2 database? If yes, how to and how much effort will that be?
View 2 Replies
View Related
Sep 6, 2007
I don't want to use SSRS's GUI for parameter entry. It's quite minimal and not very easy to use for users and doesn't cope very well with large selection lists (E.g if you wanted to select 3 companies from a list of 60 000 to run a report for).
So I want to make my own parameter entry screen and then pass only the user parameter value selection on to the report parameters.
Can I do that? Are the parameters exposed?
I'd wanna do something like:
My_SSRS_Rep.param1=@MyValFromMyApp1
My_SSRS_Rep.param2=@MyValFromMyApp2
My_SSRS_Rep.Run/Refresh/View
Currently I just have a Windows form with a web browser control in it.
And I've set the url to http://myserver/reportserver?%2fDB+Report+Server%myRep&rs:Command=Render
So it is possible?
Or do I need to go about this some other way like using the SSRS Report Viewer or some other mechanism?
Answer:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88484
Report Viewer it is then!
UPDATE1:
Or maybe not...
When I do the following, the report does not refresh:
Dim param(0) As Microsoft.Reporting.WinForms.ReportParameter
param(0) = New Microsoft.Reporting.WinForms.ReportParameter("Test", a)
Me.ReportViewer1.ServerReport.SetParameters(param)
Me.ReportViewer1.ServerReport.Refresh()
Anyone know why?
View 4 Replies
View Related
Jun 2, 2006
Comments and ideas for software tools (ActiveX components)to make a user interface for database.
View 3 Replies
View Related
Jul 20, 2005
Oracle has a 'wait interface' for monitoring bottlenecks, etc... does SQLServer have utilities like this?
View 3 Replies
View Related
Sep 13, 2007
I would like to initiate a discussion regarding a client-side interface using a SQL db. Specifically, I want to have all users with read-only privileges, but include an event on a form that will nevertheless update a record on the server using a different user identity in ADO code - one that has read-write privileges in the database.
Is this a common approach?
View 5 Replies
View Related
Oct 5, 2007
Is there a way to provide updates to the user interface during execution of a package? I realize it's not the purpose of SSIS, but would find it helpful... especially in terms of looping through recordsets, etc. what value a certain variable is set to.
View 1 Replies
View Related
Jun 13, 2007
I've been tasked to understand and develop an easy interface to query (insert, select, update, etc) a sql server compact database on an x86 win ce 5 machine. I'm using VS 2005 and have all the necessary SDK's installed. The problem is I can't find any good tutorials or documentation on sql server compact coding in C++ (only in C# and VB). Do y'all have any suggestions on where I can get started to learn the basic c++ sql interface coding?
Thanks!
Jeff
Edit: I'd like to note that I can run the sample northwind project on a win ce 5 x86 emulator, so it's not the setup that I need help with, but the actual coding.
View 6 Replies
View Related
Oct 7, 2007
When I initially downloaded SQL Server Express the System tables were visible using SQL Server Management Studio Express. I was able to create a new database and define and populate a couple of small tables. I then attempted to set up an ODBC SQL Natvie Client connection so that I could print the table contents using Crystal Reports. That failed with the following error message:
"An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections."
I subsequently uninstalled and reinstalled SQL Server Express. Now, I get the following error message whenever I try to connect to the database using SQL Server Management Studio Express. Additionally, the System tables are no longer visible. However, I can access my database via the Server Explorer in VS2005.
TITLE: Connect to Server
------------------------------
Cannot connect to STAN-DELLSQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
View 4 Replies
View Related