OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations. After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model. COURSE BENEFITS: Understand the Power BI Desktop data model, its components and most effective schemas Describe concepts of calculated columns and measures Create queries using M Create calculations with DAX Understand the use of functions Create and optimize a data model Understand the consequences of data model design decisions WHO IS THE COURSE FOR? Power BI report developers who wish to improve the structure of their data models Power BI report developers who wish to use advanced features like parameters and M coding in Power Query Power BI practitioners who wish to optimise their models more effectively Attendees wishing to prepare thoroughly for the DAX In A Day course COURSE OUTLINE Module 1 Getting And Shaping The Data Understand what is meant by data model in the context of Power BI Understand the consequences of data model design decisions Understand consequences of Power BI’s data type handling Understand data connection options Module 2 Basic Data Modelling Understand basic data modelling Understand basic data model types Explore dimension tables and fact tables Explore data connections Module 3 Getting Started With M (Power Query Language) Get introduced to M Understand key components and syntax Module 4 Understanding Logic Operators Understand Transformations Understand Join operation Module 5 Introduction To DAX Get introduced to DAX and how can it be used Understand working with parameters and DAX (lab combining the previous module) Module 6 Working With Functions - DAX CALCULATE And More Understand working with functions Understand the basics of the CALCULATE formula Module 7 Modelling With Power BI & DAX Best Practice Gain familiarity with basic data modelling for business scenarios Learn some best practices for working with Power BI
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
The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. Course Overview At the start of any career, gaining a solid understanding of key business skills is extremely valuable. These qualifications and courses are designed to blend core skills with key finance knowledge, to give you essential business skills. This Level 1 qualification covers a range of skills and relevant supporting knowledge to help prepare students for applying numbers in business and working in a business environment. It will give students an understanding of: • How different organisations operate • How to contribute effectively in the workplace • How businesses process sales and purchases, and the documents and procedures associated with this. Students will also be equipped with the basic numerical skills needed in the workplace, such as decimals, percentages and fractions, and applying proportions and ratios. The jobs it can lead to: • Data entry clerk • Accounts administrator • Administrative assistant Entry requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Working in the business environment: This unit introduces students to the skills needed in the workplace, including the importance of teamwork, communication, effective time management and professional behaviour. They’ll also learn about some of the core finance processes linked to sales and purchase orders. Learning outcomes: • Develop skills for the workplace. • Understand how organisations operate. • Understand how sales and purchases support businesses. • Apply business procedures to sales and purchases. Using numbers in business: Numeracy is an essential business skill. This unit will introduce students to the basic skills needed when working with numbers in a business environment, developing confidence and skills to use and apply numbers to a wide range of situations. Learning outcomes: • Perform simple business calculations. • Calculate decimals, fractions, percentage, proportions and ratios. • Use tools and techniques to present numerical data.
This course shows you how to perform a complete female intimate waxing treatment. Our course offers a blend of practical training and online learning to give you the knowledge and skills to deliver intimate waxing services to your clients. This course will teach you the benefits of using hot wax and how to work with hot wax on the bikini area. You will be shown a full demonstration of both a Brazilian and Hollywood wax, and you will work on each other or a model to complete both of the techniques. All courses are kept intimate with a maximum of 6 learners to a class. Course Prerequisites We accept students aged 18 and over. The student must have good written and spoken English. Students must have the previous level 2 or equivalent waxing training and certification. Course Agenda Maintain safe and effective methods of working when providing female intimate waxing services Consult, plan and prepare for waxing services with clients Pre-study Intimate Waxing theory Professional live demo Practical training 1 model
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"
Throughout the phlebotomy training course for beginners, you will look at the theory behind phlebotomy and be allowed to develop your practical skill using the most up to date techniques and equipment. The course covers all of the competencies set out in CHS132 (National Occupational Standard for Phlebotomy). Once completed, you will have all of the skills and knowledge necessary to work as a phlebotomist. Course prerequisites This course is suitable for both medics and non-medics. A minimum of 21 years of age Good command of English Able to learn independently Course structure You are required to complete an online study and eight practical hours onsite. All courses are kept intimate with six learners in a class. Areas covered within the course: A background to phlebotomy Health and safety in phlebotomy Infection control Informed consent Anatomy and physiology of the arm Site selection - good and bad veins Complications that can arise when taking blood Needlestick Injuries; what they are and what to do How and where to correctly apply a tourniquet What is expected of a phlebotomist The importance of correct patient identification and informed consent Practice Kit included with virtual course
Learn the basic handbuilding techniques including slab building pinch pot / coil animal sculpture and glazing All of the equipment and resources will be provided.