Downloads21
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
Awards
Issues
Videos
Articles
Reports

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
4.5 (1)
ObjectScript quality test
Passed
Updated on 08 February 2023
ObjectScript quality report
Category
Analytics
Works with
InterSystems IRIS
Tags
Info
Version
1.0.3
Last updated
2021-09-11
Repository
Open
Documentation
Open
License
Link