TDWI Courses

Data is a critical resource for every organization. We depend on data every day to keep records, produce reports, deliver information, monitor performance, make decisions, and much more. The data resource is on par with financial and human resources as a core component of doing business, yet data management practices are often quite casual. Data...

Vertica is a high-performance and scalable database management system designed for big data analytics. Vertica SQL refers to the SQL (Structured Query Language) support provided by this platform and is optimized for executing analytical queries on large volumes of data. Thanks to its columnar data storage architecture and data compression features, Vertica offers extremely fast...

Whether you are a business data modeler who represents data requirements as entities and relationships, or a physical data modeler more concerned with tables, columns, and indexes, you know that the hard stuff lies beneath the surface. Every data design, whether logical or technical, is challenged by one or more complex considerations—scalability, adaptability, performance, legacy...

Business intelligence and data warehousing systems challenge the proven data modeling techniques of the past. From requirements to implementation, new roles, uses, and kinds of data demand updated modeling skills. The data modeler’s toolbox must address relational data, dimensional data, unstructured data, and master data. For those with data modeling experience, this course extends their...

A business intelligence and analytics architecture is a set of frameworks to organize the data, management, and technical components used to build BI systems and analytical capabilities. Architecture plays an important role in business intelligence and analytics programs and projects, ensuring that the development efforts of multiple projects and teams fit together to form a...

This introduction to agile for DW/BI teams aligns agile values and principles with BI/DW delivery, reviews both iterative (scrum) and flow-based (kanban) methods, and clarifies roles, responsibilities, and relationships in the agile BI/DW project community. The class also provides guidelines, examples, and practice on how to write and slice effective agile BI/DW requirements into effective...

Data is a critical resource for every organization. We depend on data every day to keep records, produce reports, deliver information, monitor performance, make decisions, and much more. The data resource is on par with financial and human resources as a core component of doing business, yet data management practices are often quite casual. Data...

The advent of big data has changed the world of analytics forever. Big data challenges scalability and big data platforms reshape BI and analytics infrastructure. Hadoop has taken center stage in the big data revolution. We all need to understand the platform, its ecosystem, and how to work with it. The enterprise adoption of Hadoop...

Big Data, Hadoop, NoSQL, analytical database servers, MapReduce, appliances are all immensely popular terms in the IT industry. For most organizations the questions are: How mature are all these new technologies? Are they worthy replacements for the more traditional SQL products? How should they be incorporated into the existing data warehouse architecture? This seminar discusses...

The updated name of this course is Advanced Hadoop – Delivering Business Value The feature set of the Hadoop ecosystem continues to grow and expand capabilities to meet enterprise-class requirements. What are these requirements and what problems have been solved? As an enterprise we need to understand these capabilities beyond the success stories of Internet...