• Develop star and snowflake schemas for decision-making purposes

• Describe the characteristics and capabilities of online analytical processing (OLAP)

• Describe the role and functions of data analytics and data mining

• Explain how SQL analytic functions are used to support data analytics

• Define data visualization and explain how it supports business intelligence