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
Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner I™ training (PSPO) to master the fundamentals of Product Ownership. Learn how to take your understanding of Scrum frameworks and apply it to maximise product value. Course Description The Professional Scrum Product Owner (PSPO) course goes beyond requirement writing and Product Backlog management. It equips Product Owners with a comprehensive understanding of product management needed to drive value from their products. The PSPO course is Scrum.org certified and delivered by our professional Scrum trainers. We combine real world industry experience with a hands-on practical approach, the result of which is a 98% first-time pass rate. Say goodbye to PowerPoint and join our interactive PSPO training course to gain key practical skillsets and learn how how to implement frameworks immediately to deliver tangibel results. Embrace a product-focused mindset over project-oriented thinking. Bridge business strategy to product execution with Scrum. Recognise the Product Owner's role as an Agile Product Manager. Master Scrum Principles and Empiricism. Understand Product Owner responsibilities within the Scrum Team. Align the team with business strategy, product vision, Product Goal, and Sprint Goal. Communicate business strategy, product vision, and Product Goal effectively. Learn techniques for Product Backlog Management, Release Management, and Forecasting. Identify valuable metrics for tracking value creation and successful product delivery. Employ techniques to engage stakeholders, customers, and Scrum Team members effectively. Why Train With Us? Develop and solidify your knowledge of the Scrum Framework and the accountabilities of being a product owner with our immersive two-day online PSPO course through instruction and team-based exercises. Led by experienced industry professionals and supportive Professional Scrum Trainers & Product Owners, we go beyond powerpoint to offer engaging, hands-on learning experiences. From debunking myths to empowering your Scrum Teams with the right practices, we'll be with you every step of the way - from learning to passing the test and implementing it seamlessly into your job context. Who Should Attend This Course? Ideal for students across industries dealing with complex problem-solving, the Professional Scrum Product Owner course targets three key groups: Aspiring Product Owners seeking to start their career in the field. Experienced Product Owners aiming to enhance their understanding and address misconceptions about Scrum and the Product Owner role. Scrum Masters desiring to become effective coaches for Product Owners, gaining valuable insights from the course. 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 This comprehensive Microsoft Office course provides an in-depth understanding of the core Office applications—Word, Excel, PowerPoint, and Access. Designed to develop essential digital skills, it equips learners with the ability to navigate each program with confidence, improving document creation, data management, presentations, and database handling. Covering both foundational and advanced features, the course is ideal for those looking to boost their efficiency in a variety of business and administrative contexts. By the end of the course, learners will have the capability to produce professional documents, organise data in spreadsheets, create impactful presentations, and manage information through databases. This structured training ensures clarity in using Microsoft Office tools to support workplace productivity and enhance employability across multiple sectors. Course Description This course explores the full functionality of Microsoft Word, Excel, PowerPoint, and Access—focusing on both classic and new features of the 2019 versions. Learners will begin with the essentials, such as creating and formatting documents, performing calculations in spreadsheets, and developing effective slide presentations. As the modules progress, learners will delve into more detailed features, including managing lists, inserting graphics, handling data queries, and designing user-friendly reports. The training also includes familiarisation with the interface and workflow improvements in each application, offering structured, sequential guidance. Ideal for office professionals, jobseekers, and administrative staff, the course enhances digital fluency and enables learners to carry out a wide range of clerical and operational tasks using the Microsoft Office suite. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Microsoft Word 2019 Module 09: Microsoft Word 2019 New Features Module 10: Getting Started with Word Module 11: Formatting Text and Paragraphs Module 12: Working More Efficiently Module 13: Managing Lists Module 14: Adding Tables Module 15: Inserting Graphic Objects Module 16: Controlling Page Appearance Module 17: Preparing to Publish a Document Module 18: Workbooks - Microsoft Word 2016 (Beginner) Module 19: Microsoft PowerPoint 2019 Module 20: Microsoft PowerPoint 2019 New Features Module 21: PowerPoint Interface Module 22: Presentation Basics Module 23: Formatting Module 24: Inserting Options Module 25: Working with Objects Module 26: Table Module 27: Charts Module 28: Review and Presentation Module 29: Microsoft Access 2019 Module 30: Microsoft Access 2019 New Features Module 31: Introduction to Access Module 32: Modify Data Module 33: Working with Queries Module 34: Access Forms Module 35: Working with Reports (See full curriculum) Who is this course for? Individuals seeking to improve their office software knowledge for employment. Professionals aiming to upgrade their digital skills in a business setting. Beginners with an interest in learning Microsoft Office applications. Jobseekers and administrative workers looking to strengthen their CVs. Career Path Administrative Assistant Data Entry Officer Office Manager Project Coordinator Personal Assistant Executive Support Roles Customer Service Representative Database Administrator (Entry-Level)
This Level 4 course aims to equip professionals with the knowledge about the skills and practical behaviours which are required for them to step into a leadership/management role. The demand for management roles is expected to grow in the coming years. This is due to a number of factors, including: The ageing population, which is leading to a shortage of skilled workers. The increasing complexity of businesses requires more managers to oversee operations. The growing importance of technology is creating new opportunities for managers to lead and innovate.
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
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