Auditing Data using Pivot tables
I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look: How to perform Data Audit using Pivot
I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look: How to perform Data Audit using Pivot
Here is an interesting way to learn two things in one go. While creating the Power BI course for UDEMY, I created lot of explanatory videos. One of the DAX
Apps are great. But we are not great at using them. Useful ones do not get enough attention and useless ones we get addicted to. We waste our precious life
Yes I know. Nobody wants to see ads. But unfortunately that is not possible. If FB does not get some revenue, they will close down – like any other business.
Power BI and Power Map support mapping your own data using Latitude and Longitudes. Lat-longs are available in various formats. Power BI supports only decimal format. Unfortunately lot of data
Power BI Portal offers an amazing new way of creating reports. You can just type a question like “show total amount by country and by year”. Power BI now analyzes the
Very recently a nice new feature is added to Outlook. @name in Outlook is just like what we do in Twitter. You can just add @ followed by name of
VLOOKUP is one of the most commonly used functions in Excel. However, it comes with its own set of problems: It increases the file size It consumes lots of processing
Quick Calc in Power BI (Desktop as well as Portal) is a handy feature. Similar to Show Values As in Pivot Tables. How to use Quick Calc in Power BI
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
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.
