top of page
Search



Vijay Perepa
6 days ago0 min read
ย
ย
ย


Exploring the Power of MCP with SQL โ A Practical Demo
Recently, I set up an MCP (Model Context Protocol) Server for SQL and spent some time exploring how effectively it can interact with databases through AI-driven workflows....... Recently, I set up an MCP (Model Context Protocol) Server for SQL and spent some time exploring how effectively it can interact with databases through AI-driven workflows. The experience was quite impressive. With MCP acting as a standardized bridge between AI models and external tools, it becomes pos

Vijay Perepa
Apr 21 min read
ย
ย
ย



Vijay Perepa
Apr 20 min read
ย
ย
ย
Microsoft Fabric Data Engineering Explained Lakehouse, Spark and OneLake Architecture
Microsoft Fabric Data Engineering Explained Lakehouse, Spark and OneLake Architecture Watch Video ๐ฅ In this video, we explore Microsoft Fabric Data Engineering in a clear and structured way. You will understand: โข Lakehouse architecture and why it combines Data Lake flexibility with Data Warehouse performance โข How Apache Spark works inside Fabric โข Notebooks and Spark Job Definitions for production workloads โข Medallion architecture (Bronze, Silver, Gold) โข How OneLake acts

Vijay Perepa
Mar 41 min read
ย
ย
ย


Microsoft Fabric Data Factory Explained Simply | Pipelines, Copy Job, Mirroring & Copilot
In this video, I explain Microsoft Fabric Data Factory in a simple and practical way for learners, working professionals, and anyone exploring modern data integration. You will understand how Data Factory acts as the core engine for enterprise data movement and orchestration inside Microsoft Fabric. I cover the major capabilities, including: * Data integration across 170+ sources** * Power Query Dataflows** * Pipelines and orchestration** * Copy Job** * Database Mirroring**

Vijay Perepa
Feb 271 min read
ย
ย
ย



Vijay Perepa
Nov 21, 20250 min read
ย
ย
ย


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 9, 20251 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 12, 20251 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 7, 20251 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 22, 20251 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 14, 20251 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 13, 20251 min read
ย
ย
ย


๐๐๐ญ๐ ๐๐ง๐ ๐๐ฌ๐ญ๐ข๐จ๐ง ๐ญ๐จ ๐๐๐ฅ๐ญ๐ ๐๐๐๐ฅ๐ ๐ฐ๐ข๐ญ๐ก ๐๐๐ญ๐๐๐ฅ๐จ๐ฐ ๐๐๐ง2 | ๐๐๐ญ ๐๐๐๐๐ฎ๐ฅ๐ญ ๐๐๐ฆ๐๐ง๐ญ๐ข๐ ๐๐จ๐๐๐ฅ & ๐๐ฎ๐ข๐ฅ๐ ๐๐๐ฉ๐จ๐ซ๐ญ๐ฌ ๐ข๐ง ๐๐ข๐๐ซ๐จ๐ฌ๐จ๐๐ญ ๐ ๐๐
๐๐ ๐พ๐๐๐๐ ๐ฝ๐๐
๐๐ย https://youtu.be/j9rdXD5mAno ย ๐๐ #PowerBIย #DataAnalyticsย #ETLย #Dataflowsย #PowerQueryย #MicrosoftFabricย #Busi...

Vijay Perepa
Feb 11, 20251 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 5, 20251 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 1, 20252 min read
ย
ย
ย


๐๐๐ ๐๐ง๐ข๐ฆ๐๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐!
๐๐ Watch Video https://youtu.be/e5eZN0uzB3A ๐๐ Are you looking to enhance your Power BI dashboards with interactive and dynamic...

Vijay Perepa
Feb 1, 20251 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 4, 20251 min read
ย
ย
ย


๐๐จ๐ฐ๐๐ซ ๐จ๐ ๐๐ฒ๐ญ๐ก๐จ๐ง ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐! ๐
๐๐ ๐๐ข๐ต๐ค๐ฉ ๐ต๐ฉ๐ฆ ๐ง๐ถ๐ญ๐ญ ๐ต๐ถ๐ต๐ฐ๐ณ๐ช๐ข๐ญ ๐ฉ๐ฆ๐ณ๐ฆ: ย https://lnkd.in/ggJYPin5 ย ๐๐ I am sharing here my video link where I have...

Vijay Perepa
Jan 2, 20251 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
ย
ย
ย
bottom of page
