- 42
- 63 340
Idris Alugo
Poland
Приєднався 10 жов 2022
Data Analytics LearnCamp - Mini Project IV Solution Video
Data Analytics LearnCamp - Mini Project IV Solution Video
Переглядів: 425
Відео
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
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
Thanks a lot Idris sir. really loved it. Fully Professional Project
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
My server name is empty and showing me error
Great content. I learned so much from the complete playlist and watching the videos. Thank you for making such informative content.👍
Very clear explanation. thanks
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 🙌.
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 .
Good morning my Day name is not getting sorted from monday to sunday... How to sort ? Kindly help
thank u so much for ur effort i own u my new career which is realy change my life , thank u again idris
Hi , i want to do the same maven pizza challenge using excel and board applications Could you please explain the same using excel
How can I get the data for this class please?
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.
Please Idris, we don't have access to the data. Please can you kindly provide the link?
drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q
Good evening Mr Idris. How do i get the the original data for task 2. 🙏
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.
Hello Bashir, Thank you. The data is same as previous video I believe. Could you confirm this?
Hello Bashir, here it is: drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q
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
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
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
Thanks so much, I can now access it @@IdrisAlugo
I was the one that sent the previous msg with my friend's email account. Thank you
Keep up the good work sir.. You are a good tutor. Have learnt more than I thought I would practically
Thank you!, I've learned so much from this! :)
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?
Hi Iddris, I was trying to use F4 to insert the dollar sign but it was giving me project. Is it a keyboard issue?
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?
😀 *Promo sm*
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.
I believe it should be previous data. Kindly check. Thanks
drive.google.com/file/d/1m0kTq5fPn6fbDMSc6iuIK3i_jV--Cr4q
how can i get the data file to your videos
You can find it in the description
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
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?
Thank you for this. I have been stuck on learning SQL for so long and this summer learn camp has been of great help.
Date Table it is 😊
host udah coli belum?
You videos are a great source of learning
I couldn't connect to the server cos it's asking for name of server.
Very interesting, insightful
Pls I tried this but I keep getting error in installing the SQL server
What challenges are you facing because I am just installing mine now with the help of the video
This is an awesome video, very explanatory
This is amazing! Thanks for your concise explanation.
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.
You are a great teacher
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?
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?
@@IdrisAlugo Thank you. I get it, clearly. Had just queried the top 3 score IMDb rating.
The second last question asks for the Avg of the Top genre in India not total (SUM).
@@Data_Accord Thanks for pointing. An oversight
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
Sir, can you share the dataset for this Mini Project?
It has been added to the description. Here it is: drive.google.com/drive/folders/1B0rsqRgl2AGbMqMS4Uu8nHAz81VzvSWy
@@IdrisAlugo thank you so much
Please sir, can I have your Twitter handle?
“I don't know o, even me I'm confused right now”😭😭😭😂
Thank you sir, pleasure to watch...
Thank you, very beginner friendly 😊
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
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.
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...
God bless you boss
Good day Sir. I have tried downloading this video through the same platform i used yesterday but couldn't do so.
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.
Hello, kindly try again. the link is generated by UA-cam
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.
@@yusufbolajijimoh6226 pls try this: ua-cam.com/users/livekMzPGdy21sI
@@IdrisAlugoI used another downloader and it was fine. Thanks for your service
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.
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.
Well noted. Will definitely be working on this one. Thanks for suggestion
@@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
@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?
@@IdrisAlugo Not yet. I wonder! Where to get projects sir
@@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