Core Elements

• Power BI Desktop is a ETL tool
• Power Query M formula language
• DAX (Data Analysis Expression Language)
• Power BI Service
• Power BI Licensing (Pro / Premium)

---

📈 Main Tasks

1) Consume and Transform Data with Power BI Desktop

• Connect to data sources
• Perform transformations

2) Model and Visualize Data

• Create and optimize data models (normalization/de-normalization)
• Create calculated columns, tables, and measures
• Create and format interactive visualizations
• Manage custom reporting solutions

3) Configure Dashboards in the Power BI Service

• Publish dashboards
• Configure dashboards
• Configure security for dashboards
• Configure organizational content packs and apps

---

☁️ Eco-System

• Power Platform
• Power BI Service
• Power BI Documentation
• Power BI Blog
• Power BI Community
• Power BI Ideas
• Power BI Support
• Power BI Data Stories Gallery
• Exam PL-300: Microsoft Power BI Data Analyst

📑 Power BI Tools and Documentation

• Download Power BI tools and apps
• Power Query M formula language
• Data Analysis Expressions (DAX) Reference

🔧 External Tools

• DAX Formatter
• DAX Patterns
• DAX Studio
• Power BI Helper
• M Formatter

🎓 Basic Training

• Microsoft Learn for Power BI
• Introduction to Data Modeling for Power BI
• Introducing DAX Video Course

💡 References

• Curbal
• Guy in a Cube
• SQLBI
• RADACAD
• Book Collection