28377 Development courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about lean six sigma Understand the core competencies and principles of lean six sigma Explore the various areas of lean six sigma Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert manager or entrepreneur Lean Six Sigma Green Belt Training Course Master the skills you need to propel your career forward in lean six sigma. This course will equip you with the essential knowledge and skillset that will make you a confident manager or entrepreneurand take your career to the next level. This comprehensive lean six sigma green belt course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this lean six sigma green belt course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective lean six sigma practice and equip you with the essential skills, confidence and competence to assist you in the lean six sigma industry. You'll gain a solid understanding of the core competencies required to drive a successful career in lean six sigma. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for manager or entrepreneur or for people who are aspiring to specialise in lean six sigma. Enrol in this lean six sigma green belt course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive lean six sigma green belt course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this lean six sigma can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This lean six sigma green belt course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This lean six sigma green belt course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This lean six sigma green belt course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction to Quality and Lean and Six Sigma Introduction to Quality and It's Importance 00:13:00 Introduction to Lean and Six Sigma 00:20:00 Lean Six Sigma Project Selection Methods 00:26:00 Introduction to Define Phase Project Charter 00:23:00 How to Identify Business Problems 00:18:00 How to Identify Stakeholders and Their Position 00:16:00 How to Find Out the Scope of the Project 00:17:00 Measure Phase Introduction to Measure 00:06:00 Process Map & It's Relevance to KPIV / KPOV 00:17:00 Data types - Continuous and Discrete 00:16:00 Sampling and Data Collection Plan 00:23:00 Data Collection Plan 00:13:00 Measurement System Analysis 00:23:00 Attribute Gauge R&R Analysis 00:19:00 Descriptive Statistics - Measure of Central Tendency 00:18:00 Introduction to Variation 00:20:00 Descriptive Statistics - Measures of Variation 00:24:00 Basic Data Diagnosis - Time Series 00:27:00 Basic Data Diagnosis & Stratification- Run Chart , Bar & Pie Chart 00:33:00 How to Baseline your Project 00:27:00 Process Capability Analysis 00:33:00 Process Capability Indices 00:37:00 Calculation of Z Score From Various Tables 00:09:00 Cause and Effect Analysis 00:29:00 Pareto Analysis for Prioritization 00:32:00 Control Impact Analysis for Prioritizing X's 00:17:00 5 Why Analysis for Finding the Root Cause 00:23:00 FMEA for Identifying the Risk & Root Causes 00:38:00 Introduction to Analyze Phase Recap of Define and Measure 00:21:00 Analyze Phase Learning Objectives and Deliverables 00:09:00 Introduction & 5 Principles of Lean 00:26:00 8 Wastes in Lean 00:36:00 Introduction to Value Stream Mapping 00:24:00 How to Draw a VSM - An Example 00:28:00 Tools and Techniques to Analyze X's&Y's 00:29:00 Tools Used for Correlation Studies 00:26:00 Properties of Normal Distribution 00:17:00 Introduction to Hypothesis Testing 00:15:00 Formulation of Null and Alternate Hypothesis 00:20:00 Connection Between Hypothesis Testing and 5 Why Analysis 00:10:00 Introduction to Type I and Type 2 Errors 00:14:00 Introduction to Type I and Type 2 Errors 00:14:00 Introduction to P Value 00:16:00 Hypothesis Testing of Means- Z test 00:28:00 Hypothesis Testing of Means - 1 Sample t Test 00:12:00 Hypothesis Testing of Means - 2 Sample t Test 00:28:00 Hypothesis Testing of Means - F test & Anova 00:31:00 Hypothesis Testing of Proportions - Chi Square Test 00:25:00 Introduction to Regression - Simple Linear Regression 00:24:00 Non Parametric Hypothesis Testing - Man- Whitney Test 00:21:00 Introduction to Improve Phase Recap of Analyze Phase 00:23:00 Learning Objectives and Deliverable of Improve Phase 00:11:00 Brainstorming Techniques Ground Rules for Solution Generation 00:21:00 Criteria Based Matrix for Solution Priritization 00:19:00 Pugh Matrix for Solution Prioritization 00:08:00 Introduction to Poka Yoke 00:08:00 Introduction to 5S 00:19:00 Cost Benefit Analysis 00:16:00 Implementation Plan 00:10:00 Pilot Implementation 00:12:00 Verification of Pilot Results 00:12:00 Improve Roadmap 00:05:00 Introduction to Control Phase Improve Recap 00:08:00 Control Phase Learning Objectives and Deliverable 00:10:00 Control Road Map and Objectives 00:09:00 Process Control and Control Plan 00:13:00 Introduction to Control Charts 00:17:00 Interpreting Control Charts 00:24:00 Control Limits and Specification Limits 00:17:00 Types of Control charts and Selection of Control Charts 00:28:00 P and NP Chart 00:26:00 U Chart 00:12:00 IMR Chart 00:13:00 X Bar R Chart 00:18:00 Steps for Implementing Control Charts and Response Plan 00:16:00 Before and After Display and Project Closure 00:23:00 Supplementary Resources Supplementary Resources - Lean Six Sigma Green Belt Training & Certification 00:00:00 Final Assessment Assessment - Lean Six Sigma Green Belt Training 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Master the basics of typescript! Our all-inclusive Typescript Basics course will provide you with deep insight and knowledge

Document Control: Document Control Course Online Would you like your Document Control: Document Control Course talents to be better? If so, you are welcome to enrol in our specially created Document Control Course, which is intended to provide participants an in-depth understanding. This Document Control: Document Control Course will teach you about the basics of document control and the identification of document control. Also, the Document Control course describes how to classify and secure the document control system. Moreover, the Document Control course emphasizes on Document Control lifecycle, legal concepts, Document Control: Document Control Course best practices and the underlying expertise. You will be more productive at preparing the final documentation, management after completing our Document Control training. As a document control expert you can handle teams, engineering and management of document control. Unlock your potential in the Document Control: Document Control Course process! Main Course: Document Control Course Free Courses included with Document Control: Document Control Course Document Control Course Offers free Business Writing. Special Offers of this Document Control: Document Control Course. This Document Control: Document Control Course includes a FREE PDF Certificate. Lifetime access to this Document Control: Document Control Course Instant access to this Document Control: Document Control Course 24/7 Support Available to this Document Control: Document Control Course [ Note: Free PDF certificate as soon as completing the Document Control: Document Control Course] Document Control: Document Control Online Training You will learn about the advantages of document management as well as the document control lifecycle in this Document Control course. The Document Control course also explains how to make a document control system more efficient. Additionally, the Document Control course places a strong emphasis on the underlying expertise, best practices, and legal ideas related to document control. Following your completion of our Document Control programme, you'll be more efficient at work. Who is this course for? Document Control: Document Control Online Training A wide spectrum of people who are keen to advance their knowledge and abilities in Document Control Training are catered to by this Document Control: Document Control Course. Requirements Document Control: Document Control Online Training To enrol in this Document Control: Document Control Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Document Control: Document Control Course. Be energetic and self-motivated to complete our Document Control: Document Control Course. Basic computer Skill is required to complete our Document Control: Document Control Course. If you want to enrol in our Document Control: Document Control Course, you must be at least 15 years old. Career path Document Control: Document Control Online Training

So, you've recently passed your graduation and are looking for a job. Hundreds of others are doing the same and may be that the position you are applying for already has over 20 applicants. All of them have the same qualification and experience. They also read the same sample questions and prepare similarly for the job interview. So, how will you distinguish yourself from the rest? How can you ensure that you get noticed by the interviewers, and they pick you from the crowd? This course mainly aims at giving you an edge over the usual practice for the interviews. You will uncover the tips and tricks of the interviews that will make you more confident and helps you to handle all sorts of questions. You will learn to do brainstorming and list down all kind of questions- common, uncommon, and weird that could be asked. You will master the skills you need to excel at an interview. Course Highlights Interview Tips & Tricks is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Interview Tips & Tricks into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Interview Tips & Tricks Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Interview Tips & Tricks is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Interview Tips & Tricks is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Importance of Knowing The Tips And Tricks for Interviews 00:15:00 The Different Types of Interviews 01:00:00 Skill Building to Crack Interviews 00:15:00 Tools and Miscellaneous You Need To Have 00:15:00 The Perfect 'Resume' - Significance and Importance 00:30:00 Preparing Properly for an Interview 00:30:00 What Role Does Appearance Play? 00:30:00 Tips To Gear Up - Pre-Interview 00:30:00 Modern Tips By Interview Experts 00:30:00 Mock Exam Mock Exam- Interview Tips & Tricks 00:20:00 Final Exam Final Exam- Interview Tips & Tricks 00:20:00

The job market these days are extremely competitive as there are thousands of applicants for one single open position. It is never an easy task to face a HR representative and come up with answers on the spot. What you need to get through this ordeal is the build up your skills and use the right combination of body language and confidence. Well this Interview Skills & Tips Course course is here with 100 tips for you to succeed in your next interrogation - sorry, interview. This course will help you boost your interviewing skills by suggesting simple things that make the interviewer see you in a different light compared to the other applicants. You will get advice from basic hygiene to grooming that could help you land your dream job. You will learn about preparing answers to common interview questions and practices that help you level up your confidence and see to it that you do not derail from the subject. This Interview Skills & Tips Course course is a great help for those wanting to do well in an interview, so your next obvious step is to get this course. Course Highlights Interview Skills & Tips Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Interview Skills & Tips Course into 4 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 4 hours, 10 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Interview Skills & Tips Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Interview Skills & Tips Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Interview Skills & Tips Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Interview Tips Part - 01 00:30:00 Interview Tips Part - 02 01:00:00 Interview Tips Part - 03 01:00:00 Interview Tips Part - 04 01:00:00 Mock Exam Mock Exam- Interview Skills & Tips Course 00:20:00 Final Exam Final Exam- Interview Skills & Tips Course 00:20:00

How to tackle Job Interviews successfully There are many tricks and methods to a successful job interview. It's imperative you walk into each and every interview with a premeditated plan for selling yourself. So if you want to go into an interview with the best possible preparation then this course will help you achieve it. You'll need to research the target company. Go through the company's website, editorials and annual reports. Read up on their ongoing projects, future plans and ultimate goals. Try to figure out the size of company, how many employees they have and what kind of work environment they offer. These are the basics that you need to know. As you go more into the course you will have much detailed analysis on what to do during a job interview. An interview is usually done to know more about someone, especially when you need to hire them. Learn the right skills throughout this course which will surely prove to be beneficial to you. So if you want to succeed in interviews, then this course is meant for you. Course Highlights Accredited Complete Guide to Job Interview is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Complete Guide to Job Interview into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Complete Guide to Job Interview Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Entrepreneurs, students, adventurers, the dreamers or individuals who are interested in learning the techniques of goal setting. Accredited Complete Guide to Job Interview is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Complete Guide to Job Interview is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module 1 : CV & Resume Writing INTRODUCTION FREE 00:15:00 EFFECTIVE RESUME AND COVER LETTER WRITING FREE 00:30:00 THE PURPOSE OF YOUR RESUME 01:00:00 RESUME PRESENTATION IS THE KEY 01:00:00 WOW THE EMPLOYER 01:00:00 ELEMENTS OF A RESUME THAT WILL IMPRESS 01:00:00 WRITING YOUR OBJECTIVE 01:00:00 WRITING YOUR SUMMARY 01:00:00 WRITING THE SKILLS AND ACCOMPLISHMENTS SECTION 01:00:00 RESUME FORMATTING 01:00:00 WRITING AN ELECTRONIC RESUME 01:00:00 PUT YOUR BEST FOOT FORWARD 00:15:00 YOUR RESUME - A WORK OF ART 01:00:00 WRITING THE HISTORY/ EXPERIENCE SECTION 01:00:00 WRITING YOUR EDUCATION SECTION 01:00:00 WRITING A PROFESSIONAL AFFILIATIONS SECTION 00:15:00 WRITING A PUBLICATIONS and PERSONAL INTERESTS SECTION 01:00:00 WRITING A REFERENCES SECTION 00:30:00 YOUR RESUME - A WORK OF ART 01:00:00 DO NOT PUT IN YOUR RESUME 00:15:00 A VARIETY OF RESUME SAMPLES 00:30:00 THE IMPORTANCE OF WRITING COVER LETTERS 01:00:00 COVER LETTER OUTLINE: HOW TO WRITE A GOOD COVER LETTER 01:00:00 KEY PHRASES TO BE USED IN YOUR COVER LETTER 00:15:00 COVER LETTER SAMPLE 01:00:00 BASIC COVER LETTER TEMPLATE EXAMPLE 00:30:00 CONCLUSION 00:15:00 Module 2 : Interview Skills Importance of Knowing The Tips And Tricks for Interviews 00:15:00 The Different Types of Interviews 01:00:00 Skill Building to Crack Interviews 00:15:00 Tools and Miscellaneous You Need To Have 00:15:00 The Perfect 'Resume' - Significance and Importance 00:30:00 Preparing Properly for an Interview 00:30:00 What Role Does Appearance Play? 00:30:00 Tips To Gear Up - Pre-Interview 00:30:00 Modern Tips By Interview Experts 00:30:00 Module 3 : Interview Tips Interview Tips Part - 01 00:30:00 Interview Tips Part - 02 01:00:00 Interview Tips Part - 03 01:00:00 Interview Tips Part - 04 01:00:00 Module 4 : Getting the Perfect Job How to Prepare for the Interview 01:00:00 Choosing the Perfect Job 01:00:00 Conducting Your Job Search 01:00:00 How to Conduct Yourself in a Job Interview 00:15:00 How to Dress for an Interview 00:30:00 The Importance of Improving Your Skills 01:00:00 Finding Training Resources for Your Perfect Job 00:15:00 Defining the 'Perfect Job' 01:00:00 Evaluating Your Qualifications for the Job 01:00:00 Five Ways to Guarantee Landing the Perfect Job 00:15:00 How Effective are Specialty Employment Agencies and Job Banks? 00:15:00 Getting the Perfect Job and Keeping It 01:00:00 Focus on the Interviewer and Interview 00:15:00 How to Kill Your Chances for Being Hired 01:00:00 How to Know if You're Making the Right Choice 00:15:00 Interview Tips to Help You Land a Perfect Job 01:00:00 Is Getting the Perfect Job Worth the Extra Effort? 00:15:00 Preparing for the Perfect Job 00:15:00 Project Your Own Image 01:00:00 How to Define Your Perfect Job 00:15:00 Is the Perfect Job Fact or Fantasy? 00:15:00 The Best Job Resources 01:00:00 The Importance of Maintaining Professionalism 01:00:00 Things to Consider when Identifying the Perfect Job 01:00:00 Where to Find the Perfect Job 01:00:00 Mock Exam Final Exam

Highlights of the Course Course Type: Online Learning Duration: 5 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about british sign language Understand the core competencies and principles of british sign language Explore the various areas of british sign language Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert british sign language instructor British Sign Language (BSL) Level 2 Course Master the skills you need to propel your career forward in British sign language. This course will equip you with the essential knowledge and skillset that will make you a confident British sign language interpreter or trainer and take your career to the next level. This comprehensive British sign language course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this British sign language course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective British sign language practice and equip you with the essential skills, confidence and competence to assist you in the British sign language industry. You'll gain a solid understanding of the core competencies required to drive a successful career in British sign language. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for British sign language interpreter or trainer or for people who are aspiring to specialise in British sign language. Enrol in this British sign language course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. **This course is distributed under the Lead Academy licence.** Who is this Course for? This comprehensive British sign language course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this British sign language can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This British sign language course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This British sign language course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This British sign language course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation 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. Course Curriculum British Sign Language (BSL) Level 2 HANDOUT STUDY Questions Forms From English To BSL 00:01:00 QUIZ VIDEO Questions Forms Into BSL 00:02:00 QUIZ VIDEO ANSWERS Questions Forms Into BSL 00:02:00 VIDEO Questions Tags (Negation & Affirmation) with Subtitles 00:01:00 VIDEO Questions Tags (Negation & Affirmation) without Subtitles 00:01:00 FingerSpelling STUDY HANDOUT Fingerspelling - Game 1 and 2 : Boggle 00:01:00 QUIZ VIDEO: Fingerspelling Receptive Skills on TV Programmes 00:03:00 QUIZ VIDEO: Fingerspelling Receptive Skills on Films 00:02:00 QUIZ ANSWERS : Fingerspelling Receptive Skills on Films and TV Programmes 00:01:00 HANDOUTS Handshapes to show Light, Legs, Eyes, People and Ball 00:01:00 VIDEO : Directional Verbs with Subtitles 00:02:00 VIDEO : Directional Verbs without Subtitles 00:02:00 HANDOUT : Directional Verbs 00:01:00 VIDEO Multi Channels Signs with Subtitles 00:03:00 VIDEO Multi Channels Signs without Subtitles 00:03:00 QUIZ VIDEO : Itemising/Listings Signs with 4 Stories 00:08:00 QUIZ ANSWERS : Itemising/Listings Signs with 4 Stories 00:01:00 VIDEO Opposites Signs With Subtitles 00:03:00 VIDEO Opposites Signs without Subtitles 00:03:00 HANDOUTS : Opposites Signs 00:01:00 QUIZ HANDOUTS First letter of Your Name Homework 00:01:00 QUIZ VIDEO First letter of Your Name and Surname with BSL Guest 00:10:00 HANDOUT ANSWER: First letter of Your Name and Surname with BSL Guest 00:01:00 Jobs HANDOUT Asking Questions about the Jobs 00:01:00 VIDEO : Asking Questions about the Job with Subtitles 00:02:00 VIDEO : Asking Questions about the Job without Subtitles 00:02:00 VIDEO : Job Signs with Images 00:02:00 VIDEO : Job Signs without Images 00:02:00 QUIZ VIDEO : What is my Job 00:04:00 QUIZ HANDOUT ANSWERS : What Is My Job 00:01:00 Buildings VIDEO : Type of Buildings with Subtitles 00:03:00 VIDEO : Type of Buildings without Subtitles 00:03:00 HANDOUTS : Type Of Houses1 00:01:00 HANDOUTS : Type of Houses2 00:01:00 Rooms In The House VIDEO : At Home (Rooms) with Subtitles 00:01:00 VIDEO : At Home (Rooms) without Subtitles 00:01:00 VIDEO : At Home - What is in each room with Subtitles 00:05:00 VIDEO : At Home - What is in each room without Subtitles 00:05:00 QUIZ VIDEO : How To Describe Each Room With Images 00:11:00 Daily Routines VIDEO : Day to Day Routines With Images 00:02:00 VIDEO : Day To Day Routines Without Images 00:02:00 HANDOUT: Daily Routines1 00:01:00 HANDOUT: Daily Routines 2 00:01:00 HANDOUT: Daily Routines 3 00:01:00 HANDOUT: Daily Chores1 00:01:00 HANDOUT: Daily Chores2 00:01:00 QUIZ VIDEO : My Day to Day Routines 00:07:00 QUIZ ANSWER : My Day to Day Routines 00:01:00 Travelling And Holidays HANDOUTS BSL Signs for Countries and Cities 00:01:00 VIDEO: Countries Signs with Flags 00:03:00 VIDEO: Countries Signs without Flags and Subtitles 00:03:00 VIDEO : Cities in UK and Europe with Subtitles 00:02:00 VIDEO : Cities in UK and Europe without Subtitles 00:02:00 VIDEO : Types of Holidays with Subtitles 00:01:00 VIDEO : Types of Holidays without Subtitles 00:01:00 HANDOUTS : Types of Holiday 00:01:00 VIDEO : What did you do on Holiday with Subtitles 00:04:00 VIDEO : What did you do on Holiday without Subtitles 00:04:00 HANDOUTS : What did you do on Holiday 00:01:00 VIDEO : What do you need to bring on Holiday with Subtitles 00:02:00 VIDEO : What do you need to bring on Holiday without Subtitles 00:02:00 HANDOUTS : What do you need to bring on Holiday 00:01:00 VIDEO : At the Beach with Subtitles 00:03:00 VIDEO : At the Beach without Subtitles 00:03:00 HANDOUTS : At the Beach 00:01:00 VIDEO : Holiday Questions with Subtitles 00:01:00 HANDOUTS : Holiday Questions 00:01:00 Health And Medical Terminology VIDEO : Health and Medical Terminology with Subtitles 00:08:00 VIDEO : Health and Medical Terminology without Subtitles 00:08:00 VIDEO : Health and Medical Terminology - Treatments with Subtitles 00:02:00 VIDEO : Health and Medical Terminology - Treatments without Subtitles 00:02:00 VIDEO : Health and Medical Terminology - Questions with Subtitles 00:02:00 VIDEO : Health and Medical Terminology - Questions without Subtitles 00:02:00 HANDOUTS : Health and Medical Terminology 00:01:00 VIDEO STUDY : At the Doctors with BSL Guest 00:03:00 VIDEO QUIZ: Multi-Choices Questions “At the Doctors with BSL Guest ” 00:09:00 VIDEO QUIZ ANSWERS : Multi-Choices Answers “At the Doctors with BSL Guest” 00:06:00 Technology VIDEO Technology Terminology with Subtitles 00:04:00 VIDEO Technology Terminology without Subtitles 00:04:00 HANDOUT Technology Terminology 00:01:00 Educational Signs VIDEO : EDUCATIONAL SIGNS with Subtitles 00:08:00 VIDEO : EDUCATIONAL SIGNS without Subtitles 00:08:00 VIDEO : DEAF EDUCATION with Subtitles 00:01:00 VIDEO : DEAF EDUCATION without Subtitles 00:01:00 HANDOUTS : EDUCATIONAL and DEAF EDUCATION 00:01:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 5 hours 25 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about animation Understand the core competencies and principles of animation Explore the various areas of animation Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert animator expert 2D Animation With No Drawing Skills in AE Course Master the skills you need to propel your career forward in animation. This course will equip you with the essential knowledge and skillset that will make you a confident animator expert and take your career to the next level. This comprehensive 2D animation with no drawing skills in AE course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this 2D animation with no drawing skills in AE course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective animation practice and equip you with the essential skills, confidence and competence to assist you in the animation industry. You'll gain a solid understanding of the core competencies required to drive a successful career in animation. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for animator expert or for people who are aspiring to specialise in animation. Enrol in this 2D animation with no drawing skills in AE course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive 2D animation with no drawing skills in AE course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this animation can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This 2D animation with no drawing skills in AE course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This 2D animation with no drawing skills in AE course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Start Here Who Is Better Short Film 00:03:00 Introduction 00:02:00 Two Secrets To Do Awesome Animations 00:02:00 Example of Simple and Interesting 00:03:00 Analyzing “Who Is Better” 00:03:00 Character Emotion Emotional Expression And Body Language 00:03:00 Character Relationships 00:02:00 Relationship Examples 00:04:00 Character Design Designing Characters With Geometric Shapes 00:03:00 Body Language From Geometric Shapes 00:04:00 Expressing With The Mouth 00:03:00 Working With References 00:02:00 Designing Simple Characters 00:04:00 Mock Assessment 1 Assessment Mock-1-2D Animation With No Drawing Skills in AE 00:10:00 Planning a Project Planning Your Animation With a Storyboard 00:02:00 Hiring Voice Talent 00:03:00 Preparing for the Animatic 00:04:00 Editing The Animatic 00:00:00 Finished Animatic for “Who Is Better” 00:04:00 Introduction to Rigging Tutorials Introduction to Rigging Tutorials 00:02:00 Getting Adobe After Effects (For those who don't have it yet) 00:05:00 New Composition in After Effects (For absolute Beginners 00:04:00 Creating the Body for Simple (The circle) 00:04:00 Creating Arms and Legs for Simple 00:07:00 Rigging The Character Automation Using Expressions 00:06:00 Setting Forward Kinematics 00:07:00 Setting Inverse Kinematics 00:03:00 Rigging the Right Arm and Legs 00:07:00 Mock Assessment 2 Assessment Mock-2-2D Animation With No Drawing Skills in AE 00:10:00 Prepearing Controllers Creating and Aligning Controllers 00:04:00 Connecting the Body with Controllers 00:04:00 Cleaning the Timeline 00:05:00 Working With The Mouth Mouth Expression Research 00:04:00 Drawing The Mouth Variations 00:08:00 Prepare Mouth for Emotional Lip-Sync 00:05:00 Animating the First Two Mouths for the Lip Sync 00:07:00 Animating the rest of the Mouths 00:06:00 Preparing the Mouth with Expression Controls 00:05:00 Head Turn Effect 00:10:00 Activating the Flip Switch to rotate the Mouth 00:05:00 Emotional Lip-Sync Emotional Auto Lip-Sync using Expressions 00:09:00 Adding Dialogue to test Auto Lip Sync 00:06:00 Wiggly Body for Maniac Effects 00:11:00 Simple Shading 00:06:00 Mock Assessment 3 Assessment Mock-3-2D Animation With No Drawing Skills in AE 00:10:00 Technical Tips To Know Before Animating Introduction to Animation Tutorials 00:01:00 Tips on Changing the Elbow Knee Angles Part 1 00:05:00 Tips on Changing the Elbow/Knee Angles Part 2 00:06:00 Refining the Lip Sync 00:05:00 Basic Frame Units in Animations at 24 fps 00:03:00 Basic Frame Units for Reaction Movements 00:04:00 Applying the 5 to 10 frame rule 00:02:00 Basic Frame Units for Aggressive Movements 00:05:00 Animating Tutorials Preparing the Timeline for the Posing 00:05:00 Adding two more markers 00:06:00 Posing the 1st Keyframe Like Me 00:06:00 Posing the 2nd Keyframe: Body, Hand and Mouth 00:05:00 Posing the 2nd Keyframe: Left Hand and Hips 00:03:00 Posing the 2nd Keyframe: Correcting the Left Leg 00:02:00 Posing the 3rd Keyframe 00:05:00 Adding Markers for Anticipation and Aftermath 00:05:00 Animating the Anticipation of the 1st Pose 00:04:00 Animating the Aftermath of the 1st Pose 00:03:00 Applying Ease and Wizz 00:05:00 Animating the Anticipation of the 2nd Pose 00:05:00 Fixing the Left Leg 00:06:00 Fixing the Right Arm 00:03:00 Animating the Anticipation of the 3rd Pose 00:03:00 Fixing the Right Hand Drop 00:05:00 Fixing the Left Leg for Final Position 00:07:00 Wrapping Up The Course Closing thoughts on Body Language Animation 00:04:00 Challenge: Animating 3 seconds 00:03:00 Prepare Composition for Rendering 00:03:00 Rendering for YouTube in After Effects 00:03:00 Final Assessment Assessment - 2D Animation With No Drawing Skills in AE 00:10:00 Supplementary Resources Supplementary Resources - 2D Animation With No Drawing Skills in AE 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 11 Hours 11 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about retail analytics and management Understand the core competencies and principles of retail analytics and management Explore the various areas of retail analytics and management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert retail manager Retail Analytics In Microsoft Excel Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive retail analytics in Microsoft excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this retail analytics in Microsoft excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialize in Microsoft excel. Enroll in this retail analytics in Microsoft excel course today and take the next step towards your personal and professional goals. Earn industry-recognized credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive retail analytics in Microsoft excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This retail analytics in Microsoft excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This retail analytics in Microsoft excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This retail analytics in Microsoft excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00