Business Intelligence Questions

All the above given statements are functions of Inventory.

Inventory or stock is the goods and materials that a business holds for the ultimate goal of resale. Inventory management is a discipline primarily about specifying the shape and placement of stocked goods.

The primary function of inventory is to use marketing and production to increase profitability, to get the maximum amount for the business' investment. There are other functions of inventory, such as balancing supply and demand, improving efficiency, establishing a safety stock and geographical specialization.

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.

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.

We can tune the report by using index awarness in universe

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.

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

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft applications and consultation to customers with their computer-related tasks.

It's called Broadcast Agent Server. Its function is torun the jobs or reports scheduled and can be monitored using Broadcast Agent Console.

1. Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart. 

2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS. 

3. Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.