top of page
Search
![](https://i.ytimg.com/vi/qnJBsB0U-4k/sddefault.jpg)
![𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦 𝐃𝐚𝐭𝐚 𝐢𝐧𝐭𝐨 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: 🦋 𝐁𝐮𝐭𝐭𝐞𝐫𝐟𝐥𝐲 🦋 (🌪️ 𝐓𝐨𝐫𝐧𝐚𝐝𝐨 🌪️) 𝐂𝐡𝐚𝐫𝐭𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐒𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈](https://i.ytimg.com/vi/qnJBsB0U-4k/sddefault.jpg)
Vijay Perepa
4 days ago1 min read
𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦 𝐃𝐚𝐭𝐚 𝐢𝐧𝐭𝐨 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: 🦋 𝐁𝐮𝐭𝐭𝐞𝐫𝐟𝐥𝐲 🦋 (🌪️ 𝐓𝐨𝐫𝐧𝐚𝐝𝐨 🌪️) 𝐂𝐡𝐚𝐫𝐭𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐒𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
In data analysis, visualization is key to telling impactful stories. My latest video demonstrates how to create a Butterfly (Tornado)...
1 view0 comments
![](https://i.ytimg.com/vi/LaNZt_lf-eo/sddefault.jpg)
![𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐃𝐚𝐭𝐞 𝐅𝐨𝐫𝐦𝐚𝐭𝐬 𝐢𝐧 𝐒𝐚𝐦𝐞 𝐂𝐨𝐥𝐮𝐦𝐧 | 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲](https://i.ytimg.com/vi/LaNZt_lf-eo/sddefault.jpg)
Vijay Perepa
5 days ago1 min read
𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐃𝐚𝐭𝐞 𝐅𝐨𝐫𝐦𝐚𝐭𝐬 𝐢𝐧 𝐒𝐚𝐦𝐞 𝐂𝐨𝐥𝐮𝐦𝐧 | 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲
👉👉𝐖𝐚𝐭𝐜𝐡 𝐕𝐢𝐝𝐞𝐨 - https://youtu.be/LaNZt_lf-eo 👈👈 In many of my Excel trainings, and this applies to Power BI as well, I’ve...
0 views0 comments
![](https://i.ytimg.com/vi/Mq8CLZ3Hh_k/maxresdefault.jpg)
![𝐃𝐚𝐭𝐚 𝐈𝐧𝐠𝐞𝐬𝐭𝐢𝐨𝐧 𝐭𝐨 𝐃𝐞𝐥𝐭𝐚 𝐓𝐚𝐛𝐥𝐞 𝐰𝐢𝐭𝐡 𝐃𝐚𝐭𝐚𝐟𝐥𝐨𝐰 𝐆𝐞𝐧2 | 𝐒𝐞𝐭 𝐃𝐞𝐟𝐚𝐮𝐥𝐭 𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐌𝐨𝐝𝐞𝐥 & 𝐁𝐮𝐢𝐥𝐝 𝐑𝐞𝐩𝐨𝐫𝐭𝐬 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛](https://i.ytimg.com/vi/Mq8CLZ3Hh_k/maxresdefault.jpg)
Vijay Perepa
Feb 111 min read
𝐃𝐚𝐭𝐚 𝐈𝐧𝐠𝐞𝐬𝐭𝐢𝐨𝐧 𝐭𝐨 𝐃𝐞𝐥𝐭𝐚 𝐓𝐚𝐛𝐥𝐞 𝐰𝐢𝐭𝐡 𝐃𝐚𝐭𝐚𝐟𝐥𝐨𝐰 𝐆𝐞𝐧2 | 𝐒𝐞𝐭 𝐃𝐞𝐟𝐚𝐮𝐥𝐭 𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐌𝐨𝐝𝐞𝐥 & 𝐁𝐮𝐢𝐥𝐝 𝐑𝐞𝐩𝐨𝐫𝐭𝐬 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛
👉👉 𝑾𝒂𝒕𝒄𝒉 𝑽𝒊𝒅𝒆𝒐 https://youtu.be/j9rdXD5mAno 👈👈 #PowerBI #DataAnalytics #ETL #Dataflows #PowerQuery #MicrosoftFabric #Busi...
2 views0 comments
![](https://i.ytimg.com/vi/6iTu3RYKbTU/maxresdefault.jpg)
![𝐁𝐫𝐞𝐚𝐤𝐢𝐧𝐠 𝐃𝐨𝐰𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜 𝐟𝐨𝐫 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬](https://i.ytimg.com/vi/6iTu3RYKbTU/maxresdefault.jpg)
Vijay Perepa
Feb 51 min read
𝐁𝐫𝐞𝐚𝐤𝐢𝐧𝐠 𝐃𝐨𝐰𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜 𝐟𝐨𝐫 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬
Simple Data Ingestion! Watch the full tutorial here 👉 https://lnkd.in/gbxtsMW9 👈 If you've been wondering how to get started with...
2 views0 comments
![](https://i.ytimg.com/vi/e5eZN0uzB3A/maxresdefault.jpg)
![Creating an Animated Circular Progress Bar with SVG](https://i.ytimg.com/vi/e5eZN0uzB3A/maxresdefault.jpg)
Vijay Perepa
Feb 12 min read
Creating an Animated Circular Progress Bar with SVG
Complete Tutorial (Youtube link) - Below is the snippet for SVG Code with Explanation Introduction SVG (Scalable Vector Graphics) is a...
32 views0 comments
![](https://i.ytimg.com/vi/e5eZN0uzB3A/maxresdefault.jpg)
![𝐒𝐕𝐆 𝐀𝐧𝐢𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈!](https://i.ytimg.com/vi/e5eZN0uzB3A/maxresdefault.jpg)
Vijay Perepa
Feb 11 min read
𝐒𝐕𝐆 𝐀𝐧𝐢𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈!
👉👉 Watch Video https://youtu.be/e5eZN0uzB3A 👈👈 Are you looking to enhance your Power BI dashboards with interactive and dynamic...
5 views0 comments
![](https://i.ytimg.com/vi/1bIRmzpAoE8/maxresdefault.jpg)
![Create Interactive Flip Cards in Power BI with HTML & CSS!](https://i.ytimg.com/vi/1bIRmzpAoE8/maxresdefault.jpg)
Vijay Perepa
Jan 41 min read
Create Interactive Flip Cards in Power BI with HTML & CSS!
👉👉 Watch Tutorial - https://lnkd.in/gqi56A_i Learn how to use HTML & CSS to create dynamic and engaging flip cards that display...
9 views0 comments
![](https://static.wixstatic.com/media/c0f6b5_e07843cb81a949a6972f69b3c0ee5517~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/c0f6b5_e07843cb81a949a6972f69b3c0ee5517~mv2.webp)
![𝐏𝐨𝐰𝐞𝐫 𝐨𝐟 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈! 🐍](https://static.wixstatic.com/media/c0f6b5_e07843cb81a949a6972f69b3c0ee5517~mv2.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/c0f6b5_e07843cb81a949a6972f69b3c0ee5517~mv2.webp)
Vijay Perepa
Jan 21 min read
𝐏𝐨𝐰𝐞𝐫 𝐨𝐟 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈! 🐍
👉👉 𝘞𝘢𝘵𝘤𝘩 𝘵𝘩𝘦 𝘧𝘶𝘭𝘭 𝘵𝘶𝘵𝘰𝘳𝘪𝘢𝘭 𝘩𝘦𝘳𝘦: https://lnkd.in/ggJYPin5 👈👈 I am sharing here my video link where I have...
8 views0 comments
![The Most Powerful VBA Tricks: UDF Secrets](https://static.wixstatic.com/media/c0f6b5_8c23269f557747f4acdc61bedfa01d02~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/c0f6b5_8c23269f557747f4acdc61bedfa01d02~mv2.webp)
Vijay Perepa
Jun 1, 20241 min read
The Most Powerful VBA Tricks: UDF Secrets
User-Defined Functions (UDFs) in VBA (Visual Basic for Applications) are custom functions that you can create to perform calculations or...
3 views0 comments
![Click for a Chart in Excel using VBA.](https://static.wixstatic.com/media/c0f6b5_d57c41119bf34c87b7d376f2bb2f5723~mv2.webp)
Vijay Perepa
May 25, 20241 min read
Click for a Chart in Excel using VBA.
Do you wish to have a tutorial for this? Please comment below. #vba #excelvba #excelcharts #exceltipsandtricks
5 views0 comments
![](https://i.ytimg.com/vi/MQeoMuJwpsE/maxresdefault.jpg)
![Microsoft Fabric: From CSV to Delta Table with Spark and SQL Magic!](https://i.ytimg.com/vi/MQeoMuJwpsE/maxresdefault.jpg)
Vijay Perepa
May 22, 20242 min read
Microsoft Fabric: From CSV to Delta Table with Spark and SQL Magic!
What is Covered: Introduction to Microsoft Fabric: Learn what Microsoft Fabric is and how it can revolutionize your data management and...
8 views0 comments
![](https://static.wixstatic.com/media/c0f6b5_3477ef2e9b314317a501bd21d681c937f000.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/c0f6b5_3477ef2e9b314317a501bd21d681c937f000.webp)
![Understanding Advanced Formulae in Excel:](https://static.wixstatic.com/media/c0f6b5_3477ef2e9b314317a501bd21d681c937f000.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/c0f6b5_3477ef2e9b314317a501bd21d681c937f000.webp)
Vijay Perepa
May 19, 20241 min read
Understanding Advanced Formulae in Excel:
#excelworld #exceltricks #excel #microsoft Understanding Advanced Formulae in Excel: Learn how to utilize the TAKE() function To extract...
4 views0 comments
![](https://i.ytimg.com/vi/FXpTBB_DNGA/maxresdefault.jpg)
![How to Create Fiscal Calendar using LAMBDA Function in Excel](https://i.ytimg.com/vi/FXpTBB_DNGA/maxresdefault.jpg)
Vijay Perepa
May 10, 20241 min read
How to Create Fiscal Calendar using LAMBDA Function in Excel
In this tutorial, we have explained how to create fiscal calendar with the powerful LAMBDA function in Excel. A fiscal calendar, unlike a...
12 views0 comments
Vijay Perepa
May 3, 20241 min read
Understanding Calculation Groups (CG) in Power BI
Understanding Calculation Groups (CG) in Power BI is a valuable skill that can help you reduce the number of measures you need to create....
12 views0 comments
Vijay Perepa
Jan 31, 20241 min read
CURRENTMONTH( ) FUNCTION in EXCEL?
The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial...
14 views0 comments
Vijay Perepa
Jan 30, 20241 min read
Custom Formulae using LAMBDACURRENT YEAR and SAMEPERIODLASTYEAR in EXCEL#lambda #customized #excel #timeseriesanalysis
https://www.youtube.com/shorts/oPR9GGS1bko
15 views0 comments
![](https://i.ytimg.com/vi/M8I3yk-OaRI/sddefault.jpg)
![🚀🚀 Transforming Insights: Elevate User Experience with Dynamic SVG Animations in Power BI 🌼🌼](https://i.ytimg.com/vi/M8I3yk-OaRI/sddefault.jpg)
Vijay Perepa
Dec 28, 20231 min read
🚀🚀 Transforming Insights: Elevate User Experience with Dynamic SVG Animations in Power BI 🌼🌼
Animated SVGs (Scalable Vector Graphics) offer a dynamic and interactive dimension to your Power BI reports, enhancing user engagement...
31 views0 comments
![](https://i.ytimg.com/vi/iMqrs6z_Zhs/maxresdefault.jpg)
![𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬](https://i.ytimg.com/vi/iMqrs6z_Zhs/maxresdefault.jpg)
Vijay Perepa
May 20, 20231 min read
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬: 𝐋𝐞𝐚𝐫𝐧 𝐇𝐨𝐰 𝐭𝐨 𝐄𝐚𝐬𝐢𝐥𝐲 𝐅𝐢𝐥𝐭𝐞𝐫 𝐚...
11 views0 comments
![](https://i.ytimg.com/vi/fqlC6IL4hZU/maxresdefault.jpg)
![Unlocking the Power of VBA Visuals: See How to Create a Quick Bookmark Chart in less than 5 Minutes](https://i.ytimg.com/vi/fqlC6IL4hZU/maxresdefault.jpg)
Vijay Perepa
May 4, 20231 min read
Unlocking the Power of VBA Visuals: See How to Create a Quick Bookmark Chart in less than 5 Minutes
When you have a summary Visual which shows Revenue by Country, for which you may want to show the sub plots / visuals by City for...
11 views0 comments
![](https://static.wixstatic.com/media/c0f6b5_81f28b225ef24c58bd2d01ff08b4ab86f000.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/c0f6b5_81f28b225ef24c58bd2d01ff08b4ab86f000.webp)
![𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |](https://static.wixstatic.com/media/c0f6b5_81f28b225ef24c58bd2d01ff08b4ab86f000.jpg/v1/fill/w_454,h_341,fp_0.50_0.50,q_90,enc_auto/c0f6b5_81f28b225ef24c58bd2d01ff08b4ab86f000.webp)
Vijay Perepa
May 1, 20231 min read
𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |
𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 || 𝐒𝐭𝐨𝐫𝐲 𝐓𝐞𝐥𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡...
9 views0 comments
bottom of page