Home Applications pop-song-analytics

pop-song-analytics

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
4.5
0 reviews
1
Awards
262
Views
0
IPM installs
0
1
Details
Releases
Reviews
Awards  (1)
Issues
Articles  (2)
Pop Songs analytics from the last decades

What's new in this version

  • Add individual global import for ZPM
  • Fix PowerBI file

Pop Songs Analytics

Inspired on a Netflix documentary called this is pop, it is an exercise to analyse the songs that was on billboard top 100 songs in the last years.
For this project was used a csv file with all Billboard Hot 100 from 2000 to 2018, created by “Michael Tauberg” @typhon available on Data World project

Report

Report 1
Report 2

Installation

Docker

The repo is dockerised so you can clone/git pull the repo into any local directory

$ git clone https://github.com/henryhamon/pop-song-analytics.git

Open the terminal in this directory and run:

$ docker-compose up -d

The script in Installer.cls will import everything you place under /src into IRIS.

MS Power BI

Open the power bi file locate on ./dsw/pop_songs_analytics_powerbi.pbix
You could configure the data source, go to “Get Data” and select InterSystems IRIS.

Follow the setup below:

PowerBI 1

What’s inside the repository

Dockerfile

The simplest dockerfile which starts IRIS and imports Installer.cls and then runs the Installer.setup method, which creates IRISAPP Namespace and imports ObjectScript code from /src folder into it.
Use the related docker-compose.yml to easily setup additional parametes like port number and where you map keys and host folders.
Use .env/ file to adjust the dockerfile being used in docker-compose.

PowerBI file

The MS Power BI file locate on ./dsw/pop_songs_analytics_powerbi.pbix

.vscode/settings.json

Settings file to let you immedietly code in VSCode with VSCode ObjectScript plugin)

.vscode/launch.json

Config file if you want to debug with VSCode ObjectScript

Read about this project in this article

A live demo here

Made with
Version
1.0.311 Sep, 2021
ObjectScript quality test
Category
Analytics
Works with
InterSystems IRIS
First published
05 Sep, 2021
Last checked by moderator
27 Jun, 2023Works