Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Software for An...  What types of software tools do you use?
Previous Previous
 
Next Next
New Post 6/14/2011 9:29 AM
User is offline josh
1 posts
No Ranking


Re: What types of software tools do you use? 

I'm with Quest Software, so I'm biased, but Quest offers a tool designed specifically for analysts called Toad for Data Analysts. It is basically as a cross-playform SQL query and analysis tool that enables you to write high performance queries without being a SQL expert. It has advanced features like:

  • Connects to virtually any source (RDBMS, BI systems, Salesforce.com, Excel, Hadoop, NoSQL)
  • Cross-platform data comparison
  • Visual query builder
  • Data visualization
  • Advanced analytical function
  • Data cleansing

The 15-day trial can be download from http://www.quest.com/toad-for-data-analysts or you can download the freeware/lite version at http://www.toadworld.com

 

 
New Post 8/17/2010 7:14 AM
User is offline joetraff
2 posts
No Ranking


Re: What types of software tools do you use? 

 larimar wrote

Currently:

  • MS Word for use cases, test plans, test cases
  • MS Excel for requirements, business rules, actors catalogue, issues log, change requests log, traceability matrices
  • MS Visio for sample UI mockups
  • Enterprise Architect for BPMN and UML diagrams (would use for ER diagrams too if I did any)

I have also been looking at more sophisticated tools for managing requirements end-to-end between BAs, developers, testers, and PMs.  Some of the tools we've looked at are:

  • Borland CaliberRM
  • GatherSpace
  • stpSoft Reqsheet
  • Artifact Lighthouse
  • Visual Studio Team Server (on its own... some of the above products integrate with this as well)

I have yet to find what I would consider an all-encompassing solution, so I expect some customization will occur with whatever we decide on (like a VSTS integrated tool).

Great reply.

Keep on sharing.

 
New Post 2/24/2012 1:56 PM
User is offline Sandy
74 posts
8th Level Poster




Re: What types of software tools do you use? 

The International Council on Systems Engineering (INCOSE) publishes a very nice comparison of requirements management tools by feature-set, in Excel format:

http://www.incose.org/ProductsPubs/Products/INCOSERMToolSurveyConsolidatedResults.xls

I've used a number of tools and have my own preferences - I find that some tools claim to be 'requirements management' tools but are in reality just requirements repositories. 

As a consultant, my choice of tools usually comes down to the tools that are available at my client's organization.  Most of these requirements management tools are enterprise products (not just a matter of installing them onto your desktop off a CD and going from there) - it usually takes someone familiar with the tool to setup, configure, and continue to administer it on a central server. (Most have some form of browser-based access and/or desktop client access).

Outside of requirements management tools, there are business process modeling tools (Enterprise Architect, for example) - but as above, these are an enterprise / organization investment.  So the old-fashioned tools (when you can't get post-it notes and scotch tape) like Visio still work well.

There are also tools for creating nifty screen mockups like Balsamiq's Mockups, and there are some freeware tools as well.  I'm not as familiar with these (outside of the Balsamiq product), and would be interested to hear about people's experiences with these types of tools.

Sandy

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Software for An...  What types of software tools do you use?

Community Blog - Latest Posts

m_anst
m_anst
What Does Success Look Like? I challenge Business Analysts to view requestors’ requirements as an opportunity to define success. Too often, teams fall into a trap focused on requestors’ prescriptive requirements that are meant to serve as roadmaps for developers and testers. When you limit your view of requirements to this prescripti...
0 Responses
Mariya Kotsupalova
Mariya Kotsupalova
They say the best criteria of Business Analyst’s success are a happy customer (business) and a happy engineering team. But what does it mean? How can we break down happiness and measure it? These are precisely the questions my 8 BAs team and I tried to answer this year. The result was a surprisingly efficient pair of surveys we developed and ...
0 Responses
Rajesh-N
Rajesh-N
Explore the Benefits of RPA's Adoption Across Segments In the past few years, we have seen steady growth in Robotic Process Automation (RPA). It gathered momentum in 2019 and became a hot topic in IT and business circuits in 2020. The power of process automation will be felt even more strongly, propelling its adoption as a replacement f...
0 Responses






Copyright 2006-2020 by Modern Analyst Media LLC