Data Analytics

Data Analytics

Exploring Microsoft PowerBI

SQL Union vs Union ALL

SQL Union vs Union ALL

Display user selections

Display user selections

Пікірлер

  • @osoriomatucurane9511
    @osoriomatucurane951127 күн бұрын

    Awesome tutorial, shaping the dataset from wider to long format. That's is most prefered format and know as tidy data, Where each variable repreeented by a column, each observation correeponds to a row

  • @Sirigineedi_Navann
    @Sirigineedi_NavannАй бұрын

    Nice one akka 😊

  • @Sirigineedi_Navann
    @Sirigineedi_NavannАй бұрын

    Nice explanation Akka Please post video's regularly I sent you request on LinkedIn

  • @Sirigineedi_Navann
    @Sirigineedi_NavannАй бұрын

    Its useful akka. But forgot to mention one thing union all will work faster performance wise

  • @dataanalytics6870
    @dataanalytics6870Ай бұрын

    yes its true, only difference is it gives duplicates

  • @Sirigineedi_Navann
    @Sirigineedi_NavannАй бұрын

    Hello akka regular ga videos post cheyyandi if possible 😊

  • @karansingha-b9e
    @karansingha-b9eАй бұрын

    Works well thanks

  • @amrethaselvaraj1870
    @amrethaselvaraj18702 ай бұрын

    Very clear explanation.Thanks for the video!

  • @Sirigineedi_Navann
    @Sirigineedi_Navann2 ай бұрын

    Hello akka try to post videos regularly 😊

  • @Eliz_ign
    @Eliz_ign2 ай бұрын

    Thank you so much, it will help me I sure ✨

  • @xuelian1995
    @xuelian19953 ай бұрын

    Your explanation is very clear. I like your video.

  • @Jack0112358
    @Jack01123583 ай бұрын

    thx! how ridiculous that we have to do that, they didn't fix that one and a the color choice for individual chart??

  • @Sirigineedi_Navann
    @Sirigineedi_Navann3 ай бұрын

    Useful one sister 😊

  • @SouravMondal-hb8rz
    @SouravMondal-hb8rz3 ай бұрын

    Ma'am can we sync the slicer with multiple Bookmarks.?

  • @meenakshinatarajan8910
    @meenakshinatarajan89103 ай бұрын

    I learned Power BI end to end process for beginners, very clear and interesting...Started learning more from your playlist...Thank you so much Akila

  • @ganeshraj5328
    @ganeshraj53283 ай бұрын

    Nice explanation! The videos are all clear. Thank you for your efforts. I'm sure you will soon reach a larger audience.

  • @nitinsharma2019
    @nitinsharma20194 ай бұрын

    Also provide the dataset which you are using for practice...

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Using Adventure Works Data, you can download database into SQL server and practice Power BI report. kzread.info/dash/bejne/on-qsqSNn9jPqNY.html

  • @nitinsharma2019
    @nitinsharma20194 ай бұрын

    Thanks

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Useful one sister 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Super and simple one 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Useful one

  • @devendrabarasker4987
    @devendrabarasker49874 ай бұрын

    How to practice this?

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    You need to install Visual studios and any database server in system to create this package

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Clear cut explanation The way you are explaining is next level sister 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Super explanation akka 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Akka how long it will take to learn ssis??

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Hi, You can learn basics in 4hrs

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Hello Akka On your KZread Please switch on the comments button

  • @dineshsingh2431
    @dineshsingh24314 ай бұрын

    Very usefull thank you. Can you make one video..how to wrap the legends...my legends are lengthy those are not fitting in charts. I want those to wrapped

  • @syedaneesdurez8766
    @syedaneesdurez87664 ай бұрын

    Madam I want to join your tutorial of Power BI.Please advise.

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Please go through the videos you may get hands on experience, if you are looking for any specific topic feel free to let us know will try to cover in our next release.

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Hello akka How did you mentioned *-1 can you explain me if possible??

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Hi, (Hiredate - termdate ) * 1 will convert the difference to number of days,for e.g (6/10/2012 - 4/12/2012 ) * 1 returns -59 to convert the days to positive * -1

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Hello sister Thanku so much 😊😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    nice one 😊 very useful akka

  • @solmanraj3140
    @solmanraj31404 ай бұрын

    Can you please send the Excel file you used for tutorial ! Which will be helpful for our Practise...

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Hi, I used sample dataset provided in Power BI Desktop. Please check the video at 0.16.Thank you

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Nice one akka 😊 Make a real-time video on project

  • @dataanalytics6870
    @dataanalytics68704 ай бұрын

    Please check end to end Power BI projects playlist

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    @@dataanalytics6870 thanku 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    Thanku Akka Mee videos baguntunnayi please do regular videos 😊

  • @syedaneesdurez8766
    @syedaneesdurez87664 ай бұрын

    Amazing

  • @Sirigineedi_Navann
    @Sirigineedi_Navann4 ай бұрын

    nice one akhila akka 😊

  • @Sirigineedi_Navann
    @Sirigineedi_Navann5 ай бұрын

    wonderful explanation kudos for the great efforts

  • @Sirigineedi_Navann
    @Sirigineedi_Navann5 ай бұрын

    Simply superb akka Kudos to your great efforts 😊

  • @dataanalytics6870
    @dataanalytics68705 ай бұрын

    Thanks for watching

  • @AmitKumar-td1kh
    @AmitKumar-td1kh5 ай бұрын

    Thank you 🙏

  • @dataanalytics6870
    @dataanalytics68705 ай бұрын

    You’re welcome 😊

  • @PranayPawar1991
    @PranayPawar19916 ай бұрын

    Perfect explanation. That's super quick

  • @dataanalytics6870
    @dataanalytics68705 ай бұрын

    Glad it helped!

  • @birasafabrice
    @birasafabrice6 ай бұрын

    exactly what I was looking for, thanks a lot for saving me some time!

  • @dataanalytics6870
    @dataanalytics68705 ай бұрын

    You are welcome!

  • @karthikhc8919
    @karthikhc89196 ай бұрын

    Thank you so much!!!! It was very helpful😍

  • @dataanalytics6870
    @dataanalytics68705 ай бұрын

    I'm so glad!

  • @45sdk
    @45sdk2 жыл бұрын

    Thanks for the great video. Could you help me understand how could you do the same if you need to find the minimum and maximum date from more than one table?

  • @dataanalytics6870
    @dataanalytics68702 жыл бұрын

    kzread.info/dash/bejne/hpmdpK1rnqvapMY.html