At STAR BASE, we are application developers. Normally if an application developer has an issue with how to do something in SQL, a good developer can google it and come up with a quick solution. But when it comes to generating and using a list of sequential numbers, it appears that the most common method used could be categorized as brute force. That is generating a table with all known integers, or at least enough to support your application, and join to it. However, I have found a solution, that admittedly may only work with DB2, that uses recursive SQL to solve the problem. Check this out:
with sequence (seq) as (
select 1 from sysibm/sysdummy1
union all
select s.seq + 1 from sequence s where s.seq < 9
)
select * from sequence
This bit of SQL will generate the following response:
1
2
3
4
5
6
7
8
9
To adjust the ending point, change 's.seq < 9' to the appropriate ending point.
To adjust the starting point, change 'select 1' to the appropriate starting point.
To adjust the increment, change 'select s.seq + 1' to the appropriate increment.
For example to generate a list from 10 to 100 by 5 you can use the following SQL:
with sequence (seq) as (
select 10 from sysibm/sysdummy1
union all
select s.seq + 5 from sequence s where s.seq < 100
)
select * from sequence
This can be used to solve several problems including generating n random numbers, determining the missing numeric keys in a file, and determining the numbers in a range. Can you modify it to work with your DB?
It would be unfruitful for an enterprise application development team to take a project through the project life cycle (PLC) and implement the solution if nobody in the organization is going to use it. I have witnessed many times a solution gets implemented and the business users don’t like the new process and often times find ways around it. Business users try to continue on a path of “doing it the way we have been doing it for years”; which makes the job of the BA more difficult as he/she is the Agent of Change within the organization. To get the business users out of that mindset and accept new, more efficient, ways of doing things is one of the goals of assessing organizational readiness. This task is centered on identifying whether the organization, and the people in it, is ready to effectively use a solution ready for implementation. The Business Analyst should identify the forces that support and oppose the proposed change to the organization. In this way the BA can work to mitigate the opposition of the change, by identifying any training needs or other techniques that will make implementation of the solution go more smoothly and be effectively used for its intended purpose.
One of the tasks of a Business Analyst (BA) is Solution Validation, as it is defined in the BABOK®. This is usually carried out by supporting the testing phase of the project once the entire solution or one or more features of the solution has completed development. This would depend if you are using the Waterfall or Agile approach to application software development.
There is no doubt that a considerable amount of resources of an organization is spent on requirement definition and documentation no matter where the maturity of the Business Analysis practice within the organization. The business has a considerable interest in requirements that lead to IT business solutions and it can define the direction and prosperity of the entire organization.
Any application development team member, whether in Cincinnati, Dayton or other business community, knows that a software development project goes through many phases, known as the Project Life Cycle (PLC), and through many tasks within those phases. These include: develop business case, develop project charter, develop project scope, develop solution scope, elicit business and non-functional requirements from stakeholders, requirements management and communication, risk assessment, develop project schedule, develop work breakdown structure, analyze current-state systems, develop future-state models, develop use cases, develop user stories, develop data models, development functional design, develop technical design, develop solution, handle development issues, test solution, facilitate user acceptance testing, implement solution, post-implementation support, handle production issues caused by solution, turn over solution to IT support team. (Quite a list, huh?) Your list may be slightly different than mine, but I believe the essence of a project has been captured.
Usability Testing is done by selecting three to five persons from the user community, usually from the primary or secondary user group of the user interface, and have them test a mockup of the interface. No more than five users are necessary for usability testing as you will receive decreasing benefits from additional users. Also, you may have to run more than one round of usability testing. Take the results of the first round that suggest changes are needed, make those changes to the mockup and run another round of usability testing with different three to five users.
As a Business Analyst (BA) we are often asked to help design a new user interface and the supporting application to perform a required function in the Enterprise Resource Planning (ERP) system. If you are talking about a web interface you may work with a graphic designer, or perhaps not. You go off with your business application development design team and create a mock-up of the interface and write a design specification describing how it is to be built. Often the business is not represented on the design team. The design team may pass the mock-up and design specification by a business Subject Matter Expert (SME) before attempting to get it approved; but then they are often approved by a business manager without ever being seen by the end-users that will actually use the new application. Often, features and function are primary concerns when the design is being created. What if we change focus of our design team?
e is a Fad”. Now I know that will get a few of my other friends’ up in arms ready to defend their approach to IT project work. I can see the smoke coming out of their ears now. However, if you read Kupe’s article he says that “the word agile is a fad, the agile movement is definitely a trend.” I think it is safe to say that Agile is the hottest trend in IT project work these days. Many companies have switched over to Agile over these past few years and many more companies are considering the move. It has prompted many training courses by education providers. So let’s take a deep, hard look at the Agile “movement” and see if it is a fad, or is it here to stay? Is Agile really any better than Waterfall? What is the next best thing that will come down the pike?
Still a very timely topic of discussion, from the person who wishes to transition into a Business Analysis career who wants to know what skills they must have to be a successful BA, to the new BA who wants to know what skills they need to add to their repertoire, to the Senior BA who wants to know where to go next in their career; everyone wants to know how to improve their skills to get to that next level of their career.
One of my fellow
It took decades to get it where it is today. I am sure you can find bright spots in which IT and Business work together to achieve their goals, but in more organizations than not, this is not the case. Just as business processes and technology advance year by year, the relationship between IT and Business can be made better. I believe the Business Analyst is in prime position to turn the relationship around to a positive, collaborative, trusting relationship in which the two work together to achieve the strategic goals and initiatives of the organization. Why the BA? The BA is one role that works on both sides of the fence. The BA works with business stakeholders to bring out requirements for business improvement or application development solutions. The BA also works with the IT Solution Delivery Team to develop the solution that meets the business requirements. As the BA works with both teams, they are in prime position to bridge the gap between the two. So how should the BA go about bridging the gap?