18214 Courses delivered Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Leading Cross-Cultural Virtual Teams: In-House Training High-performing teams are a must in this world of intense competition and higher expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed and suppliers and clients actively engage in joint projects. Teams work across geographical and organizational boundaries to deliver solutions and services to global users where distance and differences, both geographic and cultural, amplify the effect of issues and factors that are relatively straightforward when managing a team of people in the same location. This course delivers practical concepts and techniques that participants will start using immediately on their global projects. What you will Learn At the end of this program, you will be able to: Define relationships among foundational concepts (leadership and three dimensions of diversity) and explain their potential impacts on project performance Describe key components of successful project leadership and build selected Transformational Leadership skills Prepare to convert project challenges stemming from personal or cultural diversity into potential competitive advantage Implement selected best practices to meet key challenges facing virtual project teams Foster and grow an environment that supports continued success for CCVTs Foundation Concepts Basic definitions Critical success factors for leading cross-cultural virtual teams (CCVTs) A roadmap to success for leading CCVTs Leadership Excellence in Any Project Environment Leading effectively in a global environment Transformational leadership The four components of Transformational Leadership Leveraging Personal Diversity Overview of personal diversity Mind styles The theory of multiple intelligences Connecting Transformational Leadership and personal diversity Embracing Cultural Diversity Introduction to cultural intelligence The impact of culture Cultural Dimensions Theory The Culture Map Managing Virtual Diversity Overview of virtual diversity Virtual time management Virtual processes and technology Virtual leadership Creating an Environment for Success Supporting a cross-cultural virtual-team (CCVT-) friendly environment Building a foundation of trust Developing a team charter Recap and review Summary and Next Steps Personal action plan

The SEO & PPC Masterclass Workshop is for business owners and marketing managers who want to improve their search engine rankings, increase traffic and drive long term growth in sales.

DevOps demystified training course description This course is an introduction to DevOps. The course emphasizes communication, collaboration , integration, and automation to improve the workflow between developers and IT operations professionals. Improved workflows lead to more opportunities to design software and services in a more agile fashion. This course is a basis for discovering the most important DevOps concepts and to understand the principles and methods behind this. The course will leave you with the inspiration to be the advocate of change. What will you learn Explain DevOps principles. Describe the relationship between Agile , Lean and IT Service Management ( ITSM). Describe methods for automation and technology factors. Describe considerations when changing. Describe challenges, risks and critical success factors. DevOps demystifieds training course details Who will benefit: Non-technical staff involved with DevOps. Prerequisites: None. Duration 1 day DevOps demystified training course contents Why DevOps? From a business perspective From an IT perspective Stereotypes of Dev and Ops: perception and reality What is DevOps? Introduction DevOps Goals DevOps Added value of DevOps Proven Results DevOps for businesses DevOps principles (The Three Ways) DevOps and other frameworks DevOps and Agile DevOps and Lean DevOps and IT Service Management DevOps culture Characteristics of a DevOps culture Organizational Considerations DevOps DevOps stakeholders DevOps roles DevOps teams DevOps organizational structures DevOps methods Continuous Integration Continuous delivery Continuous deployment Value stream mapping Kanban Theory of Constraints Improvement Kata Deming's quality circle ITSM processes DevOps and Automation Methods for DevOps automation Longevity and tools categories DevOps applications Transitioning to a DevOps culture Implementation Challenges, risks and critical success factors Measuring DevOps successes

Facilitation Skills for Business Analysts: Virtual In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). Business analysts are communicators who bridge the gap between people with business needs and knowledge and the people who will provide solutions. Business analysts are continuously involved in communications with stakeholders and developers as they create the solution to business problems. They participate in information-gathering sessions including interviewing, joint requirements definition, and Joint Application Design (JAD) workshops which are used to streamline information gathering and get immediate validation from user representatives. The business analyst is also involved with negotiating the solution with the stakeholders, upper-level management, and the developers, mediating among the groups when disagreements take place, and influencing the results of decisions during the solution cycle. This course teaches the methods needed to organize and run information-gathering events. It combines the basics of graphic decision making and modeling with facilitation, communication, and meeting management skills. What you will Learn At the end of this program, you will be able to: Identify the major touch points between key BABOK® Guide knowledge areas and business analysis communication Describe the facilitation skills that are most supportive of those intersections Improve your ability to apply these skills in the context of your business analyst functions Foundation Concepts The role of the Business analyst (BA) An Introduction to the BABOK® Guide Business analyst roles and the product / project life cycle (PLC) Facilitation skills for the business analyst The BABOK® Guide and Communication An introduction to the communication process Addressing basic communications challenges Planning business analysis communication Communication and BABOK® Guide tasks Targeted Elicitation Techniques Synergy between communication and targeted elicitation techniques Preparing for elicitation Cornerstone targeted technique: interviews Other targeted elicitation techniques Related general communication skills Group Elicitation Techniques Synergy between requirements communication and group elicitation techniques Cornerstone group elicitation technique - requirements workshops Other group elicitation techniques Related general communication skills - meeting management best practices Related general communication skills - facilitating best practices Process / Model-Based Elicitation Techniques Synergy between requirements communication and process / model-based elicitation techniques Process / model-based elicitation techniques Related interpersonal skills - problem solving and decision making Investigative Elicitation Techniques Synergy between requirements communication and investigative elicitation techniques Cornerstone investigative elicitation technique - document analysis Other investigative elicitation techniques Summary of elicitation techniques by usage in the requirements process Using Presentations, Structured Walkthroughs, and Influencing Structured walkthroughs, presentations, and influencing within BABOK® Guide tasks Cornerstone technique - structured walkthroughs General communication skill - presenting Related interpersonal skill - influencing Special Facilitation Skills - Negotiating and Mediating Negotiating Mediating

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Course description Figma is an industry leading web-based design tool that allows you to create user interfaces for any screen type or size, collaborate on those designs in real-time and build interactive prototypes suitable for user testing. Figma is a visual design tool so there’s no coding involved. Design is achieved by adding, combining and styling shapes, text and images on a canvas or ‘Frame’.  We run 2 consecutive Figma training days, the second day building on the practical activities from the first.  You can attend just the first day. Attending just the second day is only recommended if you’re already very comfortable with the Figma interface.  Day 1: Basic Figma design and collaboration For beginners with no prior experience with Figma who want to understand the basics, be able to create their own designs, share, collaborate and even iterate on the designs of others. You will learn: How to navigate the Figma interface. How to create your own designs by: Setting up a design file. Setting up the screen type you want to design and add grids and guides. Adding and modifying basic shapes and text to create user interface elements. How to save text and colour styles for reuse. How to create reusable components. How to use the ‘auto layout’ feature to promote tidy, consistent and usable design. How to collaborate on designs by sharing screens and commenting on designs. A brief introduction to prototyping: What’s possible. What’s not. Day 2: Component variants, design systems and prototyping  This session will cover the more sophisticated aspects of Figma use such as: How to use component variants to create: Interaction styles such as hover and mouse down states ‘Flavours’ of a widget such as primary and secondary button styles. Toggleable elements within a widget such as buttons or bullets within a product card. How to turn a collection of components into a basic design system. Prototyping fundamentals: How to make journeys clickable. How to introduce animations. Tips and tricks for effective user testing. The limitations of Figma prototyping Is it for you? With no experience of Figma necessary, this course is suitable if: If you’re involved with creating or curating digital experiences. if you want to turn your design ideas into something tangible. If you work with Figma designers and want to understand the ‘art of the possible’. If you want to collaborate with your team on Figma projects. Learning objectives After completing day 1 you will be able to: Understand the Figma user interface. Create mobile and desktop interface designs. Effectively collaborate remotely. Share designs and gather feedback. Use auto layout to promote consistent and usable designs. Understand Figma’s role in user experience design, and its limitations. After day 2 you will be able to: Understand how design systems are set up and used. Create component variants for use in your own design system. Use that design system to efficiently create a user journey. Create a prototype suitable for user testing.

Scrum Master and Product Owner Workshop: Virtual In-House Training This workshop builds on the specific roles and responsibilities of the Product Owner and Scrum Master in a Scrum environment, and how they need to work together as part of the Scrum methodology. During these sessions, you will explore who does what before, during, and after the Scrum Sprint cycles, as well as how to make the process work best in your specific Agile environment. You will come away from this workshop with a much deeper understanding of the roles and responsibilities so that individual performance improves on the job. Improved target results include providing focused leadership, making effective decisions, guiding Agile teams, and delivering business value. Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum Events Scrum Artifacts Scrum Roles and Responsibilities Scrum Roles Product Owner Responsibilities Scrum Master Responsibilities The Scrum Team Responsibilities Cross-functional Teams Product Ownership Product Ownership Vision Understand Your Customers and Market Stakeholder Management and Engagement Product Backlog What is a User Story? Epics and User Stories Acceptance Criteria Preparing User Stories for a Sprint Definition of Ready (DoR) and Definition of Done (DoD) User Story Estimation Using Planning Poker Backlog Grooming Roadmaps, Story Maps, Impact Mapping Product Backlog Prioritization, MoSCoW, Kano Analysis Technical Debt The Sprint Team Capacity and Velocity Planning Sprint Planning Meeting and Sprint Plan The Sprint: Learning to Become Self-managing, Self-organizing, Self-improving Sprint Review Meeting Retrospectives Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content

Introduction to Project Management: In-House Training This course provides practical insights into what is project management and how it is performed in a structured manner. This course provides practical insights into what is project management and how it is performed in a structured manner. You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. What you Will Learn You will learn how to: Articulate on the basics of the project management profession Explain project management terms and concepts in practice Speak on how projects originate in mature organizations Employ a disciplined approach to initiating, planning, and managing projects to closure Identify and describe the roles and responsibilities of key project stakeholders Consider standard project processes to implement based upon the PMBOK® Guide Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially Summary and Next Steps Review of goals, objectives, key concepts, and expectations Evaluations