top of page
Search


How to Analyze Latest N Months Sales
Watch Video here https://www.youtube.com/watch?v=0sVrr2Hr514&t=219s Analysing Last N Months is an excellent way to get a quick,...

Vijay Perepa
Jul 121 min read


When to use Funnel Chart
When to use Funnel Chart A 𝒇𝒖𝒏𝒏𝒆𝒍 𝒄𝒉𝒂𝒓𝒕 is designed to visually represent data as it moves through various stages of a...

Vijay Perepa
Apr 71 min read


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


𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦 𝐃𝐚𝐭𝐚 𝐢𝐧𝐭𝐨 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: 🦋 𝐁𝐮𝐭𝐭𝐞𝐫𝐟𝐥𝐲 🦋 (🌪️ 𝐓𝐨𝐫𝐧𝐚𝐝𝐨 🌪️) 𝐂𝐡𝐚𝐫𝐭𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐒𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
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


𝐌𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐃𝐚𝐭𝐞 𝐅𝐨𝐫𝐦𝐚𝐭𝐬 𝐢𝐧 𝐒𝐚𝐦𝐞 𝐂𝐨𝐥𝐮𝐦𝐧 | 𝐏𝐨𝐰𝐞𝐫 𝐐𝐮𝐞𝐫𝐲
👉👉𝐖𝐚𝐭𝐜𝐡 𝐕𝐢𝐝𝐞𝐨 - 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


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

Vijay Perepa
Feb 111 min read


𝐁𝐫𝐞𝐚𝐤𝐢𝐧𝐠 𝐃𝐨𝐰𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜 𝐟𝐨𝐫 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬
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


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


𝐒𝐕𝐆 𝐀𝐧𝐢𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈!
👉👉 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


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


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

Vijay Perepa
Jan 21 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...

Vijay Perepa
Jun 1, 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

Vijay Perepa
May 25, 20241 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...

Vijay Perepa
May 22, 20242 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...

Vijay Perepa
May 19, 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...

Vijay Perepa
May 10, 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....

Vijay Perepa
May 3, 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...

Vijay Perepa
Jan 31, 20241 min read
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


🚀🚀 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
bottom of page