29060 OV courses delivered Online

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—this is a day of supervised revision for anyone who wishes to take the PL-300 exam so we expect you to have attended a PL-300 course, either taught or on your own, before attending this day of revision. We are happy for attendees to join the course if you have taken the PL-300 with us or with another provider. In the morning we look at questions from the PL-300 exam, grouped by subject area. For each question we show you the correct answer and then explain why that is the correct answer. After lunch everyone tries a practice exam under exam conditions and we finish the day with clarification on the subjects or specific questions that the class is finding hard. The cost of the course includes a free voucher to take the exam, so please don’t buy your own separately. If you do so we cannot reimburse you with the cost of the exam. COURSE BENEFITS: Discover the parts of the course on which to focus most attention Become familiar with the styles and formats of the exam questions Alert yourself to some of the particularly tricky questions Familiarise yourself with the style of the 'case study' question Practice an exam under real exam conditions Get a feel for the time you need to devote to the normal questions and to the case study WHO IS THE COURSE FOR? Power BI report developers who need PL-300 Certification to apply for a job Business Intelligence specialists who wish to enhance their career prospects with a PL-300 Certification Anyone who wishes to maximise their chances of passing the PL-300 Power BI Data Analyst exam COURSE OUTLINE Module 1 Structure Of The Exam Registration for the exam and setup of your workspace The percentage of marks devoted to each subject area Types of questions used in the exam Advised timing for the normal questions and for the case study question Module 2 Individual Exam Question Practice The exam questions are divided into subject areas and for each question… We consider the question and try to answer it We view the answer Where necessary, we look at an in-depth explanation of why that is the correct answer Examine case study questions and how to treat these differently from the normal questions Module 3 Practice Exam Under Exam Conditions Attendees take a practice exam Attendees receive a mark, broken down into subject areas Module 4 Exam Question Practice Focussed On Tricky Areas Together, based on the results of attendees’ exam results we decide which areas on which to focus More practice on individual exam questions using the same style as in Module 2

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

Unschooling questions have unschooling answers. Answers to your questions, with an unschooling perspective. A safe space in which to share anything from the everyday to your deepest concerns. Concentrated time set aside, to help you purposefully move forward, and take hold of a joyful family life. Select from the following options:1/2 Hour Discovery call (Free) : Come and meet me for half an hour and we can discuss together your needs and put together a personal plan for you.  1 hour Clinic (£75) : Bring your own questions and enjoy an unschooling perspective on your unique journey. With the option to upgrade to the full Mentoring Support Service .4 x 1 hour sessions (£266) or 6 x 1 hour sessions (£399) : 1:1 support over of a series of sessions. A bespoke program, tailored to you and your family. Compiled after an initial, in depth, diagnostic assessment. Identifying your challenges and putting together a practical plan that can be implemented with on-going support. LPL Monthly Members receive a 20% discount on mentoring services which is automatically applied at the checkout. Join the LPL Monthly Membership

Learn how to design and customize a perfect fitting sweater using DK or 4ply/fingering weight yarn. From layout and shape to color placement and professional finishing, this 12-week course will guide you through every step with personalized assistance from expert crochet tutor, Merrian. You'll also be part of a small community of crochet students, all making the sweater together over the 12 weeks.

Duco Digital Training's BCS Foundation Certificate in Business Analysis has been designed to provide learners with knowledge and understanding of business analysis concepts, principles and techniques for roles such as business a analyst.

Learn about Bloodstain Pattern Analysis (BPA) and develop the skills to identify bloodstains and interpret bloodstain patterns, over the course of 3 MODULES, from renowned experts in the field. Brought to you by SPATTER/ED Ltd.

This interactive course has been designed to help participants manage their time more efficiently and to develop the skills for effective workplace planning

Effective Presentation Skills (On-Demand) Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In today's results-oriented, global working environment, the ability to create and deliver presentations effectively is a necessary skill set for people at all levels of an organization. Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In this engaging two-day course, you will plan, write, refine, practice, and deliver a presentation to the class. Your presentation will be filmed on both days, and you will leave the course with a flash drive copy of your videos. (ONLY AVAILABLE for Traditional and Virtual Classes) In addition to discovering and enhancing your own personal delivery style, you will learn how to create an overarching goal for your presentation and then organize and structure it for maximum impact. What you will Learn At the end of this program, you will be able to: Construct an effective presentation goal statement, opening, body, and closing that connect with an audience Analyze an audience's needs and style preferences, including relevant DiSC®-related elements Deliver a complete criteria-based presentation that will persuade others Align usage of visuals as well as verbal and non-verbal techniques to maximize the impact of your presentation Getting Started Introductions and social agreements Course structure Course goals and objectives Opening activities Planning and Organizing Video: 'The Art of Misdirection' Setting your presentation goal Writing a goal statement Analyzing your audience Applying the 'reality' test Creating and strengthening supports Structuring your presentation 5 components of an effective opening Presentation body Presentation closing Write your presentation opening Audience Analysis Video: 'How to Tie Your Shoes' Everything DiSC® introduction Audience DiSC® Styles Analyzing your audience Further audience analysis Effective Delivery Delivery challenges and in-person Keeping your audience engaged Your body as your instrument Verbal / paraverbal elements Body stance and nonverbal communication What are your 'tells?' Controlling nervousness Staying attuned to your audience Responding to questions Review and edit your opening Deliver your opening Visuals and Enriching Elements Using images in your presentation Guidelines for visual composition Using questions to engage your audience The power of the pause Practicing and Applying What You've Learned Preparation Delivery Feedback Opportunity to put into practice the program content and receive a video copy Summary and Next Steps What did we learn and how can we implement this in our work environment? Your personal action plan

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"