This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security
Duration 5 Days 30 CPD hours This course is intended for This is a basic-level programming course designed for attendees with prior development experience in another language, such as COBOL, 4GL, Mainframe or other non-object oriented languages. This course is not geared for non-developers. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core OO coding and Java development skills, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand what OO programming is and what the advantages of OO are in today's world Work with objects, classes, and OO implementations Understand the basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction Understand not only the fundamentals of the Java language, but also its importance, uses, strengths and weaknesses Understand the basics of the Java language and how it relates to OO programming and the Object Model Work with the Modular system (Project Jigsaw) Understand and use classes, inheritance and polymorphism Understand and use collections, generics, autoboxing, and enumerations Process large amount of data using Lambda expressions and the Stream API Abstract, static and private methods in interfaces Take advantage of the Java tooling that is available with the programming environment being used in the class Java 11 features covered: Using the Local Variable Type in Lambda expressions; Updates made to the String API This course provides hands-on Java 11 training for developers who have little or no prior working knowledge of object-oriented programming languages such as C, COBOL, and 4GL. You will learn the best practices for writing great object-oriented programs in Java 11, using sound development techniques, new improved features for better performance, and new capabilities for addressing rapid application development. Special emphasis is placed on object oriented concepts and best practices. A First Look The Java Platform Using the JDK The Eclipse Paradigm Getting Started with Java Writing a Simple Class Adding Methods to the Class OO Concepts Object-Oriented Programming Inheritance, Abstraction, and Polymorphism Essential Java Programming Language Statements Using Strings Specializing in a Subclass Fields and Variables Using Arrays Local-Variable Type Inference Java Packages and Visibility Object Oriented Development Inheritance and Polymorphism Interfaces and Abstract Classes Introduction to Exception Handling Exceptions Java Developer's Toolboxÿ Utility Classes Java Date/Time Advanced Java Programming Introduction to Generics Lambda Expressions and Functional Interface Working with Collections Collections Using Collections Stream APIÿ Streams Collectors The Java Module System Introduction to the Module System Time Permitting Formatting Strings Introduction to Annotations Java 12 and beyond Additional course details: Nexus Humans Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) 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 Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) 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 This course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications, such as data science, machine learning, artificial intelligence, and web development. Overview In this course, you will develop simple command-line programs in Python. You will: Set up Python and develop a simple application. Declare and perform operations on simple data types, including strings, numbers, and dates. Declare and perform operations on data structures, including lists, ranges, tuples, dictionaries, and sets. Write conditional statements and loops. Define and use functions, classes, and modules. Manage files and directories through code. Deal with exceptions. Though Python has been in use for nearly thirty years, it has become one of the most popular languages for software development, particularly within the fields of data science, machine learning, artificial intelligence, and web development?all areas in which Python is widely used. Whether you're relatively new to programming, or have experience in other programming languages, this course will provide you with a comprehensive first exposure to the Python programming language that can provide you with a quick start in Python, or as the foundation for further learning. You will learn elements of the Python 3 language and development strategies by creating a complete program that performs a wide range of operations on a variety of data types, structures, and objects, implements program logic through conditional statements and loops, structures code for reusability through functions, classes, and modules, reads and writes files, and handles error conditions. Lesson 1: Setting Up Python and Developing a Simple Application Topic A: Set Up the Development Environment Topic B: Write Python Statements Topic C: Create a Python Application Topic D: Prevent Errors Lesson 2: Processing Simple Data Types Topic A: Process Strings and Integers Topic B: Process Decimals, Floats, and Mixed Number Types Lesson 3: Processing Data Structures Topic A: Process Ordered Data Structures Topic B: Process Unordered Data Structures Lesson 4: Writing Conditional Statements and Loops in Python Topic A: Write a Conditional Statement Topic B: Write a Loop Lesson 5: Structuring Code for Reuse Topic A: Define and Call a Function Topic B: Define and Instantiate a Class Topic C: Import and Use a Module Lesson 6: Writing Code to Process Files and Directories Topic A: Write to a Text File Topic B: Read from a Text File Topic C: Get the Contents of a Directory Topic D: Manage Files and Directories Lesson 7: Dealing with Exceptions Topic A: Handle Exceptions Topic B: Raise Exceptions
What You'll Learn An introduction to reactive expressions - how they differ from base R functionality and why they are needed within Shiny. Simple reactive expressions - creating dynamic data expressions Reacting to user-initiated actions - how to get your dashboard to adapt dynamically to user inputs Nested reactions - more complex relationships where multiple actions need to bee accounted for About The Trainer Jeremy has been using R since the very first day of his career in 2005, when it was better known as a mere letter of the alphabet! As an early adopter of the language, he’s seen it evolve – from its ugly initial versions to more elegant analytics solutions underpinned by the tidyverse, on which this course is focused. He is a regular speaker on UK R circuit and co-organises a number of R-community groups, including LondonR, ManchesterR & BrightonR, and the infamous EARL conference! About Us Datacove are a data and analytics consultancy specialising in customer analytics, marketing analytics and process automation. With over 20 years of combined experience in the industry we answer the questions that sit at the heart of every business, from who your customers are, to where and how you find more of them and how much you need to spend to do so. We also automate your most painful business processes, removing the 20+ hours you spend on them per week, forever! Extra Information Our courses are delivered during core office hours, ensuring they fit seamlessly into your work schedule. Once your booking is confirmed, we will send you a Microsoft Teams link, allowing you to join the session with ease.
What You'll Learn Static vs dynamic displays - why interactive plots and tables are useful in shiny and how they can contribute towards the overall usability of the application Introduction to highcharter - how to create rendered, interactive plots using a similar syntax to the tidyverse (ggplot2) Developing dynamic charts within high charts - creating visualisations that respond to user-initiated actions within the application Introduction to DT - a package for creating data tables that users can interact with, e.g. by searching for specific pieces of data Developing dynamic tables within DT - developing sortable and searchable interactive tables for use in the application About The Trainer Jeremy has been using R since the very first day of his career in 2005, when it was better known as a mere letter of the alphabet! As an early adopter of the language, he’s seen it evolve – from its ugly initial versions to more elegant analytics solutions underpinned by the tidyverse, on which this course is focused. He is a regular speaker on UK R circuit and co-organises a number of R-community groups, including LondonR, ManchesterR & BrightonR, and the infamous EARL conference! About Us Datacove are a data and analytics consultancy specialising in customer analytics, marketing analytics and process automation. With over 20 years of combined experience in the industry we answer the questions that sit at the heart of every business, from who your customers are, to where and how you find more of them and how much you need to spend to do so. We also automate your most painful business processes, removing the 20+ hours you spend on them per week, forever! Extra Information Our courses are delivered during core office hours, ensuring they fit seamlessly into your work schedule. Once your booking is confirmed, we will send you a Microsoft Teams link, allowing you to join the session with ease.
What You'll Learn Overview of the Shiny interface - the difference between a UI and a server and how they interlink Shiny folder structures - hows to store and use static datasets, imagery and other assets for your application. Introduction to Shiny servers - how to create and deploy your first application and how to manage deployments within Shiny apps Basic Shiny UI inputs - include filters/drop downs, date sliders, text and buttons About The Trainer Jeremy has been using R since the very first day of his career in 2005, when it was better known as a mere letter of the alphabet! As an early adopter of the language, he’s seen it evolve – from its ugly initial versions to more elegant analytics solutions underpinned by the tidyverse, on which this course is focused. He is a regular speaker on UK R circuit and co-organises a number of R-community groups, including LondonR, ManchesterR & BrightonR, and the infamous EARL conference! About Us Datacove are a data and analytics consultancy specialising in customer analytics, marketing analytics and process automation. With over 20 years of combined experience in the industry we answer the questions that sit at the heart of every business, from who your customers are, to where and how you find more of them and how much you need to spend to do so. We also automate your most painful business processes, removing the 20+ hours you spend on them per week, forever! Extra Information Our courses are delivered during core office hours, ensuring they fit seamlessly into your work schedule. Once your booking is confirmed, we will send you a Microsoft Teams link, allowing you to join the session with ease.
Creating Family Friendly Museums: Afternoon Cuppa Session (Wales) Monday 7 July, 2-3pm Join us for an informal virtual briefing and Q&A session to help you think about low and no cost changes you could make to enhance your museum’s family provision using the Kids in Museums Manifesto. The Kids in Museums Manifesto is a set of simple guidelines for museums, heritage sites and cultural organisations, which we update every two years. In late 2024, we consulted hundreds of children, young people and families about what makes a heritage site a great place to visit, using their responses to shape a new version of the Manifesto. In this session, we will introduce the new version, along with low and no cost changes you could make to improve your museum for a family audience. You can also find out about the Kids in Museums Manifesto Self-Assessment Tool, which can support you to do a light touch self-audit of how well your museum or heritage site meets the Kids in Museums Manifesto. The Kids in Museums Manifesto Self-Assessment Tool is particularly aimed those with limited budgets. In this session, we will: Provide a range of practical ideas to inspire your family friendly provision. Share how your organisation can use the Kids in Museums Manifesto Self-Assessment Tool to improve your family offer. Hear a case study from Ruthin Gaol about the changes they made to their family offer following a Kids in Museums Family Friendly Museum Audit. Please bring along your own cuppa and snacks! Take a look at the full schedule. This event will be delivered virtually over one hour. This session will be delivered in English with bilingual slides, with the option to provide a Welsh language interpreter. The Kids in Museums Manifesto and self-assessment tool are also available in Welsh. Generously supported by the Welsh Government. Who should attend? This training is aimed at staff and volunteers who work in museums, art galleries and heritage sites who are interested in making their organisations more family friendly. This training webinar is for staff and volunteers from Welsh museums only. Creu Amgueddfeydd sy’n Croesawu Teuluoedd: Sesiwn Paned Prynhawn (Cymru) Dydd Llun 7 Gorffennaf, 2-3pm Ymunwch â ni ar gyfer sesiwn briffio a holi ac ateb anffurfiol ar-lein i’ch helpu i ystyried sut y gallech chi wneud newidiadau am ddim, neu am gost isel, i wella darpariaeth eich amgueddfa i deuluoedd gan ddefnyddio Maniffesto Kids in Museums. Mae Maniffesto Kids in Museums yn gyfres o ganllawiau syml i amgueddfeydd, safleoedd treftadaeth a sefydliadau diwylliannol, yr ydym yn ei ddiweddaru bob dwy flynedd. Tua diwedd 2024, aethom ati i holi cannoedd o blant, pobl ifanc a theuluoedd am yr hyn sy’n gwneud safle treftadaeth yn lle da i ymweld ag o. Yna aethom ati i ddefnyddio eu hatebion i siapio fersiwn newydd o’r Maniffesto. Yn y sesiwn hon, byddwn yn cyflwyno’r fersiwn newydd hwn, ac yn awgrymu newidiadau cost isel, neu am ddim, y gallech eu gwneud i wella eich amgueddfa i deuluoedd sy’n ymweld. Gallwch hefyd ddysgu am Offeryn Hunanasesu Maniffesto Kids in Museums, sy’n gallu eich cefnogi chi i wneud hunan-archwiliad ysgafn o’r graddau y mae eich amgueddfa neu safle treftadaeth yn cyfateb â Maniffesto Kids in Museums. Mae Offeryn Hunanasesu Maniffesto Kids in Museums wedi’i anelu’n arbennig at safleoedd sydd â chyllidebau cyfyngedig. Yn y sesiwn hon, byddwn yn: Cynnig amrywiaeth o syniadau ymarferol i ysbrydoli eich darpariaeth sy’n addas i deuluoedd. Rhannu sut y gall eich sefydliad ddefnyddio Offeryn Hunanasesu Kids in Museums i wella eich cynnig i deuluoedd. Clywed astudiaeth achos o Garchar Rhuthun am y newidiadau a wnaethant i’w cynnig i deuluoedd yn dilyn Archwiliad Amgueddfeydd sy’n Croesawu Teuluoedd gan Kids in Museums. Dewch â’ch paned a’ch byrbryd eich hun! Gwelwch yr amserlen lawn. Bydd y sesiwn hon yn para awr ac yn cael ei darparu ar-lein. Bydd yn cael ei chyflwyno drwy gyfrwng y Saesneg gyda sleidiau dwyieithog, a’r opsiwn i gael cyfieithydd Cymraeg. Mae Maniffesto Kids in Museums a’r pecyn hunanasesu ar gael yn Gymraeg hefyd. Gyda chefnogaeth hael gan Lywodraeth Cymru. Pwy ddylai fynychu? Mae’r hyfforddiant hwn wedi’i fwriadu ar gyfer staff a gwirfoddolwyr sy’n gweithio mewn amgueddfeydd, orielau celf a safleoedd treftadaeth sydd â diddordeb mewn gwneud eu sefydliadau’n fwy croesawgar i deuluoedd. Mae’r gweminar hyfforddi hwn i staff a gwirfoddolwyr mewn amgueddfeydd yng Nghymru yn unig.
Duration 4 Days 24 CPD hours This course is intended for This advanced course is the third in a series of three classes designed for RPG IV programmers. Programming experience using RPG IV is mandatory when enrolling in this course. You should have attended RPG IV Programming Fundamentals Workshop for IBM i (AS060) and RPG IV Programming Intermediate Workshop for IBM i (AS070). This course is not designed for RPG III programmers who want RPG IV. RPG III programmers should review the agenda carefully before they make a decision to attend this class. Overview Use address pointers and user spaces in RPG IV programs Write database triggers in RPG IV Develop ILE modular objects and package them in service programs Explain the purpose of ILE activation groups Explain the behavior of error handling and percolation in ILE Code an ILE error handling program Call application program interfaces (APIs) from RPG IV program Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i. Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills & techniques. Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i.
Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level XML training course, designed for those needing an introduction to concepts and technologies associated with XML and its related recommendations. Previous experience or knowledge of HTML is helpful but not essential. Overview This course is an intensive, hands-on introduction to XML, XPath, and XSLT. The course is a balanced mixture of theory and practical labs designed to take students from the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with the fundamentals of XML, including coverage of DTDs and XML Schema. It then moves on to the XPath and XSLT standards, and how to use them to transform XML documents into other documents such as HTML documents or other XML documents. This course provides indoctrination in the practical use of W3C standards (including XSL and XML Schema) and of implementing tools and technologies. This course is programming language independent, making it useful for Java, .NET, C++, and any other programming orientation. Graduates will hit the ground running, applying XML to projects at both an architectural as well as a line by line coding level. We can easily adapt this course to industry and client specific needs.In addition to valuable knowledge and working examples, students receive a copy of the 'Xtensil' product. This unique software was developed to assist in implementing, testing, and fielding XML applications. Xtensil is used as both a teaching aid and a straightforward, basic, fully functional XML toolkit that students can use on Windows and Linux platforms. Working in a hands-on learning environment student will learn to: Write well-formed XML documents Model business requirements using XML Handle XML reserved characters Validate an XML document with a DTD and with a Schema Centralize data and markup definition with entities Create DTDs and Schemas using XML tools Generate XML documents from databases Write XSL templates to transform XML documents into HTML Integrate XML, XSL and the DOM to implement a complete solution The Extensible Markup Language (XML) is a standard that is enabling a revolution in web applications and business to business interactions. XML is the basis for Wireless Markup Language (WML), Voice Markup Language (VoiceML), Simple Object Access Protocol (SOAP), Web Services, and numerous industry initiatives such as ACORD (insurance), PXML (proposal/RFP) and OTA (travel). Introduction to XML is a three-day, hands-on course geared for software developers who need to understand what XML is and how to use in with today's systems and architectures. This course covers the topics from tags to architectures. The course is a balanced mixture of theory and practical labs designed to take students from a quick review of the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with a quick review of the fundamentals of XML before covering XML Schema in detail. It then moves on to the XPath and XSLT covering advanced topics in both. Finally, XML and Web Services security mechanisms and issues are addressed. XML Content Introduction to XML XML Mechanics XML Structure Namespaces Structure Using Schemas XML Formatting CSS and Rendering XML XSL Transformations XSLT and XPath XPath 2.0 and XSLT 2.0 Overview XSL FO (Formatting Objects) Applying XML XML Interoperability XML Performance Improvements Web Services Overview XML Applications Additional course details: Nexus Humans Introduction to XML (TT4300) 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 Introduction to XML (TT4300) 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.