Question: 1. What is a data cube, also called a OLAP cube? 2.Tell me about fact tables and dimension tables. 3. How do you set up

1. What is a data cube, also called a "OLAP cube?"

2.Tell me about fact tables and dimension tables.

3. How do you set up BI analytics for a company from the ground up?

4. What is a data mart? When is a data mart a better choice than a single data warehouse?

5. Define OLTP and OLAP. How do they differ? What are they used for?

6. Which business intelligence (BI) tools have you used, and what are their pros and cons?

7. Why does BI do what it does?

8. What are some good things about data, Normalization, de-normalization?

9. What are the main things a BI developer has to do?

10. What are Business Intelligence's most important goals?

11. What do you think Business Intelligence means to you?

12. What are the most popular tools that Business Analysts use for Business Intelligence (BI)? 13. How will you use a business intelligence (BI) system in your work?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Schema Data Mart and Data Warehouses. Reading is below........ 1. Does this schema represent a data mart or data warehouse? Why? 2. There are two predominant schema designs mentioned in the reading...

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

4.3 Assignment 2: Data Mart (DM) data staging, ETL, implementations and considerations (50%) Formative feedback for task 3 is available in class in week 11 Task 1: Extract, Transform and Load (ETL)...

1 . Which of the following is an example of analytic information? a . Information about the amount of money in a checking account b . Information showing which airline routes tend to be most...

A data warehouse is which of the following? Can be updated by end users. Contains numerous naming conventions and formats. Organized around important subject areas. Contains only current data. An...

This week we learned how Excel can help to present and understand data for a company. Throughout Chapter 1 and 2, we see that Excel spreadsheets can be used to present data, total data, and display a...

Big dreams, arrogance, infighting, and delusion all collided in the disastrous attempt to fix venerable retail giant J.C. Penney. The inside story of a revolution derailed. WHEN YOU FIND A SAVIOR,...

A very large tele - communications company called Cell 9 , providing cellular phone services to a number of states in various regions of the country, plans to build a data warehouse for decision...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Can you please answer this questions below QUESTION 1 The key to any successful report is clarity, ____, completeness, and correctness. a. actuality b. longevity c. brevity 2 points QUESTION 2 A is a...

Compute if the dividend on the CD is 0 and the payoff is $1300 - max (0, 1300 S5.5) + max(0, S5.5 2600) and the initial price is to be $1300.

Consider a quadratic version of the estimated regression model given in the previous question: P-5.42-376x,-0.18.x According to the estimated model, which of the following statements is correct for...

Sofia, Marcus and Zara are discussing the methods they use to find the area of a trapezium. I work out a+b, then divide by 2, then multiply by h. I work out half of h, then work out a+b, then...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...