top of page
Search


Master Power Automate String Functions with Real Data | Substring, FormatDateTime, Concat & More!
Start Learning Power Automate and find how to combine String, Date, and Mathematical functions to build dynamic workflows! In this video, Iโll walk you through real business data, showing how functions like substring(), concat(), formatDateTime(), nthIndexOf(), and mathematical expressions can automate real-world processes effortlessly. Youโll also get the complete dataset used in this tutorial โ so you can practice, follow along, and create your own intelligent automations.

Vijay Perepa
Nov 91 min read
ย
ย
ย


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






