{"id":"https://openalex.org/W7225392091","doi":"https://doi.org/10.58257/ijprems55109","title":"SALES DATA ANALYSIS AND VISUALIZATION USING PYTHON, SQL, AND POWER BI","display_name":"SALES DATA ANALYSIS AND VISUALIZATION USING PYTHON, SQL, AND POWER BI","publication_year":2026,"publication_date":"2026-11-06","ids":{"openalex":"https://openalex.org/W7225392091","doi":"https://doi.org/10.58257/ijprems55109"},"language":"en","primary_location":{"id":"doi:10.58257/ijprems55109","doi":"https://doi.org/10.58257/ijprems55109","is_oa":true,"landing_page_url":"https://doi.org/10.58257/ijprems55109","pdf_url":"https://doi.org/10.58257/ijprems55109","source":{"id":"https://openalex.org/S4387284908","display_name":"International Journal of Progressive Research in Engineering Management and Science","issn_l":"2583-1062","issn":["2583-1062"],"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 Progressive Research in Engineering Management and Science","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://doi.org/10.58257/ijprems55109","any_repository_has_fulltext":false},"authorships":[],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"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.9160000085830688,"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.9160000085830688,"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/T10799","display_name":"Data Visualization and Analytics","score":0.05570000037550926,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/T11734","display_name":"Decision Support System Applications","score":0.013399999588727951,"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/sales-analysis","display_name":"sales analysis","score":0.9909999966621399},{"id":"https://openalex.org/keywords/sales-data-visualization","display_name":"sales data visualization","score":0.7580000162124634},{"id":"https://openalex.org/keywords/sales-dashboard","display_name":"sales dashboard","score":0.6790000200271606},{"id":"https://openalex.org/keywords/power-bi","display_name":"Power BI","score":0.7099999785423279},{"id":"https://openalex.org/keywords/python","display_name":"Python","score":0.5910000205039978},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.9369999766349792},{"id":"https://openalex.org/keywords/matplotlib","display_name":"Matplotlib","score":0.8069999814033508},{"id":"https://openalex.org/keywords/react","display_name":"React","score":0.871999979019165},{"id":"https://openalex.org/keywords/managerial-decision-making","display_name":"management decision-making","score":0.6570000052452087},{"id":"https://openalex.org/keywords/data-preprocessing","display_name":"data preprocessing","score":0.8989999890327454}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7269999980926514},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.71670001745224},{"id":"https://openalex.org/C139749660","wikidata":"https://www.wikidata.org/wiki/Q5657855","display_name":"Sales management","level":2,"score":0.6879000067710876},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.6323000192642212},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.4997999966144562},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.43130001425743103},{"id":"https://openalex.org/C10551718","wikidata":"https://www.wikidata.org/wiki/Q5227332","display_name":"Data pre-processing","level":2,"score":0.4101000130176544},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.40389999747276306},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36809998750686646},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.3546999990940094},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3407000005245209},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.3357999920845032},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.29649999737739563},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.29429998993873596},{"id":"https://openalex.org/C14669888","wikidata":"https://www.wikidata.org/wiki/Q4014850","display_name":"Creative visualization","level":3,"score":0.29019999504089355},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.28610000014305115},{"id":"https://openalex.org/C110593043","wikidata":"https://www.wikidata.org/wiki/Q7300787","display_name":"Real-time data","level":2,"score":0.2703000009059906},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.2630000114440918},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.25870001316070557},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2508000135421753}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.58257/ijprems55109","doi":"https://doi.org/10.58257/ijprems55109","is_oa":true,"landing_page_url":"https://doi.org/10.58257/ijprems55109","pdf_url":"https://doi.org/10.58257/ijprems55109","source":{"id":"https://openalex.org/S4387284908","display_name":"International Journal of Progressive Research in Engineering Management and Science","issn_l":"2583-1062","issn":["2583-1062"],"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 Progressive Research in Engineering Management and Science","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.58257/ijprems55109","doi":"https://doi.org/10.58257/ijprems55109","is_oa":true,"landing_page_url":"https://doi.org/10.58257/ijprems55109","pdf_url":"https://doi.org/10.58257/ijprems55109","source":{"id":"https://openalex.org/S4387284908","display_name":"International Journal of Progressive Research in Engineering Management and Science","issn_l":"2583-1062","issn":["2583-1062"],"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 Progressive Research in Engineering Management and Science","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/W7225392091.pdf","grobid_xml":"https://content.openalex.org/works/W7225392091.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7218133629","https://openalex.org/W7163761765","https://openalex.org/W7218248583","https://openalex.org/W7130332949","https://openalex.org/W7082357457","https://openalex.org/W4402000077","https://openalex.org/W4388761139","https://openalex.org/W7163806440","https://openalex.org/W4403984052","https://openalex.org/W7155194868"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"the":[3,78,169],"design":[4],"and":[5,11,21,28,45,58,72,90,97,106,108,124,140,149,160,167,182,198],"implementation":[6],"of":[7,32,51,77,171],"Sales":[8],"Data":[9],"Analysis":[10],"Visualization":[12],"is":[13,35,80,85,93,101,111],"a":[14,67],"project":[15,34,65,155],"developed":[16,81],"to":[17,36,70,95,103,113,120,191],"analyze":[18,46],"sales":[19,40,48,52,74,99,122,151,172,184],"data":[20,91,158,200],"present":[22,125],"meaningful":[23],"information":[24,123],"through":[25],"charts,":[26],"graphs,":[27,107],"dashboards.The":[29],"main":[30],"purpose":[31],"this":[33],"help":[37,145],"users":[38,146],"understand":[39],"performance,":[41],"identify":[42,147,192],"top-performing":[43],"products,":[44],"monthly":[47,141,183],"trends.Traditional":[49],"methods":[50],"analysis":[53,159],"often":[54],"require":[55],"manual":[56],"calculations":[57],"report":[59],"preparation,":[60],"which":[61],"can":[62,163,188],"be":[63,189],"time-consuming.This":[64],"provides":[66],"systematic":[68],"approach":[69],"processing":[71,89],"visualizing":[73],"information.The":[75,173],"frontend":[76],"system":[79,132,174],"using":[82],"React.js,while":[83],"Python":[84],"used":[86,94,102,112,190],"for":[87],"backend":[88],"analysis.SQL":[92],"store":[96],"manage":[98],"records.Matplotlib":[100],"generate":[104],"charts":[105],"Power":[109],"BI":[110],"create":[114],"interactive":[115],"dashboards.These":[116],"technologies":[117],"work":[118],"together":[119],"organize":[121],"analytical":[126],"results":[127,152],"in":[128],"an":[129],"understandable":[130],"format.The":[131],"focuses":[133,175],"on":[134,176],"analyzing":[135,177],"total":[136,178],"sales,":[137,139,179,181],"product-wise":[138,180],"salesperformance.The":[142],"visual":[143],"representations":[144],"patterns":[148],"compare":[150],"more":[153],"easily.This":[154],"demonstrates":[156],"how":[157],"visualization":[161],"tools":[162],"support":[164],"business":[165],"decision-making":[166],"improve":[168,199],"understanding":[170],"performance.Data":[185],"preprocessing":[186],"techniques":[187],"missing":[193],"values,":[194],"remove":[195],"duplicate":[196],"records,":[197],"quality":[201],"before":[202],"analysis.":[203]},"counts_by_year":[],"updated_date":"2026-11-08T12:12:28.789561","created_date":"2026-11-07T00:00:00"}