Duration: Hours

Data warehouse and business intelligence are terms used to describe the process of storing all the company’s data in internal or external databases from various sources with the focus on analysis and generating actionable insights through online BI tools.

 

Training Mode: Online

Description

What are data warehouse skills? Data Warehouse Development requires a developer with great analytical, computer and communication skills. It is important to have hands-on experience with ETL tools as well as a working knowledge of structured query language (SQL), Business Intelligence best practices and data warehouse and reporting techniques.

Data Warehousing and Business Intelligence – Course Outline

Prerequisites:
Basic understanding of computer technology

1: Understanding Business Intelligence

a). The Challenge of Decision Making

b). What Is Business Intelligence?

c). The Business Intelligence Value Proposition

d). The Combination of Business and Technology

2: Business Intelligence Technology Counterparts

a). Enterprise Resource Planning

b). Customer Relationship Management

c). Business Intelligence and Financial Information

3: The Spectrum of Business Intelligence

a). Enterprise and Departmental Business Intelligence

b). Strategic and Tactical Business Intelligence

c). Power and Usability in Business Intelligence

d). Data Warehousing intelligence

e). Finding the Right Spot on the Continuum

f). Business Intelligence: Art or Science?

4: Business Intelligence User Interfaces

a). Querying and Reporting

b). Reporting and Querying Toolkits

c). Basic Approaches

d). Data Access

e). Dashboards

f). Briefing Books

5: On-Line Analytical Processing (OLAP)

a). What Is OLAP?

b). OLAP Applications and Functionality

c). Multi-Dimensions

d). OLAP Architecture

e). Data Mining

6: What’s next?

a). Visualization

b). Guided Analysis

c). Handling Unstructured Data

7: Business Intelligence: Is It for You?

a). How Do You Know?

b). Customizing Business Intelligence

c). The Business Intelligence Project Plan

d). Human Factors

e). “Could Be” as Opposed to “Should Be”

f). Choosing the Right Size, Shape, and Cost

g). Best Practices

8: The Bottom Line

a). Ideas to Use

 

For more inputs on Data warehousing you can connect here.

Contact the L&D Specialist at Locus IT

Reviews

There are no reviews yet.

Be the first to review “Data Warehouse Business Intelligence”

Your email address will not be published.