What Even Is Power BI?
Power BI is a data visualization and business intelligence tool by Microsoft. You use it to connect to data, clean it, analyze it, and build dashboards and reports.
Power BI vs Excel
Excel makes you do the work every time something changes. Power BI does the work for you automatically
Power Query
Before you can analyze anything, your data needs to be clean. Power Query is the tool inside Power BI where you do all that cleaning.
DAX — The Formula Language of Power BI
DAX stands for Data Analysis Expressions. It is the formula language of Power BI. Everything you write in the formula bar in Power BI is DAX.
Measures vs Calculated Columns
A Calculated Column adds a new column to your table. It calculates a value per row and store there permanently.
Top comments (0)