Жыл бұрын
2 жыл бұрын
Пікірлер
@RememberRund Күн бұрын
Great thanks If we add extra cell will PowerBI covered it ?
@mohammedishtiyaq-l4u 2 күн бұрын
Music is louder than your voice over
@absentdata Күн бұрын
My bad 👨
@bishtdeepak__ 2 күн бұрын
can you please tell me, where you got the dataset?
@dustyocat 2 күн бұрын
These videos are all completely illegible to me. No one mentions this in the comments below. Any thoughts? I have never encountered this
@absentdata 21 сағат бұрын
What do you mean by illegible?
@x9v8k 3 күн бұрын
When I choose card(new) it does not show the images it displays MV7 and a empty box next to it. How can I fix this?
@datsummerchik 3 күн бұрын
Thank you!!!! This was all the help I needed!
@absentdata 3 күн бұрын
You're welcome
@Collins-nv4qv 4 күн бұрын
Wtf is this 😮 I just started sql yesterday
@absentdata 3 күн бұрын
Keep it up
@Data5555 6 күн бұрын
when i add the: riders*price as revenue i get: Msg 8117, Level 16, State 1, Line 18 Operand data type nvarchar is invalid for multiply operator. Any suggestion, or help?
@absentdata 5 күн бұрын
Read the error. It's tell you the problem. You are trying to multiply different data types. Make sure they are both numbers. Check your data tyoes
@jeffjosepaliakara425 6 күн бұрын
Brooo count(*) will also work
@k_uronushi 9 күн бұрын
Hi, thank you so much for this video. I'm facing a problem though, I followed up all your instructions up until 2:56. After I hit enter it says "'C:\Program' is not recognized as an internal or external command, operable program or batch file.". What to do now?
@VlexCrowley 9 күн бұрын
wow
@VlexCrowley 10 күн бұрын
I'm a beginner so excuse me if my question sounds silly😅, after the first cte why did you make a percentage rank and not just query with SELECT TOP 25 PERCENT?
@absentdata 10 күн бұрын
Percent rank rank the values by percentage. You can use top 25% but the data needs to be sorted and it's the top 25% of the data, not the top 25% of the sales
@TechiSkills 6 күн бұрын
@@absentdata For sorting Data we can use order by total desc inside cte. After that we can find top 25% or limit 25% from cte
@ankitabhande7715 12 күн бұрын
What is the actual Project name
@absentdata 12 күн бұрын
You give it whatever name you want
@zairereid656 13 күн бұрын
Can we use HasData's dynamic scraping method with just two lines of code too?
@absentdata 13 күн бұрын
What's dynamic scraping?
@MohammadMonirHossain-uo2mm 14 күн бұрын
Very good video tutorial. Benefited, Thank you very much.
@absentdata 14 күн бұрын
Thank uou
@kiranneelangol3596 15 күн бұрын
Im glad i found this channel. Best resource to enhance advanced sql skills… thank you 😇
@absentdata 14 күн бұрын
Thanks for subscribing
@chandlercrisafe 16 күн бұрын
*not so beginner friendly
@absentdata 15 күн бұрын
Glad you enjoyed it. Share it within anyone who wants to learn
@samarthsam8102 16 күн бұрын
Or you can just simply use rlike '%[0-9]{5}$'
@youdube1203 18 күн бұрын
A super tip. i am going to check Over clause documentation
@absentdata 15 күн бұрын
Thanks
@leninrangarajan 21 күн бұрын
for coefficient and intercepts components = pd.DataFrame({ 'component': X.columns, 'value': coef }) intercept = pd.DataFrame({'component': ['intercept'],'value': [lin.intercept_] }) components = pd.concat([components, intercept], ignore_index=True)
@arielxiao4766 22 күн бұрын
ntile is good too
@absentdata 22 күн бұрын
How would you write the query using ntile
@arielxiao4766 21 күн бұрын
@@absentdata maybe ntile(4) OVER(...ORDER BY total_sales DESC) and then MAX(total_sales) where ntile_percent = 1?
@bassantahmed5964 23 күн бұрын
why you are neglect other scores in all of (M,F,R) and filter them to top scores ?
@absentdata 23 күн бұрын
Usually the business objective is to target customers who have the highest potential to pay. Those would be top scorers
@bassantahmed5964 22 күн бұрын
@@absentdata I have make RFM depend on all data without filtration and give me the same percentage , it is more logic for me and I don't know if it is true or not ... I didn't understand how you filter the 8,9,10 top customer again is it logic or filtration of whole customers?
@bassantahmed5964 22 күн бұрын
@@absentdata top customer filtered to top , intermediate and low why ? .one more time I didn't get that point
@rayyanzaidi3323 24 күн бұрын
after following from start I just got lost after mint 48 :/
@ThePlaceUncovered 24 күн бұрын
nice work. Kindly, I got lost during the modelling sections where you say you already created the Ifs and the chart. from timestamp 7:31. Kindly share that video.... I am eagerly waiting. Or something close to that. Because I am stack with that data coefficient not knowing how to link it to the existing sheets and continue the modelling and visualization. Many thanks. new sub
@absentdata 24 күн бұрын
I guess you mean the what if analysis. You can use this video tutorial kzbin.info/www/bejne/moark6KffapqgKs
@BDQUERY350 25 күн бұрын
well done!
@d4v1d16 26 күн бұрын
I add the csv files, but decimal numbers doesn't have the decimal point, for example in the video or file in github I see 0.24 in temp colum but in my sql server I see 24, any idea what is the issue? Thanks
@absentdata 25 күн бұрын
No idea. but since you identified a difference you can modify it
@d4v1d16 25 күн бұрын
@absentdata Thank you
@makeitbueno 27 күн бұрын
Sql union, join하고 power bi로 넘기고, interactive dashboard로 담아서 stakeholder들이 필요로 할만한 insights를 담아주는 과정이 깔끔하게 술술 이해됐어요. 몰입해서 보게 된 흐름 좋은 강의였습니다!
@onehmong9368 27 күн бұрын
What in the world is this shxt. As a python programmer I'm lost.
@absentdata 27 күн бұрын
Sorry homie. I'm creating a SQL course for Data Analyst. You will be able to follow easy to advanced
@onehmong9368 27 күн бұрын
@absentdata thanks dawg
@montegukh7907 Ай бұрын
amazing video, i've learned alot But just one issue, at around 1:05 instead of 34%, I am getting the answer as 0, for all the products.
@absentdata Ай бұрын
Check out the description it will show you how to create a date table. There was an issue when I uploaded it and this short section was skipped.
@MamadoSulie Ай бұрын
Why you have chosen more than 3 days is late day ?
@absentdata Ай бұрын
It arbitrary you can choose 6 days if you want. It just the cut off that was given in the question
@nirjharacharjee1088 Ай бұрын
You are just doing sneaky edits. Following you means wasting time.
@absentdata Ай бұрын
Unsubscribe and watch something else
@nirjharacharjee1088 Ай бұрын
@absentdata Definitely will do that. Don't worry. Thanks for your suggestion though.
@VonexCS 28 күн бұрын
@@nirjharacharjee1088 wdym?
@juroolubalakrishna7399 Ай бұрын
@absentdata i wrote this Dax formula After connecting the tables "Profit YoY = var last_year = CALCULATE(SUM(Query1[Profit]),DATEADD(CalenderTable[Date],-1,YEAR)) return (SUM(Query1[Profit])-last_year)/last_year" then after creating the card it is showing "infinity" can please guide me what to do ?
@absentdata Ай бұрын
Read the description
@juroolubalakrishna7399 Ай бұрын
@@absentdata I have created the date table according to the description and tried the formula byt instead of 34%, I am getting the answer as infinity.
@lucskyost Ай бұрын
Solution to handle incorrect date format after data import: By default, SQL Server uses system regional settings to interpret date formats (e.g., DMY for Vietnam, MDY for US), then converts them to YMD format when storing. -To handle DMY format, run SET DATEFORMAT DMY before importing. -If you prefer not to change the default, update the table with: UPDATE product_sales.dbo.product_sales SET Date = CONVERT(DATETIME, FORMAT(Date, 'yyyy-dd-MM HH:mm:ss'), 120); -Alternatively, change system regional settings: +Go to Region settings. +Set Date format to dd/MM/yyyy. +Restart SQL Server if necessary. -You can also edit the CSV file before importing to ensure correct date formatting.
@absentdata Ай бұрын
You're a hero! Thanks for posting this
@edekicharles3505 29 күн бұрын
Thank you for this
@xavierberge524 21 күн бұрын
@@absentdata It would be a good idea to pin this post at the top of the comment section for it to be the first one seen by the viewers as I am pretty confident a lot of the viewers following the video as a tutorial will have to face this issue.
@MaveLight2030 Ай бұрын
The best doing it in FPA
@absentdata Ай бұрын
Or Python :)
@shekhark1139 Ай бұрын
Thanks👍 for posting for interesting video. I think this code works, pls correct if need. ;with cte as ( Select salesperson_name, Sum(amount) over (partition by salesperson_name order by sale_date asc) as Run_sum from sales_data ) Select * from cte where run_sum=100000
@rendezyt Ай бұрын
Thanks for the video; how did you create the 2023 and 2022 button visualizations at 59:56 as just before the report did not have these; I made buttons through the insert tab (not selecting the visualizations pane as I did not see those visualizations in the available ones) and shaped them into a trapezoid but when I select the filters pane (with my buttons selected) it does not say Filters on this visualization, it only says filters on this page. You kinda skipped that step and I am confused. I am having trouble trying to filter the the Units Yoy and Profit Yoy for 2022/2023 as a result; as you did not explain the edit relationships thing or the visualization I explained above. Could you please respond back?
@absentdata Ай бұрын
There are only filters and no buttons used. If you want to know how to build a date table, read the description.
@rendezyt Ай бұрын
@@absentdata Thanks for replying I don't mean the Dates table, I have that already. What did you do exactly to make the 2022/2023 black and white colored filters that trapezoid shape at 59:56 in the video next to the ASCES logo; like what steps did you take? I have tried to recreate it in but because you did not actually show them I have not made progress.
@rendezyt Ай бұрын
@@absentdata I know you are busy sir, but could you please respond to my follow-up query just above. Thanks.
@rendezyt Ай бұрын
@@absentdata No worries, through some digging I found out it is a tile slicer (2022/2023) visualization not a button
@jegbefumweneddie-ehis8300 Ай бұрын
@rendezyt were you able to edit the image slicer in 36:00-40:00, i am genuinely having hard time with this as I do not get the options to edit the image slicer
@pebrian7252 Ай бұрын
How if we use distinct count for frequency to get total transaction because there's multiple data for every invoice number?
@absentdata Ай бұрын
An invoice shoukd have multiple data. I bought 3 apples so I will get one invoice with 3 apples.
@alexey.zaitsev Ай бұрын
Why do we multiply sum(is_late)*1.0?
@absentdata Ай бұрын
If you multiply by a decimal or float it will ensure that you also get a float value back. If you don't it will just round to the nearest whole number.
@shekhark1139 Ай бұрын
Interesting @@absentdata
@MamadoSulie Ай бұрын
But if u didn't multiply the query it's still correct, isn't it ?@absentdata
@minahiljaved2952 Ай бұрын
what is the best method? especially in stocks data?
@absentdata Ай бұрын
That's a hard one to answer because it depends on the volatility of the stock but you should try backfilling
@darllabulagner8585 Ай бұрын
Big thanks for this! Keep doing this kind of video :)
@absentdata Ай бұрын
Much love!
@rendezyt Ай бұрын
@@absentdata Hello, thanks for the video; how did you create the 2023 and 2022 button visualizations at 59:56 as just before the report did not have these; I made buttons through the insert tab (not selecting the visualizations pane as I did not see those visualizations in the available ones) and shaped them into a trapezoid but when I select the filters pane (with my buttons selected) it does not say Filters on this visualization, it only says filters on this page. You kinda skipped that step and I am confused. I am having trouble trying to filter the the Units Yoy and Profit Yoy for 2022/2023 as a result; as you did not explain the edit relationships thing or the visualization I explained above. Could you please respond back?
@aniketbhateja9638 Ай бұрын
Sir i calculated profit yoy using pivot table in excel and manually verified it, it's coming out to be 6.686%, kindly verify because It differs vastly from your 34%. Thank You.
@absentdata Ай бұрын
Read the description
@aniketbhateja9638 Ай бұрын
@@absentdata I did create the date table and connected it manually.
@unknown-x3l Ай бұрын
Please provide dataset for practice.Then it will be more fun.
@BenjaminOrkins Ай бұрын
When I go to import the data, my data type for dteday is showing up as nvarchar, and when I change it to datetime, my import fails every time. Any ideas?
@aiwaheed3902 Ай бұрын
nice tutorial. well done
@Moshie71 Ай бұрын
I’ll give this a go later, but I’m sure there’s no way this will work …
@akataowensordum Ай бұрын
Why was the letter ‘t’ inserted, please?
@tounsiomar2626 Ай бұрын
you are using a subquery so you need to alias the table you created in the subquery
@samsungnotezece Ай бұрын
Loved it 🙏 Thank you ✅️
@absentdata Ай бұрын
Much love