Project Contract Management Skills: In-House Training Contracts are a critical part of most large or strategic projects/programs. As such, it is imperative that Project and Program Managers be well versed on basic implications of a contract as well as best practices in contract management. While not as critical a need, anyone involved in projects that involve external relationships should have a healthy appreciation for the power of good contract management. The overall goal of the course is to provide knowledge to manage complex contracts in a global environment. What You Will Learn After this program, you will be able to: Explain overall project procurement process from a buyer and seller perspective Recognize the importance of key contractual terms and how they affect projects Evaluate and contribute to the pre-contract documents and processes Identify and mitigate common pitfalls throughout the procurement process Utilize techniques to administer contracts Getting Started Introductions Course structure Course goals and objectives Foundation Concepts The Importance of Contract Management Terms and Definitions Contract Management Process Legal Systems Codes of Conduct Planning Business Analysis Procurement Management Plan Procurement Statement of Work (SOW) Common Pitfalls Solicit Contract Market Analysis Bid documents Sellers' Proposals Pitfalls Execute Contract Evaluate and Award Contract Negotiate Contract Execute Contract Common Pitfalls Deliver the Contract Preparing to Deliver Project Plan Risk Management Common Pitfalls Administer Contract Enabling Contract Management Contract Performance Monitoring and Control Change Management Financial Management / Payment Dispute Management & Resolution Contract Completion and Closure
24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! This Advanced Diploma in Data Analytics with Tableau at QLS Level 6 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Data Analytics with Tableau at QLS Level 6 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Data Analytics with Tableau at QLS Level 6 course. Due to Data Analytics with Tableau at QLS Level 6's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Data Analytics with Tableau at QLS Level 6 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Data Analytics with Tableau at QLS Level 6 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Data Analytics with Tableau at QLS Level 6 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Data Analytics with Tableau at QLS Level 6 course. This Data Analytics with Tableau at QLS Level 6 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Data Analytics with Tableau at QLS Level 6 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Data Analytics with Tableau at QLS Level 6 course: Module 01: Introduction to the Course Module 02: Project 1: Discount Mart (Sales and Profit Analytics) Module 03: Project 2: Green Destinations (HR Analytics) Module 04: Project 3: Superstore (Sales Agent Tracker) Module 05: Northwind Trade (Shipping Analytics) Module 06: Project 5: Tesla (Stock Price Analytics) Module 07: Bonus: Introduction to Database Concepts Module 08: Tableau Stories Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Advanced Diploma in Data Analytics with Tableau at QLS Level 6 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Analytics with Tableau at QLS Level 6 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Data Analytics with Tableau at QLS Level 6 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Advanced Diploma in Data Analytics with Tableau at QLS Level 6 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Data Analytics with Tableau at QLS Level 6 , you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included
Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders working with analysts, Quality and process engineers, technicians, corrective action coordinators or managers; supervisors, team leaders, and process operators; anyone who wants to improve their ability to solve recurring problems. Overview At the completion of this course, you should be able to: Identify the different types of tools and techniques available Apply change management successfully Review what to look for when applying business case thinking to Root Cause Analysis Develop a process to systematically approach problems Business success is dependent on effective resolution of the problems that present themselves every day. Often the same or similar problems continue causing repeated losses in time or money and your staff become experts at fixing rather than preventing the problems. Learn to find and fix root causes and develop corrective actions that will effectively eliminate or control these problems. Section 1: RCA Foundation Concepts and Objectives Section Learning Objectives Discuss Definitions ? IT Perspective Discuss What is a problem and why do they exist? What is Root Cause? RCA Benefits and Approaches Event and Casual Analysis Event and Causal Analysis: Exercise 1c Worksheet RCA Tools for each approach Section Summary and Conclusions Section 2: Enhance use of RCA tools Why use a Particular Method Tool: Change Analysis Change Analysis Examples Tool: How to Resolve Conflict Tool: 5 Why?s Example Learning Management Problem Tool: Cause and Effect Tool: Fault Tree Analysis Why do we use Fault Tree Analysis? How does it work? Fault Tree Diagram Symbols Example #1 of FTA: Car Hits Object Tool: Failure Modes and Effects Analysis (FMEA) Example: Failure Modes and Effects Analysis Tool: Design / Application Review Section 3: Problem Resolution and Prevention Section Objectives The Secret of Solving Problems: -A Note about Statistical Control -A Note about Fire Fighting Technique: Business Process Mapping Example: IGOE Technique: Lean Six Sigma and DMAIC Lean Six Sigma Benefits Importance of Understanding the Business Process The Business Process Mandate Technique: Process Modeling Graphical Notation Standard (BPMN): -What is Business Process Modeling Notation (BPMN)? -Benefits of BPMN -Basic Components of BPMN Technique: Business Process Maturity Model Five Levels of Maturity Section 4: Capability Improvement for RCA Steps in Disciplined Problem Solving RCA as a RCA Process Key RCA Role Considerations Sustainable RCA Improvement Organizational Units Process Area Goals, Practices Specific and General Practices Specific Practice Examples Software Maturity Survey SWOT Analysis Worksheet Recognize the importance of the Change Management component in your RCA implementation Using the ADKAR Model to Communicate Change Review ADKAR© Model ? -Awareness of the need for change -Desire to participate and support the change -Knowledge on how to change -Ability to implement required skills and behaviors -Reinforcement to sustain the change The ADKAR Model: Reinforcement Section 5: Course Summary and Conclusions Plan the Proposal and Business Case Example: 1 Page Business Case Resource Guide Questions
Excel 2016 Formulas and Functions Course Overview: This course is designed to provide learners with a comprehensive understanding of Excel 2016 formulas and functions. By covering essential tools and techniques, the course enables learners to confidently navigate the Excel environment and utilise formulas for data analysis, calculations, and reporting. With a focus on both fundamental and advanced functions, learners will gain the skills needed to streamline their tasks and improve efficiency in the workplace. The course’s practical value lies in its application across various industries, allowing professionals to enhance their data handling and reporting capabilities, making it an invaluable addition to any skill set. Course Description: The "Excel 2016 Formulas and Functions" course covers the core concepts of using Excel formulas and functions to manage and analyse data. It starts with the basics, such as SUM, AVERAGE, and IF functions, before advancing to more complex tools like VLOOKUP and conditional formatting.Through each module, learners will explore how to use these features to automate calculations, create dynamic reports, and manipulate datasets. The course offers a structured approach to mastering Excel, with clear guidance on how to use each function effectively in a business context. Learners will come away with the knowledge to work more efficiently in Excel, enabling them to make informed data-driven decisions and enhance productivity. Excel 2016 Formulas and Functions Curriculum: Module 01: Getting Started with Microsoft Excel 2016 Module 02: Basic Formulas and Functions Module 03: Formulas and Functions Activities (See full curriculum) Who is this course for? Individuals seeking to improve their Excel skills Professionals aiming to enhance their data analysis capabilities Beginners with an interest in data management and analysis Any other individuals looking to gain proficiency in Excel Career Path: Data Analyst Administrative Assistant Financial Analyst Business Analyst Project Coordinator
The aim of the course Stock Analysis and Valuation is to provide students with a deep understanding of how to evaluate the financial health and value of publicly traded companies.After the successful completion of the course, you will be able to learn about the following, Understand the valuation of Stocks using Macro and Micro Valuations. Understand the use of Absolute Valuation or Discounted Cash Flow methods. Learn concepts in Stock Portfolio Management. The course "Stock Analysis and Valuation" is designed to provide students with a comprehensive understanding of the techniques and methods used in analyzing and valuing publicly traded companies. The course will cover the fundamental principles of financial analysis, competitive analysis, and valuation, and will provide students with practical skills in financial modeling, forecasting, and valuation. The course "Stock Analysis and Valuation" is designed to provide students with a comprehensive understanding of the techniques and methods used in analyzing and valuing publicly traded companies. The course will cover the fundamental principles of financial analysis, competitive analysis, and valuation, and will provide students with practical skills in financial modeling, forecasting, and valuation. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Stock Analysis and Valuation Self-paced pre-recorded learning content on this topic. Stock Analysis and Valustion Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Equity Analyst Investment Analyst Financial Analyst Valuation Specialist Portfolio Manager Research Analyst Fund Manager Asset Manager Investment Banker Private Equity Analyst Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
This course provides a holistic understanding of People Analytics by exploring data collection, analysis, and visualisation. From improving workforce dynamics to addressing ethical considerations, participants gain insights into leveraging analytics for strategic HR practices.After the successful completion of the course, you will be able to learn about the following, Define People Analytics and distinguish it from traditional HR practices. Explain the benefits of using People Analytics in organizations. Identify the key concepts and techniques used in People Analytics, such as data collection, analysis, and visualization. Understand how People Analytics can be used to improve workforce performance, retention, and engagement. Analyze the challenges associated with implementing People Analytics in organizations, such as data privacy and ethical considerations. Appreciate the role of People Analytics in a data-driven organization and its potential impact on business outcomes. Evaluate case studies and examples of successful implementation of People Analytics in different industries. This course illuminates the realm of People Analytics, differentiating it from traditional HR practices. Participants delve into key concepts, techniques, and benefits, equipping them to harness data for enhanced workforce performance, retention, and engagement. The course addresses challenges and explores People Analytics' pivotal role in shaping data-driven organizational strategies. This comprehensive course empowers participants to define, implement, and leverage People Analytics effectively. Covering key concepts, techniques, and real-world case studies, it prepares professionals to navigate the complexities of data-driven HR practices and contribute to organizational success. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to People Analytics Self-paced pre-recorded learning content on this topic. People Analytics Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be an added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone who is eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. People Analytics Specialist HR Data Scientist Workforce Performance Analyst Employee Engagement Strategist HR Analytics Consultant Data-Driven HR Manager Organizational Insights Analyst Talent Retention Analyst Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.
Course Overview This comprehensive course on "Data Analysis and Forecasting in Excel" provides learners with essential skills to manage, analyse, and visualise data effectively using Excel. Whether you are analysing historical data or forecasting future trends, this course covers key tools such as PivotTables, charts, and lookup functions to make your data work for you. Learners will also gain proficiency in automating tasks and creating dynamic reports, which are invaluable for decision-making processes in various professional settings. By the end of the course, you will have the capability to work with complex data sets, produce insightful reports, and apply forecasting techniques to guide future strategies. Course Description In this course, learners will delve into the full spectrum of data analysis capabilities offered by Excel. Topics include modifying worksheets, working with lists, and using advanced tools such as PivotTables, PivotCharts, and lookup functions. Learners will explore the process of visualising data through charts and sparklines, allowing them to convey complex information in an accessible manner. The course also covers automating workbook functionality and creating mapping data for better analysis. Additionally, learners will gain expertise in forecasting data trends to support strategic planning. By the end of the course, participants will have developed a comprehensive understanding of Excel’s analytical tools, enabling them to manage data with efficiency and precision in various business contexts. Course Modules Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08: Automating Workbook Functionality Module 09: Creating Sparklines and Mapping Data Module 10: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel data analysis skills. Professionals aiming to improve their forecasting and reporting capabilities. Beginners with an interest in data management and analysis. Those seeking to enhance their proficiency in Excel for career advancement. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Project Manager Excel Specialist in various industries such as finance, marketing, and logistics
Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist
Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist