171 Courses in Birmingham

Workplace Mediation

The 3-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

Workplace Innovation Are You A Leader Who Wants To Enhance Your Team’s Accountability, Adaptability, Resilience, And Well-Being? Consider joining our newly launched Growth Leadership Programme: Workplace Innovation, subsided by Scottish Enterprise, which offers a unique approach to leadership development and workplace Innovation, emphasising Motivational Intelligence (MQ). Our programme will help you build on your leadership capabilities and confidence while creating a more innovative, productive, and fair workplace for employee development and growth. Growth Leadership: Workplace Innovation Leading with Motivational Intelligence (MQ) You’ll learn to: Develop MQ leadership skills that encourage fair and innovative workplace practices and inclusive economic growth. Increase engagement, innovation, and productivity among your team. Enhance your strategic decision-making skills. Build a resilient, agile, and change-driven team culture. Identify and integrate organisational values into your workplace culture. Create a successful business that is also a fair place to work. Session Overview Our comprehensive programme, consisting of eight engaging and insightful sessions, is meticulously crafted to provide a world-class education in Leadership, Workplace Innovation and Motivational Intelligence (MQ). We combine some of the most potent, powerful and cutting-edge research in workplace innovation, neuroscience and the most promising discoveries in cognitive and social psychology of the 20th century. 01 Self-Leadership and The Secret to Personal Success Session 1: Self-Leadership and The Secret to Personal Success This comprehensive kick-off session delves into the foundations of self-leadership and personal success. Participants will explore various aspects, from setting course expectations and creating a conducive learning environment to understanding motivational intelligence and managing negative thoughts. Through essential resources like the Leadership Reference Manual and Roadmap Workbook, multi-sensory perception, and spaced repetition learning techniques, participants will solidify their learnings and enhance personal and professional growth. Key Learning Outcomes: Understand the critical role of self-leadership in personal and professional success and the impact of external and internal factors on performance Develop strategies to optimise motivation, communication, and effectiveness within teams and organisations, leveraging diverse learning styles and adult learning techniques Utilise essential resources like the Leadership Reference Manual and Roadmap Workbook for ongoing growth and development while implementing practical tools like the Start, Stop, Continue plan for self-reflection and improvement Explore the power of adaptability, self-awareness, and resilience in navigating through challenging times and maintaining a positive mindset Discover the importance of a positive mental diet, gratitude, and consistent small decisions that compound over time, leading to personal and professional growth 02 The Role of Intelligence in Leadership and Management Session 2: The Role of Intelligence in Leadership and Management It's time to delve into Motivational Intelligence and its role in our personal and professional lives. In this comprehensive and interactive session, participants will explore the multifaceted aspects of intelligence in Leadership and management, focusing on IQ, EQ, and MQ. Participants will learn how to cultivate a growth mindset and motivational intelligence within themselves and their teams, fostering a culture of learning and resilience. The session will also cover the importance of crafting a clear vision for the team or organisation and provide practical strategies for effectively communicating the vision to internal and external stakeholders. Key Learning Outcomes: Understand the roles of IQ, EQ, and MQ in Leadership and management and their impact on individual and team performance Develop strategies to improve your levels of intelligence and foster a growth mindset within individuals and teams Discover the importance of vision in Leadership and management and learn to craft it using the WHERE (performance), HOW (perception), and WHY (purpose) perspectives Gain insights into effectively communicating the vision to stakeholders, ensuring alignment, ownership, and motivation Reflect on the role of a growth mindset and motivational intelligence in achieving the team's vision and fostering a culture of continuous improvement and adaptability 03 The Pillars of Human Performance: Unlocking Potential Session 3: The Pillars of Human Performance: Unlocking Unlimited Potential Discover the keys to unlocking your unlimited potential and becoming a more effective leader in this interactive course. Through engaging discussions and self-reflection, participants will dive deep into unlimited potential, understand its significance in Leadership, and learn to overcome challenges in their teams or businesses. Participants will gain insights into the characteristics of influential leaders, the importance of asking the right questions, and the value of embracing failure as a part of success. With a focus on personal and professional growth, this session will equip you with the tools and techniques to become a better manager and leader. Key Learning Outcomes: Understand the concept of unlimited potential and its importance in Leadership and personal growth Identify personal and team visions, challenges, and the role of asking the right questions in gaining insights Recognise the role of practice and reflection in transforming weaknesses into strengths Explore the characteristics and impact of great leaders and learn how to apply these traits in your leadership style Embrace the importance of failure as a crucial part of success and create a supportive environment for personal and team development 04 Defining Management and Vertical Alignment Session 4: Defining Management and Vertical Alignment In this engaging session, participants will delve into the essential differences between management and Leadership and discover how understanding these distinctions can significantly impact team culture and performance. We'll examine common management mistakes and their effects, uncover the best practices of excellent management, and discuss the development of management skills and the management hierarchy. This interactive session will provide valuable insights and actionable strategies that can be applied to personal and professional life, helping participants become more effective and successful managers and leaders. Key Learning Outcomes: Differentiating between management and Leadership: Gain a deeper understanding of how these concepts differ and their impact on team culture and performance Identifying common management mistakes: Learn about these pitfalls and their consequences on team culture and performance and develop strategies to avoid them Mastering the best practices of excellent management: Discover the five essential techniques to help you become a more effective manager Developing management skills and understanding the management hierarchy: Enhance your ability to grow as a leader and manager Embracing Ultimate Responsibility: Learn the importance of taking ownership and responsibility for your and your team's success and understand the role of motivational intelligence in achieving this 05 Workplace Innovation and High-Payoff Activities Session 5: Workplace Innovation and High-Payoff Activities n (Job Crafting) This session provides a comprehensive overview of the critical principles of workplace innovation, job crafting, people leadership, and coaching in the workplace. Participants will learn about job crafting, our MQ workplace innovation process, and the crucial role of Leadership in managing and monitoring performance in the workplace. By adopting a proactive and creative approach to their work, individuals can improve their job satisfaction, contribute to their organisation's success, and drive economic health for the nation. Key Learning Outcomes: Understanding of Leadership in the job crafting innovative process Skills in job crafting and workplace innovation Knowledge of the critical role of Leadership in performance management Techniques for effective coaching and positive feedback, through trust and mutual respect in the workplace Helping individuals reflect on their role in the success of the team and company and developing a written plan to achieve their goals 06 Defining and Exploring Leadership Session 6: Defining and Exploring Leadership In this session, we will define and explore the essence of Leadership, dispelling the myths and providing a definition that will guide you through the course. We will also explore the three-tier hierarchy of success and how leaders can influence MQ (motivational intelligence) by doing five things consistently. As a manager or leader, you may have found that your team's success is not guaranteed even with the best plans, processes, and strategies. This is because not all team members will adopt new ideas or changes unless they first believe they can achieve the desired outcome. Key Learning Outcomes: Understanding the essence of Leadership to provide an in-depth understanding of the essence of successful Leadership, dispelling the myths and providing a definition that will guide you through the course Psychology of your team: Leaders understand that to achieve their goals, they need to focus on the psychology of their team Power of questions in Leadership: Leaders can gain insight into the minds of their team members and unlock the key to motivating and developing them by asking the right questions Explore the three-tier hierarchy of success and the importance of each level in determining a person's likelihood of success Five things great leaders do each day to influence a culture of responsibility, consistently build esteem and confidence, and always work on coaching and mentoring employees 07 Building a Leadership Toolbox Session 7: Building a Leadership Toolbox: Trust & Inspiration Fostering Adaptability, Responsibility, Resilience, and Courage, this step focuses on leaders' tools and techniques to promote greater team accountability and ownership. It starts to delve into the critical role of self-esteem in a person's motivational intelligence and adaptability. We also explore how self-esteem is formed and influences a person's interpretation of feedback. We also look at self-esteem's critical role in a person's motivational intelligence and adaptability, examining how self-esteem is formed and influences a person's interpretation of feedback. Key Learning Outcomes: Understanding the tools and techniques leaders can use to foster greater team accountability and ownership Delving into the critical role of self-esteem in a person's motivational intelligence and adaptability Exploring how self-esteem is formed and influences a person's interpretation of feedback Examining the levels of self-esteem and associated behaviours of each group Understanding the influence of comfort zones and tools leaders can use to help people overcome the fear of change 08 Developing a Healthy Perspective and Resilient Attitude Session 8: Developing a Healthy Perspective and Resilient Attitude This step explores how developing a healthy perspective and resilient attitude is crucial for success as a leader. In this session, we will explore the critical role of self-reflection in building motivation and adaptability. We will examine how self-esteem is formed and how it influences a person's interpretation of feedback. We will also delve into the levels of self-esteem and the associated behaviours of each class. We will provide practical strategies for cultivating resilience and adaptability in facing challenges and setbacks. Through reflection and analysis of your moments of surprise, frustration, and failure, you will develop a growth mindset that fosters continuous learning and improvement. Key Learning Outcomes: The critical role of self-reflection in building motivation and adaptability How self-esteem is formed and influences a person's interpretation of feedback The levels of self-esteem and the associated behaviours of each class Strategies for cultivating resilience and adaptability in the face of challenges and setbacks The influence of affirmations and tools leaders can use to help people overcome the fear of change

Successful Teams

The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.

Supporting Women in Leadership Throughout The UK Our women in leadership course is specifically designed to target challenges and support women in developing their leadership and management careers. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Discover Our Women in Construction Management Course The Power Within is dedicated to helping women in construction across England and Scotland achieve business success through our Motivational Intelligence framework. Motivational Intelligence is the third level of intelligence, and the science behind it has won a Nobel Prize. Our women leadership in construction course supports women by improving their motivation, self-belief, decision-making, and leadership skills. This programme is designed to help female business leaders adapt more quickly to their environment, handle adversity more effectively, take productive action, and thrive during times of change. Each is a vital skill needed in today’s ever-changing business environment. When completed, you’ll have the skills needed to make decisions more effectively that help your business grow, become more resilient, and take opportunities when others are stuck. "This course has completely changed my outlook on my responsibilities as a manager/leader. In 26 years with Pfizer, I have never participated in a programme that has as profoundly changed my perspective on my role, my responsibilities and my ability to positively impact my team." FEMALE DIRECTOR OF BUSINESS SERVICES, PFIZER LEADING WITH MOTIVATIONAL INTELLIGENCE What is our Women in Construction Course? In the past five years, we’ve supported thousands of business leaders and managers in nurturing the skills and mindset needed to achieve and exceed their business goals. The Power Within knows women are incredibly effective and consistent at applying our Motivational Intelligence techniques to their lives and business. Our women in construction management course is designed to give you the skills you need to take charge of your business and ensure constant growth while future-proofing your business. The training is perfect for women in construction who are managers or leaders looking to: Quickly Adapt Their Team to Change Effectively Mentor Every Team Member Improve Communication and Collaboration Gain More Buy-In to New Goals or Strategies Transform Their Team Culture Increase Initiative and Self-Motivation Across Their Team How We Help Women in the Construction Industry Our course focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. You’ll be provided with valuable knowledge needed to be successful leaders and managers of all levels. We’ll focus on addressing the challenges new businesses around the world face, like leading teams and developing businesses in turbulent and transitional times as well as overcoming the challenges of being women in the construction industry. Throughout the course, particular emphasis is given to helping leaders raise motivational intelligence and foster a growth mindset within their team. LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. SQA APPROVED EXECUTIVE DIPLOMA What Skills Do We Help Women in Construction Develop? The skills we teach through our women in construction management courses are delivered through seven modularised sessions, each between three and three-and-a-half hours per session, with all sessions starting at 9:30 am via Zoom. An additional two hours per week is spent working on the online training assignments and leadership development plan. Each session will provide the education and information needed to establish yourself in your business. Here is more information regarding each session and the skills taught: SESSION 1: SELF-LEADERSHIP & THE SECRET TO PERSONAL SUCCESS Our first module is focused on setting course expectations and creating the right environment for learning. We’ll introduce the format and logistics, then discuss leading through turbulent times and how we can take control of ourselves, our thoughts, and our actions to lead growth. There is also a discussion on adult learning techniques and how leaders can leverage them to improve the effectiveness of their teams. We’ll also explore how turbulence and transition have changed how we manage and lead our teams. SESSION 2: THE ROLE OF INTELLIGENCE WHEN LEADING In this session, we’ll discuss the three levels of human intelligence and show how they each play in an individual’s performance and behaviors. Through two distinct mindsets, you’ll be shown how an individual’s motivational intelligence ultimately influences their emotional intelligence and intelligence quotient (IQ). Depending on which mindset a person operates under ultimately dictates their view of themselves, opportunities, and the work at which they will allow themselves to succeed. Finally, we’ll discuss switching your team to a growth mindset. SESSION 3: THE PILLARS OF HUMAN PERFORMANCE Completing this session will allow you to deconstruct the components that create a motivational intelligence growth mindset. Through discussion, you’ll see how most organizational challenges can be directly tied back to lapses in these components. We’ll review the leaders who’ve had the most significant influence on the meeting participants and shows the commonalities that make these leaders stand out. Lastly, we’ll introduce terminology, tools, and techniques that leaders can leverage to better coach and mentor their team. SESSION 4: MANAGEMENT VERSUS LEADERSHIP: THE TWO CRITICAL AND CO-DEPENDENT SKILLSETS FOR CREATING TEAM SUCCESS We’ll discuss the difference between a manager’s and a leader’s focus. The discussion focuses on the two most common management mistakes and how they undermine team culture and individual performance. The final debate focuses on the five critical best practices of excellent management, including clearly defining and communicating goals, creating alignment and buy-in, setting proper expectations, monitoring performance, and recognizing and rewarding performance. Our final portion will work to define what management is. Session 5: Exploring and Defining Leadership: Dispelling the Myths that Surround It Session 5 strives to define leadership. Building on this definition is a follow-up discussion regarding how people develop their leadership abilities. We’ll explore the underpinnings of what creates a successful leader. It also includes the importance of asking questions and active listening. We’ll review the five behavioral characteristics associated with motivational intelligence and how leaders can assess the relative strengths or weaknesses of the characteristics within their team. Lastly, we’ll explore great leaders’ five critical best practices, including communicating a compelling vision, modeling the correct behaviors, establishing a team culture anchored in responsibility, consistently building team confidence and self-esteem, and proactively coaching and mentoring. SESSION 6: BUILDING A LEADERSHIP TOOLBOX FOSTERING ADAPTABILITY, RESILIENCE, AND COURAGE We’ll provide information regarding tools and techniques that leaders can utilize to foster greater accountability and ownership win their teams. The Power Within will explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll discuss how self-esteem has formed and how it will influence how a person interprets feedback in life. Lastly, we’ll explore levels of self-esteem and the associated behaviors of each. SESSION 7: HELPING EMPLOYEES DEVELOP A HEALTHY PERSPECTIVE AND RESILIENT ATTITUDE During the final session, we’ll explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll talk about how self-esteem is formed and how it influences how a person interprets feedback. Finally, we’ll explore levels of self-esteem and the behaviors of each and the influence of comfort zones, and the tools that leaders can use to help people escape the fear of change. Our Course Leaders The Power Within was founded by husband and wife team James and Enas Fleming, to inspire people worldwide to think bigger, be better, and achieve more. They both work on a personal level with individuals, businesses, and organisations to help them create leaders and build environments where they can thrive. James and Enas challenge the limits with the Motivational Intelligence formula to help you broaden your perspective and create a future on your terms. Here is more about your course instructors: James Fleming James Fleming – James Fleming, the co-creator of The Power Within. He wanted to inspire people around the world to think better, be better, and achieve more. James believes everyone can do whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through the Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Mari Steyn Mari is the go-to person for building self-esteem, offering new perspectives and stepping up in Life. With an endless abundance of excitement and love for all people, combined with degrees in Psychology, Knowledge and Information Management and is a Master NLP and Transformation Coach and International NLP and Coaching Trainer and Executive Coach, Mari offers an attractive, fresh, expert approach to Emotional Freedom, Motivational Intelligence, Leadership Development and ReWriting your Story. We undoubtedly have the power within to alchemize ourselves and any situation! Seeing the light go on in someone’s eyes is my ultimate joy. Take Charge with Our Women in Construction Course The Power Within is a Motivational Intelligence company dedicated to helping businesses and leaders become more accountable, resilient, adaptable, and capable of handling all challenges, regardless of the complexity. Our women in construction management course build upon best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Throughout the course, emphasis is given to helping leaders raise their motivational intelligence and foster a growth mindset within their team. You’ll gain the skills you need to successfully lead your team and overcome adversity while ensuring your company is profitable. To learn more about our course or to register, reach out today.

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Forklift Truck Training The aim of the NPORS Forklift Truck Training is to provide both theoretical and practical training to ensure the safe usage of the FLT Counter Balance Forklifts. As a result of the forklift truck training you will receive the red trained operator card or the Traditional Card. Call to book your forklift course today Experienced operator – NPORS Forklift Truck Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Forklift Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Forklift Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Forklift Truck Test is for operators who have received some form of forklift training in the past or alternatively has been operating Forklift trucks for a period of time. If you are unsure if you qualify to go down the forklift truck test route please contact us to discuss this in more detail. There are two parts to the forklift truck course, a theory section comprised of 25 questions and a practical session. Forklift Truck Training Course: Navigating Safety and Efficiency Forklift trucks, also known as lift trucks or forklifts, are indispensable tools in various industries, facilitating the movement and handling of materials with precision and ease. However, operating a forklift requires specialised skills and knowledge to ensure safety, efficiency, and compliance with regulations. In this comprehensive course outline, we will delve into the essential content covered in a forklift truck training course, designed to equip participants with the expertise needed to operate forklifts safely and effectively in the work place. 1. Introduction to Forklift Trucks: Overview of forklift types: counterbalance, reach, pallet trucks, etc. Understanding the components and controls of a forklift Different configurations and attachments for specific tasks All health and safety regulations covered 2. Forklift Safety Procedures: Importance of safety in forklift operation Pre-operational checks and inspections Understanding load capacity and load centre Personal protective equipment (PPE) requirements Emergency procedures: evacuation, fire, and accident response 3. Forklift Operation Basics: Starting, stopping, and manoeuvring the forklift safely around obstacles Steering techniques: forward, reverse, and turning Operating on various surfaces: smooth floors, ramps, and inclines Lifting, lowering, side shifting and tilting loads using hydraulic controls 4. Load Handling Techniques: Proper load assessment: weight, size, and stability Positioning the forklift for efficient loading and unloading Securing loads with proper attachments: forks, clamps, and attachments Stacking and de-stacking loads safely and efficiently 5. Site Safety and Hazard Awareness: Identifying potential hazards in the workplace Working safely around pedestrians, other forklifts, and obstacles Recognising environmental hazards: narrow aisles, confined spaces, and overhead obstructions Understanding site-specific safety rules and regulations 6. Maintenance and Inspections: Importance of regular maintenance for forklift performance and longevity Daily, pre-shift, and post-shift inspection procedures Lubrication points and maintenance schedules Identifying and reporting mechanical issues and defects 7. Practical Hands-On Training: Practical exercises in forklift operation under supervision Manoeuvring through obstacle courses and tight spaces Load handling exercises: stacking, de-stacking, and transporting loads Emergency response drills: simulated scenarios to test response and decision-making skills 8. Assessment and Certification: Written examination to assess theoretical knowledge Practical assessment of forklift operation skills Certification upon successful completion of the course Conclusion: A forklift truck training course equips participants with the essential knowledge, skills, and confidence to operate forklifts safely and efficiently in various work environments. By covering topics such as safety procedures, operation techniques, load handling, site awareness, maintenance practices, and practical hands-on training, participants can enhance their proficiency and contribute to a safer and more productive workplace. Whether you’re a novice operator or an experienced professional, investing in forklift training is essential for ensuring compliance, reducing risks, and promoting excellence in material handling operations. Frequently Asked Questions 1. What types of forklifts are covered in the training? The training covers various forklift types, including counterbalance, reach trucks, and pallet trucks. 2. What are the course components? The course includes theoretical training, practical sessions, safety procedures, load handling techniques, site safety, maintenance, and inspections. 3. Who is the training suitable for? The training is suitable for both novice operators and experienced operators who need certification or recertification. 4. What certification will I receive? Participants will receive an NPORS card, either a red trained operator card or a traditional card, valid for 2-5 years depending on the type. 5. What are the prerequisites for the course? There are no prerequisites for novice operators, but experienced operators should have prior forklift operation experience. Forklift Truck Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of Forklifts and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment. However, this training can only be conducted on your sites Our forklift training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS forklift Tester to your site nationwide, to reduce the amount of time away from work Our more courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. For those looking for a “NPORS Forklift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security