Employment opportunities video lecture

Loading...

En provenance du cours de University of Colorado System

Data Warehouse Concepts, Design, and Data Integration

749 notes

University of Colorado System

Data Warehouse Concepts, Design, and Data Integration

749 notes

Cours 2 sur 5 dans Specialization Data Warehousing for Business Intelligence

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects. In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you’re done with this course, you’ll be able to: * Evaluate an organization for data warehouse maturity and business architecture alignment; * Create a data warehouse design and reflect on alternative design methodologies and design goals; * Create data integration workflows using prominent open source software; * Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and * Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software

À partir de la leçon

Data Warehouse Concepts and Architectures

Module 1 introduces the course and covers concepts that provide a context for the remainder of this course. In the first two lessons, you’ll understand the objectives for the course and know what topics and assignments to expect. In the remaining lessons, you will learn about historical reasons for development of data warehouse technology, learning effects, business architectures, maturity models, project management issues, market trends, and employment opportunities. This informational module will ensure that you have the background for success in later modules that emphasize details and hands-on skills.You should also read about the software requirements in the lesson at the end of module 1. I recommend that you try to install the software this week before assignments begin in week 2.

Employment opportunities video lecture6:10

Rencontrer les enseignants

Michael Mannino
Associate Professor
Business School, University of Colorado Denver

Welcome to lesson seven of module one on data warehouse concepts and architectures.

I'm going to start with an important questions about a career involving data

warehouses and business intelligence.

What position do you want to aspire in your career?

What is your strategy to obtain this position?

Lesson seven concludes the informational background in module one,

with details about career opportunities.

You will learn about position requirements, skill acquisition, and

salary levels.

You have two learning objectives in this lesson.

You should gain awareness about employment and career opportunities.

Most importantly, you should begin reflecting on a strategy for

initial employment evolving into a career involving data warehousing and

business intelligence.

These job titles were taken from an employment publication

created by the Robert Half Technology Division.

Robert Half is a leading firm providing professional staffing services

with more than 400 locations world wide.

The duties and qualifications of these positions have some overlap.

The data warehouse analyst and

business intelligence analyst collaborate with users.

The data warehouse analyst is more involved with data warehouses and

collaborates with business analysts and data warehouse managers.

The business intelligence analyst is more involved with analytics and

communicates with management.

The data analyst position does not specialize in data warehouses and

business intelligence, but has similar duties as a data warehouse analyst.

In smaller organizations,

data analysts may work with both operational databases and data warehouses.

The data warehouse manager designs, implements, and maintains data warehouses.

Data warehouse managers can specialize in processes environment,

that is reporting versus data integration, product, and

task, the design implementation or maintenance.

Senior data warehouse managers often have management responsibilities

to supervise a team of data warehouse administrators.

This matrix relates skills in positions.

The data analyst position is omitted due to overlap with the data warehouse analyst

and business intelligence analyst positions.

Communication skills are major requirements for data warehouse and

business intelligence analysts.

But somewhat less for data warehouse managers.

For data warehouse managers involved with the design and implementation,

communication skill requirements are comparable to analyst positions.

Business intelligence analysts have skill requirements for data mining and

quantitative modeling, that are not usually necessary for

a data warehouse analyst.

Data warehouse analyst have scale requirements for

data integration tools and schema design, that are not typically necessary for

business intelligence analysts.

Data analyst have more skill requirements for SQL however.

Data warehouse managers have high skill requirements for

schema design performance analysis, and SQL extensions.

According to analysts the technology division of Robert Half,

these positions are not entry level.

They typically require three to five years of experience

in information technology areas.

Along with an education in computing such as computer science or

information systems.

Thus, you need to take a long term perspective and

obtain a position in data warehousing or business intelligence.

You need specialized education, such as provided in this specialization.

You also need experience, perhaps initially through an internship.

Certification in specific products can be important to move from an information

technology or business analyst position, into data warehousing or

business intelligence positions.

Job experience as an analyst can propel you into a data warehouse

manager position.

According to salaries reported to the Robert Half salary survey.

USA demand for data warehouse managers, data warehouse analysts and business

intelligence analysts is high, with good compensation growth in recent years.

The first three position titles in this table, not specific to data warehouses,

have also had good growth.

The salary survey reports a substantial premium for Oracle and

Microsoft Sequel Server Skills of about ten percent.

The salary trends in Europe and Australia, reported by Robert Heft,

are not as clear and lack reporting about data warehouse positions.

These trends show wide variance with flat salary growth in the ranges reported.

The global salary survey, conducted by Robert Half, lacks the specificity and

data of the USA survey.

This lesson concludes the informational background in module one.

You learned about positions, skill requirements and acquisition, and

salary trends.

This background should provide strong motivation

as you work through remaining modules in this course, and

other courses in the data warehousing for business intelligence specialization.

In answer to the opening questions, you should carefully evaluate your aspirations

for a career in data warehousing and business intelligence.

You need a plan to acquire education and professional experience.

This specialization provides targeted education

that costs thousands from other sources.

Employers will be impressed with the certificate demonstrating

your completion of this specialization.

You may need to augment this specialization

with initial experience in product training.

To acquire a data warehouse manager position

you may need to work in an analyst position for several years.

However, if you work for a small firm in an information technology position.

You should have opportunity to acquire a variety of experience as a data warehouse

analyst and manager.

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2019 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play