262 Courses in Manchester

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Overview The most significant network between the organisation and their investors is Financial Statements and annual reports. It is very important to understand the role of these factors to have better communication channels. This course will give you intense knowledge to prepare financial statements according to International Financial Reporting Standards. IFRS regulates financial reporting standards and according to it the company's financial reporting should be transparent. Thus, if it is as per IFRS rules, its credibility can be trusted. It will also help to analyse the financial statement and annual reports. It will enable you to evaluate corporate accounts and make strong decisions and judgements about the company's status.

Overview Financial Accounting and reporting play a very important role within the organization and its stakeholders. This course is designed to analyze the functions of financial reporting in communication and its effects on decision-making processes or managerial decisions. It will highlight the accounting and financial standards-setting process and its implication on the organization globally. Financial accounting and reporting discuss how accountants act as processors and purveyors of information for decision-making and the needs of those who use accounting information. It also looks at the role performed by accountants and notes the need to be aware of relevant regulatory and conceptual frameworks. 

Overview Financial Analysis and reporting play a very important role within the organisation and its stakeholders. This course is designed to analyse the functions of financial reporting in communication and its effects on decision-making processes or managerial decisions. It will highlight the accounting and financial standards-setting process and its implication on the organisation globally. Financial Analysis and reporting discuss how accountants act as processors and purveyors of information for decision-making and the needs of those who use accounting information. It also looks at the role performed by accountants and notes the need to be aware of relevant regulatory and conceptual frameworks.

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

Our training programme will provide those involved at any stage of the process for procuring goods and/or services within their organisations with the knowledge and skillset to identify and mitigate the threat posed by the breadth and multi-layered complexity of procurement fraud and corruption.

This practical, enjoyable day will give you the tools to go and do your job effectively and the opportunity to practise using them in a safe and supportive environment before putting them into practice for real back in the workplace. To inspire, you need to be inspired!Having the right set of skills, tools and techniques helps us to manage in a productive and beneficial way. Above all, the workshop will inspire you with the determination to engage with the people you manage to produce greater levels of achievement. This workshop will enable you to: Understand what the role of the manager is Engage and inspire a team to perform Recognise the range of styles appropriate for different situations and how your communication style impacts Provide clear direction on your team's purpose, role and responsibilities Understand how to create a motivating environment for those who report to you Hold them accountable for delivery Hold performance conversations Review and evaluate your learning and have a plan to take back and implement at work 1 Bringing the role to life Starting the day with sharing your current ideals and approaches using the pre workshop task Understanding what you bring to your role and your objectives for the day 2 The role and responsibilities of a manager: an overview Responsibility and accountability Producing results Managing teams Developing individuals 3 Communication excellence The model of a team communicator What type of communicator are you and what about your team? Practical interactive group exercise 4 Your role as a team leader - shaping how we work using the organisation's values Your role Your team's role Enabling your team to deliver in a changing mindset 5 Engaging and motivating your team Exercise: using a leadership model to explore how you are enabling your team to engage with current change, what's getting in the way and how you will manage this in your organisational context Peer and group task and discussion 6 Addressing motivation at team and individual level in times of change Exercises:Identifying approaches to motivating people at work based on a work based model of motivation: team taskExploring a behavioural model of motivation: team discussion Review in plenary 7 Holding people accountable The work cycle model of team performance: Agree purposeSet objectivesMonitor performanceProvide feedbackCompliance vs. commitment Professional discussion in small groups Exercise: Practising short conversations using peer coaching support 8 Review of learning and action planning Personal review and action planning Group review of learning Evaluation

Our training programme will provide those involved at any stage of the process for procuring goods and/or services within their organisations with the knowledge and skillset to identify and mitigate the threat posed by the breadth and multi-layered complexity of procurement fraud, corruption and associated financial crime and money laundering.

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

About this Course This 5 full-day course provides a comprehensive understanding of all the commissioning procedures for combined cycle power plants. The Commissioning Management System (CMS) of combined cycle power plants is covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report. The course provides also a thorough understanding of all the commissioning requirements for gas turbines, steam turbines and auxiliaries, generator and auxiliaries, electrical equipment, switchgear equipment, switchgear and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component in a combined cycle power plant, instrumentation, trial run of the equipment, safety and precautions, commissioning of combined cycle power plant systems, safety rules clearance certificates, procedure for the control and handling of defects, commissioning reports, operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any combined cycle power plant equipment because it provides detailed pre-commissioning checks and tests, and detailed tests and commissioning procedures and instructions for every component in a combined cycle power plant. In addition, the seminar provides an in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each combined cycle power plant equipment, safety and precautions, safety rules clearance certificates, procedures for handling defects, and commissioning reports. Training Objectives Pre-commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for Every Equipment in Combined Cycle Power Plants: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for every equipment in combined cycle power plants Commissioning Management System (CMS) of Combined Cycle Power Plants: Discover the benefits of the CMS of combined cycle power plants including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report Commissioning Procedures and Instructions for Heat Recovery Steam Generators, Air Blow and Steam Blow of Steam and Gas Piping in Combined Cycle Power Plants: Learn about the commissioning procedures and instructions for heat recovery steam generators, chemical cleaning of heat recovery steam generators, air blow and gas blow of steam and gas piping in combined cycle power plants, safety valve setting and soot blowers Commissioning Procedures and Instructions for Gas Turbines and Steam Turbines: Gain a thorough understanding of all the commissioning procedures and instructions for gas and steam turbines and auxiliaries including acid cleaning of oil pipelines, lubrication and governing system (oil flushing and hydraulic testing), jacking oil system, governing system, regenerative system, barring gear, vacuum tightness test, first rolling of turbine and data logging Commissioning Procedures and Instructions for Generator and Auxiliaries: Discover all the commissioning procedures and instructions for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and start-up of generators Commissioning Procedures and Instructions for Electrical Equipment: Learn about all the commissioning procedures and instructions for electrical equipment including switchyard equipment, switchgear, transformers and motors Operational Testing, Performance Testing, Heat Rate Testing, Emission Testing of Combine Cycle Power Plants: Gain a thorough understanding of operational testing, first fire, generator synchronization, performance testing, heat rate testing, emission testing, contract testing, CO2 concentration tests, electrical full-load rejection test, duct burner testing, partial load stability test, and reliability test of combined cycle power plants Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations