• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

37 Oracle Business Intelligence courses delivered Live Online

🔥 Limited Time Offer 🔥

Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. INTRODUCTION TO IBM COGNOS DYNAMIC CUBES * Define and differentiate Dynamic Cubes * Dynamic Cubes characteristics * Examine Dynamic Cube requirements * Examine Dynamic Cube components * Examine high level architecture * IBM Cognos Dynamic Query * Review Dimensional Data Structures * Dynamic Cubes caching * CREATE & DESIGN A DYNAMIC CUBE * Explore the IBM Cognos Cube Designer * Review the cube development process * Examine the Automatic Cube Generation * Manual development overview * Create dimensions * Model the cube * Best practice for effective modeling DEPLOY & CONFIGURE A DYNAMIC CUBE * Deploy a cube * Explore the Estimate Hardware Requirements * Identify cube management tasks * Examine Query Service administration * Explore Dynamic Cube properties * Schedule cube actions * Use the DCAdmin comment line tool ADVANCED DYNAMIC CUBE MODELLING * Examine advanced modeling concepts * Explore modeling caveats * Calculated measures and members * Model Relative Time * Explore the Current Period property * Define period aggregation rules for measures ADVANCED FEATURES OF CUBE DESIGNER * Examine multilingual support * Examine ragged hierarchies and padding members * Define Parent-Child Dimensions * Refresh Metadata * Import Framework Manager packages * Filter measures and dimensions OPTIMIZE PERFORMANCE WITH AGGREGATES * Identify aggregates and aggregate tables * In-memory aggregates * Use Aggregate Advisor to identify aggregates * User defined in-memory aggregates * Optimize In-Memory Aggregates automatically * Aggregate Advisor recommendations * Monitor Dynamic Cube performance * Model aggregates (automatically vs manually) * Use Slicers to define aggregation partitions DEFINE SECURITY * Overview of Dynamic Cube security * Identify security filters * The Security process - Three steps * Examine security scope * Identify scope rules * Identify roles * Capabilities and access permissions * Cube security deep dive MODEL A VIRTUAL CUBE * Explore virtual cubes * Create the virtual cube * Explore virtual cube objects * Examine virtual measures and calculated members * Currency conversion using virtual cubes * Security on virtual cubes INTRODUCTION TO IBM COGNOS ANALYTICS * Define IBM Cognos Analytics * Redefined Business Intelligence * Self-service * Navigate to content in IBM Cognos Analytics * Interact with the user interface * Model data with IBM Cognos Analytics * IBM Cognos Analytics components * Create reports * Perform self-service with analysis and Dashboards * IBM Cognos Analytics architecture (high level) * IBM Cognos Analytics security * Package / data source relationship * Create Data modules * Upload files ADDITIONAL COURSE DETAILS: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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.

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)
Delivered on-request, onlineDelivered Online
Price on Enquiry

BOE320 SAP BI Platform - Admin Servers (Win)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are System Administrators and System Architects. Overview Explain the architecture in SAP BusinessObjects Business Intelligence platformConfigure SAP BusinessObjects Business Intelligence platformPerform common server management and administrative tasks in SAP BusinessObjects Business Intelligence platform In this course, students learn how to explain the architecture in the SAP BusinessObjects Business Intelligence platform and perform common server management and administrative tasks in the SAP BusinessObjects Business Intelligence platform. SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM * Describing the SAP BusinessObjects Business Intelligence Platform * Describing the SAP BusinessObjects Business Intelligence Platform Architecture INSTALLATION OF SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM * Installing SAP BusinessObjects Business Intelligence Platform: Server-Side Installation * Installing SAP BusinessObjects Business Intelligence Platform: Client-Side Installation SERVER ADMINISTRATION AND MANAGEMENT * Using the Central Management Console (CMC) * Using the Central Configuration Manager (CCM) WEB APPLICATION SERVERS MANAGEMENT * Configuring Web Application Servers CENTRAL MANAGEMENT SERVER (CMS) DATABASE * Managing the Central Management Server (CMS) and System Database * Configuring Auditing FILE REPOSITORY SERVER MANAGEMENT * Managing the File Repository Server * Using the Repository Diagnostic Tool ADAPTIVE SERVERS * Managing the Adaptive Job Server * Managing the Adaptive Processing Server CRYSTAL REPORTS SERVERS * Demonstrating Information Flows in Crystal Reports * Configuring Crystal Reports * Managing Crystal Reports Servers WEB INTELLIGENCE SERVER * Managing Web Intelligence Document Schedules * Viewing Web Intelligence Documents * Configuring a Web Intelligence Processing Server * Configuring a Connection Server DASHBOARD SERVERS * Configuring Dashboard Servers * Managing Dashboard Design Servers EXPLORER SERVERS * Configuring Explorer Servers * Managing Information Spaces EVENT SERVERS * Configuring Event Servers * Managing Event Servers SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM 4.1 MONITORING * Monitoring the SAP BusinessObjects Business Intelligence Platform 4.1 * Using the SAP BusinessObjects Business Intelligence Platform 4.1 Monitoring Dashboard ADDITIONAL COURSE DETAILS: Nexus Humans BOE320 SAP BI Platform - Admin Servers (Win) 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 BOE320 SAP BI Platform - Admin Servers (Win) 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.

BOE320 SAP BI Platform - Admin Servers (Win)
Delivered on-request, onlineDelivered Online
Price on Enquiry

IBM Sterling B2B Integrator Fundamentals

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Consultants, Support, System Administrators Overview Upon completion of the course, students will be able to: Run a business process. Create a business process using the Graphical Process Modeler. Explain how to create a service configuration. Explain how to track an executable business process. Discuss the basics of Sterling B2B Integrator. This course teaches students techniques, tools, and recommended practices that can be used to run a business process, create a business process using the Graphical Process Modeler, explain how to create a service configuration, explain how to track an executable business process, and discuss the basics of Sterling B2B Integrator through a combination of lecture and hands-on labs. ABOUT IBM STERLING B2B INTEGRATOR * High level overview of the Admin Console with an exercise to start the application XML AND XPATH BASICS * Review the basics of XML and XPath which is heavily used in the application BASIC BUSINESS PROCESS CONCEPTS * Reviewing what XML and XPath components are used to build business processes * Reviewing how to manually execute a business process within the application TRACKING AND TROUBLESHOOTING BUSINESS PROCESSES * Exercises to demonstrate how to work with business process instances GRAPHICAL PROCESS MODELER (GPM) * Overview of the Graphical Process Modeler * Exercises to walk through the development of a business process in the GPM * Exercises for checking in, executing, and modifying business processes INTRODUCTION TO SERVICE MANAGEMENT * Several exercises showcasing specific services/adapters and other functionality BEST PRACTICES * Covers specific business process development methods that are best practice MAPPING * Introduction to the Map Editor and Standards * Exercises to build and use an XML Encoder Map TYPING MAP * Exercises to build and use a Typing Map CASE STUDY * Exercise to build an end-to-end solution using what was learned in previous exercises TRACKING SYSTEM HEALTH * Review of archiving, migrating, and deleting business processes ADDITIONAL COURSE DETAILS: Nexus Humans IBM Sterling B2B Integrator Fundamentals 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 IBM Sterling B2B Integrator Fundamentals 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.

IBM Sterling B2B Integrator Fundamentals
Delivered on-request, onlineDelivered Online
Price on Enquiry

BOID10 SAP BusinessObjects Information Design Tool

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. BASIC SAP BUSINESSOBJECTS UNIVERSE DESIGN * Describing Universes * Defining the Components of a Universe DATA CONNECTIONS * Defining connections DATA FOUNDATIONS * Creating Data Foundations * Using Joins BUSINESS LAYERS * Accessing Data through the Business Layer * Integrating the Business Layer Components * Validating Objects * Creating Measure Objects * Creating Shortcut Joins LOOPS IN A DATA FOUNDATION * Resolving Loops with Joined Tables * Resolving Loops Using Aliases * Resolving Loops Using Contexts * Detecting Contexts * Editing Contexts * Testing Contexts * Resolving Recursive Loops DATA RESTRICTIONS * Defining Data Restrictions * Applying Mandatory Data Restrictions * Applying Optional Data Restrictions LISTS OF VALUES (LOV) * Providing a List of Values PARAMETERS * Illustrating Runtime Parameters OBJECT @FUNCTIONS * Using Object @functions in Queries * Applying the Aggregate Awareness Optimization Method * Using Other @ Functions NAVIGATION PATHS * Defining Drill Down Navigation Paths DERIVED TABLES * Creating Derived Tables KEY AWARENESS * Defining Numeric Keys UNIVERSE MANAGEMENT WITH DATA FOUNDATION AND BUSINESS LAYER VIEWS * Managing a Universe using the Data Foundation View * Managing a Universe using the Business Layer View UNIVERSE OPTIMIZATION * Optimizing Universes Using Parameters UNIVERSE DEPLOYMENT AND SECURITY * Deploying a Universe * Securing a Published Universe * Creating Data Security Profiles * Creating Business Security Profiles * Assigning Security Profiles to Users * Identifying the Priority of Security Settings * Updating a Published Universe SQL CLAUSE PROCESSING PROBLEMS * Determining How the Order of SQL Clauses Affects Data Returned * Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables * Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables * Identifying Fan Traps * Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables OUTER JOIN PROBLEM RESOLUTION * Resolving an Ambiguous Outer Join Using @AggregateAware UNIVERSE CREATION FROM DIFFERENT DATA SOURCES * Identifying the Different Data Sources * Creating an OLAP Universe * Creating a Multi-source Universe SHARED PROJECTS * Using Shared Projects * Manipulating Other Designers' Resources UNIVERSE CONVERSION * Converting Existing .unv Universes TRANSLATION * Deploying Universes in Different Languages

BOID10 SAP BusinessObjects Information Design Tool
Delivered on-request, onlineDelivered Online
Price on Enquiry

R12.x Extend Oracle Applications - OA Framework Personalizations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

R12.x Extend Oracle Applications - OA Framework Personalizations
Delivered on-request, onlineDelivered Online
Price on Enquiry

Oracle BI 11g R1 - Build Repositories

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 Oracle BI 11g R1 - Build Repositories 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.

Oracle BI 11g R1 - Build Repositories
Delivered on-request, onlineDelivered Online
Price on Enquiry

WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is designed for application developers. Overview Describe the benefits of implementing a decision management solution with Operational Decision Manager.Identify the key user roles that are involved in designing and developing a decision management solution, and the tasks that are associated with each role.Describe the development process of building a business rule application and the collaboration between business and development teams.Set up and customize the Business Object Model (BOM) and vocabulary for rule authoring. Implement the Execution Object Model (XOM) that enables rule execution.Orchestrate rule execution through ruleflows. Author rule artifacts to implement business policies.Debug business rule applications to ensure that the implemented business logic is error-free.Set up and customize testing and simulation for business users.Package and deploy decision services to test and production environments.Integrate decision services for managed execution within an enterprise environment.Monitor and audit execution of decision services.Work with Operational Decision Manager features that support decision governance. This course introduces developers to IBM Operational Decision Manager V8.9.2. It teaches participants the concepts and skills required to design, develop, and integrate a business rule solution with Operational Decision Manager. This course begins with an overview of Operational Decision Manager, which is composed of two main environments: Decision Server for technical users and Decision Center for business users. The course outlines the collaboration between development and business teams during project development. Through instructor-led presentations and hands-on lab exercises, participants learn about the core features of Decision Server, which is the primary working environment for developers. Participants design decision services and work with the object models that are required to author and execute rule artifacts. Participants gain experience with deployment and execution, and work extensively with Rule Execution Server. In addition, students become familiar with rule authoring so that you can support business users to set up and customize the rule authoring and validation environments. Participants also learn how to use Operational Decision Manager features to support decision governance. INTRODUCING IBM OPERATIONAL DECISION MANAGER * Exercise: Operational Decision Manager in action * DEVELOPING DECISION SERVICES * Exercise: Setting up decision services * PROGRAMMING WITH BUSINESS RULES AND DEVELOPING OBJECT MODELS * Exercise: Working with the BOM * Exercise: Refactoring * ORCHESTRATING RULESET EXECUTION * Exercise: Working with ruleflows * AUTHORING RULES * Exercise: Exploring action rules * Exercise: Authoring action rules * Exercise: Authoring decision tables * CUSTOMIZING RULE VOCABULARY WITH CATEGORIES AND DOMAINS * Exercise: Working with static domains * Exercise: Working with dynamic domains * WORKING WITH QUERIES * Exercise: Working with queries * DEBUGGING RULES * Exercise: Executing rules locally * Exercise: Debugging a ruleset * Enabling tests and simulations * Exercise: Enabling rule validation * MANAGING DEPLOYMENT * Exercise: Managing deployment * Exercise: Using Build Command to build RuleApps * Executing rules with Rule Execution Server * Exercise: Exploring the Rule Execution Server console * AUDITING AND MONITORING RULESET EXECUTION * Exercise: Auditing ruleset execution through Decision Warehouse * WORKING WITH THE REST API * Exercise: Executing rules as a hosted transparent decision service (HTDS) * ADDITIONAL COURSE DETAILS: Nexus Humans WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2 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 WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2 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.

WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2
Delivered on-request, onlineDelivered Online
Price on Enquiry

55232 Writing Analytical Queries for Business Intelligence

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE * Two Approaches to SQL Programming * TSQL Data Retrieval in an Analytics / Business Intelligence Environment * The Database Engine * SQL Server Management Studio and the CarDeal Sample Database * Identifying Variables in Tables * SQL is a Declarative Language * Introduction to the SELECT Query * Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY * Turning Columns into Variables for Analysis * Column Expressions, Data Types, and Built-in Functions * Column aliases * Data type conversions * Built-in Scalar Functions * Table Aliases * The WHERE clause * ORDER BY * Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS * Primary Keys, Foreign Keys, and Joins * Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product * Understanding Joins, Part 2: The INNER JOIN * Understanding Joins, Part 3: The OUTER JOINS * Understanding Joins, Part 4: Joining more than two tables * Understanding Joins, Part 5: Combining INNER and OUTER JOINs * Combining JOIN Operations with WHERE and ORDER BY * Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY * Identifying required aggregation level and granularity * Aggregate Functions * GROUP BY * HAVING * Order of operations in SELECT queries * Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS * Non-correlated and correlated subqueries * Derived tables * Common table expressions * Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC * Views * Table-valued functions * Stored procedures * Creating objects for read-access users * Creating database accounts for analytical client tools * Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT * Connecting to SQL Server and Submitting Queries from Client Tools * Connecting and running SELECT queries from: * Excel * PowerBI * RStudio * Exporting datasets to files using * Results pane from SSMS * The bcp utility * The Import/Export Wizard * Lab 1: Getting Your Dataset to the Client ADDITIONAL COURSE DETAILS: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

55232 Writing Analytical Queries for Business Intelligence
Delivered Online4 days, Aug 26th, 13:00 + 1 more
£1785

Oracle BI Publisher 12c R1: Fundamentals

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Analyst Developer End User Implementer Overview Schedule and Burst Reports Perform Translations Create Reports Integrated With Oracle BI EE Administer BI Publisher Server Describe BI Publisher Technology and Architecture Create reports from OBI EE data sources Create and Modify Data Models Create RTF Templates by Using Template Builder Explore and Use the Form Field Method for Creating RTF Templates Create Layouts by Using the Layout Editor This Oracle BI Publisher 12c training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution. BI PUBLISHER TECHNOLOGY AND ARCHITECTURE * Functional Components * Layout Templates * Multitier Architecture * Enterprise Server Architecture and Performance and Scalability * Document Generation Process and Output Formats * Supported Data Sources * Bursting Overview * Internationalization and Language Support GETTING STARTED WITH BI PUBLISHER * Logging In, the Home Page, and Global Header, and Setting Account Preferences * Viewing Reports * Managing Repository Objects * Managing Favorites * Using Create Report wizard to Create Reports * Selecting Data: Data Model, Spreadsheet, and BI Subject Area * Configuring Report Properties USING THE DATA MODEL EDITOR * Exploring the Schemas Used in the Course * Exploring the Data Model Editor UI and the Supported Data Sources * Creating a Private Data Source * Creating a Simple Data Model based on a SQL Query Data Set * Using Query Builder to Build a Query * Viewing Data and Saving Sample Data Sets * Adding Parameters and LOVs to the Query * Configuring Parameter Settings and Viewing Reports with Parameters WORKING WITH LAYOUT EDITOR * Opening the Layout Editor and Navigating the Layout Editor UI * Creating a Layout by Using a Basic Template * Inserting a Layout Grid * Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats * Inserting and Editing Charts, and Converting Charts to a Pivot Tables * Adding Repeating Sections, Text Items, and Images * Working with Lists, Gauges and Pivot Tables * Creating Boilerplates USING TEMPLATE BUILDER TO CREATE RTF TEMPLATES * Using the BI Publisher Menu Bar * Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data * Adding a Chart to an RTF Template * Designing an RTF Template for a BI Publisher Report * Creating a BI Publisher Report by Using Template Builder in Online Mode * Exploring the Basic and Form Field Methods * Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting BI PUBLISHER SERVER: ADMINISTRATION AND SECURITY * Describing the Administration Page * Creating the JDBC Connections * Setting, Viewing, and Updating Data Sources * Describing the Security Model for BI Publisher and Oracle Fusion Middleware * Describing Groups, Users, Roles, and Permissions * Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS * Describing and Configuring BI Publisher Scheduler * Integrating with Oracle BI Presentation Services and Oracle Endeca Server SCHEDULING AND BURSTING REPORTS * Scheduling and Describing a Report Job and Related Options * Managing and Viewing a Report Job * Viewing Report Job History * Scheduling a Report with Trigger * Describing Bursting * Adding a Bursting Definition to a Data Model * Scheduling a Bursting Job INTEGRATING BI PUBLISHER WITH ORACLE BI ENTERPRISE EDITION * Configuring Presentation Services Integration * Navigating Oracle BI EE * Creating a Report based on OBI EE Subject Area * Creating a Data Model and Report based on a BI Server SQL Query * Creating a Data Model and Report based on an Oracle BI Analysis * Adding a BI Publisher Report to an Oracle BI EE Dashboard CREATING DATA MODELS AND BI PUBLISHER REPORTS BASED ON OTHER DATA SOURCES * Configuring Presentation Services Integration * Describing the Web Services Data Source * Describing the HTTP (XML/RSS Feed) Data Source * Explaining Proxy Setting for Web Services and HTTP Data Sources * Creating a BI Publisher Report based on an External Web Service * Creating a BI Publisher Report based on an HTTP Data Set * Creating a BI Publisher Report Based on XML File * Creating a BI Publisher Report Based on CSV Data source PERFORMING TRANSLATIONS * Describing Translation Types * Translating by Using the Localized Template Option * Translating by Using the XLIFF Option * Managing XLIFF Translations on BI Publisher Server * Describing the Overall Translation Process * Describing Catalog Translation * Exporting and Importing the XLIFF for a Catalog Folder ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI Publisher 12c R1: Fundamentals 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 Oracle BI Publisher 12c R1: Fundamentals 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.

Oracle BI Publisher 12c R1: Fundamentals
Delivered on-request, onlineDelivered Online
Price on Enquiry

KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This basic course is for users and developers familiar with earlier versions of IBM InfoSphere Information Server or IBM InfoSphere MDM who want to learn about new features in V11.3 Overview The objectives of this course are as follows:- Learn about the new features of DataStage V11.3- Learn about the new features of Information Analyzer V11.3- Learn about the new features of Data Click V11.3- Learn about the new features of the Information Governance Catalog V11.3 This course is designed to introduce you to new features in data integration and governance in IBM InfoSphere Information Server V11.3 and IBM InfoSphere MDM V11.3. OUTLINE * Unit DS: New Features in IBM InfoSphere DataStage V11.3 * Unit DC: New Features in IBM InfoSphere Data Click V11.3 * Unit IA: New Features in IBM InfoSphere Information Analyzer V11.3 * **All units are accompanied by hands-on lab exercises. ADDITIONAL COURSE DETAILS: Nexus Humans KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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 KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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.

KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3
Delivered on-request, onlineDelivered Online
Price on Enquiry

Educators matching "Oracle Business Intelligence"

Show all 12
British Hang Gliding and Paragliding Association

british hang gliding and paragliding association

Meridian Business Park

Welcome to the British Hang Gliding & Paragliding Association (BHPA) website. From its head office in Leicester the BHPA supports a country-wide network of recreational clubs and registered schools, and provides the infrastructure within which hang gliding and paragliding in the United Kingdom (UK) thrive. Hang Glider (Courtesy Mike Scholes) The BHPA oversees pilot and instructor training standards, and provides technical support such as airworthiness standards, and coaching courses for qualified hang gliding and paragliding pilots. Initial hang gliding or paragliding training must be undertaken at a BHPA registered school. Most schools offer training in a wide range of flying disciplines, so it's important to understand the differences between the disciplines before choosing a school. The Learn to Fly section of this web site explains the relative merits of each discipline, the types of flying involved, and provides an insight into the training methods used. As you near the end of your initial training with one of our registered schools, it's important to start looking for suitable recreational club to join. Obtaining your Club Pilot rating marks the end of your formal instruction and qualifies you to leave the school and fly within a BHPA recreational club. The BHPA supports a network of UK hang gliding and paragliding recreational clubs who are able to offer the supportive flying and social environment vital to the safe development of your flying skills, as you join other recreational flyers on the hill, and continue your progression through the BHPA Pilot Rating Scheme (PRS). As your accumulated airtime increases and your flying skills improve, you will probably start to think about your long term goals and aspirations, and working towards your Pilot Rating, the next rung on the PRS ladder. Club coaches can offer advice and support with the flying tasks that need to be completed, and the theory exam you will need to sit. An online BHPA Mock Pilot Rating Exam is also available. This will allow you to test your current knowledge and help you to understand the subject areas you will need to revise before sitting the real exam. When you first leave your school and join a club, you may choose to spend your first few hours' flying with no specific aim other than to safely accumulate airtime. However, it is well known that pilots make safer more efficient progress when they are given particular tasks to undertake. With that in mind, a panel of experienced BHPA coaches have devised a new pathway to learning, the BHPA Pilot Development Structure. This offers an alternative to the more formal Pilot Rating System, and for newly qualified pilots aims to: encourage interaction between new pilots, their club and its coaches provide a structured way to progress, acquire knowledge and build skills through attainable goals reduce flying related incidents and promote safe flying Paraglider (Courtesy Derek Frith) The BHPA also has a disability initiative called Flyability. This reports directly to the BHPA's Executive Council on disability related matters within the sport. Flyability doesn't simply take people with disabilities flying, it strives to motivate people with disabilities to become involved in the sport of hang gliding and paragliding and to train as pilots. Much of Flyability's work in the sport, focuses around changing peoples perception of disability and their attitudes toward people with disabilities. Disability awareness, education and advice play key roles in Flyability's aims and objectives, as does the development of specialist equipment, training and flying techniques. The BHPA also publishes Skywings, the only magazine dedicated to free flying in the United Kingdom. This glossy full colour magazine is distributed by mail to around 6,500 BHPA members each month as part of their membership package. Powered hang glider (Courtesy Ian Ferguson) Skywings magazine is also read by countless more hang gliding and paragliding pilots and organisations around the world who have purchased an International Skywings magazine subscription from our on-line shop. Freely available electronic copies of Skywings magazine are also published each month on our Skywings page. These can be viewed online as a flipbook magazine, or downloaded as a pdf document. When viewing the magazine online on a device with a small screen, we recommend that you select the single page option in the menu at the top of each issue.

Elevator

elevator

City Quay Business Centre

Elevator is Scotland’s leading private sector organisation dedicated to supporting the entrepreneurs, inventors, disruptors, game changers and business leaders of today and tomorrow. We have a desire to make a difference. As a social enterprise, we work to support entrepreneurship and employability across Scotland. Our mission is to recycle wealth back into the communities we support. Our profits are reinvested into developing and delivering programmes, events and initiatives around the themes of enterprise, employability and entrepreneurship. Our aim is for anyone who is starting or growing a business to have access to all the support they need to make it a success. Our thriving Centres for Entrepreneurship offer a safe space to help ambitious entrepreneurs accelerate their businesses through a range of highly effective accelerator programmes. From the Elevator Programme and Academic Accelerators to our sector specific programmes for creatives, company creative programmes for the energy and sustainable mobility industries to our rural offering – there is something for everyone. We deliver vibrant and inspiring business support to nearly 40% of Scotland’s start-ups - covering both rural and urban space. The largest provider of Business Gateway services in Scotland, we deliver support across Aberdeen, Dundee, Angus, Perth and Lanarkshire. In addition, we have a network of Business Centres, providing flexible, professional office space at 21 different locations across the North of Scotland. These offer valuable community workspaces containing a mixture of small businesses, training and meeting facilities. Our vision for Scotland is clear - a national, connected approach that will stimulate and support the development of an innovative, pioneering, progressive and entrepreneurial society. Engaging and collaborating with partners, founders and alumni, we are collectively making Scotland an inclusive, sustainable and inspiring place in which to do business.