354 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 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

Bring your poorly sewing machine for some TLC. In this session as part of London Repair week, I will show you how to look after your machine, common issues and how to fix them, and guaranteed you'll go home with a better understanding of how to keep your machine purring. I will talk for an hour and then there's a Q&A/ fixing session for an hour and you'll get to home with a fact sheet and some excellent quality needles (these fix 99% of all issues!). If your machine needs more fixing than can be provided during this session you can leave her, and I will fix her for the discounted rate of £30, effectively taking your ticket price off the repair cost.

Want learn how to use social media to market your business effectively? Join this short course from Let’s Do Marketing to learn how to create your social media strategy for success – and come away with the knowledge, skills and confidence to start connecting with your customers online!

Our Exam Technique Training course for the OISC Level 2 exam is designed as a half day course. Participants can expect to focus on the exam structure, practise mock exam questions and learn how to maximise their marks. View the OISC Level 2 Mock Exam Preparation dates below, available in Manchester, Birmingham or London. OISC Level 2 Mock Exam Preparation The aim of the Exam Technique Training is to provide participants with a strong body of knowledge of the OISC Level 2 exam. This half-day course does not cover the full training involved in the OISC Level 2 syllabus. However, some of the topics covered in the course will be relevant. Topics: Navigating the OISC Exam Resource Book Overview of the Syllabus for the Level 2 OISC Exam Practice mock exam questions Exam tips Q&A The course includes the opportunity to practice a typical question under exam conditions. Following this, there will be time for collective discussion and group feedback. There is a limited capacity of 10 participants on this course so book early to avoid disappointment. The size of the course means that all individuals will have time to ask questions and learn as much as possible about how to prepare for the OISC Level 2 exam. Please note that this is an exam preparation course – not the OISC exam. We provide some of the most comprehensive immigration law training courses across the UK. This course is ideal for anyone who is preparing to take the OISC Level 2 exam. Book this course as a bundle with our OISC Level 2 Caseworker Training Course and save! Call our team today to secure your special offer 0333 414 9244. Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course.   Course joining links, materials and instructions are sent out 24hours before the course starts.

Gin seems unstoppable at the moment with new micro-distilleries opening up seemingly every month, but what exactly is gin? Where was it first made? Which country drinks the most gin and what are the styles of gin available today? Find out everything you need to know about gin during this fascinating two-hour tasting. We'll be taking a look at (and sniffing) a range of the botanicals used in the production of gin, then we'll taste six gins from around the world alongside some of our favourite premium tonic waters.

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. What do you get? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer 6 weeks access to our live coaching program delivered by expert Tableau coaches 50+ practical exercises to practice what you learn 12 months access to video’s that walk you through the theory and exercise solutions Practical advice, tools and resources for using Tableau in the real world The three additional online modules provide:Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs.An agile and iterative development process that delivers products that meet user needs more quickly and effectively.An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU What is possible How does Tableau deal with data Know your way around Review of Type Conversions How do we format charts Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA Connecting to and setting up data in Tableau Modifying data attributes How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) Brainstorm and assess possible priorities Pitfalls to avoid Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing progress over time Creating Tables – Creating Tables, Highlight Tables, Heat Maps Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps Making things dynamic with parameters MODULE 5: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION Table Calculations Sets, Reference Lines, Trends and Forecasting Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files Advanced charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS Using the Dashboard Interface Device layouts Dashboard Actions – Set actions, Parameter actions Viz in Tooltips for Dashboards Dashboard containers – Horizontal & Vertical containers, Hidden containers Navigate between dashboards Telling data driven stories MODULE 8: BRING YOUR OWN DATA Design Best Practices & Resources Wireframe templates Questions Process Start building and testing MODULE 9: EMPOWER STAKEHOLDERS What is Tableau Server Publishing & permissions How can your users engage with content The Tableau ecosystem Review your progress Your next steps HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. We help teams using Tableau to transform in the following ways : From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics From disjointed stakeholder questions – To clear and concise requirements that lead to decision making From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories From using demo data theory – To Delivering value [Answering questions] on their own data From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business

Why Choose Rhino 3D Basic to Intermediate Training Course? Course Link Learn NURBS modeling, curves, and 3D printing prep in our Rhino 3D Course. Master materials, textures, and lighting for 2D & 3D modeling. A basic understanding of Rhino is valuable for creative professionals pursuing careers in product, furniture, architectural, or jewelry design. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. Supported Learning Approach: Personalized Support: No matter the course duration, our team is dedicated to supporting you every step of the way. From homework assignments to video tutorials and free after-support, we ensure a supportive path to software expertise. One to One Course Advantage: The One-to-One Course Advantage offers personalized learning, flexible scheduling, focused feedback, and a private environment to boost confidence and achieve your specific objectives. Rhino 3D Basic to Intermediate Training Course Course Duration: 10 hours Course Description: 3D modeling journey with our Rhino 3D Basic to Intermediate Training Course. Ideal for beginners, master the powerful Rhino 3D software used by architects and designers. Explore the interface, create captivating 3D models, and enhance your designs with comprehensive tools and techniques. Course Outline: I. Introduction to Rhino 3D (1 hour) - Explore the Rhino 3D interface and discover essential tools for 3D modeling - Master seamless navigation and viewport controls - Grasp the significance of units and tolerance for precise creations - Customize your workspace for an efficient and personalized workflow II. Creating Basic 3D Objects (3 hours) - Unleash your creativity by crafting simple yet captivating 3D shapes - Gain expertise in editing objects and working with curves for refinement - Dive into the world of surfaces and solids, refining your skills - Effortlessly use transformations and copying techniques to enhance your designs III. Organizing and Enhancing Models (2 hours) - Streamline your projects with smart organization using groups and layers - Elevate the visual appeal of your models with vibrant colors, materials, and textures - Illuminate your creations with fundamental lighting techniques IV. Advanced Modeling Techniques (2 hours) - Master the art of tackling complex shapes with advanced modeling tools - Explore the nuances of creating and editing curves and surfaces - Enhance your proficiency in handling solids and understand Boolean operations and trimming techniques V. Introduction to Rendering (1 hour) - Gain an overview of rendering and its role in visualizing your designs - Understand Rhino's powerful render engine and its capabilities - Apply basic materials to elevate the quality of your renderings VI. Exporting and Importing (1 hour) - Acquire a comprehensive understanding of file formats for seamless sharing - Prepare your models for 3D printing using best practices - Integrate models from other software into Rhino 3D for a unified workflow VII. Conclusion and Next Steps (30 minutes) - Recapitulate the knowledge gained throughout the course - Access valuable tips and resources for continuous learning and growth - Engage in an interactive Q&A session to receive feedback and support Note: The above course outline is flexible, ensuring it meets the unique needs and skill levels of learners. Download - Rhino

Why choose SketchUp Course for Interior Designers and Architects with Layout and Vray? Introducing SketchUp Training Course tailored for Interior Designers and Architects. This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for rendering. Course info Duration: 10 hrs Method: 1-2-1, Personalized attention Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm Explore the world of 3D drawing with Sketchup in this beginner-friendly course. With its user-friendly interface, Sketchup offers a gentle learning curve, allowing you to quickly grasp 3D geometries. As you become acquainted with the basic drawing tools, you'll uncover a plethora of advanced techniques to create intricate and complex 3D objects. Who Should Take This Course? This course is ideal for individuals seeking to utilize a 3D drawing tool to solve three-dimensional problems or engage in more advanced design endeavors. Our experienced tutors communicate in accessible English, avoiding complex jargon and ensuring clarity throughout the course.  We offer a wealth of learning resources for you to access beyond live lessons. Stay up-to-date, practice, and review key concepts essential to your growth. Course Title: SketchUp Training for Interior Designers and Architects with Layout and V-Ray Course Course Duration: 10 hours Course Description: This comprehensive course is designed for interior designers and architects who want to master SketchUp for 3D modeling, Layout for creating construction documents, and V-Ray for advanced rendering. Participants will learn how to create stunning 3D models for their projects, produce detailed construction documents, and apply professional-grade rendering techniques to bring their designs to life. Course Outline: Module 1: Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Interface and basic tools - Navigation and viewport controls - Creating and saving interior design and architecture projects Module 2: Creating Floor Plans (1 hour) - Importing floor plans and site plans - Drawing walls, windows, and doors - Creating and editing floor levels - Understanding Layers and Scenes Module 3: Adding Furniture and Fixtures (2 hours) - Importing furniture and fixtures from the 3D Warehouse - Creating custom furniture and fixtures - Placing and arranging furniture and fixtures in the space - Creating and editing custom materials Module 4: Advanced Modeling Techniques (2 hours) - Creating more complex 3D models using advanced tools - Using groups and components for model organization - Adding custom details and finishes Module 5: Layout for Construction Documents (2 hours) - Creating construction documents in Layout - Importing SketchUp models into Layout - Creating floor plans, elevations, and sections - Adding annotations and dimensions to construction documents Module 6: Introduction to V-Ray (1 hour) - Overview of V-Ray for SketchUp - Basic V-Ray interface and tools - Understanding V-Ray materials and textures Module 7: Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to SketchUp models - Creating artificial lighting and using natural lighting - Adding entourage and landscaping to designs Module 8: Importing and Exporting (30 minutes) - Importing and exporting files from other software - Understanding file formats and compatibility - Exporting models for 3D printing Module 9: Conclusion and Next Steps (30 minutes) - Review of course content - Tips for further learning and resources - Q&A and feedback

Unleash your voice, captivate audiences, and master the art of communication with our transformative "Public Speaking Skills" course. Discover the power of your words today!

Join us as we journey through the wine regions of Italy. Discover what makes Italy the most fascinating wine-producing nation in the world! Taste beautiful Barolo, velvety Valpolicella, and charming Chianti amongst many others. We will explore regions such as Piedmont, Veneto, Tuscany, Umbria, Lazio, Lombardia, Puglia, Trentino, and Sicily. Three whole weeks dedicated to Italy enabling us to unravel the mysteries and delights of Italian wine.