Training

Founded on our vast experience working with large international groups and our hands-on approach to data-driven projects, we help you set up the right organization to tackle today’s challenges, assessing how to efficiently share responsibilities and ensure accountability, with a strong focus on empowerment through first-class training.

Business Intelligence & Data Visualization are an important tool for establishing a data culture. Amongst others by getting the semantics right, gaining insights, monitoring performance and improving the overall data literacy of the organization. We use Power BI, Tableau and Google Data Studio as an enabler.

We apply the - tell me - show me – coach me principle together with business related exercises to manifest the learning curve and high engagement level. Contact us for options.

For setting, using, and raising the knowledge and skills standard for Power BI we have the following training programs:

1 day - Rapid Data Analysis with Power BI (certified)

Getting the basics right and feel confident on designing, developing and publishing dashboards yourself using different data sources like Excel.

  • - Components of Power BI

    - Power BI Interface

    - Fields Panel:

    o Columns

    o Icons

    o Measures

    o Calculated fields

    - Organizing columns

  • - Most used visuals

    - Choosing the right visual

    - Fields, Format and Analyze

    - Formatting visuals

    - Setting up visuals

    - Adding lines

    - Conditional formatting

    - Adding visuals from the app source

  • - Types of slicers

    - Formatting slicers

    - Syncing slicers

  • - Adding filters

    - Visual and page filters

  • - Power BI Online

    - Reports and dashboards

    - Work spaces and Apps

    - Sharing the report: Teams, SharePoint, Power BI

    - Exporting the report: Excel and PowerPoint

3 day - Power BI Super User training (certified)

From designing and creating reports and dashboards combining different data sources, applying calculations towards more complex reporting features like drillthroughs and “what if” statements. Together we will get this sorted to supercharge your knowledge and skills to an advanced level.

  • o Online or Desktop?

    o The Power BI Desktop interface

    o Tables, charts and slicers

    o Loading data with Power Query

    o Combining Excel sheets

    o Data model and model view, relationships

    o Visualisations

    o Fields, Format and Analyse buttons

    o Creating a report

    o Conditional formatting

    o Sharing a report

  • o Calculated fields or measures?

    o Adding extra columns

    o Formulas to create measures (SUM, COUNT, DISTINCTCOUNT, MAX, MIN, AVERAGE)

    o Measure table setup

    o Adding a datetable

    o Filtering options using CALCULATE

    o USE RELATIONSHIP, SAME PERIOD LAST YEAR, TOTAL YTD, DATE ADD

    o Using variables

  • o Best practices for report structure

    o Tooltip page

    o Drillthrough

    o Navigation buttons

    o Bookmarks

    o Dynamic titles

    o SWITCH function

    o What-IF (parameters)

We adapt to the delivery format that suits you best, being at our well facilitated office, in-company or a virtual classroom of course. The training program and content can be customized to your context, maturity level and in English, Dutch or German. Please feel free to contact us.