9 Business Analysis courses in Birmingham

OVERVIEW -------------------------------------------------------------------------------- Objective * Understanding the Importance of Business Analysis Model * Determining various techniques of Process Modelling * Understanding the scope of modelling * Efficiently mapping the business landscape * Analysing the enterprise structure * How to avoid project failures. * Learning efficient skills of being a successful business analyst. * Understand and document various techniques for the organization delivers value. * Successful project conversion * Building team, changing the organization and overcoming resistance. * Creating an effective Business Case.

In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility.

This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, follow a methodical workflow to develop sound solutions, use open-source, off-the-shelf tools to develop, test, and deploy those solutions, and ensure that they protect the privacy of users. This course includes hands-on activities for each topic area.

OVERVIEW -------------------------------------------------------------------------------- This course is specially designed to increase the fundamental knowledge of business analysts and their roles and functions more efficiently. In this course, participants attain skills and knowledge of efficient ways to approach, the best methods to elaborate the supplies for business system projects.

QUERYING MICROSOFT SQL SERVER COURSE DESCRIPTION This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. WHAT WILL YOU LEARN * Write SELECT statements. * Create and implement views and table-valued functions. * Transform data by implementing pivot, unpivot, rollup and cube. * Create and implement stored procedures. * Add programming constructs such as variables, conditions, and loops to T-SQL code. QUERYING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. * Prerequisites: Database fundamentals * Duration 5 days QUERYING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. * T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. * Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. * Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. * Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. * SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. * DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. * Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions * Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. * Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. * Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. * Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. * Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. * Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets * Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. * Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL * Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. * Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

ABOUT THIS TRAINING COURSE More energy companies today are setting ambitious net-zero targets and are expected to pour billions into the voluntary carbon offset market by the end of this decade. To get to net zero emissions, companies will need to balance emissions with nature and technology-based offsets. Markets are the best tool for connecting carbon sources and sinks. Many countries will not have enough supply inside their borders and will need to co-operate with those who have extra greenhouse gas removal potential. The energy industry is in search of effective climate tools as pressure mounts from investors and consumers for more progress on fighting rising emissions. Corporations fighting to cut their carbon footprint have for years focused on internal reduction measures. Many are now adding to that effort by turning to carbon credits, a process made easier as verification and registration tools mature. One particular category of carbon offsets leads the way: high-quality, nature-based carbon credits. These represent the largest category of carbon credit projects in the voluntary carbon market, comprising nearly half of credits issued. Public concern about this practice focused on the additionality, leakage, and integrity of carbon offsets that are created through reforestation, land preservation, carbon capture and other projects. Lack of standardization and government regulation has also increased uncertainty for all participants in carbon markets, creating risks for developers of credit-generating projects and offset purchasers. Demand for higher-quality offsets will value projects that were subjected to due diligence and rely upon reputable third-party verification. Companies purchasing offsets generated by permanent and quantifiable projects will therefore be in the best position moving forward. In this highly interactive training course, your course instructor will guide you through the latest developments and best procurement practices to successfully operate in the voluntary carbon market. Training Objectives At the end of this course, the participants will be able to: * Discover the current state of the carbon economy * Gain insights into the voluntary carbon market * Learn about the different type carbon credits available * Examine how companies can reach net zero target by using carbon offsets * Uncover best practices in carbon credit procurement strategy * Learn the pricing dynamics carbon credits * Examine how to identify and ensure high quality credits * Obtain key learning from flawed carbon offset projects Target Audience This course is intended for: * Energy transition team leaders * Carbon credit procurement professionals * ESG strategy team leaders * Finance and accounting professionals * Low carbon business analysts or economists * Corporate business sustainability professionals * Legal, compliance and regulatory professionals * Carbon trading professionals Course Level * Intermediate Trainer Your expert course leader is a skilled and accomplished professional with over 25 years of extensive C-level experience in the energy markets worldwide. He has a strong expertise in all the aspects of (energy) commodity markets, international sales, marketing of services, derivatives trading, staff training and risk management within dynamic and high-pressure environments. He received a Master's degree in Law from the University of Utrecht in 1987. He started his career at the NLKKAS, the Clearing House of the Commodity Futures Exchange in Amsterdam. After working for the NLKKAS for five years, he was appointed as Member of the Management Board of the Agricultural Futures Exchange (ATA) in Amsterdam at the age of 31. While working for the Clearing House and exchange, he became an expert in all the aspects of trading and risk management of commodities. In 1997, he founded his own specialist-consulting firm that provides strategic advice about (energy) commodity markets, trading and risk management. He has advised government agencies such as the European Commission, investment banks, major utilities and commodity trading companies and various energy exchanges and market places in Europe, CEE countries, North America and Asia. Some of the issues he has advised on are the development and implementation of a Risk Management Framework, investment strategies, trading and hedging strategies, initiation of Power Exchanges (APX) and other trading platforms, the set-up of (OTC) Clearing facilities, and feasibility and market studies like for the Oil, LNG and the Carbon Market. The latest additions are (Corporate) PPAs and Artificial Intelligence for energy firms. He has given numerous seminars, workshops and (in-house) training sessions about both the physical and financial trading and risk management of commodity and carbon products. The courses have been given to companies all over the world, in countries like Japan, Singapore, Thailand, United Kingdom, Germany, Poland, Slovenia, Czech Republic, Malaysia, China, India, Belgium and the Netherlands. He has published several articles in specialist magazines such as Commodities Now and Energy Risk and he is the co-author of a book called A Guide to Emissions Trading: Risk Management and Business Implications published by Risk Books in 2004. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

ISTQB® FOUNDATION TRAINING COURSE (2 persons minimum) The aim of this course is to provide you with the knowledge and skills to pass an exam certifying you as an ISTQB® Certified Tester - Foundation Level. Most organisations require this certification as a minimum skill requirement for software testers. In this course you will learn a standardized approach to software testing that will be immediately applicable to your projects. In order to get the certification you will be required to pass a 60-minute exam. Our trainers will fully prepare you by employing scenarios that mirror the exam questions, and by focusing course delivery with a balance of theory and practice. Target group: Functional Tester, Agile Tester, User Acceptance Tester, Test Automation Specialist, Performance Testing Specialist, Testing Team Lead, Test Manager, Business analyst Prerequisites: There are no specific prerequisites for this course. This course is suitable for anyone involved in software testing. Duration: 3 days. Training objectives: * Learn aspects of test planning, estimation, monitoring and control. * Understand and use international standards and terminology. * Understand and implement effective testing techniques. * Be well prepared for the exam. * Identify the missing testing skills for the career development purposes. This course covers the following areas: * Fundamentals of software testing * Testing throughout the life cycle (software development models, test levels, test types) * Test design techniques (e.g. specification-based or black-box techniques, structure-based or white-box techniques) * Static testing (static testing techniques, review process, tool-assisted static analysis) * Test management (test organisation, test planning and estimation, test progress monitoring and control, risks) * Tools to support testing (types, benefits and risks) Language: English

Businesses that don't control their costs don't stay in business. How well are you doing? Is everyone in your organisation sufficiently aware of costs, managing them effectively and maximising opportunities to reduce them? If there is scope for improvement, this course will help get you back on track. It will demonstrate that cost reduction is so much more than cost control and cost cutting. True cost management is about being aware of costs, seeking to reduce them through good design and efficient operating practices whilst taking continuing action on overspending. This course will develop the participants' skills in: * Being aware of costs at all times * Seeking cost reduction from the start (including life-cycle costing) * Appraising projects / production to identify and take out risk * Understanding real budgeting * Using techniques such as ZBB and ABC where appropriate * Ensuring cost reports lead to action * Managing a cost reduction process that delivers Benefits to the organisation will include: * Identification of cost reduction and business improvement opportunities * Better reporting and ownership of costs * Greater awareness and control of everyday costs 1 INTRODUCTION - THE COST MANAGEMENT PROCESS * The risks of poor cost control * Capital and revenue costs * The importance of cost awareness * The importance of cost reduction * Cost management - the key aspects * How to build a cost management and control process checklist for your areas of responsibility 2 COST REMOVAL - TAKING OUT COSTS * Cost awareness * Costs of poor design / poor processes * Value engineering * Removing redundant costs 3 THE NEED FOR COMMERCIAL, TECHNICAL AND FINANCIAL APPRAISALS * Understand the problems before cash is committed and costs incurred * Making the effort to identify commercial and technical risk * The time value of money - DCF techniques for long term projects * Cost models for production processes and projects * Costing models - project appraisals * The use of spreadsheets to identify sensitivity and risk * How to focus on risk management 4 BUDGETING - PROPER BUDGETING CHALLENGES COSTS * The philosophy of the business - are costs an issue? * The importance of having the right culture * The need for detailed business objectives * Budgetary control measures * Designing budget reports - for action 5 ZERO-BASED BUDGETING (ZBB) - THE PRINCIPLES * Much more than starting with a clean sheet of paper * What ZBB can achieve * The concept of decision packages - to challenge business methods and costs * Only necessary costs should be incurred * A review of an operating budget - demonstrating what ZBB challenges and the costs it may lead to being taken out 6 AWARENESS OF OVERHEADS AND OTHER COSTS * Definitions of cost - direct and indirect * Dealing with overheads - what is meant by allocation, absorption or apportionment? * The apparent and real problems with overheads * Different ways of dealing with overheads * Review of overhead allocation methods and accounting and reporting issues 7 OVERHEADS AND PRODUCT COSTING * Activity-based costing (ABC) - the principles * Where and how the ABC approach may be helpful * Know the 'true' cost of a product or a project * Should you be in business? Will you stay in business? * Identifying weaknesses in a traditional overhead allocation * How ABC will help improve product or service costing * Identifying which products and activities should be developed and which abandoned 8 COST REDUCTION CULTURE * The need for cost reports * What measures can be used to identify over-spends as early as possible * Cost control performance measures and ratios 9 DESIGN OF COST CONTROL REPORTS * Reports should lead to action and deliver * Selecting cost control measures which can be acted upon * Practice in designing action reports 10 COURSE SUMMARY - DEVELOPING YOUR OWN COST ACTION PLAN * Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability. This programme will help you: * Identify ways to analyse data and sort relevant from irrelevant information * Develop analytical and numerate thinking, and consider the financial implications of a decision * Make decisions based on sound commercial reasoning - a mix of intuition and analysis * Select from a range of tools to analyse a situation and apply these effectively * Understand how costs and profits are calculated * Use tried-and-tested techniques to manage and control your budgets * Appreciate the fundamentals of financial analysis * Focus on the bottom line * Identify the basics of capital investment appraisal for your business * Evaluate results and seek opportunities for improvement to your business 1 THE COMMERCIAL ENVIRONMENT * What do shareholders and investors want? * What do managers want? * Profit v non-profit organisations * Investor expectations 2 FINANCIAL AND NON-FINANCIAL INFORMATION * Risk and reward considerations * Drivers of commercial decisions 3 RUNNING A BUSINESS * A practical exercise to bring financial statements to life * Different stakeholder interests in a business * The impact and consequences of decisions on financial statements 4 WHERE DO I MAKE A DIFFERENCE TO THE ORGANISATION? * How can I contribute to an improved business performance? * Key performance indicators - measuring the right things * A 'balanced scorecard' approach - it's not all about money! 5 A 'BALANCED SCORECARD' APPROACH * Analysing and reviewing my contribution to the business direction * What is the current focus of my commercial decisions? * Developing the business in the right way - getting the balance right! * Where should/could it be in the future? * Do my decisions support the overall vision and strategy? 6 MAKING COMMERCIAL DECISIONS * Left-brain and right-brain thinking * Convergent and divergent thinking * Analysis and instinct * Interactive case study exercise - emotional and rational decisions * Reflection - what is my style of making decisions 7 LET'S CONSIDER THE CUSTOMER! * Identifying target markets * Differentiating propositions and products * Customer service considerations * Marketing considerations and initiatives * Pricing strategies and considerations 8 STRATEGIC ANALYSIS * The external environment * The internal environment * LEPEST analysis * SWOT analysis * Forecasting * Group activity - analysing markets and the competition * How do these improve your decisions? 9 COMPARING PERFORMANCE * Analysing key financial ratios * Ways to compare performance and results * Break-even analysis 10 PROFIT AND LOSS ACCOUNTS AND BUDGETING * Managing income and expenditure * The budgeting process * How does this link to the profit and loss account? * Managing and controlling a cost centre/budget * The role of the finance department * Different ways of budgeting * Incremental budgeting * Zero-based budgeting 11 UNDERSTANDING THE BALANCE SHEET * Purpose of balance sheets * Understanding and navigating the content * What does a balance sheet tell you? * How do you affect your balance sheet? * Links to the profit and loss account * A practical team exercise that brings financial statements to life 12 BUSINESS DECISIONS EXERCISE * How does this improve your decisions? * A practical exercise to apply new knowledge and bring commercial thinking to to life * The impact and consequences of decisions on financial statements 13 WORKING CAPITAL * Why is this important? * The importance of keeping cash flowing * Business decisions that affect cash * Calculating profit 14 CAPITAL INVESTMENT APPRAISAL * Capex v Opex * Payback * Return on investment * The future value of money * The concept of hurdle rate 15 LESSONS LEARNED AND ACTION PLANNING * So what? * Recap and consolidation of learning * The decisions that I need to consider * Actions to achieve my plan