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
This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.
Exclusive to AutoCAD subscribers, the AutoCAD Electrical toolset simplifies electrical system creation. Click here for more info: Website Our course provides a strong foundation in 2D electrical design, covering essential tools. Flexible one-on-one sessions from 9 a.m. to 7 p.m., Monday to Saturday. Call 02077202581 or book online. The 16-hour course offers flexibility, divide hours across days. Benefit from individualized attention and tailored content. Enroll for in-person or Zoom sessions to excel in AutoCAD Electrical. AutoCAD Electrical Course Content: Introduction to AutoCAD Electrical Software: Overview and features of AutoCAD Electrical Understanding the software interface and tools Project file structure and management Layout and Navigation: Navigating the AutoCAD Electrical workspace Creating new project files and using attribute editors Understanding WDD, WDX, and WDF project files Exploring the Project Manager interface and attribute editors Electrical Diagram Drawing: Numbering and titling wires in diagrams Labelling components Utilizing diagram symbol libraries Creating and editing Electrical Control Circuits (ECC) Component dialog box and Circuit Scale dialog box Introduction to Programmable Logic Controllers (PLCs) and Integrated Systems: PLC Symbols and Concepts Inserting Programmable Logic Controllers (PLCs) into diagrams Adding PLC Units to diagrams Working with PLC Input and Output points and circuits Understanding PLC-based classification Using the Spreadsheet to PLC Input and Output Points utility Custom and Bespoke Symbols: Creating custom symbols for Switches, Wires, Contactors, Motors, Transformers, etc. Specifying symbol conventions and standards Offline and online usage of AutoCAD Electrical databases Drawing for Terminals and Plans: Implementing Terminal symbols in diagrams Handling terminal plans and locations Working with compound level terminals and locations Utilizing the Component command for single and multiple components Managing Jumpers and wiring Modifying Terminal Strips and Dual In-Line Packages (DIP) Understanding DIN Rail, Electrical Enclosure, Circuit Breakers, and Electrical Equipment Generating PDFs and Reports: Exporting drawings to PDF format Organizing report templates Automating the generation of reports Creating Electrical Audit Reports This AutoCAD Electrical course provides comprehensive knowledge of the software, focusing on electrical diagram drawing, symbol creation, PLC integration, terminal planning, and report generation. Participants will gain the skills needed to efficiently design electrical systems using AutoCAD Electrical software. Upon completion, participants will proficiently use AutoCAD Electrical to create precise electrical diagrams, integrate PLCs, design custom symbols, plan terminals, and generate reports efficiently. They will possess the skills needed to confidently design electrical systems and enhance their expertise in electrical design and drawing. AutoCAD Electrical Training Course: Master precision in specialized electrical design skills. Optimize your design process with streamlined workflows. Ensure compliance with industry standards consistently. Boost productivity in electrical design tasks. Facilitate seamless collaboration with fellow professionals. Benefit from recorded lessons for convenient review. Enjoy continuous support with lifetime email assistance. Unleash the complete power of AutoCAD for your electrical design needs. Enroll today and craft precise, professional electrical drawings confidently. Select between in-person and live online sessions to suit your preference. Flexible Evening Sessions: Learn AutoCAD at your own pace with evening sessions designed for busy individuals. Boost your career opportunities in computer-aided design. Comprehensive Skill Development: Gain a strong foundation in AutoCAD's core features and advance to 3D modeling and rendering techniques, enhancing your design capabilities. Industry-Standard Knowledge: Become proficient in AutoCAD, a widely used CAD software in architecture, engineering, and construction fields, making you highly sought after by employers. Practical Application: Apply AutoCAD skills to real-world design scenarios, creating detailed plans for professional projects in architecture, engineering, and mechanical fields. Recorded Lessons for Review: Access lesson recordings to reinforce learning and review specific topics or techniques whenever needed. Lifetime Email Support: Enjoy ongoing support with lifetime email assistance, even after completing the course, for guidance and clarification.
Who is this course for? AutoCAD 2D Basics to Advanced Course. Click here for more info: Website This course enables you to learn the skills in the CAD. Upon completion, you'll proficiently edit and create 2D drawings, utilizing advanced features like Paperspace and Block Attributes for increased efficiency. 1-on-1 sessions. Our booking are available Mon to Sat, 9 am to 7 pm Duration: 16 hours, which you can flexibly distribute across as many days you want. Approach: In-person or live online training. AutoCAD Basics to Advanced Level Training Course Outline. Fundamental Concepts: Introduction to AutoCAD interface, commands, and tools. Managing drawings and creating basic shapes. Basic modification techniques like erase, move, rotate, and scale. Intermediate Techniques: Working with layers and adjusting properties. Creating and modifying text and dimensions. Introduction to blocks and attributes. Advanced Topics: Advanced object modification techniques such as fillet, chamfer, trim, and extend. Utilizing grips for object manipulation. Creating and editing polylines and splines. Course Highlights: Engaging exercises and projects for skill reinforcement. Access to Q&A and troubleshooting support. Proficiency in AutoCAD 2D for basic to intermediate drawings. Topics Covered: Drawing techniques encompassing various shapes. Inquiry tools for measurement and selection. Modification commands for object manipulation. Layer management and attributes. Annotation and dimensioning. Hatching objects and working with reusable content. Layouts and viewports for better organization. Annotating drawings effectively. Polylines, splines, ellipses, and tables. Plotting drawings and creating templates. Multi-lines, revision clouds, and wipeout objects. Working with point objects and calculations. Creating and managing templates. Annotation scaling and text manipulation. Dimensioning and geometric annotations. Dynamic blocks and attributes. Layer management best practices. Introduction to sheet sets and their properties. Utilizing fields and attributes in sheet sets. Working with tables, table styles, and advanced tables. Exporting and importing tables. Creating tables linked to external data. Download AutoCAD Software https://www.autodesk.co.uk What Will I Gain from this Course? Throughout this course, you will develop expertise in the following areas: CAD layering techniques Text and dimension style manipulation Proficiency in creating and editing 2D drawings Mastery of attributed block creation and editing Efficient utilization of Paperspace Dynamic input and grips utilization This comprehensive training program not only provides you with an advanced comprehension of 2D drawing in AutoCAD but also offers a fundamental introduction to 3D drawing concepts. Upon completion of this course, you will possess the skills to: Swiftly generate schematics, parts, and assemblies Enhance efficiency by reusing content and customizing tool palettes Save time through the use of dynamic blocks, which can be edited in place Gain full control over your viewports and layouts Is This Course Right for Me? This advanced AutoCAD 2D training assumes that you are already a proficient AutoCAD user. We recommend prior attendance of our Introduction and/or Intermediate AutoCAD 2D training courses or practical experience in the topics covered in those courses. If you have any doubts about the suitability of this course for your skill level, please feel free to contact us, and we will be happy to assist you. In this course, you will gain proficiency in utilizing essential features of AutoCAD (Computer Aided Design) to enhance the efficiency of producing and editing 2D CAD drawings. You will acquire expertise in layering, text and dimension styles, the creation and modification of attributed blocks, and effective use of Paperspace. Additionally, you will master dynamic inputs, grips, and the art of renaming and purging. This flexible course grants you 16 hours to complete, typically spanning 4 to 5 days. It serves as a valuable continuation of skills acquired from the CAD: AutoCAD 2D Essentials course or as an opportunity to expand your existing AutoCAD knowledge. Upon course completion, you will possess the ability to efficiently create and modify 2D drawings, leveraging advanced features like Paperspace and Block Attributes. Your instruction will be provided by an Autodesk-certified instructor with industry experience." 1. All-encompassing course designed to accommodate both novices and advanced users. 2. Addresses essential functions and advanced methodologies in AutoCAD. 3. Enhances proficiency in creating precise and professional 2D drawings. Interactive instruction guided by seasoned educators. Benefit from on-demand access to lesson recordings for convenient revision. Receive ongoing support through lifetime email and phone assistance. Post-course Assistance: Enjoy continuous support via lifetime email and phone assistance. Should you encounter any challenges or queries after the course, we are readily available to address your concerns via email or phone calls."
Why Choose AutoCAD Architecture 1 on 1 Course? Our courses for AutoCAD and AutoCAD Architecture. AutoCAD conveys design intent through Lines and Circles, AutoCAD Architecture enhances these elements with walls, doors, windows and AEC. Click here for more info: Website When Can I Reserve My Spot? 1 on 1 training and available from Monday to Saturday, 9 am to 7 pm Duration: 16 hours, which you can flexibly book. Training Method: 1-on-1, in-person face-to-face or live online training. AutoCAD Architecture 3D Course Overview: AutoCAD Architecture Introduction Distinguishing AutoCAD Architecture from AutoCAD LT Exploring the User Interface and 3D Viewing Wall Construction and Customization: Adding Walls to the Model Creating Specialized Curtain Walls Modifying Walls for Specific Needs Joining Walls for Complex Structures Incorporating Wall Openings for Doors and Windows Ceiling Plans (Reflected): Establishing Ceiling Grids and Construction Details Customizing Ceiling Grids for Design Consistency Inserting Ceiling Fixtures and Detailed Construction Structural Design and Analysis: Utilizing Structural Elements and Online Resources Constructing Column Grids and Annotating Columns Adjusting Column Grids and Annotations Enhancing Clarity with Column Grid Annotations Stairs: Designing and Customizing Stairs Adding Railings and Detailed Construction Refining Railings and Detailed Construction Floors and Slabs: Creating Floor Slabs with Construction Details Aligning Floor Slabs with Design Specifications Editing Slabs Using Slab Tools and Construction Details Roofs and Roof Detailing: Roof Creation for the Building Designing Roof Slabs for Specific Areas Modifying Roofs and Roof Slabs as Needed Precise Roof Detailing with Roof Slab Tools Annotation: Scaling Detail Drawings and Annotations Incorporating Text, Leaders, and Comments Accurate Dimensioning in AutoCAD Architecture Enhancing Clarity with Various Annotation Tools Equipment and Furnishings: Integrating Interior and Exterior Furnishings Incorporating Blocks and 3D Models for Realism Leveraging Tool Palettes and Autodesk Seek Resources Model Views Ready for Printing PDF: Creating Callouts for Specific Views Designing Elevations, Sections, and Construction Details Modifying Callout Objects for Improved Visualization Implementing Live Sections and Elevations Generating Reports and Managing Project Resources Schedules: Adding Door and Window Labels Editing Label Data for Accuracy Creating Schedules for Efficient Project Management Customizing Schedules to Meet Specific Requirements This comprehensive AutoCAD Architecture 3D course equips participants with the skills needed to create intricate 3D architectural models, implement construction details, and efficiently manage project resources. It empowers participants to produce professional-grade architectural designs using AutoCAD Architecture software." Upon completion of the AutoCAD Architecture 1-on-1 Course, participants will demonstrate proficiency in architectural design using the application. They will have mastered essential techniques, gained expertise in drawing management, refined their model visualization skills, and earned an accredited certificate. This tailored learning experience, coupled with post-course support and practical exercises, will significantly boost career prospects in the field. Download Autocad Architecture Training Choices: Personalized in-person or Live online courses. Tailored courses designed to meet your specific knowledge and project needs. Customized Learning: Adapt the course to match your existing skills and project requirements. Certifications: Instructors certified by Autodesk. AutoCAD Architecture training Certificate of Attendance. Expert Guidance: Learn from Autodesk Certified Instructors with extensive professional experience. Interactive Learning: Engage in practical, hands-on training. Follow step-by-step demonstrations and practice in real-time. Keep your course-created files for future reference. Comprehensive Resources: Receive a detailed training guide for ongoing reference. Earn an e-certificate upon successful course completion. Post-Course Assistance: Access lifetime email support from your instructor. Prerequisites: Basic familiarity with standard AutoCAD or equivalent knowledge. Version Versatility: Training available for any AutoCAD Architecture version to suit your requirements." Thorough Learning Experience: Establish a robust 3ds Max foundation and master vital skills for crafting impressive 3D models and visualizations. Customized Instruction: Benefit from one-on-one guidance provided by seasoned instructors, ensuring focused and tailored learning. Flexible Learning Paths: Select between in-person or live online sessions, granting you the flexibility to learn from any location. Lesson Recordings: Gain access to recorded lessons for future reference, facilitating self-paced review of course content. Ongoing Email Assistance: Access continuous email support from our experts to address any queries or seek clarifications. Complimentary Career Guidance: Receive valuable career advice from industry professionals, assisting you in charting a successful course in the realm of 3D modeling and visualization."
Immerse Medical are experienced at teaching first aid to young people within the educational sector. We have designed this workshop style programme specifically for those in KS3/4. The sessions are fun, engaging and focus on fundamental life saving skills. Using interactive gamification, students gain hands on experience, which they will draw upon in real life medical emergencies. These sessions are perfect as part of phase 2 of National Citizenship Service (NCS) and Duke of Edinburgh (DofE) Awards. Key points Meets national curriculum secondary education guidelines– We’ve designed this programme to exceed the requirements of the 2020 guidelines. Training by doctors, nurses and paramedics – We have years of experience working on the front line of emergency medicine; giving us real world knowledge and skills in managing injured or unwell people. Latest equipment & technology – We utilise technology enhanced learning to provide a realistic opportunity to practice fundamental life saving skills in a safe environment. More than first aid – While participating in this workshop young people will also develop their ability to work as part of team, communicate effectively and think critically in high pressure situations leading to an overall increase in personal confidence. Check out the skills included in the videos below. First Aid Courses For Young People Programmes and sessions for young people focusing on how to keep each other safe and what to do if something goes wrong. Sessions are designed with age and national curriculum in mind, from 1 hour tasters to sessions for large groups, perfect as part of NCS and Duke of Edinburgh programmes. Our training for young people is fun, engaging and focuses on fundamental life saving skills. All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.
Overview This one day course is designed for anyone that deals with telephone sales in either an inbound or outbound call environment. Description The telephone has become a critical tool in obtaining sales in today’s competitive market, and yet it is often an area we pay little attention to, and consequently it becomes a negative aspect of our business rather than the highly positive one it can be. This course sets out to enable the attendees to sell effectively over the phone. The tools that are covered will help generate sales and whether they take inbound or receive outbound calls they will find that if they apply the techniques in this session, their success rate will increase immensely. Topics covered: Advantages and Disadvantages – A look at how the phone can work for and against us in a sales environment. An Introduction to Selling on the Telephone – Understanding the key points that encourage a customer to purchase from us. Structuring and the Sales Process – Defining a set process for structuring a sales call with a chance to demonstrate understanding. Why People Buy – A look at the reasoning behind people’s purchasing decisions. How People Buy – An insight into the emotional factors behind how people arrive at purchasing decisions. Turning Inbound Calls into Sales – Gauging the level of interest of a caller in order to establish the likelihood of a sale. Making Effective Outbound Calls – A set process of ensuring you gain the best advantage with this type of call. Getting Past the Gatekeeper – Understanding the role of the gatekeeper and developing methods of dealing with them in order to speak to the decision maker. Using scripts and techniques that are proven and effective. Sounds Interesting? – Studying three key communication factors when projecting the voice over the phone. Including a chance to review how the participant’s voice comes across over the phone. Methods of Improving the Way You Sound – 10 key tips on vocal improvement. Telephone Questioning Techniques – Giving the delegates the chance to fully understand the different questioning techniques that can be used during a sales call. Features and Benefits – How to practically apply them in a sales scenario. Logical and Emotional Purchasing – A further look at the reasons we buy. Overcoming Objections – Practical use of a set process and ways to apply it in the workplace. Closing the Sale – Clear methodology with a chance to practice the skills in a fun way. Post-course Assignment – A method of carrying the learning into the workplace and ensure continual review. Who should attend the course? Anyone who handles inbound or outbound sales calls over the telephone. Requirements for Attendance No prerequisites required.
Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.