Contents
- Introduction to Power BI
- Importance of data-driven decisions.
- Workflow of data analyses.
- Basic functions of Microsoft Power BI (data, model and report views; filter functions).
- Loading data records in the data view.
- Creation of a data model and an initial report.
2. data preparation and visualization
- Best practices in data visualization.
- Change and format visualizations.
- Use of visualizations in reports and dashboards.
- Avoiding typical mistakes and guidelines for comprehensible graphics.
- Use of the Power Query Editor for data processing and linking different data sources.
3. dashboards and data storytelling
- Arranging reports and analyses in dashboards.
- Principles of data storytelling.
- Communicating reports to relevant target groups.
- Basics of Data Analysis Expressions (DAX language).
- Integration of DAX in reports.
- Writing complex DAX code for calculations.
4. advanced topics
- Basic concepts of statistics.
- Best practices for statistical data analysis.
- Advanced methods of business intelligence based on statistics and machine learning.
- Use of drillthrough for cross-page drilldown.
- Carrying out an influencing factor analysis.
How do you learn in the course?
This online course offers a particularly practice-oriented learning concept with comprehensive self-study units and a team of mentors who are available at all times. A new chapter is unlocked for you every week. With a time budget of 5-6 hours per week, you are sure to reach your goal in 6 weeks. This is how you learn in the course:
- Placement test: In an onboarding meeting at the start of the course, you and the mentoring team will determine what knowledge you already have and which parts of the course you should pay particular attention to. This will give you the best possible preparation for learning in the self-study units.
- Data Lab: In the course's learning environment, you can expect videos, interactive graphics, text and, above all, lots of practical exercises with comprehensive datasets. You can run these directly in the browser or import them into Power BI.
- Mentor team: Learning coaches are available to answer any questions. These are experienced data analysts who are happy to help - via chat, audio or video call.
- Webinars: Once a week, you have the opportunity to take part in webinars and immerse yourself in selected specialist data analysis topics.
- Career coaching: What professional goals are you pursuing with further training and how can you achieve them? A team of mentors is on hand to help you achieve your career goals.
- Final quiz: Your newly acquired knowledge in the area of Analytics & Reporting will be put to the test in a final quiz.
- Certificate: After successfully completing the final quiz, you will receive your official certificate.
This online training is provided by our partner StackFuel GmbH. StackFuel specializes in training courses on data literacy, data science and AI.
Your benefit
You will learn in this course:
- Fundamentals of business intelligence and data-driven decisions
- Basic functions of Power BI
- Best practices for data visualization in Power BI
- Best practices for data processing with Power Query Editor
- Best practices for data storytelling
- Basics of KPI calculation with DAX language and statistics
Recommended for
This beginner's course is aimed at anyone who wants to learn Business Intelligence without acquiring complex technological skills. The ability to use intuitive tools such as Power BI or Self-Service BI are sought-after skills in many specialist departments, e.g. Marketing, HR or Finance. The training is also suitable for career changers .