top of page
Search



Vijay Perepa
Dec 12, 20210 min read
55 views
0 comments



Vijay Perepa
Dec 1, 20210 min read
68 views
0 comments


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
140 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐍𝐨𝐯 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐏𝐚𝐠𝐞𝐍𝐚𝐯𝐢𝐠𝐚𝐭𝐢𝐨𝐧
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
43 views
0 comments


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
11 views
0 comments


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

Vijay Perepa
Nov 7, 20211 min read
39 views
0 comments


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
13 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐂𝐨𝐥𝐨𝐫 𝐂𝐡𝐚𝐧𝐠𝐞 𝐢𝐧 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐰𝐢𝐭𝐡 𝐬𝐥𝐢𝐜𝐞𝐫
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
384 views
0 comments


𝐒𝐦𝐚𝐥𝐥 𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞𝐬 - 𝐏𝐢𝐞 𝐂𝐡𝐚𝐫𝐭 - 𝐑 & 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
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
621 views
0 comments


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

Vijay Perepa
Oct 6, 20211 min read
52 views
0 comments

Vijay Perepa
Sep 28, 20210 min read
28 views
0 comments



Vijay Perepa
Sep 4, 20210 min read
13 views
0 comments


𝐂𝐢𝐫𝐜𝐥𝐞 𝐏𝐨𝐥𝐚𝐫 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐮𝐬𝐢𝐧𝐠 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬
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
333 views
0 comments


𝐇𝐨𝐰 𝐭𝐨 𝐮𝐬𝐞 𝐑 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
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
191 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐀𝐧𝐧𝐮𝐚𝐥 𝐆𝐫𝐨𝐰𝐭𝐡 𝐑𝐚𝐭𝐞
#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
124 views
0 comments


𝐀𝐧𝐢𝐦𝐚𝐭𝐞 𝐂𝐡𝐚𝐫𝐭𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥 𝐒𝐡𝐨𝐫𝐭𝐥𝐲
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
49 views
0 comments


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
33 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - 𝐉𝐮𝐧𝐞 𝟐𝟎𝟐𝟏 𝐔𝐩𝐝𝐚𝐭𝐞𝐬 - 𝐅𝐞𝐰 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐨𝐢𝐧𝐭𝐬
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
283 views
0 comments


Power BI Webinar
Link to the Webinar : MS Teams

Vijay Perepa
Jun 25, 20211 min read
72 views
0 comments


𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐮𝐭𝐨 𝐖𝐢𝐝𝐭𝐡 𝐉𝐮𝐬𝐭 𝐛𝐲 𝐬𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐂𝐞𝐥𝐥
Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

Vijay Perepa
Jun 24, 20211 min read
92 views
0 comments
bottom of page