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...

Start Applying M Query and Understanding the Logic In this video few common functions are explained Keep watching! 😎

Power Query is the Data Transformation engine which can be used in many applications, and Power Query Editor is the Graphical User...

In this Video , I have Explained how to create a very quick video using the Power Query Model in Excel. How to create a Custom Column in...

As promised, I have started the Series - Learn Power Query and Power Query Editor. What is the difference between these two?! Power Query...

Power Query is a data transformation and data preparation engine. Power Query comes with a rich GUI for getting data from different...