DATA TECHNOLOGY PARTNERSHIP PROGRAM
Programme Overview
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server data Quality Services and SQL Server Master Data Services.
Every student will learn how to:
- Describe data warehouse concepts and architecture considerations.
- Select an appropriate hardware platform for a data warehouse. Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
- Implement Control Flow in an SSIS Package.
- Debug and Troubleshoot SSIS packages.
- Implement an ETL solution that supports incremental data extraction.
- Implement an ETL solution that supports incremental data loading.
- Implement data cleansing by using Microsoft Data Quality Services.
- Implement Master Data Services to enforce data integrity.
- Extend SSIS with custom scripts and components.
- Deploy and Configure SSIS packages.
- Describe how BI solutions can consume data from the data warehouse.
Course Objectives
After completing this course, students will be able to:
- Design and build a complete Android application.
- Debug and maintain Android applications using different tools and plugins.
- Thoroughly understand the life-cycle of an Android application and its main components.
- Use external resources, manifest files, intents and adapters
- Understand and use all Android persistent storage techniques: Preferences, files, databases, and content providers.
- Use Android’s background processing techniques.
Who should attend?
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be will attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
Course Pre-requisites
This course requires that you meet the following prerequisites: At least 2 years experience of working with relational databases, including:
- Designing a normalized database.
- Some exposure to basic programming constructs (such as looping and branching).
- Creating tables and relationships
- An awareness of key business priorities such as revenue, profitability, and financial accounting.
- Querying with Transact-SQL.
Course Outline
Industry 4.0: Introduction to Concepts & Technology Pillars
Overall course objective and deliverables Overview of the course outline
- What is Industry 4.0 and why now?
- What enabled the new revolution?
- Industry 4.0 framework & blueprint
- Digital Supply Chain, IIoT, Cloud, Big Data Analytics
- Cybersecurity, Augmental Reality, Additive Manufacturing, Horizontal & Verticial Integration
- Autonomous Robot, Artificial Intelligence, New Business Model
- Business and operation & Best practices from the pioneers
- OT & IT convergence and New roles and responsibilities
- New steps
Industry 4.0: Introduction to Concepts & Technology Pillars
- Overall of Data Warehousing
- Considenrations for a Data Warehouse Solution
- Considerations for Data Warehouse Infratructure
- Planning Data Warehouse Hardware
- Data Warehouse Design Overview
- Designing Dimension Tables & Designing Fact Tables
- Physical Design for a Data Warehouse
- Introduction to ETL with SSIS
- Exploring Data Sources & Implementing Data Flow
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers & Managing Consistency
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
- Planning Data Extraction
- Extracting Modified Data
- Planning Data Loads
- Using SSIS for Incremental Loads
- Using Transact-SQL Loading Techniques
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Introduction to Master Data Services
- Implementing a Master Data Services Model
- Managing Master Data
- Creating a Master Data Hub
- Using Scripts in SSIS
- Using Custom Components in SSIS
- Overview of SSIS Deployment
- Deploying SSIS
- Projects Planing SSIS Package Execution
- Introduction to Business Intelligence
- Enterprise Business Intelligence Self-
- Service BI and Big Data
Trainer's Profile
MR. BALASUBRAMANIAN@BALAN
Balasubramanian@Balan is a certified Trainer with specialization in the field of Information Systems and a Master’s Holder in Business Administration. Being exposed to information systems and network operations based environment, he have garnered interest in that respective field. Ever since then he have continuously updated himself with various kind of knowledge either from the area of training or having managing medium range project locally or abroad. One of the mainstream project that was partially outsourced, in the area of complete network infrastructure implementation, configuration was handled and completed in due time which also contributed to his additional knowledge on different area of skills which could have not been obtained via certification. He has served corporate gaints such as LYODD Register, Kuala Lumpur Center Berhad (KLCCB), Putrajaya Hodlings (PJH), University Technology Petronas (UTP), Maxis Communication Berhad, Asia Pacific Broadcasting Union (ABU), United Nations Development Programme and Kuala Lumpur Heart Care ( KLHC). He is currently associated with I Tech Train as a Project Consultant. He has been a project manager and technical trainer since year 2007 and has educated many corporate professional from various industries ever since then. Balan was responsible for the preparation and assessment of training and developing and updating the course outline and content. Meanwhile he also provides consultation to department which requires special training and outlining the course specification in accordance to the organizational goal.