Data Analytics with Power BI

Power BI combines data from different sources and provides comprehensive and quick insight by extracting and visualizing company data. Power BI provides an analytical environment for monitoring data and sharing reports. Interactive dashboards and reports show insights and key performance indicators based on integrated data sources.

Aim of the further education

• Fundamentals of data analysis, data preparation and data visualization
• Intuitive and productive handling of data
• Introduction and basics of working with Power BI
• Statistical & mathematical basics
• Practical implementation of your use cases using so-called learning transfer sessions
• Ability to make data-driven decisions & use data strategically

Your benefit: 

• Development of concrete ideas for Power BI use cases
• Evaluation concerning feasibility
• Get support with the implementation of use cases and first steps in Power BI
• Clarification of specific topics and questions regarding the handling and use of Power BI
• Optimization of Power BI Dashboards

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.