3701 Office Skills courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create Web Intelligence documents for your reporting needsRetrieve data by building queries using SAP BusinessObjects universesUse Web Intelligence to enhance documents for easier analysisOrganize, manage and distribute documents using the BI launch pad This course is designed to give students the comprehensive skills and in-depth knowledge needed to access, analyze and share data using SAP BusinessObjects BI launch pad and SAP BusinessObjects Web Intelligence. Web Intelligence Describing Web Intelligence Concepts Explaining Web Intelligence Core Functions Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform Web Intelligence Documents with Queries Creating Queries Creating a Document Modifying a Document?s Query Modify the Query Panel Data Return Restrictions from Queries Restricting Data with Query Filters Modifying a Query with a Predefined Query Filter Applying a Single-Value Query Filter Using Wildcards in Query Filters Using Prompts to Restrict Data Using Complex Filters Web Intelligence Document Design Modifying Web Intelligence Documents Displaying Data in Tables Using Tables Presenting Data in Free-standing Cells Presenting Data in Charts Presentation of Data in Documents Using Breaks and Calculations Using Sorts and Hiding Data Formatting Breaks and Cross Tables Filtering Report Data Ranking Data Highlighting Information with Formatting Rules Organizing a Report into Sections Web Intelligence Document Formatting Formatting Documents Formatting Charts Data Calculation Applying Formulas and Variables Using Formulas and Variables Drilling Functionality Analyzing the Data Cube Drilling in an Web Intelligence Document Web Intelligence Documentation Management Publishing Documents to the Corporate Repository Logging In to the BI Launch Pad Managing Documents in BI Launch Pad Viewing a Web Intelligence Document in the BI Launch Pad Sharing Web Intelligence Documents Setting BI Launch Pad Preferences Logging Off From the BI Launch Pad

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Solution Architects, and System Architects. Overview Describe the SAP BusinessObjects Business Intelligence tools.Learn about the use cases and get an overview of basic functions of the most important BusinessObjects reporting tools. In this course, students describe the SAP BusinessObjects Business Intelligence tools and learn about the use cases by getting an overview of basic functions of the most important BusinessObjects reporting tools. Overview of SAP BusinessObjects Business Intelligence (BI) 4.1 Describing SAP Analytics Solutions Identifying the Components of SAP BusinessObjects 4.1 Semantic Layer in SAP BusinessObjects BI 4.1 Describing Semantic Layer Technology Creating a Universe in the Information Design Tool SAP Crystal Reports Creating a Report in SAP Crystal Reports for Enterprise Creating a Report in SAP Crystal Reports 2013 Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence Creating Web Intelligence Documents in SAP BusinessObjects Web Intelligence SAP BusinessObjects Analysis, Edition for Microsoft Office Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office SAP BusinessObjects Analysis, Edition for OLAP Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP SAP BusinessObjects Design Studio 1.2 Creating an Analytical Application in SAP BusinessObjects Design Studio 1.2 SAP BusinessObjects Dashboards Creating a Dashboard with SAP BusinessObjects Dashboards SAP BusinessObjects Explorer Creating an SAP BusinessObjects Explorer Information Space SAP Lumira and SAP Predictive Analysis Visualizing Data in SAP Lumira Forecasting in SAP Predictive Analysis Additional course details: Nexus Humans SAPBI Introduction to SAP BusinessObjects BI Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SAPBI Introduction to SAP BusinessObjects BI Solutions course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This introductory-level course is great for experienced technical professionals working in a wide range of industries, such as software development, data science, marketing and advertising, finance, healthcare, and more, who are looking to use the latest AI and machine learning techniques in their day to day. The hands-on labs in this course use Python, so you should have some familiarity with Python scripting basics. Overview Working in an interactive learning environment, led by our engaging OpenAI expert you'll: Understand the capabilities and products offered by OpenAI and how to access them through the OpenAI API. set up an OpenAI environment on Azure, including creating an Azure virtual machine and configuring the environment to connect to Azure resources. Gain hands-on experience building a GPT-3 based chatbot on Azure and implement advanced natural language processing capabilities. Use the OpenAI API to access GPT-3 and generate high-quality text Learn how to use Whisper to improve the quality of text generation. Understand the capabilities of DALL-E and use it to generate images for unique and engaging visuals. Geared for technical professionals, Quick Start to Azure AI Basics for Technical Users is a fun, fast paced course designed to quickly get you up to speed with OpenAI?s powerful tools and functionality, and to provide hands-on experience in setting up an OpenAI environment on Azure. Guided by our AI expert, you?ll explore the capabilities of OpenAI's GPT-3, Whisper and DALL-E, and build a chatbot on Azure. It will provide you with the knowledge and resources to continue your journey in AI and machine learning and have a good understanding of the potential of OpenAI and Azure for your projects. First, you?ll dive into the world of OpenAI, learning about its products and the capabilities they offer. You'll also discover how Azure's offerings for AI and machine learning can complement OpenAI's tools and resources, providing you with a powerful combination for your projects. And don't worry if you're new to Azure, we'll walk you through the process of setting up an account and creating a resource group. As you progress through the course, you'll get the chance to work with OpenAI's GPT-3, one of the most advanced large language models available today. You'll learn how to use the OpenAI API to access GPT-3 and discover how to use it to generate high-quality text quickly and easily. And that's not all, you'll also learn how to build a GPT-3 based chatbot on Azure, giving you the opportunity to implement advanced natural language processing capabilities in your chatbot projects. The course will also cover OpenAI Whisper, an OpenAI tool that can improve the quality of text generation, allowing you to create more coherent and natural language content. And you will learn about OpenAI DALL-E, an OpenAI tool that can generate images, giving you the ability to create unique and engaging visuals to enhance your content and projects. Introduction to OpenAI and Azure Explore OpenAI and its products, as well as Azure's offerings for AI and Machine Learning, allowing you to understand the tools and resources available to you for your AI projects. Explore OpenAI and its products Explore Azure and its offerings for AI and Machine Learning Get Hands-On: Setting up an OpenAI environment on Azure Walk through the process of setting up an OpenAI environment on Azure, giving you the hands-on experience needed to start building your own projects using OpenAI and Azure. Create an Azure virtual machine and installing the OpenAI SDK Configure the OpenAI environment and connecting to Azure resources Explore OpenAI GPT-3 Learn about GPT-3, one of OpenAI's most powerful language models, and how to use it to generate high quality text, giving you the ability to create natural language content quickly and easily. Review GPT-3 and its capabilities Use the OpenAI API to access GPT-3 Get Hands-on: Building a GPT-3 based chatbot on Azure Learn how to build a GPT-3 based chatbot on Azure, giving you the opportunity to learn how to implement advanced natural language processing capabilities in your chatbot projects. Setup an Azure Function and creating a chatbot Integrate GPT-3 with the chatbot OpenAI Whisper Explore Whisper, an OpenAI tool that can improve the quality of text generation, allowing you to create more coherent and natural language content. Explore Whisper and its capabilities Use Whisper to improve the quality of text generation OpenAI DALL-E Explore DALL-E, an OpenAI tool that can generate images, giving you the ability to create unique and engaging visuals to enhance your content and projects. Explore DALL-E and its capabilities Use the OpenAI API to access DALL-E What?s Next: Keep Going! Other ways OpenAI can impact your day to day Explore great places to check for expanded tools and add-ons for Azure OpenAI Where to go for help and support Quick Look at Generative AI and its Business Implications Understanding Generative AI Generative AI in Business Ethical considerations of Generative AI

Duration 3 Days 18 CPD hours This course is intended for This advanced course is for Infrastructure Specialist, Senior Technical Specialist,Technical Specialist, Support Engineers, and System Architects. Overview Understand the MDM Architecture and how the Physical, Virtual and Hybrid MDM handles a service request Understand the core Workbench features available for the InfoSphere MDM Understand how MDM using OSGi for deploying customizations to the product Create a new Physical MDM Entity using the Workbench Wizard Extend an existing Physical MDM Entity using the Workbench Wizard Extend an existing Physical MDM Service using the Workbench Wizard Create a new Composite Service using a transiant object containing other existing business objects Customize and deploy a Virtual configuration Create a new Virtual Callout Handler Create a new Virtual Composite View Generate new Services based on the Virtual configuration (eSOA) Customize a Hybrid MDM implementation Understand the Adaptive Service Interface (ASI) This course is designed for anyone who wants to get an understanding of how to use and customize the InfoSphere Master Data Management using the InfoSphere MDM Workbench InfoSphere MDM Architecture . OSGi and MDM . Data Additions . Physical Data Extensions . MDM Physical Behavior Extensions . Composite Services . Adaptive Services Interface (ASI) . Virtual Data Model . Virtual Handlers . eSOA Toolkit . Hybrid MDM .

Duration 3 Days 18 CPD hours This course is intended for Authors Overview Please refer to course overview This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity. What is IBM Cognos Analytics - Reporting The Welcome page Consume report content Interactive filtering Working with reports Dimensionally modeled relational dataUse personal data sources and data modules Upload personal data Upload custom images Using navigation paths in a data module Examine list reports Group data Format columns Include headers and footers Aggregate fact data Identify differences in aggregation Multiple facts and repeated information Use shared dimensions to create multi-fact queries Present repeated information Add repeated information to reports Create a mailing list report Create crosstab reports Add measures to a crosstab Data sources for a crosstab Create complex crosstab reports Add items as peers Create crosstab nodes and crosstab members Work with crosstab data Format, sort, and aggregate a crosstab Create discontinuous crosstab reportsCreate visualization reports Visualization categories Customize visualizations Client side visualizations Enhanced map visualizations Focus reports using filters Create filters to narrow the focus Use advanced detail filters Apply a filter with aggregation Use summary filters Focus reports using prompts Examine parameters and prompts Create a parameter for a report item Add a prompt page Add a prompt item to a report Identify a prompt type Create a cascading prompt Use calculations What are calculations Add Date and Time functions Add string functions Display prompt selections in report titles Customize reports with conditional formatting Three steps for conditional formatting Create a variable Assign the variable to a report object Format based on the conditional value Conditionally render report objects Drill-through definitions Navigate to related data Enhance report layout View the structure of a report Use Guided report layout Force page breaks Create horizontal pagination Modify the report structure Format objects across reports Use additional report-building techniques Enhance a report design Add objects to reports Convert a list to a crosstab Explore reuse Additional course details: Nexus Humans B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for Report Authors Overview Create query models Create reports based on query relationships Introduction to dimensional data Introduction to dimensional data in reports Dimensional report context Focus your dimensional data Calculations and dimensional functions Create advanced dynamic reports This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Data deck Use Master detail relationships with Decks Optimize Active Reports Create an Active Report with new visualizations

Duration 2 Days 12 CPD hours This course is intended for Report authors working with dimensional data sources. Through interactive demonstrations & exercises, participants will learn how to author reports that navigate & manipulate dimensional data structures using the specific dimensional functions & features available in IBM Cognos Analytics. Introduction to Dimensional Concepts Identify different data sources and models Investigate the OLAP dimensional structure Identify dimensional data items and expressions Differentiate the IBM Cognos Analytics query language from SQL and MDX Differentiate relational and dimensional report authoring styles Introduction to Dimensional Data in Reports Work with members Identify sets and tuples in IBM Cognos Analytics Dimensional Report Context Understand the purpose of report context Understand how data is affected by default and root members Focus Your Dimensional Data Compare dimensional queries to relational queries Explain the importance of filtering dimensional queries Evaluate different filtering techniques Filter based on dimensions and members Filter based on measure values Filter using a slicer Calculations & Dimensional Functions Use IBM Cognos Analytics dimensional functions to create sets and tuples Perform arithmetic operations in OLAP queries Identify coercion errors and rules Functions for Navigating Dimesional Hierarchies Navigate dimensional data using family functions Relative Functions Navigate dimensional data using relative functions Navigate dimensional data using relative time functions Advanced Drilling Techniques & Member Sets Understand default drill-up and drill-down functionality Identify cases when you need to override default drilling behavior Configure advanced drilling behavior to support sophisticated use cases Define member sets to support advanced drilling Define member sets to support functions Set Up Drill-Through Reports Navigate from a specific report to a target report Drill down to greater detail and then navigate to target report Navigate between reports created using different data sources End-to-End Workshop Review concepts covered throughout the course

Duration 2 Days 12 CPD hours This course is intended for Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

Duration 1 Days 6 CPD hours This course is intended for This course is designed for data scientists with experience of Python who need to learn how to apply their data science and machine learning skills on Azure Databricks. Overview After completing this course, you will be able to: Provision an Azure Databricks workspace and cluster Use Azure Databricks to train a machine learning model Use MLflow to track experiments and manage machine learning models Integrate Azure Databricks with Azure Machine Learning Azure Databricks is a cloud-scale platform for data analytics and machine learning. In this course, students will learn how to use Azure Databricks to explore, prepare, and model data; and integrate Databricks machine learning processes with Azure Machine Learning. Introduction to Azure Databricks Getting Started with Azure Databricks Working with Data in Azure Databricks Training and Evaluating Machine Learning Models Preparing Data for Machine Learning Training a Machine Learning Model Managing Experiments and Models Using MLflow to Track Experiments Managing Models Managing Experiments and Models Using MLflow to Track Experiments Managing Models Integrating Azure Databricks and Azure Machine Learning Tracking Experiments with Azure Machine Learning Deploying Models