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
Learn how to create a simple, but informative and interactive dashboard from daily updated data sourced from Johns Hopkins Institute. This uses on-cloud import using Power BI Dataflow. Interact with