339 Courses delivered Live Online

Data modelling and visualisation skills are in demand! Create Interactive Reports and Dashboards.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

Dive into the world of hydrogen integration with renewable power through EnergyEdge's course. Enroll in our virtual instructor-led training today!

Agile techniques and management frameworks are changing the way organisations operate. Evolving to realise that organisations are no longer static and structured entities is the key to unlocking new ways to achieve better results. Agile can be utilised at an organisation, team, and project level. Transforming to an Agile way of working requires knowledge, commitment, and frameworks to lead change. The Applying Professional Scrum training teaches key implementation techniques and Scrum frameworks. Course Description Applying Professional Scrum Training ONLINE Getting results with the Scrum framework Scrum is the most used Agile framework for complex product development and project management. It is a proven system, in use for over 25 years by companies large and small. Scrum training introduces an iterative and incremental approach to product or project development – aiming to reduce complexity and achieve results faster. A Scrum team works simultaneously rather than sequentially, with more flexibility. Scrum teams learn to work better together, delivering more value for project stakeholders. Applying professional scrum training The Applying professional Scrum (APS) course introduces the Scrum framework and demonstrates its power over traditional approaches to project or product development. It is an interactive course that aims to familiarise participants with its iterative and 'Sprint' based methodology. The Scrum framework is commonly used in software development but is relevant in any industry or to any complex project. Course contents and key objectives The course will teach participants how to apply Professional Scrum and the Scrum framework. It is appropriate for anyone, whether or not they have previous exposure to Scrum. Contents of the two-day course include: Understanding more about Agile development and the value that an Agile mindset can bring. Explain how Scrum differs from traditional work models and the advantages this offers. Explain the details of the Scrum methodology and its practical application. Understand how to apply Scrum to projects and teamwork. This includes the concepts of the Scrum team, Sprints, Sprint reviews, and the Daily Scrum. Course attendees will work in Scrum teams to simulate a Scrum project. This will involve a series of 'sprints' to solve complex problems and demonstrate the Scrum approach's power. Such Sprints are key to the Scrum framework. They bring in the iterative way of working, giving teams the chance to review success and quickly adapt to meet business requirements. As part of this practical approach, participants will learn to recognize and understand common missteps and misunderstandings when using Scrum. Expected Outcomes from Applying professional scrum training Applying professional scrum training will teach attendees what Scrum is, the value it can deliver, and how to implement it. The practical and example-based nature of the course will help develop a thorough understanding of the Scrum framework. Experience is the key to implementing it in practice. As such, the course is designed to mimic this and teach the problems to look out for and their solution. Participants will emerge as proficient Scrum practitioners – ready to transform the development of their projects. Who Should Attend This Course? Scrum is beneficial for any company, or individual, with complex projects or products. This course provides an introduction and solid grounding in Scrum, enabling participants to work effectively within the Scrum team and to go on to further training if desired. It is ideal for anyone: Working in or joining a team that uses Scrum. Considering the use of Scrum or investigating its benefits. Working alongside or managing Scrum teams – even if not using the methodology directly. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Course Overview: Our Level 3 Award in Education and Training (AET) is perfect for those looking to enter the adult teaching industry in the UK and beyond. This course provides a comprehensive understanding of teaching roles, planning inclusive sessions, assessment principles, and creating supportive learning environments. Delivered online or in-class with full tutor support, our course materials are accessible anytime, anywhere, through our student portal. Sector Covered: This qualification is highly sought-after across various industries, including healthcare, beauty, education, security, and more. From healthcare professionals to educators and trainers, the Level 3 AET equips individuals with the necessary skills to excel in their respective fields. Course Outlines: Understanding teacher/trainer roles and responsibilities Building effective relationships in education and training Implementing inclusive teaching approaches Principles of assessment Creating safe and supportive learning environments Motivating learners Planning, delivering, and evaluating teaching sessions Exploring different assessment methods Managing potential problems in teaching Utilizing teaching equipment and aids Practical teaching sessions (Teaching concepts and techniques) Entry Requirement: Basic functional skills (Numeracy, Literacy, ICT) are required. However, individuals with experience or competence may opt for the distance learning course. How it Works: With our self-study method and tutor support, our online or distance learning option provides flexibility. Upon enrollment, you'll receive all necessary materials and access to the student portal. Complete assignments within 12 weeks, and upon finishing earlier, receive your certificate promptly. A 1-day micro-teach on your chosen topic is required, where you'll showcase your teaching abilities. Corporate or Group Booking: Enjoy special discounts for corporate or group bookings. Our experienced trainers can conduct sessions at your location. Contact us to arrange corporate or group training. Assessment: No formal examination is required. Instead, submit a portfolio at the end of the course. Course Fee: Distance Learning Online: £197.00 (all inclusive) Webinar (Zoom) Live Class: £259.99 (all inclusive) Face-to-Face Class: £279.99 (inside London) / £329.99 (outside London) (all inclusive) Book Now

Who is this course for? This course is ideal for individuals interested in learning landscape architecture, emphasizing the planning, design, and management of various outdoor spaces, such as private gardens, public parks, and commercial landscapes. Click here for more info: Website 1-on-1 training, Monday to Saturday, 9 a.m. to 7 p.m., or call to book. Tailor your 40-hour course  Option A: AutoCAD, Sketchup, Vray, and Photoshop.  Option B: Rhino, Sketchup, Vray, and Photoshop. Both covering specializes in Planting Plans and Maps. Course Outline - Option A: AutoCAD, Sketchup, Vray, Photoshop (Total: 40 hours) AutoCAD (10 hours): Module 1: Introduction to AutoCAD (2 hours) - Overview of AutoCAD interface and tools - Creating, opening, and saving drawings - Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) - Working with lines, circles, and arcs - Utilizing polylines and polygons - Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) - Using coordinate systems for precision - Dimensioning and text incorporation - Hatching and gradients for added detail Module 4: Advanced Tools (2 hours) - Leveraging blocks and attributes - Managing layers and object properties - Creating layouts and preparing for plotting Sketchup (16 hours): (Specializing in Planting Plans, Vegetation Plans, and Maps) Module 1: Introduction to Sketchup (2 hours) - Navigating the Sketchup interface - Grasping basic 2D and 3D modeling concepts - Creating and manipulating objects Module 2: Advanced Modeling (6 hours) - Model intricate garden elements with curves and surfaces - Expertly edit and transform geometry - Specialized focus on Planting Plans, Vegetation Plans, and Maps Module 3: Visualization with Vray (4 hours) - Understanding the Vray rendering engine - Applying materials and textures for realism - Setting up lighting and cameras for realistic rendering Module 4: Image Enhancement with Photoshop (10 hours): - Introduction to Photoshop for design purposes - Editing and enhancing Sketchup and Vray outputs - Creating visually striking presentations Additional Resources: Access free online portfolio design assistance, career growth guidance, and mock interviews to ensure your readiness for the competitive job market. Course Outline - Option B: AutoCAD, Rhino, Vray, Photoshop (Total: 40 hours) AutoCAD (12 hours): Module 1: Introduction to AutoCAD (2 hours) - Overview of AutoCAD interface and tools - Creating, opening, and saving drawings - Basic drawing and editing commands Module 2: Drawing and Editing (3 hours) - Working with lines, circles, and arcs - Utilizing polylines and polygons - Modifying objects: Move, Copy, Rotate, and Scale Module 3: Precision Drawing (3 hours) - Using coordinate systems for precision - Dimensioning and text incorporation - Hatching and gradients for added detail Module 4: Advanced Tools (4 hours) - Leveraging blocks and attributes - Managing layers and object properties - Creating layouts and preparing for plotting Rhino (14 hours): Module 1: Introduction to Rhino (2 hours) - Navigating the Rhino interface - Grasping basic 2D and 3D modeling concepts - Creating and manipulating objects Module 2: Advanced Modeling (6 hours) - Model intricate garden structures with curves and surfaces - Proficiently edit and transform geometry - Build complex 3D structures Module 3: Visualization with Vray (6 hours) - Setting up lights and cameras for garden renders - Exploring rendering settings and options - Post-production and compositing techniques Image Enhancement with Photoshop (8 hours): - Introduction to Photoshop for design purposes - Editing and enhancing Rhino and Vray outputs - Creating visually striking presentations Both Option A and Option B provide comprehensive training in essential design software, with the choice between specialization in Sketchup (Option A) or a broader skill set with Rhino (Option B). Additionally, both options offer access to valuable resources for career preparation. When Can I Book this Training Course? Personalized 1-on-1 training sessions available, allowing for a tailored learning experience. Pre-book your preferred time slot from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, call 02077202581 to book over the phone. Training Duration 40-hour training program, with the flexibility to split hours based on your ideal learning schedule. Training Method Choose between in-person Face to Face or Live Online 1-on-1 training. Expect personalized attention, flexible learning pace, and individualized support throughout your training. Live Online sessions available over Zoom for added convenience. Enroll in our 1-on-1 Course Today! Comprehensive Training Program Overview Option A: AutoCAD (10 hours) Sketchup (16 hours) (Specializing in Planting Plans, Vegetation Plans, and Maps) Vray (4 hours) Photoshop (10 hours) Option B: AutoCAD (12 hours) Rhino (14 hours) Vray (6 hours) Photoshop (8 hours) Benefits of Option A: Diverse Skillset: Gain expertise in AutoCAD, Sketchup, Vray, and Photoshop for various design fields. Specialization: Focus on Planting Plans, Vegetation Plans, and Maps within Sketchup. Realistic Renderings: Learn Vray for compelling 3D renderings. Image Editing: Enhance images effectively with Photoshop. Career Readiness: Access resources like portfolio design assistance and mock interviews for job market readiness. Benefits of Option B: Versatile Expertise: Master AutoCAD, Rhino, Vray, and Photoshop for various design disciplines. Advanced 3D Modeling: Excel in complex designs with Rhino and 3ds Max. Quality Renderings: Create impressive 3D renderings with Vray. Image Editing Mastery: Perfect design concepts with Photoshop. Additional Training Course Benefits: Compatible with both Mac and Windows operating systems. Price Assurance for exceptional value. Flexible scheduling from Monday to Sunday, 9 am to 8 pm. Lifetime Email and Phone Support. Assistance in configuring your computer for seamless software installation. Referral Benefits, including special discounts for friend referrals and savings on group training courses.

OVERVIEW DIAD is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. The course focuses on five practical Labs and at the end of the day, attendees will better understand how to: Connect and transform data from a variety of data sources. Define business rules and KPIs. Explore data with powerful interactive visuals. Build stunning reports. Share their dashboards with their team business partners and publish them to the web. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: Learn how to clean, transform, and load data from various sources Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage and share report assets to the Power BI Service WHO IS THE COURSE FOR? Data Analysts and Management Consultants with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Analysts looking for a quick introduction to Power BI who don’t have the time for the full three day PL-300 course Marketers in data-intensive organisations who need new tools to build visually appealing, dynamic charts for their stakeholders to use LAB OUTLINE Lab 1 Accessing & Preparing The Data Load data from Excel and CSV sources Manipulate the data to prepare it for reporting Prepare tables in Power Query and load them into the data model Lab 2 Data Modelling And Exploration Create a range of different charts Highlight and cross-filter Create new groups and hierarchies Add new measures to the model Lab 3 Data Visualization Add conditional formatting to a report Add logos to a filter Import a custom visual Apply a custom theme Add bookmarks to the report to tell a story Lab 4 Publishing A Report And Creating A Dashboard Create a Workspace in the Power BI Service Publish a report to the Service Create a Dashboard and pin visuals to it Generate and view insights Lab 5 Collaboration Share a Dashboard Access a Dashboard on a Mobile Device

Enhance your professional communication skills with our Business English ESOL Course. Master presentations, negotiation, meetings, phone calls, report writing, letters & emails, and formal & informal networking. Designed for those with a foundation in English, our online program offers flexibility and convenience. Join us for twice-weekly Zoom lessons for 8/12 weeks, with a free initial assessment. Elevate your business communication skills from anywhere. Enrol today and unlock your potential!