We have developed this platform for one of our client in Steel industry
business to analyze the sales data via visualization.
sales data via visualization.
The procedures we used for Client sales data visualization
Setup PowerBI Desktop
and MySQL Connector in
windows server.
Setup Power BI Online
account and pull the saved
PBIX configuration from
development instance.
Get Data : Through PowerBI
desktop,click get data then
click database option and
choose MySQL database.
Schedule regular data to
refresh and update the
report from the
PBIX file.
Create various PowerBI
Reports using selected
data inside the PowerBI
desktop.
Enter DB Info : Setup
database to authenticate
credentials.
Select Data : Select data
and create data model
as per requirement of
Management.
Setup Power BI Desktop
and MySQL Connector in
windows server.
Get Data : Through PowerBI
desktop,click get data then
click database option and
choose MySQL database.
Enter DB Info : Setup
database to authenticate
credentials.
Select Data : Select data
and create data model
as per requirement of
Management.
Create various Power BI
Reports using selected
data inside the PowerBI
desktop.
Setup Power BI Online
account and pull the saved
PBIX configuration from
development instance.
Schedule regular data to
refresh and update the
report from the
PBIX file.
Database
MySql
Connector
MySQL Connector
Data visualization
Power BI Web
Report Development:
Power BI Desktop
Cloud Platform:
Amazon Web Service
(AWS)
Cultivating Meaningful
Connections that can
Stand the Test of Time