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.
Your are one of the few channels that bring this amount of value. Please keep posting this kind of series, its helped me a lot in a project! Thank you so much!
@@codebasics First i would like to thank you for making this project. And then Kindly make me clear the same thing we can do by using Python Pandas too right?? and if posible could you states the difference between please. Thanks
@@codebasics While connecting Power BI with MySQL data This error is comming: This connector requires one or more additional components to be installed before it can be used. I have try everything to solve the error but the error is not going Please help
I think you forgot to remove duplicates from the Data (USD and INR the ones with special characters) It is always a good practice to remove duplicates at the begining while cleaning the data. Your videos are very helpful and valuable. Thank you very much for your time.
Hello everyone i just started this amazing series and everyone who has recently started will get an error while connecting to my sql server from power bi as one or more connector required.....i researched and found out that the problem is with the connector versions....just install previous connector version for my sql and it should work...i installed 8.0.24 and it is now working fine....thanks sir dhaval patel for providing such informative content for free .cheeers
I still have issues. I could not complete mySQL installation. The product configuration stage is having an error and in the next stage i need to provide the root password. But the password is not even created during this installation. It seems due to the previous installations. Can anybody help?
DUDE! Just discovered your channel a couple of weeks ago. You are 1 of 2 of my favorite YT channels right now! Such a great job. Great teacher. I am enjoying this series right now. I love how you bring your actual business experience into it to give it context. KEEP IT UP, PLEASE!
i am currently doing internship at infosys. this is the exact playlist that a student must look at. thanks for your efforts to bring quality content on yutube.
Glad you liked it. You will be glad to know I am launching a sequel of this series, a paid course with lot of practical learning, fun and almost like a virtual internship experience. I will be launching this in May, this year (2022). Stay tuned, will announce on my channel soon
Tell Me one thing if we can do most of the things like data cleaning, data preparation, creating different charts with the help of power bi . So why we need Pandas, Numpy, Matplotlib All these Libraries to create all these things.
We can use samsung phone for making phone calls, watsapp etc then why do we need iphone, xiomi or mi phones? Power BI, Tableau, Pandas/Python/Matplotlib serve similar purpose but every tool has its own plus and minus (just like phones example above)
Reasons from my point of view and as per my knowledge: 1. Tons of functions in pandas for in depth data mining, data format conversion, compared to power BI 2. Python is cheaper compared to Power BI 3. Python has more visualizations than Power BI 4. Numpy makes processing faster with numbers Finally python is like squeeze and squash but Power BI is kinda concrete.
Clear and well explained! Best lecture I've watched on MySQL and Power BI. There are links on the comments section on how to clone the repository but got help from Mr. Google for the importation of data from a different MySQL version. Will need to learn power BI syntax before proceeding to the next video!
Thanks for your kind words Jo and most importantly your self effort. Many times people ask my obvious questions such as how to clone git repo etc and I just don't have time to respond to all. I love your attitude of putting effort to get things done.
I am so grateful for this tutorial. You have explained everything so well. I should have started with this tutorial instead of doing others. Great stuff.
Sir the values you converted to INR was related to the conversion rate of 2020 but the data column depicts the year 2017.. I think we should use the conversion rate of 2017 to for accurate calculation
Hey codebasics I missed two of the videos series but I will watch it offline before your next live stream, thanks for your time. You are a good teacher, keep it up.
I know am late to this... But I have recently learned power bi... But this video brings the best value to it... Very clear in explaining as it is like real time scenarios.. Appreciate it sir
If anyone get error like "this connector requires one or more additional components to be installed" while connecting to Mysql database then you need to install the connector... but the catch is if you go for the latest version you found yourself stuck with the same error(in majority of cases it happens) ....so to overcome it go for 8.0.32 version, it will work effortlessly and do reopen your powerBI or in some cases refresh your system.... Hope i am clear with the solution.. Thank you
thank you i just finished the project i have a question how this kind of garbage data get inside the tables like negative amount sales is it a software development issue because if the software is well written it should not allowed this kind of negative number to be in the first place i well developed software help reducing the cleaning process
For those who are getting "this connector requires on or more additional components to be installed before it can usef" Just get the 8.0.28 connector 😅❤ Thanks 👍
sir your playlist is really helpful for learners. I started powerbi with you sales project. but in part 04 facing issue to get data from mysql to powerbi. its showing ..'character not supported by .net while connecting to Mysql in powerbi. please help!!
I think there is extra character might be white space in Currency column i.e USD and INR so removing duplicates and using trim funtion will solve that issue.
Hello sir, your videos are greatly helpful. I am learning Data Analysis as a beginner, and I have a mac. Can you please suggest some alternative to Power BI as it is not available? Thank you
YOU ARE AMAZING TEACHER. I learnt alot from you. but can you please tell why you did not remove duplicate data in the starting? the reason for these two INR and USD is because the data is duplicate
I couldn't follow along this tutorial. First I encountered problems with connecting to MySQL, and when I resolved that, I have authentication problems "we couldnt authenticate with the credential provided". The solutions I found in the internet were hard to understand. : (
PowerBI desktop application is not MAC OS supportive. While for tableau there is a requirement to install Tableau prep builder and Tableau Desktop application. Could you suggest an alternative so that it is easier to follow the tutorial ??
It is the best video to watch after dinner :p. Just one thing to ask about. In the transaction table, they seems to be duplicate records, shouldn't we remove them?
Sir i want to ask one question that...is certification is necessary for data analyst or data scientist career...??? Without certificate it is tough to get these positions...????
Nothing can stop you if you have good amount of knowledge even withoutout certificate.just do some practice and projects on data analysis.dont go into the trap of certification.good luck.
thank you for the tutorial, im wondering how PowerQuery stands next to well known ELT tools like Oracle ODI or infomratica or so, is it recommended to use PQ or ETL specialized tools?
hello sir, in last you are trying to solve issue of two USD in currency, hence it is duplicate can we remove it? same goes with INR ,some of them is also two times , so there are also duplicate values. can you please explain it? thank you
Thanks for sharing these tutorial its very helpful, i'm facing issue with connecting Mysql database with powerbi, have already downloaded the latest version of mysql server..but when connecting with powerbi it shown "this connector requires one or more additional component to be installed before it can be used"...kindly help me on sorting this...
I'm facing this error "Details: "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)"
Any sources to find a similar kind of data for building dashboards. So that it won't be a copy-paste of work. Would like to apply the same on some other data set. Would appreciate your quick response
00:05 Data cleaning and ETL is needed for data analysis in Power BI. 02:43 Connect to MySQL database in Power BI and load the tables 05:48 Establishing relationships between tables based on matching fields 08:40 Data modeling and establishing relationships between tables are important for data analysis and engineering roles. 11:10 Performing data cleaning and ETL process. 13:51 Creating a new column to convert sales amount into INR 16:34 Data transformation using ETL 19:10 Data cleaning and ETL process explained. Crafted by Merlin AI.
Hi sir,Big thanks for such great materials and teaching.I am stuck at one place while trying to connect to my sql data base from power bi ,it shows this connector requires one or more additional components to be installed before it can be used,even though i have installed MY sql sucessfully.What should i do? please help
at 12:03 couldn't there be a reason that some transactions were entered with zero price? like giving products for free as an offer or for promotion or for whatever reason. Is it okay to ignore such records in real scenarios? how such data can even be trusted if it contains invalid rows? This question always comes to my mind when it comes to data cleaning.. Please enlighten me. And thank you so much for the tutorials
Initially, I encountered an issue with the installation of the MySQL connector, which I managed to resolve. However, upon attempting to establish the connection, I am now facing an "SSPI error" that persists despite my attempts to troubleshoot the problem. I have explored several troubleshooting steps, including changing the MySQL password and verifying the ODBC configuration. However, none of these attempts have yielded a successful resolution. As I am eager to move forward with my sales insight project, I would greatly appreciate any assistance or suggestions you can provide to help resolve this issue. If there are alternative authentication methods, server configurations, or any other recommendations you can offer, I am open to exploring them.
Bro I'm not able to connect MySQL to power bi it is asking for windows credentials or database credentials and I don't know from where to get them I don't remember those passwords please help me
There are 2 duplicate records at 20:07 hence the reason of untransformed USD values. There is no need of adding further transformation layer of code at 20:20 to accommodate these duplicate records rather dropping them from the main dataset will fix the problem. In summary a good tutorial for the beginners, well done!
Hi Sir, I m getting error while getting data into Power BI from MYSQL server. Have followed same steps as u mentioned. Have given server as localhost and database name as sales, getting error as -- MYSQL: Retrieve of the RSA public key is not enabled for insecure connections. Please help me to resolve this issue.
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.
Your link to download the resource isn't working.
Can you please provide CSV files for all the tables.
Please share the csv file
Your are one of the few channels that bring this amount of value. Please keep posting this kind of series, its helped me a lot in a project! Thank you so much!
yes couple of more project series are coming up soon. I am working on tableau series at the moment.
@@codebasics First i would like to thank you for making this project. And then Kindly make me clear the same thing we can do by using Python Pandas too right?? and if posible could you states the difference between please. Thanks
How to convert CSV or excel files to SQL files for uploading into MySQL?
@@codebasics
While connecting Power BI with MySQL data
This error is comming:
This connector requires one or more additional components to be installed before it can be used.
I have try everything to solve the error but the error is not going
Please help
I think you forgot to remove duplicates from the Data (USD and INR the ones with special characters)
It is always a good practice to remove duplicates at the begining while cleaning the data.
Your videos are very helpful and valuable.
Thank you very much for your time.
you have noticed it, thank you for that.
Hello everyone i just started this amazing series and everyone who has recently started will get an error while connecting to my sql server from power bi as one or more connector required.....i researched and found out that the problem is with the connector versions....just install previous connector version for my sql and it should work...i installed 8.0.24 and it is now working fine....thanks sir dhaval patel for providing such informative content for free .cheeers
Thanks man. I had the same issue. But i choose same version 8.0.24 and it is working
Hey! I have installed 8.0.24, still facing the same issue. Any idea on this?
I still have issues. I could not complete mySQL installation. The product configuration stage is having an error and in the next stage i need to provide the root password. But the password is not even created during this installation. It seems due to the previous installations. Can anybody help?
@@laavanyachandru650 try with 8.0.28 one
2:15 importing to PowerBI
3:55 Power query
5:15 data modeling
The best, Honest, Authentic person in tech era...
DUDE! Just discovered your channel a couple of weeks ago. You are 1 of 2 of my favorite YT channels right now! Such a great job. Great teacher. I am enjoying this series right now. I love how you bring your actual business experience into it to give it context. KEEP IT UP, PLEASE!
which is the other favorite channel ?
@@syedkamran4121 reminder Todd.
The data cleaning process which you teaching here are excellent and step by step. It's understandable easily. Thanks a lot Dhaval sir for this series.
Glad it was helpful!
Wow. I just discovered this channel yesterday and i couldnt be happier bro. Thank you so much for doing this
The way u put it simply is the best way one can teach.
this series is a pure gem👍 following this series as my first data analyst practice project. Thank you so much for such a great explanation👌!!!
Thanks Yash, I am doing same series in tableau now. It will be uploaded in next few weeks.
Put ads in I want you make money. Just keep on adding value to your videos. Benefiting from them right now. Thank you.
I've Started learning @ 12/04/2021
nice progress as started with the project directly
Hi, Iam facing prblem in connector can u please help
If I've an option to like each video in this playlist 10 times, I'd surely do it. Such a clear and concise explanation sir. My sincere thanks!
10 id bana lo
your chanel is my first channel that i refer to for learning data science ,greaaaaaaat job thank u sooo much
Thank you soo much for making it Ad free ❤️
Best teacher with a high value of information
Its such a good startup video for those who are getting handson for the first time❤❤❤❤❤
Really feeling gr8 after doing so as u told in this video series till now
I am happy this was helpful to you.
i am currently doing internship at infosys. this is the exact playlist that a student must look at. thanks for your efforts to bring quality content on yutube.
Glad you liked it. You will be glad to know I am launching a sequel of this series, a paid course with lot of practical learning, fun and almost like a virtual internship experience. I will be launching this in May, this year (2022). Stay tuned, will announce on my channel soon
Very helpful video!! One thing i want to ask that isn't it necessary to have a primary key in transaction table? If not then why?
Finally I succeed to connect Power BI with SQL database. Thanks
How ?
how
HOW ? after installing the new mySQl connector then also i am not able to connect the SQLdatabase with power BI
how did you manage to do it? I m unable to fix the error
Tell Me one thing if we can do most of the things like data cleaning, data preparation, creating different charts with the help of power bi . So why we need Pandas, Numpy, Matplotlib All these Libraries to create all these things.
We can use samsung phone for making phone calls, watsapp etc then why do we need iphone, xiomi or mi phones?
Power BI, Tableau, Pandas/Python/Matplotlib serve similar purpose but every tool has its own plus and minus (just like phones example above)
Reasons from my point of view and as per my knowledge:
1. Tons of functions in pandas for in depth data mining, data format conversion, compared to power BI
2. Python is cheaper compared to Power BI
3. Python has more visualizations than Power BI
4. Numpy makes processing faster with numbers
Finally python is like squeeze and squash but Power BI is kinda concrete.
Clear and well explained! Best lecture I've watched on MySQL and Power BI. There are links on the comments section on how to clone the repository but got help from Mr. Google for the importation of data from a different MySQL version. Will need to learn power BI syntax before proceeding to the next video!
Thanks for your kind words Jo and most importantly your self effort. Many times people ask my obvious questions such as how to clone git repo etc and I just don't have time to respond to all. I love your attitude of putting effort to get things done.
I am so grateful for this tutorial. You have explained everything so well. I should have started with this tutorial instead of doing others. Great stuff.
Sir the values you converted to INR was related to the conversion rate of 2020 but the data column depicts the year 2017.. I think we should use the conversion rate of 2017 to for accurate calculation
Unable to connect with database, requires additional connection what to do please help ?
anybody who's facing connection issues with mysql.. Install everything with v8.0.32. It worked for me!
Hey codebasics I missed two of the videos series but I will watch it offline before your next live stream, thanks for your time. You are a good teacher, keep it up.
I know am late to this... But I have recently learned power bi... But this video brings the best value to it... Very clear in explaining as it is like real time scenarios.. Appreciate it sir
You're awesome, thank for all this knowledge you're sharing
May you prosper always
Instead of creating a custom column, we can also use a trigger in MySQL workbench to convert USD to INR, and change value from sales_amount column
Thank you so much sir. Your explanations are easy to grasp and this playlist helped me a lot.
If anyone get error like "this connector requires one or more additional components to be installed" while connecting to Mysql database then you need to install the connector...
but the catch is if you go for the latest version you found yourself stuck with the same error(in majority of cases it happens) ....so to overcome it go for 8.0.32 version, it will work effortlessly and do reopen your powerBI or in some cases refresh your system....
Hope i am clear with the solution..
Thank you
Thank you. It worked
Thank you so much sir, this course is what I need.
thank you i just finished the project i have a question how this kind of garbage data get inside the tables like negative amount sales
is it a software development issue because if the software is well written it should not allowed this kind of negative number to be in the first place
i well developed software help reducing the cleaning process
i swear i love this project
Thank you sincerely! The entire series is a useful step by step guide. Subscribed!
Glad it was helpful!
since we converted the data to inr so in the currency column the rows where the currency is mentioned as usd should we change it to inr?
Very clear and excellent video to learn power bi query
Glad you liked it
20.48 ; why we are having such USD repetition, they both are representing same values?
sir, at the final transformed data why all the INR values are shown as 102 INR?
Explanation was very clear. Thank You Sir. If u could share the data source would be very helpful
For those who are getting "this connector requires on or more additional components to be installed before it can usef"
Just get the 8.0.28 connector 😅❤
Thanks 👍
With the power BI desktop (x64) i installed 8.0.28 and the latest but none of them work for me. Any suggestion pls
@@sabrinalucky4130 you've to apply try and error method
Just install all the versions and check 🥲
@@Nobody_does_it_better_23 which worked for u?
can u pls tell
sir your playlist is really helpful for learners. I started powerbi with you sales project. but in part 04 facing issue to get data from mysql to powerbi. its showing ..'character not supported by .net while connecting to Mysql in powerbi. please help!!
I think there is extra character might be white space in Currency column i.e USD and INR so removing duplicates and using trim funtion will solve that issue.
Amazing work brother, May Ganesh shower more success and progress to you. Keep educating people with your amazing skills and god bless you.
Hello sir, your videos are greatly helpful. I am learning Data Analysis as a beginner, and I have a mac. Can you please suggest some alternative to Power BI as it is not available? Thank you
Great Video sir , Thanks , Love the series till now
really good case study
when you have done the currency conversion then you should also update the currency from USD to INR.
YOU ARE AMAZING TEACHER. I learnt alot from you. but can you please tell why you did not remove duplicate data in the starting? the reason for these two INR and USD is because the data is duplicate
can we do all the data cleaning with pandas and then save it as a csv and then we use the csv file in power bi to build the dashboards?
yes you can
I couldn't follow along this tutorial. First I encountered problems with connecting to MySQL, and when I resolved that, I have authentication problems "we couldnt authenticate with the credential provided". The solutions I found in the internet were hard to understand. : (
Great Lecture series sir, I request u to if u have a time then plz Add other Project Series also on "Object Detection".
Great video!! I follow one by one, play and pause a lot! May you be showered by prosperities and happiness sir!
I am happy this was helpful to you.
PowerBI desktop application is not MAC OS supportive. While for tableau there is a requirement to install Tableau prep builder and Tableau Desktop application. Could you suggest an alternative so that it is easier to follow the tutorial ??
It is the best video to watch after dinner :p. Just one thing to ask about. In the transaction table, they seems to be duplicate records, shouldn't we remove them?
like by the formula: Table.SelectRows(#"Added Conditional Column", each ([currency] = "INR#(cr)" or [currency] = "USD#(cr)"))
yes. good point, I am planning to cover these in next video. But I agree we should remove them
@@codebasics Interesting video!!! Will we have it tonight?
Can't wait for that
Sir i want to ask one question that...is certification is necessary for data analyst or data scientist career...??? Without certificate it is tough to get these positions...????
Nothing can stop you if you have good amount of knowledge even withoutout certificate.just do some practice and projects on data analysis.dont go into the trap of certification.good luck.
Can I make the same project and showcase as portfolio on freelancing website?
thank you for the tutorial, im wondering how PowerQuery stands next to well known ELT tools like Oracle ODI or infomratica or so, is it recommended to use PQ or ETL specialized tools?
hello sir, in last you are trying to solve issue of two USD in currency, hence it is duplicate can we remove it?
same goes with INR ,some of them is also two times , so there are also duplicate values.
can you please explain it? thank you
For extra space in INR and USD better remove the extra space by Transform -> Format -> Clean
thankyou
Hi, shouldn't the USD to INR conversion be based on the order_date?
Thanks for sharing these tutorial its very helpful, i'm facing issue with connecting Mysql database with powerbi, have already downloaded the latest version of mysql server..but when connecting with powerbi it shown "this connector requires one or more additional component to be installed before it can be used"...kindly help me on sorting this...
Try using older version of the connector and delete previous connector
I'm facing this error "Details: "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)"
Any sources to find a similar kind of data for building dashboards. So that it won't be a copy-paste of work. Would like to apply the same on some other data set. Would appreciate your quick response
Thank you for your effort sir
Thank you for sharing!
were the USD rows duplicaed at 20:40?
can we put this project on our LinkedIn, Github profile etc?
00:05 Data cleaning and ETL is needed for data analysis in Power BI.
02:43 Connect to MySQL database in Power BI and load the tables
05:48 Establishing relationships between tables based on matching fields
08:40 Data modeling and establishing relationships between tables are important for data analysis and engineering roles.
11:10 Performing data cleaning and ETL process.
13:51 Creating a new column to convert sales amount into INR
16:34 Data transformation using ETL
19:10 Data cleaning and ETL process explained.
Crafted by Merlin AI.
This project playlist is the best thing I've come across. Thank you sir.
Glad it was helpful!
your explanation is damn good sir
after loading the data in the PBI desktop, why did the original values of sales_amount and norm_sales amount changes?
What should I do I have mac
Hi sir,Big thanks for such great materials and teaching.I am stuck at one place while trying to connect to my sql data base from power bi ,it shows this connector requires one or more additional components to be installed before it can be used,even though i have installed MY sql sucessfully.What should i do? please help
Im also facing the same issue can plz anyone help me
@@abdulraziqbarkatali8493 bc sab yehi issue face karre hain
at 12:03 couldn't there be a reason that some transactions were entered with zero price? like giving products for free as an offer or for promotion or for whatever reason. Is it okay to ignore such records in real scenarios? how such data can even be trusted if it contains invalid rows? This question always comes to my mind when it comes to data cleaning.. Please enlighten me. And thank you so much for the tutorials
it depends tbh. the best way to tackle this is to know the process of the company you're performing the analysis for
The second USD category is actually duplicate records from first USD category ... You could just use filter
Thank you for your suggestions.
This is very helpful information.. Thank you!!!
Glad it was helpful!
Thanks a lot... 🙏 It's really helpful...
Watching ur videos with hitting like and sharing is a crime..
Initially, I encountered an issue with the installation of the MySQL connector, which I managed to resolve. However, upon attempting to establish the connection, I am now facing an "SSPI error" that persists despite my attempts to troubleshoot the problem.
I have explored several troubleshooting steps, including changing the MySQL password and verifying the ODBC configuration. However, none of these attempts have yielded a successful resolution.
As I am eager to move forward with my sales insight project, I would greatly appreciate any assistance or suggestions you can provide to help resolve this issue. If there are alternative authentication methods, server configurations, or any other recommendations you can offer, I am open to exploring them.
How did u resolved the problem of installing connectors ..??
@@soniapaul8639 use older version of the connectors
Bro I'm not able to connect MySQL to power bi it is asking for windows credentials or database credentials and I don't know from where to get them I don't remember those passwords please help me
@@shobhitdwivedi9044 u can uninstall and reinstall and then give a fresh password
i am unable to connect to my SQL server using hostname=localhost please suggest me a way to connect it
Sir really good class 👍👍👍 .expecting more vedios
Why is it showing 102 instead of the transformed value in the power Bi desktop, after closing and applying?
@codebasics
There are 2 duplicate records at 20:07 hence the reason of untransformed USD values. There is no need of adding further transformation layer of code at 20:20 to accommodate these duplicate records rather dropping them from the main dataset will fix the problem. In summary a good tutorial for the beginners, well done!
Using Trimming should be fine.
how to link the PowerBI to the database, through the ODBC, .NET connector, or what? Please help.
Sir is sql,python and Power Bi.
This three skill is good Enough for junior data analysis job? Thank you very much
Yes those 3 and microsoft excel should be enough.
We can use excel file to upload the data in powerBI why we are using mysql as a source...?
I'm unable to connect MySQL to Power BI; it says I need to install a connector; please assist.
Can we make it in tableau
Isn't the last two USD data were duplicates? the dates and everything were same! if it is not how do we remove the duplicate data?
Hi Sir, I m getting error while getting data into Power BI from MYSQL server. Have followed same steps as u mentioned. Have given server as localhost and database name as sales, getting error as -- MYSQL: Retrieve of the RSA public key is not enabled for insecure connections. Please help me to resolve this issue.
I'm facing this issue too, have you got any solution? please help me if you got solution for this.
did you gys found the Soluion?
How to connect with Mysql server while we are using powerBI app in a different system?
i was getting data from the MySQL database but the power bi says that the connector requires one or more components ,please share the solution if any
Thank you very much sir,for making such videos
Glad it was helpful!
Where can I get this data set sir?
Awesome & Just Love the way of your explanation !!!! Can Power BI work with live data , can it update when database is modified ?
yes it can work with live data