Data Literacy

Stacks Image 232
These courses increase end-user Data Analysis Skills. Our offer:
- Microsoft Excel
- Microsoft Power Query
- Microsoft Power BI
- Proprietary applications

The training courses below belong to our standard contents. Upon request, the content, duration and form of the training may vary.

Use the info form to obtain the technical details of a learning topic or to request more information.

  • Microsoft Power BI Visuals

    Interactive must-follow workshop for any user of Power BI reports or dashboards.

    3,5 h
    Workshop or Webinar

    Power BI Visuals Workshop

    Anyone who has ever received a Power BI dashboard in their inbox knows the importance of understanding the visual representations, filters, and settings applied. Analysing this information correctly is crucial.

    This workshop will introduce you to the world of Power BI Services. It's designed for a broad audience, particularly end users of Dashboards, Power BI Apps, or team members with access to a Power BI Workspace.

    This is a must-attend session for anyone who wants to accurately interpret Power BI analyses!

  • Microsoft Power BI Fundamentals

    ‘Getting started’ training of 2 days, supplemented by a case study on day 3 in Power BI desktop. Data is loaded, edited via Power Query. Afterwards, you will learn how to make the right relationships. Data dimension tables and measures in DAX are added to obtain a ‘Semantic Model’. Based on this, a report is created.

    2 or 3 days
    Interactif Training

    Power BI Fundamentals

    This interactive multi-day training course is aimed at the ‘Report Builder’ who wants to work with raw data on his or her own or in a team to transform it into ‘data-facts’ tables in Power BI Desktop. Based on relationships between the information and adding data dimension tables and a table with DAX measures, you will obtain a ‘Semantic Model’.

    On this basis, you learn how to draw up a report. The right choice of visuals and styles, supplementing with slicers, drill-through pages and tooltip pages makes your report a user-friendly tool for the business analyst in your organisation.

    To collaborate and share this information, publish the report in Power BI Services and, if required, you can create a Power BI App to distribute the information to a wider audience.

    This course lasts 2 days and offers the optional option of adding a third day in which trainees develop a case study to apply and test their acquired knowledge.

    During the first two days, we use datasets from IT-Training4all BV. On the third day, there is a customised case-study, possibly on company-specific data.

  • Microsoft Power BI 5-step-report

    You have access to a ‘Semantic Model’ but want to build your own report? Follow this half-day workshop. Here you will learn how to build an interactive report with 5 visuals, a drill-through page and a tooltip page.

    3,5 h
    Workshop or Webinar

    Power BI 5-step-report

    In this workshop, you'll primarily build a report using Power BI Desktop, though an alternative approach via Power BI Services is also available.

    You'll create a multi-page report featuring five visuals. In addition to utilising filters and formatting tools for these visuals, you'll learn how to set up a tooltip page and a drill through page.

    This session is designed for report builders who want to leverage existing semantic models while maintaining their unique perspective in report creation.

  • Microsoft Power Query

    If you often frequently process data from external sources such as CSV files, SharePoint folders, and lists in Excel, then this workshop is perfect for you!

    3,5 h
    Workshop or Webinar

    Getting started with Power Query in Microsoft Excel

    A pivot table requires well-prepared information. Use Power Query to transform and correct your existing Excel tables. Seamlessly process and merge monthly SAP exports into a coherent whole using Power Query.

    This interactive workshop will introduce you to the various applications of Power Query in Excel. Whether you're importing a CSV file or reading data from a PDF, this session will teach you how to read and integrate different sources with Power Query.

  • Microsoft Excel Calculations

    Formulas and functions are the backbone of any spreadsheet. This one-day course will introduce you to a wide range of functions. You'll dive deep into logical, reference, lookup, and comparison functions, gaining a comprehensive understanding of how to use them effectively.

    1 day
    Interactive Training

    Microsoft Excel: the spreadsheet

    While Excel is often associated with lists, it is actually a powerful calculator. Discover the new generation of functions alongside familiar ones and enhance your numerical analysis by making smart use of tools like conditional formatting in your worksheets.

    This course is designed for both new Excel users who need initial training in formulas and functions, as well as existing users looking to refresh their knowledge.

  • Microsoft Excel DataCrunching

    In this session, tthe ultimate goal is to analyze figures and data in Excel using a pivot table. To achieve this, we will also cover essential topics such as tables, functions, slicers, and conditional formatting.

    1 day
    Interactve Training

    Microsoft Excel: be a wizard with tables and pivottables

    Whether your data is entered manually or exported from another application, this course is suitable for both scenarios. You will learn how to:

    • Convert data in a data table
    • Use functions and formulas to refine data
    • Utilise pivot tables to analyse and update data

    This session is designed for users who primarily work with lists and data sources, and for whom analysing and summarising data is essential. At the end of this session, you will have created a pivot table complete with slicers and charts.