380 Courses

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 course Tailored training courses: in in company training, 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 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 course Tailored training courses: in in company training, 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 Visualisations, 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

Our Sponsor Licence Compliance Training will give you all the tools and knowledge you need to ensure your company remains compliant when hiring foreign workers. View our HR Sponsor Licence and Compliance training course dates below, delivered via Microsoft Teams. Course Overview:   Our HR Sponsor Licence and Compliance Training Course is designed to equip HR professionals, managers, and directors with the essential tools and knowledge to ensure their companies remain compliant when hiring foreign workers. In today’s ever-changing landscape of hiring foreign workers, it is crucial to have a solid understanding of the necessary processes and regulations to avoid penalties and maintain a valid Sponsor Licence. Our comprehensive training course has been meticulously crafted to inform, advise, and train companies on maintaining compliance when employing foreign workers. With the Home Office increasing its scrutiny and penalising companies without proper processes in place, it is essential to stay ahead of the game. Non-compliance can have severe consequences, including the suspension or revocation of your licence, which not only affects your company’s operations but also impacts the workers you sponsor. It is paramount to ensure that your company adheres to all the necessary regulations and requirements. This comprehensive course is your one-stop shop for Sponsor Management and Compliance Training. Don’t forget to check out our Home Office Audit Training Course which is designed to train HR professionals, employers and businesses with the knowledge and skills to excel during audit visits and follows on directly from our HR Sponsor Licence and Compliance course.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why choose IAS' Immigration Training Courses? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. The Home Office is penalising more companies than ever for not having the correct processes in place when sponsoring workers. Being non-compliant can lead to your licence being suspended or revoked, which can have serious consequences for the company and workers. This training course is not to be missed by HR Management/Directors.   How is this course structured? Our “Sponsor Licence – HR, Compliance & Right to Work Training” course will include; An overview of Sponsor Licences & The Skilled Worker Visa. How to perform correct Right to Work checks HR processes you need to have in place Sponsor Management System (SMS) Assigning of Key Roles Updating information Renewal of your licence Q&A   Join over 92% of satisfied customers who found their training with IAS useful and beneficial to their role. You will also be provided with training material to keep after completing the course.

Training duration: 10 hrs. Click here for more info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Learn Arnold for 3ds Max and make breath-taking renders with our comprehensive training course. Led by certified tutors and industry experts, you'll master the basics to advanced techniques of creating stunning visual effects and lifelike renderings. Course Duration: 10 hours Course Outline: Session 1: Introduction to Arnold Renderer (1 hour) Unveiling Arnold Renderer's features and capabilities Understanding the benefits of Arnold in 3ds Max Setting up Arnold renderer and exploring its interface Mastering the workflow for exceptional results Session 2: Basic Arnold Shading (1 hour) Navigating the Arnold shading network Creating essential materials with Arnold shaders Working with diverse shader types (standard, Lambert, etc.) Elevating visuals with maps and textures in Arnold's materials Session 3: Arnold Lighting Techniques (1.5 hours) Embracing the art of lighting with Arnold Lights Implementing various light types (area lights, spotlights, etc.) Creating ambiance with Arnold skydome and environment lighting Illuminating scenes using physical sky and image-based lighting Session 4: Arnold Cameras and Rendering Settings (1.5 hours) Mastering Arnold cameras and their settings Achieving depth of field and motion blur effects in Arnold Configuring optimal rendering settings for superior results Fine-tuning rendering with the Arnold Render Setup dialog Session 5: Advanced Arnold Shading (1.5 hours) Creating intricate materials with advanced Arnold shaders Realistic surfaces with Arnold's procedural textures Harnessing the power of advanced shading nodes (bump, displacement, etc.) Unleashing specialized effects with Arnold shaders (subsurface scattering, hair, etc.) Session 6: Arnold Rendering Optimization (1 hour) Streamlining rendering settings for enhanced efficiency Leveraging Arnold features like adaptive sampling and denoising Noise reduction techniques for smoother Arnold renders Troubleshooting common rendering issues and their solutions Session 7: Advanced Lighting Techniques (1 hour) Crafting lifelike lighting setups with Arnold's prowess Exploring advanced lighting properties (exposure, color temperature, etc.) Enhancing lighting with Arnold light filters and modifiers Implementing captivating effects like volumetric lighting and caustics Session 8: Arnold AOVs and Compositing (1 hour) Understanding Arnold AOVs (Arbitrary Output Variables) Configuring and rendering AOVs for post-production control Compositing AOVs for artistic adjustments in post-production Leveraging AOVs for fine-tuning the final image Session 9: Arnold for Animation and Motion Graphics (1 hour) Integrating Arnold seamlessly into animation and motion graphics projects Rendering animation sequences with finesse Managing motion blur and time-based effects with Arnold Unveiling Arnold's potential for particle rendering and dynamic effects Session 10: Arnold Tips, Tricks, and Best Practices (1 hour) Exploring advanced techniques and workflows for exceptional results Optimizing scene setup for enhanced rendering performance Troubleshooting tips for common issues and errors in Arnold Q&A session and final review to consolidate knowledge

Revit face to face training customised and bespoke.

Why learn Vectorworks Basics to Intermediate Training Course? Course Link Vectorworks skills with our course! Led by certified expert tutors, this course takes you from basics to intermediate level, enabling you to create plans and sections. The course will cover 2D and 3D modeling, rendering, and visualization.  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. At London Design Training Course, we offer a range of Vectorworks training options to meet your specific needs and those of your business. Explore the links below for detailed information about the various training types and their content. On-Site Training: London Design Training Course comes to your location, eliminating the need for you to travel. This approach allows us to fully understand your business culture and requirements. Training can be conducted in your studio or conference room, with scheduling flexibility tailored to your preferences. In-House Training: Our studio in London SW96DE, hosts In-House Vectorworks training for both individuals and groups. During the sessions, we provide the necessary software and hardware to ensure a seamless learning experience. Vectorworks Basic to Intermediate Course Course Duration: 16 hours The Vectorworks Basic to Intermediate Course is tailored for individuals with basic Vectorworks knowledge, aiming to master advanced 2D and 3D techniques, including modeling and rendering. Participants will customize Vectorworks to their needs, create custom tools, and automate tasks with scripting. I. Review of Basic Concepts (1 hour) - Vectorworks interface and navigation - Creating and editing 2D and 3D geometry - Working with layers and classes - Utilizing views and viewports II. Advanced 2D Drawing Techniques (2 hours) - Creating complex geometry using advanced drawing tools - Editing and modifying intricate geometry - Customizing line types and hatches - Utilizing advanced annotation tools III. Advanced 3D Modeling (3 hours) - Creating 3D forms and custom 3D objects - Exploring advanced 3D tools such as Solid Modeling - Converting 2D plans into 3D models IV. Visualization and Rendering (3 hours) - Setting up cameras and lights for visualization purposes - Utilizing the Renderworks engine for rendering - Enhancing visuals with the visualization palette - Creating and editing textures and materials V. Customizing Vectorworks (3 hours) - Personalizing the interface to suit specific preferences - Creating custom tools and automating tasks using the scripting language - Developing custom object styles and resources - Creating custom plug-ins and scripts VI. Collaboration and Sharing (2 hours) - Importing and exporting data from other software - Collaborating with others on the same project - Utilizing cloud-based collaboration tools VII. Conclusion and Next Steps (1 hour) - Review of course content and key skills learned - Tips for further learning and available resources - Q&A and feedback session Free 30-day, BIM & CAD Software Trial Request | Vectorworks https://www.vectorworks.net/trial Vectorworks Trial Version Request. Please fill out the following form. We will provide you with an evaluation serial number to activate your trial copy. Learning Outcomes of the Vectorworks Basics to Intermediate Training Course: Proficiency in Vectorworks interface, tools, and navigation. Master 2D drafting and 3D modeling skills. Efficiently manage workflows using layers, classes, and views. Spotlighting techniques for lighting design and stage productions. Advanced object manipulation with solid modeling and Boolean operations. Utilize the symbol library for enhanced productivity. Create professional presentation drawings using viewports and annotations. Integrate with other software and CAD/BIM workflows. Apply skills to real-world projects for practical application. Upon completing the course, participants will have essential skills to effectively use Vectorworks, advancing their proficiency to an intermediate level.

Who is this course for? Enscape Rendering Training Course. The Enscape Rendering Training Course is tailored for architects, interior designers, and design students aiming to learn realistic visualizations using Enscape. Whether you prefer 1-on-1 in-person or online courses, this training is best for you. Click here for more info: Website Training duration: 5 hrs Method: 1-on-1 and Tailored content Schedule: Customize your training. Choose any hour from Mon to Sat, 9 am to 7 pm Call 02077202581 or WhatsApp at 07970325184 to book. Course Outline: Enscape Rendering Software Training (5 hours) Course 1: Enscape for Revit Hour 1: 1. Introduction to Enscape: Overview of Enscape rendering software, its features, and benefits. 2. Installing and Setting up Enscape: Step-by-step guidance on installing and configuring Enscape for Revit. 3. Enscape Interface: Familiarizing with the Enscape user interface and navigation controls within Revit. Hour 2: 4. Enscape Materials: Exploring material creation, application, and customization within Enscape for Revit. 5. Lighting in Enscape: Understanding different lighting options, adjusting light settings, and creating realistic lighting effects. Hour 3: 6. Enscape Camera Settings: Manipulating camera angles, perspectives, and settings for optimal visualization. 7. Enscape Rendering Settings: Exploring various rendering settings and techniques to enhance the quality of the final output. Hour 4: 8. Enscape Rendering Workflow: Demonstrating a step-by-step workflow for generating renderings and walkthroughs using Enscape in Revit. 9. Advanced Features: Introduction to advanced features such as creating panoramas, virtual reality (VR) walkthroughs, and creating animations in Enscape. Hour 5: 10. Tips and Tricks: Sharing tips and techniques for maximizing efficiency and achieving high-quality results in Enscape for Revit. 11. Q&A and Troubleshooting: Addressing participant questions, providing troubleshooting guidance, and discussing common challenges and solutions. OR Course Outline: Enscape Rendering Software Training (5 hours) Course 1: Enscape for Sketchup Hour 1: 1. Introduction to Enscape: Overview of Enscape rendering software, its features, and benefits for SketchUp users. 2. Installing and Setting up Enscape: Step-by-step guidance on installing and configuring Enscape for SketchUp. 3. Enscape Interface: Familiarizing with the Enscape user interface and navigation controls within SketchUp. Hour 2: 4. Enscape Materials: Exploring material creation, application, and customization within Enscape for SketchUp. 5. Lighting in Enscape: Understanding different lighting options, adjusting light settings, and creating realistic lighting effects. Hour 3: 6. Enscape Camera Settings: Manipulating camera angles, perspectives, and settings for optimal visualization in SketchUp. 7. Enscape Rendering Settings: Exploring various rendering settings and techniques to enhance the quality of the final output. Hour 4: 8. Enscape Rendering Workflow: Demonstrating a step-by-step workflow for generating renderings and walkthroughs using Enscape in SketchUp. 9. Advanced Features: Introduction to advanced features such as creating panoramas, virtual reality (VR) walkthroughs, and creating animations in Enscape. Hour 5: 10. Tips and Tricks: Sharing tips and techniques for maximizing efficiency and achieving high-quality results in Enscape for SketchUp. 11. Q&A and Troubleshooting: Addressing participant questions, providing troubleshooting guidance, and discussing common challenges and solutions. Learning Outcome: After completing the Enscape (VR) Training and Interactive Workshop, participants will master real-time walkthroughs, set up VR applications, efficiently migrate models, navigate designs dynamically, update objects in real-time, control visual styles, adjust day-time settings, export and share designs, utilize the asset library, and gain a comprehensive overview of Enscape. These skills will enable them to confidently visualize and display 3D designs without cloud uploads or external software, enhancing communication and collaboration in architectural projects. What does the Enscape Training & Interactive Workshop offer? The Enscape Training & Interactive Workshop is designed to help you get up and running with Virtual Reality (VR) in a cost-effective manner. It covers hardware and software setup, navigation techniques, real-time updates, material settings, and more. The workshop also allows participants to experience VR firsthand. What are the benefits of attending the Enscape (VR) Training and Interactive Workshop? By attending this workshop, you will gain the ability to perform real-time walkthroughs of your designs in 3D. You can view your projects in VR without the need for cloud uploads or exporting to other 3D software. The workshop offers extensive asset libraries, collaboration, and annotation sharing, enhancing your design visualization capabilities. What are the prerequisites for attending the Enscape (VR) Training and Interactive Workshop? No prior knowledge of Enscape is required. However, assistance from IT management may be necessary for hardware and software installation. Logistics, such as room suitability and technical requirements, will be discussed before the workshop. What will I learn in the Enscape (VR) Training and Interactive Workshop? The workshop covers hardware setup, software installation, and configuration. You will learn how to migrate models from Revit and SketchUp into VR, navigate through designs, update objects and materials in real-time, and utilize various visual styles and settings. The course also includes interactive workshops with support from our expert tutors. Enscape rendering courses offer valuable benefits: Real-time Visualization: Instantly visualize designs for quick iterations and informed decisions. Seamless Integration: Streamline rendering by integrating with popular design software. High-Quality Visuals: Create photorealistic presentations and walkthroughs. Efficient Design Communication: Enhance collaboration and communication during presentations. Enhanced Design Iteration: Explore options and make informed decisions in real-time. Time and Cost Savings: Reduce rendering time and deliver projects more efficiently. Portfolio Enhancement: Elevate your portfolio with visually striking renderings, opening new opportunities.

Why Learn SketchUp Evening Training Course? You will learn how to create and edit 3D models to a professional standard, ensuring you leave with the skills and confidence to fully take advantage of SketchUp and Layout software. You can book this course after work we are open 9 am to 7 pm. Course info Duration: 10 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. SketchUp Evening Training Course Course Duration: 10 hours I. Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Familiarization with the user interface and essential tools - Mastering navigation and viewport controls - Efficiently creating and managing interior design and architectural projects II. Creating Floor Plans (1 hour) - Importing floor plans and site plans for reference - Precision in drawing walls, windows, and doors - Effective management of floor levels - Organizing designs using Layers and Scenes III. Adding Furniture and Fixtures (2 hours) - Accessing and importing furniture and fixtures from the extensive 3D Warehouse - Crafting custom furniture and fixtures to suit specific design needs - Strategically placing and arranging elements within the space - Crafting and customizing materials to achieve the desired visual impact IV. Advanced Modeling Techniques (2 hours) - Employing advanced tools for creating intricate 3D models - Enhancing model organization using groups and components - Adding exquisite details and finishes to elevate design quality V. Layout for Construction Documents (2 hours) - Creating construction documents in Layout for clear communication - Seamlessly importing SketchUp models into Layout - Crafting detailed floor plans, elevations, and sections - Adding annotations and dimensions to facilitate construction VI. Introduction to Vray (1 hour) - Understanding the capabilities of Vray for SketchUp - Familiarization with the basic Vray interface and tools - Exploring Vray materials and textures for enhanced rendering VII. Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to elevate SketchUp models - Creating artificial and natural lighting for realistic visualizations - Enhancing designs with entourage and landscaping elements VIII. Importing and Exporting (30 minutes) - Seamlessly importing and exporting files for versatile workflows - Ensuring file format compatibility with other software - Preparing models for 3D printing as required IX. Conclusion and Next Steps (30 minutes) - Comprehensive review of course content and key takeaways - Suggested further learning resources and avenues for improvement - Interactive Q&A session and feedback collection Download SketchUp | Free Trial of 3D Modeling Software SketchUp https://www.sketchup.com SketchUp's Intuitive Interface Helps You Communicate Ideas In 3D Fast. Subscribe Today!

Half day rally navigator training workshop scheduled to be ideal for crews doing the 2025 Tour of Cheshire Historic Road Rally but open to all.

Online gluten-free sourdough class for complete beginners.