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
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
f). Briefing Books
5: On-Line Analytical Processing (OLAP)
a). What Is OLAP?
b). OLAP Applications and Functionality
d). OLAP Architecture
e). Data Mining
6: What’s next?
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