top of page
Search



Vijay Perepa
Dec 21, 20210 min read



Vijay Perepa
Dec 12, 20210 min read



Vijay Perepa
Dec 1, 20210 min read


New Format Pane for Page and Visuals 📊
Power BI - Nov 2021 Updates New Format Pane for Page and Visuals 📊 Also you can use Bold / Italic / Underline ! (Same as Excel ,...

Vijay Perepa
Nov 22, 20211 min read


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐍𝐨𝐯 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐏𝐚𝐠𝐞𝐍𝐚𝐯𝐢𝐠𝐚𝐭𝐢𝐨𝐧
Power - BI Nov 2021 Update brought many more best features . I will sharing most of the features thru small videos to get better idea....

Vijay Perepa
Nov 18, 20211 min read


Let's Compare Power Query Functions and Excel Formulae
Comparison of Text Formulas in Excel and in Power Query

Vijay Perepa
Nov 13, 20211 min read


R Simple Plotting
R (Simple) Plot #rlanguage #perepaedu#learning

Vijay Perepa
Nov 7, 20211 min read


Let's hae very basic understanding of SQL
What is Schema Object? The Schema Object where the SQL Data is stored There are 12 Types of Schema Object 1. Base Table 2. View 3. Domain...

Vijay Perepa
Nov 3, 20211 min read


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐂𝐨𝐥𝐨𝐫 𝐂𝐡𝐚𝐧𝐠𝐞 𝐢𝐧 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐰𝐢𝐭𝐡 𝐬𝐥𝐢𝐜𝐞𝐫
This is a known tip to many, but beginners of Power BI , this must be a useful tip. Step 1 - Create a Clustered Column Chart Step 2 -...

Vijay Perepa
Oct 24, 20211 min read


𝐒𝐦𝐚𝐥𝐥 𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞𝐬 - 𝐏𝐢𝐞 𝐂𝐡𝐚𝐫𝐭 - 𝐑 & 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
While using small multiples Feature in Power BI , one thing you may notice that you cannot have Small Multiples for PIE . To get small...

Vijay Perepa
Oct 17, 20211 min read


𝐃𝐞𝐞𝐩 𝐃𝐢𝐯𝐞 𝐞𝐢𝐭𝐡𝐞𝐫 𝐰𝐢𝐭𝐡 𝐃𝐀𝐗 𝐨𝐫 𝐉𝐮𝐬𝐭 𝐰𝐢𝐭𝐡 𝐑𝐢𝐠𝐡𝐭 𝐌𝐨𝐮𝐬𝐞 𝐂𝐥𝐢𝐜
One of the best feature available with Power BI Since beginning. To know watch this Video

Vijay Perepa
Oct 6, 20211 min read

Vijay Perepa
Sep 28, 20210 min read



Vijay Perepa
Sep 4, 20210 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...

Vijay Perepa
Aug 11, 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...

Vijay Perepa
Aug 4, 20211 min read


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐀𝐧𝐧𝐮𝐚𝐥 𝐆𝐫𝐨𝐰𝐭𝐡 𝐑𝐚𝐭𝐞
#CAGR#PowerBi# Dax Dynamic Compound Annual Growth Rate (CAGR) in Power BI. Tutorial will be published shortly! Also covering many...

Vijay Perepa
Jul 11, 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...

Vijay Perepa
Jul 5, 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...

Vijay Perepa
Jun 28, 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)...

Vijay Perepa
Jun 26, 20211 min read


Power BI Webinar
Link to the Webinar : MS Teams

Vijay Perepa
Jun 25, 20211 min read
bottom of page





