- 269
- 95 860
Marchetty Pavan Sai
India
Приєднався 24 січ 2023
Power BI Instructor for Beginners. Passion to Learn and Vision to serve by teaching made me start this initiative.
I am Microsoft Certified Power BI Data Analyst Associate.
I provide one on one guidance and training for the beginners.
Join Community: lnkd.in/gxxMxVtb
LinkedIn: www.linkedin.com/in/marchetty...
Twitter: passionofpavan
Instagram: marchetty_p...
Telegram(Username): @marchettypavansai
Email: pavansaimarchetty@gmail.com
I am Microsoft Certified Power BI Data Analyst Associate.
I provide one on one guidance and training for the beginners.
Join Community: lnkd.in/gxxMxVtb
LinkedIn: www.linkedin.com/in/marchetty...
Twitter: passionofpavan
Instagram: marchetty_p...
Telegram(Username): @marchettypavansai
Email: pavansaimarchetty@gmail.com
Power BI | Dashboard | Report | Sales Analysis
This video is about Sales Analysis in POWER BI.
Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=994518079
Dataset Link: docs.google.com/spreadsheets/d/1dPE5rFlBanRZo7ONXaYohdTz3pJQgcAG/edit?usp=sharing&ouid=115523926732041288498&rtpof=true&sd=true
LinkedIn: www.linkedin.com/in/marchetty-pavan-sai
Twitter: passionofpavan
Instagram: marchetty_pavan_sai
Telegram(Username): @marchettypavansai
Email: pavansaimarchetty@gmail.com
Please Like!! Share!! & Subscribe!!
Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=994518079
Dataset Link: docs.google.com/spreadsheets/d/1dPE5rFlBanRZo7ONXaYohdTz3pJQgcAG/edit?usp=sharing&ouid=115523926732041288498&rtpof=true&sd=true
LinkedIn: www.linkedin.com/in/marchetty-pavan-sai
Twitter: passionofpavan
Instagram: marchetty_pavan_sai
Telegram(Username): @marchettypavansai
Email: pavansaimarchetty@gmail.com
Please Like!! Share!! & Subscribe!!
Переглядів: 106
Відео
Power BI | Dashboard | Report | Telecom Customer Churn Analysis
Переглядів 19421 день тому
This video is about Telecom Customer Churn Analysis in POWER BI. Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=994518079 Dataset Link: docs.google.com/spreadsheets/d/1vPI-BiuzT0iavyMNqWlZxGtn2TyU_VHE/edit?usp=sharing&ouid=115523926732041288498&rtpof=true&sd=true LinkedIn: www.linkedin.com/in/marchetty-pavan-sai Twitter: passionofpa...
AI | CHATGPT | What is Prompt Engineering
Переглядів 812 місяці тому
AI | CHATGPT | What is Prompt Engineering
SQL SERVER | MSSQL| Manager who has access to more than 5 direct reports
Переглядів 283 місяці тому
This video is about How to find cumulative total based on player ID in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypav...
Python | Numbers, Variables, Strings, Indexing and Slicing, Lists
Переглядів 404 місяці тому
This video is about Numbers, Variables, Strings, Indexing and Slicing, Lists in Python Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=279457353 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypavans...
SQL SERVER | MSSQL| How to find cumulative total based on player ID
Переглядів 354 місяці тому
This video is about How to find cumulative total based on player ID in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypav...
SQL SERVER | MSSQL| How to find active business based on occurrences
Переглядів 414 місяці тому
This video is about How to find active business based on occurrences in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypa...
SQL SERVER | MSSQL| How to create bins and count bins
Переглядів 644 місяці тому
This video is about How to create bins and count bins in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypavansai Email: p...
SQL SERVER | MSSQL| How to find Consecutive Available seats
Переглядів 864 місяці тому
This video is about How to find Consecutive Available seats in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypavansai Em...
SQL SERVER | MSSQL| How to find biggest number which is appearing only once
Переглядів 385 місяців тому
This video is about How to find biggest number which is appearing only once in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marc...
SQL SERVER | MSSQL| How to find authors who has viewed atleast one of their own articles
Переглядів 205 місяців тому
This video is about How to find authors who has viewed atleast one of their own articles in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Use...
SQL SERVER | MSSQL| How to calculate click through rate (CTR)
Переглядів 665 місяців тому
This video is about How to calculate click through rate (CTR) in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypavansai ...
SQL SERVER | MSSQL| How to find the rows where criteria is matching thrice
Переглядів 375 місяців тому
This video is about How to find the rows where criteria is matching thrice in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @march...
SQL SERVER | MSSQL| How to find Total Sales in USD
Переглядів 415 місяців тому
This video is about How to find Total Sales in USD in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypavansai Email: pava...
SQL SERVER | MSSQL| How to find Start date and end date of balance
Переглядів 1906 місяців тому
This video is about How to find Start date and end date of balance in MSSQL | SQL SERVER Videos List: docs.google.com/spreadsheets/d/1ZH3BMoGhbS3SrBwOLgFteDU8CcHgDOgVTyCC-e3rL3s/edit#gid=756150344 Please feel free to reach out at : LinkedIn: www.linkedin.com/in/marchettypavansai/ Twitter: passionofpavan Instagram: marchetty_pavan_sai Telegram(Username): @marchettypava...
SQL SERVER | MSSQL| How to Unpivot Columns
Переглядів 816 місяців тому
SQL SERVER | MSSQL| How to Unpivot Columns
SQL SERVER | MSSQL| How to find Net balance Amount on Credit and Debit Transactions
Переглядів 1776 місяців тому
SQL SERVER | MSSQL| How to find Net balance Amount on Credit and Debit Transactions
SQL SERVER | MSSQL| How to print alphabets from A to Z
Переглядів 846 місяців тому
SQL SERVER | MSSQL| How to print alphabets from A to Z
SQL SERVER | MSSQL| How to find Running total
Переглядів 1006 місяців тому
SQL SERVER | MSSQL| How to find Running total
SQL SERVER | MSSQL| How to pivot columns for salesyear
Переглядів 366 місяців тому
SQL SERVER | MSSQL| How to pivot columns for salesyear
SQL SERVER | MSSQL| How to find start time and end time of a process
Переглядів 986 місяців тому
SQL SERVER | MSSQL| How to find start time and end time of a process
SQL SERVER | MSSQL| How to find latest transaction of account
Переглядів 1446 місяців тому
SQL SERVER | MSSQL| How to find latest transaction of account
SQL SERVER | MSSQL| How to transform rows to respective columns using subquery
Переглядів 536 місяців тому
SQL SERVER | MSSQL| How to transform rows to respective columns using subquery
SQL SERVER | MSSQL| How to find the output of rows for various joins
Переглядів 307 місяців тому
SQL SERVER | MSSQL| How to find the output of rows for various joins
SQL SERVER | MSSQL| How to find the device and the total signals & location of major occurrence
Переглядів 357 місяців тому
SQL SERVER | MSSQL| How to find the device and the total signals & location of major occurrence
SQL SERVER | MSSQL| How to find call number where duration of outgoing is greater than incoming call
Переглядів 457 місяців тому
SQL SERVER | MSSQL| How to find call number where duration of outgoing is greater than incoming call
SQL SERVER | MSSQL | How to find Employees salary greater than the average salary of department
Переглядів 4617 місяців тому
SQL SERVER | MSSQL | How to find Employees salary greater than the average salary of department
SQL SERVER | MSSQL | How to find Highest sales or orders daywise
Переглядів 847 місяців тому
SQL SERVER | MSSQL | How to find Highest sales or orders daywise
SQL SERVER | MSSQL | How to find Ordered Quantity Sold on Both Days and on a Particular day
Переглядів 587 місяців тому
SQL SERVER | MSSQL | How to find Ordered Quantity Sold on Both Days and on a Particular day
SQL SERVER | MSSQL | How to find students where Total Marks is greater than Previous Year Marks
Переглядів 1468 місяців тому
SQL SERVER | MSSQL | How to find students where Total Marks is greater than Previous Year Marks
Hello Sir 😊 Please create videos of case Studies Using Advanced and Lengthy DAX. So we can get a tight grasp over DAX. Train us In a way so that, we could create custom solutions. Thank you for your Knowledgeable Videos !!!
@@gurvindersingharora5301 Sure, Thank you!!
Wow, thank you very much. I understood it very well, thank you Marchetty.
@@Samuel-br6lr Thank you!
In a short video, you have explained multiple concepts...Thank you, brother...
Where is my other comments. I asked that , in every column there is written no internet service what is the mean of this . Because there is already a individual column for Internet service so this is written in every column no internet service. And multiple column name what's the mean of this
@@fashion_queen internet service exclusively is a service provided...and for other columns, no internet service means that that they are not opting for internet service which may or may not impact the respective columns ( different services or subscription taken)
And one more thing I understand monthly charges but total charges means I mean how they calculate total charges. Monthly charges* months. Is this mean? And in my data sets in senior citizen, 0 and 1 available it means 0 indicates no senior citizen am I right. Pls resolve my all queries 😢
@@fashion_queen with respect to senior citizen, you are correct. Monthly charges may be monthly packages Total charges may be total amount gained from customer
Thank you
@@infamismworldwild6248 thank you!
Thank You. Very useful video
Thank you!
hello pawan, i am ankit remember me i was your senior at amity university gwalior from mechanical branch. hello how are you
Hi Ankit sir, I am fine sir, I do remember, Happy to receive your text sir.
Please drop me your linkedin profile to connect. Thank you!
Please can you make same circular dependency video while creating a month number in the table and doing sort .. It will b helpfull.. Tq
nice idea. but turns out this approach is very slow
Hi Marchetty. thank you for the video, it was of much help. How to calculate running totals if there are some other columns e.g. State and Product Type. You want the running totals to calculate based on those variables as well. so it keep filtering "State" column and "Prodcut Type" column with the "Date" column. Hope I made my point. Thanks in advance and would be really good if you can make a video for this type of situation. here is an example: Date State Product Type Sale 25/7/24 ABC Pepsi $10 24/7/24 DEF Coke $15 23/7/24 ABC Pepsi $20 22/7/24 ABC Coke $10
@@HUs1620 Try using allexcept (state column) as a filter argument and check if it is required one
@@passionofpavan thanks I will try. I am at a very beginner level. can you please write code here
Mean value is Static not Dynamic one, Mean value always changes based on sales data increase. I tried measure in place of 300 but it's not working. Is there any solution for that?
The video has a lot of useful info but is unclear on the Replace Key purpose. Is that section necessary if a user only wants to add a key? Or, is it just a second section which shows a separate process of how to replace a key. Also, the pace of the video is way too fast. In order to try to replicate the steps I have to continue to pause the video and rewind.
That was fantastic! Just what I wanted to display!! Thanks!
Thank you!!
Hello sir will you help mi
How to select salary less than salary of john and greater than devid salary
Please let me know your query
How to select salary less than salary of john and greater than devid salary
Will you upload this question on youtub
@@shitaldesai9139 I hope you are looking for the query as below. The output will be only one row as per data shown where the employee name is Antony. select * from Employee where salary < (select salary from employee where EmpName = 'John') and salary > (select salary from employee where EmpName = 'Donald')
Thank you, Keep growing
Thank you!!
Useful
Thank you!!
So usefull for comparatives.
Thank you!!
Very helpfull :) thank you
Thank you!!
Where can i find the requirement document given by client of this project. (As you said, you will provide it with us.)
Thank you for explaining
Thank you!!
Good explanation sir
Thank you !!
Thanks
Thank you!
Thank you!
Thank you!!
Hello, is there any way for me to show only the smallest and the largest value (if i tick January, February, March, it will only show January, March)?
Yes please reply
Nice one power Sai 😄😄
Thank you navann!!
If we add a dimension in column section and then how can we do column total to show average and rest of the column show sum value?
Thank you. Very helpful.
Thank you!
bro u have taken the example(scenario) of ALL() function for explaining ALLCROSSFILTER(), ALLCROSSFILTER () does the the work of ALL() but what next ?.... that's the actual difference u are saying the similarities not the difference between ALLCROSSFILTER() and ALL()....LOL
formula for color change - great idea! thank you
Thank you!!
Great ..Pavan ..very well explained ...
Thank you sir!
Super ..Pavan ...Very neat explanation
Thank you sir!
Very informative brother I hope this new venture becomes something big. Keep up the good work.👍🏻
Thank you so much Aviral !!
What if I have the return rate in a measure instead of a column?
THANK YOU!! I've been trying to implement this for 2 hours and none of the solutions other websites/videos provided were working for me. Thanks for the video and the explanation!!
Thank you!!
Hi sir. I can't access the sample file please provide dataset so that we can follow along. were not learning just by watching...
docs.google.com/spreadsheets/d/1rgn4PBQDw3mNQLQ6nS7yCG8JknownkXA/edit?usp=sharing&ouid=115523926732041288498&rtpof=true&sd=true
Could you please provide the datasets for practice
Please create sample data from your end. Thank you!
Really crystal clear explaination bro..
Thank you!!
I have used the below query to get the same result. = Table.AddColumn(Table.TransformColumnTypes(Table.FromRecords({ [Column1 = "Apple", Column2 = "Banana"], [Column1 = "Apple", Column2 = "Apple"], [Column1 = "Banana", Column2 = "Banana"] }), {{"Column1", type text}, {"Column2", type text}}), "Comparison", each [Column1] = [Column2], type text) Here is one drawback of the above code, if the cases are not the same, it won't return the correct answer. looking for the formula to convert the cases {lower or upper} to match the columns without error. By the way, just started to watch your videos at 1.5x speed and really enjoy the way you are explaining things. I am new to PQ. Keep up the good work. you will soon be recognized.
Thank you!!
nice one Pavan Sai Keep Rocking brother
Thank you so much!!
Total value is only coming
can you please post full tutorials of SQL server ? you lessons are good
Thank you!. Currently ,i will be posting such questions for practice...I may post concepts in the later part...
hi Pavan, how to get the previous year info also along with the previous year marks. I want to display the previous year also. please help
Please provide query and data for creating the table
Please create some random sample data in sql accordingly. Thank you!
Thank you for this video. It got me 90% of the way there. Is there a way to also have a option where it says “all ___ selected” if they select all values? Right now if the slicer has all values selected it says “blank”
Thanks so much man! it really helps!
Thank you!
Great Brother. Thanks for your valuable efforts.
Thank you!!
Thank you!!
thank you so much bro, i was able to clear the test today and same question came. thanks for your help
Thank you!!
How can we use more than one column in ADDMISSINGITEMS
Is it going till advanced concepts Templorary tables Joins?
I will try to keep taking it forward as far as possible. Thank you!