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.
Distinct count is not available in Pivot Table by default. However, if you create a pivot table using data in data model, you can get this option. As an additional
Once you know how to convert crosstab to tabular format, your data processing becomes super-fast and efficient. Most people struggle with multiple crosstab inputs and waste enormous amount of time
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