P404 Air Sampling of Asbestos and MMMF and Requirements for a Certificate of Reoccupation Following Clearance of Asbestos is the industry standard qualification for those whose work involves air sampling and clearance testing, such as asbestos analysts. In addition to holding the qualification, they are required to undertake and provide evidence of annual refresher training. RP404 Refresher is a new course, specifically designed to meet this requirement. RP404 Refresher enables candidates to revise and update their knowledge on air sampling and clearance testing techniques, and to receive a certificate of course completion by passing a written examination, which covers both the theory and practice of air sampling and clearance testing.
Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Discuss Katherine Mansfield's ground-breaking collection of short stories and explore her importance 100 years after her death Highlights Take this English book club to maintain your English fluency & accuracy 5 hours of live classes to help you develop phrasing & expressing your ideas Read these short stories and discuss their meaning and impact Be corrected by an expert English teacher to remove errors and mistakes Develop more sophisticated ways of expressing yourself in English in this 5 week English book club course using Katherine Mansfield's The Garden Party & Other Stories. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This collection of short stories was written towards the end of Katherine Mansfield's tragically short life. With a variety of settings - New Zealand, England and the French Riviera - the stories reflect on everyday experience. After an introductory session on the author, each week we will read and discuss the following stories:Week 1: The author's life and legacyWeek 2: At the BayWeek 3: The Garden Party, The Daughters of the Late Colonel, Mr and Mrs DoveWeek 4: The Young Girl, Life of Ma Parker, Marriage à la Mode, The Voyage, Miss BrillWeek 5 : The First Ball, The Singing Lesson, The Stranger, Bank Holiday, An Ideal Family, The Lady's MaidThe stories range from the impressionistic (At the Bay), to the darkly comic (The Daughters of the Late Colonel) and to the brutal and sharp (Miss Brill). Geoff says: "This writer has had a profound effect on both the style of the short story, and on the subject matter and theme. 100 years after her death we are reading her to discuss her literary importance, and to share in her unmistakable delight in being alive and putting life on the page . She said: “The amount of minute and delicate joy I get out of watching people and things … is simply enormous, the detail of life, the life of life.”
Discuss Katherine Mansfield's ground-breaking collection of short stories and explore her importance 100 years after her death Highlights Take this English book club to maintain your English fluency & accuracy 5 hours of live classes to help you develop phrasing & expressing your ideas Read these short stories and discuss their meaning and impact Be corrected by an expert English teacher to remove errors and mistakes Develop more sophisticated ways of expressing yourself in English in this 5 week English book club course using Katherine Mansfield's The Garden Party & Other Stories. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This collection of short stories was written towards the end of Katherine Mansfield's tragically short life. With a variety of settings - New Zealand, England and the French Riviera - the stories reflect on everyday experience. After an introductory session on the author, each week we will read and discuss the following stories:Week 1: The author's life and legacyWeek 2: At the BayWeek 3: The Garden Party, The Daughters of the Late Colonel, Mr and Mrs DoveWeek 4: The Young Girl, Life of Ma Parker, Marriage à la Mode, The Voyage, Miss BrillWeek 5 : The First Ball, The Singing Lesson, The Stranger, Bank Holiday, An Ideal Family, The Lady's MaidThe stories range from the impressionistic (At the Bay), to the darkly comic (The Daughters of the Late Colonel) and to the brutal and sharp (Miss Brill). Geoff says: "This writer has had a profound effect on both the style of the short story, and on the subject matter and theme. 100 years after her death we are reading her to discuss her literary importance, and to share in her unmistakable delight in being alive and putting life on the page . She said: “The amount of minute and delicate joy I get out of watching people and things … is simply enormous, the detail of life, the life of life.”
Duration 5 Days 30 CPD hours Overview Mining data Manipulating data Visualizing and reporting data Applying basic statistical methods Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life. As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making. 1 - Identifying Basic Concepts of Data Schemas Identify Relational and Non-Relational Databases Understand the Way We Use Tables, Primary Keys, and Normalization 2 - Understanding Different Data Systems Describe Types of Data Processing and Storage Systems Explain How Data Changes 3 - Understanding Types and Characteristics of Data Understand Types of Data Break Down the Field Data Types 4 - Comparing and Contrasting Different Data Structures, Formats, and Markup Languages Differentiate between Structured Data and Unstructured Data Recognize Different File Formats Understand the Different Code Languages Used for Data 5 - Explaining Data Integration and Collection Methods Understand the Processes of Extracting, Transforming, and Loading Data Explain API/Web Scraping and Other Collection Methods Collect and Use Public and Publicly-Available Data Use and Collect Survey Data 6 - Identifying Common Reasons for Cleansing and Profiling Data Learn to Profile Data Address Redundant, Duplicated, and Unnecessary Data Work with Missing Value Address Invalid Data Convert Data to Meet Specifications 7 - Executing Different Data Manipulation Techniques Manipulate Field Data and Create Variables Transpose and Append Data Query Data 8 - Explaining Common Techniques for Data Manipulation and Optimization Use Functions to Manipulate Data Use Common Techniques for Query Optimization 9 - Applying Descriptive Statistical Methods Use Measures of Central Tendency Use Measures of Dispersion Use Frequency and Percentages 10 - Describing Key Analysis Techniques Get Started with Analysis Recognize Types of Analysis 11 - Understanding the Use of Different Statistical Methods Understand the Importance of Statistical Tests Break Down the Hypothesis Test Understand Tests and Methods to Determine Relationships Between Variables 12 - Using the Appropriate Type of Visualization Use Basic Visuals Build Advanced Visuals Build Maps with Geographical Data Use Visuals to Tell a Story 13 - Expressing Business Requirements in a Report Format Consider Audience Needs When Developing a Report Describe Data Source Considerations For Reporting Describe Considerations for Delivering Reports and Dashboards Develop Reports or Dashboards Understand Ways to Sort and Filter Data 14 - Designing Components for Reports and Dashboards Design Elements for Reports and Dashboards Utilize Standard Elements Creating a Narrative and Other Written Elements Understand Deployment Considerations 15 - Understand Deployment Considerations Understand How Updates and Timing Affect Reporting Differentiate Between Types of Reports 16 - Summarizing the Importance of Data Governance Define Data Governance Understand Access Requirements and Policies Understand Security Requirements Understand Entity Relationship Requirements 17 - Applying Quality Control to Data Describe Characteristics, Rules, and Metrics of Data Quality Identify Reasons to Quality Check Data and Methods of Data Validation 18 - Explaining Master Data Management Concepts Explain the Basics of Master Data Management Describe Master Data Management Processes Additional course details: Nexus Humans CompTIA Data Plus (DA0-001) 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 CompTIA Data Plus (DA0-001) 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.
In times of crisis, people are in reaction mode. They work more from “fight vs. flight” than by using reason. When we serve these customers, we need to respond appropriately and help them to achieve emotional control so that we can work to solve problems. In this interactive online class, you will learn the tools needed to get yourself in emotional control. You will also learn why people react on emotion and tools to help them get back in control, too. Attendees will be able to: Focus on others to project a UB4ME, customer-centered attitude; Empower people with respect (acknowledging) and control (offering choices); and Understand customers better and develop emotionally-intelligent methods for managing their fears and reactions. Register for this class and you will be sent ONLINE login instructions prior to the class date.