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
Power BI Tutorial by Dr Nitin Paranjape. Based upon the Jul 2022 update. Covers entire data lifecycle step-by-step. Sample files included.
Excel vs Power BI is a very commonly asked question during the sessions I conduct. However, a to-the-point comparison is not easily available. You will see lot of feature comparisons.
Finance and Accounting departments use Excel extensively. Advanced Excel is still the most sought after topic for training programs globally. We conducted this live event on 27th Feb 2021. This
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
