Financial Statistics Dashboards System | Dynamic Excel Map Chart | Tutorial 2

Поділитися
Вставка
  • Опубліковано 28 сер 2024

КОМЕНТАРІ • 120

  • @christianlira1259
    @christianlira1259 Рік тому +3

    Complete mind reconneting to a whole new network. I am amazed by the intelligence of the developer person here in producing from a single 'platfform', some of the most advanced visualizations created from zero to great. Thank you for your open knowledge sharing. Much appreciated.

  • @haiodaalbardee5666
    @haiodaalbardee5666 2 роки тому +4

    OMG, How you can even think on this way !! ❤️ GOD Bless you all

  • @exceltestnumber1
    @exceltestnumber1 2 роки тому +30

    I thought you used tons of formulas o create this, but really i surprised of this simplicity...BEST UA-cam CHANNEL EVER

    • @OtherLevels
      @OtherLevels  2 роки тому +5

      You got our goal Antonio, Much Appreciate bro

  • @tedjlegrand
    @tedjlegrand Рік тому +2

    The best looking excels dahsboards I have seen on UA-cam..! ANd you share a complete tutorial, Thanks, I learn a lot with you

    • @OtherLevels
      @OtherLevels  Рік тому +1

      Glad to hear that, Thank you Tadh ❤

  • @Augusto64012
    @Augusto64012 2 роки тому +4

    Start releasing the database as well. That way we can follow you more perfectly.
    Thank you for providing so much knowledge with your videos! 🇧🇷

  • @s71.37
    @s71.37 2 роки тому +2

    My prof said to me once that Data visualization is an art, I was not convinced until I saw your channel

    • @OtherLevels
      @OtherLevels  2 роки тому +2

      Thank you very much, we appreciate that

  • @NaJMStudio
    @NaJMStudio 2 роки тому +3

    You are one of my favorite teacher. Amazing work sir really appreciate your work and waiting for next tutorial.

    • @OtherLevels
      @OtherLevels  2 роки тому +2

      Thank you very much Najm, our pleasure

  • @MrSagar93
    @MrSagar93 2 роки тому +3

    Absolutely Beautiful and Mind Blowing skill. Never came across such a person who is great at data also has creative appeal !!
    Fantastic work keep growing 💓

  • @cristianluisteixeirafrc8435
    @cristianluisteixeirafrc8435 2 роки тому +1

    We really have to be very careful with the current fashion of new technologies, we have to be careful not to keep changing tools all the time.
    This fantastic video clearly shows how valuable it is to specialize and master a tool.
    Congratulations

  • @Devi1D0g04
    @Devi1D0g04 2 роки тому

    When I tell you this just made me so happy I been waiting for this video since I saw your 1st. Super excited to finish

  • @ahmedelboghdadi5328
    @ahmedelboghdadi5328 2 роки тому +5

    This is just amazing! I wonder how many videos are remaining for the whole set to videos to be available including the animations. Keep up the great work! On behalf of the whole world, thank you so much for sharing 💛💛

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thank you very much Ahmed, We appreciate that, video are available ua-cam.com/video/FuC0V_nKQW8/v-deo.html

    • @zhen1470
      @zhen1470 Рік тому

      @@OtherLevels what version of excel you are using ????can you tell me thanks

  • @roviskyksa5050
    @roviskyksa5050 2 роки тому +3

    definitely this is an outstanding work with small formula you are doing amazing things, you are a Wonderful ❤

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Glad you like it, Enjoy dear

  • @linhnguy3n
    @linhnguy3n 2 роки тому +2

    Such a brilliant creator! I can't believe that one day excel could turn into piece of art. Really appreciate your kindness to share the tutorial for me. Keep move on and make more video for us to learn!

    • @OtherLevels
      @OtherLevels  Рік тому +1

      Thank you very much ,Glad you like our content

  • @OoDiyaaoO
    @OoDiyaaoO 2 роки тому +2

    Amazing work!!! Never stop creating these outstanding designs and ideas PLEASE

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thank you very much and glad you liked the content

  • @jsaint51
    @jsaint51 2 роки тому

    ...continued from part 1... this is really good. I'm hooked on this one. Tons of fun following along in Excel. The Map is brilliant. On to part 3!

  • @RovyDigitalArt
    @RovyDigitalArt 2 роки тому +10

    Excel MASTERS 👍 i think we dont need any more to go for Power BI or any software

  • @pralhadshetye8863
    @pralhadshetye8863 2 роки тому +1

    You are a creative genius.

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thanks Pralhad, we appreciate that

  • @mdhossen7082
    @mdhossen7082 Рік тому +1

    wow, boss,
    This Video is very very helpful,
    Thanks

  • @lovnishkumar5803
    @lovnishkumar5803 Рік тому

    Mind blowing dashboard great work i really appreciated your hard work and efforts.

  • @featheredserpentofthewest2049
    @featheredserpentofthewest2049 2 роки тому +1

    Absolutely brilliant! Amazing!

    • @OtherLevels
      @OtherLevels  2 роки тому +2

      Thank you very much ,Glad you liked it

  • @downloadmx5318
    @downloadmx5318 2 роки тому +1

    Simply beautiful

  • @jeffthechristian3010
    @jeffthechristian3010 2 роки тому +1

    This is magical.

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

    kudos to "dynamic dots on map"-solution!

  • @ayael
    @ayael 2 роки тому +2

    Lv. Other level's - Welcome bois.
    Lv. Beyond imagination
    Lv. Next level aliens
    Lv. Pure Art
    Lv. Pro
    Lv. Expert
    Lv. Intermediate
    Lv. Basic

  • @TottiXful
    @TottiXful 2 роки тому +3

    Stunning job. Can you please creat a dashboard for actual expenditure vs. Budget. In terms of department division and unit expenditure compared to planned budget 🤗
    Also a business plan.
    Thanks

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thank you very much, it's great idea we will do it soon

  • @homayoonsarwari5375
    @homayoonsarwari5375 2 роки тому

    That's really intuitive and I really loved the work. Keep up the great work

  • @Amathylar
    @Amathylar Рік тому +1

    This is awesome!

    • @OtherLevels
      @OtherLevels  Рік тому +1

      You are the best ❤️ thank you Amathylar

  • @theloniousmonk81
    @theloniousmonk81 2 роки тому +1

    YOU ARE THE BEST

  • @El-HusseinHegazy
    @El-HusseinHegazy 11 днів тому

    Super excellent,
    Kindly is there a way to import KML as a layer above excel map?

  • @shajupauljohn3244
    @shajupauljohn3244 2 роки тому +1

    Excellent presentation

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thank you shaju , Glad you liked it

  • @MrHenk588
    @MrHenk588 2 роки тому +1

    Very amazing work! Just triggered me that the UK is right on Latvia haha, haters gonna hate :p

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Thank you very much, we appreciate that

  • @paulguitard7363
    @paulguitard7363 2 роки тому

    Amazing work!

  • @DLMORALES1205
    @DLMORALES1205 2 роки тому +2

    Tutorial 3,4,5..... please!!!!!

  • @juarezr61274
    @juarezr61274 2 роки тому +1

    Amazing!

  • @dmitriykutyrev8597
    @dmitriykutyrev8597 2 роки тому

    ​ @Other Level’s
    Hello. Thank you for your videos on the channel.
    I want to ask you a question, I hope you can help!
    1. Do you use other data visualization tools?
    2. Where do you get inspiration from to create such wonderful works?
    3. Can you recommend websites / books / articles where you can get acquainted?
    Thank you for your reply, work and your channel.

  • @Nick_88888
    @Nick_88888 2 роки тому +1

    What function do the SIN & COS functions serve ?

  • @relax_your_mind_Nature_8944
    @relax_your_mind_Nature_8944 2 роки тому +1

    Amazing

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

    Hey man great vid
    but i cant seem to get the dots to change color in the map
    i followed everything but its not happening

  • @ashleeherrington2643
    @ashleeherrington2643 2 роки тому +1

    is there a recommendation how to do the map chart if you cannot convert the shape in powerpoint? thank you!

    • @umarilyas8583
      @umarilyas8583 2 роки тому

      Just create dot map manually with circle shapes, it becomes more flexible. Just use another map as an outline and just go around it. Worked for me that way, didnt have the convert to shape feature button un-greying.

  • @twotallsocks
    @twotallsocks 2 роки тому

    Great dashboards. Do you have any tips on multiple users using these? Do they work with Excel Online? Can they be used by multiple people on a network shared folder with Excel? That's the kind of limitations I've run into before which make it less useful.

  • @adarshkaushal3867
    @adarshkaushal3867 Рік тому +1

    At 14:52 unable to change mao color and convert into shapes? Any idea what to do?

    • @RishabGarg-ii5mf
      @RishabGarg-ii5mf 6 місяців тому

      Same problem

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

      You can get a .jpg, convert to .svg ( online tolls are available), paste this svg file to power point & convert to shape. Worked for me.

  • @gilbert2186
    @gilbert2186 2 роки тому

    Do we need to purchase a template in order to fully follow along step by step with this video?

  • @lmy1314
    @lmy1314 2 роки тому

    Your videos are very helpful to me. Could you please share that SVG? I made it according to your video, except for the SVG, the other operations are the same; but if I do the dots, I can't do it (after finishing a country, the dots will not automatically change after the year is changed) I don't know if it is SVG problem or pivot table sorting problem.

  • @dhanashreedahiphale266
    @dhanashreedahiphale266 Рік тому

    please make more videos on power bi dashboard

  • @CherryKolla
    @CherryKolla 2 роки тому

    Thanks for your videos. Can you create a dashboard for a delivery company?

  • @pedrocoelho9999
    @pedrocoelho9999 Рік тому

    Olá! Primeiramente tens um excelente trabalho! Na hora de copiar as bolinhas, quando altero as datas algumas nao puxam a cor correta😢

    • @OtherLevels
      @OtherLevels  Рік тому

      Quer dizer que a cor não aparece ou os pontos mudam de cor diferente da que você escolheu?

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

    Ссылки по плейлистам больше не доступны!

  • @pierrezanetti3283
    @pierrezanetti3283 Рік тому +1

    Hi, do you know where we can found the data tables used to make the dashboard ?
    Thanks for your help !

    • @OtherLevels
      @OtherLevels  Рік тому +2

      you are welcome
      Kindly visit our website to get the datasets for training and practicing
      www.other-levels.com/blogs/datasets

    • @pierrezanetti3283
      @pierrezanetti3283 Рік тому

      @@OtherLevels Thank you !

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

    can you give download to that world picture?

  • @yuvrajdhiman2770
    @yuvrajdhiman2770 2 роки тому

    Please share your data set as well while uploading these videos... we can use the same data set while practicing through your video

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Please visit our website www.other-levels.com you will find the dataset

  • @afonsoribeiro3564
    @afonsoribeiro3564 Рік тому

    Hey man great content but pls allow Visa card on your website and not just paypal

    • @OtherLevels
      @OtherLevels  Рік тому

      Please chat with us on our website to get credit card payment method www.other-levels.com

  • @jamespyle6398
    @jamespyle6398 2 роки тому +1

    hen I change the color of the map in PP it doesn't change, and there is no convert to shapes button. Does this only work in later versions? I am on 2016.

    • @OtherLevels
      @OtherLevels  Рік тому +1

      It's supposed to work in all PP versions

  • @hiagosilvaribeiro3096
    @hiagosilvaribeiro3096 2 роки тому

    Pls, do something about saty of work (segurança do trabalho). There's nothing on the internet. One that we can (acompanhar os exames periódicos), admissionais e demissionais . Acidentes acontecidos no trabalho, e o gráfico mostrar um corpo, e os números na parte do corpo afetada. Algo desse tipo

  • @sonamchopel3087
    @sonamchopel3087 2 роки тому

    Please, can this dashboard be made online for multiple user and real-time viewing?

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

    Please I can't find the dataset for the part two

  • @ManishKumar-ht6gm
    @ManishKumar-ht6gm 2 роки тому

    Why are u creating a new table with vlookup when you can just refer to the pivot table cell?

  • @vishyr9578
    @vishyr9578 Рік тому +1

    What if the pivot tables has more than 6 rows. ?

    • @OtherLevels
      @OtherLevels  Рік тому +1

      For questions about this dashboard? Join our channel Membership
      ua-cam.com/channels/uDF09RGFE3V3lY77Z_cA9g.htmljoin

  • @lachlanyoung6403
    @lachlanyoung6403 2 роки тому

    hey, i was looking to make an excel spreadsheet, where it looks fancy.
    My main goal is to have a spreadsheet where it keeps track of many different types of statistics from all players in a sport team after each game, and even get it to automatically update from an external website if that’s possible?
    is there any of your videos that could best help me? thank you

  • @amirhamzakhan4977
    @amirhamzakhan4977 Рік тому +1

    can you share your data set you had used in this vedio.

    • @OtherLevels
      @OtherLevels  Рік тому +1

      Kindly visit our website to get the datasets for training and practicing,It will be available ASAP for this template:
      www.other-levels.com/blogs/datasets

  • @user-rr9fl1zj9f
    @user-rr9fl1zj9f 5 місяців тому

    I m unable to find svg world dot map

  • @hiranwasalaarachchi6320
    @hiranwasalaarachchi6320 2 роки тому +1

    what is the version of excel that you are using?

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Microsoft Office 365 , Enjoy

  • @havesomemana1442
    @havesomemana1442 2 роки тому +1

    I cant say except (wow)

  • @Beatboxil968
    @Beatboxil968 2 роки тому

    Hi, how to create shape from picture in powerpoint?

  • @gamercod3520
    @gamercod3520 2 роки тому

    How many parts will this tutorial be?

  • @swathimurthy5219
    @swathimurthy5219 Рік тому

    how did you learn all this

  • @elghark
    @elghark 3 дні тому

    Am I the only one that can't color the svg map on Power Point? Actually, when I import it on excel, it is always white in background and black in dots and I can't change it

  • @ycaroovoador7744
    @ycaroovoador7744 2 роки тому +1

    👍👍👍👍👍👍

  • @vrushikasinghania6385
    @vrushikasinghania6385 2 роки тому

    Hi, Could you share where can I get the raw excel data set used for this project?

    • @OtherLevels
      @OtherLevels  2 роки тому +1

      Please visit our website www.other-levels.com

    • @vrushikasinghania6385
      @vrushikasinghania6385 2 роки тому

      @@OtherLevels hi, thanks for replying, the excel on the website is processed data right, I wanted raw, unprocessed data. If possible please share where can I access it from. TIA.

  • @AhmedMohammed-oq6tw
    @AhmedMohammed-oq6tw 2 роки тому +2

    I want to Kiss your HEAD, you are a Genius 🤩

  • @jackbird5987
    @jackbird5987 2 роки тому +1

    Please teach us the rest of the tutorial

    • @OtherLevels
      @OtherLevels  2 роки тому +2

      ua-cam.com/video/FuC0V_nKQW8/v-deo.html

    • @jackbird5987
      @jackbird5987 2 роки тому

      @@OtherLevels thank you very much !!! I kept finding it but I found nothing🥲🙏

  • @vikashchoudhary7008
    @vikashchoudhary7008 2 роки тому

    Can you provide the data for this dashboard??

    • @OtherLevels
      @OtherLevels  2 роки тому

      Please visit our website www.other-levels.com

  • @lightningpop8717
    @lightningpop8717 2 роки тому

    Someone on fiverr using your images.

  • @TSGGaming7803
    @TSGGaming7803 2 роки тому

    Make Data entry teamplete

  • @CH-ce1rm
    @CH-ce1rm 2 роки тому +1

    Fancy and all, but this is essentially just hand drawing with your mouse...To do this every time it'll kill you

  • @OblivionNight1
    @OblivionNight1 2 роки тому +1

  • @kyrsid
    @kyrsid 2 роки тому +1

    Jesus!