Let's build a Power BI dashboard: Disney wait times with APIs / Powershell for your portfolio!

Do you love theme parks and want to use related data for your portfolio? Are you interested in theme park wait times and how to use them in reports and dashboards? Well check this video out!

In this video, we'll walk through how to obtain near-real time theme park wait times, download them via an API, and even build a quick Power BI Dashboard based on the data.

Part 2 will be available soon, where we automate further and even add SQL Server to the mix!

------------------------------------------------
Data Source used: https://queue-times.com (big thanks to them!)
------------------------------------------------
ChatGPT prompt used:
"I need to call an API that returns data and export that to a csv. Can you write a powershell script that does this please?"

-----------------------------------------
https://postman.com
   / @postman  

https://lucidchart.com
   / @lucidchart.  
-----------------------------------------
Powershell Resources:
(Powershell for SQL Server) https://dbatools.io
   / @dbatools  
(Powershell Tutorials) Powershell in a month of lunches: https://www.manning.com/books/learn-p...\
-----------------------------------------
Data Sources
https://kaggle.com
https://data.gov
https://statista.com
https://www.microsoft.com/en-us/resea...
  / datasets  
https://datos.estadisticas.pr
-----------------------------------------
Resources:
Notepad ++: https://notepad-plus-plus.org/downloads
Power BI Visual Vocabulary: https://community.fabric.microsoft.co...
https://dbatools.io/commands
https://liveSQL.oracle.com
-----------------------------------------
Favorite PBI Channels:
/ @howtopowerbi
/ @datapears
/ @guyinacube
/ @powerbipark
-----------------------------------------

Catch me live on Twitch! / sqldevdba

-----------------------------------------

Chapters
00:00 - Intro (let's talk about APIs)
01:34 - What about SSIS?
03:37 - New Setup for streaming
05:39 - Checking out the source - queue-times.com
08:38 - Intro/demo of Postman for API Exploration
11:24 - Building the code Spoiler alert: ChatGPT Helps
12:20 - Evascroll in the house!
14:50 - The chatgpt (bing chat) prompt
21:17 - Example of file extraction and discussing the automation
21:35 - Shoutout to DBATools!
24:39 - Let's check out the API call and data for Magic Kingdom
30:42 - ElementFuture in the house!
33:11 - Why write to two files at the same time (Live/History)?
36:00 - How do we schedule the code to run? (Windows task scheduler)
39:54 - Rod720TV in the house!
44:30 - Quick demo of a few reports we've already made
46:39 - Back to work! Let's continue our data export
50:16 - Question: Where do I start as a beginner?
01:00:02 - BownerSoup in the house! Question: how do we append to a file ?
01:02:18 - Pulsecheck - recap of progress and planning the rest
01:04:05 - Let's chat about the Architecture (w/ diagram)
01:21:37 - Creating a Power BI dashboard using the data
01:29:23 - Question - What about building DIM (Dimension) tables?
01:37:00 - Back to the dashboard (adding conditional format, slicers, etc.)
01:49:27 - Acaci in the house!
02:10:37 - Done! Outro (and surprise asthma attack!)

Tags:
#disney #disneydata #sql #powershellscripting #powershell #api #datavisualization #powerbi #dataanalysis #powershelltraining #powerbitraining #etl #themepark #portfolio #tutorial #powerbitutorial #ssms #apis #etl #dashboard