250 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

– essential guidance for safe and effective remote working Join our expert tutors to discover how you can make online therapy work for your practice -------------------------------------------------------------------------------- * Accredited CPD Certificate: 4 hours * Length: 9am – 1.15pm (BST) -------------------------------------------------------------------------------- LIVE ONLINE – Specialist training in delivering effective therapy online or over the phone – Join Ros Townsend live online on Tuesday 11th June 24 for this jam-packed, informative session. You will receive your Zoom link the day before the event.  NB. Spaces are limited and tend to go quickly.  Register your interest here if you can’t make this date, and we’ll let you know when there’s another one. BONUS RECORDING – the training is recorded, in case of technical difficulties, so you will also get a recording for 2 weeks afterwards to maximise your learning. Delivering online therapy, or counselling clients on the phone, requires a particular set of skills and brings with it specific considerations. This live online workshop will help you gain confidence in working safely and ethically, examining the advantages, potential drawbacks and adjustments you need to make to work remotely successfully. There will be plenty of time for questions, and helpful discussions with your peers and experienced tutors. WHY TAKE THIS COURSE Whether you are a new practitioner wanting to develop your online practice, or an experienced therapist who has decided to start offering services online or on the phone, this course will help you gain the skills and understanding you need to do so safely and effectively. Unlike other online courses, this practical live online CPD training gives you the opportunity to ask our experienced tutors questions about any aspects that concern you, as well as learning from their case histories about what has worked – and what hasn’t – for them. Covering essential areas such as managing client expectations, setting up a therapeutic online environment, risk management, and the use and adaptation of various skills and techniques for online or telephone work, this course gives you the essential information you need to deliver therapeutic interventions remotely. Both Jo Baker [https://www.humangivens.com/person/jo-baker/] and Ros Townsend [https://www.humangivens.com/person/rosalind-townsend/], the course tutors, have extensive experience of working with clients online, with Ros now running her entire therapy practice remotely. Jo works using a blended approach (combining face-to-face counselling and online psychotherapy), and both bring a wealth of practical tips, hands on experience and real-life examples to the training. During the day, there will be ample opportunity to discuss and share ideas with both tutors and peers, and to enter into both structured and more free-ranging discussions about both the benefits and potential difficulties that one might encounter when working therapeutically through remote mediums.   WHAT THE TRAINING COVERS: * The importance of aligning client and therapist expectations for online therapy, or therapy over the phone * How to set-up successfully for work on the phone or online – including template agreements to use with your clients * Managing your technology and ensuring good communication – key things to ascertain, plus troubleshooting tips * What to do when the call won’t connect * The importance of confidentiality and privacy – and the potential problems you need be aware of when working online * Agreeing safe communication methods between sessions * How to successfully manage dual therapy spaces * The importance of setting and maintaining professional boundaries * Discussion regarding what is / is not acceptable in a home therapy space * How to manage transitions before and after the session – for clients and therapists * The key differences between online and face to face therapy work * How to adapt and work successfully with a range of key therapeutic skills – such as Guided Imagery [https://www.humangivens.com/college/guided-imagery-and-visualisation-workshop/] and The Rewind technique [https://www.humangivens.com/college/rewind-technique-training-workshop/] * Assessing suitability of client presentations – including guidance on cases that are not suitable for online therapy * How to manage risk effectively in an online or telephone environment * How to put in place effective contingency plans for when technology fails * Developing flexibility: dealing with the unexpected – including what to do if a session is interrupted * When to refer a client on * The additional pressures and potential stressors of online and telephone working * Working in a blended way – combining remote and face-to-face sessions * Key differences for the client of receiving therapy online or over the telephone * The particular considerations of working with a wider client group from different geographical locations * The importance of self-care and self-awareness * Insurance and GDPR considerations when delivering online therapy or counselling, or working via the phone * The importance of appropriate supervision -------------------------------------------------------------------------------- Course Programme The ‘Online and phone therapy training’ course starts at 9.00am and runs until 1.15pm. (BST). * 9.00am Join the Zoom meeting * 9.15am First session starts * 11.00am Comfort break and discussion * 11.30am Second session * 1.15pm Day ends -------------------------------------------------------------------------------- WHO IS THIS COURSE SUITABLE FOR? * This course is designed for both trainee and fully-qualified therapists, psychotherapists and counsellors * It is recommended to all HG practitioners by the Human Givens Institute – trainee HG Therapists are expected to take this training if they are considering working online. -------------------------------------------------------------------------------- https://directory.cpdstandards.com/providers/human-givens-college/ This course has been independently accredited by the internationally recognised CPD Standards Office for 4 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Thinking about learning more about the data you are using in your job and how to present this? The BCS Foundation Award in Data Visualisation teaches how data is used to make decisions in an organisation and the importance of presenting accurate data in a way that enables decision making to happen.

COURSE OVERVIEW Discover how self-awareness and mental imagery can forge a path to better outcomes by taking A Beginners Guide to Visualisation. As human beings, our frailties and lack of conviction can often prevent us from reaching goals and objectives. With the help of this introductory training, you will be able to literally imagine your future and work towards attaining it with new levels of vigour and purpose.           This Visualisation course focuses on the most effective ways to use the power of the mind to provide the impetus for actions and success. From the basic concepts of visualisation and its uses, you will be given a demonstration of how it has been used in the past and why it is still a valuable process that experts use time and time again. Taking you on a complete learning curve, even if you have had no previous experience, you will soon be capable of building pictures in your head that you will be able to make come true in the physical world.  This best selling A Beginners Guide to Visualisation has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth A Beginners Guide to Visualisation is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The A Beginners Guide to Visualisation is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The A Beginners Guide to Visualisation is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the A Beginners Guide to Visualisation, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the A Beginners Guide to Visualisation will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the A Beginners Guide to Visualisation to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email. 

PROFESSIONAL ARDUINO DATA VISUALISATION USING PYTHON COURSE OVERVIEW Are you looking to begin your Arduino data visualisation career or want to develop more advanced skills in Arduino data visualisation? Then this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and help you to develop your expertise in Arduino data visualisation. This professional Arduino data visualisation using Python course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Python progammer or electronic and electrical engineer. The professional Arduino data visualisation using Python course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Python progammer or electronic and electrical engineer. This comprehensive professional Arduino data visualisation using Python course is the perfect way to kickstart your career in the field of Arduino data visualisation. This professional Arduino data visualisation using Python course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Python progammer or electronic and electrical engineer or want to learn more skills on Arduino data visualisation but unsure of where to start, then this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This professional Arduino data visualisation using Python course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience. WHO SHOULD TAKE THIS COURSE? This comprehensive professional Arduino data visualisation using Python course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Arduino data visualisation. ENTRY REQUIREMENTS * There are no academic entry requirements for this professional Arduino data visualisation using Python course, and it is open to students of all academic backgrounds. * As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. CAREER PATH This professional Arduino data visualisation using Python course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. COURSE CURRICULUM Introduction Introduction Who We Are Hardware and Software Requirements Download and Install Software Section Download and Install Arduino Pro IDE Download and Install Python Editor Download and Install Required Libraries Python Coding to Control Arduino Pins Python Coding to Control Pin Via Serial Arduino Coding to Control Pin Via Serial Running Python Script to Control the Pin Python Coding to Control Arduino Pins Python GUI with Button to Control Arduino Pins Arduino Real-Time Plotting with Python Arduino Real-Time Plotting with Python Arduino Input/Output Control Via Python Blink Simple Led Example with Python Reading Digital Input and Sending Digital Output with Python Extra Installing Python and PIP RECOGNISED ACCREDITATION CPD CERTIFICATION SERVICE This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. CERTIFICATE OF ACHIEVEMENT CERTIFICATE OF ACHIEVEMENT FROM LEAD ACADEMY After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQS IS CPD A RECOGNISED QUALIFICATION IN THE UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. ARE QLS COURSES RECOGNISED? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. WHEN WILL I RECEIVE MY CERTIFICATE? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. CAN I PAY BY INVOICE? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. CAN I PAY VIA INSTALMENT? Yes, you can pay via instalments at checkout. HOW TO TAKE ONLINE CLASSES FROM HOME? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. DOES AGE MATTER IN ONLINE LEARNING? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. WHEN I WILL GET THE LOGIN DETAILS FOR MY COURSE? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Duration 2 Days 12 CPD hours This course is intended for This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. COURSE OUTLINE * The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: * Fundamentals of data visualisation * Data characteristics & dimensions * Mapping visual encodings to data dimensions * Colour theory * Graphical perception & communication * Interaction design * Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text * Designing effective dashboards

Take This Course * £175.00 £21.00 * 1 year * Intermediate * Course Certificate * Number of Units39 * Number of Quizzes0 * 3 hours, 27 minutes Gift this course * * * * COURSE OVERVIEW In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Flourish Studio Masterclass : Create Animated Visualisation will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Flourish Studio Masterclass : Create Animated Visualisation will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Flourish Studio Masterclass : Create Animated Visualisation and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. LEARNING OBJECTIVES * Learn the fundamental skills you require to be an expert * Explore different techniques used by professionals * Find out the relevant job skills & knowledge to excel in this profession * Get a clear understanding of the job market and current demand * Update your skills and fill any knowledge gap to compete in the relevant industry * CPD accreditation for proof of acquired skills and knowledge WHO IS THIS COURSE FOR? Whether you are a beginner or an existing practitioner, our CPD accredited Flourish Studio Masterclass : Create Animated Visualisation is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. ENTRY REQUIREMENT Anyone interested in learning more about this subject should take this Flourish Studio Masterclass : Create Animated Visualisation. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD CERTIFICATE FROM COURSE GATE At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. CAREER PATH The Flourish Studio Masterclass : Create Animated Visualisation will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. COURSE CURRICULUM Introduction to Flourish Studio Welcome 00:04:00 Flourish Studio Background Story 00:01:00 Features of Flourish Studio 00:02:00 Flourish Studio Plans (Free, Business, Enterprise) 00:02:00 Getting Started with Flourish Signing up 00:02:00 Home Page Interface Walkthrough 00:06:00 Creating our First Flourish Visualisation 00:04:00 Adding and Managing Data in Flourish Templates Managing Data in Visualisations 00:08:00 Column Bindings 00:06:00 Merge Datasets 00:07:00 Creating Visualisations in Flourish Studio from scratch Creating a Bar or Line Chart in Flourish Studio - First Steps 00:08:00 Changing Settings to update Chart's look and feel - 1 00:21:00 Changing Settings to update Chart's look and feel - 2 00:10:00 Changing Settings to update Chart's look and feel - 3 00:12:00 More Visualisation Templates in Flourish Studio Table Charts (including mini visualisations) 00:09:00 Creating a Hierarchy Visualisation 00:05:00 Scatter Plot 00:06:00 More interesting variations of Scatter Plot 00:04:00 Map & Projection Charts + 3D Maps 00:08:00 Survey Charts 00:07:00 Gantt Chart 00:06:00 Radar Chart in Flourish Studio 00:06:00 Creating a Story and other Options How to create a Story in Flourish 00:13:00 Exporting, Publishing and Sharing 00:05:00 Flourish's Embed Options 00:06:00 How to Delete Projects 00:02:00 Other Exciting and Important Features Controlling access to Visualisations and stories with different Account Types 00:03:00 How to create a video or GIF from Flourish Visualisation/Story 00:04:00 How to generate the thumbnail of your visualisation 00:02:00 Customise colours in Flourish palettes 00:02:00 How to show published projects on your profile page 00:03:00 How to colour parts of your text with custom HTML 00:03:00 Add Social icons in Footer 00:02:00 Data Visualisation Tips & Resources How to select the right Visualisation Template 00:05:00 Dashboard Development Best Practices 00:04:00 Sources to get Datasets to use in Visualisations 00:02:00 Useful Resources to get Help & Continue Learning 00:06:00 Congratulations Congratulations on Course Completion 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways. Learning Outcomes: 1. Master the art of efficient worksheet modification and effective list management. 2. Harness the power of data analysis tools to make informed decisions. 3. Craft compelling visuals using charts, Sparklines, and data mapping techniques. 4. Implement PivotTables and PivotCharts to dissect complex data sets effortlessly. 5. Automate workbook functionalities for optimised and streamlined processes.   Video Player https://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp4 00:00 00:00 00:00 Use Up/Down Arrow keys to increase or decrease volume. WHY BUY THIS DATA ANALYSIS, AUTOMATING AND VISUALISATION IN EXCEL? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Data Analysis, Automating and Visualisation in Excel Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience WHO IS THIS DATA ANALYSIS, AUTOMATING AND VISUALISATION IN EXCEL COURSE FOR? * Individuals looking to enhance their data visualisation and analysis prowess. * Managers wanting a streamlined approach to handling large datasets. * Academic researchers aiming to present their data in a more compelling format. * Finance professionals seeking efficient ways to dissect and forecast financial data. * Marketing strategists aiming to leverage data for improved decision-making. CAREER PATH * Data Analyst: £30,000 - £50,000 per annum * Financial Analyst: £35,000 - £55,000 per annum * Market Research Analyst: £28,000 - £45,000 per annum * Business Intelligence Analyst: £32,000 - £56,000 per annum * Operations Analyst: £30,000 - £52,000 per annum * Research Scientist (Data-oriented): £35,000 - £60,000 per annum PREREQUISITES This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. COURSE CURRICULUM Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Assignment Assignment - Data Analysis, Automating and Visualisation in Excel 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the Big Data bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Big Data : Data Science, Data Analytics & Data Visualisation. Delve into eight immersive CPD Accredited courses, each a standalone course: 1. Big Data Analytics with PySpark Power BI and MongoDB 2. Big Data Analytics with PySpark Tableau Desktop and MongoDB 3. Building Big Data Pipelines with PySpark MongoDB and Bokeh 4. Develop Big Data Pipelines with R & Sparklyr & Tableau 5. Develop Big Data Pipelines with R, Sparklyr & Power BI 6. Basic Data Analysis 7. SQL for Data Science, Data Analytics and Data Visualization 8. Complete Python Machine Learning & Data Science Fundamentals Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Big Data : Data Science, Data Analytics & Data Visualisation bundle illuminate your path to wisdom. The Big Data : Data Science, Data Analytics & Data Visualisation bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Big Data : Data Science, Data Analytics & Data Visualisation package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Big Data bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Big Data : Data Science, Data Analytics & Data Visualisation community today and let your voyage of discovery begin! Learning Outcomes: * Attain a holistic understanding in the designated areas of study with the Big Data bundle. * Establish robust bases across each course nestled within the Big Data bundle. * Decipher intricate concepts through the articulate content of the Big Data bundle. * Amplify your prowess in interpreting, scrutinising, and implementing theories. * Procure the capacity to engage with the course material on an intellectual and profound level. * Become proficient in the art of problem-solving across various disciplines. Stepping into the Big Data bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Big Data bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Big Data bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Big Data bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Big Data bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Big Data journey and let knowledge guide you towards a brighter future. CPD 85 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? * Individuals keen on deepening their firm understanding in the respective fields. * Students pursuing higher education looking for comprehensive theory modules. * Professionals seeking to refresh or enhance their knowledge. * Anyone with a thirst for knowledge and a passion for continuous learning. CAREER PATH Armed with the Big Data bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Big Data bundle lays a solid groundwork. CERTIFICATES CPD CERTIFICATE OF COMPLETION Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD QUALITY STANDARD HARDCOPY CERTIFICATE (FREE UK DELIVERY) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Webinar - Full Recording This webinar will provide an interactive overview on the use of experiential imagery and visualisation techniques in the treatment of anxiety, depression, trauma and suicide management. 1. OVERVIEW 2. Imagery and Thinking 3. Activation and Consolidation 4. TREATMENT 5. Basic imagery techniques for all clients 6. Imagery Techniques for anxiety, depression and anger 7. Imagery Techniques for PTSD 8. Imagery techniques for Compassion Focused Therapy 9. Imagery Techniques in Suicide prevention 10. Implementation for your practice. 11. Imagery techniques applied to ourselves as therapists 12. Summary What is the workshop about? This workshop will cover the the role of imagery in maintaining psychological distress and the use of visualisation-based techniques in therapeutic practice. There will be practical demonstrations and the opportunity to apply key techniques to therapists ourselves. Who should attend? This workshop is aimed at therapists, counsellors, advisers, educationalists, health care workers, social workers and students in these areas. It is particularly useful for counsellors who do not normally work within a cognitive or behavioural model but want to explore tried and tested techniques. Similarly, counsellors and therapists working within this tradition are likely to find this workshop a useful refresher in the latest approaches. It is also suitable for anyone with an interest in contemporary practice in this area. What have previous delegates said about this workshop? * Particularly interesting to apply visualisation techniques to ourselves as therapists. * Excellent . Very interesting .Thank you . * I am newly qualified and though I have used imagery before, my experience is not that broad, so this was very helpful to understand how useful it can be across different disorders and also for me as a therapist. * Excellent pacing, very resourceful and easy to understand. Lots of practical ideas to use for practice. Thank you! * I loved this workshop, it was informative and give me more ideas as to how to use imagery. I feel more confident about using imagery in my role * Informative, good ideas * Engaging, well paced and informative. I'm a qualified CBT therapist and found this really increased my knowledge giving particular skills and ways of delivering. * Very enjoyable and informative. I got new ideas for use of visualisation work with clients and also for my own self reflection. Thank you! * This was a very informative workshop. I will use it in my practice * I found it great, and I have used visualisation in a small way but feel I can approach with more confidence. Resources A full set of slides with extensive clickable links to online resources, is sent free to all delegates after the event. This also includes references to key sources. Who is leading this webinar? Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George's Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapists.