Celebrating the Success of the Datakirk UK Work Experience Programme!
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.
