These PBI files are the results of the Udemy's course: "Curso Power BI – Análisis de Datos y Business Intelligence", by datdata.
The course consists of 5 main projects, each one more complete or complex than the previous one. In this way, the course explains the vast majority of tools that are available in Power BI:
- Connecting to different types of sources.
- Data cleaning and transformation with Power Query.
- Creating charts, tables, tooltips and other visualizations that work together with slicers to provide richer and easier data insights.
- Using of DAX formulas to enable even more custom and complex data transformations:
- SUM()
- COUNT()
- COUNTA()
- DISTINCTCOUNT()
- COUNTROWS()
- TOTALMTD()
- AVERAGE()
- SUMX()
- RANKX()
- DATEADD()
- DATESYTD()
- TOTALYTD()
- RELATED()
- NAMEOF()
- IF()
- SWITCH()
- TRUE()
- FORMAT()
- FILTER()
- ALL()
- GENERATESERIES()
- VAR
- RETURN
- MONTH
- YEAR
In this repository, I want to highlight the last 3 projects because they encapsulate most of the topics in the course. The last one is more focused on the DAX formulas, so the visuals are not well finished.
