3898 Courses delivered Live Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

4 phone sessions 45 mins One session alone 3 with girlfriend Love language training Emotions evaluation Relationship boundaries Mediation Understanding each other better Overhaul for bad patterns Examining problem areas Couples training course Compromise solutions implementation The conclusion to move forward https://relationshipsmdd.com/product/my-girlfriend-doesnt-give-me-space-package/

Level 3 Supporting Teaching and Learning in Schools Certificate is a RQF qualification & this course play a major role by working with pupils & supporting teachers. This course has been designed to teach the knowledge required to be a teaching assistant and support children’s learning from birth to nineteen years. The course covers various requirements needed to work as an assistant within schools and how to approach a career in the education sector.  ABOUT THIS COURSE: Level 3 Award in Supporting Teaching and Learning is a knowledge only qualification. Experience in the real work environment is not required and the entire course is completed online. Please note that this is a knowledge only Level 3 qualification and does not require any practical assessments. COURSE ASSESSMENT: To pass this course learners must pass 4 assignments. These are completed after navigating through the corresponding lessons and writing your answers to assignment questions. Once these have been read and marked by your personal tutor, feedback and marks are provided to students which contain helpful tips to improve work in future assignments. UNITS COVERED: • Unit 1: Schools and Colleges as Organisations • Unit 2: Support Health and Safety in a Learning Environment • Unit 3: Understand how to Safeguard Children and Young People • Unit 4: Understand How Children and Young People Develop HOW MUCH THIS COURSE COST? Level 3: Award in Supporting Teaching and Learning Course will cost for Distance Learning / Online £249.99 and for class based £349.99. There is no any hidden fess/cost. 

Learn how to create easy to read accessible person centred profiles for children of all ages and young adults. Course Category Person Centred Planning Inclusion Description Person centred planning is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most easily used approach is called creating a one page plan or a person centred profile. All person centred planning tools and processes are driven by a commitment to achieve inclusive outcomes for the person whose plan it is, and the young people involved are always present throughout their planning session. The focus of all person centred approaches is the whole person irrespective of the label they carry. Two people, a process facilitator and a graphic facilitator, typically facilitate plans. The role of the support service staff in this work is as a facilitator not as an expert participant, problem solver, assessor or provider of consultation. One Page Plans are especially effective tools in planning and supporting children and young people with additional support needs and for through-care planning for young people who are looked after or accommodated. Over time person centred working will reveal areas of unmet need in current provision and thereby inform the ongoing strategic planning within any particular region. Testimonials Be the first… Learning Objectives To Explore the values underpinning person centred working To show how One Page Plans naturally capture young people’s strengths and capacities A demonstration of how person centred planning encourages meaningful consultation and participation with young people (particularly for those who cannot make their views known in typical ways To show how Person Centred Planning leads to the building of stronger parent/school partnerships To indicate how person centred planning can promote multi-agency teamwork and shared responsibilities To increase understanding the how of process and graphic facilitation in person centred work. Who Is It For ? Teachers and School Staff Education Services Social Care Staff Health Professionals Transition Coordinators Family Support Workers Link Workers Course Content An introduction to the person centred planning tool of creating a One Page Plan We would stress that this is an introductory day and that participants will be expected to make plans for their own follow up and further practice of the tools covered in the course of the day. If you liked this course you may well like: PERSON CENTRED REVIEWS

In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Course Category Inclusion Description In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Testimonials ‘Inclusive practice has become more daring, more radical, more inspirational, more inclusive. How exciting and encouraging!’ ‘What a moving and energising day – there is so much we can do together’ Learning Objectives Increased confidence regarding developing leadership for inclusive practice in mainstream schools Access to a wider range of practical strategies to impact on team building Deeper understanding of developing vision and consensus Opportunity to reflect on professional attitudes and behaviour towards staff, parents and pupils New skills and processes to make inclusion successful Who Is It For? Heads and Deputies Leaders Managers of Chidren’s Centres Managers of Early Years settings Local Authority Support Services Course Content The course answers the questions: How to get a team thinking and working more inclusively? How to create and share my vision? Where do I start to think about developing a more inclusive setting? How can I get the best out of my team? We will cover a range of areas including: Establishing a welcoming team Building Vision and values Developing Trust Creating inclusive staff teams and communities of acceptance Creative Team problem solving Organisational models Curriculum access and curriculum design for inclusion Work with parents Consensus building If you liked this course you may well like: LEADERSHIP: CREATING AND SHARING YOUR VISION

Learn how to carry out a Person Centred Review based on the values of person centred thinking. Course Category Person Centred Planning Inclusion Strategic Work Visioning and Problem Solving Description Person centred planning is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most commonly used person centred tool is a Person Centred Review – and it shows these values in action. All person centred planning tools and processes are driven by a commitment to achieve inclusive outcomes for the person whose plan it is, and the young people involved are always present throughout their planning session. The focus of all person centred approaches is the whole person irrespective of the label they carry. Two people, a process facilitator and a graphic facilitator, typically facilitate plans. The role of the support service staff in this work is as a facilitator not as an expert participant, problem solver, assessor or provider of consultation. Person Centred Reviews like MAPS and PATH are especially effective tools in planning transitions and annual review processes for young people with additional support needs and for through-care planning for young people who are looked after or accommodated. Over time person centred working will reveal areas of unmet need in current provision and thereby inform the ongoing strategic planning within any particular region. Testimonials Be the first…. Learning Objectives To Explore the values underpinning person centred working To show how person centred planning with Person Centred Reviews naturally captures young people’s strengths and capacities A demonstration of how person centred reviews encourage meaningful consultation and participation with young people (particularly for those who cannot make their views known in typical ways To show how Person Centred Planning leads to the building of stronger parent/school partnerships To indicate how person centred planning can promote multi-agency teamwork and shared responsibilities To increase understanding the how of process and graphic facilitation in person centred work. Who Is It For ? Teachers and School Staff Education Services Social Care Staff Health Professionals Transition Coordinators Family Support Workers Link Workers Course Content An introduction to the person centred planning Person Centred Reviews – live demonstrations of process in action followed by real time coaching of facilitation skills. We would stress that this is an introductory day and that participants will be expected to make plans for their own follow up and further practice of the tools covered in the course of the day. If you liked this course you may well like: PERSON CENTRED PLANNING USING PATH AND MAPS

Electrical safety in organisations is often the responsibility of non-electrically qualified staff, such as facilities managers, risk managers or health & safety officers who have not had systematic training in how to prevent electrical hazards in the workplace. This situation results in a number of deaths in the workplace being caused by electrical incidents. This course provides a comprehensive overview of the fundamentals of electrical safety and a systematic set of principles for assessing and managing electrical safety in any business and across all sectors of industry and the public sector: the subject is universally applicable, across industries and countries. The course is applicable to the buildings, facilities, equipment and environments associated with a wide range of organisations, irrespective of size, which includes the industrial, commercial and the public sectors. The course provides practical guidance to enable individuals and their organisations to have a level of knowledge and understanding to manage the risks associated with an electrical system. It will focus on providing a specific procedure for managing electrical safety. The course follows the structure of the IET’s Code of Practice for Electrical Safety Management. The aim of the Code of Practice for Electrical Safety Management is to provide good practice guidance to enable individuals and their organisations to have a level of knowledge and understanding to manage the risks associated with an electrical system. There are many technical publications that provide guidance on certain aspects of electrical safety but not in a way that provides a process for managing electrical safety.

Course Objectives At the end of this course you will be able to: Identify and work with basic Word 2013 tools and features Edit text in a Word document Modify the appearance of text in a Word document Organise data in tables and lists Insert special characters and graphical objects Control the appearance of pages in a Word document Proof a document Customise the Word environment '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Good pace, questions encoraged, trainer ensured everyone was kept at same level. Jenny Price - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with Word Identify the Components of the Word Interface Create a Word Document Help Editing a Document Navigate and Select Text Modify Text Find and Replace Text Formatting Text and Paragraphs Apply Character Formatting Align Text Using Tabs Display Text as List Items Control Paragraph Layout Apply Borders and Shading Apply Styles Manage Formatting Adding Tables Insert a Table Modify a Table Format a Table Convert Text to a Table Managing Lists Sort a List Renumber a List Customise a List Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Page Setup Apply a Page Border and Color Add a Watermark Add Headers and Footers Control Page Layout Proofing a Document Check Spelling and Grammar Other Proofing Tools Check Accessibility Customising the Word Environment Customise the Word Interface Additional Save Options Who is this course for? Who is this course for? This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included