I love Coding, because it gives a lot of satisfaction. I suggest you to watch this video to know how to split columns in a Spreadsheet . ...

Power BI Webinar. Wish to Join. Please share your Email ID to Share the Teams Link Click on the above picture to access the meeting....

What is Column and What is Measure. When Column to be created and when the Measure is to be used . Explained in Simplified way for the...

Based on Recent Question from one of the Subscribers , Created a quick video to show how to Normalize complex Excel Data so that , you...

PowerPoint Support 3D Models and using 3D Models is really Fun in PowerPoint. If you can create your own 3D Models then more Fun....

When you are working with Pivot Tables , Slicers plays very important Role. They help us to filter data of All pivot Tables / Charts with...

HR - Recruitment Tracker - Creating Report using Power BI. In this Video a I have explained how to create a recruitment tracker using...

#PowerBI#HRAnalytics#RecruitmentTracker#PowerBIDesktop Most Common question is from any Power BI user , "How to Practice and how to get...

Have you tried using Python for Quick work in Excel or CSV. Watch this Video. I have explained how to Store data of CSV into Excel...

Python - is Powerful - is Fast - Can be integrated with many applications - Runs everywhere - Very friendly & easy to learn; - Most...

What is Personalized Visual. When this feature was introduced. What is new in Personalized visuals in Oct 2020 Update. To know about...

While working with Filter Pane, you can have more options to make it much clear and interesting to make it standout. While using many...

In the Latest update of Power BI Desktop (Oct 2020 ), few features I liked very much. I have shared my views . - New Logo - New Interface...

Watch this Video to know how quickly you can use Shapes to convert into an nice infographics

Some you may get bit complex Data in Excel. The Data with Merged Cells, Blanks, Multiple Column Headers, Some Time Data Title as Column...

While Presenting Any Report you must keep the Audience in view because they are your customers and you need to incorporate their...

New #VBA #Series is Coming up! Please be the #member of www.perepaedu.com and Subscribe to www.youtube.com/perepavijay Keep watching for...

Some times, even after applying Page / Report Level Filters, we may require few visuals should not interact with that Filter and they...

M Query is a Functional Language. While Transforming Data in Power Query knowledge of Table Functions and other Functions is an added...