Combine data from multiple files / sheets
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.
This is a part of data clean up series based upon the 10 rules for clean data. This video covers rules 1, 5, 6, 10 – cross-tabs, data growing horizontally
Starting a new video series on Power BI. Here is the first video: Power BI Data Import.
We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all
Just released Excel Tables comprehensive video. Have a look. It shows many benefits of using Tables like automatic formula copy, dependents update, structured formulas, automatic headers, easier import in Power
A brilliant new feature is now available in Power BI – Split column into rows. To understand why we need it, you must go and read the article – Analyzing
Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to
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]
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.
