Business Analyst - Reporting Tool

GeekInterview.com > Interview Questions > Management > Business Analyst

Go To First | Previous Question | Next Question

Business Analyst | Question 126 of 128

Reporting Tool

What are the reporting tools used by BA. How do you decide that which reports you have to extract or on what basis you extract the report? What are the fields or the data when you extract in a report? How often you extract report.

Total Answers and Comments: 4

Last Update: October 27, 2009 Asked by: nehasahu

Sponsored Links

Best Rated Answer

—

Submitted by: Arpit Mediratta

Dear,

There are two ways to Get or retrieve Data/Reports from database or warehouse.

TWO WAYS:

1. SQL Query or Statement: This si commonly used by developers or program managers.

2*. OLAP TOOL: "Online Analytical Processing" Tool also helps to fetch the reports with out SQL query.

Tool Examples: [COGNOS, Business Objects.....]

--------------------------------
ETL: ETL is just one step above to OLAP tool.

WHY & WHERE ETL is USED:

ETL: Extract + Transformation + Loading

ETL is used when one is not having local access. And have only remote connection, thin client.

One can extract, transform the data and upload in the warehouse for the same.
--------------------------------

OLAP comes after ETL.

Once developers uplaods in the warehouse, BA can fetch reports using OLAP tools.

HYPERIAN also is somewhat inclined in the same tune but a Business Intelligence Tool rather than Reporting Tool.

Thanks and Sincere Regards,
arpit mediratta

Above answer was rated as good by the following members:
neilkommu

March 20, 2009 05:46:56

Arpit Mediratta

Member Since: March 2009 Contribution: 2

RE: Reporting Tool

Dear

There are two ways to Get or retrieve Data/Reports from database or warehouse.

TWO WAYS:

1. SQL Query or Statement: This si commonly used by developers or program managers.

2*. OLAP TOOL: "Online Analytical Processing" Tool also helps to fetch the reports with out SQL query.

Tool Examples: [COGNOS Business Objects.....]

--------------------------------
ETL: ETL is just one step above to OLAP tool.

WHY & WHERE ETL is USED:

ETL: Extract + Transformation + Loading

ETL is used when one is not having local access. And have only remote connection thin client.

One can extract transform the data and upload in the warehouse for the same.
--------------------------------

OLAP comes after ETL.

Once developers uplaods in the warehouse BA can fetch reports using OLAP tools.

HYPERIAN also is somewhat inclined in the same tune but a Business Intelligence Tool rather than Reporting Tool.

Thanks and Sincere Regards
arpit mediratta

Is this answer useful? Yes | No

1 2

Overall Rating: -1

October 06, 2009 05:19:20

dpkhca

Member Since: October 2009 Contribution: 2

RE: Reporting Tool

I would classify reporting tools into two types :

1)Adhoc Reporting
2)Dashboard

Is this answer useful? Yes | No

October 06, 2009 05:23:25

dpkhca

Member Since: October 2009 Contribution: 2

RE: Reporting Tool

For best solution a BA should pref use Business Intelligence tools as Cognos Discoverer Crystal reports etc. These BI tools can provide you with a high level as well as detailed reporting. Number of time you have to run reports depends how frequently you want to see the data or how frequently the data is updated.

Is this answer useful? Yes | No

October 26, 2009 18:02:11

Inclus12

Member Since: October 2009 Contribution: 2

RE: Reporting Tool

Guess your question needs to be more specific. but the general idea is it depends on what sort of report is expected and who the user is. For example if you are using Business Objects to create a report and the user of the report does not have access to the tool then you are going to have to export it. (and the frequency will depend on factors such User needs and data frequency by which I mean that if your data is update once every week there is no point in creating a daily report because it will be the same for a full week).

Hope this helps!
http://Inclus.net

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank