LOADING

Type to search

Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database

Share

Let’s explore connectivity of Power BI with MySQL Database.

MySQL Database:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 29

Open Power BI and click on Get Data > More Options:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 30

Select My SQL Database and connect to database:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 31

Load MySQL Database table:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 32

Select table and click on Load button:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 33

Payment table is loaded into Power BI.

Load more tables from same Database:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 34

Create Relationship between sakila_customer and sakila _ payment tables on the basis of identical field customer_id:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 35

 

Create visualization from two tables:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 36

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:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 37

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:

Connecting Microsoft PowerBI to MySql Database - Working on Sakila Database 38

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *