Power BI, Power Pivot & Power Query Training

Data from spreadsheet and files without structures
    Duration
    Start hour
    Level

      2 days • Live online • Hands-on labs • Qualified Trainer • Official Comarch Certificate

      Quick Facts

      • Price

        276 ÂŁ

      • Duration

        ⏰ 2 days (16 training hours) of practical training 

      • Training format

        Live Online Training: Learn in real-time with an expert instructor from anywhere.

      • Learning method
        • Project-Based Case Study: Build a complete analysis project from planning to final insights using a realistic business scenario.
        • Guided & Collaborative: Work side-by-side with the instructor and peers to plan strategy and implement solutions.
        • Just-in-Time Learning: Master advanced techniques and functions exactly when you need them as the project unfolds.
      • Certificate

        Official training certificate issued upon course completion.

      • Registration

        Check available dates and register via this form.

        About the course

        This practical two-day training focuses on using Power Query and Power Pivot together with Power BI to clean and model unstructured data.

        Participants will learn how to:

        • import spreadsheets and flat files,
        • transform messy data into structured models,
        • build interactive reports - without advanced coding.

        The course is ideal for professionals who work with Excel files, CSVs and other irregular data sources and want to streamline their data preparation process.

        Who should attend?

        • Business users and analysts who work with Excel or CSV data regularly
        • Teams preparing data for Power BI reports and dashboards
        • Anyone who wants to reduce manual data cleaning and automate workflows

        Learning outcomes

        After completing this course, participants will be able to:

        • Import data from spreadsheets, text and CSV files into Power BI
        • Use Power Query to clean and reshape unstructured datasets
        • Apply transformations, merge, append and pivot data
        • Build data models with Power Pivot for reporting
        • Create clean, reusable data sources for Power BI dashboards
        • Share structured data models securely with others

        Enrol now!

        FAQ

        What topics are covered?

        The DAX creating advanced formulas course syllabus includes:

        1. Data model design:

        • Source data logic
        • Definition of output structure
        • Final table layout incl. relationships

        2. Data adjustments:

        • Transforming data from source to final shape
        • Automated file merging in folders
        • Preparing tables for relationships

        Data Analysis, defining measures and calculated columns. Calculations based on data subsets; RELATED() 
        function, iterators, conditions and data lookup:

        • Focused analysis – filters, CALCULATE() function, context modifiers
        • Analysis over time – comparison and cumulative values, date table

        3. Data visualization:

        • Choosing right visual component
        • Filters and slicers
        • Slicer formatting 
        What requirements are needed?

        The DAX course participants are required to have:

        • Training participants are required to have basic knowledge of Power BI or the Power Pivot and Power Query
        What is included in Power BI, Power Pivot, Power Query course?
        • Two days of live training, course materials and an official completion certificate.
        • Training is carried out in the form of alternating lectures and practical exercises, performed individually or together.
        Is this Power BI, Power Pivot, Power Query training is interactive?

        Yes - sessions include hands-on labs and real-world datasets.

        What's next after this course?
        How can I join?

        To sign up, simply fill out the short registration form.

        Go to form

        Similar trainings

        Sign up for training!

        Register now for our upcoming training sessions by filling out the registration form.

        Join us to build your expertise and take the next step in your career!

        Enrol now!

        đź“© Any questions? Get in touch with us!

        Lidia Waśnik

        lidia.wasnik@comarch.com

        +48 12 646 14 41