We are thrilled to announce the successful completion of the Datakirk UK Work Experience Programme! This intensive program, designed for international students specializing in Data & AI-related fields, has been a remarkable journey of learning, collaboration, and innovation.
Our Mission
At Datakirk, we are committed to empowering talent and shaping a more inclusive future of work. By providing education and opportunities, we aim to increase the representation of disadvantaged groups in the data economy.
Programme Highlights
- Duration: 8th April 2024 – 12th July 2024
- Applications: 146 aspiring candidates applied
- Shortlisted: 47 completed initial task and were shortlisted
- Completion: 32 successfully completed the programme.
Key Achievements
Database Management (SQL)
Our Work Experience team contributed to the Datakirk Retail Store CRM project. They:
- Designed the database schema for customers, sales orders, products, categories, and sales representatives.
- Implemented the schema in RDBMS like MySQL, SQL Server, or PostgreSQL.
- Inserted sample data and developed SQL queries for CRM operations.
- Enforced data integrity with constraints and triggers.
- Created views and stored procedures to enhance database performance.
Data Analysis
The team analysed the Scottish Government’s Export Statistics Scotland. They:
- Imported datasets into tools like Excel, Google Sheets, or Python.
- Produced comprehensive reports in PDF format, with annotated screenshots explaining their calculations.
Data Visualisation
The team tackled a client brief involving pharmaceutical product formularies. They:
- Created a relational database from various data sheets.
- Developed a query to filter and extract client-specific data.
- Generated visualizations to answer key client questions about formulary updates and availability indexes.
- Mapped the availability of a specific drug across the UK and analysed regional trends.
Data Engineering
In the Scottish Housing News Analytics project, the team:
- Established a data repository using Microsoft Bing Search API and Azure Data Factory.
- Transformed raw data into structured formats using Spark Notebooks in Synapse Data Engineering.
- Performed sentiment analysis and created Power BI dashboards for data visualisation.
Machine Learning
The team built machine learning models using datasets like Customers, Iris, Wine, Titanic, and MNIST. They:
- Used Python packages such as pandas, matplotlib, and scikit-learn.
- Serialized models for deployment and set up environments using cloud platforms or containerization tools.
- Deployed models as RESTful APIs or within containerized environments and also through Azure.
Natural Language Processing (NLP)
The Work Experience Team developed a sentiment analysis model for customer reviews. They:
- Classified reviews into positive, negative, or neutral categories.
- Provided insights into customer satisfaction and areas for improvement.
AI Application Development
Finally, the team created a chatbot for the Scottish Ethnic Minority Talent Summit & Festival using Microsoft Power Virtual Agent and Azure. In order to :
- Enhance attendee engagement by providing quick access to event information.
- Assist with inquiries related to the event schedule, speakers, venue details, and registration.
Celebrating Success
This program has been a testament to the incredible potential of our interns and their dedication to advancing their skills in Data & AI. We are immensely proud of what they have achieved and excited to see them apply their knowledge in their future careers.
Thank You!
A big thank you to our expert mentors, dedicated participants, and everyone who supported this journey. Together, we are shaping a brighter and more inclusive future for the data economy.
Stay Connected
Stay tuned for more updates on our incredible journey and achievements! Follow us for more insights and stories.
#Datakirk #DataScience #AI #MachineLearning #Internship #DataVisualization #DataAnalysis #NLP #SQL #AIApplications #WorkExperience #FutureOfWork #DiversityInTech #CelebratingSuccess
