We are proud to announce that ensquad Ltd. will be closing shortly so that the team can focus on a new joint venture LobesLab Ltd. together with Business Leaders Malta. We are really happy with this 2-year experience and are grateful to all those that supported us, clients and family.
Check-out our launching article here.
ensquad Ltd. has sent one of its founders, Frankie Inguanez, to the SME Internationalisation and Export Management Course, also known as Go Global. This course is organised by TradeMalta together with Malta University Consulting and supported by HSBC.
The course was made up of eleven sessions which were either panel discussions by entrapreneurs or lectures by industry professionals addressing topics such as eMarketing, Legal & Contracting Issues, Market Research and more.
This course is part of recent developments underway at ensquad more of will which will be announced shortly.
I have just finished successfully my PhD studies in Integrative Medicine with full points in my thesis / dissertation. The practical research for my dissertation was done in Malta and it involved quite some complex before – intermediate – after results of the effects of the treatment protocol on the individual group members in a workplace group matrix field.
Dr. Claudia Schembri-Heitmann, Ph.D. in Integrative Medicine (IQUIM, Hawaii), HP, Germany / Malta
When all the work was finished, it became very clear that only a top professional statistician could solve this challenge of presenting the data in a professional visual way for me.
Very luckily, while discussing my problem with some associates, someone recommended “ensquad Ltd”. As soon as I contacted the firm, I was immediately given the impression of top professionality with their response and after our first introductory meeting I was already decided that I could not be in better hands. They suggested and designed a very practical way for calculating and analysing my complicated data on different levels, both for the individuals, the specific group of participants and also in an inter-group comparison. “ensquad Ltd” put together the whole analysis and results as a written report which included data tables and charts in a visual, simple, yet very strong manner. This definitely made all the difference in the evaluation and presentation of the dissertation. “ensquad Ltd” was also very supportive to answer my questions relating to the data and statistical analysis in a language that I was able to understand.
I would definitely and strongly recommend the “ensquad Ltd” team and their services to anyone seeking professional support with their data and statistics.
We are proud to have formed part of the Microsoft BizSpark programme and are grateful to Microsoft for the support they have given us. The new Startup programme is very interesting and thanks to Mary Downing for organising such an informative meeting at the Microsoft Innovation Center. Highlights of the event were covered in a the news by TVM.
An anonymised dataset from a Czech bank, known as the Berka Dataset was downloaded from here. This dataset was prepared by Petr Berka and Marta Sochorova. The data about clients and their accounts include:
Each of the above is stored in a separate CSV file, which was loaded to PowerBI. Data cleaning was performed on various relations, mainly translating Czech to English, and date conversion. The relationships between each table were then identified. More information about this dataset can be found on data.world and here.
A report with a number of pages highlighting some aspects from each relation was then created.
Today we celebrate our first birthday. This year was mostly taken up by properly setting up as a company, registering a trademark, building the brand and connections. We thank our clients for believing in us and look forward to strengthening our relationships. More projects and plans in the pipeline and looking forward to a great second year. Thanks to Sephora Inguanez for a wonderful and delicious cake.
Wishing everyone a Merry Christmas and a Happy New Year.
After publishing our BI dashboard tool based on the MIA public data set we would like to provide an overview of the data cleaning process involved and some interesting insights.
The available data from the respective websites (MIA and NSO) is in PDF and XLS formats and was first migrated to an SQL database. Some exploratory analysis was made and it was found that across different years some variations in the same airlines, cities, countries, and airports were found and needed to be addressed. In some cases, such as in Air Serbia, there were companies that re-branded and changed the name, this required some research and consolidation. In two particular cases, there were errors in summations and thus we double checked and made our own summations. Therefore, some yearly and monthly summations were calculated rather than quoting them as is from the reports. In some cases, the values for some months were missing but the yearly total was provided, we, therefore, distributed the difference across the missing months since there were only 2 cases.
After working on this tool and publishing it we would like to draw attention to a few interesting patterns.
We would like to note that the data is as found on the MIA and NSO sites and ensquad Ltd. does not take responsibility for the correctness of said data. We would also like to note that this tool should not be considered in isolation, meaning that no concrete conclusion can be made without further investigation. Should you have any queries feel free to contact us on info@ensquad.frankieinguanez.com
We are proud to launch a free public Business Intelligence (BI) dashboard based on the Malta International Airport (MIA) public data of aircraft and passenger movements. This showcases the importance of data visualization, which leads to insights and reflection to ask very valid questions. In this article, we shall go through the different sections of the tool and in a subsequent article, we shall give an overview of the cleaning process and some insights.
The report contains passenger and aircraft movements from MIA between 2005 and 2016 with the possibility of filtering by Year, Country, and Airport. The Airline market share is available from 2004 until 2016 with the possibility of filtering by Airline and Year. The passenger to aircraft ratio is a metric that measures the aircraft occupancy rate, and we are providing it for the top 5 airlines with the possibility of filtering by year. The same metric is also provided for 5 airlines with the possibility of filtering by year and country.
Continue reading part 02 for insights from the dashboard.
We would like to note that the data is as found on the MIA and NSO sites and ensquad Ltd. does not take responsibility for the correctness of said data. We would also like to note that this tool should not be considered in isolation, meaning that no concrete conclusion can be made without further investigation. Should you have any queries feel free to contact us on info@ensquad.frankieinguanez.com
ensquad Ltd. is a Microsoft Bizpsark startup located at Skyparks Business Centre in Luqa. It is co-founded by Robert Abela, Alan Gatt, Frankie Inguanez and Luke Vella Critien. We specialise in offering Business Intelligence Solutions and Training. Today, we are launching our website, https://ensquad.frankieinguanez.com with more information about our services and team.
You must be logged in to post a comment.