top of page
Search


๐๐ข๐ซ๐๐ฅ๐ ๐๐จ๐ฅ๐๐ซ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐ ๐ฎ๐ฌ๐ข๐ง๐ ๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ
Tried using Polar Char in place of Pie/Donut Chart to show case the data of multiple variables. Pie / Donut don't support both positive...

Vijay Perepa
Aug 11, 20211 min read
ย
ย
ย


๐๐จ๐ฐ ๐ญ๐จ ๐ฎ๐ฌ๐ ๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐
A Simple Column chart using R Visuals in Power BI. R is a language and environment for statistical computing and graphics and it is...

Vijay Perepa
Aug 4, 20211 min read
ย
ย
ย


๐๐จ๐ฐ๐๐ซ ๐๐ - ๐๐จ๐ฆ๐ฉ๐จ๐ฎ๐ง๐ ๐๐ง๐ง๐ฎ๐๐ฅ ๐๐ซ๐จ๐ฐ๐ญ๐ก ๐๐๐ญ๐
#CAGR#PowerBi# Dax Dynamic Compound Annual Growth Rate (CAGR) in Power BI. Tutorial will be published shortly! Also covering many...

Vijay Perepa
Jul 11, 20211 min read
ย
ย
ย


๐๐ง๐ข๐ฆ๐๐ญ๐ ๐๐ก๐๐ซ๐ญ๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ | ๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ ๐๐ก๐จ๐ซ๐ญ๐ฅ๐ฒ
Using small piece of code you can animated Charts in Excel like you can do in Power Point TUTORIAL WILL BE POSTED SHORTLY ! Keep watching...

Vijay Perepa
Jul 5, 20211 min read
ย
ย
ย


Learn Excel VBA Hiding Objects and Charts in A spreadsheet
Learning VBA is very helpful to automate certain activities may be they are simple or complex. In this Video I have shown how to Show or...

Vijay Perepa
Jun 28, 20211 min read
ย
ย
ย


๐๐จ๐ฐ๐๐ซ ๐๐ - ๐๐ฎ๐ง๐ ๐๐๐๐ ๐๐ฉ๐๐๐ญ๐๐ฌ - ๐ ๐๐ฐ ๐ข๐ฆ๐ฉ๐จ๐ซ๐ญ๐๐ง๐ญ ๐๐จ๐ข๐ง๐ญ๐ฌ
June 2021 update of Power BI is out. Few very important points Reporting options: Paginated Report Visual in Power BI Desktop (Preview)...

Vijay Perepa
Jun 26, 20211 min read
ย
ย
ย


Power BI Webinar
Link to the Webinar : MS Teams

Vijay Perepa
Jun 25, 20211 min read
ย
ย
ย


๐๐ฑ๐๐๐ฅ ๐๐๐ ๐๐จ๐ฅ๐ฎ๐ฆ๐ง ๐๐ฎ๐ญ๐จ ๐๐ข๐๐ญ๐ก ๐๐ฎ๐ฌ๐ญ ๐๐ฒ ๐ฌ๐๐ฅ๐๐๐ญ๐ข๐ง๐ ๐๐๐ฅ๐ฅ
Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

Vijay Perepa
Jun 24, 20211 min read
ย
ย
ย

Vijay Perepa
Jun 17, 20210 min read
ย
ย
ย



Vijay Perepa
Jun 2, 20210 min read
ย
ย
ย


For Power BI Learners - What should be the approach!
๐ก๐ผ๐๐ฒ: ๐ ๐ ๐ฅ๐ฒ๐พ๐๐ฒ๐๐ ๐๐ผ ๐๐ต๐ฒ ๐ฟ๐ฒ๐ฎ๐ฑ๐ฒ๐ฟ๐ ๐๐ผ ๐๐ฎ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฎ๐ ๐ฎ ๐ณ๐ฒ๐ฒ๐ฑ๐ฏ๐ฎ๐ฐ๐ธ ๐ผ๐ป๐น๐! ๐๐ป๐...

Vijay Perepa
May 15, 20212 min read
ย
ย
ย


๐๐จ๐ง๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐๐๐ซ๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ - ๐๐จ๐ฐ๐๐ซ ๐๐
While dealing with YoY comparisons and Cards, you may require flexibility to show the values based on selection and other conditions. In...

Vijay Perepa
May 11, 20211 min read
ย
ย
ย


๐๐ก๐๐ซ๐ญ๐ข๐๐ฎ๐ฅ๐๐ซ + ๐๐จ๐ฐ๐๐ซ ๐๐ = ๐๐ฎ๐ฌ๐ญ๐จ๐ฆ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ
๐๐จ๐ฐ๐๐ซ ๐๐ ๐๐จ๐ฉ ๐ ๐๐ซ๐จ๐๐ข๐ญ๐๐๐ฅ๐ ๐๐ง๐ ๐๐จ๐ฌ๐ฌ ๐๐๐ค๐ข๐ง๐ ๐๐ซ๐๐ง๐๐ก๐๐ฌ ๐ฎ๐ฌ๐ข๐ง๐ ๐๐ก๐๐ซ๐ญ๐ข๐๐ฎ๐ฅ๐๐ญ๐จ๐ซ...

Vijay Perepa
Apr 25, 20211 min read
ย
ย
ย


There is only one action which doesn't have straight Key Board Short Cut in Excel.
Do you know what is that? And you wish to create your own Short Cut using a single VBA Statement Application.CommandbarsApplication.Comma...

Vijay Perepa
Apr 24, 20211 min read
ย
ย
ย


Know All Functions in Power Query ( M Language)
Get the complete list of Functions available in M Language with small step. Coming up with a new series of Videos . To get notified...

Vijay Perepa
Apr 21, 20211 min read
ย
ย
ย


๐๐ฎ๐ป ๐๐ ๐ฐ๐ฒ๐น ๐ฃ๐ฟ๐ฒ๐๐ฒ๐ป๐ & ๐๐ ๐ฝ๐น๐ฎ๐ถ๐ป ๐๐ต๐ฒ ๐๐ฎ๐๐ฎ ๐น๐ถ๐ธ๐ฒ ๐๐ฒ ๐ฑ๐ผ?
Imagine if Excel started Talking to you and present the Data and Charts and also giving explanation about the Data, and there is less...

Vijay Perepa
Apr 13, 20211 min read
ย
ย
ย


๐๐ฎ๐ฌ๐ญ๐จ๐ฆ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ ๐ฐ๐ข๐ญ๐ก ๐๐ฒ๐ญ๐ก๐จ๐ง ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐
สแดแดสษด แด แดสษชแดแด๊ฑ แดสแดแดแดษดแด๊ฑ แด๊ฐ แดสแดสแด๊ฑ ษชษด แดแดแดกแดส สษช แดษดแด
แดสแดสแดษด While using a reporting Tool, some times the Customer requirements are tricky and...

Vijay Perepa
Apr 11, 20211 min read
ย
ย
ย



Vijay Perepa
Apr 8, 20210 min read
ย
ย
ย


๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐ฎ๐ป๐ฑ ๐ฃ๐๐๐ต๐ผ๐ป ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป - ๐ง๐ผ๐ฟ๐ป๐ฎ๐ฑ๐ผ ๐๐ต๐ฎ๐ฟ๐
๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐ฎ๐ป๐ฑ ๐ฃ๐๐๐ต๐ผ๐ป ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป - ๐ฃ๐๐๐ต๐ผ๐ป ๐ฉ๐ถ๐๐๐ฎ๐น๐ ๐ถ๐ป ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ - ๐ง๐ผ๐ฟ๐ป๐ฎ๐ฑ๐ผ ๐๐ต๐ฎ๐ฟ๐...

Vijay Perepa
Apr 7, 20211 min read
ย
ย
ย
bottom of page

