20673 Courses delivered Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Furniture design face to face training customised and bespoke.

This 3 day Tableau Desktop Advanced Training course is designed for professionals who have been working with Tableau for some time and are looking to dive deeper and learn analytical use cases that utilise Tableaus advanced features. It is also a perfect refresher course if you want to upgrade your skills to the latest features. Public Course Options EXTEND YOUR KNOWLEDGE OF TABLEAU IN THIS HANDS-ON COURSE TRAINING £1,200 per person + VAT 3 Day live virtual course 12 Months access to online course This 3 day Tableau Desktop Advanced Training course is designed for the professional who has been working with Tableau for some time and is looking to dive deeper. You will review all calculation types and apply Table Calculations and Level of Detail Expressions in multiple use cases. You will also learn advanced techniques for analysing time series data, cohorts and survey data. You will learn advanced mapping and dashboard techniques to help improve the insights gained for your target audience. You will be introduced to the latest features together with practical use cases for getting the most benefit from them. Attendees should have a deep understanding of the fundamental concepts of building Tableau worksheets and dashboards and be comfortable with the techniques learnt in the Foundation and Analyst courses. At the end of this course you will be able to apply and combine some of the more complex capabilities and techniques that Tableau has to offer. In addition to our regular 2 day syllabus we have added an additional day so that we can add learning for many new features introduced into Tableau over the last couple of years. Live Coaching and Q&A Access In addition to the 3 day live and interactive course, delegates also receive 6 weeks live access to our Coaching and Q&A calls that take place 3 times each week. Delegates have found these to be highly beneficial to enhance their learning experience as well as assisting with applying the learning from the course to practical working deliverables on their own data. The course includes the following topics: RECAP: CALCULATIONS Review of Number Functions Review of String Functions Review of Date Functions Review of Type Conversions Review of Logical Functions Review of Aggregate Functions Alternatives to Calculations 2 Hands-on exercises GETTING THE MOST FROM TABLE CALCULATIONS What are and when to use Table Calculations What Table Calculation Types are there? Defining the Scope and Direction of calculations Using Table Calculations in Calculated Fields How do Filters work with Table Calculations? 7 Hands-on exercises LODS - LEVEL OF DETAIL EXPRESSIONS Overview FIXED LOD How do Filters work with LODs? INCLUDE LOD EXCLUDE LOD Nesting LODs Comparing the various Calculation Types 5 Hands-on exercises ADVANCED TECHNIQUES FOR ANALYSING TIME-BASED DATA Creating Sparklines Creating Slope Charts Creating Control Charts Creating Bump Charts 4 Hands-on exercises ANALYSING BEHAVIOURS IN DATA Creating Cohort Analysis Analysing Survey Data 2 Hands-on exercises ADVANCED TECHNIQUES FOR MAPPING Mapping Distance from a point Normalising map areas with Hexbins Combining Spatial & Data Files 3 Hands-on exercises ADVANCED CONSIDERATIONS FOR DASHBOARDS Identifying your Audience Using Containers and Layout Considerations for Dashboard Elements Sheet swapping Adding Dashboard Actions to Context 2 Hands-on exercises In addition to the regular syllabus we will also cover the following New Features : Viz in Tooltips Set Actions Parameter Actions Show/Hide Containers Animations Dashboard Navigation Button Replace Worksheet in a Dashboard (DB) Show/Hide Sort Controls Vector Maps Customisable reference line tooltips Automatic dashboard phone layouts Export to PowerPoint Transparent worksheet backgrounds Density Mark Type (New Heatmap) Dashboard Extensions Step and Jump Lines Dashboard Grids Nested sorting improvements Ask Data Explain Data Spatial Calculations Negative values on log axis Additional clustering functionality Enhanced cross-database join control This training course includes over 35 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. A comprehensive training manual is provided together with all the data, starter and solution Tableau Workbooks required for the training.  Students must use their own laptop with an active version of Tableau Desktop 2020.1 (or later) pre-installed. What People Are Saying About This Course "Course was fantastic and completely relevant to the work I am doing with Tableau. I particularly liked Steve's method of teaching and how he applied the course material to 'real-life' use-cases."Richard W., Dashboard Consulting Ltd "This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work."Lauren M., Baillie Gifford "I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I've learned into practice."Aron F., Grove & Dean "Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work."John B., Mporium

Microsoft Project Orange Belt® 2016: Virtual In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2016 Explain where Project 2016 fits in the Microsoft® EPM solution Initialize Project 2016 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Concepts of Project Management Getting Started with Project 2016 Project 2016: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The planning processes Importing tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding) Entering Estimates Tendencies in estimating The rolling wave approach Entering duration and work estimates Types of tasks Entering Dependencies The principle of dynamic scheduling Choosing the right Type of dependency Entering dependencies in Project 2016 Different applications of dependencies Entering Deadlines, Constraints, and Task Calendars Use of deadlines and constraints Entering deadlines and constraints in Project 2016 Entering Resources and Costs Types of resources Entering resources in Project 2016 Calendars and resources Entering costs in Project 2016 Entering Assignments Assignments in a schedule Assignments and task types Entering assignments in Project 2016 Assignments, budgets, and costs Optimizing the Schedule The critical path method (CPM) and the resource critical path (RCP) Resource leveling Optimizing time, cost, and resources in Project 2016 Updating the Schedule The baseline Updating strategies and situations Prepare the status and forecast report in Project 2016 Reporting Using reports Using Visual Reports Formatting and printing in Project 2016 Customizing fields in Project 2016 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2016 Evaluating the Project Evaluating the project performance Project benefits and results Templates for future projects Summary and Next steps Tools and checklist Best practices checklist Certification options

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. What do you get? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer 6 weeks access to our live coaching program delivered by expert Tableau coaches 50+ practical exercises to practice what you learn 12 months access to video’s that walk you through the theory and exercise solutions Practical advice, tools and resources for using Tableau in the real world The three additional online modules provide:Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs.An agile and iterative development process that delivers products that meet user needs more quickly and effectively.An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU What is possible How does Tableau deal with data Know your way around Review of Type Conversions How do we format charts Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA Connecting to and setting up data in Tableau Modifying data attributes How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) Brainstorm and assess possible priorities Pitfalls to avoid Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing progress over time Creating Tables – Creating Tables, Highlight Tables, Heat Maps Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps Making things dynamic with parameters MODULE 5: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION Table Calculations Sets, Reference Lines, Trends and Forecasting Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files Advanced charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS Using the Dashboard Interface Device layouts Dashboard Actions – Set actions, Parameter actions Viz in Tooltips for Dashboards Dashboard containers – Horizontal & Vertical containers, Hidden containers Navigate between dashboards Telling data driven stories MODULE 8: BRING YOUR OWN DATA Design Best Practices & Resources Wireframe templates Questions Process Start building and testing MODULE 9: EMPOWER STAKEHOLDERS What is Tableau Server Publishing & permissions How can your users engage with content The Tableau ecosystem Review your progress Your next steps HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. We help teams using Tableau to transform in the following ways : From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics From disjointed stakeholder questions – To clear and concise requirements that lead to decision making From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories From using demo data theory – To Delivering value [Answering questions] on their own data From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business

Microsoft Project Orange Belt® 2013: Virtual In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2013 Explain where Project 2013 fits in the Microsoft® EPM solution Initialize Project 2013 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Enterprise Project Management Concepts and Framework Getting Started with Project 2013 Project 2013: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The Planning Processes Importing Tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks and milestones, as well as custom WBS coding) Entering Estimates Tendencies in Estimating The Rolling Wave Approach Entering Duration and Work Estimates Types of Tasks Entering Dependencies The Principle of Dynamic Scheduling Choosing the Right Type of Dependency Entering Dependencies in Project 2013 Different Applications of Dependencies Entering Deadlines, Constraints, and Task Calendars Use of Deadlines and Constraints Entering Deadlines and Constraints in Project 2013 Entering Resources and Costs Types of Resources Entering Resources in Project 2013 Calendars and Resources Entering Costs in Project 2013 Entering Assignments Assignments in a Schedule Assignments and Task Types Entering Assignments in Project 2013 Assignments, Budgets, and Costs Optimizing the Schedule The Critical Path Method and the Resource Critical Path Resource Leveling Optimizing Time, Cost, and Resources in Project 2013 Updating the Schedule The Baseline Updating Strategies and Situations Prepare the Status and Forecast Report in Project 2013 Reporting Using Reports Using Visual Reports Formatting and Printing in Project 2013 Customizing Fields in Project 2013 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2013 Evaluating the Project Evaluating the Project Performance Project Benefits and Results Templates for Future Projects Summary Tools and Checklist Best Practices Checklist Consolidated Schedules Creating Consolidated Schedules Using a Resource Pool Links across Projects Solving common problems Analyzing the Critical Path across Projects

ICA Advanced Certificate in Managing Sanctions Risk Sanctions are a key tool in the armoury of the global fight against financial crime. Understanding sanctions remains a complex yet fascinating topic and is crucial for the development of well-rounded strategy in combating financial crime. The ICA Advanced Certificate in Managing Sanctions Risk explores the intricacies and challenges of meeting sanctions obligations. You will learn about the latest sanctions challenges and best practice and you will review case studies so you understand the risks sanctions present to firms and the frameworks used to manage these risks. The course will also investigate key areas of sanctions controls such as sanctions screening, managing alerts and sanctions evasion typologies. This course will enable you to: Understand latest sanctions challenges Learn sanctions best practice Review case studies, so you understand the risks sanctions present to firms and the frameworks used to manage these risks Investigate key areas of sanctions controls such as sanctions screening, managing alerts and sanctions evasion typologies. Benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate This course is awarded in association with Alliance Manchester Business School, the University of Manchester. Students who successfully complete the assessment criteria for this course will be awarded the ICA Advanced Certificate in Managing Sanctions Risk and will be able to use designation - (Adv.Cert(Sanctions). What will you learn? Global sanctions architecture - Political, Legal and Implementation context The international context Transparency, control and ownership Developing the control framework Sanctions lifting and roll back Identifying higher risk jurisdictions and activities

ICA International Advanced Certificate in Anti Money Laundering This ICA International Advanced Certificate in Anti Money Laundering training course is an intermediate level programme designed to develop Participants existing skills and knowledge base in anti-money laundering. You can study at home through online learning and also attend two highly interactive workshops if these are offered in your jurisdiction. All material for this training course is now delivered online, making it more accessible and environmentally sound. Benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate The expected outcomes of this ICA International Advanced Certificate in Anti Money Laundering training course are as follows: Reduced exposure to reputational and financial risk for your organisation Enhanced workplace performance Full preparation to advance to the diploma programmes Increased potential for career progression Students successfully completing this training course will receive the ICA International Advanced Certificate in Anti Money Laundering and will also be able to use the designation 'Adv. Cert. (AML)'. This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. During this ICA International Advanced Certificate in Anti Money Laundering training course, students will cover the following subjects: What are the Money Laundering, Terrorist Financing and Sanctions Risks that must be Managed? The International Bodies and Standard Setters National Legal and Regulatory Frameworks Taking an AML/CFT Risk-based Approach and Managing the Risks Initial and 'Ongoing' Customer Due Diligence (CDD) Monitoring Activity and Transactions Recognising and Reporting Suspicions The Vulnerabilities of Specific Services and Products How will you be assessed? Assessed by a one-hour, question-based exam and one research-based assignment

ICA Advanced Certificate in Practical Customer Due Diligence (CDD) Course The CDD training course covers best practice in dealing with Customer Due Diligence and working with CDD documentation. Adequate due diligence on new and existing customers has never been so instrumental to protecting a business from reputational, operational, legals and financial risks. Designed for KYC Analysts and professionals working with the CDD process, this course provides a practical qualification in CDD that will help you make clear and informed CDD judgements. In doing so, this course will also improve your ability to identify areas of potential risk for your firm in relation to Customer Due Diligence. Benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Students who successfully complete the course will be awarded the ICA Advanced Certificate in Practical Customer Due Diligence and will be entitled to use the designation- Adv.Cert(CDD) This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. This three workshop training programme will use CDD documents and hands-on learning to cover the following topics: Outcomes and success criteria of KYC Identification and verification Understanding the customer Understanding the relationship Beneficial ownership Understanding the control structure of the entity Customer screening Risk acceptance Enhanced due diligence How will you be assessed? Three hour examination which comprises multiple choice questions and short form written response questions (including a section where you will be provided with a set of CDD documentation and asked to assess the information/respond to questions based upon them.) Pre-reading/exercises/tasks to be completed in advance of virtual workshops, delivered via the online learning platform. Four compulsory virtual classrooms covering key areas and embedding them through discussions and practical exercises (workshops are compulsory as part of the exam is based on the case study used in the workshops). The innovative workshop exercises that use mock CDD documents, genuinely reflecting the practical issues encountered in the CDD environment.

The SEO & PPC Masterclass Workshop is for business owners and marketing managers who want to improve their search engine rankings, increase traffic and drive long term growth in sales.