i was facing issue while updating the transaction_date to date but then i used this query:- SET SQL_SAFE_UPDATES = 0; UPDATE sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y'); SET SQL_SAFE_UPDATES = 1; and it went perfectly and format was changed to date forat after altering the table.
@datatutorials1
2 ай бұрын
Thanks for commenting with steps
@Ahamed.24
2 ай бұрын
For me, this is not working, I still couldn’t update the date format. It’s still showing the error msg 1411 as it is showing for U.. can u give me a solution for this please ?
@detainedboi5335
2 ай бұрын
Same issue
@ashwinimahankale3044
Ай бұрын
@@datatutorials1 Still facing the same issue
@ajithmathew7209
4 ай бұрын
Sir, pls do a video on complete dax tutorial as early as possible
@AnandeWoman
5 күн бұрын
The most part I like is when you said that “I know you are doing Great” Thank you so much
@AdityaNarayanGoswami-g6u
4 күн бұрын
The Dataset for Coffee Shop Analysis is not there in the Description.
@sathyamanikantabk4483
4 ай бұрын
for me its taking more than 1 hour to load the data into Mysql and why
@kishan0705
3 ай бұрын
That's what I am thinking, have you found any alternative ways to import these data in few minutes
@rishabhchauhan8612
3 ай бұрын
It get loaded in seconds in ms sql
@Hustler19
2 ай бұрын
Same
@tusharprajapati541
Ай бұрын
Same here
@kishan0705
3 ай бұрын
Can someone please let me know what are the other steps to import the data into mysql, it's taking crazy amount of time like seriously 😳, There should be some alternative ways to wrap thi process up in few minutes. Help if someone knows.
@alexrosen8762
3 ай бұрын
There are a lot of SQL courses out there but nothing like this because SQL codes are used in real life/project based forum which makes it more clear on how you can benefit from SQL codes. The documentation makes it even more understandable and you can connect the dots in a much easier way. More project like this please 🙏
@mrbartuss1
4 ай бұрын
It's probably a dumb question, but what's the point of doing SQL analysis? Just to compare the numbers that are in PBI?
@datatutorials1
4 ай бұрын
This is discussed in video, watch complete video for your answer
@sathyamanikantabk4483
4 ай бұрын
ONE MORE SUGGESTION NEXT TIME PLEASE use Snowflake to load the data and teach because it took me more than hour to load the data in MYSQL(i use 16gb ram latest laptop) but where as in SNowfalke it took me just 5 seconds to load the data and now I was good to go.....
@shabareesharadhyamath4688
3 ай бұрын
YESS
@sonalimali9254
3 ай бұрын
@sathyamanikantabk4483 could you pls tell how you did that using snowflake
@rahulttripathi3395
2 ай бұрын
ETL have been common prerequisite in all data science jobs
@navyakatakam745
3 ай бұрын
It was an excellent explanation of every requirement with Mysql and Powerbi. It helps a lot for practicing and learning more. Thank you! Please also do a video on the most essential useable DAX queries and Snowflake. It will be helpful again.
@HeetDayani
3 ай бұрын
close your channel i have fired total_Sales query 10 time and asked chatgpt but not get correct answer answer is null
@minnijain1810
14 күн бұрын
best ever project in whole youtube for SQL and power bi .. really amazing project and thank you so much for uploading it
@PrabhasG-xd3zn
4 ай бұрын
sir i getting error UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y');
@sanjaysonar1152
4 ай бұрын
me too.. :(
@kishan0705
3 ай бұрын
We all get this error because this Stupid has given us wrong Excel data file, see the date format in his Excel file and our Excel file that we have downloaded through drive.
@revalladhanunjay8690
3 ай бұрын
mee too...any solution....?
@thinleyyangzom2161
2 ай бұрын
UPDATE `coffee shop sales` SET transaction_date = STR_TO_DATE(transaction_date, '%d/%m/%Y'); ALTER TABLE `coffee shop sales` MODIFY COLUMN transaction_date DATE;
@Liumusic02
27 күн бұрын
Why we don't use power query in powerbi to clean data? i have watched completely but i don't have answer :v
@E-AKN
23 күн бұрын
good job sir, you have a new subscriber. I learn a lot of thing in this video.
@sathyamanikantabk4483
4 ай бұрын
2:10:58 INSTEAD OF WRITING OR COPYING EVERYTHING into group by statement U can just say 1 (i.e., in select statement i have written the case statement in 1st place so IN GROUP BY MENTION 1 ) to make the query look readable and easy
@meghalohar2367
Ай бұрын
Really appreciate your hard work ..helpful video
@SagarsDataJourney
4 ай бұрын
Thanks for this amazing project. Learned a lot of things
@TheSudp
4 ай бұрын
Sir, Can you do a video on Power App as well and show how the data can be connected through it with our Power Bi desktop version.
@tariqhussain1497
4 ай бұрын
Good noon, you have nice way to explain, and waiting for the part 2
@Priyamarathe-m5o
9 күн бұрын
i am unable connect power bi with my sql please help
@ruchikarajvansh
4 ай бұрын
For Last question we can use this also right ? Its giving same output select dayname(transaction_date) as names_of_days,round(sum(transaction_qty * unit_price),0) as total_sales from coffee_shop where month(transaction_date) =5 group by dayname(transaction_date);
@datatutorials1
4 ай бұрын
Yes
@ramesettyramya4528
3 ай бұрын
Hii, hope you're doing well i've this pblm where we do the total sales for the specific month, so im getting the total sales of all the 12 months but i could not get the total sales for a particular month it is showing me the null value and also i was not able to resolve the date datatype query . please help me to solve this issue and move forward into the project
@Sumankumari-hw9qb
3 ай бұрын
i have the same problem if you have the solution please share here
@subhojitchatterjee6312
2 ай бұрын
UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%m/%d/%Y'); Use this, it worked for me.
@PROCoderss
4 ай бұрын
hello sir i am getting this below error while importing CSV file in MSSQL TITLE: Microsoft SQL Server Management Studio Error inserting data into table. (Microsoft.SqlServer.Import.Wizard) ------------------------------ ADDITIONAL INFORMATION: Error inserting data into table. (Microsoft.SqlServer.Prose.Import) Column 'transaction_date' does not allow DBNull.Value. (Microsoft.Data.SqlClient)
@PROCoderss
4 ай бұрын
and when i changed the data type of transaction_date into allow null then it will put null in the rows
@revalladhanunjay8690
3 ай бұрын
mee too same problem....any solution.......?
@howtohackflipkart3682
Ай бұрын
2 hrs gone still data is not loaded into SQL
@Sanatan_shiksha1
4 ай бұрын
In 999 everything not costly how much time it will take to complete entire course if we give daily 8 to 10 hours
@datatutorials1
4 ай бұрын
3 Months
@deekshidha3794
2 ай бұрын
Bro for me I did'nt connect MYSQL connector with powerbi once I download connect but its does'nt connect with powerbi what can I do can you pls tell me
@vamshikrishnareddy1302
Ай бұрын
thank you so much brother, I have wasted alot of time that how to change date format but now I learned through this , before tried alot of videos, chat gpt , googling etc but I forgot "Y" instead "y" used🥵
@MayankGadiya-uq1el
4 ай бұрын
using the set_transaction_date query my entire date column got converted to today's date. can someone explain why this happened so?
@sayakghosh1670
3 ай бұрын
it would have been better if the data was divided into different tables, the database is not even normalized properly , should atlest normalise to the 3rd normal form
@Abhijeet_13
4 ай бұрын
How to connect MySQL server to Powerbi when I tried to connect then some error is occurring can you help me out it I will sent ss
@Naughtygirl-mi6th
Ай бұрын
Bro mysql show in alter is error why my spelling is correct and code also
@beingrishi6450
4 ай бұрын
When the 2nd part is coming related to PowerBI report making???
@shubhabratadey
4 ай бұрын
I have the following questions: 1. In this scenario we are manually importing a file in SQL and then will get this data in PBI to show various KPIs. What if I could have used Excel files hosted on SharePoints and do the same? It would become dynamic without manual interventions. I would be able to import multiple files then based on my criteria. 2. Is it possible to auto import files in SQL Tables along with file names which'll make our imported data dynamic and will allow the user to play around? 3. Is it possible to automatically delete certain imported data portions. E.g - Lets say I would only like to keep data for the last 30 days and remove the rest from SQL table. 4. Can we use Power Automate to answer my above queries? I would certainly wait or your next video if all or any of them can be addressed. Thanks for this wonderful video.
@vineetkhairwal
2 ай бұрын
Am getting error in. ALTER TABLE coffee_shop_sales MODIFY COLUMN transaction_date DATE; Its showing... incorrect date value
@harshitgarg3313
2 ай бұрын
bro have you solved it, facing the same problem
@taizoondean689
4 ай бұрын
Thanks for uploading God bless You
@VINODkumar-gz8tt
4 ай бұрын
Thanks for new project , time to learn advance dax
@gopichand5717
4 ай бұрын
Awesome video , thanks for sharing
@alfiyaqureshi8507
Ай бұрын
can we do this sql part in SSMS please reply
@mfit8945
2 ай бұрын
why i just get first month data while importing file in SQL workbench
@mfit8945
2 ай бұрын
alter table coffe_shop_sales modify column transaction date Date; alter table coffee_shop_sales modify change transaction_time time;
@KennethDarby-o3j
3 күн бұрын
Thank you, Thank you, Thank you!!
@Wasimd-t4b
4 ай бұрын
Thanks for making this video really helped me to revise me sql concept , keep postting
@chandanchoudhary1893
21 күн бұрын
Thanks
@amangupta5943
2 ай бұрын
when will be the 2nd part is coming
@Naughtygirl-mi6th
Ай бұрын
Bro please reply why mysql show error every time my query is correct but why
@datatutorials1
Ай бұрын
Which query??
@Naughtygirl-mi6th
Ай бұрын
@@datatutorials1 Bhai every query specially transaction ID date change
@datatutorials1
Ай бұрын
@Naughtygirl-mi6th please see pinned comment for solution
@amoltulse851
2 ай бұрын
I am not able to find the database excel file
@dipakmani3964
4 ай бұрын
Thanks for this video, when it will came next video?
@henhunter4298
2 ай бұрын
@47:58 I can't seem to run the query "UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y');. It just gives me the ErrorCode 1411 Incorrect datetime value, similar to what we see in the video. However, you glass over how that was resolved because then I do see the next time you select * from coffee_shop_sales, that this has been fixed. How do I fix the Error Code 1411?
@pathaspandana3852
3 ай бұрын
How to load data quickly in my sql
@beingrishi6450
4 ай бұрын
Why "K" is given i cant understand
@rashmimishra2177
Ай бұрын
thank you , really very helpful
@VINODkumar-gz8tt
4 ай бұрын
UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y'); - tried this and getting error (update coffee_shope_sales set transaction_date = str_to_date(transaction_date,'%y-%d-%m') where transaction_date is not null Error Code: 1411. Incorrect datetime value: '01-01-2023' for function str_to_date 0.000 sec). Kindly help me on this
@vibhorsingh2373
4 ай бұрын
update coffee_shop_sales set transaction_date= str_to_date(transaction_date, '%d/%m/%Y'); Try this, it is working
@babaloladaniel5728
4 ай бұрын
I also encountered same error. Infact, I have been on it for some hours now. However, I got the trick and it worked. The Date format initially was month/day/year. You can check to confirm. So all you need is to follow same progression in your query. UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%m/%d/%Y'); It worked for me. I am pretty happy to share the solution with you.
@nikhildhongade291
4 ай бұрын
good ...keep it up.
@santoshmane9335
2 ай бұрын
Hello, i was facing issue while converting text to date format can you please help me.
@sarveshwankhade6823
3 күн бұрын
bro same issue i faced it but i wested so much time and ask chat gpt aftet i get it
@rao1199
4 ай бұрын
How do we know particular chart to select for specific requirement. Any tips from your side?
@KwinJay-k6l
Ай бұрын
You just have to know chart types and their uses in representing different aspects of data.
@kota117.
4 ай бұрын
Great video waiting for part2 plz upload as soon as possible
@sovan_404
2 ай бұрын
can't change the data types...
@rahulttripathi3395
2 ай бұрын
Pls make videos on etl
@SaikatHazra-d9o
3 ай бұрын
Please make the second part.
@Hustler19
3 ай бұрын
Thanks for such content sir
@MohanKrishna-i8h
4 ай бұрын
Sir please do a vedio on data cleaning...in power query
@datatutorials1
4 ай бұрын
Video is already created kzitem.info/news/bejne/oo2Z052vq5NopKgsi=IciEbmiJve6VXnpA
@nunoalexandre6408
4 ай бұрын
Lovit🎉🎉🎉
@beingrishi6450
4 ай бұрын
Im very lucky to get this channel, exceptional video covering power bi sql and excel
@ThanosBaba218
4 ай бұрын
Can u make a Dax session
@nagarajupullur6489
4 ай бұрын
part - 2 ?
@ayushsinha9749
4 ай бұрын
Thanks sir for this project
@juancruz7836
3 ай бұрын
thank you
@_Anshuman-zo1lj
4 ай бұрын
part 2?
@charlesdanieldoka663
4 ай бұрын
❤❤❤❤❤❤
@Life_with_dharaa
4 ай бұрын
Sir, from where you get this type of dataset?
@datatutorials1
4 ай бұрын
Maven analytics
@johannpauldalingay7329
4 ай бұрын
UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y'); - tried this and the result is Error as shown in the demo (47:46)
@datatutorials1
4 ай бұрын
Whats the error
@johannpauldalingay7329
4 ай бұрын
@@datatutorials1 Error Code: 1411. Incorrect date time value. Same as what is shown in Action Output in your video
@datatutorials1
4 ай бұрын
Try using the query i mentioned in the query document attached with data file
@johannpauldalingay7329
4 ай бұрын
@@datatutorials1 this one? UPDATE coffee_shop_sales SET transaction_date = STR_TO_DATE(transaction_date, '%d-%m-%Y'); The result was Error Code 1411
Пікірлер: 120