Let's create a dashboard in Power BI and SQL Server for your portfolio using 2024 Olympics Data API!

Are you a student or aspiring Data analyst interested in APIs, Powershell, or Databases? Here's a project that you can use for your portfolio!

The Brazilian group ‪@codante-io‬ has an amazing API as part of a Hackathon they're sponsoring that returns dates about the 2024 Olympic games. Using Powershell, we were able to download and store the data in CSV files, then push them to SQL Server and build a Report/Dashboard in Power BI!

In this video, we:
1) Discussed the goal and architecture of the project
2) Downloaded the data using Powershell to CSV Files
3) Uploaded the data to SQL Server (not required) using Powershell
4) Created a fully functioning Power BI Dashboard using the data

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

Final (Interactive) dashboard included here:

https://app.powerbi.com/view?r=eyJrIj...

------------------------------------------------------------
Tools used:

https://Postman.com (To Explore the API)
https://LucidChart.com (To Create diagrams and ERDs)
------------------------------------------------------------
Code used: (SQL, Powershell, PBIX) and Data Files available here:

Google Drive: https://drive.google.com/drive/folder...
------------------------------------------------------------

Recursos (Obrigado ‪@codante-io‬ !):
Reddit: RobertoTC
Video about project:    • Fiz uma API das Olimpíadas 2024  
Project:: https://codante.io/mini-projetos/hack...
Documentation: https://docs.apis.codante.io/olympic-...
Youtube:    / @codante-io  
GitHub: https://github.com/codante-io

------------------------------------------------------------
If you want to learn more, or be a part of the live streams, here are my channels!

  / sqldevdba  

Power BI Demos:
https://SQLDevDBA.com/power-bi-demos

If you have any suggestions or requests/ideas:
https://SQLDevDBA.com/contact

------------------------------------------------------------
Dev Channels/Power BI
   / @cursosdedesarrollo  
   / @brentozarunlimited  
   / @guyinacube  
   / @sqlbi  
------------------------------------------------------------
Chapters

00:00 - Intro
01:51 - Why even do this?
08:05 - Special thanks to the Codante.io team!
10:18 - About the Codante.io Olympics API
10:30 - Exploring the API Docs
16:57 - Exploring API calls via Postman
28:52 - Quick chat about SSIS, KWS, and SQL Server Developer
32:21 - Walkthrough of the resulting Power BI Report
41:17 - Reviewing the architecture and planning
48:50 - Exploring/Reviewing the Powershell calls
1:04:20 - Shout out to DBATools.io
1:07:35 - Chatting about Paging APIs in Powershell
1:13:22 - Running Powershell code (Countries, Events, Sports, Participants)
1:15:26 - BownerSoup en la casa!
1:18:35 - "Events" API Call
1:21:25 - Creating SQL Server Objects
1:40:32 - How to Generate Create scripts for objects
1:44:14 - GoompyBumpy en la casa! (Q?: Is this Unity?)
1:47:18 - GoompyBumpy Q: What are you using this data for?
1:47:10 - Face for Radio
1:53:26 - Done with SQL, let's populate the Objects via Powershell
2:00:37 - BownerSoup Q?: Does Powershell connect as a SQL user?
2:21:10 - Starting Power BI Report!
2:29:37 - BownerSoup Q?: Show me the bookmarks/page navigator!
2:53:53 - Establishing relationships b/w datasets
3:00:30 - Starting Power BI Visuals
3:01:08 - How to create a Page Navigator
3:22:17 - Adding a Bar Graph
3:38:18 - Second (Events) page with Table and Bar charts
3:51:58 - Status/Credits Page
3:59:43 - Visual Upgrades and tweaks (Shadows, colors, etc.)
4:13:44 - How to hot-swap data sources (CSV to SQL)
4:15:54 - Publishing / Publish to Web
4:20:33 - Wrap up / Thanks!

----------------------------------------
Tags
#CodanteIO #datos #datavisualization #powerbi #powerbitutorial #español #sql #sqlserver #analisisdedatos #database #data #olympics #olimpiadas #jogosolímpicos #juegosolimpicos2024 #olympics2024 #tutorial #api #powershell #puertorico #dashboard #ssms #etl