Power BI Fundamentals (Eng) (2 days) | Kolding
Do you want to learn how to build professional reports and dashboards using Microsoft Power BI? Would you like to gain broad skills across all areas of Power BI and learn best practices for data modeling and data visualization? Then this course is relevant for you.
This course is designed for report developers, Excel users, and other business professionals who work with data and reporting on a daily basis, and who want to gain solid knowledge and practical skills across all areas of Power BI.
About the Course
The course is structured around six modules:
- Module 1: Get and Transform Data
- Module 2: Data Modeling
- Module 3: Analyze Data with DAX
- Module 4: Data Visualization
- Module 5: Publishing
- Module 6: Power BI Services
In this course, we use the applications Power BI Desktop and Power BI Services (cloud), both part of the Microsoft Power BI platform.
Why attend this course?
Expand your skills in data analysis with Power BI. Since 2015, Power BI has been Microsoft’s platform for analytics and business intelligence. It integrates closely with Excel and is recommended by Microsoft as the preferred tool for data visualization.
Power BI is widely implemented in companies and public organizations, which creates strong demand for employees and data analysts with Power BI skills for data analysis and reporting.
What will you gain from the course?
In this course, the focus is on learning how to build user-friendly, professional Power BI reports from scratch following best practices.
You will learn to work across all key areas of Power BI, including:
- Introduction to Power BI
- The Power BI universe
- Data modeling theory and best practices
- The work flow in Power BI
- The Power Query Editor
- Creating queries in Power Query
- Transforming data using ETL tools
- Introduction to M code in Power Query
- Building dimension and fact tables
- Data modeling
- Relationships and data modeling concepts
- Cardinality and filter direction
- Introduction to DAX for data analysis
- Understanding DAX syntax
- Measures and calculated columns
- Basic DAX measures to start your analysis
- Advanced DAX functions such as CALCULATE
- Iterator functions such as SUMX and COUNTX
- Filter functions
- Data visualization
- Professional design and layout
- Storytelling with data
- Conditional formatting
- User-friendly functionality
- Power BI Services (Cloud)
- Introduction to Power BI Services
- Gateways and types of data sources
- Data refresh
- Export to PowerPoint and PDF
- Export to Excel
- Integration with Microsoft Teams and SharePoint
Please note that your registration is only confirmed once you receive a final confirmation from us.
We look forward to welcoming you to the course!
The course is held at:
Comwell Kolding
Skovbrynet 1
6000 Kolding
Denmark
Courses are generally held at the advertised location; however, changes to the venue may occur if necessary.
If you have any questions for the instructor about this course, you can contact:
Rita Linde, Power BI Consultant
rita@powerguide.dk | tlf. 26141116 | Rita Linde | LinkedIn