- Overview of the basics of data science and digital transformation
- Presentation of the advantages and prerequisites of data-driven companies
- Introduction to data literacy
- Criteria for the correct presentation of analyses and for data communication
- Basics of exploratory data analysis for checking data quality
- Familiarization with the common forms of representation for analyzing the position, scattering and correlation of properties in a data set for simple analysis tools
- Exercise: Derive targeted insights using a predefined "Grand Tour" dashboard
- Guiding questions lead the participants through the transfer task
- Joint discussion of the forms of presentation with the course participants
- Clarification of potential questions that arose during the self-study phase and transfer task (modules 2 and 3)
- Basics for creating meaningful data dashboards
- Basic principles of data-driven storytelling and how to apply them
- Getting to know typical problem types in a data set (e.g. invalid and incorrect data)
- Introduction to methodologies for successfully cleansing data in Microsoft Excel or Power BI
- Preparation measures for forecast analyses in Microsoft Excel or Power BI
- Presentation of tools for assessing a regression analysis
- Exercise: Examining the data quality of a given data set
- With the help of suitable visualizations, the course participants recognize outliers and can suggest specific recommendations on how to deal with the incorrect data points (removal of data vs. methodical data correction)
- Guiding questions lead the participants through the transfer task
- Clarification of questions that arose during the self-study phase and transfer task (modules 5 and 6)
- Discussion of a case study on the topic of forecasting and joint evaluation of the analysis model
- Presentation of best practices for automated data cleansing in Microsoft Power BI
- Joint conclusion and room for questions
Contents
1. understand data
- Introduction to data science
- Introduction to exploratory data analysis
- Data visualization and data analysis
- Understanding position, dispersion and context
2. visualize data
- Presentation of comparisons
- Presentation of relationships and connections
- Representation of rankings
- Representation of compositions
3rd "Grand Tour" team challenge
- Practical exercises with the presentation types from the previous modules
4. prepare data
- Problem identification and problem types
- Exploration and cleansing of data
- Special features of forecasting analyses
5. assess data
- Regression models explained in detail
- Coefficient of determination for the assessment of regression models
- Key figures for deviations
- Mean absolute error (MAE)
- Mean square error (MSE)
6th Team Challenge "Data cleansing"
- Practical exercises to determine and optimize data quality in data sets
How do you learn in the course?
This online course offers you a digital blended concept that has been specially developed for part-time learning. With a time budget of at least 3-4 hours per week, you are sure to reach your goal. Alternatively, you can schedule the learning units flexibly. This is how you learn in the course:
- Self-study phases: Learn independently, at your own pace and whenever you want. Our courses offer you didactically high-quality learning material with videos, articles, interactive exercises, quizzes and learning checks.
- Live webinars: In regular online seminars, you will meet your trainers in person. You will receive answers to your questions, specific assistance and instructions on how to deepen your knowledge and apply the skills you have acquired in practical exercises.
- Practical assignments: To learn the skills in practice, you will be given access to data projects that allow you to apply the techniques and methods you have learned to real-world problems. Through these exercises, you will gain a deep understanding of working with data and develop methods and techniques that you can apply in your everyday work.
- Learning community: A digital learning community is available to you throughout the course. Exchange ideas with other participants and the trainers and ask questions.
- Certificate of attendance and Open Badge: As a graduate of the course, you will receive a certificate and an Open Badge that you can easily share in professional networks (e.g. LinkedIn).
- Future Jobs Club: Booking this online course gives you access to the Future Jobs Club with exclusive information, offers and networking opportunities.
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
Your benefit
- Learn how to cleanse and analyze company data in a structured way - using Microsoft Excel and Power BI.
- Gain sound assessment skills in order to derive and communicate the right findings from data analyses.
- Receive concrete tips and examples for the optimal visualization of data analyses.
- Learn all about typical pitfalls and how to critically scrutinize your ad hoc analyses.
- Not only will you learn the necessary tools first-hand from your trainers, you will also apply the knowledge directly in exercises with the data sets provided in two comprehensive practical blocks.
Take an active part in our online community and work with your own questions - this is how you will benefit most from this course. This will allow you to apply the content both in self-study and in practical exercises.
Methods
Well-founded trainer, presentations, practical exercises, self-reflection, discussions, work aids, group work on real projects of the participants and exchange of experience in the learning community.
Recommended for
This introductory course is aimed at specialists from all sectors and anyone interested in learning how typical data analyses are carried out and how common tools such as Microsoft Excel or Power BI are used for this purpose.
Further recommendations for "Data analysis and data visualization with Excel and Power BI"
Seminar evaluation for "Data analysis and data visualization with Excel and Power BI"







Start dates and details


