How Analysts translate Messy Data, DAX and Dashboards into Action using Power BI

You have done your data modelling and your dataset is well structured and preferably in a star schema. The relationships are correct. Then what? This data is still raw data and it does not answer any questions the business is asking. What is the total revenue? What is the cost of production? You cant outright answer this questions. This is where DAX comes in. DAX- Data Analysis Expressions This is a powerful formula language used in Power BI. It is essential for creating calculations that unlock insights into your data. It is what says " revenue this year is higher than last year" or " cost of production this year is up 4% as compared to last year". DAX is important so as to optimize decision making in a business. Calculated Columns and Measures in DAX Calculated Column: This performs a row by row calculation in a table. Measure: This returns a singular value for the context you choose(filter, aggregation) DAX Functions Text Functions They manipulate texts. Concatenate/ConcatenateX Con