Data Analytics with Power BI

Basic training (2 days in presence or live-online)

Introduction to data analytics

• Motivation and characteristics of data-driven companies
• Terms relating to data science, data mining, data analytics and business intelligence
• Data-driven mindset: development and significance in production
• From data to insights
• Terminology and basics concepts of data analysis

Introduction to Power BI

• Power BI basics
• Essential functions, settings & options
• Importing data
• Data transformation in Power Query
• Visualisation elements
• Report creation and export

Statistical basics

• Application of descriptive statistics
• Dependent/independent variables
• Scale levels
• Population & samples
• Measures of position: mean, median and mode
• Measures of dispersion: variance, standard deviation, range, normal distribution
• Pitfalls in data analysis (e.g. causality vs. correlation)

Preparation of data

• Requirements for data quality
• Common data problems
• Data preparation
• Storytelling with data

Reports & Visuals

• General design rules
• Introduction to visualisations
• Using different chart types for different purposes

Advanced options and applications

• DAX functions
• Use of templates and templates
• Visualising data models in reports

Outlook and Q&A session

• Integration of Co-Pilot
• Expert tips
• Wrap up

Learning transfer (2 times 0.5 days)

• Specific problems and questions from users concerning using PowerBI and implementing use cases are discussed and solved directly. 
• Participants receive intensive support and guidance during the practical exercises. You will also receive tips for implementation, and individual questions will be addressed.
• Specific questions are collected in the appointment's basic training, which the trainer prepares for the learning transfer units.