Welcome to our channel! We're here to help aspiring data analysts learn the skills they need to succeed in the field. Our focus is on Tableau, MySQL, Excel and Power Bi. We aim to provide clear and concise explanations of key concepts and techniques, along with hands-on examples to help you learn by doing as practice makes permanent. Whether you're a beginner or an experienced data analyst, our channel has something to you. Subscribe now to stay up-to-date on the latest data analysis trends and techniques.
thanks of lot ...i have no words for you but such as you are a great man...this error have taken my a lot of time but after seen your video my all problem was solved as clear cut to cut ...once again thanks of lot...🙌🙌❤❤
You have no idea how grateful I am. I've tried everything, and nothing worked, and OMG this was a great solution! A tip for ppl with the same problem: ProgramData may be a hidden folder, so you may have to change the properties settings to see it. And also, instead of changing the file, you can just copy your table data file into the Uploads folder, and it will all be the same :)
Is there anyway to do this with less than 12 months of data? I can not do this and I think it might be because my data set has dates that don't total a full year.
It appear this (20:56:49 load data infile 'freight.csv' into table freight fields terminated by',' ignore 1 lines Error Code: 1292. Incorrect date value: '2018-01-02;10975;38;774571;MMA-5946;Herrings Crossroads;7' for column 'fecha' at row 1 0.000 sec )
Error Code: 1292. Incorrect date value: '2020' for column 'date_added' at row 1 I still keep getting this error even thought I updated my data dates from yyyy-mm-dd
HELLO i HAVE TRIED YOUR STEP BUT THEY ARE GIVING ME THIS ERROR: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Still having issues. My dataset does has lot of null values and its not a calculated field you can easily apply formula. How do I import this file with the nulls
bro i want to import csv file containing 60000 rows into wix but there is a limit of 50,000 rows so i am trying to upload it to mysql(external database option) how do i achieve this?
Buddy, thank u so much for this video. I got a problem trying to resolve the secure-fiele-priv issue, but I read your comments and I could resolve it. THANKS A LOT.
not all the dashboard is sales basis what if for asset management? that is why that profit margin does not apply always, please make an example that is generic to all
I have a question. I have a bar chart, showing the percentage of A from B. I want the bar to be green if it meets the target (constant), and red if not. Now, I've created the color calculated field, saying if percentage was higher than target then 1, else 0. But when I'm adding the field to color, it only shows 1 or 0. Not both so that I be able to set the colors. I do not know what is the problem. I did add other fields, thought maybe it's because it's a one bar, but again, I do not get both values, only then one which applies to the condition. Appreciate your help in this regard.
Hi there, Hope you're doing well. This approach is not suitable for your case as tableau shows only the available values only for the field you created. So, if your calculated field has all values of 1 then tableau will show 1 in the color field unlike this video where we have both values (0,1) in the fields values.
Good one, but this is possible only when all dashboards are in same file, what if all dashboards are in different locations and files, what tool needs to be used??
@@AnalyticsExplorers I forgot what I did; it's been a while, but it's fixed. Thanks for creating this video as my company has transitioned from ms access to an actualy rdbms
Hello Suvarna, You can find the solution in our short video here: ru-vid.comn4xjOUnfOMY?si=rj1MxuCMHAI9lpQ5 Good luck and if you find it useful, don't forget to spread it with your colleagues!😀
Explore more on MYSQL CSV import: 1) using python and pandas (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5IU7PZZ0LM8.htmlsi=ayhprBcnipS8-RJM) 2) using table data import wizard (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pmLrjtnUEBc.htmlsi=a4C2Mxb0UaAEajBk) Find Error 1290 "secure-file-priv error" solution here (ru-vid.comn4xjOUnfOMY?si=2ACk_9oOw0WfStyr)