Power Pivot Data Model adds database like features to Excel. Power Pivot allows you to handle millions of rows of data, from multiple data sources and lightening fast analysis. It
Here is a quick listing of the key differences from a usage point of view. It will help you choose the right type based upon the analytical objectives.
Here is a quick post to show the practical scenario when the Remove Top and Bottom Rows options are useful while cleaning up data using Power Query. Remove Top Rows
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]
Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can hide unwanted columns from appearing in the Pivot Table field list. This setting is
We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool
In the earlier article, we saw how Power BI Desktop can help us create complex, interactive, and useful reports from various sources of data. Here is a detailed walk-through of
Here is an animated globe showing the new year dawning across time zones. Created using Power Map. You can also create it using Excel 2013 onwards. In the next article,
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format) using Power Query. Watch the video.
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.
