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
Is statistics a driving force in the industry you want to enter? Do you want to work as a marketing analyst, a business intelligence analyst, a data analyst, or a data scientist? Well then, you've come to the right place!
Five half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.
Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.
Disciplined Agile Senior Scrum Master (DASSM): In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics
Learn how to lead and manage effective change by aligning people through emotional engagement.
Disciplined Agile Senior Scrum Master (DASSM): Virtual In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics
The S.C.I.E.N.C.E.S VIP Program is a 3-month powerful personal development training tool, based around Neuroplastic Mental Acceleration (NMA): encompassing the eight steps to ascension, spread over 60 x 30 minute training sessions: Accept, Aware, Assess, Adapt, Aspire, Accelerate, Actualise, Ascend. The program is designed to provide mental well-being & acceleration by promoting fluid intelligence (the brain’s ability to learn new skills) though activating neuroplasticity - synaptogenisis & neurogenisis.
AI in Project Management: The Next Generation of Project Decision Making Project managers need to make critical project decisions on a daily basis. They are confronted with increasing complexities, high ambiguity and the need to process an exponentially growing amount of data and information in order to make informed and good decisions. This leads to an increasing risk of project failure - meanwhile, the project management industry is already challenged with ongoing low project success rates, caused by often massive failures of projects. Project Data Analytics and Artificial Intelligence (AI) are expected to fill the gap by providing analytical and unbiased capabilities that go beyond human possibilities, towards a data-driven and fact-based decision-making approach. While there is little doubt that AI as a trending technology will disrupt the project management practice and augment today's project management capabilities, AI cannot be seen as just another new tool to make project management more effective. Rather, AI will act as a complement to human intelligence, requiring a collaborative approach and, accordingly, a significant change in project culture and peoples' mindset. Today's project decisions are usually driven by human intuition, experience, leadership, and often do not follow any rational logic. Project decision-makers will be required to abandon such an approach and shift to a data-driven, decision-making approach. This session will provide an overview of the expected changes from AI-driven project management, the resulting impact on project decision making and changes in project culture, and what actions can be taken by project professionals to match their beliefs and behaviours with the new project culture. Learning goals: Gain insights into how AI for project management will significantly change decision-making in projects Gain an understanding of how to transition to a new AI-powered project culture
Emotional Intelligence: Emotional Intelligence Online Discover the Power of Emotional Intelligence: Enhance Your Skills and Propel Your Success! Are you ready to take your personal and professional life to the next level? Do you want to improve your relationships, excel in your career, and unlock your true potential? Look no further than our groundbreaking Emotional Intelligence: Emotional Intelligence course! Unlock the transformative power of Emotional Intelligence: Emotional Intelligence course and propel your success to new heights. Join our Emotional Intelligence: Emotional Intelligence course today and embark on a journey of self-discovery, growth, and achievement. Don't miss this opportunity to invest in yourself and take charge of your future. Enroll Emotional Intelligence: Emotional Intelligence now and experience the profound impact of Emotional Intelligence: Emotional Intelligence course on your personal and professional life! [ Note: Free PDF certificate as soon as completing Emotional Intelligence: Emotional Intelligence Course] Emotional Intelligence: Emotional Intelligence Online Course Curriculum of Emotional Intelligence: Emotional Intelligence Course Module 01: Emotional Intelligence Module 02: Introduction to Emotional Intelligence Module 03: Emotion Module 04: Neuro-Linguistic Programming (NLP) Module 05: Biological Behaviour of Psychology Module 06: Behaviours (Personality) Module 07: Learning Module 08: Motivation Certificate of Completion of Emotional Intelligence Course You will receive a course completion certificate for free as soon as you complete the Emotional Intelligence: Emotional Intelligence course. Who is this course for? Emotional Intelligence: Emotional Intelligence Online An Emotional Intelligence: Emotional Intelligence course is designed to help individuals develop and enhance their emotional intelligence skills. Emotional intelligence refers to the ability to recognize, understand, and manage our own emotions and the emotions of others. Requirements Emotional Intelligence: Emotional Intelligence Online To enrol in this Emotional Intelligence: Emotional Intelligence Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Emotional Intelligence: Emotional Intelligence Course. Be energetic and self-motivated to complete our Emotional Intelligence: Emotional Intelligence Course. Basic computer Skill is required to complete our Emotional Intelligence: Emotional Intelligence Course. If you want to enrol in our Emotional Intelligence: Emotional Intelligence Course you must be at least 15 years old. Career path Emotional Intelligence: Emotional Intelligence Online This Emotional Intelligence: Emotional Intelligence course is beneficial for various groups of people, including: Professionals and Leaders Managers and Supervisors Sales and Customer Service Professionals Educators and Trainers Human Resources Professionals Individuals seeking personal growth