Blog | PerepaEdu

Vijay Perepa

Sep 28, 20210 min read

Power BI Dashboard

28 views0 comments

Quick Infographic Animation in PowerPoint

Vijay Perepa

Sep 4, 20210 min read

Quick Infographic Animation in PowerPoint

13 views0 comments

𝐂𝐢𝐫𝐜𝐥𝐞 𝐏𝐨𝐥𝐚𝐫 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐮𝐬𝐢𝐧𝐠 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬

Vijay Perepa

Aug 11, 20211 min read

𝐂𝐢𝐫𝐜𝐥𝐞 𝐏𝐨𝐥𝐚𝐫 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐮𝐬𝐢𝐧𝐠 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬

Tried using Polar Char in place of Pie/Donut Chart to show case the data of multiple variables. Pie / Donut don't support both positive...

333 views0 comments

Vijay Perepa

Aug 4, 20211 min read

𝐇𝐨𝐰 𝐭𝐨 𝐮𝐬𝐞 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

A Simple Column chart using R Visuals in Power BI. R is a language and environment for statistical computing and graphics and it is...

191 views0 comments

Vijay Perepa

Jul 11, 20211 min read

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐀𝐧𝐧𝐮𝐚𝐥 𝐆𝐫𝐨𝐰𝐭𝐡 𝐑𝐚𝐭𝐞

#CAGR#PowerBi# Dax Dynamic Compound Annual Growth Rate (CAGR) in Power BI. Tutorial will be published shortly! Also covering many...

124 views0 comments

𝐀𝐧𝐢𝐦𝐚𝐭𝐞 𝐂𝐡𝐚𝐫𝐭𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥 𝐒𝐡𝐨𝐫𝐭𝐥𝐲

Vijay Perepa

Jul 5, 20211 min read

𝐀𝐧𝐢𝐦𝐚𝐭𝐞 𝐂𝐡𝐚𝐫𝐭𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥 𝐒𝐡𝐨𝐫𝐭𝐥𝐲

Using small piece of code you can animated Charts in Excel like you can do in Power Point TUTORIAL WILL BE POSTED SHORTLY ! Keep watching...

49 views0 comments

Learn Excel VBA Hiding Objects and Charts in A spreadsheet

Vijay Perepa

Jun 28, 20211 min read

Learn Excel VBA Hiding Objects and Charts in A spreadsheet

Learning VBA is very helpful to automate certain activities may be they are simple or complex. In this Video I have shown how to Show or...

33 views0 comments

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐉𝐮𝐧𝐞 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐅𝐞𝐰 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐨𝐢𝐧𝐭𝐬

Vijay Perepa

Jun 26, 20211 min read

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐉𝐮𝐧𝐞 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐅𝐞𝐰 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐨𝐢𝐧𝐭𝐬

June 2021 update of Power BI is out. Few very important points Reporting options: Paginated Report Visual in Power BI Desktop (Preview)...

283 views0 comments

Vijay Perepa

Jun 25, 20211 min read

Power BI Webinar

Link to the Webinar : MS Teams

72 views0 comments

𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐮𝐭𝐨 𝐖𝐢𝐝𝐭𝐡 𝐉𝐮𝐬𝐭 𝐛𝐲 𝐬𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐂𝐞𝐥𝐥

Vijay Perepa

Jun 24, 20211 min read

𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐮𝐭𝐨 𝐖𝐢𝐝𝐭𝐡 𝐉𝐮𝐬𝐭 𝐛𝐲 𝐬𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐂𝐞𝐥𝐥

Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

92 views0 comments

Vijay Perepa

Jun 17, 20210 min read

My Latest Report

5 views0 comments

Creating Vibrant Background images for Power BI Desktop

Vijay Perepa

Jun 2, 20210 min read

Creating Vibrant Background images for Power BI Desktop

164 views0 comments

For Power BI Learners - What should be the approach!

Vijay Perepa

May 15, 20212 min read

For Power BI Learners - What should be the approach!

𝗡𝗼𝘁𝗲: 𝗠𝘆 𝗥𝗲𝗾𝘂𝗲𝘀𝘁 𝘁𝗼 𝘁𝗵𝗲 𝗿𝗲𝗮𝗱𝗲𝗿𝘀 𝘁𝗼 𝘁𝗮𝗸𝗲 𝘁𝗵𝗶𝘀 𝗮𝘀 𝗮 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸 𝗼𝗻𝗹𝘆! 𝗔𝗻𝘆...

392 views0 comments

Vijay Perepa

May 11, 20211 min read

𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐂𝐚𝐫𝐝 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 - 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

While dealing with YoY comparisons and Cards, you may require flexibility to show the values based on selection and other conditions. In...

219 views0 comments

Vijay Perepa

Apr 25, 20211 min read

𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐫 + 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 = 𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐓𝐨𝐩 𝟓 𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐥𝐞 𝐚𝐧𝐝 𝐋𝐨𝐬𝐬 𝐌𝐚𝐤𝐢𝐧𝐠 𝐁𝐫𝐚𝐧𝐜𝐡𝐞𝐬 𝐮𝐬𝐢𝐧𝐠 𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐭𝐨𝐫...

226 views0 comments

There is only one action which doesn't have straight Key Board Short Cut in Excel.

Vijay Perepa

Apr 24, 20211 min read

There is only one action which doesn't have straight Key Board Short Cut in Excel.

Do you know what is that? And you wish to create your own Short Cut using a single VBA Statement Application.CommandbarsApplication.Comma...

12 views0 comments

Vijay Perepa

Apr 23, 20210 min read

𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲 𝐊𝐞𝐲 𝐁𝐨𝐚𝐫𝐝 𝐒𝐡𝐨𝐫𝐭 𝐂𝐮𝐭𝐬

80 views0 comments

Know All Functions in Power Query ( M Language)

Vijay Perepa

Apr 21, 20211 min read

Know All Functions in Power Query ( M Language)

Get the complete list of Functions available in M Language with small step. Coming up with a new series of Videos . To get notified...

132 views0 comments

𝗖𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗲𝘀𝗲𝗻𝘁 & 𝗘𝘅𝗽𝗹𝗮𝗶𝗻 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗹𝗶𝗸𝗲 𝘄𝗲 𝗱𝗼?

Vijay Perepa

Apr 13, 20211 min read

𝗖𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗲𝘀𝗲𝗻𝘁 & 𝗘𝘅𝗽𝗹𝗮𝗶𝗻 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗹𝗶𝗸𝗲 𝘄𝗲 𝗱𝗼?

Imagine if Excel started Talking to you and present the Data and Charts and also giving explanation about the Data, and there is less...

98 views0 comments

Vijay Perepa

Apr 11, 20211 min read

𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐰𝐢𝐭𝐡 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

ʟᴇᴀʀɴ ᴠᴀʀɪᴏᴜꜱ ᴇʟᴇᴍᴇɴᴛꜱ ᴏꜰ ᴄʜᴀʀᴛꜱ ɪɴ ᴘᴏᴡᴇʀ ʙɪ ᴀɴᴅ ᴘʏᴛʜᴏɴ While using a reporting Tool, some times the Customer requirements are tricky and...

1,024 views0 comments