{"id":"https://openalex.org/W7225235403","doi":"https://doi.org/10.5281/zenodo.23964012","title":"Building a Business Intelligence Pipeline for GitHub Issue Analytics: Talend ETL, a MySQL Star Schema and Power BI","display_name":"Building a Business Intelligence Pipeline for GitHub Issue Analytics: Talend ETL, a MySQL Star Schema and Power BI","publication_year":2026,"publication_date":"2026-11-04","ids":{"openalex":"https://openalex.org/W7225235403","doi":"https://doi.org/10.5281/zenodo.23964012"},"language":"en","primary_location":{"id":"doi:10.5281/zenodo.23964012","doi":"https://doi.org/10.5281/zenodo.23964012","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23964012","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"volume":null,"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5281/zenodo.23964012","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5160611439","display_name":"YASMINE DAOUDI","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3121676899","display_name":"Universit\u00e9 Ibn-Tofail","ror":"https://ror.org/02wj89n04","country_code":"MA","type":"education","lineage":["https://openalex.org/I3121676899"]}],"countries":["MA"],"is_corresponding":true,"raw_author_name":"DAOUDI, YASMINE","raw_affiliation_strings":["Higher School of Technology of K\u00e9nitra, Ibn Tofail University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Higher School of Technology of K\u00e9nitra, Ibn Tofail University","institution_ids":["https://openalex.org/I3121676899"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5160611439"],"corresponding_institution_ids":["https://openalex.org/I3121676899"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9574999809265137,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9574999809265137,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.0272000003606081,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10430","display_name":"Software Engineering Techniques and Practices","score":0.003000000026077032,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8026999831199646},{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.6352999806404114},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6335999965667725},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5774000287055969},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4927999973297119},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.486299991607666},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4307999908924103},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4244000017642975},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4056999981403351},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.37779998779296875},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.373199999332428},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.35670000314712524},{"id":"https://openalex.org/C32587265","wikidata":"https://www.wikidata.org/wiki/Q1182260","display_name":"Data deduplication","level":2,"score":0.3386000096797943},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.33390000462532043},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.3174000084400177},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3098999857902527},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.30559998750686646},{"id":"https://openalex.org/C183003079","wikidata":"https://www.wikidata.org/wiki/Q1000371","display_name":"Personalization","level":2,"score":0.30149999260902405},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.2870999872684479},{"id":"https://openalex.org/C175309249","wikidata":"https://www.wikidata.org/wiki/Q725864","display_name":"Pipeline transport","level":2,"score":0.2824999988079071},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.2754000127315521},{"id":"https://openalex.org/C2776574205","wikidata":"https://www.wikidata.org/wiki/Q1391314","display_name":"Business information","level":2,"score":0.2685999870300293},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.2621999979019165},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.2599000036716461},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.25870001316070557},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.2565999925136566},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2549000084400177},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.2533000111579895},{"id":"https://openalex.org/C148027188","wikidata":"https://www.wikidata.org/wiki/Q907375","display_name":"Unit testing","level":3,"score":0.251800000667572},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.2513999938964844}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5281/zenodo.23964012","doi":"https://doi.org/10.5281/zenodo.23964012","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23964012","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},{"id":"doi:10.5281/zenodo.23964013","doi":"https://doi.org/10.5281/zenodo.23964013","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23964013","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.5281/zenodo.23964012","doi":"https://doi.org/10.5281/zenodo.23964012","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.23964012","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"GitHub":[0,34],"issues":[1,31],"carry":[2],"operational":[3],"data":[4,49],"about":[5],"software":[6],"quality,":[7],"but":[8],"they":[9],"arrive":[10],"as":[11,52,154,163],"paginated,":[12],"semi-structured":[13],"JSON":[14],"that":[15,29,147],"is":[16],"hard":[17],"to":[18],"analyze":[19],"directly.":[20],"This":[21],"paper":[22],"describes":[23],"an":[24,164],"end-to-end":[25],"business":[26],"intelligence":[27],"pipeline":[28,157],"extracts":[30],"from":[32],"the":[33,100,124,129,133,138,152],"REST":[35],"API":[36],"with":[37],"Talend":[38],"Open":[39],"Studio,":[40],"transforms":[41],"them,":[42],"and":[43,60,66,84,93,107,110,132,159],"loads":[44],"them":[45],"into":[46],"a":[47,53,96,118,155,160],"MySQL":[48,108],"warehouse":[50,130],"modeled":[51],"star":[54],"schema":[55],"(one":[56],"bug":[57,168],"fact":[58],"table":[59],"four":[61],"dimensions:":[62],"developer,":[63],"project,":[64],"status":[65,77],"priority).":[67],"Dashboards":[68],"in":[69,99,137],"Power":[70],"BI":[71],"or":[72],"Tableau":[73],"support":[74],"questions":[75],"on":[76,117],"distribution,":[78],"monthly":[79],"trends,":[80],"bugs":[81],"per":[82],"project":[83,139],"priority":[85],"mix.":[86],"We":[87,149],"document":[88],"three":[89],"concrete":[90],"integration":[91],"failures":[92],"their":[94],"fixes:":[95],"phantom":[97],"column":[98],"JSON-extraction":[101],"schema,":[102,131],"ISO":[103],"8601":[104],"date":[105],"parsing,":[106],"authentication":[109],"SSL":[111],"errors.":[112],"The":[113],"ETL":[114],"was":[115],"validated":[116,156],"proof-of-concept":[119],"load":[120],"of":[121,146,167],"59":[122],"issues;":[123],"dashboards":[125],"were":[126],"designed":[127],"against":[128],"large-volume":[134],"charts":[135],"shown":[136],"report":[140],"are":[141],"illustrative":[142],"rather":[143],"than":[144],"results":[145],"load.":[148],"therefore":[150],"present":[151],"work":[153],"design":[158],"template,":[161],"not":[162,171],"empirical":[165],"study":[166],"data.":[169],"Preprint,":[170],"peer":[172],"reviewed.":[173]},"counts_by_year":[],"updated_date":"2026-11-05T12:25:35.769452","created_date":"2026-11-05T00:00:00"}