51167 Courses delivered Online

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

Managing Multiple Projects: On-Demand Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Are your projects taking longer and longer to complete? Are results less than optimal because of time pressures on resources? Would you like to increase project 'throughout'? Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Planning and managing individual projects is challenging. When introducing the real-life limitation of resources and other outside influences into the multi-project environment, those challenges are magnified, and new challenges are introduced. This interactive workshop will position you for immediate action. The goal of this course is to equip you with the necessary knowledge, skills, and techniques so that you can effectively and productively manage multiple projects. What you Will Learn You'll learn how to: Manage stakeholder relationships and expectations Prioritize and sequence multiple projects Manage time and stress within a multiple project environment Effectively manage logical dependencies among projects Optimize the use of resources across multiple projects using concepts from Critical Chain methods Manage risk and communications in a multiple project environment Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Portfolio, program, and project management principles The multiple project environment The MMP Process Model Developing the Multiple Project List Multiple project portfolio management Project selection Project categories and types The multiple project list Multiple Project Logical Dependencies Project dependencies Types of multiple project portfolios Categories of logical dependencies across multiple projects Project priorities in the multiple project schedule Multiple Project Resource Management Multiple project resources and resource management concepts Multiple project resource loading Resource pool and resource database Multiple project resource issues and outsourcing Critical chain resource management, including drum resources and multi-tasking Managing Risk Across Multiple Projects Multiple project risk management process Identifying, assessing, and responding to multiple project risks Critical chain and multiple project risks Risk interrelationship management methods Creating and Executing the Multiple Project Plan The multiple project plan Multiple project scheduling Multiple project budgeting Executing and maintaining the multiple project plan Controlling in the multiple project environment Tools in multiple project management Multiple Project Communications Effective communication in the multiple project environment Common communication barriers Multiple project communications plan Resolving multiple project conflicts Summary and Next Steps What did we learn, and how can we implement this in our work environments?

Portfolio Management Skills: On-Demand Project Management Institute (PMI)® Charter Global Registered Education Provider (R.E.P.) International Institute for Learning (IIL) has been reviewed and approved as a provider of project management training by PMI®. Become a strong, effective change advocate for meaningful portfolio management. This course is designed to equip and enable you to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in your organization. It focuses on helping you become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards. What you Will Learn At the end of this program, you will be able to: Articulate the benefits of portfolio management Link the initiatives in an organization with its strategic objectives Participate in the introduction of portfolio management in an organization Create or improve the portfolio governance structure Lead the inventory of ongoing and new initiatives Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools Support the executives in balancing the portfolio based on the optimal use of resources and priorities Create a portfolio delivery plan Define thresholds and variance reporting criteria Assist the executives and the financial team in the definition of Stage Gate Funding Lead the Stage Gate reviews Analyze the benefits that are being realized by the initiatives Foundation Concepts Definitions Benefits of Portfolio Management Objectives of Portfolio Management Portfolio Life Cycles Governing the Portfolio Portfolio Governance structure Roles and responsibilities Initial activities when starting portfolio management Prioritizing Initiatives Prioritize purpose Multi-Criteria Analysis Analytical Hierarchy Process (AHP) Strategic alignment Balancing the Portfolio Allocating resources and budgets Communicating decisions of initiatives status Planning the Portfolio Planning review cycles Using Stage Gate Funding Setting thresholds and variance reporting Tool examples Managing the Portfolio Delivery Project and Program Life Cycles Stage Gate Reviews Loop back to Prioritize, Balance and Plan Interaction with the Portfolio Delivery Board Project, Program and Functional Managers' roles and responsibilities

Vendor Relationship Management: On-Demand A successful project is dependent upon the contribution of vendors. After the selection and procurement of a vendor has occurred, the project manager assumes the responsibility for managing the vendor relationship. Managing vendor performance and the vendor relationship can make or break a project. Through case scenarios and an interactive workshop approach, this program deals with the challenging task of delivering a successful project involving significant vendor contributions. What You Will Learn You'll learn how to: Determine stakeholder interests, impact on the project, and requirements Explain the process of planning for and preparing a contract Describe best practices for managing the quality of products and services Identify key techniques for managing vendor relationships Take proactive steps to ensure good working relationships with third parties Emphasize quality in the work performed by external resources Engage in requirements gathering and management Understand Agreements, Statements of Work, Letters of Intent and Contracts Develop an effective contract change control process Discuss the steps for closing a contract Getting Started Introductions Course structure Course goals and objectives Stakeholder Relationships Identifying stakeholders Planning stakeholder management Managing stakeholder engagement Controlling stakeholder engagement Event: Worksheet: What Are Your Issues with Stakeholders? Understanding the Procurement Process Planning procurement management Conducting procurements Controlling procurements Closing procurements Event - Discuss the project's outsourced scope and qualities of an ideal vendor and customize a set of criteria for this project including descriptions and weightings Requirements Gathering and Management Requirements gathering Requirements management Managing relationships Contract change control Change management Event - Small Group Activity: Identifying Gaps in the Requirements Process Agreements, Statements of Work, Letters of Intent and Contracts Contract controls Agreements Contracts Negotiations Closing the contract Contract termination Procurement Audits and Lessons Learned Event - Class Activity: Win-Win Negotiating Summary and Next Steps What did we learn, and how can we implement this in our work environments?

Global Project Management: On-Demand In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. In today's increasingly global environment, managing a project with customers and support organizations spread across multiple countries and continents is a major challenge. From identifying stakeholders and gathering requirements, to planning, controlling, and executing the project, the basic logistics of a global project present their own standard challenges. However, with additional cultural, language-based, and regional elements, global projects involve more complexities than teams often realize. There are unique communication needs, cultural awareness elements, varying customs and work expectations, and critical legal differences to consider. In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. This will leverage you to problem solve differently on global projects, prevent problems, and ensure success. The goal is for you to effectively navigate the challenges of leading projects with multi-regional footprints and globally diverse sets of stakeholders. What you Will Learn At the end of this program, you will be able to: Determine when a project meets the criteria of being a true global one Articulate global project needs based on the project grid and framework Identify and analyze global project stakeholders Recognize cultural differences and articulate how they impact project work Determine global project estimating, scheduling, and staffing challenges Assess global project risks and develop problem-solving responses Analyze complex cultural situations and align optimal project communication and negotiation tools and techniques Apply best practices for conducting virtual team work and mitigating virtual challenges Evaluate ways to control for global project scope, cost, and procurement Align customer management best practices with global customer needs Implement key global project closing activities Foundation Concepts What is a global project? What makes a global project different? A global project management framework Initiating the Global Project Launching a global project Respecting cultural differences Identifying and analyzing stakeholders Developing the communications plan Defining the ideal global project manager Crafting a global project charter Planning the Global Project Gathering requirements for a global project Defining the scope, region by region Estimating and scheduling for global projects Staffing the global project Developing the global risk management plan Executing the Global Project Managing global stakeholder expectations Embracing cultural diversity Honing global negotiation techniques Procuring goods and services on a global basis Managing global legal and regulatory issues at the micro and macro level Monitoring and Controlling the Global Project Status reporting Virtual communication Cost control Schedule control Scope control Customer satisfaction Closing the Global Project Contract closure at the macro and micro levels Administrative closure with global reach Lessons learned

The purpose of the Foundation certification is to confirm that you have sufficient knowledge and understanding to work as an informed member of a Portfolio Office or in a range of portfolio management roles. In this MoP Foundation course, participants will acquire the sufficient knowledge and understanding of the principles, cycles, practices, techniques, roles, responsibilities, documents, and organizational context within which portfolio management operates. MoP helps organizations ensure if the investments are done in the right change initiatives and implementing them correctly. This is achieved by: Prioritizing the programs and projects in terms of their contribution to the organization's strategic objectives and overall level of risk Managing the programs and projects consistently to ensure efficient and effective delivery Maximizing the benefit by providing the greatest return from the investment made

Management of Portfolios (MoP®) Foundations: On-Demand The purpose of the Foundation certification is to confirm that you have sufficient knowledge and understanding to work as an informed member of a Portfolio Office or in a range of portfolio management roles. In this MoP Foundation course, participants will acquire the sufficient knowledge and understanding of the principles, cycles, practices, techniques, roles, responsibilities, documents, and organizational context within which portfolio management operates. MoP helps organizations ensure if the investments are done in the right change initiatives and implementing them correctly. This is achieved by: Prioritizing the programs and projects in terms of their contribution to the organization's strategic objectives and overall level of risk Managing the programs and projects consistently to ensure efficient and effective delivery Maximizing the benefit by providing the greatest return from the investment made What You Will Learn Individuals certified at the MoP Foundation level will be able to: Define the scope and objectives of portfolio management and how it differs from program and project management List the benefits of applying portfolio management Explain the context it operates in List the principles upon which successful portfolio management is based on List the different approaches to implement MoP List the factors required to maintain the progress and assess the success of portfolio management State the purpose and key content of the major portfolio documents Define the scope of key portfolio management roles Introduction: MoP Scenario Background of the MethodologyThe MoP Principles Senior Management Commitment Governance Alignment Strategy Alignment Portfolio Office Energized Change Culture The MoP Definition CycleRoles and ResponsibilitiesThe MoP Delivery Cycle Management control Benefits management Financial management Risk management Stakeholder engagement Organizational governance Resource management The MoP Framework

Project Management Fundamentals - Français Many projects are managed by very efficient and very competent people who have no training in project management.They manage projects as they would manage a process improvement, the deployment of a marketing campaign, the development of a new product, the planning or implementation of an event, or many other 'tasks' referred to as projects.The 'Project Management Fundamentals' course (in English 'Project Management Fundamentals', or 'PMF') is designed to support those people who need a solid foundation of project management knowledge, without being unnecessarily overloaded by learning in addition to the usual work. The course provides a set of practices, concepts and principles that can be brought to the workplace, as well as knowledge to adapt to specific project environments.Nowadays, this relates for example to Agile or iterative methods.Thus, we recently added the key concepts of Agile to allow a basic understanding of how these two methods can possibly coexist. What You Will Learn At the end of this program, you will be able to: Use standard project management terminology. Describe the benefits and importance of strong project management. Identify the character of a successful project by a successful project manager. Recognize how agile/adaptive practices are incorporated into project management. Explore project management processes, starting, planning, executing, monitoring and controlling, and closing. Use project management processes and tools based on case studies and real-world situations. Create a first project plan. Getting Started Basic Concepts people and projects Getting started and defining requirements Use the Project Work Flowchart Manage project risks Estimations Deadlines Execute, communicate and develop the team To master Close the project Summary and Next Steps

Management of Portfolios (MoP®) Foundation: On-Demand In this MoP® Foundation course, participants will acquire the sufficient knowledge and understanding of the principles, cycles, practices, techniques, roles, responsibilities, documents, and organizational context within which portfolio management operates. MoP helps organizations ensure if the investments are done in the right change initiatives and implementing them correctly. This is achieved by: Prioritizing the programs and projects in terms of their contribution to the organization's strategic objectives and overall level of risk Managing the programs and projects consistently to ensure efficient and effective delivery Maximizing the benefit by providing the greatest return from the investment made What You Will Learn Individuals certified at the MoP Foundation level will be able to: Define the scope and objectives of portfolio management and how it differs from program and project management List the benefits of applying portfolio management Explain the context it operates in List the principles upon which successful portfolio management is based on List the different approaches to implement MoP List the factors required to maintain the progress and assess the success of portfolio management State the purpose and key content of the major portfolio documents Define the scope of key portfolio management roles Introduction: MoP Scenario Background of the Methodology The MoP Principles Senior Management Commitment Governance Alignment Strategy Alignment Portfolio Office Energized Change Culture The MoP Definition Cycle Roles and Responsibilities The MoP Delivery Cycle Management control Benefits management Financial management Risk management Stakeholder engagement Organizational governance Resource management The MoP Framework Recap