Data Analyst Portfolio Project - Final Result - Power BI & Excel

Поделиться
HTML-код
  • Опубликовано: 11 ноя 2024
  • НаукаНаука

Комментарии • 30

  • @RoronoaZoro-qm8hp
    @RoronoaZoro-qm8hp 3 года назад +4

    Hi Ali hope you are doing great buddy...
    Just wanted to drop by and say thank you for sharing such amazing content with the community.
    This month I was finally able to transition into Data Science/analyst domain, I which ur content played a major role.
    Keep up the good work 👍

    • @aliahmad1987
      @aliahmad1987  3 года назад +1

      Hey!
      I am great, thank you for asking :) How great is that though? Very happy to hear that from you. I'll keep doing mine and have fun learning everything you will moving forward and remember to give back to others who also want to learn!
      // Ali

    • @RoronoaZoro-qm8hp
      @RoronoaZoro-qm8hp 3 года назад

      @@aliahmad1987 my role is slightly towards the data science domain. Currently I am enjoying the learning process and excited for what next to come.
      Currently I am still a newbie but hopefully in future down the line, I would love do give back to the community 😊.

  • @MohammedAli-kl6dw
    @MohammedAli-kl6dw 3 года назад

    Hey guys i too am Ali but with a difference. I am trying to be a Data Analyst. By the way thank you for all this tutorials. Keep growing by the grace of Almighty!

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Hi there!
      Thank you for your support and I look forward to seeing your progress :)
      // Ali

  • @faiazrummankhan5589
    @faiazrummankhan5589 3 года назад +2

    Fantastic Series !!! Keep on !

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Thank you Faiaz :) Next one might have to be more advanced really...

  • @Prashantpatil-cq3yt
    @Prashantpatil-cq3yt 3 года назад +2

    Please make a video that will help us... In live environment

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Hi,
      I recommend you check my other portfolio series with SQL & Power BI, that is made on an example database!
      // Ali

  • @DebjyotiSaha-lh8lg
    @DebjyotiSaha-lh8lg 3 года назад +2

    Hello Ali,
    Got to know some new things with this portfolio project. Also I am building website for my portfolio will drop it soon whenever it gets ready. Need feedback on that.
    All around really great video and looking forward to more such projects.
    Thank You!

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Hi Debjyoti!
      I am glad you learned some new things, if you make your portfolio and want some feedback please let me know and I would love to give some!
      // Ali

  • @douglastaleb5222
    @douglastaleb5222 3 года назад +1

    Amazing. Thank you, Ali!

  • @michdezal2333
    @michdezal2333 3 года назад +2

    Thanks for series, it really help be visualize the process of storytelling. I had a question, is it fine that there was no conclusion in the analysis?

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Hi Mich,
      First of all, thank you for the kind words :)!
      What was your use case? The easiest is to try and think before about what you are trying to solve or analyze.
      // Ali

  • @SACHINKUMAR-px8kq
    @SACHINKUMAR-px8kq Год назад +1

    Thankyou So much Sir

  • @syaoransakura8839
    @syaoransakura8839 3 года назад +1

    Finally here, I will remark first

  • @giandenorte
    @giandenorte 3 года назад +1

    Such an amazing masterpiece! I am wondering how do you update the dashboard if the daily data is from google forms. We do the cleaning and organizing the data every single day?

    • @aliahmad1987
      @aliahmad1987  3 года назад

      Hi,
      You could use a Power BI gateway to reload data automatically, but the input, if it is a manual source then you would have to enter as you go, otherwise if if it is a smart watch or other things, you can automate this by using an API in combination with a gateway.
      Best,
      Ali

  • @okparaesther7720
    @okparaesther7720 3 года назад +3

    Can i share my power bi dashboard in the trial version of power bi as an interactive dashboard?. Because i am able to only save mine as a pdf and share.

    • @aliahmad1987
      @aliahmad1987  3 года назад +1

      Hi Okpara!
      Yes you can.
      1) Publish it to your Workspace
      2) Navigate to and open the report in your browser
      3) Go to File -> Embed Report -> Publish To Web
      Then it is public and you will get a link to it :)

    • @okparaesther7720
      @okparaesther7720 3 года назад

      @@aliahmad1987 thank you so much

  • @giandenorte
    @giandenorte 3 года назад +1

    Hi ali, I am wondering how can I track every person performance if my first column is date then second column is person1, second column is person2... In the Powerbi, it reads the every column for the fact table. I want it to be person then with drop down as person1, person2.... Help me here

    • @aliahmad1987
      @aliahmad1987  3 года назад +1

      Hi Geian,
      It should be (I'll try and do it here):
      Date | Person_FK | Metric
      06.08.2021 | X | 25
      06.08.2021 | Y | 30
      Hope that makes sense. You have two rows and differnt keys per row, but only one column.
      Then you will connect that to a dimension table describing the FK values and your dropdown would be "PersonName" or whatever you name it.
      // Ali

    • @giandenorte
      @giandenorte 3 года назад

      @@aliahmad1987 yes, I did it like this. I just copy paste the whole date data over and over again in excel, is there a shortcut in this method?

    • @giandenorte
      @giandenorte 3 года назад

      @@aliahmad1987 thanks for this again Ali, I appreciate your teaching and kindness. I am gaining confident now. Hehe

  • @dan.6398
    @dan.6398 Год назад +1

    Hi Ali,
    Is it possible to share PowerBI Portfolio on free version ? I am getting request to input professional email address.

    • @aliahmad1987
      @aliahmad1987  Год назад

      Hi,
      You can create a trial account with a free mail, but long term you would most likely need to use a professional one. Maybe you can use some screenshots?