This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 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 and Business Intelligence. 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing
Course Overview The Canine First Aid and CPR Course provides essential knowledge and skills to respond to emergencies involving dogs. It covers a range of critical topics, including first aid, CPR, and basic health assessments. This course is designed to empower learners with the confidence to act decisively in a variety of canine emergency situations, enhancing the safety and well-being of pets. Upon completion, learners will gain the ability to handle common canine injuries and medical emergencies, ensuring pets receive the care they need in times of distress. Course Description This course dives deep into key areas of canine health and emergency response. Learners will explore pet first aid, including injury management and common health issues, along with essential CPR techniques for dogs. The course also covers important aspects of pet business practices, giving those interested in the pet care industry a well-rounded understanding. With an engaging and thorough curriculum, learners will develop the skills required to provide immediate assistance to dogs in need, preparing them for any situation that may arise. The course is designed for all levels of learners, from beginners to professionals seeking to expand their knowledge in pet care. Course Modules: Module 01: Pet First Aid Key first aid procedures for dogs Identifying and treating common injuries Basic wound care and infection prevention Module 02: Pet CPR Techniques for canine CPR Recognising signs of cardiac arrest in dogs Step-by-step guide to performing CPR Module 03: Pet Business Essential business practices for pet care professionals Overview of pet care industry trends Marketing and client management for pet businesses (See full curriculum) Who is this course for? Individuals seeking to improve their dog care knowledge. Professionals aiming to expand their skill set in the pet care industry. Beginners with an interest in pet health and emergency care. Pet owners looking to become more confident in handling canine emergencies. Career Path Pet Care Professional Canine Health Advisor Dog Trainer or Behaviourist Veterinary Assistant Pet Business Owner
Course Overview This Sexual Harassment Awareness Training is designed to equip individuals with the knowledge and skills to recognise, address, and prevent sexual harassment in the workplace. Covering key concepts, legal frameworks, and organisational responsibilities, the course provides essential insights into maintaining a respectful and safe work environment. Participants will gain a thorough understanding of what constitutes sexual harassment, how to identify it, and how to manage such situations effectively. By completing this course, learners will be better prepared to contribute to a respectful and legally compliant workplace culture. Course Description This course delves into various aspects of sexual harassment, from definitions to workplace implications, and legal frameworks. It covers the different forms of harassment, employee rights, and employer obligations. Learners will explore how to effectively address and prevent incidents of harassment, ensuring worker protection through robust policies and procedures. The course also covers the process of dealing with incidents, including mediation and the aftermath, helping individuals recognise the importance of fostering a safe, respectful work environment. Upon completion, learners will have the skills to proactively contribute to creating a harassment-free workplace. Course Modules Module 01: What is Sexual Harassment? Module 02: Sexual Harassment in the Workplace Module 03: The Law and Sexual Harassment Module 04: Addressing Sexual Harassment Module 05: Worker Protection Module 06: Prevent Sexual Harassment at Work Module 07: Policies and Procedures Module 08: How to Deal with Sexual Harassment in the Workplace? Module 09: Mediation and the Aftermath (See full curriculum) Who is this course for? Individuals seeking to understand workplace dynamics and employee rights. Professionals aiming to enhance their knowledge of workplace law and ethical practices. Beginners with an interest in workplace relations and human resources. Any other individual interested in fostering a respectful workplace environment. Career Path HR Manager Equality and Diversity Officer Workplace Health and Safety Specialist Legal Advisor (Employment Law) Corporate Trainer or Consultant
Presentation Skills Course Overview This course on Presentation Skills is designed to help learners develop the confidence and techniques necessary to deliver engaging and effective presentations. It covers key aspects of presentation delivery, from understanding audience psychology to mastering various engagement techniques. Learners will be guided on how to structure content, use humour, and create a safe, welcoming environment for their audience. By the end of the course, participants will be equipped with the skills to deliver presentations that are not only informative but also captivating and memorable. Course Description Throughout this course, learners will explore the essential principles behind effective presentation techniques. The content includes creating a sense of security for the audience, fostering a positive atmosphere, and using humour to enhance engagement. Learners will also delve into methods of connecting with different audience types, ensuring their message is both clear and compelling. The course will include modules that focus on both verbal and non-verbal communication, giving learners the ability to present confidently in any setting. By the end of this course, participants will be prepared to present with impact, regardless of their experience level. Presentation Skills Curriculum Module 01: Introduction to Archetype Module 02: Make Your Audience Feel Safe Module 03: Make Your Audience Feel Good Module 04: Make Your Audience Laugh Module 05: Course Wrap Up (See full curriculum) Who is this course for? Individuals seeking to improve their public speaking skills. Professionals aiming to enhance their communication and presentation abilities. Beginners with an interest in presentation techniques. Anyone looking to build confidence when presenting to groups. Career Path Public Speaking Coach Corporate Trainer Event Speaker Communications Specialist Marketing and Sales Presentations
Vectorworks Evening Course face to face One to one
Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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. Tailored in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements Microsoft Office 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 Career path Career path Microsoft Office 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
Autocad face to face training customised and bespoke Online or Face to Face
Why AutoCAD Mac Basics-Advanced Training Course? Click here for more info Learn 2D drawing, Plans, Sections, Elevations and advanced features. Choose in-person or live online sessions. Certified tutors, practical exercises, and career advice. Access recorded lessons and lifetime email support. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD for Mac Essentials to Advanced Training Course: Learn AutoCAD for Mac and master its popular functionalities, tailored for Mac users. Course Highlights: Thorough grounding for beginners in using AutoCAD for Mac. Develop the skills to create precise and high-quality 2D layouts and designs. Generic drawing techniques applicable to all industries. In-class or live online options available. Ideal for newcomers to AutoCAD for Mac, self-taught users, and those transitioning from other CAD tools. Autodesk Certified Tutors: Autocad Mac 1-2-1 training courses. Expert trainers with extensive experience in AutoCAD and various CAD applications. Hands-On Learning: Practical and hands-on training with demonstrations and step-by-step techniques. Support and Prerequisites: Lifetime post-course email support. Good working knowledge of the Mac OS required, no prior CAD experience needed. AutoCAD Mac Course Content: Fundamental Drawing:Creating Basic ObjectsWorking with LinesWorking with ArcsHandling Polylines Object Manipulation Techniques:Utilizing GripsMastering Object SnapsTracking Object Snap PointsEmploying Polar Tracking File Management:Saving Your WorkAuto-backupsUnderstanding Different File Formats (DXF, etc.)Disaster Recovery Accurate Object Creation:Working with UnitsUtilizing Dynamic InputUsing Inquiry Commands for Measurements Object Viewing and Navigation:Zooming TechniquesPanning Techniques Object Manipulation:Selecting Objects in the DrawingNoun/Verb SelectionQuick SelectMoving, Copying, Rotating, Mirroring, and Arraying ObjectsScaling, Trimming, and Extending Objects Organizing Drawings:Managing LayersChanging Object PropertiesExploring the Properties PaletteUsing Different Linetypes Layouts and Annotations:Working with Layouts and Page SetupsScaling Drawing ViewsAnnotating the Drawing with Text and DimensionsCreating MultileadersApplying Hatching to Objects Reusable Content:Creating and Inserting Blocks and SymbolsUsing Tool PalettesWorking with Groups Paper Space and Model Space: Understanding Model Space and Paper Space Creating Layouts and Managing Viewports Setting Viewport Scales Plotting and Output: Plotting Drawings Generating PDF Output Handling Multiple Sheet Drawings Using Plotstyles Drawing Templates and AutoCAD Tools: Creating Drawing Templates Exploring AutoCAD Toolsets Advance Plans, Sections, Elevations and Construction detailing. This course provides comprehensive instruction in AutoCAD, equipping participants with essential skills to create and manage drawings effectively for various design projects.
Ladder Safety Course Overview This course on "Ladder Safety" provides learners with essential knowledge and skills to ensure the safe use of ladders in various environments. It covers critical topics such as ladder classifications, risk assessments, pre-use safety checks, and the correct procedures for setting up and using ladders safely. Designed for both beginners and those looking to refresh their knowledge, the course aims to reduce the risks associated with ladder usage and promote safety in the workplace. By the end of the course, learners will be equipped to identify potential hazards, conduct safety inspections, and implement effective safety measures when using ladders. Course Description The "Ladder Safety" course explores key aspects of ladder use, focusing on ensuring safety in various work environments. Learners will delve into ladder classifications, pre-use safety inspections, and risk assessments to identify hazards. The course covers setting up ladders correctly, ensuring proper placement, and securing them to prevent accidents. Throughout the course, learners will gain an understanding of safe ladder usage techniques and the importance of conducting thorough risk assessments. The course provides an engaging learning experience that equips participants with the knowledge to make informed decisions about ladder safety and compliance with workplace regulations. Ladder Safety Curriculum Module 01: Introduction to Ladder Safety Module 02: Ladder Classifications and Uses Module 03: Pre-use Safety Inspections and Risk Assessment Module 04: Setting Up and Safe Use of Ladders Module 05: Placement Considerations and Securing a Ladder (See full curriculum) Who is this course for? Individuals seeking to enhance workplace safety Professionals aiming to improve their knowledge of health and safety regulations Beginners with an interest in workplace safety and risk management Anyone working in environments where ladder use is required Career Path Health and Safety Officer Construction Site Manager Facilities Management Professional Risk Assessment Specialist Safety Trainer in Various Industries
Martial Arts First Aid Course Course Overview The Martial Arts First Aid Course provides essential knowledge and skills to manage medical situations in martial arts environments. It equips learners with the necessary tools to assess and respond to both minor and major injuries effectively. The course is designed for anyone involved in martial arts, from instructors to enthusiasts, ensuring they can provide first aid with confidence and accuracy. Learners will gain an understanding of emergency procedures, common injuries, and the best approaches to safeguarding participants in martial arts settings. Course Description This course covers a range of crucial first aid topics, including the proper methods for initial assessment, CPR, managing common injuries, and handling major medical emergencies. Learners will gain a comprehensive understanding of martial arts-related injuries and how to manage them, from bruises and sprains to life-threatening conditions. The course also focuses on injury prevention strategies and the precautions needed to ensure safety during training. By completing this course, learners will be well-equipped to respond to emergency situations in a martial arts environment, supporting both immediate care and long-term recovery. Martial Arts First Aid Course Curriculum Module 01: Introduction to Martial Arts First Aid Module 02: Initial Assessment Module 03: CPR & Recovery Position Module 04: Common Injuries Module 05: Major Injuries Module 06: Medical Emergencies Module 07: Injury Prevention Module 08: Things to Keep in Mind (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of first aid in martial arts. Professionals aiming to improve safety measures in martial arts training. Beginners with an interest in martial arts and emergency response. Coaches and instructors wishing to ensure a safer environment for their students. Career Path Martial Arts Instructor First Aid Trainer Sports Therapist Safety Coordinator in Sports Emergency Medical Responder