Split to rows – Analyse Surveys
In this video, I will show you how to use Power Query to split a column by a delimiter and create new rows for each value. This is useful when
In this video, I will show you how to use Power Query to split a column by a delimiter and create new rows for each value. This is useful when
Learn all about sorting in Excel. Simple sort, multi-level, custom order, formatting and more … Two detailed videos. First one is about native Excel features. Second one is about automating
Learn how to interactively filter data in Power BI reports using Slicers. Slicers are a powerful tool that allow you to filter and customize your data visualization in Power BI.
Recently Power BI Formatting changed for better. It is now almost similar to the way we format charts in Excel. This makes it easier for Excel users to learn Power
Decomposition tree is an amazing but lesser known (and used) visual in Power BI. It is a native visual and it is designed for data brainstorming (a term I coined
Power BI Modern Tooltips support drilldown and drill-through operations. Let us see how to build and use these rich tooltips. But that is not all. You can also use an
Excel Data Model has been there since 12 years. Despite that, it is not known to majority of Excel users. Even those who know about it do not use it
Budget vs actuals report is a very common need. It could also be target vs actuals or forecast vs actuals. The concept is same. We have two pieces of data.
Power BI Tutorial by Dr Nitin Paranjape. Based upon the Jul 2022 update. Covers entire data lifecycle step-by-step. Sample files included.