---
type: learning
area: learning
status: learning
date: 2026-05-03
created: 2026-05-03
updated: 1980-01-01
tags:
  - learning
---
You’ve just been hired as a Business Intelligence Analyst by AdventureWorks*, a global
manufacturing company that produces cycling equipment and accessories

## Typical Power BI workflow
- ETL inside Power Query
- Load inside Power Bi frontend
	-  Frontend is:
		- Model view
		- Data view
		- Report view
Steps to follow:
 - 1 ETL inside **Power Query Editor**
 - 2 Data Modelling inside **Model View**
 - 3 Table features and calculation are added in **Data View**
 - 4 Creating visual and reports in **Report View**
![[img-20250308-120244-34ecdd43.png]]


### Best Practices
- Always Verify data types
- Always Change Table names to the best name

### Type of Connection modes
![[img-20250308-125216-3898d7ea.png]]