Idris Alugo
Idris Alugo
  • 42
  • 63 340

Відео

Data Analytics LearnCamp - Mini Project III (Solution Video)
Переглядів 541Рік тому
Link to the dataset and business requirements: drive.google.com/drive/folders/1B0rsqRgl2AGbMqMS4Uu8nHAz81VzvSWy
Installing Microsoft SQL Server 2022 on Windows 10/11
Переглядів 2,7 тис.Рік тому
Installing Microsoft SQL Server 2022 on Windows 10/11
Data Analytics LearnCamp Week 1 Project Walkthrough
Переглядів 657Рік тому
Data Analytics LearnCamp Week 1 Project Walkthrough
Data Analytics LearnCamp - Mini Project 1
Переглядів 892Рік тому
Data Analytics LearnCamp - Mini Project 1
Maven Space Challenge - DAX and Visualization III
Переглядів 270Рік тому
Maven Space Challenge - DAX and Visualization III
Maven Space Challenge - DAX and Visualization II
Переглядів 414Рік тому
Maven Space Challenge - DAX and Visualization II
Maven Space Challenge - DAX Calculations and Visualization 1
Переглядів 501Рік тому
Maven Space Challenge - DAX Calculations and Visualization 1
Maven Space Challenge - Data Understanding and ETL
Переглядів 722Рік тому
Maven Space Challenge - Data Understanding and ETL
CREATING A DATE TABLE IN POWER BI
Переглядів 1,1 тис.2 роки тому
CREATING A DATE TABLE IN POWER BI
Pizza Sales Analysis - DAX Calculations and Visualization 5
Переглядів 2,7 тис.2 роки тому
Pizza Sales Analysis - DAX Calculations and Visualization 5
Pizza Sales Analysis - DAX Calculations and Visualization 4
Переглядів 2,3 тис.2 роки тому
Pizza Sales Analysis - DAX Calculations and Visualization 4
Pizza Sales Analysis - DAX Calculations and Visualization 3
Переглядів 2 тис.2 роки тому
Pizza Sales Analysis - DAX Calculations and Visualization 3
Pizza Sales Analysis - DAX Calculations and Visualization 2
Переглядів 3,4 тис.2 роки тому
Pizza Sales Analysis - DAX Calculations and Visualization 2
Pizza Sales Analysis - DAX Calculations and Visualization 1
Переглядів 7 тис.2 роки тому
Pizza Sales Analysis - DAX Calculations and Visualization 1
Pizza Sales Analysis - Data Modelling
Переглядів 2,8 тис.2 роки тому
Pizza Sales Analysis - Data Modelling
IDENTIFYING KEYS AND TABLE TYPES IN DATA MODEL
Переглядів 7402 роки тому
IDENTIFYING KEYS AND TABLE TYPES IN DATA MODEL
Pizza Sales Analysis - Data Extraction, Transformation and Loading
Переглядів 3,8 тис.2 роки тому
Pizza Sales Analysis - Data Extraction, Transformation and Loading
Pizza Sales Analysis - Business/Data Understanding
Переглядів 5 тис.2 роки тому
Pizza Sales Analysis - Business/Data Understanding

КОМЕНТАРІ

  • @adityaraj-j9k4t
    @adityaraj-j9k4t 26 днів тому

    Thanks a lot Idris sir. really loved it. Fully Professional Project

  • @adityaraj-j9k4t
    @adityaraj-j9k4t 27 днів тому

    best tutorial ever i found for the power bi project. what a deep thought and insights idris sir applied, thank you Idris sir, please make more videos like this project. this entire playlist is amazing. love from India

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

    My server name is empty and showing me error

  • @NishantPatel-u5o
    @NishantPatel-u5o 5 місяців тому

    Great content. I learned so much from the complete playlist and watching the videos. Thank you for making such informative content.👍

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

    Very clear explanation. thanks

  • @akshat1434
    @akshat1434 8 місяців тому

    Great Insight Idris please cover more Project & also a request if you can take up more sessions on how to drive insights from various dashboard & visuals , & please keep up the good work really enjoyed this session 🙌.

  • @rajatsehgal4249
    @rajatsehgal4249 8 місяців тому

    The column that you named total price will be Sales/Revenue .The total price will be when you sum up all the values present in price column .

  • @firelibrary3605
    @firelibrary3605 9 місяців тому

    Good morning my Day name is not getting sorted from monday to sunday... How to sort ? Kindly help

  • @maizidan2295
    @maizidan2295 11 місяців тому

    thank u so much for ur effort i own u my new career which is realy change my life , thank u again idris

  • @Practice-k2w
    @Practice-k2w 11 місяців тому

    Hi , i want to do the same maven pizza challenge using excel and board applications Could you please explain the same using excel

  • @a.adebayo3708
    @a.adebayo3708 Рік тому

    How can I get the data for this class please?

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

    This is a very educating and interesting lecture on Data Analysis being offered for free. May you remain blessed beyond measures for this selfless service to humanity.

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

    Please Idris, we don't have access to the data. Please can you kindly provide the link?

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

      drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q

  • @a.adebayo3708
    @a.adebayo3708 Рік тому

    Good evening Mr Idris. How do i get the the original data for task 2. 🙏

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

    Thank You Idris, for this great playlist... The data files for Day 10 (SQL) are missing .... Kindly provide the same by sharing your discord in your About section or providing the link here.

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

      Hello Bashir, Thank you. The data is same as previous video I believe. Could you confirm this?

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

      Hello Bashir, here it is: drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q

  • @a.adebayo3708
    @a.adebayo3708 Рік тому

    Good evening. Please how do you delete the range and cells when highlighted and the 100 in D3 remains the same with it's formula. How do you make 100 in D3 stand alone when highlighting it and you can delete other rows and columns without it being affected. Thank you

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

    Good day, Mr. Idris Alugo. I found it very hard to access the link to dataset you dropped in this video, is there anything you can help me do about it? Because, I am actually done with this class but I think I will learn better while using the same dataset. Thank you

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

      Hello. Here is the link: drive.google.com/file/d/1EOyw56eh3B7d05s8zluaoNWBTOjO9ab8 Same as in the description above. kindly let me know if you still cant access it

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

      Thanks so much, I can now access it @@IdrisAlugo

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

      I was the one that sent the previous msg with my friend's email account. Thank you

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

    Keep up the good work sir.. You are a good tutor. Have learnt more than I thought I would practically

  • @chiamakaiyke-okoye823
    @chiamakaiyke-okoye823 Рік тому

    Thank you!, I've learned so much from this! :)

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

      I'm glad you were able to learn and complete the Excel series. You can share your project on LinkedIn and tag me. What's next? Going to SQL? Or PowerBi?

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

    Hi Iddris, I was trying to use F4 to insert the dollar sign but it was giving me project. Is it a keyboard issue?

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

    I believe questions can still be answered even after the BootCamp sir. My question is, you have illustrated using the formula search to find the position of "-" What if the words are all joined together. How do we separate that using the same methods?

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

    😀 *Promo sm*

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

    Hi Idris. Thank you for the knowledge you have been impacting. I noticed that the dataset for day 10 is not linked. Can you pls link it, so we UA-cam summer learn camp members can continue with the class? Thank you.

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

      I believe it should be previous data. Kindly check. Thanks

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

      drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q

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

    how can i get the data file to your videos

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

      You can find it in the description

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

    For the joins where the columns to be used to join has a similar name you can use USING() which works the same as ON

  • @estherolaoye-fl4gw
    @estherolaoye-fl4gw Рік тому

    Hi Mr. Idris, I would like to join your class via Zoom meeting when else you are having your class, How do I go about it?

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

    Thank you for this. I have been stuck on learning SQL for so long and this summer learn camp has been of great help.

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

    Date Table it is 😊

  • @BrianMackey-lz7iw
    @BrianMackey-lz7iw Рік тому

    host udah coli belum?

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

    You videos are a great source of learning

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

    I couldn't connect to the server cos it's asking for name of server.

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

    Very interesting, insightful

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

    Pls I tried this but I keep getting error in installing the SQL server

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

      What challenges are you facing because I am just installing mine now with the help of the video

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

    This is an awesome video, very explanatory

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

    This is amazing! Thanks for your concise explanation.

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

    One to one relationship is used to identify a unique identity. Used case scenario: In monogamous relationships, one person has one partner, who is only partnered with that person.

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

    You are a great teacher

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

    Thank you for the great walkthrough Mr. Idris. Need some clarification on the first question asking for the top 3 ratings for movies released in the United States. Do we count the 'rating' column that has the rating of the movie in alphabets or find the top 3 in the 'score' column that has the IMDb user rating?

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

      while thye score and rating might sound similar, it is only logical to find the Top 3 of a categorical variable (rating) based on movies count. It is not possible with score for sure. Top 3 score based on what? Score is a continous variable. I hope you understand the explanation?

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

      @@IdrisAlugo Thank you. I get it, clearly. Had just queried the top 3 score IMDb rating.

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

      The second last question asks for the Avg of the Top genre in India not total (SUM).

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

      @@Data_Accord Thanks for pointing. An oversight

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

      Bringing all my code together, I was thinking the tables would include all the average, sum, count..... I did not know it is going to include only the release country

  • @ayomideayotiwonuleola5018

    Sir, can you share the dataset for this Mini Project?

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

      It has been added to the description. Here it is: drive.google.com/drive/folders/1B0rsqRgl2AGbMqMS4Uu8nHAz81VzvSWy

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

      @@IdrisAlugo thank you so much

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

    Please sir, can I have your Twitter handle?

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

    “I don't know o, even me I'm confused right now”😭😭😭😂

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

    Thank you sir, pleasure to watch...

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

    Thank you, very beginner friendly 😊

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

    THANK YOU VERY MUCH IDRIS, I WANTED TO ATTEMPT THE TASK BUT COULDNT ACCESS THE PLATFORM,PLEASE HOW DO I JOIN THE DISCORD AND HAVE ACCESS TO THE RESOURCE

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

      The registration for the camp is closed so you can't join the discord. You can access the resources for the task in the next video. Check the data analytics learncamp playlist. The video and workbooks are there.

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

    Thank you Idris Sir, your teaching of tutoring is amazing. May Allah bless you sir. Precise and accurate to understand, once again thanks a lot for understanding this tough topic at this ease...

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

    God bless you boss

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

    Good day Sir. I have tried downloading this video through the same platform i used yesterday but couldn't do so.

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

    I'm trying to download this video on my phone but the link I copied is not working perfectly like the last uploaded video link.

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

      Hello, kindly try again. the link is generated by UA-cam

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

      I just tried it now with this "ua-cam.com/users/livekMzPGdy21sI?feature=share" and it didn't work. Just like 5secs of the clip.

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

      @@yusufbolajijimoh6226 pls try this: ua-cam.com/users/livekMzPGdy21sI

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

      ​@@IdrisAlugoI used another downloader and it was fine. Thanks for your service

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

    Hi everyone, if you need the spreadsheet from the class, please check the description on the UA-cam videos from previous classes. You should find the spreadsheet linked there. I hope this helps.

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

    Than you Sir, how can I become data analytics please please do a favour of help and give step by step guidance to reach there.

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

      Well noted. Will definitely be working on this one. Thanks for suggestion

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

      @@IdrisAlugo Thaks for replying sir, I watch your excel videos, that series was awesome and I learnt a lot from there. Sir I have completed my Masters of Computer Applications in 2018. I have knowledge of Excel, SQL, python programming and still I don't know to find Carrier in Data Analytics. Please do some tutorials in orde to adopt

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

      @umarbashir1236 sounds like you are good to go for me. All you need to do is work on data projects and use your social network like LinkedIn etc. Have you worked on projects?

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

      @@IdrisAlugo Not yet. I wonder! Where to get projects sir

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

      @@IdrisAlugo I'm currently working for government organization and use only M.S Excel there for working and they pay me 100 dollars per month only. Which is not sufficient for me to run my home needs