perform the following case problems for excel chapters 2

perform the following case problems for excel chapters 2.

Perform the following Case Problems for Excel Chapters 2.

Submit your final solution workbooks under Assignments Excel Case Problems

• Complete and solve these case problems:

o Case Problem Level 1: Filename: Crème Current Sales Analysis.xlsx (See pp. 147-149)

o Case Problem Level 2: Filename: LaRosa Demographic Analysis.xlsx (See pp. 149-150)

o Case Problem Level 3: Filename: CKG Parts Analysis.xlsx (See pp. 150-153)

Our focus will be

  • Explain the basic definitions and concepts of data warehouses
  • Explain data warehousing architectures
  • Describe the processes used in developing and managing data warehouses
  • Explain data warehousing operations
  • Explain the role of data warehouses in decision support
  • Explain data integration and the extraction, transformation, and load (ETL) processes
  • Describe real-time (active) data warehousing
  • Explain data warehouse administration and security issues
  • Solve problems with Excel’s Statistical Analysis Tools
  • Lecture and Readings

  • Business Intelligence: Chapter 2: Introduction to Business Intelligence
  • perform the following case problems for excel chapters 2