3050 Courses

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

A one-day workshop aimed at beginners to the world of phone photography and videography for business.

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

QA Level 2 Award In Food Safety In Catering (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations. Accredited, Ofqual regulated qualification Our Food Safety in Catering training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Food safety in Catering certificate fulfils the legal requirements and is a very good way to make sure your employees are trained in Food Safety. The Ofqual Register number for this course is 603/2594/X

QA Level 2 Award In Food Safety For Retail (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations.

QA Level 2 Award In Food Safety For Manufacturing (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations. Accredited, Ofqual regulated qualification: Our Food Safety For Manufacturing training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Food safety For Manufacturing certificate fulfils the legal requirements and is a very good way to make sure your employees are trained in Food Safety. The Ofqual Register number for this course is 603/2592/6

What past delegates said: "I started looking for a course in education and training when I was offered a chance to help deliver some health & safety training in my local area - I was incredibly lucky to have found Ottilia Pochat Training. Ottilia has a wealth of experience in teaching, and she managed to share those skills and techniques with us in a way that was both incredibly informative and fun! I can’t recommend Ottilia Pochat Training highly enough - why wouldn’t you want to learn how to teach from the best?" This course is fully tutor-led and teaches you how to become a good, quality trainer Virtual Classroom, this course is run over 8 weeks: 16 sessions of 2½ hour duration, from 10:00 -12:30 and 13:30 - 16:00 The virtually run course starting on Friday 7 July will be held over 8 consecutive Fridays Face to Face: Five-day course Run by a Dutch teacher who spent 4 years learning to teach and has international teaching experience in working with all age groups Course Contents Roles and responsibilities in education and training Ways to maintain a safe and supportive learning environment Relationships between teachers and other professionals Boundaries between the teaching role and other professionals Points of referral to meet the individual needs of learners Inclusive teaching, including:Ways to create an inclusive teaching and learning environmentCreating an inclusive teaching and learning planJustifying own selection of teaching and learning approaches, resources and assessment methods in relation to individual learner needsUsing teaching and learning approaches to meet learner needsEvaluating the delivery of inclusive teaching and learning including areas for improvementDelivering inclusive teaching and learning to meet individual needs Communicating with learners in a way that meets their needs Understanding assessment in education and training, including:Different methods of assessment and how they can be adapted to meet individual learner needsHow to involve learners and others in the assessment processThe role and use of constructive feedbackRecord keeping of assessments Benefits of this course: This Ofqual regulated course will allow you to work in adult education Or even, run online training sessions With this course, you'll also be able to run professional workshops Accredited, Ofqual regulated qualification Our QA Level 3 Award in Education and Training (RQF) Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can rest assured that your level 3 Award in Education and Training fulfils the legal requirements to kick-start your own career in Education and Training. The Ofqual Register number for this course is 603/2770/4

Time Management 1 Day Training in Dunfermline

Qualsafe Food Allergen Awareness (RQF) Half day course This course gives learners the knowledge and understanding of food allergens and foods that commonly cause intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Benefits of this course: This qualification is aimed at food handlers and other staff involved in food preparation and services It provides knowledge and understanding of food allergens and foods that commonly cause intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. Course Contents: The characteristics and consequences of food allergies and intolerances How to identify and control contamination from allergenic ingredients Ways to accurate communicate of allergen information to consumers Accredited, Ofqual regulated qualification: This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8 Classroom £95.00 pp Enquire about this course Half day course This course gives learners the knowledge and understanding of food allergens and food intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Enquire about this courseCourse ContentsUpcoming Dates Face to Face / Classroom Courses Would you like this course? Contact us and we'll set a date. We also run short, CPD Accredited training sessions in Food Allergens and Intolerances. Enquire about this courseCourse Contents Benefits of this course: This qualification is aimed at those who are working in, or preparing to work in a food handling, food retail or food manufacturing role It provides knowledge and understanding of food allergens and intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. This is an Ofqual regulated qualification, showing your due diligence and care for your customers Enquire about this course Course Contents The characteristics of food allergens, food intolerance and coeliac disease The importance of, and procedures for identifying and controlling food allergen risks How to provide accurate food allergen information Enquire about this course Our Reviews Facebook 5.0 Rating READ FACEBOOK REVIEWS "Informative and very enjoyable!" Google Reviews 5.0 Rating READ GOOGLE REVIEWS Accredited, Ofqual regulated qualification This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8

Highfield Level 2 Award In Food Allergen Awareness And Control In Catering (RQF) Half day course This course gives learners the knowledge and understanding of food allergens and foods that commonly cause intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Benefits of this course: This qualification is aimed at food handlers and other staff involved in food preparation and service who work within the catering industry It provides knowledge and understanding of food allergens and foods that commonly cause intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. This qualification is supported by Allergy UK, who regard it as suitable staff training for catering outlets that wish to apply for their Allergy Aware Scheme. Course Contents: The characteristics and consequences of food allergies and intolerances How to identify and control contamination from allergenic ingredients Ways to accurate communicate of allergen information to consumers Accredited, Ofqual regulated qualification Our Food Allergen Awareness and Control in Catering training course is a nationally recognised, Ofqual regulated qualifications accredited by Highfields Qualifications. This means that you can be rest assured that your Food Allergen Awareness and Control in Catering Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 603/1396/1