Cursos de Datos y Business Intelligence

This course introduces the skills and knowledge required to administer a Db2 13 for z/OS system. Utilizing the lecture and a z/OS lab environment, learners will gain practical practice starting, stopping, and accessing Db2; examining the zParms and data sets; connecting to a Db2 subsystem via Data Studio; querying the catalog; exploring RACF; examining threads; working with DB2I; modifying Db2 active and archived logs; utilizing online utilities; monitoring and controlling Db2; recovering the catalog and directory; and using the administrative task scheduler.

This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements.Students will participate in hands-on exercises to practice what they have learned.

This course provides you with information about the functions of IBM's Db2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.   Db2 runs under a number of operating systems, such as z/OS, VM, Linux, UNIX, and Windows operating systems. The course includes discussion of how the Db2 products provide services. The focus is on the services Db2 provides and how users work with Db2, not on its internal workings. This course does not include hands-on labs.

This course provides participants with a high-level overview of the IBM Cognos Analytics Dashboard tool and its underlying architecture. They will explore the powerful features of IBM Cognos Analytics dashboards to transform raw data into actionable insights. Through interactive lessons, practical exercises, and real-world scenarios, learners will gain the skills to create, customize, and share dynamic dashboards that drive data-informed decisions.Learners will gain hands-on experience through exercises that enhance their ability to create and customize dashboards, stories, and explorations.By the end of this course, learners should be proficient in creating and customizing dashboards, using Cognos Analytics tools and AI Assistant, integrating and visualize data from multiple sources, employing advanced features like 3D maps, forecasting, and drill-through definitions to enhance insights, and much more.

This course teaches Professional Report Authors about advanced report building techniques using relational data models, and ways of enhancing, customizing, and managing professional reports. The course builds on topics presented in the Fundamentals course. Attendees will participate in interactive demonstrations and exercises that illustrate key concepts while learning how to use advanced features in the product builds on topics learned in the Fundamentals course.

Students will explore IBM Cognos Analytics report authoring and different report object types (list, crosstab, chart, visualization, etc.). They will also create and format reports using grouping, headers, footers, and other formatting options. Also covered is the ability to focus reports by filtering data and using prompts. Students will learn to add value to reports using calculations and additional report-building techniques as well as how to enhance reports with advanced formatting and exceptional data highlighting.

This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.

This course provides a high-level overview of the IBM Cognos Analytics Data Module tool and its underlying architecture to provide learners with the skills necessary to master data modeling using the web-based, self-service capabilities of IBM Cognos Analytics Data Modules. Learners will explore the essential steps in building data modules, from understanding the purpose and workflow of data modeling to creating, refining, and optimizing data structures. The course covers various topics, including relationship joins, data enrichment with calculations and filters, creating navigation paths, and managing data security. Learners will gain hands-on experience through exercises that enhance their ability to create and customize data modules, ensuring consistency and usability for reporting, dashboarding, and exploration purposes. By the end of this course, learners should be proficient in developing data modules that integrate multiple data sources, support business analysis, and facilitate informed decision-making within the IBM Cognos environment.

This course provides participants with a high-level overview of the IBM Cognos Analytics suite of products and their underlying architecture. They will examine each component as it relates to an Analytics solution. Participants will be shown a range of resources to provide additional information on each product.  

This course explores Manta user interface fundamentals and principal features that are most relevant to End Users. Explore Manta repository and flow viewer, discover how to fine-tune your visualization, and learn how to interpret, manipulate, and compare different revisions of your lineage diagram.

This course teaches Information Server and/or DataStage administrators to configure, manage, and monitor the DataStage Engine which plays a crucial role in Information Server.  It not only runs high-performance parallel ETL jobs designed and built-in DataStage.  It also supports other Information Server products including Information Analyzer, QualityStage, and Data Click.  After introducing DataStage parallel jobs and the Engine that runs them, the course describes DataStage project configuration, the Engine’s development and runtime environments, and the Engine’s data source connectivity.  In addition, the course explains how to import and export DataStage objects, how to run and monitor DataStage jobs through the command line and GUI, and how to use some important Engine utilities.

This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. This course covers common data quality issues, QualityStage architecture, QualityStage clients and their functions, importing metadata, running jobs and reviewing results, building Investigate jobs, the Standardize stage and rule sets, identifying matching records and applying multiple Match passes, building a Survive job, and using a Two-Source match.Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.

This course provides Administrators with guidance on installing and administering the IBM Planning Analytics - Local environment. The course outlines how the architecture can be customized to fit into various infrastructures. Students will learn how to install and configure IBM Planning Analytics - Local, monitor system performance, and secure applications.Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities.If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. http://www.ibm.com/training/terms 

This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

This course introduces the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.

This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

 This course guides students through the fundamentals of using IBM SPSS Statistics for typical data analysis. Students will learn the basics of reading data, data definition, data modification, data analysis, and presentation of analytical results. In addition to the fundamentals, students will learn shortcuts that will help them save time. This course uses the IBM SPSS Statistics Base; one section presents an add-on module, IBM SPSS Custom Tables.

Contains: PDF course guide, as well as a lab environment where students can work through demonstrations and exercises at their own pace. This course provides an application-oriented introduction to the statistical component of IBM SPSS Statistics. Students will review several statistical techniques and discuss situations in which they would use each technique, how to set up the analysis, and how to interpret the results. This includes a broad range of techniques for exploring and summarizing data, as well as investigating and testing relationships. Students will gain an understanding of when and why to use these various techniques and how to apply them with confidence, interpret their output, and graphically display the results.

This course guides students through the fundamentals of using IBM SPSS Statistics for typical data analysis. Students will learn the basics of reading data, data definition, data modification, data analysis, and presentation of analytical results. In addition to the fundamentals, students will learn shortcuts that will help them save time. This course uses the IBM SPSS Statistics Base; one section presents an add-on module, IBM SPSS Custom Tables.