OPC-1000: Connecting Oracle Primavera Cloud to Power BI

OPC-1000: Connecting Oracle Primavera Cloud to Power BI

Do you already have experience with Oracle Primavera Cloud or Power BI and want to learn how to convert project data from Oracle Primavera Cloud (OPC) into clear and interactive reports? Then this training course is an excellent starting point. You’ll learn, step by step, how to retrieve data from Oracle Primavera Cloud using the Oracle REST APIs and make it available in Power BI. The course does not focus on in-depth Power BI features, but rather on successfully connecting the two applications and building a solid data structure for reporting.

During hands-on workshops, you’ll work with realistic examples in which project data, activities, and Monte Carlo data are retrieved from Oracle Primavera Cloud and modeled into actionable management information. You’ll also learn what OPC data is required, how to set it up, and what transformations are needed within Power BI. If there is sufficient time at the end of the course, an interactive consultation session will be organized in which participants work on their own real-world case or a specific reporting question. This will give you immediate insight into how to apply the techniques you’ve learned within your own organization.

Classroom-based: €484 excluding VAT
Classroom-based online via Microsoft Teams: €425 excluding VAT

Topics

Day 1

  • APIs, JSON, and Access Tokens
  • Basics of Power Query
  • Oracle Primavera REST APIs
  • Primavera Cloud Settings
  • Power BI Settings
  • Get Token Query
  • Access Token Query
  • Primavera Get Function
  • Workspace REST Endpoints
  • Project Data REST Endpoints
  • Activity Data REST Endpoints
  • Monte Carlo Data REST Endpoints
  • Basics of OPC Power BI Reports
  • Custom BI Reports
  • Duration 1 day
  • Enrollment Formats. Open enrollment, In Company
  • Delivery Formats. Face-to-Face, Online
  • Learning Format Software Training
  • Spoken language Dutch or English
  • Coursebook Temporarily accessible digital learning environment
  • Availability Up to 30 days after training
  • Language course book English
  • Prerequisite Knowledge Project Planning Using Oracle Primavera Cloud. Power BI Basics
  • Minimum number of participants 2
  • Maximum number of participants 8
  • Completion Certificate of participation

Our course is offered worldwide view our class times below

Winter Time

Netherlands

GMT+01:00 09:00 - 16:30

Online Europe / Africa

GMT+01:00 9:00 - 16:30

Online South America

GMT-04:00 8:00 - 15:30

Online Asia

GMT+07:00 14:00 - 21:30

Summertime

Netherlands

GMT+02:00 09:00 - 16:30

Online Europe / Africa

GMT+02:00 08:00 - 15:30

Online South America

GMT-04:00 8:00 - 15:30

Online Asia

GMT+07:00 13:00 - 20:30

Register for the training

More participants?