top of page
Search


Vijay Perepa
Mar 19, 20211 min read
How to create a complete PPT from Excel with a press of button
Some times creating PowerPoint presentation slide by slide is quite tedious and very demotivating. But If you can get entire (Complete)...
233 views0 comments


Vijay Perepa
Mar 13, 20211 min read
𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐧𝐠 𝐌𝐞𝐚𝐬𝐮𝐫𝐞𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐰𝐢𝐭𝐡 𝐓𝐚𝐛𝐮𝐥𝐚𝐫 𝐄𝐝𝐢𝐭𝐨𝐫
𝟑𝟎 𝐌𝐞𝐚𝐬𝐮𝐫𝐞𝐬 𝐢𝐧 𝐒𝐢𝐧𝐠𝐥𝐞 𝐂𝐥𝐢𝐜𝐤 😨 While Creating a Power BI Report - DAX Functions matter a lot. We can actually...
533 views0 comments


Vijay Perepa
Mar 6, 20211 min read
CREATING BULK MEASURES IN POWER BI
Using Tabular Editor
1,345 views0 comments


Vijay Perepa
Mar 5, 20211 min read
Creating Multiple Measures using Tabular Editor - Automatic Measures in Power BI
While working in Power BI , Measures play very important role, but some times it becomes tedious to create number of measures. If we can...
876 views0 comments


Vijay Perepa
Mar 5, 20211 min read
𝐂𝐮𝐬𝐭𝐨𝐦𝐕𝐢𝐬𝐮𝐚𝐥𝐬- 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐏𝐚𝐫𝐭𝟑 𝐏𝐢𝐞𝐂𝐡𝐚𝐫𝐭 𝐰𝐢𝐭𝐡 𝐃𝐫𝐢𝐥𝐥 𝐃𝐨𝐰𝐧
While using Pie Chart / Donut Chart , we may require TOPN and Others and when filtering Other we need the breakup. In this video I have...
104 views0 comments
Vijay Perepa
Feb 21, 20211 min read
POWER BI DA-100 Personalized Training
If you wish to Learn Power BI for Your Current Job, Entering a New Job or wanted to attend the Exam for certification, you can reach us...
37 views0 comments

Vijay Perepa
Feb 20, 20211 min read
Power BI - HR Analytics (Recruitment) - Webinar
This webinar will be conducted between 6:30 PM - 8:00 pm (IST) Click here to Join the session . Be on time
25 views0 comments


Vijay Perepa
Feb 17, 20211 min read
𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬 - 𝐕𝐚𝐫𝐢𝐚𝐧𝐜𝐞 𝐂𝐡𝐚𝐫𝐭
The Variance Chart for Power BI provides users with the capability to compare performance and benchmark with variance visualized in both...
147 views0 comments


Vijay Perepa
Feb 15, 20211 min read
𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬 - 𝐏𝐚𝐫𝐭 𝟏
One of the important feature in Power BI , I like is Custom Visuals. To tell the Data Stories, some times, custom visual make it easy! In...
205 views0 comments


Vijay Perepa
Feb 12, 20211 min read
Custom Animations in PowerPoint
Watch this video to know how to create Custom Animations using multiple options. I have explained how to use WAVE TEXT ANIMATION and its...
59 views0 comments

Vijay Perepa
Feb 12, 20211 min read
𝐇𝐨𝐰 𝐭𝐨 𝐂𝐫𝐞𝐚𝐭𝐞 𝐚 𝐌𝐚𝐭𝐫𝐢𝐱𝐓𝐚𝐛𝐥𝐞 𝐰𝐢𝐭𝐡 𝐒𝐩𝐚𝐫𝐤𝐥𝐢𝐧𝐞 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
Creating a Table Visual with Sparkline in Power BI like we can do in Excel Some times Simple workaround makes the reporting much...
179 views0 comments


Vijay Perepa
Feb 10, 20211 min read
𝐌𝐚𝐧𝐚𝐠𝐢𝐧𝐠 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 (𝐢𝐧𝐜𝐨𝐧𝐬𝐢𝐬𝐭𝐞𝐧𝐭) 𝐅𝐢𝐥𝐞𝐬 𝐍𝐚𝐦𝐞𝐬 𝐨𝐟 𝐃𝐚𝐭𝐚𝐬𝐞𝐭
While dealing with Excel/CSV Files as Source Data for Power BI Report, you may face a common problem inconsistent Names of Files and even...
299 views1 comment

Vijay Perepa
Feb 4, 20211 min read
𝗔𝗴𝗲𝗶𝗻𝗴 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜
https://community.powerbi.com/t5/Data-Stories-Gallery/Ageing-Analysis-in-Power-BI/m-p/1645585#M5006 #powerbi #powerbisupport...
219 views0 comments


Vijay Perepa
Feb 3, 20211 min read
Waffle Chart - Excel for beginners
Learning Excel is Quite interesting when you are learning in a right direction. Using Conditional and few custom options available in...
45 views0 comments


Vijay Perepa
Feb 2, 20211 min read
Excel Basics for Beginners
Started a series of Videos for Beginners . Follow the blog get the more tips and Tricks on Excel
66 views0 comments


Vijay Perepa
Jan 31, 20211 min read
Excel Formulas - CHOOSE - To create interactive Chart
To Create any Advanced chart you need to know few basic Excel Formulas and with clear understanding about the outcome, which can result a...
75 views0 comments


Vijay Perepa
Jan 26, 20211 min read
Interactive Excel Chart in 5 Minutes
Creating Reports with Excel Charts is quite Easy and Effective. Whenever we create a Chart in Excel we need to keep in view of the end...
93 views0 comments


Vijay Perepa
Jan 24, 20211 min read
Simple IF Function, Data Validation, Conditional Formatting to get a Quick Dynamic Report (Chart)
Some times, you can use simple basics of Excel to show best results and within no time. In this video I have explained how to use...
69 views0 comments


Vijay Perepa
Jan 23, 20211 min read
How to Create Butterfly Chart (Also called as Tornado, Pyramid Chart)
Telling a Data Story with Visualization in Excel much is quite interesting. Watch this video to understand how to achieve that in just 15...
78 views0 comments


Vijay Perepa
Jan 22, 20210 min read
62 views0 comments
bottom of page