Let’s explore connectivity of Power BI with MySQL Database.
Open Power BI and click on Get Data > More Options:
Select My SQL Database and connect to database:
Load MySQL Database table:
Select table and click on Load button:
Payment table is loaded into Power BI.
Load more tables from same Database:
Create Relationship between sakila_customer and sakila _ payment tables on the basis of identical field customer_id:
Create visualization from two tables:
This visualization is giving details about payment of different actors on the basis of first name and last update.
Create new visualization with same details:
Now we will create a Waterfall chart for increase and decrease in payment amount according to count of customer id and first name of actors:
Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business.
We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares being rebuilt with Artificial Intelligence Capabilities .
We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return .
Whatsapp at +91-9953805788 or email at - email@example.com if you would like to know more .