- Description
- Deployed Project Link
- Installation
- Usage
- Contributing
- GitHub
- Contact
- Acknowledgements
- Tests
- License
This project is a Power BI data analysis that evaluates student intake data over the past 10 years across all Canadian provinces. The project correlates student intake trends with Permanent Residency (PR) assignments and provides insights into the countries of origin for PRs. The project uses various analytical techniques to visualize the data, explore trends by province, and break down the different PR streams based on the points required for eligibility.
Key features include:
- Trend analysis of student permits issued over a 10-year span.
- Correlation between student intake and PRs assigned.
- Drill-down by province to identify regions with the highest student intake.
- Breakdown of PR streams, including the points required for eligibility.
- Visualizations of PR origins and student permit distributions using the Google Maps API for geographical insights.
- Power BI for data visualization and dashboard creation.
- Python (Numpy, Pandas) and Jupyter Notebook for data cleaning and manipulation.
- Google Maps API for visual representation of PR and student data by country and province.
Currently, the project is not deployed online. For further details, please contact the project maintainer.
To run this project locally, follow these steps:
-
Clone the repository:
git clone https://github.com/brij0/Study-Permit-analysis-project.git
-
Navigate to the project directory:
cd Power-BI-Canada-Study-Permit-analysis -
Install necessary dependencies (if using Python scripts for data cleaning):
pip install -r requirements.txt
-
Download the necessary datasets and save them in the
/datasetsfolder. -
Run the Python data cleaning scripts:
python data_cleaning.py
-
Open Power BI Desktop and load the
.pbixfile to explore the dashboard.
- Open the Power BI dashboard to explore trends in student intake across Canada.
- Drill-down functionality allows you to see detailed data by province or country of origin for PR assignments.
- Use Google Maps visualizations to see a geographical representation of PR origin countries and student permit distributions.
- Analyze the points required for PR eligibility for various streams, such as the Master’s Graduate stream, PhD stream, and more.
- Student Intake: A 10-year trend of student intake data, broken down by province and country of origin.
- PR Assignment Correlation: Analysis of how student intakes correlate with PR assignments across different provinces.
- Top Countries for PR: Drill down by country to see the countries contributing most to PR assignments.
- PR Stream Breakdown: Compare eligibility points across different PR streams, such as the Foreign Worker stream, International Student stream, and more.
Contributions are welcome! To contribute:
- Fork the repository.
- Create a new branch:
git checkout -b feature-branch. - Make changes and commit:
git commit -m 'Added a new feature'. - Push to the branch:
git push origin feature-branch. - Submit a pull request.
Please ensure your contributions follow best practices and are well-documented.
You can find this repository and more projects at my GitHub profile:
Feel free to reach out for any questions, feedback, or collaborations:
- Email: [email protected]
Special thanks to the following individuals and resources for their help and support during this project:
-
YouTube Tutorials: The following YouTube tutorials were instrumental in guiding the use of Python and Power BI:
-
OpenAI GPT: For support in providing insights and generating clear explanations.
Currently, there are no tests available for this project. If you would like to contribute, please create a test plan.
This project is licensed under the MIT License.