DK EN NL

Reporting & Dashboards kursus

Reporting & Dashboards

Do you want to learn how to create an overview of your company’s activities? Then choose this course and learn how you build reports and dashboards based on both project and portfolio data.

Microsoft Project Online takes advantage of the Microsoft Business Intelligence platform and all its capabilities, including Microsoft Power BI. The students will get a thorough introduction to the possibilities this brings to the world of Microsoft Project Online, both on a project level as well as on portfolio level.

Using Excel, students will be able to create a report through a familiar tool, and publish them to the Project Web App (PWA). Introducing Reporting Services and Report Builder will enhance the participants understanding of building filter and parameter friendly reports.

Participants will learn how to make automated reports in Excel and PowerPoint available to users, as well as creating dashboards with Microsoft Power BI. With hands on exercises, the course aims to provide the participants with an understanding of the data available in Microsoft Project Server and Project Online and how to choose the best option for reporting on the data, as well as actually creating working reports and dashboards.

Target Audience

Project Online Administrators, Project Management Officers, Business Intelligence Architects, Business Data Analysts, Portfolio Managers, SharePoint Architects.

In this course you will learn how to:

  • Access and work with project and portfolio data from Microsoft Project Online
  • Use data connections in Microsoft Project Online
  • Use and understand POWER BI
  • Create reports using various reporting tools such as:
    • Excel
    • SharePoint
  • Create dashboards online with Power BI or Project Online

Prerequisites
Basic knowledge of Project Server and SharePoint will be required. Knowledge of structuring, building and using reports in Excel is an advantage.

Agenda
1. Introduction
          a. Understanding your data

2. Data Sources
          a. OData

3. Power Bi
          a. Q&A
          b. Power Query
          c. Power Map
          d. Power BI App

4. Report Tools
          a. Excel
                    - Limitations
                    - Power Pivot
                    - Power View
                    - Apps
                    - Dashboards

5. Power Point
          a. Connecting to Data Sources
          b. Refreshing data

6. SharePoint
          a. Web Part Filters
          b. Dashboard Pages
          c. Dashboard Center
          d. Security

7. Power BI

          a. Dashboards

8. Best Practices

9. Inspiration and Samples

 

Price  

9.500 DKK (ex. VAT)


kunde logo
kunde logo
kunde logo
kunde logo
kunde logo
kunde logo

Tilmeld dig vores nyhedsbrev og hold dig opdateret (engelsk)