OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations
OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: Understand the need for storytelling with data Understand the agile process to creating Power BI data visualizations Understand the art behind visualizations Gain familiarity with Power BI report layouts and structure Understand implications behind choosing the right charts Gain familiarity with using Power BI custom visuals WHO IS THE COURSE FOR? Power BI report developers who wish to improve the aesthetic quality of their reports Power BI and other BI practitioners who would like to understand more about the theory of data visualization BI practitioners who wish to create reports that communicate the meaning behind the data more clearly Power BI users who would like to explore the types of chart and visual available that answer different types of business question COURSE OUTLINE Module 1 What Is Storytelling With Data? Volume, Velocity and Variety The importance of business questions What is a story in this context? Module 2 The Science Behind Data Visualization Basic problems to avoid Memory and visualization Ways to spark iconic, short-term and long-term memory Module 3 The Process Behind Data Visualization Using an agile approach to report development Data structure and data grain Converting the story to a data model Module 4 Dashboards And Reports Terminology and definitions Dashboard layout and structure Report layout and structure Storyboarding Drill-through, bookmarks, toggles and tooltips Module 5 Chart Selection Charts for comparison Time series Proportions Constructing effective tables, cards and slicers Scatterplots Module 6 Accessibility And Custom Visuals Report accessibility checklists Custom visuals Creating a custom R visual Charticulator Module 7 Publishing And Formatting Colour schemes Making a Power BI theme Use of fonts, icons and symbols Sizing dashboard and report tiles Sparklines, hyperlinks and images Module 8 Report Authoring - Best Practices Design thought process The audience Defining the platform environment The user experience Visualization Implementation and testing Optimization Module 9 Dashboard And Goals Design Tips and tricks Best practices for dashboard design Tracking business metrics with goals
Explore practical neuroscience-backed tools to help you thrive in challenging circumstances.
This course focus is the management process and leadership skills necessary to anticipate, plan for and manage your organization's communications through a crisis. The course is built around the Crisis Communications section of ISO 22361, the new international standard for Crisis Management. This course includes the CCCM (Certified Crisis Communications Manager) exam and designation for free ($ 500 value). The course does not take you step-by-step how to fill in a template. Instead, you will learn how to protect and manage your organization’s reputation, how to identify and influence the ways organizations represent themselves to various stakeholders, how to prepare your organization for any media or social media crisis, and the best principles and best practices for developing an effective Crisis Communications Program for your organization. This course is designed first and foremost for executives, marketing managers, communications staff, business continuity practitioners, emergency managers, Crisis Management Team and Business Continuity Management Team members and their support staff. It is highly useful for health and safety staff, first responders, line managers, auditors, administrative and professional staff. At the conclusion of this course, participants should: - have a solid understanding of the overall Crisis Management lifecycle - know how to create an effective Crisis Management Communications structure within their organization - understand the key components of a Crisis Communications program including social media - successfully challenge the CCCM (Certified Crisis Communications Manager) exam The CCCM is one of the professional designations offered by the National Institute for Business Continuity Management (NIBCM.net). The exam is comprised of 100 Multiple Choice and T/F questions. You have 90 minutes to complete the exam. In order to obtain the CCCM designation, you must obtain a pass mark of at least 70%. This online course has content equivalent to our 3-day in-person CMC-601 course. The course is comprised of 23 lessons, each being 1/2 hour or so in length, plus additional, optional 'homework' assignments, activities, and downloadable tools including templates. The course also provides for regular asynchronous interaction with the course instructor for assignments and any questions that may arise. CONTENT INTRODUCTION TO CRISIS MANAGEMENT Lesson I - Introduction to Crisis Management Lesson 2 - Evolution of Crisis Management Lesson 3 - Towards a Crisis Management Standard Practice Test 1 CRISIS COMMUNICATIONS Lesson 4 - Pre-Crisis Communications Lesson 5 - Pre-Crisis Communications (cont'd) Lesson 6 - Managing Relationships and Reputation Lesson 7 - Key Roles Practice Test 2 Lesson 8 - Crisis Communications Strategy Lesson 9 - Crisis Communications Strategy (cont'd) Lesson 10 - Key Principles and Activities of Crisis Communication Lesson 11 - Key Principles and Activities of Crisis Communication (cont'd) Lesson 12 - Key Principles and Activities of Crisis Communication (cont'd) Practice Test 3 Lesson 13 - Consistency of Message Lesson 14 - Barriers to Effective Commnication Lesson 15 - Barriers to Effective Communication (cont'd) Lesson 16 - Social Media - Opportunities and Threats Lesson 17 - Social Media - Opportunities and Threats (cont'd) Practice Test 4 Lesson 18 - A Crisis Communication Plan BEST PRACTICES FOR CRISIS MANAGEMENT AND CMMUNICATIONS Lesson 19 - Crisis Management Best Practices Lesson 20 - Crisis Communications Best Practices BONUS LESSONS Bonus Lesson 21 - Pandemic Planning Bonus Lesson 22 - Cyber Security and Crisis Management Bonus Lesson 23 - Cyber Security and Crisis Management (cont'd) CCCM EXAM CCCM Practice Exam CCCM Exam COMPLETION RULES You must complete the test "CCCM Exam"
The BCS Essentials Certificate in Artificial Intelligence teaches the general principles of Artificial Intelligence, an introduction to Machine Learning and understand it's potential implications and capabilities. You will learn about human and artificial intelligence, the machine learning process, the different types of agents, the types of machine learning, the benefits, challenges and risks of a machine learning project, ethics in AI and the future of humans and machines in work. This is a great course for any person or organisation who needs to gain familiarity about Artificial Intelligence and Machine Learning before they commence a project; helping ensure the project approach is correct and avoid the common and costly pitfalls of technology projects.
Agile Release Plans: On-Demand While many Agile frameworks provide guidance on a focus on value and iterative development, many do not explain how that value is delivered to the customer. Release Plans have become an accepted and common practice to bridge the gap between the Product Vision and the Product Backlog (Agile requirements). In this course, you will be provided with an introduction to Agile and to Scrum, the most utilized Agile framework. You will also learn how the Vision, Roadmap, and Charter help to establish the Release Plan. The goal of this course is to equip you with the necessary knowledge, skills, and techniques to build Release Plans to ensure you deliver the most value to your customers. What you will Learn At the end of this program, you will be able to: Recall the Scrum framework elements (roles, events, and artifacts) Examine the benefits of Agile Develop a Product Vision and Roadmap Create an Agile Project Charter Prepare a Release Plan Write user stories to support a Product Backlog Foundation Concepts Introduction to Scrum Scrum Overview Agile Benefits Product Definition Business Goals Product Vision Product Roadmap Agile Project Charter Product Scope Project Risks Release Deadlines Sprint Durations Team Norms Release Planning Release Plan Process Select Stories and a Release Date Product Backlog User stories Building the product backlog Product Backlog Refinement Transitioning to the Scrum Team
The mentorship program for all wedding photographer, from one of the worlds top 100. A course aimed around your interests and bespoke to you, from portfolio critique to business review with the option of joining me on a shoot.