top of page
Search


Data Pipelines in Microsoft Fabric and transform raw data using PySpark
👉👉Watch Video - https://youtu.be/Ptl7USRnj44 👈👈 In this step-by-step tutorial, we’ll show you how to: ✅ Connect and ingest CSV files...

Vijay Perepa
Feb 221 min read
2 views
0 comments


𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦 𝐃𝐚𝐭𝐚 𝐢𝐧𝐭𝐨 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: 🦋 𝐁𝐮𝐭𝐭𝐞𝐫𝐟𝐥𝐲 🦋 (🌪️ 𝐓𝐨𝐫𝐧𝐚𝐝𝐨 🌪️) 𝐂𝐡𝐚𝐫𝐭𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐒𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
In data analysis, visualization is key to telling impactful stories. My latest video demonstrates how to create a Butterfly (Tornado)...

Vijay Perepa
Feb 141 min read
3 views
0 comments


𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐃𝐚𝐭𝐞 𝐅𝐨𝐫𝐦𝐚𝐭𝐬 𝐢𝐧 𝐒𝐚𝐦𝐞 𝐂𝐨𝐥𝐮𝐦𝐧 | 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲
👉👉𝐖𝐚𝐭𝐜𝐡 𝐕𝐢𝐝𝐞𝐨 - https://youtu.be/LaNZt_lf-eo 👈👈 In many of my Excel trainings, and this applies to Power BI as well, I’ve...

Vijay Perepa
Feb 131 min read
0 views
0 comments


𝐃𝐚𝐭𝐚 𝐈𝐧𝐠𝐞𝐬𝐭𝐢𝐨𝐧 𝐭𝐨 𝐃𝐞𝐥𝐭𝐚 𝐓𝐚𝐛𝐥𝐞 𝐰𝐢𝐭𝐡 𝐃𝐚𝐭𝐚𝐟𝐥𝐨𝐰 𝐆𝐞𝐧2 | 𝐒𝐞𝐭 𝐃𝐞𝐟𝐚𝐮𝐥𝐭 𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐌𝐨𝐝𝐞𝐥 & 𝐁𝐮𝐢𝐥𝐝 𝐑𝐞𝐩𝐨𝐫𝐭𝐬 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛
👉👉 𝑾𝒂𝒕𝒄𝒉 𝑽𝒊𝒅𝒆𝒐 https://youtu.be/j9rdXD5mAno 👈👈 #PowerBI #DataAnalytics #ETL #Dataflows #PowerQuery #MicrosoftFabric #Busi...
Vijay Perepa
Feb 111 min read
2 views
0 comments


𝐁𝐫𝐞𝐚𝐤𝐢𝐧𝐠 𝐃𝐨𝐰𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜 𝐟𝐨𝐫 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬
Simple Data Ingestion! Watch the full tutorial here 👉 https://lnkd.in/gbxtsMW9 👈 If you've been wondering how to get started with...
Vijay Perepa
Feb 51 min read
2 views
0 comments


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...
Vijay Perepa
Feb 12 min read
42 views
0 comments


𝐒𝐕𝐆 𝐀𝐧𝐢𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈!
👉👉 Watch Video https://youtu.be/e5eZN0uzB3A 👈👈 Are you looking to enhance your Power BI dashboards with interactive and dynamic...
Vijay Perepa
Feb 11 min read
7 views
0 comments


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...
Vijay Perepa
Jan 41 min read
19 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐨𝐟 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈! 🐍
👉👉 𝘞𝘢𝘵𝘤𝘩 𝘵𝘩𝘦 𝘧𝘶𝘭𝘭 𝘵𝘶𝘵𝘰𝘳𝘪𝘢𝘭 𝘩𝘦𝘳𝘦: https://lnkd.in/ggJYPin5 👈👈 I am sharing here my video link where I have...
Vijay Perepa
Jan 21 min read
8 views
0 comments

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...
Vijay Perepa
Jun 1, 20241 min read
3 views
0 comments

Click for a Chart in Excel using VBA.
Do you wish to have a tutorial for this? Please comment below. #vba #excelvba #excelcharts #exceltipsandtricks
Vijay Perepa
May 25, 20241 min read
5 views
0 comments


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...
Vijay Perepa
May 22, 20242 min read
8 views
0 comments


Understanding Advanced Formulae in Excel:
#excelworld #exceltricks #excel #microsoft Understanding Advanced Formulae in Excel: Learn how to utilize the TAKE() function To extract...
Vijay Perepa
May 19, 20241 min read
4 views
0 comments


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...
Vijay Perepa
May 10, 20241 min read
14 views
0 comments
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....
Vijay Perepa
May 3, 20241 min read
12 views
0 comments
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...
Vijay Perepa
Jan 31, 20241 min read
14 views
0 comments
Custom Formulae using LAMBDACURRENT YEAR and SAMEPERIODLASTYEAR in EXCEL#lambda #customized #excel #timeseriesanalysis
https://www.youtube.com/shorts/oPR9GGS1bko
Vijay Perepa
Jan 30, 20241 min read
15 views
0 comments


🚀🚀 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...
Vijay Perepa
Dec 28, 20231 min read
31 views
0 comments


𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬: 𝐋𝐞𝐚𝐫𝐧 𝐇𝐨𝐰 𝐭𝐨 𝐄𝐚𝐬𝐢𝐥𝐲 𝐅𝐢𝐥𝐭𝐞𝐫 𝐚...
Vijay Perepa
May 20, 20231 min read
11 views
0 comments


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...
Vijay Perepa
May 4, 20231 min read
11 views
0 comments
bottom of page