{"id":"https://openalex.org/W4410972742","doi":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","title":"Designing Compliance-Focused Financial Reporting Systems Using SQL, Tableau, and BI Tools","display_name":"Designing Compliance-Focused Financial Reporting Systems Using SQL, Tableau, and BI Tools","publication_year":2022,"publication_date":"2022-01-01","ids":{"openalex":"https://openalex.org/W4410972742","doi":"https://doi.org/10.54660/ijmor.2022.1.2.94-110"},"language":"en","primary_location":{"id":"doi:10.54660/ijmor.2022.1.2.94-110","doi":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","is_oa":true,"landing_page_url":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","pdf_url":"https://www.themanagementjournal.com/uploads/archives/20250602114719_MOR-2025-3-020.1.pdf","source":{"id":"https://openalex.org/S4387290804","display_name":"International Journal of Management and Organizational Research","issn_l":"2583-6641","issn":["2583-6641"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Management and Organizational Research","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://www.themanagementjournal.com/uploads/archives/20250602114719_MOR-2025-3-020.1.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5117584812","display_name":"Olasunbo Olajumoke Fagbore","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Olasunbo Olajumoke Fagbore","raw_affiliation_strings":["Independent Researcher , Texas , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Independent Researcher , Texas , USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5117448629","display_name":"Jeffrey Chidera Ogeawuchi","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jeffrey Chidera Ogeawuchi","raw_affiliation_strings":["CBRE & Boston Properties , Boston MA , USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CBRE & Boston Properties , Boston MA , USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5099061124","display_name":"Oluwatosin Ilori","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4405286368","display_name":"City of Saskatoon","ror":"https://ror.org/01yeswp15","country_code":"CA","type":"government","lineage":["https://openalex.org/I4405286368"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Oluwatosin Ilori","raw_affiliation_strings":["Independent Researcher , City of Saskatoon , Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Independent Researcher , City of Saskatoon , Canada","institution_ids":["https://openalex.org/I4405286368"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5116597902","display_name":"Ngozi Joan Isibor","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ngozi Joan Isibor","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5117584814","display_name":"Azeez Odetunde","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I8408910","display_name":"Cardiff Metropolitan University","ror":"https://ror.org/00bqvf857","country_code":"GB","type":"education","lineage":["https://openalex.org/I8408910"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Azeez Odetunde","raw_affiliation_strings":["Cardiff Metropolitan University , UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Cardiff Metropolitan University , UK","institution_ids":["https://openalex.org/I8408910"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5116845884","display_name":"Bolaji Iyanu Adekunle","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bolaji Iyanu Adekunle","raw_affiliation_strings":["Data Scientist , GSFEN Limited , Nigeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Data Scientist , GSFEN Limited , Nigeria","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.571,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.75379011,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"1","issue":"2","first_page":"94","last_page":"110"},"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.635699987411499,"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.635699987411499,"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/T13794","display_name":"Financial Reporting and XBRL","score":0.23469999432563782,"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/T11734","display_name":"Decision Support System Applications","score":0.048900000751018524,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sarbanes-oxley-act","display_name":"Sarbanes-Oxley Act","score":0.9459999799728394},{"id":"https://openalex.org/keywords/international-financial-reporting-standards","display_name":"IFRS","score":0.9610000252723694},{"id":"https://openalex.org/keywords/basel-iii","display_name":"Basel III","score":0.9990000128746033},{"id":"https://openalex.org/keywords/tableau-dashboard","display_name":"Tableau dashboard","score":0.9639999866485596},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"business intelligence","score":0.6169999837875366},{"id":"https://openalex.org/keywords/etl-automation","display_name":"ETL automation","score":0.9620000123977661},{"id":"https://openalex.org/keywords/data-lineage","display_name":"data lineage","score":0.5580000281333923},{"id":"https://openalex.org/keywords/audit-readiness","display_name":"audit readiness","score":0.5440000295639038},{"id":"https://openalex.org/keywords/regulatory-risk","display_name":"regulatory risk","score":0.44999998807907104},{"id":"https://openalex.org/keywords/internal-control","display_name":"internal control","score":0.5600000023841858},{"id":"https://openalex.org/keywords/analysis-of-variance","display_name":"analysis of variance","score":0.671999990940094},{"id":"https://openalex.org/keywords/data-governance","display_name":"data governance","score":0.4449999928474426},{"id":"https://openalex.org/keywords/investment-funds","display_name":"investment funds","score":0.5479999780654907},{"id":"https://openalex.org/keywords/corporate-finance","display_name":"corporate finance","score":0.7200000286102295}],"concepts":[{"id":"https://openalex.org/C2781460075","wikidata":"https://www.wikidata.org/wiki/Q1399332","display_name":"Compliance (psychology)","level":2,"score":0.7742130160331726},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6199290752410889},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4507909417152405},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4365467429161072},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.4081297814846039},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.18583878874778748},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.54660/ijmor.2022.1.2.94-110","doi":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","is_oa":true,"landing_page_url":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","pdf_url":"https://www.themanagementjournal.com/uploads/archives/20250602114719_MOR-2025-3-020.1.pdf","source":{"id":"https://openalex.org/S4387290804","display_name":"International Journal of Management and Organizational Research","issn_l":"2583-6641","issn":["2583-6641"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Management and Organizational Research","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.54660/ijmor.2022.1.2.94-110","doi":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","is_oa":true,"landing_page_url":"https://doi.org/10.54660/ijmor.2022.1.2.94-110","pdf_url":"https://www.themanagementjournal.com/uploads/archives/20250602114719_MOR-2025-3-020.1.pdf","source":{"id":"https://openalex.org/S4387290804","display_name":"International Journal of Management and Organizational Research","issn_l":"2583-6641","issn":["2583-6641"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Management and Organizational Research","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4410972742.pdf","grobid_xml":"https://content.openalex.org/works/W4410972742.grobid-xml"},"referenced_works_count":5,"referenced_works":["https://openalex.org/W4405256015","https://openalex.org/W4406275127","https://openalex.org/W4408993245","https://openalex.org/W4408994183","https://openalex.org/W4408994654"],"related_works":["https://openalex.org/W7118281154","https://openalex.org/W7163989081","https://openalex.org/W4414217720","https://openalex.org/W4409338837","https://openalex.org/W4412032325","https://openalex.org/W4415443678","https://openalex.org/W4413466935","https://openalex.org/W4414019786","https://openalex.org/W4414822966","https://openalex.org/W7214123569"],"abstract_inverted_index":{"This":[0,259],"paper":[1],"explores":[2],"the":[3,27,102,199,225,228],"design":[4,94],"and":[5,19,43,55,72,88,105,117,126,132,144,156,175,189,212,221,242,255,269,285,305],"implementation":[6],"of":[7,16,29,107,195,201],"compliance-focused":[8],"financial":[9,59,90,108,152,278,300],"reporting":[10,226,279],"systems":[11,280],"using":[12],"a":[13,62,80,202,263,289],"robust":[14],"integration":[15],"SQL,":[17,303],"Tableau,":[18,304],"Business":[20],"Intelligence":[21],"(BI)":[22],"tools,":[23],"specifically":[24],"Excel.":[25],"In":[26],"face":[28],"evolving":[30],"regulatory":[31,190,231,286],"mandates":[32,287],"such":[33],"as":[34],"SOX":[35],"(Sarbanes-Oxley":[36],"Act),":[37],"IFRS":[38],"(International":[39],"Financial":[40],"Reporting":[41],"Standards),":[42],"Basel":[44],"III,":[45],"organizations":[46],"are":[47,119],"under":[48],"increasing":[49],"pressure":[50],"to":[51,100,121,140,150,272],"maintain":[52],"transparency,":[53],"accuracy,":[54],"timeliness":[56],"in":[57,169,274,288],"their":[58],"reporting.":[60],"Leveraging":[61],"technical":[63,260],"toolkit":[64],"comprising":[65],"structured":[66],"query":[67],"language":[68],"(SQL),":[69],"Tableau":[70,136],"dashboards,":[71],"advanced":[73],"Excel":[74,173,306],"models,":[75],"this":[76,179,196,247],"study":[77],"demonstrates":[78],"how":[79,246,295],"streamlined":[81],"data":[82,98,109,123,210,297],"architecture":[83,249],"can":[84],"enable":[85],"real-time,":[86],"auditable,":[87],"regulator-ready":[89],"reports.":[91],"The":[92],"system":[93,229],"begins":[95],"with":[96,299],"SQL-driven":[97],"modeling":[99],"ensure":[101],"integrity,":[103],"traceability,":[104],"normalization":[106],"from":[110,166,239],"multiple":[111],"source":[112],"systems.":[113],"SQL":[114],"stored":[115],"procedures":[116],"views":[118],"developed":[120],"automate":[122],"extraction,":[124],"transformation,":[125],"loading":[127],"(ETL),":[128],"eliminating":[129],"manual":[130],"errors":[131],"enhancing":[133],"audit":[134,222,257],"readiness.":[135],"is":[137,198],"then":[138],"used":[139],"create":[141],"dynamic":[142],"visualizations":[143],"compliance":[145,167],"dashboards":[146,160],"that":[147,206,281],"allow":[148],"stakeholders":[149],"monitor":[151],"health,":[153],"reconcile":[154],"transactions,":[155],"detect":[157],"anomalies.":[158],"These":[159],"integrate":[161],"governance":[162],"controls,":[163],"flagging":[164],"deviations":[165],"thresholds":[168],"real":[170],"time.":[171],"Advanced":[172],"formulas":[174],"pivot":[176],"tables":[177],"complement":[178],"workflow":[180],"by":[181],"supporting":[182],"in-depth":[183],"variance":[184],"analysis,":[185],"control":[186,253],"testing":[187],"documentation,":[188],"submissions.":[191],"A":[192],"key":[193],"contribution":[194],"work":[197],"development":[200],"repeatable":[203],"compliance-reporting":[204],"framework":[205],"emphasizes":[207],"version":[208],"control,":[209],"lineage,":[211],"role-based":[213],"access.":[214],"By":[215],"embedding":[216],"risk":[217],"metrics,":[218],"policy":[219],"thresholds,":[220],"trails":[223],"within":[224],"interface,":[227],"minimizes":[230],"risks":[232],"while":[233],"improving":[234],"operational":[235,284],"efficiency.":[236],"Case":[237],"studies":[238],"investment":[240],"funds":[241],"corporate":[243],"finance":[244,266,291],"illustrate":[245],"integrated":[248],"enhances":[250],"both":[251,283],"internal":[252],"effectiveness":[254],"external":[256],"alignment.":[258],"synthesis":[261],"provides":[262],"blueprint":[264],"for":[265],"professionals,":[267],"auditors,":[268],"IT":[270],"teams":[271],"collaborate":[273],"developing":[275],"scalable,":[276],"compliance-ready":[277],"fulfill":[282],"digitized":[290],"ecosystem.":[292],"It":[293],"highlights":[294],"bridging":[296],"engineering":[298],"analytics":[301],"through":[302],"ensures":[307],"not":[308],"just":[309],"compliance,":[310],"but":[311],"strategic":[312],"foresight.":[313]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2025-10-10T00:00:00"}