Marchetty Pavan Sai
Marchetty Pavan Sai
  • 269
  • 95 860
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!!
Переглядів: 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

КОМЕНТАРІ

  • @gurvindersingharora5301
    @gurvindersingharora5301 12 днів тому

    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 !!!

    • @passionofpavan
      @passionofpavan 11 днів тому

      @@gurvindersingharora5301 Sure, Thank you!!

  • @Samuel-br6lr
    @Samuel-br6lr 12 днів тому

    Wow, thank you very much. I understood it very well, thank you Marchetty.

  • @HareKrsn213
    @HareKrsn213 19 днів тому

    In a short video, you have explained multiple concepts...Thank you, brother...

  • @fashion_queen
    @fashion_queen 22 дні тому

    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

    • @passionofpavan
      @passionofpavan 22 дні тому

      @@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)

  • @fashion_queen
    @fashion_queen 22 дні тому

    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 😢

    • @passionofpavan
      @passionofpavan 22 дні тому

      @@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

  • @infamismworldwild6248
    @infamismworldwild6248 26 днів тому

    Thank you

  • @SantheepSwaminathanKovoor
    @SantheepSwaminathanKovoor 29 днів тому

    Thank You. Very useful video

  • @gungunsaxena8340
    @gungunsaxena8340 Місяць тому

    hello pawan, i am ankit remember me i was your senior at amity university gwalior from mechanical branch. hello how are you

    • @passionofpavan
      @passionofpavan Місяць тому

      Hi Ankit sir, I am fine sir, I do remember, Happy to receive your text sir.

    • @passionofpavan
      @passionofpavan Місяць тому

      Please drop me your linkedin profile to connect. Thank you!

  • @MoonShine-bs6cl
    @MoonShine-bs6cl Місяць тому

    Please can you make same circular dependency video while creating a month number in the table and doing sort .. It will b helpfull.. Tq

  • @wonnapee
    @wonnapee Місяць тому

    nice idea. but turns out this approach is very slow

  • @HUs1620
    @HUs1620 Місяць тому

    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

    • @passionofpavan
      @passionofpavan Місяць тому

      @@HUs1620 Try using allexcept (state column) as a filter argument and check if it is required one

    • @HUs1620
      @HUs1620 Місяць тому

      @@passionofpavan thanks I will try. I am at a very beginner level. can you please write code here

  • @vishwanathm4207
    @vishwanathm4207 Місяць тому

    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?

  • @dsmith8172
    @dsmith8172 2 місяці тому

    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.

  • @adityapai5147
    @adityapai5147 2 місяці тому

    That was fantastic! Just what I wanted to display!! Thanks!

  • @shitaldesai9139
    @shitaldesai9139 2 місяці тому

    Hello sir will you help mi

    • @shitaldesai9139
      @shitaldesai9139 2 місяці тому

      How to select salary less than salary of john and greater than devid salary

    • @passionofpavan
      @passionofpavan 2 місяці тому

      Please let me know your query

    • @shitaldesai9139
      @shitaldesai9139 2 місяці тому

      How to select salary less than salary of john and greater than devid salary

    • @shitaldesai9139
      @shitaldesai9139 2 місяці тому

      Will you upload this question on youtub

    • @ProwisorOfficial
      @ProwisorOfficial 2 місяці тому

      @@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')

  • @RahulThakur-k1n
    @RahulThakur-k1n 2 місяці тому

    Thank you, Keep growing

  • @adnanbedsur
    @adnanbedsur 2 місяці тому

    Useful

  • @ricardoveloso9163
    @ricardoveloso9163 2 місяці тому

    So usefull for comparatives.

  • @ricardoveloso9163
    @ricardoveloso9163 2 місяці тому

    Very helpfull :) thank you

  • @data_science651
    @data_science651 2 місяці тому

    Where can i find the requirement document given by client of this project. (As you said, you will provide it with us.)

  • @trendytwenty6730
    @trendytwenty6730 3 місяці тому

    Thank you for explaining

  • @JANSAMARTHAKNEWS
    @JANSAMARTHAKNEWS 3 місяці тому

    Good explanation sir

  • @nquirke7655
    @nquirke7655 3 місяці тому

    Thanks

  • @RaharijaoDavid
    @RaharijaoDavid 3 місяці тому

    Thank you!

  • @aghnamahardhika
    @aghnamahardhika 3 місяці тому

    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)?

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 3 місяці тому

    Nice one power Sai 😄😄

  • @shubhamgupta-sd9kd
    @shubhamgupta-sd9kd 3 місяці тому

    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?

  • @erlonbh
    @erlonbh 3 місяці тому

    Thank you. Very helpful.

  • @Its_Wolfs_Bi
    @Its_Wolfs_Bi 3 місяці тому

    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

  • @Зле_Коте
    @Зле_Коте 4 місяці тому

    formula for color change - great idea! thank you

  • @krishnaRaog21
    @krishnaRaog21 4 місяці тому

    Great ..Pavan ..very well explained ...

  • @krishnaRaog21
    @krishnaRaog21 4 місяці тому

    Super ..Pavan ...Very neat explanation

  • @aviraldubey6700
    @aviraldubey6700 4 місяці тому

    Very informative brother I hope this new venture becomes something big. Keep up the good work.👍🏻

  • @macshock632
    @macshock632 4 місяці тому

    What if I have the return rate in a measure instead of a column?

  • @andreagil2615
    @andreagil2615 4 місяці тому

    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!!

  • @jasonturingan3279
    @jasonturingan3279 4 місяці тому

    Hi sir. I can't access the sample file please provide dataset so that we can follow along. were not learning just by watching...

    • @passionofpavan
      @passionofpavan 4 місяці тому

      docs.google.com/spreadsheets/d/1rgn4PBQDw3mNQLQ6nS7yCG8JknownkXA/edit?usp=sharing&ouid=115523926732041288498&rtpof=true&sd=true

  • @SivaKumar-uo9cf
    @SivaKumar-uo9cf 5 місяців тому

    Could you please provide the datasets for practice

    • @passionofpavan
      @passionofpavan 5 місяців тому

      Please create sample data from your end. Thank you!

  • @SivaKumar-uo9cf
    @SivaKumar-uo9cf 5 місяців тому

    Really crystal clear explaination bro..

  • @KamranMumtazAhmed
    @KamranMumtazAhmed 5 місяців тому

    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.

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 5 місяців тому

    nice one Pavan Sai Keep Rocking brother

  • @gauravgaikwad195
    @gauravgaikwad195 5 місяців тому

    Total value is only coming

  • @Anasahmad-hm9hp
    @Anasahmad-hm9hp 5 місяців тому

    can you please post full tutorials of SQL server ? you lessons are good

    • @passionofpavan
      @passionofpavan 5 місяців тому

      Thank you!. Currently ,i will be posting such questions for practice...I may post concepts in the later part...

  • @harikrishna6008
    @harikrishna6008 5 місяців тому

    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

  • @shivaprasad4009
    @shivaprasad4009 5 місяців тому

    Please provide query and data for creating the table

    • @passionofpavan
      @passionofpavan 5 місяців тому

      Please create some random sample data in sql accordingly. Thank you!

  • @jennifermannhardt323
    @jennifermannhardt323 5 місяців тому

    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”

  • @ilhamguspujimaulana6518
    @ilhamguspujimaulana6518 5 місяців тому

    Thanks so much man! it really helps!

  • @satyaprakash-sf8bc
    @satyaprakash-sf8bc 5 місяців тому

    Great Brother. Thanks for your valuable efforts.

  • @saibaba-r9r
    @saibaba-r9r 5 місяців тому

    thank you so much bro, i was able to clear the test today and same question came. thanks for your help

  • @KarThik-tb1pl
    @KarThik-tb1pl 6 місяців тому

    How can we use more than one column in ADDMISSINGITEMS

  • @Vishnubhandarge1
    @Vishnubhandarge1 6 місяців тому

    Is it going till advanced concepts Templorary tables Joins?

    • @passionofpavan
      @passionofpavan 6 місяців тому

      I will try to keep taking it forward as far as possible. Thank you!