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.
Career Development and Passion Course Overview This course is designed to help individuals navigate their career development while staying true to their passions. It covers key aspects of career growth, self-improvement, and the strategic pursuit of personal interests to build a fulfilling professional life. Learners will explore how to harness their passion to fuel career success, develop essential skills, and adopt a positive mindset for achieving long-term professional goals. Upon completion, learners will be equipped to enhance their career trajectory, align their passion with their work, and achieve greater job satisfaction. Course Description In this course, learners will delve into various stages of career development, focusing on self-improvement, identifying and chasing one's passion, and mastering the mindset required for success. Topics such as aligning passion with career choices, improving skills, and navigating job hunting will be covered in-depth. Learners will gain insights into how passion can be a driving force behind career success and how to monetise skills and interests effectively. By mastering these topics, participants will be well-prepared to achieve personal and professional fulfilment in their chosen career path. Career Development and Passion Curriculum Module 01: Career Module 02: Self-Improvement Module 03: Passion Module 04: Chase the Passion Module 05: Be Good at Your Passion Module 06: Passion and Money Module 07: Master Your Mindset Module 08: Preparation for Success Module 09: Job Hunting Module 10: Acing Your Interview Module 11: Prosper in Career (See full curriculum) Who is this course for? Individuals seeking to align their career with their passion. Professionals aiming to enhance career growth and job satisfaction. Beginners with an interest in career development and personal growth. Anyone looking to improve their job hunting and interview skills. Career Path Career development coach HR specialist Business consultant Entrepreneur in passion-driven industries Motivational speaker or trainer Corporate strategist Freelance professional
Ace Your Presentations: Public Speaking Masterclass Course Overview In the "Ace Your Presentations: Public Speaking Masterclass," learners will acquire essential skills to enhance their public speaking and presentation abilities. The course covers techniques for confident delivery, structuring engaging presentations, handling stage fright, and communicating effectively with diverse audiences. By the end, learners will have the tools to captivate any audience, whether in a business meeting, conference, or seminar. This course offers practical value for anyone seeking to improve their speaking abilities, with tangible benefits in personal confidence and professional success. Course Description This comprehensive course dives into various aspects of public speaking, including speech structure, voice modulation, body language, and audience engagement. It explores techniques for managing nerves, maintaining focus, and delivering persuasive presentations. Learners will also gain valuable insights into creating compelling visual aids and handling questions with ease. With a focus on clear, effective communication, this course equips participants with the skills needed to influence, inspire, and inform any audience, setting the stage for career advancement and personal growth. Ace Your Presentations: Public Speaking Masterclass Curriculum Module 01: Introduction to Public Speaking Module 02: Building Confidence and Overcoming Nervousness Module 03: Structuring Your Presentation Module 04: Mastering Body Language and Voice Modulation Module 05: Engaging Your Audience and Handling Questions Module 06: Creating Effective Visual Aids and Supporting Materials Module 07: Final Project: Delivering Your Own Presentation (See full curriculum) Who is this course for? Individuals seeking to boost their public speaking confidence Professionals aiming to enhance their communication skills Beginners with an interest in becoming effective presenters Anyone looking to refine their speaking abilities for career advancement Career Path Public Speaker Corporate Trainer Marketing and Sales Professional Event Speaker Communication Consultant