API from CoinMarketCap to provides Json file with daily values.
Windows Task Scheduler to run Python scripts daily locally or via Azure Databricks.
Power BI Desktop to create reports, measures, calculated columns & data models.
Power BI Service embed code for public report.
Power BI Personal Gateway to refresh dataset.
Report:
2/3 Galaxus Live Feed – Orders
Tools:
Python. Script to capture live sales feed (IMG to text package) every 20 seconds and save to a SQL server. Live feed isn’t contained in the HTML and can’t be scrapped. Only a few periods of records were recorded.
SQL Server 2019 (save records)
SSMS (create views and table for records above)
Power BI Desktop (create reports, measures, calculated columns, data models)
Power BI Service (embed code for public report)
Power BI Personal Gateway (to refresh dataset)
Report:
3/3 Galaxus Live Feed – Dog Food Tracker
Tools:
Python. Script to web scrape dynamic price of one specific product.
SQL Server 2019 (save records)
SSMS (create views and table for records above)
Power BI Desktop (create reports, measures, calculated columns, data models)
Power BI Service (embed code for public report)
Power BI Personal Gateway (to refresh dataset)
Power BI Reflex (get notified when prices falls below threshold)