Posts

Power BI DAX & Visualizations: Calculated String Measures to State and Color Visual’s Value, Label and Title

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( ...

AI, BI and ML

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...

Power BI DAX: Add Text Status to Records with Calculated Column

Image
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",     ...

Power BI Memory and Performance Considerations

Excerpt From Book:  Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next leve l ,  Publication date: 20 Jan 2022, Author: Michiel Rozema, Henk Vlootman 1. Having fewer columns is better. 2. Use the Right data type. 3. Having many rows is no issues, but watch out for many values. 4. Avoid outliers - leave these values blank or choose special value that is close to actual values. 5. Do really need all that history? 6. Split columns for some cases: columns after split should end up with fewer distinct values.   

Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions

Image
  Power BI Modelling & DAX: Custom Sorting to Power BI Visuals with DAX DataTable Functions. DAX Codes for generating the DIM table: BP Indicator (Index by DAX) = DataTable ( "Attribute" , STRING, "Indicator" , STRING, "Index" , INTEGER,                {                           { "Systolic BP" , "Systolic" , 1 },                           { "Diastolic BP" , "Diastolic" , 2 },                           { "Heartbeat" , "Pulse" , 3 }                 }                 )

Power BI DAX: Dynamic Age Calculation with DATEDIFF and FORMAT

Image
  Question 1)  raised by my youtube video viewer on 23rd,Jan 2023: This is great. Just what I was looking for. I need to check for blanks in the birthday column because my blank birthdays are causing errors. How would you do this within your code Quick Answer to Question 1) on 23rd Jan 2023: Just a quick suggestion by following code. Age =     VAR MMDD_Num_Today = VALUE ( FORMAT ( TODAY (), "MMDD" ))     VAR MMDD_Num_BD =         IF ( ISBLANK ( 'Measured Personal Data' [Birthday] ),             "Blank" ,             'Measured Personal Data' [Birthday]             )     Return     if ( MMDD_Num_BD = "Blank" , 0 ,         if (             MMDD_Num_Today >= VALUE ( FORMAT ( MMDD_Num_BD , "MMDD" )),             DATEDIFF ( 'Measured Personal Da...

My Favourite Power BI related Books in 2022

List not in ranking order,  If you are the registered member of NLB (National Library Board Singapore), you are eligible to borrow these E-book freely via NLB Mobile App.     1).  Microsoft Power BI Data Analyst Certification Guide: A comprehensive guide to becoming a confident and certified Power BI professional - Publication date: 24 Jun 2022 -   Author:   Orrin Edenfield, Edward Corcoran - Contents: Overview of Power BI and the PL-300 Exam Connecting to Data Sources Profiling the Data Cleansing, Transforming, and Shaping Data Designing a Data Model Using Data Model Advanced Features Creating Measures Using DAX Optimizing Model Performance Creating Reports Creating Dashboards Enhancing Reports Exposing Insights from Data Performing Advanced Analytics Managing Workspaces Managing Datasets Practice Exams 2).  DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence -  Publication date: Ma...