Live Webinar – September 20th, 2023 12:00 pm – 1:30 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: MPUG WebnLearn ( REP 1369 )
Mpug Member Free – Members only event

Excel’s dashboarding capabilities empower users to transform raw data into meaningful insights.

Suitable for business reporting, financial analysis, or project management, Excel dashboards offer a user-friendly and visually impactful means to analyze, interpret, and communicate data effectively.

Building a dashboard requires data that can be sourced from various locations such as databases, CSV files, and web pages.

Often, this raw data isn’t immediately suitable for use, necessitating cleaning, merging, and combining processes.

1. Do you often find yourself saying, “It’s taking too long” when referring to the time spent formatting your data for reports?
2. Are you regularly tasked with repetitive and time-consuming data cleaning and transformation activities?

These might include removing unnecessary rows and columns, filtering out irrelevant data, converting text to numbers or dates, splitting or merging columns, removing unexpected characters, or combining files together.

Would you appreciate a solution that can perform all of these tasks with the click of a button? If your answer is yes, then Power Query (also known as Get and Transform in Excel 2016 and later) is what you need.

Learning Objectives:

• Import data into Excel from sources such as text files, web pages and databases
• Keep the imported data in sync with the source data using just two clicks
• The Power Query Editor – the key to data cleaning and transformation
• Save a ton of time – automate the cleaning and transformation process

If you are NOT ALREADY a member JOIN MPUG!

This event is for members only BUT… You can take one of the MPUG Certificated Masterclass (Usually 6 Category A PDUs) Or over 30 other Category A PDUs for free each year.  The $129 Per Year Membership Fee is a terrific value!

MPUG Membership includes:

1. MPUG’s Project Server and SharePoint certificated courses available to members
2. Over 30 other virtual PDU events per year
3. You can network with other MPUG (Microsoft Project Users Group) members at in person meetings and events.
4. Work with Microsoft MVPs in MS Project Project Server & SharePoint
5. And so much more …

Seriously consider joining MPUG if you work with SharePoint or Project & earn all the PDUs you will need as a member of MPUG!

Click to register for:
Excel Power Query & Dashboards

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Live Webinar – September 20th 2023 5:00 AM – 6:00 AM EDT
Live Webinar – September 20th 2023 10:00 AM – 11:00 AM BT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: Association for Project Management – APM

Discover how AI and Machine Learning (ML) are transforming the engineering and construction industries, specifically in the pharmaceutical and life science domain.

As we are joined by Richard Cairnes (LinkedIn profile) and Grant Bezuidenhout (LinkedIn profile) from the pharmaceutical and life science team at Currie & Brown.

During this webinar, Richard & Grant will explore the power of AI to process vast amounts of data rapidly, leading to informed real-time decision-making, increased efficiency, and enhanced value delivery to our clients.

They will delve into practical examples, such as the utilization of AI in Building Information Modelling (BIM) to create better visibility, improve decision-making, offer sustainable options, and achieve cost savings for our pharmaceutical and life science projects.

Moreover, Richard will discuss the application of AI in crucial areas like Health & Safety, where AI-driven technologies are reducing human error through the use of remotely controlled, driverless, or drone vehicles for hazardous tasks.

Sustainability is another domain benefiting from AI, aiding clients in reaching their BREEAM targets and enabling contractors to forecast carbon emissions during the planning stages of a project. AI is also instrumental in identifying the advantages of using different materials to achieve environmental benefits and carbon reduction.

This event is part of a series of activities aligned to supporting the healthcare, life science, and pharmaceutical sectors to ensure that individuals are equipped with the skills to deliver projects effectively.

Click to register for:
How Artificial Intelligence (AI) Is Revolutionizing
Project Delivery In The Life Science Sector

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Live Webinar September 21st, 2023 – 12:00 pm – 1:00 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: International Institute for Software Testing
(IIST – Rep 4514) – A Rommana ALM Webinar

If you have been using ADO to manage your agile projects, you can now unleash the power of complete ALM functionality through the Rommana ALM-ADO integration. You can sync your ADO projects with Rommana ALM projects and enjoy the following ALM functionality available in Rommana ALM:

You will be able to continue to manage your projects in ADO with the added ALM functionality from Rommana ALM

Get all details in this educational webinar by the Chief Architect of Rommana ALM.

Presenter: Dr. Magdy Hanna PhD (LinkedIn profile) is a recognized educator, speaker and consultant in several areas of software engineering. His highly rated seminars in various topics over the last thirty-five years have spanned various aspects and capacities of software projects and processes.

He has trained over 50,000 professionals around the world over the last 20 years. As a professor of Software Engineering at the University of St. Thomas , he taught graduate courses on several software engineering topics with emphasis on practical software quality techniques.

Dr. Hanna developed new approaches and methods in software engineering including the Scenario-Based Development and Testing (SBDT), Requirement-Based Project Management (RBPM), Software Quality Engineering Methodology (SQEngineer), the Unified Data Model (UDM), and the Data-Driven Object Model ( DOM ). Dr. Hanna and his instructors conduct hundreds of free online webinars each year.

Dr. Hanna also served as Editor-in-Chief of the Journal of Software Test Professionals, a publication of IIST, now the Bug Free Zone.

Dr. Hanna is Founder, CEO, and Chairman of several organizations:

• International Institute for Software Testing,
  • leading educational and professional development organization that provides education-based certifications to software test and quality professionals around the world.
  • Dr. Hanna serves as the Chairman of Advisory Board for the Certified Software Test Professional (CSTP) and the Certified Test Manager (CTM) credentials.
• International Institute for Software Process
  • leading professional development organization that provides education-based certifications to software process improvement professionals around the world.
  • Dr. Hanna serves as the Chairman of Advisory Board for the International Software Process Improvement Certification (ISPIC).
• International Conference on Practical Software Quality and Testing,
• International Conference on Software Process Improvement,
• RommanaTM Software
  • In this role, he is the Chief Architect of an Integrated Software Lifecycle Management System.

NOTE: The registration page simply says
“Free Webinar Registration“

Sadly there Is NO Indication on the registration page that you are registering for this session but you actually are.

On the next page you will have a drop down box to choose this session.

Click to register for:
Extending Azure DevOps (ADO)
To Include Complete ALM Functionality

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.

Live Webinar September 20th, 2023, 1:00 pm – 2:00 pm EDT
Activity Type: Education – Course or Training  1 Hour  1 PDU
Provider: Gartner Webinars

1. Planning to make a big technology purchase soon?
2. How confident are you that it will be successful?

A critical technology purchase can be a time-consuming, complicated process with challenges like competing priorities, lack of consensus, over-zealous vendors and limited unbiased information — that’s where BuySmart can help.

Backed by actionable, objective insight from Gartner, BuySmart helps you save time, collaborate effectively, and streamline the entire purchasing process, from vendor exploration to sealing the deal. With technology templates that empower you to manage priorities and requirements, and vendor evaluations that help you shortlist your choices,

BuySmart gives you the guidance and tools you need to invest confidently.

Return to the web page to watch both the live and on-demand webinar.

Click to register for:
Gartner BuySmart™ Demo

NOTE: For PMI® Audit Purposes – Print Out This Post! Take notes on this page during the presentation and also indicate the Date & Time you attended. Note any information from the presentation you found useful to your professional development and place it in your audit folder.