Business Intelligence Questions

Q:

What are the core BI tools that professionals work with? Which ones have you used?

Answer

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Report Error

View answer Workspace Report Error Discuss

0 596
Q:

what is flat aggregation?

Answer

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Report Error

View answer Workspace Report Error Discuss

0 583
Q:

How do we Tune the BO Reports for Performance Improvement?

Answer

We can tune the report by using index awarness in universe

Report Error

View answer Workspace Report Error Discuss

2 555
Q:

What is Catalog Manager? How to move reports and dashboards using Catalog Manager?

Answer

Catalog Manager supports command line options.


 


To move reports and dashboards, we need to use some general syntax using catalog manager.


 


e.g:


catalogmanager -online/offline


-cmd {report | replace | export}


{command line options}


In extra, by keeping it online, This will automatically open up the catalog 


manager without having the need to enter the connection details every time.

Report Error

View answer Workspace Report Error Discuss

0 504
Q:

What is a BI dashboard?

Answer

Dashboards are real-time business intelligence interfaces. They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

Report Error

View answer Workspace Report Error Discuss

0 479