Business Analyst Job Ready Program with Complete Career Guide 2026
What if you could turn business challenges into smart solutions and build a career around it? This online business analyst course helps you understand strategy, project management, process improvement, forecasting and risk. Build career-focused knowledge, strengthen your confidence and explore opportunities in business analysis. Learn flexibly, earn a CPD certificate and start your journey today with the Business Analyst Job Ready Program with Complete Career Guide 2026.
4.7
(438 Reviews)
2075 Students
Business Analyst Job Ready Program with Complete Career Guide 2026
Exclusive Deal! 0% Off, Today Only!
Sale Ends In
This course includes:
-
Access1 Year Access -
Skill Level -
Duration2 days, 21 hours -
Students2075 Students
- PRIVATE
- 1 year
- Advanced
- Number of Units445
- Number of Quizzes4
- 2 days, 21 hours
14-Day Money-Back Guarantee
CPD Accredited – Business Analyst Job Ready Program with Complete Career Guide 2026
Build business analysis skills, career confidence and job-ready knowledge online for 2026.
Ready to turn your analytical thinking into a business analyst career in 2026? The Business Analyst Job Ready Program with Complete Career Guide 2026 gives you structured business analyst training UK learners can complete online while developing knowledge across business analysis, operations, strategic planning, process management, forecasting, project management and professional communication.
The timing matters. UK forecasts project employment across 30 priority digital and technology occupations to grow by 239,000 jobs, or 27%, between 2025 and 2035. When replacement demand is included, employers could require around 488,000 workers, with IT business analysts among the priority occupations.
Businesses do not improve because someone simply notices a problem. They improve when someone can examine what is happening, ask better questions, understand risk, organise information and help decision-makers see a clearer route forward. That is where strong business analysis knowledge matters.
By completing this Business Analyst Course Online, you can:
- Understand key principles of business analysis and management
- Develop knowledge of strategic analysis and product scope
- Explore project management and business process improvement
- Learn effective planning, forecasting and performance management
- Identify business risks and quality management strategies
- Strengthen communication, negotiation and organisational decision-making skills
Whether you are starting from scratch or planning a business analyst career change, Start learning today and gain access to structured business analyst training designed to develop career-focused knowledge and support your professional development in business analysis.
Why Start This Business Analyst Job Ready Program Today?
Your learning begins immediately after enrolment, helping you build business analysis and business management knowledge without waiting for classroom dates or fixed study schedules.
Enrol today and receive:
- Immediate access to all business analyst course materials
- 12 months unlimited online course access
- CPD Accredited Certificate upon completion
- Digital certificate option available
- Flexible self-paced online learning
- Weekday tutor support
Limited-time offer: Complete your enrolment today to secure the current course price and certificate benefits available during the promotional period.
Business Analyst Career Guide 2026 Course Overview
The Business Analyst Job Ready Program with Complete Career Guide 2026 is a career-focused business analyst course online for beginners, career changers and professionals who want to understand how organisations analyse challenges, improve processes, manage performance and make informed commercial decisions.
The programme brings together key areas of modern business analysis, including:
- Business analysis, management and organisational environments
- Strategic analysis, product scope and business development
- Project management and business process improvement
- Planning, forecasting and organisational performance management
- Cash, credit, risk and recovery management
- Quality management, communication and negotiation techniques
- Human resources, customer service and conflict management
Each learning area strengthens your understanding of how analysts examine business activity, identify improvement opportunities, communicate with stakeholders and connect operational information with wider organisational goals.
Moreover, the curriculum supports career awareness for roles across business analysis, project support, consulting, systems analysis, operations and business improvement. It can also complement learners exploring an IT business analyst course, business process analysis training or a wider move into digital transformation.
The programme suits beginners who want structured foundations as well as professionals bringing transferable experience from administration, customer service, finance, management, operations or project environments. Therefore, you can develop your knowledge without needing previous business analysis experience.
You will also strengthen career-relevant understanding of strategic thinking, process improvement, forecasting, risk awareness, stakeholder communication, negotiation and organisational decision-making.
After successful completion, you can receive a CPD Accredited Certificate, supporting your continuing professional development and demonstrating your commitment to business analyst training.
Enrol today and start building the knowledge behind confident business analysis.
Learning Outcomes of the Business Analyst Job Ready Program
This Business Analyst Job Ready Program with Complete Career Guide 2026 develops career-focused business analysis knowledge while strengthening your understanding of operations, planning, communication, risk and organisational decision-making.
- Explain core business analysis roles and responsibilities
- Analyse business environments, risks and opportunities effectively
- Map business processes and identify improvement opportunities
- Apply strategic analysis to products and scope
- Use planning and forecasting for informed decisions
- Evaluate performance, quality, cash and credit controls
- Strengthen stakeholder communication and negotiation approaches confidently
- Recognise project management stages and delivery priorities
- Understand organisational behaviour, motivation and conflict management
- Connect customer service insights with business development
Following Courses are Included With This Course (For Free) - Limited Time!
Why Enrol in This Business Analyst Course?
This business analyst course online UK programme helps you build essential, career-focused knowledge across business analysis, strategic planning, business processes and organisational decision-making, giving you stronger subject understanding for professional development and future career planning.
- CPD Accredited certification, supporting your professional development in business analysis and management
- Study online with 12 months unlimited access — learn anytime, anywhere
- Build career-focused knowledge for business analysis, project and improvement roles
- Receive a digital certificate upon completion, with hard-copy options available
- Receive a free student ID card to enhance your learner profile
- Flexible, self-paced learning with no deadlines, ideal for busy learners
- Transparent pricing with no hidden course fees
- Access dedicated tutor support on weekdays throughout your learning journey
- Fast online assessment and instant results, helping you progress efficiently
Who Is This Business Analyst Course For?
This online Business Analyst Job Ready programme suits learners seeking structured business analysis knowledge, career development opportunities and stronger understanding of modern organisational decision-making.
- Aspiring business analysts preparing for entry-level career opportunities
- Career changers moving into business analysis and consultancy
- Graduates seeking structured business analyst training before applications
- Professionals strengthening analysis, planning and process improvement knowledge
- Project staff expanding stakeholder and business management capabilities
- Managers developing stronger forecasting, performance and risk awareness
- Entrepreneurs improving business planning, operations and growth decisions
- Beginners exploring a business analyst course online confidently
Requirements
There are no specific entry requirements for this Business Analyst Job Ready Program with Complete Career Guide 2026. It is open to:
Beginners interested in business analyst training
Individuals exploring business analysis and project management careers
Professionals seeking CPD in business analysis and management
Career changers interested in business process improvement and strategic planning
How Is the Business Analyst Job Ready Program Assessed?
To assess your understanding, the Business Analyst Job Ready Program with Complete Career Guide 2026 includes an online multiple-choice quiz (MCQ) covering key concepts introduced throughout the programme.
The assessment evaluates your understanding of areas such as business analysis, management, strategic planning, project management, business processes, forecasting, performance, risk, quality, communication and organisational responsibilities.
Learners must achieve a 60% pass mark to complete the assessment successfully.
After successful completion, you can receive your CPD Certificate as recognition of your learning and continued professional development.
CPD Certification
After successfully completing the Business Analyst Job Ready Program with Complete Career Guide 2026 course, you will qualify for a CPD Certificate as proof of your continued professional development and achievement. This certificate can enhance your professional profile and showcase your commitment to building relevant skills and knowledge. You can receive your digital certificate for only £10, or request a printed hard copy sent by post for just £29 or both for £39.
Job Opportunities
Business analysis knowledge can support career development across consulting, technology, project delivery, operations, digital services and wider business management environments.
Completing the Business Analyst Job Ready Program with Complete Career Guide 2026 course can support your professional development for roles such as:
Business Analyst
- Investigate business problems, analyse processes, communicate with stakeholders and recommend improvements that help organisations make stronger commercial and operational decisions.
- Typical UK salary range: £23,000–£55,000
IT Business Analyst
- Connect organisational requirements with technology teams, helping businesses understand systems needs, process changes, priorities and digital improvement opportunities across projects.
- Indicative UK vacancy range: approximately £40,000–£70,000
Business Systems Analyst
- Review business systems, software and organisational processes before helping teams identify technology improvements, system requirements and more efficient working methods.
- Typical UK salary range: £34,000–£65,000
Business Project Manager
- Plan business projects, coordinate resources, manage priorities and help teams complete organisational initiatives within agreed timescales, objectives and budgets.
- Typical UK salary range: £29,000–£75,000
IT Project Manager
- Coordinate digital projects, technology teams, schedules and resources while supporting organisations in delivering new systems, services and technology-led business changes.
- Typical UK salary range: £35,000–£60,000
Management Consultant
- Examine organisational challenges, analyse information and recommend improvements that help clients increase efficiency, address problems and strengthen business performance.
- Typical UK salary range: £27,000–£60,000
Business Adviser
- Assess business needs and provide guidance around planning, growth, finance, technology, performance and organisational decisions for companies and entrepreneurs.
- Typical UK salary range: £27,000–£65,000
Data Analyst
- Collect and interpret organisational data, identify trends, support forecasting and communicate findings that help businesses make informed operational decisions.
- Typical UK salary range: £28,000–£65,000
Digital Product Owner
- Coordinate specialists around digital products, define priorities and connect organisational objectives with user needs, technology requirements and product development decisions.
- Typical UK salary range: £39,000–£75,000
Operations Manager
- Oversee organisational processes, resources, performance and service delivery while identifying opportunities to improve efficiency, quality and operational outcomes.
- Typical UK salary range: £30,000–£63,000 in the National Careers Service production-management profile.
Business Development Manager
- Identify commercial opportunities, build customer relationships and help organisations create strategies that support revenue growth, partnerships and market expansion.
- Typical UK salary range: £28,000–£80,000
Procurement Manager
- Analyse organisational purchasing requirements, assess suppliers, negotiate contracts and manage commercial risks while supporting efficient business purchasing decisions.
- Typical UK salary range: £28,000–£60,000
Frequently Asked Questions
What does the Business Analyst Job Ready Program with Complete Career Guide 2026 cover?
This course covers business analysis, business management, data analytics, Excel forecasting, financial modelling, project management, supply chain, marketing analytics, customer analytics, accounting, risk management, and career preparation. It is designed to build essential knowledge for business and analyst-related roles.
Is this Business Analyst course suitable for beginners?
Yes. This course is suitable for beginners, graduates, career changers, and professionals who want to build business analysis skills step by step. No previous business analyst experience is required to get started.
Can I study this Business Analyst course online?
Yes. The Business Analyst Job Ready Program with Complete Career Guide 2026 is delivered online, allowing you to study from home at your own pace using any internet-enabled device.
Will I receive a certificate after completing this course?
Yes. After successfully completing the course, learners can receive a CPD-accredited certificate. This can help demonstrate your learning and strengthen your CV for business, finance, analytics, or management-related opportunities.
Does this course qualify me as a professional Business Analyst?
This course provides knowledge-based training and career-focused skills, but it does not guarantee employment or provide a professional licence. It is designed to support your preparation for business analyst and related roles.
What jobs can this course help me work towards?
This course can support your progression towards roles such as Business Analyst, Junior Business Analyst, Data Analyst, Business Process Analyst, Finance Analyst, Operations Analyst, Supply Chain Analyst, Project Coordinator, or Management Consultant.
What practical skills will I learn in this course?
You will learn how to analyse business problems, understand processes, work with data, use Excel tools, build financial models, forecast performance, manage risk, prepare dashboards, and support better business decisions.
How is this Business Analyst course assessed?
The course includes mock exams, final exams, assignments, and learning activities across selected topics. These assessments help check your understanding and support your learning progress.
Who is this course best for?
This course is ideal for aspiring Business Analysts, graduates, career changers, office administrators, finance professionals, operations staff, retail professionals, entrepreneurs, and anyone interested in business analysis, data, finance, or project management.
Why should I study the Business Analyst Job Ready Program with Complete Career Guide 2026?
Business analysts help organisations solve problems, improve processes, and make smarter decisions. This course helps you build job-ready knowledge in business analysis, analytics, finance, forecasting, communication, and project management to improve your professional confidence and career prospects.
Course Curriculum
| Topic 01: Business Analysis | |||
| Module 01: Introduction to Business Management | |||
| Introduction to Business Management | 00:25:00 | ||
| Module 02: Operations Management | |||
| Operations Management | 00:24:00 | ||
| Module 03: Introduction to Business Analysis | |||
| Introduction to Business Analysis | 00:14:00 | ||
| Module 04: Strategic Analysis and Product Scope | |||
| Strategic Analysis and Product Scope | 00:28:00 | ||
| Module 05: Project Management | |||
| Project Management | 00:19:00 | ||
| Module 06: Business Development and Succession Planning | |||
| Business Development and Succession Planning | 00:24:00 | ||
| Module 07: Business Process Management | |||
| Business Process Management | 00:44:00 | ||
| Module 08: Planning & Forecasting Operations | |||
| Planning & Forecasting Operations | 00:21:00 | ||
| Module 09: Performance Management | |||
| Performance Management | 00:18:00 | ||
| Module 10: Management of Cash and Credit | |||
| Management of Cash and Credit | 00:19:00 | ||
| Module 11: Managing Risk and Recovery | |||
| Managing Risk and Recovery | 00:26:00 | ||
| Module 12: Quality Management | |||
| Quality Management | 00:21:00 | ||
| Module 13: Communication Skills | |||
| Communication Skills | 00:25:00 | ||
| Module 14: Business Environment | |||
| Business Environment | 00:16:00 | ||
| Module 15: Organisational Skills | |||
| Organisational Skills | 01:16:00 | ||
| Module 16: Negotiation Techniques | |||
| Negotiation Techniques | 00:16:00 | ||
| Module 17: Human Resource Management | |||
| Human Resource Management | 00:25:00 | ||
| Module 18: Motivation and Counselling | |||
| Motivation and Counselling | 00:19:00 | ||
| Module 19: Customer Service | |||
| Customer Service | 00:16:00 | ||
| Module 20: Time Management | |||
| Time Management | 00:40:00 | ||
| Module 21: Conflict Management | |||
| Conflict Management | 00:14:00 | ||
| Mock Exam | |||
| Mock Exam – Business Analysis | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Business Analysis | 00:20:00 | ||
| Topic 02: Business and Data Analytics for Beginners | |||
| Section 01: Business and Data Analytics | |||
| Introduction to Business and Data Analytics | 00:07:00 | ||
| Where are Insights Business Analytics Being Used | 00:11:00 | ||
| Problem Framing Process | 00:11:00 | ||
| Section 02: Business Process Model | |||
| Business Process Modelling | 00:10:00 | ||
| Outcome of the First Step | 00:06:00 | ||
| Outcome of the Second Step | 00:07:00 | ||
| Data Understanding | 00:07:00 | ||
| How Do You Exploit Data that no One Else Has? | 00:10:00 | ||
| Informational System Usually | 00:08:00 | ||
| Section 03: Working on Data | |||
| Data Preparation | 00:04:00 | ||
| Evaluation | 00:05:00 | ||
| Deployment | 00:07:00 | ||
| Major Health Insurance Company | 00:09:00 | ||
| Process | 00:09:00 | ||
| Topic 03: Financial Forecasting Model for New Business | |||
| Section 01: Financial Modelling - Introduction | |||
| Course Promo | 00:07:00 | ||
| Course Road Map and Outline | 00:03:00 | ||
| What is Financial Modelling? | 00:02:00 | ||
| Inputs and Outputs in Financial Modelling Process | 00:01:00 | ||
| What is Financial Modelling used for? | 00:06:00 | ||
| Key Components of a Financial Model | 00:03:00 | ||
| Short Overview of completed Financial Model | 00:06:00 | ||
| Section 02: Finance and Accounting Basics for Financial Modelling | |||
| Accounting Basics and Accounting Equation | 00:04:00 | ||
| Accounting Basics – Debits and Credits | 00:08:00 | ||
| Accrual Accounting v Cash Accounting | 00:06:00 | ||
| Prepaid Expenses and Unearned Revenue with Accrual v Cash Accounting | 00:04:00 | ||
| Section 03: Key Components of Financial Modelling Explained | |||
| Balance Sheet Basics for Financial Modelling | 00:06:00 | ||
| Income Statement or Profit or Loss Statement (Explained) | 00:05:00 | ||
| Cashflow Statement – Basics about Cashflow Statement | 00:04:00 | ||
| Two Methods of Cashflow Statement Explained | 00:05:00 | ||
| Indirect Method of Cashflow Explained in detail | 00:12:00 | ||
| Section 04: Basics of Excel Formulas and Functions (For Financial Model Building) | |||
| Introduction of the Formulas and Functions for the Financial Model | 00:04:00 | ||
| Basics of Choose Function – Explained | 00:13:00 | ||
| Basics of MAX and MIN Functions – Explained | 00:07:00 | ||
| Basics of IF Function | 00:07:00 | ||
| Basics of IF Function and NestedIF Statements | 00:06:00 | ||
| VLOOKUP Function – Explained | 00:06:00 | ||
| Match Function – Explained | 00:11:00 | ||
| VLOOKUP Function with Match Function | 00:06:00 | ||
| SUM IF Function – Explained | 00:05:00 | ||
| OFFSET Full Introduction | 00:14:00 | ||
| IFS Function | 00:08:00 | ||
| Section 05: Introduction to the Financial Model in Excel | |||
| Brief Overview of Financial Model | 00:01:00 | ||
| What are the Excel Basics of Financial Model | 00:06:00 | ||
| Walkthrough of the Completed Model | 00:17:00 | ||
| Build as many Scenarios you want with this Financial Model | 00:08:00 | ||
| Section 06: Building Income Statement for New Business | |||
| Sales Forecast – Basic Structure | 00:06:00 | ||
| Sales Forecast – Growth Rate and Validation tab | 00:10:00 | ||
| Sales Forecast – Growth Type Selection with Form Controls | 00:07:00 | ||
| Sales Forecasting Finalisation | 00:07:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of goods sold – Growth Rates modelling | 00:08:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of Goods Sold Finalising | 00:11:00 | ||
| Cost of Goods Sold/Gross Profit Change – Logic Behind Setting Up | 00:03:00 | ||
| Direct cost and Gross Profit | 00:05:00 | ||
| Indirect Operating Overheads – Dynamic Property Rental cost | 00:10:00 | ||
| Indirect Operating Overheads – Other Overheads | 00:06:00 | ||
| Indirect Operating Overheads – Using IFS Function | 00:06:00 | ||
| Fixed Assets and Depreciation Schedule | 00:05:00 | ||
| Fixed Assets Schedule – Setting Gross Cost and Depreciation | 00:07:00 | ||
| Fixed Assets Schedule – Finalising and Linking Depreciation to PL | 00:07:00 | ||
| Fixed Assets Schedule – Sales and Purchase of Assets | 00:03:00 | ||
| Equity and Loan Schedule – Preparation and Linking to PL | 00:09:00 | ||
| Finishing up Income Statement Modelling | 00:03:00 | ||
| Section 07: Building Cashflow Statement for New Business | |||
| Cash Inflow – Cash Sales and Collection from Credit Sales | 00:14:00 | ||
| Cash Inflow – Dynamic Growth Rate setup with Form Controls | 00:04:00 | ||
| Cash Inflow – Credit days selection drop-down menu with Form controls | 00:04:00 | ||
| Cash Inflow – Dynamic Collection days with OFFSET Function | 00:09:00 | ||
| Cash outflow – Model Cash Purchases and Payments to suppliers | 00:12:00 | ||
| Cash outflow – Direct overheads and Indirect overheads | 00:12:00 | ||
| Cash Conversion Ratio – Measure Net Profit to Cashflow for business | 00:04:00 | ||
| Cash outflow – Capex Payment, Line of Credit and Funding Movement | 00:07:00 | ||
| Section 08: Building Trade Finance Schedule (LOC) for New Business | |||
| Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule | 00:07:00 | ||
| Revolving Line of Credit – Interest Modelling | 00:02:00 | ||
| Revolving Line of Credit – Linking LOC Funding to Cashflow Statement | 00:11:00 | ||
| Section 09: Error Proofing Entire Model - IMPORTANT (New Business) | |||
| How to Setup Validation and Error Check for the entire Model – Part 1 | 00:08:00 | ||
| How to Setup Validation and Error Check for the entire Model – Part 2 | 00:06:00 | ||
| How to Setup Validation and Error Check – Conclusion | 00:03:00 | ||
| Section 10: Fixed Assets Schedule - Expansion (New Business) | |||
| Fixed Asset Schedule Expansion and Why we need it | 00:03:00 | ||
| Fixed Assets Schedule Expansion – Building it Step by step | 00:16:00 | ||
| Section 11: Indirect Method of Cashflow Statement and Balance Sheet (New Business) | |||
| Building Balance Sheet – Assets Modelling | 00:10:00 | ||
| Building Balance Sheet – Liability Side | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Model Part 1 | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Building Part 2 | 00:06:00 | ||
| Updating Error Checks and Validations | 00:07:00 | ||
| Creating KPI Cards for New Business Financial Model | 00:08:00 | ||
| Section 12: Building Financial Model for Existing Business | |||
| Building Existing Business Financial Model – Updating Ranges Tab | 00:06:00 | ||
| Building Existing Business Financial Model – Creating Periods | 00:06:00 | ||
| Building Existing Business Financial Model – Updating Validations and Error Checks | 00:11:00 | ||
| Building Existing Business Financial Model – Finalisation and KPI Cards | 00:11:00 | ||
| Section 13: Building Dashboards for Financial Model | |||
| Overview of the New Financial Model | 00:09:00 | ||
| Data Table Preparation for the charts – Part 1 | 00:09:00 | ||
| Data Table Preparation for the charts – Part 2 | 00:04:00 | ||
| Data Table Preparation for the charts – Part 3 | 00:03:00 | ||
| Building First Column Chart – Sales and Gross Profit | 00:04:00 | ||
| Building Column Chart – with Max and Min Gross Profit % | 00:06:00 | ||
| Building Column Chart – with Max and Min Net Profit % | 00:04:00 | ||
| Building Column Chart for 12 Months Sales and Gross Profit | 00:03:00 | ||
| Building Column Chart for 12 Months Gross Profit % and Net Profit % | 00:09:00 | ||
| Building Column Chart for Cashflow, Collection and Payments for 12 Month | 00:08:00 | ||
| Building Column Chart for Trend of Operating Cashflow for 12 Months | 00:08:00 | ||
| Building a Donut Chart – Sales Products Distribution | 00:07:00 | ||
| Download FREE Stock Images for Dashboard’s Background | 00:05:00 | ||
| Importing Background Image and Setting up Dashboard | 00:05:00 | ||
| Creating Chart Backgrounds for an Amazing visual effect | 00:06:00 | ||
| Finalising New Business’s Dashboard with KPI Cards | 00:09:00 | ||
| Existing Business’s Dashboard Creation – Reusing New Business Dashboard | 00:12:00 | ||
| Waterfall Chart for Net Cashflow Performance | 00:15:00 | ||
| Section 14: Bonus: Financial Model in Google Sheets | |||
| Overview of the Financial Model in Google Sheets | 00:19:00 | ||
| WaterChart for Net Cashflow Performance in Google Sheets | 00:07:00 | ||
| Section 15: Course Wrap up and Thank you | |||
| Wrap up and Thank you (Some Important points) | 00:01:00 | ||
| Downloadable Resources | |||
| Resource – Financial Forecasting Model for New Business | 00:00:00 | ||
| Topic 04: Data Analysis and Forecasting in Excel | |||
| 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 | ||
| Navbar Collapsible Content | 00:04:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Navbar Placement | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Topic 05: Business Analystics for Beginners Using SASS | |||
| Section 01: Introduction | |||
| SAS Introduction | 00:07:00 | ||
| Introduction to SAS Program | 00:05:00 | ||
| Section 02: SAS Dataset | |||
| Read SAS Dataset | 00:09:00 | ||
| Practice Read Dataset | 00:08:00 | ||
| Practical Example on Read Dataset | 00:02:00 | ||
| Introduction to SAS Dataset | 00:12:00 | ||
| SAS Dataset Practical Example | 00:07:00 | ||
| SAS Dataset Practical Program | 00:06:00 | ||
| DateValue | 00:03:00 | ||
| SAS Formats Part 1 | 00:13:00 | ||
| SAS Formats Part 2 | 00:09:00 | ||
| Reading Excel Worksheets | 00:05:00 | ||
| Reading Excel Worksheet Example | 00:11:00 | ||
| Date Format Example | 00:06:00 | ||
| Section 03: Raw Data File Standard And Example | |||
| Raw Data File Standard Part 1 | 00:09:00 | ||
| Raw Data File Standard Part 2 | 00:08:00 | ||
| Raw Data File Standard Example | 00:06:00 | ||
| Section 04: Raw Data File Non Standard | |||
| Raw Data File Non Standard | 00:07:00 | ||
| Raw Data File Non Standard Example | 00:06:00 | ||
| Length Statement | 00:02:00 | ||
| Compilation Execution | 00:04:00 | ||
| Heading | 00:01:00 | ||
| Dataerrors | 00:05:00 | ||
| Data Errorsz Example | 00:03:00 | ||
| Validate Data Procfreq | 00:05:00 | ||
| Validate Data Procpront | 00:07:00 | ||
| Validate Data Peocmeans | 00:05:00 | ||
| Dat Constant | 00:07:00 | ||
| Assignment Statement | 00:09:00 | ||
| If Then Statement | 00:09:00 | ||
| If Then Do End Statement | 00:09:00 | ||
| Diff Where and If Statement | 00:02:00 | ||
| Keep Drop | 00:08:00 | ||
| Keep Drop Example | 00:04:00 | ||
| Section 05: Append | |||
| Append | 00:09:00 | ||
| Append Examples part 1 | 00:09:00 | ||
| Append Examples part 2 | 00:07:00 | ||
| Concatenate | 00:12:00 | ||
| Merge | 00:06:00 | ||
| Merge One to One | 00:07:00 | ||
| Merge One to Many | 00:04:00 | ||
| Merge Non Match | 00:04:00 | ||
| Section 06: Option Statements | |||
| Global Statements | 00:09:00 | ||
| Global Statements Examples Part 1 | 00:08:00 | ||
| Global Statements Examples Part 2 | 00:06:00 | ||
| Section 07: Title n Foot Note | |||
| Title n Foot Note | 00:05:00 | ||
| Title n Foot Note Example | 00:08:00 | ||
| By Statement | 00:08:00 | ||
| Multiple Where Stament | 00:03:00 | ||
| Section 08: ODS statements | |||
| ODS | 00:07:00 | ||
| ODS Example | 00:04:00 | ||
| Section 09: Date Functions | |||
| Sas Date Function | 00:10:00 | ||
| Sas Date Function Example | 00:08:00 | ||
| Sas Functions Part 1 | 00:10:00 | ||
| Sas Functions Part 2 | 00:08:00 | ||
| Sas Functions | 00:07:00 | ||
| Sas Functions Example Part 1 | 00:07:00 | ||
| Sas Functions Example Part 2 | 00:09:00 | ||
| Section 10: Multiple SAS datasets | |||
| Multiple SAS Datasets Part 1 | 00:05:00 | ||
| Multiple SAS Datasets Part 2 | 00:02:00 | ||
| Multiple SAS Datasets Example | 00:10:00 | ||
| Section 11: Select Group | |||
| Select Group | 00:09:00 | ||
| Select Group Example | 00:08:00 | ||
| Section 12: Do Loop | |||
| Do Loop Part 1 | 00:07:00 | ||
| Do Loop Part 2 | 00:06:00 | ||
| Do Loop Example | 00:07:00 | ||
| Section 13: Array | |||
| Array Part 1 | 00:05:00 | ||
| Array Part 2 | 00:08:00 | ||
| Array DoLoop | 00:06:00 | ||
| ArrayTemp | 00:05:00 | ||
| Array Example | 00:10:00 | ||
| Sas Statement Part 1 | 00:04:00 | ||
| Sas Statement Part 2 | 00:05:00 | ||
| Topic 06: Supply Chain Management for Different Retail Formats | |||
| Supply Chain Management for Different Retail Formats | |||
| Lesson 01: Introduction Retail Customer Service Customer Service Mix | 00:08:00 | ||
| Lesson 02: Customer Service Pyramid Customer Service over Retail Life cycle | 00:07:00 | ||
| Lesson 03: Ways to improve Customer Service for a Retailer | 00:09:00 | ||
| Lesson 04: Order Management Process Concept of Perfect Order | 00:06:00 | ||
| Lesson 05: Multi Channel Retailing | 00:09:00 | ||
| Lesson 06: Retail Returns Reverse Logistics | 00:08:00 | ||
| Lesson 07: Reverse Logistics process | 00:11:00 | ||
| Lesson 08: Retail Loyalty Programmes | 00:08:00 | ||
| Lesson 09: Retail kiosk advanced payment technologies conclusion | 00:09:00 | ||
| Topic 07: Customer Analytics Training | |||
| Section 01: Basics Of Customer Analytics And Customer Life Cycle | |||
| What Is Customer Analytics | 00:04:00 | ||
| Customer Life Cycle | 00:04:00 | ||
| Section 02: Customer Onboarding | |||
| Customer Onboarding When Whom | 00:01:00 | ||
| Customer Onboarding Process For A Typical Bank | 00:04:00 | ||
| Section 03: Customer Activation | |||
| What Is Activation And Why Is It Necessary | 00:01:00 | ||
| The Importance Of Customer Activation | 00:03:00 | ||
| Section 04: Cross Selling | |||
| What Is Cross Sell And Why Cross Sell | 00:03:00 | ||
| How Do We Cross Sell Effectively | 00:06:00 | ||
| Upgrade Upsell | 00:06:00 | ||
| Section 05: Campaign Life Cycle | |||
| Campaign Life Cycle Transition To Lead Management | 00:04:00 | ||
| Stages Of Campaign | 00:04:00 | ||
| Campaign Execution | 00:03:00 | ||
| Campaign Channels | 00:07:00 | ||
| Campaign Assessment | 00:05:00 | ||
| Section 06: Conclusion | |||
| Conclusion | 00:08:00 | ||
| Topic 08: Fundamentals of Marketing Analytics | |||
| Section 01: Introduction To Marketing Analytics Overview | |||
| Introduction | 00:02:00 | ||
| What Is Marketing | 00:04:00 | ||
| Why Do We Need Marketing | 00:08:00 | ||
| Section 02: Basic Concepts In Marketing Analytics Overview | |||
| What To Market | 00:03:00 | ||
| Whom And When To Market | 00:06:00 | ||
| How Analytics Drives Marketing Strategies | 00:08:00 | ||
| Acquisition To Retention | 00:08:00 | ||
| Customer Profitability To Contact Strategy | 00:06:00 | ||
| Campaign Analytic | 00:12:00 | ||
| Topic 09: Supply Chain Masterclass in Retail | |||
| Supply Chain Masterclass in Retail | |||
| Lesson 01: Retail: An Introduction | 00:18:00 | ||
| Lesson 02: Retail India: A Case Study | 00:15:00 | ||
| Lesson 03: Retail Location: An Advantage | 00:17:00 | ||
| Lesson 04: Retailing: An Overview | 00:03:00 | ||
| Lesson 05: Evolution of Indian Retail | 00:12:00 | ||
| Lesson 06: Indian Retail Key Enablers | 00:08:00 | ||
| Lesson 07: Supply Chain Management for Retailing A challenge for Retailers | 00:10:00 | ||
| Lesson 08: Porters Value Chain | 00:13:00 | ||
| Lesson 09: Characteristics of an Efficient Supply Chain | 00:09:00 | ||
| Lesson 10: Supply Chain Components | 00:06:00 | ||
| Lesson 11: Macro Process In SCM | 00:10:00 | ||
| Lesson 12: Stages In SCM | 00:11:00 | ||
| Lesson 13: SCM Issues | 00:09:00 | ||
| Lesson 14: Push Based SCM | 00:12:00 | ||
| Lesson 15: Pull Based SCM | 00:06:00 | ||
| Conclusion | 00:06:00 | ||
| Topic 10: Business Productivity Training | |||
| Introduction | |||
| Prof Paul Course Intro | 00:03:00 | ||
| Productivity Training | |||
| Productivity – Part 1 | 00:12:00 | ||
| Productivity – Part 2 | 00:12:00 | ||
| Productivity – Part 3 | 00:13:00 | ||
| Teamwork Training | |||
| Project Management – Part 1 | 00:15:00 | ||
| Project Management – Part 2 | 00:17:00 | ||
| Teamwork Training | |||
| Teamwork – Part 1 | 00:12:00 | ||
| Teamwork – Part 2 | 00:12:00 | ||
| Teamwork – Part 3 | 00:13:00 | ||
| Communication Training | |||
| Communication – Part 1 | 00:17:00 | ||
| Communication – Part 2 | 00:18:00 | ||
| Topic 11: Dealing With uncertainty: Make Budgets and Forecasts | |||
| Dealing With uncertainty: Make Budgets and Forecasts | |||
| Introduction to the Course | 00:01:00 | ||
| Course Curriculum | 00:02:00 | ||
| Why do We do Budgeting? | 00:06:00 | ||
| Paper Exercise or Something Useful? | 00:06:00 | ||
| Two Key Budgets and What They Contain | 00:05:00 | ||
| Suggestive Process of Budgeting | 00:05:00 | ||
| Pre-Requirements of Budgeting | 00:04:00 | ||
| Three Key Components of Budgets | 00:09:00 | ||
| Practical Process of Budgeting and Forecasting | 00:10:00 | ||
| Basics of Revenue Budgeting | 00:05:00 | ||
| Revenue Budget – Information Needed | 00:04:00 | ||
| Revenue Budget – Practical Example | 00:04:00 | ||
| Estimating Overall Impact of Revenue | 00:02:00 | ||
| Cost and Expenses Budget – Information Needed | 00:08:00 | ||
| Labour Cost Budgeting | 00:05:00 | ||
| Other Expenses Budgeting Process | 00:03:00 | ||
| Capital Expenditure Budgeting | 00:05:00 | ||
| Qualitative Aspects of Budgeting | 00:04:00 | ||
| Marketing Budget | 00:04:00 | ||
| How to Make Budgets and Forecasts | 01:52:00 | ||
| Introduction to Budgeting and Forecasting During Uncertainty | 00:03:00 | ||
| Causes of Uncertainty | 00:04:00 | ||
| Change the Purpose of Budgeting | 00:04:00 | ||
| Budgeting for Strategic Success | 00:04:00 | ||
| Key Aspects of Strategic Budgeting | 00:05:00 | ||
| How Often We should do Budgeting | 00:06:00 | ||
| 5 Principles of Business Planning During Uncertainty | 00:05:00 | ||
| Alternative Options for Annual Budget | 00:07:00 | ||
| Topic 12: Cashflow Management and Forecasting | |||
| Module 01 | |||
| Introduction | 00:03:00 | ||
| What is Cashflow? | 00:04:00 | ||
| Forecasting | 00:07:00 | ||
| Planning and Management | 00:05:00 | ||
| Planning Part 2 | 00:12:00 | ||
| Module 02 | |||
| Where it can go Wrong | 00:09:00 | ||
| Personal Cashflow Analysis | 00:05:00 | ||
| Personal Cashflow Analysis my Numbers Story | 00:06:00 | ||
| Debt | 00:10:00 | ||
| Conclusion | 00:04:00 | ||
| Topic 13: Raising Money & Valuations | |||
| Raising Money & Valuations | |||
| Traditional Capital Raising | 00:07:00 | ||
| Startup Financing and Stages | 00:15:00 | ||
| Early Stage Financing – Own capital, crowdfunding and leasing | 00:13:00 | ||
| Early Stage FInancing – Angel Investing, VC Capital | 00:17:00 | ||
| Why we need valuation and is it objective | 00:07:00 | ||
| Business Valuation Concepts | 00:07:00 | ||
| process of valuations and factors that affect valuations | 00:11:00 | ||
| Valuation Methods and Market Approach | 00:13:00 | ||
| Income Valuation Approach | 00:09:00 | ||
| Discounting rate and how we determine it | 00:13:00 | ||
| Other Methods of valuation and Conclusion | 00:18:00 | ||
| Assignment | |||
| Assignment – Raising Money & Valuations | 00:00:00 | ||
| Topic 14: Cost Control & Project Scheduling | |||
| Chapter 1 | |||
| Monitoring and Controlling Fundamentals | 00:45:00 | ||
| Chapter 2 | |||
| Schedule Control | 00:55:00 | ||
| Chapter 3 | |||
| Cost Control | 00:43:00 | ||
| Assignment | |||
| Assignment – Cost Control & Project Scheduling | 00:00:00 | ||
| Topic 15: Mini MBA | |||
| Module 01: Appreciating the Mini MBA | |||
| Appreciating the Mini MBA | 00:10:00 | ||
| Module 02: The Foundations of Business | |||
| The Foundations of Business | 00:10:00 | ||
| Module 03: Understanding Business Law | |||
| Understanding Business Law | 00:00:00 | ||
| Module 04: Competitive Business Strategies | |||
| Competitive Business Strategies | 00:10:00 | ||
| Module 05: Departments in Business | |||
| Departments in Business | 00:10:00 | ||
| Module 06: Planning the Right Strategy for Business | |||
| Planning the Right Strategy for Business | 00:05:00 | ||
| Module 07: Managing Human Resources in Business | |||
| Managing Human Resources in Business | 00:10:00 | ||
| Module 08: Economics Influences on Business | |||
| Economics Influences on Business | 00:10:00 | ||
| Module 09: Business Accounting | |||
| Business Accounting | 00:10:00 | ||
| Module 10: Finance in Business | |||
| Finance in Business | 00:10:00 | ||
| Module 11: Business Marketing | |||
| Business Marketing | 00:10:00 | ||
| Module 12: Advertising and Promotion | |||
| Advertising and Promotion | 00:10:00 | ||
| Module 13: The Art of Negotiation | |||
| The Art of Negotiation | 00:05:00 | ||
| Module 14: Communication and Presentation | |||
| Communication and Presentation | 00:05:00 | ||
| Module 15: Organisational Behaviour in Business | |||
| Organisational Behaviour in Business | 00:10:00 | ||
| Module 16: Building Teams in Business | |||
| Building Teams in Business | 00:05:00 | ||
| Module 17: Business Leadership | |||
| Business Leadership | 00:05:00 | ||
| Module 18: Operations Management | |||
| Operations Management | 00:15:00 | ||
| Module 19: The Importance of Risk Management | |||
| The Importance of Risk Management | 00:10:00 | ||
| Module 20: Project Management | |||
| Project Management | 00:05:00 | ||
| Module 21: Quantitative Research and Analysis | |||
| Quantitative Research and Analysis | 00:05:00 | ||
| Module 22: Qualitative Research and Analysis | |||
| Qualitative Research and Analysis | 00:05:00 | ||
| Module 23: Becoming an Entrepreneur | |||
| Becoming an Entrepreneur | 00:05:00 | ||
| Module 24: Corporate Social Responsibility (CSR) | |||
| Corporate Social Responsibility (CSR) | 00:10:00 | ||
| Module 25: Avoiding Management Mistakes | |||
| Avoiding Management Mistakes | 00:05:00 | ||
| Topic 16: Business Accounting Training | |||
| Professional Bookkeeper Introduction | |||
| Professional Bookkeeper | 00:09:00 | ||
| Introduction to Accounting and Business | |||
| Defining a Business | 00:07:00 | ||
| Ethics in Accounting | 00:05:00 | ||
| Generally Accepted Accounting Principles (GAAP) | 00:10:00 | ||
| The Accounting Equation | |||
| The Accounting Equation | 00:07:00 | ||
| Transactions | 00:11:00 | ||
| Analyzing Transactions | |||
| The Accounting Equation and Transactions | 00:16:00 | ||
| Double-Entry System | 00:12:00 | ||
| Transactions – Journalizing | 00:17:00 | ||
| Entering Information - Posting Entries | |||
| Posting Entries | 00:10:00 | ||
| The Trial Balance | 00:10:00 | ||
| Finding Errors Using Horizontal Analysis | 00:09:00 | ||
| Horizontal Trend : Balance Sheet | 00:21:00 | ||
| Horizontal Trend: Income Statement | 00:36:00 | ||
| Adjusting Process | |||
| The Purpose of the Adjusting Process | 00:15:00 | ||
| Adjusting Entries | |||
| Adjusting Entries – Prepaid Expenses | 00:13:00 | ||
| Adjusting Entries – Accrued Revenues | 00:10:00 | ||
| Adjusting Entries – Depreciation Expense | 00:09:00 | ||
| Adjustment Summary | |||
| Adjustment Summary – Review | 00:13:00 | ||
| Vertical Analysis | 00:33:00 | ||
| Preparing a Worksheet | |||
| Preparing a Worksheet | 00:06:00 | ||
| Financial Statements | |||
| The Income Statement | 00:11:00 | ||
| Financial Statements – Definitions | 00:12:00 | ||
| Completing the Accounting Cycle | |||
| Temporary vs. Permanent Accounts | 00:19:00 | ||
| The Accounting Cycle Illustrated | |||
| Accounting Cycle Illustrated – Steps 1-5 | 00:11:00 | ||
| Accounting Cycle Illustrated – Steps 6-1 | 00:12:00 | ||
| Fiscal Year | |||
| Fiscal Year | 00:09:00 | ||
| Spreadsheet Exercise | |||
| Spreadsheet Exercise – Steps 1-4 | 00:11:00 | ||
| Spreadsheet Exercise – Steps 5-7 | 00:37:00 | ||
| Mock Exam | |||
| Mock Exam- Business Accounting Training | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Business Accounting Training | 00:20:00 | ||
| Topic 17: Financial Analysis: Finance Reports | |||
| Financial Analysis: Reading Financial Statements like a Pro | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| What is a 10-K? | 00:07:00 | ||
| Evaluating Profitability by Analyzing the Income Statement | 00:19:00 | ||
| Evaluating Operations: Tying Operating Metrics to Financial Results | 00:07:00 | ||
| Evaluating Financial Strength: Balance Sheet Analysis | 00:14:00 | ||
| Evaluating Cash Flow Generation | 00:09:00 | ||
| Performing Investment Analysis | 00:15:00 | ||
| Assignment | |||
| Assignment – Financial Analysis: Finance Reports | 00:00:00 | ||
| Topic 18: Presenting Financial Information | |||
| Presenting Financial Information | |||
| Module 01: Presenting Financial Information | 00:06:00 | ||
| Module 02: The Hierarchy of Performance Indicators | 00:05:00 | ||
| Module 03: The Principle of Effective Reports | 00:06:00 | ||
| Module 04: Guidelines for Designing Management Reports | 00:05:00 | ||
| Module 05: Methods of Presenting Performance Data | 00:04:00 | ||
| Module 06: The Control Chart: Highlighting the Variation in the Data | 00:07:00 | ||
| Module 07: The Pareto Chart: Highlighting Priorities | 00:01:00 | ||
| Module 08: Exercise: The Control Chart | 00:05:00 | ||
| Module 09: An Example Management Report | 00:03:00 | ||
| Module 10: Interpreting Performance Data | 00:04:00 | ||
| Module 11: Supporting Colleagues by Giving Feedback | 00:05:00 | ||
| Module 12: Data Visualisation Part 01 | 00:09:00 | ||
| Module 13: Data Visualisation Part 02 | 00:07:00 | ||
| Module 14: Data Visualisation Part 03 | 00:09:00 | ||
| Module 15: Data Visualisation Part 04 | 00:04:00 | ||
| Module 16: Final Thoughts on Presenting Financial Information | 00:04:00 | ||
| Assignment | |||
| Assignment – Presenting Financial Information | 00:00:00 | ||
| Topic 19: Finance: Financial Risk Management | |||
| Finance: Financial Risk Management | |||
| Lesson 01: Introduction | 00:01:00 | ||
| Lesson 02: Derivatives-Concepts and types of derivatives | 00:09:00 | ||
| Lesson 03: Future contracts, understanding future concepts deviating risks | 00:07:00 | ||
| Lesson 04: Settlement in future markets | 00:13:00 | ||
| Lesson 05: Option contracts, call option, Analysis of Holder and Writer in call option | 00:16:00 | ||
| Lesson 06: Put option, Analysis of Holder and writer in put option | 00:11:00 | ||
| Lesson 07: Types of options in the expiration date | 00:09:00 | ||
| Topic 20: Financial Modelling Course – Learn Online | |||
| Financial Modelling | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| Planning your Financial Model | 00:09:00 | ||
| Building a Model Template | 00:12:00 | ||
| Projecting the Income Statement | 00:13:00 | ||
| Projecting the Balance Sheet | 00:17:00 | ||
| Projecting Cash Flows | 00:14:00 | ||
| Advanced Financial Modeling | 00:14:00 | ||
| BONUS LESSON: Top 5 Excel Features for Financial Modellers | 00:08:00 | ||