Data Clean Up: Column groups into tabular columns
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.
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.
This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single
Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions. Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60
There are two simple approaches in reversing row order. One is to add an extra column with serial numbers and then sort on that column in descending order. This works
Just one button to press. Data – Remove Duplicate. Data should be a table (or like a table – column headings with data below). If it is a table choose
Single row of data which is split into two rows! Trying to clean-up such data is a frustrating experience. Here is how you do it – faster and smarter! 3 min
Unbelievable analytics using Excel: [youtube https://www.youtube.com/watch?v=vcwPk3eUxkg?rel=0] Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection
Yes. You read it correctly. Everyone does it. But still.It is very dangerous. DO NOT do it. Read on to find out why. Estimated reading time 7 min
Reports generated from business applications often become inputs to new reports. You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of
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.
