Submit application

pop-song-analytics

Downloads18
Subscribe
1
Bookmark
1
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues

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

Rating
0 (0)
Category
Analytics
Works with
InterSystems IRIS
Tags
Info
Version
1.0.3
Last updated
2021-09-11
Repository
Open
Documentation
Open
License
Link
Rewards