M.Y. BI and Analytics

The DAX formula codes suggested in the Video are :  1). Avg BP (Joint) Status =          SWITCH(             TRUE(),             [Average Systolic BP(Visual Total)] >=[Systolic_Max] || [Average Diastolic BP (Visual Total)]>=[Diastolic_Max], "Hypertnsion",             [Average Systolic BP(Visual Total)]<[Systolic_Max] && [Average Systolic BP(Visual Total)] >[Systolic_Min]                  && [Average Diastolic BP (Visual Total)]<[Diastolic_Max] && [Average Diastolic BP (Visual Total)] >[Diastolic_Min], "Normal",              [Average Systolic BP(Visual Total)]<=[Systolic_Min] || [Average Diastolic BP (Visual Total)]<=[Diastolic_Min] , "Low BP"         ) 2). Avg BP (Joint) Colour =          SWITCH( ...

Short and Simple Summaries (Data source from OpenAI): AI stands for Artificial Intelligence, which involves creating intelligent machines that can perform tasks that typically require human intelligence, such as visual perception, speech recognition, decision-making, and language translation. AI systems can be designed to learn from data and improve their performance over time. BI stands for Business Intelligence, which involves the use of data analytics tools and techniques to extract insights from data and inform business decisions. BI tools often involve collecting, analyzing, and presenting data in a way that makes it easy for business users to understand and act on. ML stands for Machine Learning, which is a subset of AI and involves using statistical and mathematical techniques to enable computer systems to learn from data and improve their performance without being explicitly programmed. ML algorithms can be used to analyze data, make predictions, and automate decision-making pr...

A calculated column is a column that you add to a table in a data model that is based on a DAX formula that you define. Calculated columns are calculated during the data refresh and the results are stored in the column for use in later operations. In this video, we use a calculated column by DAX SWITCH function to add a text string status to each record in a fact table. This status are used to categorize the records into different groups, which then be used to create visualizations. The DAX formula to create the calculated column for status in the video is:     Blood Pressure Status =               SWITCH(                         TRUE(),                         [Systolic BP]>=[Systolic_Max] || [Diastolic BP]>=[Diastolic_Max], "Hypertension",     ...