[🏠Home](README.md)

[🏠Home](README.md)

<p align="left"><img src="https://github.com/potacho/power_bi_workshop/blob/master/images/logo.png"></p>

## __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)

---

## :chart_with_upwards_trend: __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

---

## :cloud: __Eco-System__
- [Power Platform](https://powerplatform.microsoft.com/)
- [Power BI Service](https://app.powerbi.com)
- [Power BI Documentation](https://docs.microsoft.com/en-us/power-bi/) 
- [Power BI Blog](https://powerbi.microsoft.com/en-us/blog/) 
- [Power BI Community](https://community.powerbi.com/)
- [Power BI Ideas](https://ideas.powerbi.com/ideas/)
- [Power BI Support](https://powerbi.microsoft.com/en-us/support/)
- [Power BI Data Stories Gallery](https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery)
- [Exam DA-100: Analyzing Data with Microsoft Power BI](https://docs.microsoft.com/en-us/learn/certifications/exams/da-100)


## :bookmark_tabs: __Power BI Tools and Documentation__
- [Download Power BI tools and apps](https://powerbi.microsoft.com/en-us/downloads/)
- [Power Query M formula language](https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference)
- [Data Analysis Expressions (DAX) Reference](https://docs.microsoft.com/en-us/dax/dax-function-reference)


## :wrench: __External Tools__ 
- [DAX Formatter](http://www.daxformatter.com/)
- [DAX Patterns](https://www.daxpatterns.com/patterns/)
- [DAX Studio](https://daxstudio.org/)
- [Power BI Helper](https://radacad.com/power-bi-helper)


## :mortar_board: __Basic Training__
- [Microsoft Learn for Power BI](https://docs.microsoft.com/en-us/learn/powerplatform/power-bi)
- [Introduction to Data Modeling for Power BI](https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/)
- [Introducing DAX Video Course](https://www.sqlbi.com/p/introducing-dax-video-course/)


## :bulb: __References__
- [Curbal](https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/videos)
- [Guy in a Cube](https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w/videos)
- [SQLBI](https://www.youtube.com/user/sqlbitv/videos)
- [RADACAD](https://www.youtube.com/channel/UCsOfIwAXj1fT6LDqEDEAb4g/videos)
- [Potacho's Book Collection](http://www.potacho.com/files/pbi/pbi_books.rar)