Official Website: https://virtual-school.org/
Forums: https://virtual-school.org/forums/
SQL Server for Practice (Adventure Works Database): https://virtual-school.org/post?t=118
SQL Server for Practice (Star Corps Database): https://virtual-school.org/post?t=117
MySQL Server for Practice (Star Bakery Database): https://virtual-school.org/post?t=116
Welcome to our Looker Studio tutorial!
In this tutorial, we'll guide you through the process of setting up a XAMPP server, connecting MySQL to Workbench, creating tables and entering data, connecting MySQL to Looker Studio, and hosting Looker Studio reports on your XAMPP server's web page.
Download Workbench:Get started by downloading Workbench here.
Follow the installation instructions to set it up on your computer.
Install XAMPP:For MySQL, we recommend using XAMPP, an open-source alternative.
Download XAMPP here.
Install it on your C drive (not in program files) and wait for the setup to complete.
Configure MySQL Server:Access MySQL through Workbench and set up a new user for remote access using the provided query.
Adjust Server Ports in XAMPP:Change default ports in XAMPP Control Panel to enhance security.
Configure web server port to 8080 and MySQL server port to 8081.
Stop and restart the servers for changes to take effect.
Open Ports in Firewall:Open inbound and outbound rules for the configured ports in your firewall settings.
Port Forwarding in Router:Log into your router admin page and set up port forwarding for public access.
Configure phpMyAdmin and SQL Server:Update configurations in phpMyAdmin and SQL Server to reflect the new port settings.
Create and Enter Data in MySQL:Use Workbench to create a table in the test schema.
Enter data and confirm the setup.
Connect Looker Studio to MySQL:In Looker Studio, create a new data source.
Select MySQL Connector by Google and enter your public IP address, port, schema, and login details.
Build a Report in Looker Studio:Create visuals using charts and graphs to represent your data.
Customize the report and embed it for easy sharing.
Host Looker Studio Report on XAMPP Web Page:Copy the HTML code provided by Looker Studio.
Open the XAMPP index.html file, paste the code, and save the file.
Access your report through the web page using your public IP address.
Conclusion:Congratulations! You've successfully set up a XAMPP server, connected MySQL to Looker Studio, and hosted reports on your local web page.
Thank you for watching our tutorial! If you found it helpful, don't forget to like, subscribe, and hit the bell icon for more insightful tutorials and updates.
#LookerStudio #XAMPPServer #MySQLTutorial #DataVisualization #WebDevelopment #DatabaseManagement #Tutorial #TechGuide #DataAnalytics #WebHosting #SQLServer #PHPMyAdmin #PortForwarding #Workbench #DataScience #OpenSource #Programming #WebServer #EmbedReports #TechHowTo #ServerConfiguration #DataReporting #HTML #CodingTips #SoftwareDevelopment #DigitalTransformation #TutorialVideo #TechLearning