Summary

Fuyao Glass America is an OEM glass supplier to major auto manufactures like General Motors, Ford, BMW, Honda and Bentley. Fuyao decided to improve their collaboration and productivity through Office 365 and have completed an Office 365 rollout to all their users. The team at Fyuao adopted Microsoft Teams for collaboration and Microsoft Planner for task management. And to make their new implementation of Teams the business application they needed, Fuyao turned to JiJi Technologies.  With Power BI, JiJi Technologies delivered the ideal solution for Fuyao’s Project Managers that included interactive insights, dashboards, and synchronization across applications.

Challenge

To manage projects, Fuyao’s Program Management team adopted Microsoft Planner across various teams. They liked its simplicity and that it required very little training for users. Project managers of Fuyao need to manage multiple projects, and each project involves members from various teams. Project managers require reporting of tasks from multiple projects to effectively manage their Projects. They also need more information than the out-of-the-box reporting that Planner provides.

Strategy

JiJi Technologies provided a solution through the use of their in-house product Apps4.Pro and Power BI to deliver on the Fuyao need for extended reporting capabilities beyond what Planner provides. The JiJi Technologies solution Apps4.Pro uses Power BI API and Microsoft Graph API to synchronize the Planner data with the Power BI dataset. The solution also does the periodic refresh of the Planner data with Power BI. As part of the solution, JiJi Technologies provided a report with various filter options (plan, assigned to, due date, bucket).

Since all the plan details in Planner are available in Power Bi, Fuyao’s project managers started generating the following reports using Power BI easily.

  • Un-scheduled tasks across the plans
  • Tasks over-due by week/month across the plans
  • Upcoming tasks by week/month across the plans
  • Tasks completed this week

Results

Fuyao Glass has succeeded with Planner adoption across their various departments. Project managers are building their own reports and dashboards, and versions of these dashboards are shared with higher management, giving everybody greater visibility and responsiveness to projects and their status. All of this is possible through the work JiJi Technologies did, using Power BI to extend Microsoft Planner. And because this sustainable solution utilizes Microsoft 365, it can grow and change with Fuyao’s needs into the future.

With the integration of Microsoft Teams, Apps4pro Planner and Power BI, we have greatly improved our program management, task management and transparency of program status. We have also greatly improved our communication and collaboration in program management across our global colleagues."

- Ryan Chen

Director of Program Management
Fuyao Glass America