The sequel of this playlist is available in form of a video course here codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project If you like this playlist you would absolutely love the course as it is 50X better in terms of quality and content. The course name is Get Job Ready: Power BI Data Analytics For All Levels
I did this project in May-2021 and now I work as a Power BI developer. Thank you so much to Dhaval sir and Hemanand sir for creating this project. Just revisited this series and wanted to convey this!
Hey Raghavan can you help me in connecting data from MySql Database into PowerBI as i am new to this and i just could not find a way to connect data and continously there is some error "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Can you help me with that
@@syedasherahmed949 this video is using 'MySQL' not SQL Server ('T-SQL'). They are two different 'flavors' of SQL. The MySQL code will not run on a MS Server platform. Perhaps this is the issue? (I have never personally experienced any errors connecting Power BI to an SQL Server database)
Why did I come across your channel so late? However, better late than never. thank you so much. You are a great mentor. Early career data professionals are blessed with such great value content. You're a real mentor and keep doing the god's work. Thank you!
00:00 Learn SQL for data analysis 02:20 Download and import the SQL file to create the entire database 05:02 Overview of tables in a relational database 07:08 Data cleaning is a major challenge for data analysts 09:31 SQL can help with data analysis 12:00 Joining date table with transaction table 15:23 Get total revenue for 2020 and Chennai 01:34 Learn SQL for data analysis Crafted by Merlin AI.
It was a very informative video finally getting some clarification on how a data analyst would work from extracting the data and doing analysis thanks for this helpful project 👍🙂
Sir to get the transactions from particular year you can just use the order_date column(no need to use other date, year table). The query would be SELECT * FROM sales.transactions where year(transactions.order_date) = '2017';
Thank you so much sir ,for creating such a beautiful series on data analysis which is easy to understand.No other youtube channel or online course will give such in-depth content.Thank you once again for putting so much effort in it.
Thanks sir for d series it's really helpful for beginners also n for those who wish to transition from others profile.really helpful n straight to knowledge no non sense.only qaulity minutes!!!
Thank you so much! You give a real case from the beginning to the end, and linkage between SQL and PowerBi, which gives a whole picture for data analyzing process.
Thank you for this series.we will get to learn more details from this realtime database. your videos are always informative and helpful... Thank you once again.
Thank you very much sir your videods are so informative , clean, well organized and superbly accurate in instructions like where a file is paced inside github repo ... thanks for so much efforts guides us a lot
you are doing great service sir thank you, I learning BI now, I just wish to ask you that have ever made any project on deep learning on neural networks, if you have any plan in future, please let us know
Hi sir,thanks a lot for sharing your knowledge with us,can you just let us know how did you create your db_dump file?Or more precisely how can we convert a csv file into a db_dump file?
I am getting this error when I am clicking on star import Query: CREATE DATABASE IF NOT EXISTS `sales` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ Error occured at:2020-06-30 22:31:02 Line no.:1 Error Code: 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
The sql file given in source data doesn't contain sales database rather it shows sakila db with tables such as actor, address, category etc. Can someone help me to get the same dataset used here?
I am facing the same problem I tried downloading with the link (in description) and the github link shown in the video Both time same issue If you found some solution please share..
08/12: When I import the given dump in MySQL, I can see this dump has different data than you used. 08/17: My problem is solved today, I watched this video again, I was missing to refresh data after importing. Thanks.
Excellent content. I stumbled upon your channel and subscribes immediately! Question: Wouldn't it be easier to select (double click) the Sales database to make the query shorter and simpler to write (and read)?
Hi! please help me ..I'm working on 32 bit system and your db_dump is not importing in my sql workbench ..I have tried alot. If you are able to help me it will be great.
The way you teach is 8too helpful and appreciable NO DOUBT , As o now I'm working on this prject yes now i know very late but morning when you wake up , so I'm preparing for the same but I'm unable to download the PDF for the same in which sql queries are mention , data is mentioned . kindly suggest I'm pause in the 3 video i'm unable to find the pdf of projects @codebasics
Hello sir!! I want to tell you one thing that you are writing sales. (something) in the codes. But if you write "use sales" in the first line then you don't need to write sales. (something) everytime. So it will be easy to understand. Thank you!!
Hi there if anyone facing the connection issue then first try to download the sql connector in your laptop and install it(you can find the video about it in the youtube). After that just restart your laptop once. Then give it a try in powerbi by giving the hostname first, if it shows the credential error then connect with the username mostly named as root and give your password then click on connect . Dont forget to restart your laptop after installing the sql connector. i faced the same issue after restarting the laptop it worked for me. If anyone downloading the dump file better download the sql dump 1 and dump 2 it is the updated file or else you'll end up in a mess at the last video.Hope it helps.✌
Hello, I know SQL but I never use MySQL I have MS SQL SERVER on my computer and Management Studio. Is it possible to import this data into the management studio and query on it? Thank you for the videos by the way
The sequel of this playlist is available in form of a video course here codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project If you like this playlist you would absolutely love the course as it is 50X better in terms of quality and content. The course name is Get Job Ready: Power BI Data Analytics For All Levels
@codebasics I'm not able to download this file as shown in this video, can you please help?
hey dhaval, i also couldnt download this playlist..
sir I'm not able to download this file as shown in this video, can you please help?
@codebasics i am unable to import sql data file into SQL and PowerBI can please help me
Operation failed with exitcode 1
Import of D:\DATA ANALYST\MYSQL\db_dump_version_2.sql has finished with 1 errors
HOW TO FIX THIS ERROR @codebasics
I did this project in May-2021 and now I work as a Power BI developer. Thank you so much to Dhaval sir and Hemanand sir for creating this project. Just revisited this series and wanted to convey this!
Hey Raghavan can you help me in connecting data from MySql Database into PowerBI as i am new to this and i just could not find a way to connect data and continously there is some error
"Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Can you help me with that
@@syedasherahmed949 this video is using 'MySQL' not SQL Server ('T-SQL'). They are two different 'flavors' of SQL. The MySQL code will not run on a MS Server platform. Perhaps this is the issue? (I have never personally experienced any errors connecting Power BI to an SQL Server database)
Hey there is an issue in the dumb file link can you help me by providing that file.actually the file is not downloading
Hi raghavan can you please share me dump files
It's not downloading
@raghavan did you use this project in your resume?
No online courses or university teachers can teach as good as a passionate youtuber . great work as always sir!
Why did I come across your channel so late? However, better late than never. thank you so much. You are a great mentor. Early career data professionals are blessed with such great value content. You're a real mentor and keep doing the god's work. Thank you!
00:00 Learn SQL for data analysis
02:20 Download and import the SQL file to create the entire database
05:02 Overview of tables in a relational database
07:08 Data cleaning is a major challenge for data analysts
09:31 SQL can help with data analysis
12:00 Joining date table with transaction table
15:23 Get total revenue for 2020 and Chennai
01:34 Learn SQL for data analysis
Crafted by Merlin AI.
I am preparing for the interview and landed on the right channel. Thank you for your efforts and God bless you, Sir, God Bless you!!
file is not showing
@@cathome7314 it worked for me, follow readme instructions.
watching from Texas, US. Currently preparing for internship
Thank you for this series, it is extremely helpful and fantastic. Please consider posting a double bill next
We are Really Thankful to your time to Teaching us about Power BI and other Data Related Videos
I am happy this was helpful to you.
Excited to finally learn how to apply SQL to a real data science project. Thank you @codebasics !
I m new to SQL but u made it clear so simply that I can am sure that I can do it confidently.
glad u liked it haroon
hello can you help with connecting. The file in the video and the dumb file is different
Thank you sir fist time in my life executing sql queries.
luv u dear ,
1st i ignored your sql video
by now .... no words
Ek number video
a high fi from myside .........
Very informative and nice video, things explained in very easy way.....waiting for next videos on this series....thanks a ton
It was a very informative video finally getting some clarification on how a data analyst would work from extracting the data and doing analysis thanks for this helpful project 👍🙂
hey, rahish didn't u have problem in downloading datasets? I am having an error while downloading
@@kabita1536 well I didn't faced any error while downloading the datasets just follow the instructions to download from the video
@@rahishillustration9332 yes i am following the instructions but still getting error
Sir, there is an issue with the SQL file could please update the file?
Sir to get the transactions from particular year you can just use the order_date column(no need to use other date, year table). The query would be SELECT * FROM sales.transactions where year(transactions.order_date) = '2017';
Great🙏🙏
Great🙏🙏
That helped.Thanks:)
3:30 import file content
6:55 why data cleaning is vital step?
7:55 - 18:55 creating queries
You are a legend, thanks for all the selfless efforts you have been making in make us understand the concepts of data analysis.
I am happy this was helpful to you.
How to create these tables?
@@codebasics sir please provide dumped files GitHub files are not downloading
Please share
Thank you so much sir ,for creating such a beautiful series on data analysis which is easy to understand.No other youtube channel or online course will give such in-depth content.Thank you once again for putting so much effort in it.
If you have dumped files download please provide these are not downloading through github
Very informatics ..please share more video on real time project.
you are giving the best content here, keep going
Great Video and Tutorials on Data Analysis Following from starting..Big Thumbs for Content and Creation.
Looking forward for more projects using Power BI. it was great video sir. thankyou
Highly appreaciate your commitment and level of understanding👍😊great
Thanks sir for d series it's really helpful for beginners also n for those who wish to transition from others profile.really helpful n straight to knowledge no non sense.only qaulity minutes!!!
This 20 min video took me almost 1 hour to get familiar with the insights that we are getting
Thank you very much for posting these videos, really helpful for people who want to get into Data Analysis
thank you so much sir, you deserve my respect. from indonesiaa
Hello Sir. I really admire your teaching method and I have learned a lot from your videos. Thanks and keep educating us with your videos
Started the series on this Sunday and its quite interesting. Thanks for the content and would finish this playlist and practice it along with you.
Great. I am happy you are liking this
In simple words - " You are awesome".
I can't download the set from GitHub, could you share with me
(Sayar) is the name of Teacher in Burmese
So, Sayar you is the best.
Your videos are all amazing sir.. God bless you...
I am happy this was helpful to you.
Yes , All of the instructions are super useful
Thank you so much! You give a real case from the beginning to the end, and linkage between SQL and PowerBi, which gives a whole picture for data analyzing process.
you really cleaned my lots of confusion thank you
Thank sir for this amazing series . I got to learn so many things from these tutorials.
Thank you for this series.we will get to learn more details from this realtime database.
your videos are always informative and helpful... Thank you once again.
Thank you very much sir your videods are so informative , clean, well organized and superbly accurate in instructions like where a file is paced inside github repo ... thanks for so much efforts guides us a lot
thank you so much sir for this course
big thanks for your efforts. thankyouuu so much
Great work Sir ! Awesome Tutorial.
I can't download this data set from here , could you share with me
Amzong video sir 👍👍👍
Thank you so much 😊 greetings from spain
Very good video , so much informative and easy to understand.
You are 'THE BEST'.
It is a great video sir. Thanks a lot for sharing this wonderful content
Hello, I'm having challenges importing my database. it's bringing error, how did you do yours?
Hello Sir, If possible try to do more projects on data analysis work.
Please share dump files if you have these are not downloading
you are doing great service sir thank you, I learning BI now, I just wish to ask you that have ever made any project on deep learning on neural networks, if you have any plan in future, please let us know
Hi sir,thanks a lot for sharing your knowledge with us,can you just let us know how did you create your db_dump file?Or more precisely how can we convert a csv file into a db_dump file?
SIr I am heaving some issue to import the data in sql may i consult with you how can i clear my doubt pls could you suggest me ?
I am getting this error when I am clicking on star import
Query:
CREATE DATABASE IF NOT EXISTS `sales` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
Error occured at:2020-06-30 22:31:02
Line no.:1
Error Code: 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
The sql file given in source data doesn't contain sales database rather it shows sakila db with tables such as actor, address, category etc. Can someone help me to get the same dataset used here?
I am facing the same problem
I tried downloading with the link (in description) and the github link shown in the video
Both time same issue
If you found some solution please share..
Amazing sir🥳🥳🥳
Sir unable to connect power bi with my sql can you please help me out, which version of mysql to be used now, and my sql connector too
I am not able to restore sql file into postgresql. please someone can help me?
Hello, I don't see a link to your Github can you please assist..Thank you very much
Great Teaching as always !!!!
thankyou for sharing your knowledge
Really appreciate it,I have resolved the error mentioned previously.
Can you guide how were you able to do it ?
It's really helpful.
great work sir
08/12: When I import the given dump in MySQL, I can see this dump has different data than you used.
08/17: My problem is solved today, I watched this video again, I was missing to refresh data after importing. Thanks.
simple yet so descriptive, thsnks a lot
Bhai i tried downloading dump from the new link and github link ….after import data n tables are different from those shown in the video . What to do?
I'm very much grateful that I found this channel :)
I tried to run the .sql file in Postgre but it gives error something relating to binary .. etc. However, i am able to load the data base in MYSQL.
Eagerly waiting for one more data analysis project in a similar style using a bit of PYTHON, SQL, and tableau/bi...
Excellent content. I stumbled upon your channel and subscribes immediately!
Question: Wouldn't it be easier to select (double click) the Sales database to make the query shorter and simpler to write (and read)?
how did you ge the data, i cannot seem to download the file as it says file is too big to download
@@irshaadmohammed9024 I'm facing the same problem
Thank you so much for making this video
good job my friend
Very nice
Hi!
please help me ..I'm working on 32 bit system and your db_dump is not importing in my sql workbench ..I have tried alot.
If you are able to help me it will be great.
The way you teach is 8too helpful and appreciable NO DOUBT , As o now I'm working on this prject yes now i know very late but morning when you wake up , so I'm preparing for the same but I'm unable to download the PDF for the same in which sql queries are mention , data is mentioned .
kindly suggest I'm pause in the 3 video i'm unable to find the pdf of projects
@codebasics
Hello sir!!
I want to tell you one thing that you are writing sales. (something) in the codes. But if you write "use sales" in the first line then you don't need to write sales. (something) everytime.
So it will be easy to understand.
Thank you!!
Have you dumped files these are not downloading please give me if you have
i got error. ERROR 1273 (HY000) at line 1: Unknown collation: 'utf8_0900_ai_ci'. how can i fix it
I am not able to download the database
Amazing video bro
Excellent
Thanks for the video sir, Keep up the good work :)
Great work
I have MS SQL installed already. Is there any way I can use the dump mentioned in the description. Please clarify.
sir there is an error showing import completed with 1 error
how to fix that
I just opened the dump.sql file in Notepad++ and
hit CTRL+H to find and replace the string
"utf8mb4_0900_ai_ci" and replace with "utf8mb4_general_ci"
Thnaks a ton for your efforts for ua
Can I add this project to my resume?
👍 yes definitely
Hi there if anyone facing the connection issue then first try to download the sql connector in your laptop and install it(you can find the video about it in the youtube). After that just restart your laptop once. Then give it a try in powerbi by giving the hostname first, if it shows the credential error then connect with the username mostly named as root and give your password then click on connect . Dont forget to restart your laptop after installing the sql connector. i faced the same issue after restarting the laptop it worked for me.
If anyone downloading the dump file better download the sql dump 1 and dump 2 it is the updated file or else you'll end up in a mess at the last video.Hope it helps.✌
very much help ful thanks Sir
Glad it was helpful!
Hello,
I know SQL but I never use MySQL
I have MS SQL SERVER on my computer and Management Studio. Is it possible to import this data into the management studio and query on it?
Thank you for the videos by the way
Hi, Do you have any solution regarding MSSQL server?
Thanks for the video sir...
Cool... I want to learn
Thank you very much sir❤
sir, db_dump is not downloading...why?
excellent.....
thankyou so much for video
Brilliant. 😎
How about creating relationships directly in power Bi instead of doing that SQL thing to join column!?🤔
Thank you so much 😊🙏
Amazing video!!!
Unable to download sql dumb data from gitub.could you provide so i can practice please.
is your issue resolved, if yes than please suggest me how can i download this file
sir could you please upload file in excel csv form, because its getting hard to insert 1000 rows. please provide file in excel csv form