Victoria College offers a special set of Data Warehouse Courses to
help you find your dream job quickly and easily:
Introduction to Data Warehouse (Data Modeling, 20 hours):
To help you understand the basic concept, methodologies, standards and procedures of data
warehouse industry. In addition, to help you get familiar with Erwin, the most
popular data modeling tool to effectively design your data warehouse.
Data Warehouse Informatica (Data Integration, 20 hours): To
help you learn step-by-step one of the most valuable skills of a data warehouse expert -
to Extract, Transfer and Load (ETL) data. A leading tool, Informatica, is used to
ready you for the corporate jobs available in big companies.
Data Warehouse Cognos (Business Intelligence, 20 hours):
To help you to master the Business Intelligence (BI) projects with best practices in
market. This
course covers the methodologies, basic and critical skills, major components in
BI application development. You will learn the design and development in a BI
project. You will learn to use the leading BI tools (IBM Cognos) to
get you
ready for DW jobs in the top 500 companies.
For Details,
Please Contact Us Today:
Here is what you are going to get:
Extensive skills and in-depth knowledge to prepare you for the highly
paid, stable jobs in large organizations
Solid hands-on skills using the most popular, widely recognized and
utilized tools (You will also learn how to prepare and present yourself properly if your
next job requires different tools.)
To equip yourself to suit for different roles in any data
warehousing
project: 1) Data Modeling; 2) Data Integration; 3) Business Intelligence
To learn the senior level skills - methodology, analysis, design, best
practice and problem solving
To learn from the True data warehouse experts: With a total of 50 years
of solid IT experiences, the 3 instructors will share with you their knowledge and
experiences for data warehouse development and career progress
For Details,
Please Contact Us Today:
Need Personal Assistance?
Every year, our program is helping hundreds of students to become data warehouse
experts for large organizations. Now it’s your turn to join
this special program that will hold your hands and walk you step-by-step till you find
your first professional data warehouse job.
For more information on this effective
program and how you can set up a 1 to 1 FREE consultation session, please contact us
today:
“Is this course for me?”
This course is ideal for:
- People with some IT background but want to move to a better paid, less
competitive and more secured position, for example C++, Java and .Net developers,
BSA, Tech lead, DBA and other technical experts
- Or those who want to add one more key IT technology to their background
for better career future, such as BA and QA experts or project manager
Data Warehouse: A Career Future with High Payment & Excellent Job Security
Data warehouse is the key component for large organizations, such as banks, insurance
companies, investment groups, large retailers and government agencies.
Data warehouse is widely used for sales, marketing and financial data storage, analysis
and reporting. Data warehouse experts therefore become the key players to help
business win the competition.
Depending on your background and related experiences, your salary can vary from $65K
to $90K+.
In addition to the potential payment increase, job security is another
benefit: Data warehouse stores mission critical, extremely sensitive data of the
business. Therefore it is extremely hard for business to outsource data
warehousing jobs to another country.
If you want to become successful
with your data warehouse career, the choice is clear:
Contact us today for additional information, or a FREE 1 to 1 personal
consultation session:
Where Can You Find Jobs?
You can work for almost all the large companies, such as:
- Banks
- Insurance companies
- Investment groups
- Credit card companies
- Phone and cell phone companies
- Large retailers, restaurants and hotels
- Government agencies
- And a lot more...
For Additional Information,
Please Contact Us Today:
Instructors
Instructor for "Introduction to Data Warehouse (Data Modeling)"
Currently working for the Government of Ontario as a senior Data Architect. CBIP,
CDMP, Senior Data Architect, over 15 years experience in Data Warehouse.
A seasoned Data Architect who has over 15 years experience in Data
Warehouse.
The instructor was a Sr. Consultant with a reputable global Consulting firm. His
job involved a wide range of assignments covering designing, prototyping,
developing and troubleshooting OLTP databases and Decision Support Systems (i.e.
Data marts and Data warehouses).
Instructor for "Data Warehouse Informatica (Data Integration)"
With close to 20 years of extensive IT experiences for data warehouse, BI development
and other mission critical projects for both public and private sectors.
Enterprise Data Warehouse Analysis and ETL Developer, extensive experience in most
aspects of Information Technology such Software Development, Database Administration,
Systems and Business Analysis, Data Modeling, Data Warehousing,
INFORMATICA and DATASTAGE/COGNOS BI and Project Management for Consulting, Manufacturing
and Public.
Instructor for "Data Warehouse Cognos (Business Intelligence)"
Currently working for the Ministry of Education.
Senior BI Consultant, over 13 years experience in Data Warehouse and Data Mart
Projects, 15 years in IT industry. Extensive experiences in enterprise, complex IT
projects using BI, data warehouse/ETL, SOA (Cognos, Informatica,
DataStage, Hyperion) and other leading technologies.
For Additional Information,
Please Contact Us Today:
More Information
Duration
60 Hours
Overview
As human race stepped into the information age, information is power. Business today moves
at the speed of information. Getting the right information into the right hands at the
right time is essential. Companies leverage, exploit and maximize their information assets
have a strategic advantage over their competitors.
As management of information becomes more crucial to business, information capture is
not enough for business today, data quality and data analysis plays a critical role in ROI
for business.
That is also why data warehouse plays an important role in IT industry. Business can
halt the business development due to the impact of low economy, but they cannot stop the
data collection and management at any time. In order to increase the competitive power,
data analysis and prediction become the key factor to be the winner in competition. That
is also why ETL and business intelligence are getting an undeniable position today.
Objectives
This course will provide the students the full picture of data warehouse life cycle with
practical examples and in depth knowledge. In addition, it covers the critical phases in
building/developing Enterprise Data Warehouse such as Data Modeling using ERWIN, ETL
design and development using INFORMATICA and Business Intelligence using COGNOS.
Topics
- Overview of Data Warehousing
- Data Warehouse Architectures
- Dimensional Modeling
- Data Warehouse System development Life Cycle
- SOA Data Integration
- ETL Design and Development
- Performance Management and Business Intelligence
- Data Mart Design and Development
Audience
Discerning candidates who wish to specialize in one ore more of the following areas:
- Data Warehouse Architecture
- Data Architecture
- Data Modeling
- ETL Design and Development
- BI Design and Development
- Enterprise Data Warehouse Systems Analysis
- Possible Job Positions
- Data Analyst
- Information Architect
- Data Modeler
- Data Architect
- ETL Architect
- ETL Developer
- BI Architect
- BI Developer
- Project Managers
- Data Warehouse Testers
- System Analyst
- Data Warehouse Architect
Prerequisites
Candidates for this class must have:
- IT background Knowledge
- Knowledge of at least one of the following RDBMS Oracle, MS-SQL, DB2 and Sybase
- Data Warehouse Course Outline (60 hours)
- I. Data Warehouse and Modeling (20 hours)
For Additional Information,
Please Contact Us Today:
I. Introduction to Data Warehouse (Data Modeling) 20 hours
Module 1: Overview of Data Warehousing
- Definition of Data Warehouse
- Characteristics of Data Warehouse
o Time variant
o Subject oriented
o Non volatile
o Integrated
- Components of a Data warehouse
o Data sources
o Data staging area
o Presentation area
o ODS
o Data mart
- Approaches of Data warehousing
o Consolidation (ETL, EL-T, ETPL)
o Virtualization (EII)
o EAI
Module 2: Data Warehouse Architectures
- Temporary staging
- No staging
- Persistent staging
- ODS
Module 3: Data Warehouse System development Life Cycle (SDLC)
For Additional Information,
Please Contact Us Today:
II. Data Warehouse Informatica (Data Integration) 20 hours
Module 1: ETL Concept, Definition and PowerCenter Technical Architecture
- Data Integration
- ETL Concepts
o Source System
o Mapping
o Target System
o Metadata
o Staging Area
o Cleansing
o Transformations
o Workflow
o ETL Process Flow
- PowerCenter Architecture
o Sources
o Targets
o PowerCenter Server
o Repository
o Repository Server
o Repository Agent
o Client Tools
o Informatica Connections
o Informatica Components
Module 2: Components of Informatica Mapping and Workflow
- Sources and Targets
o Overview of the various Sources and Targets
o Importing a Source
o Create a Source and Target manually
o Create a Target from a Source
- Mappings Overview
o Creating an Informatica Mapping
o Passive and Active Transformations
o Using Ports
o Expressions
- Workflow and Sessions
o Using Workflow Manager and Workflow Monitor
o Tasks, Sessions and Workflow
o Scheduling your Workflow
Troubleshooting
o Workflow and Session logs
o Tracing Levels
o Using the Debugger
o Error Handling guidelines
o Informatica Tuning
Module 3: Advanced Mapping and Workflow Concepts
- Other Transformations
o Using additional Informatica transformations
o Understanding performance implications
- Advanced Mapping and Workflow Concepts
o Reusable Transformations
o Maplets
o Worklets
o Tasks
o Reusable Tasks
o Using Parameter Variables
o Understanding Server Variables
o Understanding Session Variables
o Parameter Files
- ETL Design Documents Definition and Preparation
o STM
o Design Documents etc
- Data Warehouse Project and Interview Preparation
For Additional Information,
Please Contact Us Today:
III. Data Warehouse Cognos (Business Intelligence) 20 hours
Module 1: Data Mart and Architecture
- Data Warehouse and Data Mart
- Business Intelligence Architectural Design
- Multi-dimensional database, Star Schema, Snow Flake Schema
Module 2: Cognos Technical Architecture and Design
- Architecture, Deployment and Security
o Cognos Connection Management
o Security
Module 3: Meta Data Modeling
Module 4: Querying, Reporting and Analytics
- Self-Service Query Component – Query Studio
- Advanced Reporting – Report Studio
- Analytics Analysis Studio
o Transformer and Impromptu (optional)
- Scorecard and Metrics
- v Event Management
Module 5: Milestone and Future of BI
- Future Trend of BI and Analysis
- Conclusion and Lesson Learn
For Additional Information on how
you
can take advantage of this special program, Please Contact Us Today:
* * *
Special Report:
Have You Well Prepared For the Subprime Crisis Impact? Is
Data Warehouse A Choice?
Author: Stephen (DW instructor at Victoria College)
It is a fact that the continuing devastation unleashed by the US subprime crisis not only
impacts America’s economy, but also the globally impacts may come as the dominoes
effect. The recession of US also seems an admitted fact according to some economists
forecast. The global trend is an unchangeable fact, but our attitude and preparation can
be under our control.
According to the Goldman Sachs survey published in 2008 July, there is a
demand for discretionary IT projects slows, CIOs anticipate cutting contract IT workers,
staff from third-party service providers and even some of their own in-house staff. The
global services companies will also feel the pinch due the slowing economy. ROI is always
an important consider form all business; budget control will become more significant. In
turn, outsourcing will still plays an important role in finance control.
Facing the coming challenges, how do we prepare for the coming challenges?
What’s the tactics for that?
- How to Save Your Job When Layoffs
- Are the Order of the DayRecession-Proofing Your Career in IT
- 10 Secrets for Searching for a Job During a Recession
- 6 Recession Proof IT Jobs
Personality for sure is a critical factor for success in career, but right
choice of your job is also a crucial factor to help us to achieve the goal getting a good
life. As the waves of Y2K and dot com have raised and fall. Technology is still one of the
two wheels to help a business success. When we decide to dive into the main stream of
technology, it is not easy to decide we choose the right one. Some factors which need to
be considered such as the publicity, marketability and stability, etc.
In order to well-equipped for this economic changes, equipped with
knowledge of data warehouse will be one of the beneficial solutions. The reasons why data
warehouse is the choice can be listed below:
The Change of Data Warehouse is less vigorous compared to Programming -
As Data Warehousing became the key trend in corporate computing in the 1990s till now. The
demand for data warehouse is still in growth with a steady rate disregarding the changes
of economy. The pace of programming technology changed vigorously in the past ten years,
the changes of data warehouse seems steadier compared to programming languages. With the
market demand of data analysis with using business intelligence, the role data warehouse
gets more important and higher in demand crossing from large enterprise to medium size
companies.
The Impact from Outsourcing to Data Warehouse is less compared to
Application Development - Outsourcing is an unchangeable fact happened in IT today. More
development or supporting jobs had been outsourced. From experience, quite a lot of big
corporations found out that the data warehouse area is not easy and better not to
outsourcing due to the reasons of maintenance, data privacy, etc.
The Demand of Data Warehouse specialist is not heavily affected in a
slow economy - In a slow economy, the first impact to IT is the stop of the application
development due to budget control. Usually the business application development is the one
first to be got hit due to the reason of priority. It is because data is the critical
factor must be maintained for operation of the business. In some situation, investment on
data management becomes important because companies need to increase their competitive
power in turn in investment in the data analysis and marketing campaign plays important.
It makes the data warehouse plays an important role in this special period of time.
The Global Trend and Demand on Business Intelligence Drives the Need of
Data Warehouse - As the business intelligence is widely in different industries, the
demand of the data warehouse skill people increase as well. Business intelligence not only
limited to client/server based or web-based only, but extended to the area of wireless. In
addition, the growth of operational BI has also provided a message that more IT resources
are needed in this area.
Holding Information is Holding the Key of Business - However, data
cannot leave aside and had to be maintained. Everyone knows “Holding the information
is the holding the power”. It gives the sufficient reason that data warehouse or data
management is more stable spot in a volatile economy.
Transferable in Job Market – Equipped with the data warehouse
knowledge, it will increase your capability to fit the job market of the data warehouse
directly or indirectly. The previous IT experience is still an asset because data
warehouse is not like a clear cut area from other IT area. It is closely related to the
business application, ERP, CRM, etc. Having the knowledge the data warehouse, it can equip
you to be a data modeler, ETL developer, BI developer, data warehouse QA or business
system analyst, etc.
The Software vendors Increase the competition in the Data Warehouse
market – From the fact of the acquisition of the IBM to Cognos, SAP to Business
Objects and Oracle to Hyperion, we do know that the big software vendors has a keen and
big interest in the data warehouse and foresee the demand of the data warehouse. From the
changes of Microsoft SQL Server 2000 to SQL Server 2008, it confirms that the profit
market in data warehouse cannot be neglected.
Not a lot of people can get to the cream of the technology, but everyone can catch the
tide of the global trend. For sure data warehouse will still plays an important role in
computer industry. No one can foresee when the impact of the subprime crisis will end, but
you can decide how to prepare yourself facing the changes. The clever person is the one
who get prepared before the storm coming. A wise choice is a turning point for a better
life.
For Additional Information,
Please Contact Us Today:
Learn from the 3 experts and enjoy the
extremely affordable tuition fee!
|