Жыл бұрын
Пікірлер
@travzafrica 3 күн бұрын
Hello sir, in the weekday column, what days do the numbers 0 to 6 represent?
@Banefane 3 күн бұрын
Thanks!
@johnatanezequiel1713 3 күн бұрын
One tip, you should make a course on Udemy
@absentdata 3 күн бұрын
Thank you! I might just do that!
@nishantkulkarni630 4 күн бұрын
Hello, during this project I am facing an issue to load data into power bi from sql server. I tried several ways to resolve it but unable to solve. error occurs when I load the data into power bi in the last tab by selecting "Use Current credentials" after this step the error message is " We couldn't authenticate with the credentials provided. Please try again." IF anyone can help me with this it will be very helpful for me.
@letsexplorewith_jaggu98 4 күн бұрын
i hope its rows between current row and 1 following
@rachrach9871 4 күн бұрын
Im having trouble downloading the csv file from GitHub. I tried ctrl + s but it showed only webpage option from the drop-down list. Could you please walk me through it? Thank you
@ShottyZGuy 5 күн бұрын
Can i become a data analyst with a degree in Applied Mathematics?
@absentdata 4 күн бұрын
You can of course. Having a strong foundation in math is a huge advantage
@arpansarkar8901 5 күн бұрын
Please keep uploading more Data/Business Analysis Case Study (using SQL or Python)
@user-kf1nm1bw8r 6 күн бұрын
what is SON?
@osoriomatucurane9511 8 күн бұрын
This is truely awesome. Interesting and challenging query. Step 1. Create two new variables (weekday and period). Extract weekday from the timestamp, Create a new grouping column as period bases on the timestamp using conditional statment case when then. Easy! Step2. From the resulting query in step 1, Count the records based on the weekday and period, and rank them by the total count in descending order. Easy, just like taking breakfast in the morning! Step 3. Select and display the results from the previous step2. Voila.
@absentdata 8 күн бұрын
That could be a good solution if I understand it correctly!
@osoriomatucurane9511 8 күн бұрын
@@absentdata , Sir I was just translating your query using plain english in layman terms. Actually I have replicated your query using food delivery dataset with MySQL. At the end, instead of using he window rank() , just sorted by descendent order. With cte_top_orders as ( -- Step 3 select wk_day, order_periods, count(*) as total_orders from ( -- step 2 Select wk_day, Case When order_place_time in(5, 10) then "breakfast orders" When order_place_time <= 15.5 then "lunch orders" When order_place_time <= 22.5 then "dinner orders" ELSE "late night orders" END as order_periods From ( -- step one SELECT dayname(order_time) as wk_day , time_format(order_time, "%H:%i") as order_place_time FROM food_orders ) as t1 ) as t2 Group by 1,2 order by -3 Limit 2 ) -- step 4- Final Select ROW_NUMBER() over() as Item, order_periods, total_orders From cte_top_orders ;
@mohamedabdelkader8003 8 күн бұрын
Can we make the AVG of the avg_price as sub query??
@absentdata 8 күн бұрын
That would not give the average of all the priorities. That would just be an average of all the state average
@mohamedabdelkader8003 8 күн бұрын
@@absentdata the first avg make all priorities 8 and think if makes a second avg of the new value of the old avg Wil give us 4 priorities that's mean it's working right?
@yusufbas035 9 күн бұрын
i love your videos it's so simple
@rohithan2023 9 күн бұрын
I love your videos. Learning something new with every video
@absentdata 9 күн бұрын
I am glad to hear that!
@rohithan2023 9 күн бұрын
Awesome, thanks!
@absentdata 9 күн бұрын
Thanks for watching
@user-sg3sy4vf3i 10 күн бұрын
Hi, getting ready for upcoming test case for interview, learned A lot of useful things by watching all of your case projects!
@absentdata 9 күн бұрын
Good luck on your case study!
@user-sg3sy4vf3i 10 күн бұрын
I like you approach very much to keep it simple!
@absentdata 10 күн бұрын
Thank you. I'm glad it was easy to approach
@mildamaulida916 10 күн бұрын
Thank you for this video I love it. but when I try to import data, the columns in the temp and atemp sections don't have dots (.) why? even though the data type is already float. Please reply
@MadeForD 10 күн бұрын
oh shiii Tokyo Revengers???
@absentdata 10 күн бұрын
Huh?
@MadeForD 10 күн бұрын
@@absentdata nvm i thought you know the "Toman bike" reference. That sample data you got was probably from someone who's a fan of the anime Tokyo revengers. Basically Toman is the name of the gang of bikers that's in the anime. Nvm
@mxrkb10 12 күн бұрын
This is easy and very helpful! Can I make this and add it for my portfolio?
@absentdata 11 күн бұрын
Of course, you can add it your portfolio
@Aditya_Kulkarni_BACS 12 күн бұрын
Select* from Spotify Limit 10;
@absentdata 11 күн бұрын
This only bring back the first 10 rows regardless of order or context. So its not a valid solution
@giftedone831 Күн бұрын
You thought you were smart 🤔
@sunnygawande5283 12 күн бұрын
Can you make a project on marketing campaigns??
@absentdata 10 күн бұрын
Coming soon
@SaadKhan-yd7ss 12 күн бұрын
I think you got the profit margin formulal wrong. It should be Profit / Revenue
@danarobinson180 14 күн бұрын
Very interesting data. Thanks for sharing!
@danarobinson180 14 күн бұрын
Thank you!
@vladovodenicharov6014 15 күн бұрын
Hey, I just wanted to let you know that I found out about your channel tonight and it is amazing. There are many great data-related channels on KZbin, but yours is pure gold. I would say this is the most practical content I have seen so far. One tip would be to switch to a better microphone because at some points, the audio quality is not great.
@antonioalvarez3246 15 күн бұрын
Is it a free database to practice the exercise? Where can i find a database to practice this? Thanks for the tut !
@finishfinish4370 18 күн бұрын
Thank you for making this video! it helped me get started with sql and power bi
@absentdata 17 күн бұрын
Glad to hear the video was easy ro approach.
@salvadorfernando4721 19 күн бұрын
Thank you very much! It helped me a lot
@absentdata 19 күн бұрын
Glad it was helpful
@danielringo_ 20 күн бұрын
Can the datepart function be changed with EXTRACT?
@absentdata 20 күн бұрын
Of course!
@TaliaMiller-v9v 21 күн бұрын
Where is this data from?
@parajf 22 күн бұрын
Please show how to connect realtime data streaming from Mysql to power bi
@cookiesleague 23 күн бұрын
after joining the two tables my discount only has a value of 1 or 0. 1 for complimentary and 0 for everything else
@anandshaw-ie3qk 23 күн бұрын
You read your html format dataset 😂😂😂 it's not a web scraping
@absentdata 23 күн бұрын
Since web scraping is the process of extracting data from html code hosted on the web via code or bots. Websites mostly utilise datatables created with html code, which are hosted online. The only means of extracting the data would be through code or bots. So if this doesn't describe Web scraping, please educate us.
@anandshaw-ie3qk 23 күн бұрын
@@absentdata 😏😏
@camomile4085 24 күн бұрын
WITH cte1 AS ( SELECT *, AVG(salary) OVER (PARTITION BY department) AS salary_avg, STDDEV_SAMP(salary) OVER (PARTITION BY department) AS std_dev FROM employee_salaries WHERE Salary >= 10000 ), cte2 AS ( SELECT *, (salary - salary_avg)/std_dev AS z_scores FROM cte1 ), cte3 AS ( SELECT cte2.department, cte2.salary_avg, cte2.std_dev, ROUND(cte2.std_dev/cte2.salary_avg*100,2) AS Coefficient_of_variation, SUM(CASE WHEN ABS(z_scores) > 1.96 THEN 1 ELSE 0 END) AS Ouliers_count FROM cte2 GROUP BY cte2.department, cte2.salary_avg, cte2.std_dev ) SELECT * FROM cte3 ORDER BY Coefficient_of_variation DESC ;
@tareksaleh4526 24 күн бұрын
you have a mistake. you don't divide guest by days
@aditideshpande5566 25 күн бұрын
Thank you so much for an exceptional well explained and clear video better than what I learnt in my masters degree!
@DanurOsda26 26 күн бұрын
I want to say thanks a lot for your video. I decided to switch my career to be a data analyst/business analyst and started the journey a few weeks ago. After looking at other people's CV & portfolios, who switched careers, I wanted to start building some projects before I apply to any data analyst roles. Then I found this video and started to follow along two days ago. Given the limited time I have, because I also have a corporate job, I've finished the process today and feel like I've achieved something meaningful. Thanks again and please keep sharing. Best regards.
@absentdata 21 күн бұрын
Hii I wanted to wish you the best in your career shift. I know its a great idea because the demand for good analyst is growing. I am really happy my video help you. Please share it with anyone who needs help.
@user-op5sd2ij1z 27 күн бұрын
can some one help me while convering date to max in pivote im getting 0 insted of value and then changing to date give me date in 1900
@sumeeraiawan7026 9 күн бұрын
Try these steps: first convert date format in pivot table it will come 1900 but don't worry, go to field setting select max then it will be ok. it worked for me.
@JulieAkin-John 27 күн бұрын
Thank you for this. I was able to complete this and add to my portfolio
@absentdata 27 күн бұрын
Awesome! I am glad you completed the dashboard. Feel free to share it on social media also
@phinebucad9033 27 күн бұрын
Hi, I'm a newbie here. what if I have 2 products and I want to forecast for each product, how should the code be in power query?
@absentdata 27 күн бұрын
2 separate products is seen as two separate datasets, so there should be two separate codes
@PreplyshortVid 28 күн бұрын
I love all your vudeos i just finished your first two Data Analyst Portfolio projects and i can't wait to do the third. That would make it my fourth data analyst portfolio project
@absentdata 27 күн бұрын
Awesome! Thank you so much for watching the videos.
@PreplyshortVid 28 күн бұрын
Thanks so much. I just finished project #1 and guess what i'm already done with this project #2. One interesting experience was that I used MySQL for project #1. Not funny but i succeeded in the end. It to 4 times the number of days i would have used. Lovely. I'm about to start #3. My target is to do as much of these projects as i can be for the end of July and then work on the documentation, presentation and publishing for GitHub and Kaggle.
@nikolaymaltsev7328 29 күн бұрын
Thanks. Does anybody know how to make bar corners round?
@user-qh5fr3yo1w Ай бұрын
Очень хорошее видео. Прям образец как нужно проводить анализ данных.
@john_blues Ай бұрын
The most accurate thing here was "...Please provide this asap". 😂
@ladhkay Ай бұрын
Nice!
@aghnamahardhika Ай бұрын
Thanks! However, is there any way on how to make the border transparent?