Training

 Seminars: 

Business Intelligence Roadmap Methodology 
3 Days  

Too many project teams try to develop data warehouses (DW) and business intelligence (BI) applications using a traditional methodology or no methodology at all. They quickly find themselves overwhelmed with complexity, unanticipated problems, new tasks, too much rework, and a project that seems to be out of control. This course presents a soup-to-nuts development methodology, specifically designed for DW/BI applications. The methodology provides a step-by-step guide through the engineering stages of justification, planning, analysis, design, construction, and deployment.

The content of the methodology is presented as a framework of 16 development steps. Each development step begins with a list of things to consider, then highlights the major activities, and concludes with deliverables, and roles and responsibilities of project team members who perform the activities. This course will show participants how to select the right activities from the right development steps, how to organize the activities into parallel development tracks, and how to create a customized work breakdown structure that is appropriate for their project.

BI Roadmap seminar outline.


Extreme Scoping™ (Agile DW/BI Approach)
2 Days

There is unanimous agreement among agile authors, experts, and practitioners that agile development works for building small stand-alone operational systems and front-end BI applications. However, there is considerable disagreement among the experts whether agile can work for large, complex systems like an enterprise data warehouse, which requires an enterprise perspective for activities like data standardization, data integration, enterprise data modeling, business rules ratification, coordinated ETL data staging, common metadata, collectively architected databases, and so on. Today’s popular agile methodologies were not designed to address any of these additional DW/BI-specific complexities and interdependencies. The Extreme Scoping™ approach presented in this seminar is specifically designed for enterprise data warehouse projects because it merges agile principles with a robust DW/BI methodology.

Extreme Scoping seminar outline.


Data Governance
1 Day  

After a decade of enterprise resource planning (ERP) and two decades into data warehousing (DW), many business executives are still frustrated over their inability to trust their company’s data. They have spent millions on new technologies, only to find that the state of their data assets has continued to deteriorate instead of improve. New databases are still being created at an alarming rate without reconciling to or reusing data from existing databases. In other words, data is not being shared, and the quality of data cannot be certified. This condition significantly reduces the business value of DW/BI and overall IT investments. To manage your data as a trusted and reusable business asset you need an enterprise-wide data governance program, which is a set of policies, procedures, methods, roles, and responsibilities to standardize data, control data redundancy, and manage master data.

Data Governance seminar outline.  


Data Quality
1 Day  

Everybody agrees that the quality of data should be pristine, both for operational use as well as for decision support. Everybody also agrees that their data is currently far from being pristine or trustworthy, and that something should be done about that. Enterprise-wide disciplines must be developed, taught, and enforced in the organization to improve data quality in a holistic cross-organizational way. These disciplines require some changes in the organization. For example, a stronger personal involvement by management, high-level leadership for data quality, new incentives, new performance evaluation measures, data quality enforcement policies, data quality audits, additional training for data owners and data stewards about their respective responsibilities, data standardization rules, meta data and data inventory management techniques, a common data-driven methodology, etc. This seminar will provide a roadmap from data chaos through data cleansing to continuous data quality improvement practices across the entire organization.     

Data Quality seminar outline.


Pricing and availability:
lmoss@methodfocus.com
methodfocus@earthlink.net