Business Intelligence And Data Warehousing Education: Your Location .

TDW I ON s i t e c o u r s e sprescribed business rules, it is difficult toknow where to start and how to proceed.The skill set for the BI requirements analystincludes techniques to identify requirements,tools to manage requirements, andchecklists to ensure completeness.TDWI Project Management forBusiness Intelligencecompliance, risk, and measurement—are allunderstood and represented in the resultingset of requirements.Business Intelligence Roadmap:The Complete Project Lifecycle forDecision-Support ApplicationsTwo-day courseOne-day courseDue to the varying types, technologies, andunique challenges of BI projects, thereis no “one size fits all” approach to BIproject management. Learn how to chooseamong traditional, agile, and other projectmanagement methods. Then find out how toapply the chosen method for project planning,execution, monitoring, control, completion,and closure.This popular methodology courseprovides a step-by-step guide throughthe engineering stages of justification,planning, analysis, design, construction,and deployment specifically designed forbusiness intelligence and data warehousingapplications.The BI Pathway Approach:Delivering BI for Business ValueTwo-day courseBusiness Requirements Workshop:BI Requirements Gathering TechniquesOne-day workshopDefining business requirements is challengingfor any system, but it is especially difficultfor BI systems. Most of the challenges resultfrom human and cognitive issues, more thanfrom technology. The real potential of BI oftengoes unrealized when requirements thinkingis limited to analysis and reporting. Thisworkshop offers an opportunity to exploreand practice several techniques to overcomethe barriers and identify real and meaningfulBI requirements.Requirements Analysis forInstitutional IntelligenceOne-day course or two-day workshopInstitutional Intelligence (I2) applies thetechniques and technologies of businessintelligence to the missions, goals, andstrategies of educational institutions. Thiscourse teaches processes and techniquesfor requirements gathering and requirementsmanagement that specifically targetthe complexities inherent in I2. A multidimensional framework for requirementsmanagement ensures that the manyperspectives of institutional intelligencerequirements—motivation, capabilities,performance, governance, management,Building on the core concepts and highlysuccessful fundamentals that have beencentral to data warehousing over theyears, this course reveals the time-testedBI Pathway, a methodology that will helporganizations ensure the true businessrequirements for BI/DW are completelyunderstood and the BI/DW environmentprovides actionable information that makesa difference to the business.updated Putting the Business Back inBI: A Framework for Requirements andValue ManagementOne-day course or two-day workshopBI means “business intelligence,” yet itsometimes seems that technology interestssupersede those of business. When a BIprogram gives more attention to dashboards,scorecards, OLAP, and data warehousesthan to finance, R&D, marketing, operations,and so on, it is time to put the business backinto BI. Take this course to learn a businessoriented approach to gathering the rightrequirements, measuring the right things,and delivering information that really makesa difference.Visit www.tdwi.org/onsite for full course descriptions.7

TDW I ON s i t e c o u r s e sLeadership andManagementTDWI Business IntelligenceExecutive BriefingThree-hour briefingThis survey of the BI landscape provides abusiness-oriented, nontechnical explanationof all facets of BI, from data integration tobusiness application. Critical processesand disciplines for effective businessintelligence are described, includingprogram management, governance, changemanagement, and information quality. Keytopics include differences between datawarehousing and BI, understanding the BIbusiness case, and BI best practices.TDWI Business IntelligenceProgram ManagementOne-day course or two-day workshopProgram management encompassesthe disciplines and activities necessaryto coordinate multiple, overlapping, andinterdependent projects. This course teachestechniques and provides tools to addresssix crucial areas of BI program management:portfolios, processes, quality, change,service, and value.Best Practices for EstablishedBI Programs—or New Life for OlderData WarehousesOne-day courseMore and more frequently, we find ourselvesin situations where an existing BI programneeds problem solving, new energy, or newdirections. There are guidelines, resources,and best practices that apply to matureBI environments, but the connections arenot always obvious. Gain new insights andrevitalize an established BI program bylooking at proven best practices from afresh perspective.8Data Governance for BI ProfessionalsOne-day courseThis course discusses the tactics necessaryto launch and sustain an effective datagovernance effort. It covers the 10 mostcommon mistakes companies make whenlaunching data governance, and offers casestudies of what companies have done rightin ensuring data governance adoption. Theworkshop pays particular attention to how BIand data warehousing skills can be leveragedwhen beginning a new data governanceeffort, and includes a short self-assessmentexercise for participants to gauge their ownreadiness for data governance.Business Requirements for BI ImpactOne-day courseCapturing, organizing, and communicatingthe key business requirements for your BIprogram requires an approach that alignsyour company’s business strategy andobjectives with the technical infrastructure todeliver the right management information tothe right people at the right time. This courseteaches techniques to uncover requirementsthat can drive business results and answeranalytical needs, including a frameworkfor capturing these requirements that isvaluable for both business sponsors anddata modelers.NEW Agile Data Warehousing: BasicTraining for TeamsTwo-day courseThis training thoroughly introduces thefundamentals of both Scrum and itsadaptation for data warehousing. It includestopics such as just-in-time requirementswith user stories, avoiding overcommitmentwith agile estimation techniques, pipelineddelivery teams, and techniques for keepingdeliveries on schedule. Appropriateespecially for developers, team leads, andproject managers; also of interest to productowners and shared resources such asanalysts, DBAs, and testers.Contact Yvonne Baho at 978.582.7105 or ybaho@tdwi.org for more information.

TDW I ON s i t e c o u r s e sNEW Agile Data Warehousing: BestPractices for Maximum Delivery SpeedBringing Business and IT Together: PracticalSteps to Improved Working RelationshipsTwo-day courseOne-day courseBuilding on the Basic Training for Teams,this course focuses on more than 12 agiledata warehousing “best practices” thatallow teams to reach their maximum velocity.Practices examined include semi-formalrequirements management, iterative datamodeling, refactoring data bases, and “softprod” prototypes. Appropriate especially forlead developers, architects, scrum masters,and shared resources such as DBAs. Also ofinterest to developers and testers.Business/IT working relationships have beentroubled since the dawn of the informationage. As the interdependencies of businessand technology grow, the cost of failedrelationships also increases. This courseoffers a systematic approach to address realproblems and improve business/IT workingrelationships through continuous attention toorganizational alignment.NEW Agile Data Warehousing:One-day course or two-day workshopTest-Led Development and AutomatedIntegration TestingHas your organization learned how to focuson results, create a productive environment,and partner with your business customers?This entertaining class will provide practicaltips and techniques for leading teamsthrough cultural and people challenges torealize an initiative’s full potential.Two-day workshopThis workshop provides both theoreticalinstruction on warehouse testing and a forumfor teams to define and plan a significantportion of their own test-led developmentprogram. We will examine how a single testingresource can be leveraged for all levels oftesting—unit, system, and user acceptance—placing particular emphasis on the goldstandard for agile quality management:automated and continuous integration testing.Appropriate especially for lead developers,testers, data modelers, architects. Also ofinterest to developers, scrum masters, andshared resources such as DBAs.Agile Project Management forData Warehouse ProjectsTwo-day courseTraditional project management techniquesjust won’t cut it when the pressure is on todeliver a BI solution in a tight time frame.Agile project management enables aneffective development environment withoutsacrificing quality or causing a lot of rework.This course describes self-organizingproject teams, spiral methodologies, and“extreme scoping.”Leading and Organizing BusinessIntelligence Teams: Improving Individualand Team PerformanceBuilding a BI TeamOne-day courseBI is a team job. The alignment,communication, and collaboration essentialto BI simply can’t be achieved withouthighly skilled, cross-functional, andinterdisciplinary teams. High-impact teamsfoster a culture of trust-based relationships,declared commitment, designatedresponsibility, and shared success. Thisapproach to team building starts by creatingthe right BI culture, then builds on thatculture with the essential skills, knowledge,and talents for team success.High-ImpactAdvance project goals by givingyour team a common understandingof core concepts.Visit www.tdwi.org/onsite for full course descriptions.9

TDW I ON s i t e c o u r s e sBusiness AnalyticsTDWI Introduction to Business AnalyticsOne-day courseBusiness analytics is a complex field thatinvolves many disciplines, ranging fromstatistics to data visualization. This courseprovides an overview of those disciplines anddescribes the role of each in the context ofbusiness analytics and BI systems.ChallengeTDWI Enterprise Metrics: DesigningIntegrated Business MetricsLots of data, but where is the information? You have integrated datainto the warehouse, published manyreports, and supported a high volumeof query activity. You have scratchedthe surface of analysis with OLAP.But the business is demanding moreanalytic capabilities. The demand fordashboards and scorecards raisesmany questions: What to measure?Which metrics are critical? How toachieve continuity among metrics?When should you use a dashboardor scorecard approach? Where dopredictive analytics fit in?One-day courseSolutionConsciously extend your BI architecture and development processes toencompass measurement, metrics,and business analytics.Recommended TDWI Onsite courses tohelp meet this challenge: TDWI Introduction to BusinessAnalytics (page 10) TDWI Enterprise Metrics: DesigningIntegrated Business Metrics (page 10)Measurement-based disciplines are centralto business management. How do we getcorrect, consistent, and cohesive metricsin a continually changing environment andaudience? This course teaches techniquesthat address the complex and challengingquestions of business metrics design.Enterprise Business Metrics in PracticeOne-day interactive course or two-day workshopThis highly interactive course walksparticipants through an approach foridentifying an integrated set of businessperformance metrics, implementingmeasurement/analysis processes andmechanisms (e.g., dashboards/reports), andtaking action based on the insight that isgenerated. It is designed to provide businessand IT teams with a process and bestpractices for working together to define anduse business metrics to significantly improvebusiness performance.NEW Business Analytics for Insightand ForesightOne-day courseToday’s business climate demandsextraordinary analytics. Business managersneed to know more than what; they need toknow why, what if, and what next. Learn whatis at the heart of business analytics andhow to apply the systems view to measurethe right things and find the right answers tocritical business questions. Predictive Analytics: An IntensiveOverview of Strategy, Application, andBest Practices for Data Mining (page 11)10Contact Yvonne Baho at 978.582.7105 or ybaho@tdwi.org for more information.

TDW I ON s i t e c o u r s e sStrategic Feedback: Strategy MappingMeets Systems ThinkingOne-day courseBalanced scorecards and strategy mapsprovide a strong business associationbetween what we measure and whatwe do. The work of Kaplan and Nortonhas certainly advanced the discipline ofbusiness management. Yet scorecards andstrategy maps have their limits. Scorecardscategorize and strategy maps offer alinear view of cause and effect, but neitherprovides the feedback mechanism needed toevolve strategy over time. Extending strategymaps with causal loop principles offers newopportunities for insight and innovation.Predictive Analytics: An Intensive Overviewof Strategy, Application, and Best Practicesfor Data MiningTwo-day courseData Mining Application WorkshopOne-day courseThis course offers a structured approach toteam-oriented data mining exercises in a labenvironment. Participants will experience abalanced, broad, vendor-neutral perspectiveon data mining.NEW Measuring Intangibles: BreakingDown Analytic BarriersOne-day courseThe right things to measure are those thatdrive goal attainment. This means changingthe measurement focus from outcomes(using lagging indicators) to influences(using leading indicators). Influence employsmeasurement of “intangibles,” which arecentral to managing future performance.Learn why and how to apply intangiblemeasures for business leverage and to attainyour goals.This course offers an introduction to datamining terminology, methods, resources, andbusiness issues. Participants will learn aboutvarious methods of predictive analytics,competitive advantages, and common pitfallsthat often cause data mining projects to fallshort of their potential. Leading productsare used to illustrate and compare methods.Results are drawn from actual data miningapplications and interpreted in the context ofbusiness impact.Data Mining Techniques, Tools, and TacticsTwo-day courseThis course delivers a comprehensiveoverview of data mining concepts, tools,techniques, and supporting methods. Itoffers participants a stronger grasp of datamining techniques and a solid understandingof how various methods and tools apply todifferent kinds of data-intensive problems.ConvenientSchedule training when it bestaccommodates your workload.Visit www.tdwi.org/onsite for full course descriptions.11

TDW I ON s i t e c o u r s e sData Analysisand Designupdated TDWI Data Modeling: DataAnalysis and Design for BI and DataWarehousing SystemsTwo-day course or four-day workshopChallengeLots of analytics but too littleanalysis. You have the dashboards,the scorecards, and the OLAP cubes.Yet, real understanding of businessbehaviors remains elusive. You needto find a way to make the leap fromanalytics to insight—knowing whathas happened, why it happened, andwhat it means for the future.SolutionA cause-and-effect approach tomeasuring the right things, findingreal insight, and managing to makea difference.Recommended TDWI Onsite courses tohelp meet this challenge: Business Analytics for Insightand Foresight (page 10) Measuring Intangibles: Breaking DownAnalytic Barriers (page 11) Strategic Feedback: Strategy MappingMeets Systems Thinking (page 11)12Business intelligence demands that the“toolbox” for data modelers be expandedbeyond basic entity-relationship modeling. Itnow includes techniques to manage timevariant data, distinguish between eventdata and reference data, manage dataredundancy, and more. From BI requirementsgathering to physical data design, this courseprovides a solid data modeling backgroundfor people of various data modeling andanalysis skill levels.TDWI Advanced Data Modeling TechniquesTwo-day courseEvery data design, whether logical ortechnical, is challenged by one or morecomplex considerations—scalability,adaptability, performance, legacy andpackage databases, etc. Every data modelraises questions. Advanced modelingtechniques provide many of the answers.updated TDWI Dimensional DataModeling Primer: From Requirements toBusiness AnalyticsOne-day courseDimensional data is a core component ofmodern business intelligence and datawarehousing implementations. Dimensionallyorganized data offers a more effective andadaptable solution to business analyticsneeds than can be achieved with relationaldata structures. Virtually anyone involved inbusiness intelligence and data warehousingprojects needs to have fundamentalknowledge of the pathway from businessquestions to business analytics. This coursetraces that pathway.Contact Yvonne Baho at 978.582.7105 or ybaho@tdwi.org for more information.

TDW I ON s i t e c o u r s e sAdvanced Dimensional Modeling Techniquesfor PractitionersIntermediate and Advanced Techniques forEffective Data ModelingTwo-day courseTwo-day courseThis course takes participants beyond thebasics to learn proven techniques thataddress many of the complexities encounteredin practice. From multiple fact tables todimensional complexity, participants willlearn proven techniques used by the expertsto match data designs to business realities,implement highly complex data models, andwork with very large data volumes.This course presents both intermediateand advanced techniques that will leadto greater success with data modelingdeliverables. Techniques are explained withthe help of numerous examples. Many ofthese techniques have been developedand fine-tuned through years of practiceand experience.Dimensional Modeling from aBusiness Perspective: A Model theBusiness Can UnderstandTwo-day, case study–based workshopOne-day courseOrganizations often struggle to developdimensional models that consistently meetbusiness needs. Using time-proven businessdimensional modeling techniques, thebusiness and systems communities caneffectively partner to create a data modelthat will support the business today and inthe future. This course is designed to teachthe fundamentals of business dimensionalmodeling, which in turn improvescommunications and understanding ofrequirements and enhances the businesscommunity’s participation throughouta project.Enterprise Data Modeling forBusiness IntelligenceOne-day courseThe enterprise data model (EDM) is back!EDM struggled in the late 1980s and early1990s, but today EDM is getting high scores,with much of the value being generated frombusiness intelligence programs. Learn theingredients for EDM success within dataquality, master data management, anddata warehouse initiatives. Explore thecharacteristics and variations of an EDM andwhat it takes to build and sustain an EDM.Data Modeling in PracticeIn this team workshop with minimal lecture,participants will use modeling skillsto complete a series of data modelingdeliverables, including data mart logical andphysical data models. Experience and trainingwill be put to the test in exercises that resolveanalysis, design, and integration issues.The Data Model ScorecardOne-day courseThere is no standard way to measure

business intelligence and data warehousing applications. The BI pathway approach: Delivering BI for Business Value two-day course Building on the core concepts and highly successful fundamentals that have been central to data warehousing over the years, this course reveals the time-tested