Author: Ben Howard

Ben Howard – Awarded Community Leader for his very popular and comprehensive UK web training series and has over 30 years of experience of implementing enterprise solutions for customers worldwide.  During that time, he’s worked for IBM, DELL, and Microsoft, as well as several smaller organisations. He now runs his own consultancy (Applepark Ltd), providing Project, Project Online and Power BI implementation and training services. He has been awarded the Microsoft Most Value Professional award for Project for the last 13 years, blogs semi-frequently at www.applepark.co.uk, produces video training for Pluralsight and his own YouTube channel, and finally was responsible for producing P2O, an application that exports tasks from Microsoft Project into Outlook.  You can catch him at ben@applepark.co.uk  

Automate Your Project Reporting with Power BI 3 of 3

WebNLearn: Automate Your Project Reports Using Power BI – 3 of 3

You will learn how to automate your reporting and how to automatically refresh data using project for the web or project online.

Automate your project reporting with power bi

WebNLearn: Automate Your Project Reports Using Power BI – 2 of 3

In this webinar you will learn about Power BI, how to cleanse existing data, how to derive new data values and link to data sources.

Automate your reporting using power bi

WebNLearn: Automate Your Project Reports Using Power BI – 1 of 3

In this webinar you will learn about Power BI, who would be interested in Power BI, how to view Apps, and how to put together a simple report.

Enterprise Reporting for Planner

Enterprise Reporting -Microsoft Planner data to Power BI via Flow

Many organizations use Microsoft Planner because it’s free if you have an Enterprise Plan! This is good news, but unfortunately it is difficult to report across multiple plans; the reporting options simply haven’t been built by Microsoft. To address this need I’ve created and published a solution that enables you to bring Planner tasks and assignments into Power BI which can be deployed by anyone who has access to the Power Platform.

Automate Microsoft Planner reporting using Microsoft Power Automate and Power BI (Lesson 2)

Event Description:Welcome to part 2 of this 2 part training session.  In this session you will be shown how to use Power Automate to query all of the Planner tasks and store them in Sharepoint, and then how to connect to Sharepoint using Power BI in order to provide an enterprise wide Task Management reporting solution.  At the end of the session you will be shown how to download the template flow and Power BI files so you can implement the solution in your own organization. Learning Objectives:Learn how to use Microsoft Power Automate to bring users into an Excel file in Sharepoint and how to use the Excel file as a data source for Power BI, providing and Enterprise Wide task management reporting solution. Project Management Institute (PMI)® Professional Development Units (PDUs):This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Presenter Info:Ben Howard – Awarded Community Leader for his very popular and comprehensive UK web training series and has over 30 years of experience of implementing enterprise solutions for customers worldwide.  During that time, he’s worked for IBM, DELL, and Microsoft, as well as several smaller organizations. He now runs his own consultancy (Applepark Ltd), providing Project, Project Online and Power BI implementation and training services. He has been awarded the Microsoft Most Value Professional award for Project for the last 13 years, blogs semi-frequently at www.applepark.co.uk, produces video training for Pluralsight, and finally was responsible for producing P2O, an application that exports tasks from Project into Outlook. Follow Ben on twitter: @ben_project, and subscribe to his YouTube channel @ https://www.youtube.com/c/BenHoward_PowerBI

Automate Microsoft Planner reporting using Microsoft Power Automate and Power BI

Automate Microsoft Planner reporting using Microsoft Power Automate and Power BI – Lesson 1

In this lesson (part 1 of 2) I’ll show you how to use Microsoft Planner to plan and manage lightweight projects, and how Planner integrates seamlessly into Teams, providing a single interface to track and manage all of your tasks, both from Planner and from Outlook.

Power BI for Business Users and Project Managers – Part 3: Creating Reports using the Power BI Desktop App

Project Management Institute (PMI)® Professional Development Units (PDUs):This Webinar is eligible for 1 PMI® PDU in the Strategic category of the Talent Triangle. Event Description: Once we’ve got our data into the required shape, we can begin to visualize it, i.e., build reports and dashboards for users to view. Once again, we’ll take Planner files, publish the reports, and create dashboards in the Power BI Service so that they can be shared within our organization. We’ll also show how these reports and dashboards can be viewed on mobile devices and the information socialized within the mobile app. Presenter Info: Ben Howard – Awarded Community Leader for his very popular and comprehensive UK web training series. Ben Howard has over 25 years of experience of implementing enterprise solutions such as MRPII, ERP, and latterly Microsoft’s Project Online solution. During that time he’s worked for IBM, DELL, and Microsoft, as well as several smaller organisations. He now runs his own EPM consultancy (Applepark Ltd), providing Project, Project Online and Power BI implementation and training services. He has been awarded the Microsoft Most Value Professional award for Project for the last 11 years, blogs semi frequently at www.applepark.co.uk, has published the successful “Microsoft Project 2013 Plain and Simple” book, produces video training for Pluralsight, and finally was responsible for producing P2O, an application that exports tasks from Project into Outlook. Follow Ben on twitter: @ben_project, and subscribe to his youtube channel @ https://www.youtube.com/channel/UCFLXSQWuC9rq6lOLf-poNOA Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]

Power BI for Business Users and Project Managers – Part 2: Deep Dive into Shaping Data using Power Query

Watch Part 3 On-Demand Project Management Institute (PMI)® Professional Development Units (PDUs):This Webinar is eligible for 1 PMI® PDU in the Strategic category of the Talent Triangle. Event Description: Data rarely exists in the exact format or shape that we want it. It needs “massaging”, errors need to be removed, and often new data needs to be derived from the existing data set. In this session, you’ll learn how to use Query Editor inside the Power BI desktop client to transform your existing data so that it suits your purpose. We’ll use examples from both Microsoft Planner files and Project Online. Presenter Info: Ben Howard – Awarded Community Leader for his very popular and comprehensive UK web training series. Ben Howard has over 25 years of experience of implementing enterprise solutions such as MRPII, ERP, and latterly Microsoft’s Project Online solution. During that time he’s worked for IBM, DELL, and Microsoft, as well as several smaller organisations. He now runs his own EPM consultancy (Applepark Ltd), providing Project, Project Online and Power BI implementation and training services. He has been awarded the Microsoft Most Value Professional award for Project for the last 11 years, blogs semi frequently at www.applepark.co.uk, has published the successful “Microsoft Project 2013 Plain and Simple” book, produces video training for Pluralsight, and finally was responsible for producing P2O, an application that exports tasks from Project into Outlook. Follow Ben on twitter: @ben_project, and subscribe to his youtube channel @ https://www.youtube.com/channel/UCFLXSQWuC9rq6lOLf-poNOA Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]