| |
GeekInterview.com > Interview Questions > Management > Business Analyst
| Print | |
Question: Reporting Tool
Answer: 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. |
| March 03, 2009 05:46:56 |
#1 |
| Arpit Mediratta |
Member Since: March 2009 Total Comments: 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
|
| |
Back To Question | |
