Sales Benchmarking Analysis in Power BI with Dynamic Red & Green Percentile Input Parameters. скачать в хорошем качестве

Sales Benchmarking Analysis in Power BI with Dynamic Red & Green Percentile Input Parameters.

This Power BI report is useful for sales benchmarking analysis to drive performance of the business, by grouping branches into Red, Green and Grey cohort. Learn how to create sales benchmarking in Power BI, so that branches can be automatically grouped in red, green and grey depending on percentile inputs parameters. Learn useful skills, such as: how to create charts, slicers and tables. how to create input and output percentile measures how to create colour measure that can be applied to charts how to change format as percentage how to create sales waterfall Hope you find this video useful. Kind regards, Isabella Susilowati ‪@LighthouseAnalytix‬ Timelines: 00:00 Intro 02:10 Rebuilding from scratch 02:48 Creating basic visuals: charts, slicers, and tables 04:24 Creating input and output percentiles 06:56 Creating sales colour measure 08:23 Refining DAX to remove colour from totals 09:10 Refining DAX region slicer 11:34 Creating input parameter slicers 15:23 Formatting as percentage 15:58 Last touches, including Sales Waterfall 20:29 Epilogue Music: Bensound License code: FXMRMU0FGF9DYKAE LA138