top of page
Search


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


𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬: 𝐋𝐞𝐚𝐫𝐧 𝐇𝐨𝐰 𝐭𝐨 𝐄𝐚𝐬𝐢𝐥𝐲 𝐅𝐢𝐥𝐭𝐞𝐫 𝐚...

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

Vijay Perepa
May 4, 20231 min read


𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |
𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 || 𝐒𝐭𝐨𝐫𝐲 𝐓𝐞𝐥𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡...

Vijay Perepa
May 1, 20231 min read


How to Create a Lollipop Chart in Power BI less than 10 minutes
#powerbi#python#lollipop In this video, I'll show you how to create a lollipop chart in Power BI in less than 10 minutes. Power BI is a...

Vijay Perepa
Apr 16, 20231 min read


Configuring Slicer Settings in Power BI - New Formatting Experience
There are quite few changes in the Latest Power BI update Mar 2023. This is quick tip to the beginners !

Vijay Perepa
Mar 19, 20231 min read


Uncovering the Secrets of Power BI: Learn How to Create a Dynamic CAGR!
CAGR (Compound Annual Growth Rate) commonly used to Calculate and compare the past performance of investments or to project their...

Vijay Perepa
Mar 19, 20231 min read



Vijay Perepa
Mar 19, 20230 min read



Vijay Perepa
Mar 12, 20230 min read


Power BI Training - for PL 300
Register

Vijay Perepa
Dec 10, 20221 min read


𝐇𝐨𝐰 𝐭𝐨 𝐂𝐫𝐞𝐚𝐭𝐞 𝐋𝐨𝐥𝐥𝐢𝐩𝐨𝐩 𝐂𝐡𝐚𝐫𝐭 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
Creating Lollipop Chart in Power is just few click away!! Charticulator visual provides easy to use Templates to create such custom...

Vijay Perepa
Nov 11, 20221 min read


Charticulator Templates
Charticulator a best Visual available from the market place - Power BI You can create many tailor-made visuals and if you wish you can...

Vijay Perepa
Nov 10, 20221 min read


Different Date formats in Same Column
When you get data with multiple date formats in same column, it may result errors while transforming the Data. I have noticed that many...

Vijay Perepa
Oct 18, 20221 min read


Cloud Flow with AI
Create a Cloud Flow using Description , Use your words and turn them to a cloud flow , now available as preview documentation Watch this...

Vijay Perepa
Oct 15, 20221 min read
bottom of page
