Data and Analytics expert training modules

A key element in adopting a data driven strategy is to have a skilled workforce that can maintain and operate data and analytics systems. This will increase usage of analytical applications throughout the organization and help analytics teams stay motivated and relevant to the business.

With over 25 years of experience in the SAP and Microsoft domain, Magnus facilitates tailor made training modules, as an extension to our advisory and implementation services, in the field of data engineering, analytics and machine learning.

By executing a fit-gap analysis on roles and needs, we can help to identify specific learning needs within your team, according to your organization’s vision and data ambitions.

Below an overview of the different training modules that describe the standard contents what to expect from each module. This can be tailored in consultation with your team and together develop a suitable training program according to the learning needs.

OUR EXPERT TRAINING MODULES
Microsoft Power BI

POWER BI is Microsoft’s current Dashboarding solution for which a basic license is included in an Office 365 subscription. It provides the ability to connect to different data sources and combine the data in beautiful reports and dashboards.

After completing this training

You will be able to independently create and manage Power BI dashboards by connecting to different datasets. Create a visual storyline with graphs or KPIs and apply filters and restrictions on the data. In addition, you will learn best practices and standards in the field of information presentation.

Target audience

Both novice and intermediate Power BI key users, professionals and business analysts that want to create insights from data and increase their expertise by hands on building reports and interactive dashboards.

Training topics

  • General theory on BI processes
  • Connecting to various data sources
  • Loading and refreshing data
  • Standards for data presentation
  • Creating variables
  • Visuals, graphs and tables
  • Applying advanced filtering
  • Dashboard composition
  • Mobile dashboards
  • Managing workspaces
Duration 1 day
Location Naarden / at customer site / online

 

Microsoft Azure Data Engineering

DATA ENGINEERING on Azure is Microsoft’s state-of-the-art solution for providing consistently maintained and up-to-date cloud (and on-premise) databases and data lakes.

After completing this training

You will be able to design and build a modern cloud data warehouse using various Azure tools. You are able to connect to various data sources, schedule jobs and actively monitor your data warehouse. In addition, you will learn how to keep your data warehouse safe and secure.

Target audience

Both novice and intermediate Business Intelligence analysts or consultant or on-premise BI specialists wanting to know more about the Azure cloud tools of today.

Training topics

  • Azure platform
  • Azure Data Factory
  • Azure Data Lake
  • Azure SQL
  • Connectivity
  • Designing SQL database
  • ETL processes
  • SQL basics
  • Logging & Monitoring
  • Security
  • Identity managementBackups

 

Duration x day(s)
Location Naarden / at customer site / online
SAP Analytics Cloud

ANALYTICS CLOUD is SAP’s latest Cloud tool on Business Intelligence, Augmented Analytics, Predictive Analytics and Planning. It is their new go-to tool for each of these domains.

After completing this training

You will be able to independently create, manage and leverage SAC reporting by connecting to different datasets. Create a visual storyline with graphs and applying filters and restrictions on the data. This course will also prepare you to an introduction of SAC Cloud Planning.

Target audience

Both novice and intermediate SAC key users, professionals and business analysts that want to create insights from data and increase their expertise by hands on building reports and interactive dashboards.

Training topics

  • General theory on BI processes
  • Connecting to various data sources
  • Loading and refreshing data
  • Combining data sources
  • Creating variables
  • Visuals, graphs and tables
  • Applying advanced filtering
  • Designing dimensions and planning models
  • Importing flat file data
  • Roles and Teams
  • Smart Predict, Predictive Forecast, and rolling forecast input forms 
Duration 1 day
Location Naarden / at customer site / online

 

SAP Business Objects - WebIntelligence

WEB INTELLIGENCE is part of SAP’s BusinessObjects product suite. It is a popular query and analysis reporting tool within the SAP domain. Capable of standardized reports as well as self-service reporting.

After completing this training

You have an understanding about the key components of BusinessObjects Web Intelligence and you will be able to create analytical and ad hoc reports from transactional data to meet business requirements.

Target audience

Both novice and intermediate (SAP) Business Intelligence developers, key users and business analysts that want to create insights from data and increase their expertise by hands on building reports and interactive dashboards.

Training topics

  • General theory on BI processes
  • Presentation of data in Documents
  • Formulas and Variables
  • Connecting to various data sources
  • Loading and refreshing data
  • Combining data sources
  • Webi Queries
  • Document design and management
  • Drilling functionality
  • Document publication
    Duration 1 day
    Location Naarden / at customer site / online

     

    SAP Analysis for Office

    ANALYSIS FOR OFFICE is an Office Add-In which allows you to directly connect to your SAP Systems and query data. This gives you the possibility to slice and dice the data in any way shape or form you want. With AfO it is also possible to create formatted reports for end-users for both Reporting and Planning purposes.

    After completing this training

    You can use the basic and special functions, navigation options and layout design options to be able to create and maintain Analysis for Office reports.

    Target audience

    Both novice and intermediate (SAP) Business Intelligence developers, key users and business analysts that want to create insights from data and increase their expertise by hands on building reports.

    Training topics

    • Insert a Data Source
    • Navigate in a Data Source
    • Sorting and Filtering
    • Creating Measures
    • Working with Hierarchies
    • Formulas and Variables
    • Setting Preferences
    • Adding Components to a Workbook
    • Formatting Options for the Crosstab
    • Synchronizing Crosstabs
    • Using Workspaces
    Duration x day(s)
    Location Naarden / at customer site / online

     

    SAP Business Warehouse (Modelling and Administration)

    BUSINESS WAREHOUSE (BW) is SAP’s Enterprise Data Warehouse solution. It allows you to connect directly to your source systems and use their data as input for your data models. The data models created in BW can be used as input for any reporting or planning tool.

    After completing this training

    You will be able to integrate data from different sources, transform and consolidate the data, perform data cleansing, and store the data. You will learn about data modelling, administration and staging data.

    Target audience

    BW administrators and developers with a basic knowledge of SAP BW and data warehousing concepts.

    Training topics

    • Modelling new objects like Composite Provider, ADSOs, Enhanced Master Data
    • Introduction to Eclipse and HANA Studio
    • Layered Scalable Architecture (LSA) ++ concepts
    • Data life cycle maintenance in BW/4HANA 2.0
    • Working with ODP framework
    • Core Data Services (CDS) Extractors
    • Learn to create ABAP Managed Database Procedure (AMDP)
    • Native HANA views and Mixed/Hybrid Scenario
    • Process Chains in BW4HANA Cockpit (Fiori)
    • Transaction codes with BW4HANA 2.0
    • Creating and using Customer exit in BW4HANA 2.0
    • Maintenance concepts
    • User management
    Duration x day(s)
    Location Naarden / at customer site / online

     

    Data Science

    DATA SCIENCE is the domain in which large sets of structured or unstructured data gets analyzed using advanced methods to gain extra insights. It can vary from generating predictions based on historic data to classifying objects based on a machine learning model to interpreting texts like a human being.

    After completing this training

    You will be able to do some Python coding and create your very own basic Machine Learning model. Also, you will have a better understanding on which tools are best used in the Data Science domain.

    Target audience

    Do you want to get a better understanding on how Data Science works, what it is used for and how you can successfully implement it within your business? Then this training is for you. Programming experience is not required.

    Training topics

    • Python fundamentals
    • Git
    • Organize data science project
    • Cloud tools
    • Open Source
    • Pitfalls to avoid
    • Machine Learning
    • Models vs algorithms
    • MLOps: how to bring your model into operation
    • Monitoring
    • Case
    Duration 1 day
    Location Naarden / at customer site / online

     

    Tools & Quotes – Advanced Analytics

    Tensor Flow

    We gebruiken Tensorflow voor het bouwen van Neurale Netwerken om afbeeldingen te classficeren

    Docker

    Met Docker kunnen we snel en gemakkelijk gebouwde applicaties deployen, draaien en beheren

    Python

    Python is de standaard programmeer taal waarin wij onze AI applicaties programmeren

    Kubernetes

    Wij gebruiken Kubernetes voor het automatisch op en afschalen van AI modellen voor het verwerken van afbeeldingen

    Keras

    Met Keras is het mogelijk om in een minimaal aantal regels code complexe AI modellen te bouwen

    Open CV

    Both novice and intermediate (SAP) Business Intelligence developers, key users and business analysts that want to create insights from data and increase their expertise by hands on building reports

    Databricks

    Met Databricks hebben we een compleet platform waarmee we de hele ML cyclus kunnen uitvoeren en modellen integreren in de operatie

    Github

    Door het gebruik van Git kunnen wij met meerdere mensen aan hetzelfde project programmeren en tóch overzicht bewaren

    Interested in a Data and Analytics expert training module? Contact Alain Streppel

    7 + 6 =