3742 Office Skills courses in Congleton delivered Online

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who have a basic understanding of Microsoft© Outlook© and want to know how to use its advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks. Overview In this course, you will use Outlook?s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings. You will: Insert objects in messages, and modify properties and global options. Organize, search, and manage messages. Protect your mailbox and manage its size. Use rules and Quick Steps to automate message management. Work with advanced calendar settings. Import and forward contacts. Assign delegate permissions and share Outlook items with others. Archive and back up Outlook items using data files. In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you'll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.This course builds upon the foundational knowledge presented in the Microsoft© Outlook© for Office 365? (Desktop or Online): Part 1 course and will help you customize a communication system well-suited to your work style.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 . Modifying Message Properties and Customizing Outlook Topic A: Insert Hyperlinks and Symbols Topic B: Modify Message Properties Topic C: Add Email Accounts to Outlook Topic D: Customize Outlook Options Organizing, Searching, and Managing Messages Topic A: Group and Sort Messages Topic B: Filter and Manage Messages Topic C: Search Outlook Items Managing Your Mailbox Topic A: Manage Junk Email Options Topic B: Manage Your Mailbox Size Automating Message Management Topic A: Use Automatic Replies Topic B: Use Rules to Organize Messages Topic C: Create and Use Quick Steps Working with Calendar Settings Topic A: Set Advanced Calendar Options Topic B: Create and Manage Additional Calendars Topic C: Manage Meeting Responses Managing Contacts Topic A: Import and Export Contacts Topic B: Use Electronic Business Cards Topic C: Forward Contacts Sharing Outlook Items Topic A: Assign and Manage Tasks Topic B: Share Your Calendar Topic C: Share Your Contacts Managing Outlook Data Files Topic A: Use Archiving to Manage Mailbox Size Topic B: Work with Outlook Data Files

Description Take your steps towards learning the advanced concepts of SQL by taking this SQL Developer 2014 Advanced. Through the course, you will master SQL skills and be able to take full command of SQL. You will learn to create materialised views and improve performance by using simple SQL syntax. Learn about partition the tables and performance optimisation using SQL partitioning and explore how to use analytic SQL to aggregate, analyse and report, and model data using the SQL analytic capabilities. You will also learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure by practising SQL Hierarchical features. Use of regular expressions and sub-expressions to search, match and replace strings using SQL built-in functions also explained in this course. Step up to the next level to learn more about the advanced SQL theories which will put you better in your performance and career advancement. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Duration 5 Days 30 CPD hours Overview Ensure a smooth, rapid implementation of PeopleSoft Time and Labor. Better understand how to facilitate the management, planning, reporting and approving of time, and calendar and schedule creation and usage. Set Up System and Time and Labor Tables Learn about and set up the tables that support your Time and Labor system. Identify how to track employee time by period and define workgroups and task groups to group time reporters into useful segments for processing. Manage Time Reporting Enroll time reporters into Time and Labor, and assign them to work schedules. Report time using different tools. Process reported time using the rules you defined to match your business processes. This PeopleSoft Time and Labor - North America Rel. 9.2 training will show you how to implement the PeopleSoft Time and Labor product encompassing features and functionality , and develop a solid foundation of knowledge that allows you to enroll time reporters into Time and Labor, assign them to work schedules, and report and process reported time. Setting Up PeopleSoft Human Resources, Payroll, and Benefits Tables Indentifying Prerequisite Human Resources, Benefits, and Payroll Tables Defining Prerequisite Tables Defining Holiday Schedules Defining Earnings Codes and Programs Defining Pay Groups and Pay Calendars Setting Up Basic PeopleSoft Time and Labor Tables Setting Up Time Zone Offsets Setting Up the Time and Labor Installation Table Setting Up Manager Time Calendar View Options Selecting the Labor Distriution and Labor Dilution Options Establishing Time Reporting Codes Describing Time Reporting Codes (TRC) Defining Time Reporting Code Categories Establishing Time Reporting Codes Defining TRC Programs Defning Compensatory Time Plans Establishing Time Periods Describing Time Periods Establishing Time Periods Establishing Planned Overtime Describing Planned Overtime Features Establishing Planned Overtime Creating Workgroups Describing Key Workgroup Concepts Creating Workgroups Defining Template Built Rules Identifying Online Rule Definition Tools Identifying Steps to Define Rules Defining Template Built Rules Defining Rule Programs Exporting and Importing Rules Describing Rule Template Creation Creating Task Groups Identifying Task Functinlaity Concepts Creating Task Templates Creating Task Profiles Creating Taskgroups Describing Task Profile Reporting Precedence Building Schedules Identifying Scheduling Concepts Describing Scheduling Integrations Identifying the Steps to Create a Schedule Setting Up Schedules Validating Schedules Setting Up Time Reporters Creating Time Reporter Data Maintaining Time Reporter Data Assigning Time Reporters to a Schedule Assigning and Viewing Compensatory Time Off Plans Setting Up Groups and Security Describing PeopleSoft Time and Labor Groups and Security Setting Up Group Creating Security Setting Up Dynamic Groups Setting Up Static Groups Viewing Time Reporters in Groups Setting Up Group Security Reporting Time Using Rapid Entry Describing Time Reporting Establishing Rapid Time Templates Performing Rapid Entry Running the Time Administration Process Describing the Time Administration Process Describing Time Reporter and Payable Time Status Reporting Time Using Self-Service Identifying Time Reporting Defining Time Reoprting Templates Defining User Preferences Reporting Time Using Timesheets Reporting Time Using the Web Clock Identifying Mass Time Reporting Requesting Overtime Requesting Absence Managing Exceptions Defining Exceptions Managing Exceptions Using Fluid and Workforce Availability Setting Up the Time and Labor Mobile Applications Entering Time Reporting as an Employee Managing Time Administration as a Manager Setting Up Workforce Availability Viewing Workforce Availability for Daily and Weekly Time Integrating with PeopleSoft Payroll for North America Integrating with Absence Management Preparing for a Payrun Running the Time and Labor Load Process Setting Up and Using Auto Enrollment Setting Up Auto Enrollment Defining Auto Enrollment Groups Previewing the Enrollment Data Performing Labor Distribution and Dilution Identifying Labor Distribution and Dilution Sending Costs to Time and Labor Viewing Distributed and Diluted Costs Auditing and Adjusting Payable Time Identifying the Stages of Payable Time Adjusting Paid Time Viewing Unprocessed Reported Time Viewing Unprocessed PayableTime Locking Timesheets Performing Labor Distribution and Dilution Identifying Labor Distribution and Dilution Sending Costs to Time and Labor Viewing Distributed and Diluted Costs Auditing and Adjusting Payable Time Identifying the Stages of Payable Time Adjusting Paid Time Viewing Unprocessed Reported Time Viewing Unprocessed PayableTime Locking Timesheets Additional course details: Nexus Humans Oracle PeopleSoft Time and Labor - North America Rel. 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 Oracle PeopleSoft Time and Labor - North America Rel. 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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants and Business Process Owners/Team Leads/Power Users. Overview This course is organized in a fashion that mimics the step by step process planners will undergo in executing production planning tasks on a daily basis. We start with setup up alert profiles to manage the day to day exceptions. Participants will walk through a detailed analysis of the net requirements calculation process that is executed during product heuristics. Gain an understanding of how scheduling is performed as new orders are created. This will include analyzing source determination rules as well as scheduling strategies. Participants will analyze the pegging functionality and the master data parameters that can control the outcome of pegging. Additionally, we will perform an analysis of process, service and REM heuristics. Lastly, perform an overview of the detailed scheduling activities involved in developing an execution schedule. In this course, students gain an in-depth understanding of the advanced topics required to implement production planning in SAP SCM APO. Introduction to Production Planning in SAP Advanced Planning and Optimization (SAP APO) Planning Demand in the Supply Chain Using Production Planning and Detailed Scheduling (PP/DS) Production Planning Results Evaluation Evaluating the Planning Run Results with Alerts Evaluating the Planning Results Evaluating the Planning Run with Advanced Tools Planning Procedure Configuring Basic Parameters for Planning Executing the Production Planning Run Planning a Product Using the Planning Procedure Order Creation with Product Heuristics Using Demand Management in PP/DS Planning Make-to-Order Production Using PP/DS Using Firming in PP/DS Configuring Product Heuristics Managing the Reuse of Procurement Proposals Using the Lot-Size Calculation In Production Planning Scheduling in Production Planning Determining the Source of Supply of the Order Scheduling Operations with the Strategy Profile Scheduling a Planned Order for Production Pegging in Production Planning Configuring Dynamic and Fixed Pegging Additional Heuristics in Production Planning Planning Production Using Process Heuristics Planning Production Using Service Heuristics Configuring Bottom-Up Heuristics Planning Production Using Repetitive Manufacturing (REM) Heuristics Outlining the Integration of Supply Network Planning (SNP) in PP/DS Detailed Scheduling Scheduling Operations with the Detailed Scheduling Planning Board Planning Production with Detailed Scheduling Strategies and Heuristics Managing Setup Times with the Setup Matrix Managing Scheduling with the PP/DS Optimizer Using MRP-Based Detailed Scheduling Additional course details: Nexus Humans SCM250 SAP Production Planning in SAP APO 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 SCM250 SAP Production Planning in SAP APO 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 5 Days 30 CPD hours This course is intended for Business Process Architects, Developers, Consultants, Systems Administrators, and Technology Consultants Overview This course will prepare you to: Explain the use of SAP Process Integration and the path to SAP Process Orchestration (AEX, BPM and BRM) Explain SAP Process Integration architecture Configure JAVA scenarios Understand and configure the different options with which a back- end system can be connected to the SAP Process Integration (formerly known as SAP Exchange Infrastructure) using JAVA. In this course, students learn how to explain the use of SAP Process Integration and learn how to explain SAP Process Integration architecture. Module 1 SAP Process Integration Architecture Module 2 The System Landscape Directory (SLD) Module 3 Interface Objects in the Enterprise Service Repository Module 4 Object Mapping in the Enterprise Service Repository Module 5 Configuration of Integration Directory Communication Objects Module 6 Configuration of Integration Directory Objects for Java Processing Module 7 Operations of SAP Process Integration Module 8 Connectivity Options for SAP Process Integration Module 9 HTTP Connectivity Options Module 10 File Adapter Configuration Module 11 Intermediate Document Connectivity Options Module 12 Configuration of SAP Business Application Programming Interfaces Connectivity Module 13 Enterprise Services and B2B Connectivity Additional course details: Nexus Humans BIT500 SAP Java Process Integration 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 BIT500 SAP Java Process Integration 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 4 Days 24 CPD hours This course is intended for Application Consultants, Developers, System Administrators, and System Architects Overview Understand the need for an enterprise portalLog on to, navigate, and personalize the portalDescribe the components of SAP Enterprise PortalBuild-up a portal navigation structureAdapt the portal user interface to company specificationsExplain and use the main functions of the SAP Enterprise Portal, Knowledge Management and CollaborationExplain and use the community features of the portal add-ons Forums and WikisExplain and use the SAP Fiori Launchpad on Portal' In this course, students will gain knowledge of the basic fundamentals surrounding the SAP Enterprise Portal. Enterprise Portal Explaining Business Motivations for Portals Describing SAP NetWeaver Explaining the Basics of SAP Enterprise Portal The End User's Perspective Logging On and Navigating in SAP Enterprise Portal Personalizing SAP Enterprise Portal Technical Infrastructure Determining System Requirements Outlining SAP Enterprise Portal's Architecture Portal Platform Content Explaining the Object Model for Portal Content Managing iViews Managing Portal Pages Managing Worksets and Portal Roles Explaining Business Packages Outlining Portal Content Development Tools Translating Portal Content Look and Feel of the Portal Managing Portal Themes Managing Framework Pages Managing Portal Desktops Managing Portal Rules (Rule Collections) Security Aspects Identifying Security Aspects Managing Users and Authentication Options Describing Authorization Concepts Describing Single Sign-On (SSO) Evaluating Network Security Knowledge Management (KM) Outlining Knowledge Management (KM) Describing Content Management (CM) Functions Using Web Page Composer (WPC) Describing Search and Classification (TREX) Enterprise Workspaces Explaining Enterprise Workspaces Managing Personal Workspaces Managing Shared Workspaces Collaboration Outlining Collaboration Functions Using Forums Using Wikis Fiori Launchpad on the Portal Outlining SAP Fiori Launchpad on Portal Additional course details: Nexus Humans SAPEP SAP Enterprise Portal - 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 SAPEP SAP Enterprise Portal - 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.

Duration 3 Days 18 CPD hours This course is intended for Technology Consultant System Administrator Application Consultant Overview This course will prepare you to: Set up SLT configurations, replicate data into different targets (such as SAP HANA, SAP BW or Central Finance) and monitor the data replication. In this course, you will learn how to use the trigger based real time data replication technology of the SAP LT Replication Server (SLT). SAP Landscape Replication Server Overview Explaining Positioning and Key Concepts Identifying Use Cases Understanding SLT as Part of the DMIS Product Family SAP Landscape Transformation Server Introduction Understanding the Architectural Concept Explaining the Landscape Strategy and Sizing Aspects Outlining the SLT Installation Procedure Replication to SAP HANA Setting Up Data Replication Executing Data Replication Understanding Advanced Replication Settings Outlining Operations and Monitoring Describing SLT Handling in Special Cases Replication to SAP BW Providing a Scenario Overview Explaining Open Data Provisioning (ODP) Describing Table-Based Replication Comparing Table-Based Replication and ODP Replication to SAP Data Services Explaining SAP Data Services and Architecture Describing the Setup of Replication to SAP Data Services Replication to ABAP Systems Describing the Architecture for Replication into an ABAP System Outlining the Setup for Replication into an ABAP System Replication to Non-SAP Databases Describing the Architecture for Replication to Non-SAP Databases Understanding the Setup of ABAP to Non-ABAP Replication Replication to Central Finance Describing the Architecture for Replication to Central Finance Understanding the Setup and Configuration of Replication to Central Finance SAP Landscape Transformation Replication Server Summary Providing a Summary of the SAP Landscape Transformation Replication Server SAP Landscape Transformation Replication Server 3.0 and Recent Updates Outlining SAP Landscape Transformation Replication Server 3 Updates Additional course details: Nexus Humans SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 Application consultants, Business Analysts, Executives, Technology Consultants, Users Overview By the end of this course, students will be able to:Explain SAP LumiraCreate documents and acquire dataPrepare datasetsVisualize dataShare stories In this course, students will learn how to create stunning and interactive visualizations by choosing a rich library of visualization types, ranging from scatter plots, heat and geo maps to tag clouds, box plots and network charts. Course Outline Positioning and Overview of SAP Lumira Discovery Navigating the BI Launchpad Acquiring Data Enrich the Dataset Create Visualizations Create a Story Sharing Options Using the Lumira Discovery Formula Editor Additional Data Sources Data Mashups