Archive for the ‘Power BI’ Category
Microsoft Power BI – how to create a wide variety of new charts
Mittwoch, Februar 28th, 2024Microsoft Power BI – Monthly Update February 2024
Mittwoch, Februar 21st, 2024Microsoft Power BI – convert D:HH:MM:SS (text) to Days (dec)
Samstag, Februar 10th, 2024One way to do this is to split the column by delimiter (colon in this case) to get separate columns for days hours minutes and seconds
and then add a custom column using this formula
[Text.1] + ([Text.2]/24) + ([Text.3]/1440) + ([Text.4]/86400)
Microsoft Power BI – three hacks to work faster
Mittwoch, Januar 24th, 2024Microsoft Power BI – Data Visualization with Box Plots versus Violin Plots
Sonntag, Dezember 17th, 2023Comparing the two plots the box plot is a cleaner summary of the data than the violin plot it’s easier to compare statistics between the groups with a box plot this makes a box plot worth more consideration if you have a lot of groups to compare or if you are building explanatory plots you can clearly see from the box plot that the Delta group has the lowest median on the other hand the box plot lacks as nuanced a depiction of distributions as the violin plot you can’t see the slight bimodality present in the Alpha level values the violin plot may be a better option for exploration especially since seaborn’s implementation also includes the box plot by default