This repo contains the Dashboards of my Medical Research Paper (:link: Fauzia et al.) and World trade of Commodities.
- Influence of Medical Education on Personality of Students
- World Trade of Commodities
- Setup
- Todos
- Acknowledgements
- Citation
- Connect with me
Medical education is renowned as one of the most challenging academic pursuits worldwide. It presents medical students with a myriad of academic and non-academic challenges that can significantly impact their scholastic achievements. This study aims to assess the influence of counseling and guidance, as perceived by medical students, on their academic performance. The research employed a cross-sectional design, focusing on 3rd-year MBBS students at Azra Naheed Medical College, Lahore, who were categorized into two groups (A and B) based on their academic performance in the 2021-2022 professional and module examinations. The study utilized a Google form designed by the authors, consisting of 13 questions that gauged students' perceptions regarding the impact of counseling and guidance on various factors affecting their academic progress. The questionnaire was distributed through two official WhatsApp groups (A and B), with group A comprising high-performing students and group B including those with average and below-average academic achievements.
The findings revealed that 40 students from group A and 42 students from group B responded to the questionnaire. A notable percentage of students from both groups expressed positive opinions concerning the supportive role of faculty counseling and guidance in managing the rigorous demands of medical studies, exam preparation, time management, as well as addressing social, domestic, attendance-related issues, and overall academic performance. Question 12, which pertained to career counseling for medical students in medical colleges, received positive responses from 97.5% of students in both groups, indicating a significant correlation. The results underscore the importance of faculty support for students with varying academic performances, emphasizing the pivotal role of faculty members in addressing academic and non-academic challenges. This study underscores the significance of student counseling in medical education and advocates for the establishment of dedicated counseling departments in medical institutions to enhance students' academic and non-academic well-being.
In conclusion, this research underscores the crucial role played by faculty members in addressing the academic and non-academic challenges faced by medical students. The findings of this recent study underscore students' recognition of faculty members' supportive role in enhancing their academic performance through guidance and counseling.
In this project, I aggregated data pertaining to the global trade of commodities, which was sourced from the United Nations. Subsequently, I carried out data preprocessing tasks, such as consolidating related Excel files, such as silk, wool, and cotton, into a unified category, specifically 'clothing.' I adopted a similar approach to amalgamate commodities with shared characteristics into coherent segments. Following these data preparation steps, I imported the refined dataset into Power BI, culminating in the creation of the subsequent report.
When it comes to storing the Commodities trade data, I leveraged AWS S3, which serves as the data repository. I employed AWS Glue Data Crawler to automatically discover and catalog the metadata of our dataset, making it accessible through the AWS Glue Data Catalog. For user interactions with the data, I harnessed AWS Athena, allowing users to run SQL-like queries on the data stored in S3. Additionally, I utilized AWS Redshift, which is a powerful data warehousing solution, to aggregate, process, and store large volumes of data for reporting purposes. To visualize and analyze this data effectively, I constructed Power BI dashboards.
The entire process is thoughtfully orchestrated and automated using Apache Airflow, a robust workflow automation platform. It streamlines the flow of data from its source in the United Nations dataset to AWS S3, through data preprocessing, cataloging, and storage in Redshift, and finally, to the creation of insightful reports in Power BI. This orchestration ensures that the data pipeline is well-organized and efficient, making the entire process highly manageable and scalable.
The dashboard provides a comprehensive view of countries' trade activities, encompassing imports, exports, re-imports, and re-exports. It covers the trade of various categories, including metals, ammunition, clothing, art, furniture, machinery, vehicles, and ships, spanning the period from 1980 to 2020. Additionally, the dashboard highlights key trade insights such as the most lucrative export, the most frequently ordered import, the highest-quality export, and the highest-quality import.
Users have the flexibility to choose between viewing data for all countries collectively or selecting specific countries to access tailored information. The dashboard presents a range of data metrics, including trade values in USD, quantities, product weights, and trade flow details, ensuring a comprehensive and detailed understanding of international trade dynamics.
Let's get this thing running! Follow the next steps:
git clone https://github.com/abideenml/Dashboards-ofmy-MedicalResearchPaper-and-WorldTrade- Navigate into project directory
cd path_to_repo - Open the PowerBI dashboards file:
Powerbi Report of Commodities data.pbix,Influence of Medical Education on Personality.pbixandStudent Response Dashboard.pbix.
That's it!
Finally there are a couple more todos which I'll hopefully add really soon:
- Automate the entire process of Data preprocessing and scraping from International Monetary Fund website.
- Perform Data collection from different Pakistani Medical Colleges.
I found these resources useful (while developing this one):
If you find this code useful, please cite the following:
@misc{Zain2023,
author = {Zain, Abideen},
title = {dashboard-medical-paper-worldtrade},
year = {2023},
publisher = {GitHub},
journal = {GitHub repository},
howpublished = {\url{https://github.com/abideenml/Dashboards-ofmy-MedicalResearchPaper-and-WorldTrade}},
}
If you'd love to have some more AI-related content in your life 🤓, consider:
- Connect and reach me on LinkedIn and Twitter
- Follow me on 📚 Medium
- Subscribe to my 📢 weekly AI newsletter!
