Power BI Fundamentals: Reporting and Data Analysis
Description
In this "Power BI Fundamentals" basic training, we'll spend two days covering various aspects of data analysis with Power BI. You'll learn everything necessary for analyzing data in Power BI: from accessing and profiling data to sharing insights and conducting advanced analyses.
You aim to use Power BI to effectively support your data analyses. But it's not just about gaining insights yourself; you also want to design your reports so others can use them. You want to manage and transfer them responsibly, working safely according to best practices.
After this course:
- You will know how to access and process data from various sources
- You can implement good security standards and guidelines
- You will be proficient in managing, deploying, and sharing reports
- You will be capable of building, publishing, and integrating reports in Power BI.
Prerequisites for the "Power BI Fundamentals" Training
No specific prior knowledge is needed to start with Power BI. However, a feel for data and data analysis is necessary, as the goal of using Power BI is to apply data analysis within your organization. Participants should know how they will use data analysis in their daily work. Finally, access to Power BI Desktop on their own work laptop and a Power BI Pro account within their organization are required.
Topics
The "Power BI Fundamentals" training covers the following topics:
- Introduction
- Power BI Architecture
- Data Warehousing: Tables, Star Schemas
- Data Preparation
- Data Access from Various Sources
- Cleaning and ETL
- Loading Data with Power Query
- Automatically Reading Multiple Excel Sheets from a Folder
- Data Visualization
- Creating Reports
- Enriching Reports with Advanced Features
- Adding Filters: Visual, Page, or Report
- Interactive Reports
- KPI Dashboard: Actuals vs Targets
- Modeling and Analyzing
- Creating a Data Model (Star Schemas): One-to-Many, Many-to-Many Relationships
- Creating a Date Table
- DAX Formulas
- Difference Between Row Context and Filter Context
- Enriching Reports to Unlock Insights
- Measures: SUM, AVERAGE + COUNT
- Publishing Reports to the Power BI Portal
Study Material
In the training Power BI Fundamentals: Reporting and Data Analysis, we use material that we have developed ourselves at Wortell Smart Learning. We ensure that you receive all the necessary material in time.
Available dates
| Title | Date |
|---|---|
| Power BI Fundamentals (NL) day 1 | |
| Power BI Fundamentals (NL) day 2 |
| Title | Date |
|---|---|
| Power BI Fundamentals: Self-report and analyze data (EN) day 1 | |
| Power BI Fundamentals: Self-report and analyze data (EN) day 2 |
