Skip Navigation Links.
Collapse &#128194Topics📂Topics
Collapse 📁Uncategorized📁Uncategorized
📄Home...
Collapse 📁Power BI📁Power BI
📄Introduction to Power BI Deskt...
Collapse 📁Get Data📁Get Data
📄Introduction to the Get Data f...
📄Get Data from Files...
Collapse 📁Visuals📁Visuals
📄View any visual as table in Po...
Collapse 📁Practice Datasets📁Practice Datasets
📄Adventure Works (SQL Server)...
📄Star Corp (SQL Server)...
📄Star Bakery (MySQL Server)...
📄Other SQL Datasets...
📄Kaggle Datasets...
Collapse 📁HTML Tables📁HTML Tables
📄Daily Sales by Sales Persons 2...
Collapse 📁Power Query📁Power Query
📄Data Source Settings...
📄Using Power Query M language t...
Collapse 📁Data Analysis Expression (DAX)📁Data Analysis Expression (DAX)
📄Using DAX to create parent cat...
Collapse 📁Python📁Python
Collapse 📁Python for Excel📁Python for Excel
📄Random Values in MS Excel and ...
📄Introduction to Python for Exc...
📄Seasonal Autoregressive Integr...
📄Fill missing values in MS Exce...
Collapse 📁Machine Learning (AI/ML)📁Machine Learning (AI/ML)
📄List of Machine Learning Model...
Collapse 📁MS Office📁MS Office
Collapse 📁Excel📁Excel
Collapse 📁Excel Ribbon📁Excel Ribbon
📄Introduction to MS Excel Ribbo...
Collapse 📁Home Tab📁Home Tab
📄Clipboard...
📄Font...
📄Alignment...
📄Number...
📄Style...
📄Cells...
📄Editing...
Collapse 📁Insert Tab📁Insert Tab
📄Tables...
📄Illustrations...
📄Charts...
Collapse 📁Access📁Access
📄Getting Started with Access Da...
Collapse 📹Video Tutorials📹Video Tutorials
🎬Animate: Classic Tween in Adob...
🎬Google Charts: Using Google Ch...
🎬JavaScript: How to get the Sys...
🎬JavaScript: How to use onLoad ...
🎬JavaScript: How to use onClick...
🎬JavaScript: Performing Mathema...
🎬JavaScript: Using the if-else ...
🎬Power BI: Automating Data Load...
🎬HTML: Complete Course for Begi...
🎬JavaScript: How to get the Sys...
🎬JavaScript: How to use onLoad ...
🎬JavaScript: How to use onClick...
🎬JavaScript: Performing Mathema...
🎬JavaScript: Using the if-else ...
🎬Power BI: Automating Data Load...
🎬Looker Studio: Creating a Sale...
🎬Looker Studio: Understanding t...
🎬Looker Studio: Creating Dynami...
🎬Looker Studio: Setting up Publ...
🎬MS Excel: Mastering MS Excel -...
🎬MS Access: How to Create Relat...
🎬MS Excel: Pivot Tables, Pivot ...
🎬Excel: Lookup Functions, VLook...
🎬Excel: Using the Fill Features...
🎬MS Excel: Pivot... Pivot... Pi...
🎬Excel: Mapping, Grouping and S...
🎬MS Excel: Conditional Formatti...
🎬MS Excel: Creating a Bell Curv...
🎬MS Excel: Predicting Sales wit...
🎬MS Excel: Using the Break-Even...
🎬MS Excel/Power BI: Unpivoting ...
🎬MS Excel: What lies beneath an...
🎬MS Excel: How to add serial nu...
🎬MS Excel: Creating 3D Maps and...
🎬MS Excel: Creating an Animated...
🎬MS Excel: Using What If Analys...
🎬MS Excel: Using Excel Slicers ...
🎬Power BI: Realtime Sales Simul...
🎬MS Excel: How to Create Relati...
🎬Power BI: Creating Pareto Char...
🎬MS Excel: Create a Smart, Dyna...
🎬MS Excel: How to Use Calculat...
🎬MS Excel: Simplifying Complex ...
🎬MS Excel: Calculating, Compar...
🎬MS Excel: Using Formulas like...
🎬MS Excel: Data Modeling and R...
🎬MS Excel: Mastering Excel Dash...
🎬MS Excel: Best Way to Create D...
🎬MS Excel: How to add latest pr...
🎬MS Excel: Performing Non-Linea...
🎬MS Excel: Mastering MS Excel -...
🎬Python: Calculating variance a...
🎬MS Excel: How to use ACCRIT fu...
🎬MS Excel: How to use COUPDAYBS...
🎬MS Excel: How to use AMORDIGRC...
🎬MS Excel: Realtime/Live Data P...
🎬MS Excel: Using Python Real Ti...
🎬MS Excel: Complete Guide to us...
🎬MS Excel: Data Visualization i...
🎬MS Excel: Creating a Dynamic S...
🎬Python: Forecasting with Seaso...
🎬MS Excel: Complete Guide to th...
🎬MS Excel: Using Images in Pivo...
🎬MS Power Point: The Clock - Ep...
🎬Creating and Setting up a Virt...
🎬Power BI: Setting up Power BI ...
🎬Power BI: How to install Power...
🎬Power BI: Dimensional Model Re...
🎬Power BI: Sales and Profit Rep...
🎬Power BI: Decomposition Tree a...
🎬Power BI: Visualizing Stock Po...
🎬Power BI: Drill Down Report by...
🎬Power BI: Artificial Intellige...
🎬Power BI: Team and Product Per...
🎬Power BI: Dashboards with Tool...
🎬Power BI: Bank Failure in USA ...
🎬Power BI: Using Smart Narrativ...
🎬Power BI: Using DAX (Data Anal...
🎬Power BI: Drill-through Report...
🎬Power BI: Crimes in Los Angele...
🎬Power BI: Multi Page Power BI ...
🎬Power BI: Using Sankey Diagram...
🎬Power BI: Analyzing Bank Loans...
🎬Power BI: Connecting to the Wo...
🎬Power BI: Grouping Data in Pow...
🎬Power BI: Forecasting Data wit...
🎬Power BI: Analyzing human reso...
🎬Power BI: Creating a Dimension...
🎬Power BI: Market Basket Analys...
🎬Power BI: Exploring Default Vi...
🎬MS Excel/Power BI: Unpivoting ...
🎬Power BI: Mastering Marketing ...
🎬Power BI: Analyzing Warehouse ...
🎬Power BI: Manage and Monitor P...
🎬Power BI: Analyzing Murder Mot...
🎬Power BI: Correlation Analysi...
🎬Power BI: Create a YouTube Cha...
🎬Power BI: How to Use Bookmarks...
🎬Power BI: Displaying Realtime...
🎬Power BI: Realtime Sales Simul...
🎬Power BI: Using Conditional Fo...
🎬Power BI: Displaying Live Syst...
🎬Power BI: Creating a Project C...
🎬Power BI: Realtime Call Center...
🎬Power BI: Creating Pareto Char...
🎬Power BI: Creating Data Source...
🎬Power BI: Creating a Key Perfo...
🎬Power BI: Creating Paginated R...
🎬Power BI: Creating your first ...
🎬Power BI: Analyzing Seasonalit...
🎬Power BI: Realtime Plant Simul...
🎬Power BI: Visualizing Basic St...
🎬Power BI: Using SQL Query Inst...
🎬Power BI: Loading Data into Po...
🎬Power BI: Displaying Audit Fin...
🎬Python: Performing basic Stati...
🎬Python: Mastering Data Visuali...
🎬Python: Creating Polynomial Re...
🎬Python: Uploading Files Direct...
🎬Python: Mastering NumPy Librar...
🎬Python: Resizing and Convertin...
🎬MS Excel: How to add latest pr...
🎬MS Excel: Performing Non-Linea...
🎬MS Excel: Using Python Real Ti...
🎬MS Excel: Data Visualization i...
🎬Python: Forecasting with Seaso...
🎬Python: Easiest way to downloa...
🎬Python: How to use World Bank ...
🎬Python: Data Scraping from web...
🎬Python: How to work with SQL s...
🎬Python: How to work with panda...
🎬Python: How to create and trai...
🎬Python: How to perform loops (...
🎬Python: Support Vector Machine...
🎬Python: Web Scraping using Pan...
🎬Python: Machine Learning, Clas...
🎬Python: How to classify data u...
🎬Python: How to save, reload an...
🎬Python: Why you should not tru...
🎬Python: Expected Returns (Fina...
🎬Python: Creating a GUI based a...
🎬Python: Predicting absenteeism...
🎬Python: Unleashing the Power o...
🎬Power BI: Displaying Live Syst...
🎬Power BI: Realtime Call Center...
🎬Power BI: Creating your first ...
🎬Power BI: Using SQL Query Inst...
🎬Power BI: Displaying SQL Datab...
🎬R: Creating Your First Pie Cha...
🎬SQL: How to create databases a...
🎬Power BI: Displaying Realtime...
🎬Power BI: Realtime Sales Simul...
🎬Power BI: Displaying Live Syst...
🎬Power BI: Realtime Call Center...
🎬Power BI: Creating a Key Perfo...
🎬Power BI: Creating Data Source...
🎬Power BI: Creating Paginated R...
🎬Power BI: Realtime Plant Simul...
🎬Power BI: Using SQL Query Inst...
🎬Power BI: Displaying SQL Datab...
🎬Power BI: Realtime Simulation ...
🎬Power BI: Crafting Dynamic Ani...
🎬Power BI: Displaying Realtime ...
🎬Power BI: Automating Data Load...
🎬SQL: SQL Server Reporting Serv...
🎬SQL: Creating Realtime Live Re...
🎬Power BI: Real-time Data Refre...
🎬Looker Studio: Setting up Publ...
🎬Power BI:The Clock - Episode 2...
🎬MS Excel: Realtime/Live Data P...
🎬Power BI: Creating a Dice Vide...
🎬Tableau: Tutorial for Beginner...
🎬Unity3d: How to create terrain...

Looker Studio: Setting up Public mySQL Server on your PC, and connecting it to Looker Reports

Description

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<\p>

Tags

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

Views : 19

2024-03-03 16:01:25

Use this simple trick to copy tables from web to your excel file easily #excel #datascraping #web

2024-03-02 14:29:44

MS Excel: Using Images in Pivot Tables, a new added Feature by Microsoft

2024-03-02 10:27:07

MS Excel: Complete Guide to the New Chart Pane in Excel Online

2024-03-01 05:31:38

Generate Random Text in MS Word with Simple Built-in Functions #tutorial #shorts #word #randomtext

2024-02-28 15:06:38

Fill Missing Data in Excel using Python for Excel #python #excel #interpolate #fillna #bfill #ffill

2024-02-27 20:45:12

Power BI: Creating Dashboards for Mobile Devices

2024-02-27 19:52:06

Using Python in MS Excel #python #excel #pythonforexcel #msexcel #excel365 #shorts #tutorial

2024-02-27 17:23:34

Creating Games in Power BI #datavisualization #tutorial #realtime #sql #directquery #powerbi

2024-02-25 19:25:01

Power BI: Using Latest Preview Features like Dax Query View, Visual Calculations and Button Slicers

2024-02-24 14:09:42

Turn on new exciting preview features in Power BI like visual calculations & DAX query view #shorts

2024-02-23 20:32:06

Power BI: Performing Comparative Analysis by Pivoting Columns in Power Query

2024-02-22 12:19:55

Creating a Multiplayer Dice Game in Power BI using SQL Realtime Data #shorts #powerbi #tutorial #sql

2024-02-20 20:19:25

Power BI: Creating Dashboards without External Data Sources using Power Query M Language

2024-02-20 06:57:42

Power BI Realtime Visualizations #shorts #datavisualization #tutorial #powerbi #realtime

2024-02-17 00:50:43

Python: Forecasting with Seasonal Autoregressive Integrated Moving Average (SARIMA) in Python/Excel
© 2024 - Virtual School of Information Technology