Power BI Desktop - Oct 2020 Updates - What I Liked most Part 1
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...
top of page
Create account
+91 96113 44773
Search
Vijay Perepa
Oct 18, 20201 min read
How to Create infographics in Power Point
Watch this Video to know how quickly you can use Shapes to convert into an nice infographics
375 views0 comments
Vijay Perepa
Oct 15, 20201 min read
Normalizing Complex Excel Data using Power Query M Language - Learn Power Query - Part 8
Some you may get bit complex Data in Excel. The Data with Merged Cells, Blanks, Multiple Column Headers, Some Time Data Title as Column...
237 views0 comments
Vijay Perepa
Oct 13, 20201 min read
How to Display Overall Total along with Category in a Viz - Learn Power Query - Part 7
While Presenting Any Report you must keep the Audience in view because they are your customers and you need to incorporate their...
183 views0 comments
Vijay Perepa
Oct 10, 20201 min read
Pivot Tables with VBA - New Video Series
New #VBA #Series is Coming up! Please be the #member of www.perepaedu.com and Subscribe to www.youtube.com/perepavijay Keep watching for...
36 views0 comments
Vijay Perepa
Oct 4, 20201 min read
How to Manage Visuals while using Filters in Power BI
Some times, even after applying Page / Report Level Filters, we may require few visuals should not interact with that Filter and they...
89 views0 comments
Vijay Perepa
Oct 2, 20201 min read
Learn Power Query Part 6 - Using Table Functions
M Query is a Functional Language. While Transforming Data in Power Query knowledge of Table Functions and other Functions is an added...
160 views0 comments
Vijay Perepa
Oct 1, 20201 min read
Learn Power Query - Part 5 - How to use M Query Language
Start Applying M Query and Understanding the Logic In this video few common functions are explained Keep watching! 😎
122 views0 comments
Vijay Perepa
Sep 29, 20201 min read
Learn Power Query and Power Query Editor - Part 4 Understanding M Language A Functional Language
Power Query is the Data Transformation engine which can be used in many applications, and Power Query Editor is the Graphical User...
126 views0 comments
Vijay Perepa
Sep 28, 20201 min read
Learn Power Query - Part 3, Creating Quick Dashboard in Excel
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...
44 views0 comments
Vijay Perepa
Sep 28, 20201 min read
Learn Power Query and Power Query Editor - Part 1
As promised, I have started the Series - Learn Power Query and Power Query Editor. What is the difference between these two?! Power Query...
141 views0 comments
Vijay Perepa
Sep 27, 20201 min read
Power Query Editor - A Complete Course Online
Power Query is a data transformation and data preparation engine. Power Query comes with a rich GUI for getting data from different...
485 views0 comments
Vijay Perepa
Sep 24, 20201 min read
How to create a Complete Report using DAX and Slicers in Power BI
I have create a Playlist with 6 Videos showing how to create a comprehensive report using Simple DAX Functions. Also Explained how to...
343 views0 comments
Vijay Perepa
Sep 16, 20201 min read
How to Create Measure Table and Folders inside in Power BI Desktop
Managing and Staging Measures in a Proper Folders is one of the best Practices in Report building in Power BI. Please watch to know how...
104 views0 comments
Vijay Perepa
Sep 15, 20201 min read
How to Custom sort in Excel Sort data using a custom list
In Excel, you can quickly sort your data by using the A-Z and Z-A Sort buttons on the Ribbon's Data tab. Also you can Sort Data in a...
56 views0 comments
Vijay Perepa
Sep 14, 20201 min read
How to Create Ageing Analysis in Power BI
During one of Training Programs few participants are from Finance (predominantly, who deal with Receivables and Payables) , asked about...
1,102 views0 comments
Vijay Perepa
Sep 12, 20201 min read
How to add Animated Icons into Power BI Conditional Formatting
During one of my regular workshops , one participant asked whether he can add any animated pictures viz., gifs etc. instead of regular...
1,043 views0 comments
Vijay Perepa
Sep 12, 20201 min read
How to Create BUTTERFLY (Tornado, Pyramid) Chart
While Analyzing Data using Excel, Sometimes we require some Extra customized Charts to help us to tell the story of the data,much more...
99 views0 comments
Vijay Perepa
Sep 11, 20201 min read
How to import Data from Google Sheets to Excel / Power BI
How to import and Get connected Google Sheets to Excel. A simple Trick helps us to import Google Sheet Data to Excel . Also How to use...
123 views0 comments
bottom of page