Duration 1 Days 6 CPD hours This course is intended for Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards. It is assumed that attendees on the course are familiar with charts. Please note that this course is not suitable for new Excel users, delegates need Ability to create charts Ability to use filters in data Overview This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards.Delegates will learn how to: Power BI Concepts and Main Features How a report is created Navigating reports and dashboards How to apply filters and slicers To use Insights, Analytics and Natural Language Queries Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analyzed visually. Getting Started with Power BI Power BI Concepts and Versions Introduction to Main Features: Jargon buster From Data to Reports and Dashboards Visualizations Overview Visualizations Available Visualizations as Filter Reports and Dashboards Similarities and differences Understanding what you are looking at Understanding what you are looking at Using a Report in Power BI Filters, sorting and using slicers See the actual data See Data and See Records Drill visualizations Off the shelf data analysis Quick Conditional Formatting Analytics lines Use Insight for Increases and Decrease Forecast Analytics Changing calculations and Show As Working with Dashboards Dashboards in Power BI Defined How is a dashboard different from a report? Working in the Dashboard window
Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.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 Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.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.
MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.
One On One Personalised Presentation & Communication Skills Coaching for Senior Executives
Duration 2 Days 12 CPD hours Overview What's New in This Guide? The behind-the-scenes journal entry for transactions is now included. This course is a continuation of topics following ?Get Started with QuickBooks 2020 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2020. This course covers features that are in QuickBooks Pro and Premier 2020. Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with Quick Reports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates
Duration 3 Days 18 CPD hours This course is intended for This course is designed for existing Python programmers who have at least one year of Python experience and who want to expand their programming proficiency in Python 3. Overview In this course, you will expand your Python proficiencies. You will: Select an object-oriented programming approach for Python applications. Create object-oriented Python applications. Create a desktop application. Create data-driven applications. Create and secure web service-connected applications. Program Python for data science. Implement unit testing and exception handling. Package an application for distribution. Python© continues to be a popular programming language, perhaps owing to its easy learning curve, small code footprint, and versatility for business, web, and scientific uses. Python is useful for developing custom software tools, applications, web services, and cloud applications. In this course, you'll build upon your basic Python skills, learning more advanced topics such as object-oriented programming patterns, development of graphical user interfaces, data management, creating web service-connected apps, performing data science tasks, unit testing, and creating and installing packages and executable applications. Lesson 1: Selecting an Object-Oriented Programming Approach for Python Applications Topic A: Implement Object-Oriented Design Topic B: Leverage the Benefits of Object-Oriented Programming Lesson 2: Creating Object-Oriented Python Applications Topic A: Create a Class Topic B: Use Built-in Methods Topic C: Implement the Factory Design Pattern Lesson 3: Creating a Desktop Application Topic A: Design a Graphical User Interface (GUI) Topic B: Create Interactive Applications Lesson 4: Creating Data-Driven Applications Topic A: Connect to Data Topic B: Store, Update, and Delete Data in a Database Lesson 5: Creating and Securing a Web Service-Connected App Topic A: Select a Network Application Protocol Topic B: Create a RESTful Web Service Topic C: Create a Web Service Client Topic D: Secure Connected Applications Lesson 6: Programming Python for Data Science Topic A: Clean Data with Python Topic B: Visualize Data with Python Topic C: Perform Linear Regression with Machine Learning Lesson 7: Implementing Unit Testing and Exception Handling Topic A: Handle Exceptions Topic B: Write a Unit Test Topic C: Execute a Unit Test Lesson 8: Packaging an Application for Distribution Topic A: Create and Install a Package Topic B: Generate Alternative Distribution Files
Duration 5 Days 30 CPD hours This course is intended for System Administrator System Architect Technology Consultant Overview This course will prepare you to: start and stop SAP systems perform system configuration tasks describe the architecture of database systems explain fundamental user administration concepts create RFC destinations implement SAP notes and SAP Support Packages configure printers in SAP systems schedule and monitor background jobs In this five-day training, you will learn how to perform various administrative tasks to keep the SAP system running. This course provides you with fundamental knowledge on how to ensure a smooth operation of SAP systems running on Application Server ABAP (AS ABAP). AS ABAP is the technological foundation of SAP Business Suite as well as SAP S/4HANA systems. You will also learn the theoretical administration concepts within AS ABAP and work practically in an SAP system and on the operating system level. Course Content AS ABAP Fundamentals Starting and Stopping SAP Systems Technical System Configuration Setting profile parameters Setting up and working with operation modes Working with task lists Architecture of database systems Understanding basic database administration Fundamentals of User Administration Understanding the user administration concept Understanding the AS ABAP authorization concept RFC Communication Setting up RFC connections Software Maintenance Implementing SAP Notes and SAP Support Packages Preparing a software maintenance process Working with the Support Package Manager (SPAM) Understanding the Software Update Manager (SUM) Output Management Configuring printers Background Processing Scheduling background jobs System Monitoring and Troubleshooting Monitoring architecture Monitoring with SAP Solution Manager Additional course details: Nexus Humans ADM100 System Administration I of SAP S/4HANA and SAP Business Suite 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 ADM100 System Administration I of SAP S/4HANA and SAP Business Suite 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 Application Consultant Business Process Owner / Team Lead / Power User Help Desk/CoE Support Trainer Overview This course will prepare you to: Configure organizational structure elements and service products for SAP S/4HANA Service Perform general configuration of service processes in SAP S/4HANA Service Configure an on-site service process in SAP S/4HANA Service Configure an in-house repair process in SAP S/4HANA Service Configure service contracts in SAP S/4HANA Service This course will prepare you to configure the most important business processes in SAP S/4HANA Service. The configuration for both and on-site service process and an in-house repair process is explained. Service contract configuration is also a topic. The integration with Controlling, the Cross-Application Time Sheet (CATS) and integration with Logistics in SAP S/4HANA is also discussed. Service Processing in SAP S/4HANA - Overview and Process Steps Executing a Service Process in SAP S/4HANA Configuring Organizational Structure Elements and Service Products Configuring Organizational Structure Elements for SAP S/4HANA Service Configuring Service Products General Configuration of Service Processes Configuring a Transaction Type Configuring an Item Category Configuring Item Category Determination Copying Control for Business Transactions Configuring the Integration with Controlling Configuring the Integration with the Cross-Application Time Sheet (CATS) Configuring Pricing for Service Transactions Other Basic Settings for Business Transactions Configuring an On-site Service Process Settings for Service Requests Settings for Service Order Quotations and Service Orders Settings for Service Confirmations and Service Billing Test the New Configuration in the System Configuring In-House Repair In-House Repair Processing In-House Repair Customizing Configuring Service Contracts Configuring Service Contracts
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.
Duration 3 Days 18 CPD hours This course is intended for Anyone interested in getting an overview of SAP S/4HANA Overview This course will prepare you to: Explain how SAP S/4HANA supports the digital transformation Navigate in SAP S/4HANA using SAP Fiori UX and other client technologies Describe system-wide concepts such as organizational elements or master data Describe key business processes of SAP S/4HANA Enterprise Management and SAP S/4HANA LoB solutions Describe integration scenarios between SAP S/4HANA and SAP Cloud solutions Explain SAP S/4HANA embedded analytics capabilities and additional BI/BW tools Gain basic knowledge about SAP Activate to accelerate SAP S/4HANA adoption This course provides an overview of SAP S/4HANA for learners who do not yet have specific SAP background knowledge and want to build SAP S/4HANA skills. Module 1 SAP S/4HANA Overview Module 2 Navigation Module 3 System-wide concepts Module 4 Logistics capabilities Module 5 Finance capabilities Module 6 Human Resources capabilities Module 7 SAP Activate Additional course details: Nexus Humans S4H00 SAP S/4HANA Overview 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 S4H00 SAP S/4HANA Overview 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.