product-logo

    Excel BI with Power Query / PowerPivot

    (0)
    • Bechtle-Nr.EDU128431
    • MethodIn-person seminar, Live online training
    • Target groupField sales representatives, Advanced users, Managers, Controlling employees, Marketing employees, Office users
    • Duration2 day(s)

    Please select:

        €1,300.00

        Gross price: €1,547.00 incl. €247.00 VAT

        1

        Course outline

        Method

        In-person seminar, Live online training

        Duration

        2 day(s)

        Prerequisites:

        Good understanding of Excel

        Objective:

        You'll learn how to import and present data from various sources. You are able to create and analyses complex and comprehensive data with PowerPivot.

        Content:
        • Power Query: Access and transform data: Acquire data online and from files, import data from databases and other sources, process queries, define relationships, calculations in queries
        • PowerPivot: Import data from various sources, create relationships, create and edit hierarchies, an overview of pivotables and charts, PowerPivot calculations and features, working with date tables, KPIs, perspectives
        Comment:

        0

        Customer reviews

        There are no reviews for this product yet.

        Reviews are subject to the Bazaarvoice Authenticity Policy as well as our own review and rating policy.