Below, you will find all projects.
You can access to the projects by clicking on their logos !

Web projects

McSoft.online

Starting date :

January 2023

Comment :

McSoft is an association of Airsoft. This website gather all the McSoft informations (contacts, social networks...) for the beginners who wants to join the team, to contact us and to play with us.

Acquired skills :

> Manage data of the users with the GDRP
> Use of HTML, CSS

Color PUN.fr

Starting date :

May 2022

Comment :

For the COLOR PUN 2022 of Niort, I made the website with all the informations about the COLOR PUN. The pictures of the previous COLOR PUN, the map of the run, you will find everything about the COLOR PUN. The COLOR PUN is a running organized by the ADEN in Niort.

Acquired skills :

> Use of HTML, CSS, PHP
> Creation of a public website

ShareAndPost.fr

Starting date :

June 2021

Comment :

ShareAndPost is a personnal project. This website is a social network where the user can add friends, post pictures, files... On this social network, you will find many services like a chat between users, a marketplace and much more. All this services in one platform.

Acquired skills :

> Use of HTML, CSS, PHP
> Administration of a database with PhpMyAdmin

ShareShopping.fr

Starting date :

May 2021

Comment :

This is the final project of my first year of statistics & business intelligence. This project was made in 5 days. In this project, we build a web site. This website is a 'shopping website'. You can create baskets and other persons can purchase products form your basket. Don't hesitate to visit this website on ShareShopping.fr

Acquired skills :

> Use of HTML, CSS, PHP, PhpMyAdmin
> Create a website be destined to be deployed on a http server
> Create and administrate a database

Lulubull.net

Starting date :

February 2021

Comment :

Lulubull.net is a sharing platform. In this platform, you can share files with any users. This is also a streaming platform.

Acquired skills :

> Use of HTML, CSS, PHP
> Send files with the help of PHP

Ecweesco.fr

Starting date :

May 2020

Comment :

This project was made when I was to the High School. It was the final project before my High School Diploma.

Acquired skills :

> Use of HTML, CSS
> Present a project on a static HTML page

Python projects

Migration of data to / from NoSql

Starting date :

November 2023

Comment :

In this project, by group of 2, we were incharge to migrate data from a Sql environment to a NoSql environment. We use Python to convert Sql request to NoSql request (Pipeline...).

Acquired skills :

> Use of MongoDb (Compass, Atlas)
> Learn the use of NoSql

Creation of API RESTful

Starting date :

April 2023

Comment :

This project was made in group of 3. We needed to create an API REST to gather data in a database of the social security in France. We also created the database.

Acquired skills :

> Use of Github, development of an API RESTful
> Knowledges about the object-oriented programming
> Conversion of dbf file

Web scraping

Starting date :

January 2023

Comment :

In this project, I have to web scrap the data of a web site. With the help of Python, I produce an interactive map and built an algorithm to gather data in a web site. We also learn the use of an API to gather data form a database.

Acquired skills :

> Use of Python (BeautifulSoup...)
> Knowledges about the process of Web Scraping

Connected vegetable garden

Starting date :

September 2022

Comment :

This project was started on September 2022 and finished in March 2023. Made by a group of 5, we has been contacted by a firm named "NeoSoft" and this firm has the need to transform his vegetable garden. With Python, we need to connected their vegetable garden. With the installation of a weather channel, we manage the collected data into a database and we produce a dashboard to predict the weather in the future, to upgrade the evolution of the vegetables.

Acquired skills :

> Use of various IT tools (Putty, MongoDb, Python, Recursivity...)
> Understanding of the need of a professional
> Presentation of the context to an audience that does not know it

Managing a database

Starting date :

March 2022

Comment :

This project begin with a creation of a conceptual data model (CDM) with loopingMcd and afer that, import the SQL script into PhpMyAdmin. After that, we import data with the help of SQL requests. Python was used for this project. We created a Python script with a GUI (Tkinter, mysql-connector...) that automatically update the database with Csv files. Finally, we gather differents data with SQL requests. I was alone on this project. EasyPhp was very helpful on this project.

Acquired skills :

> Use of Python, SQL, LoopingMcd, EasyPhp, PhpMyAdmin
> Create and insert data into a database
> Create a Python script to automatically insert new data with csv files
> Create a GUI (Graphics user Interface)
> Use of Auto-py-exe (pyInstaller) to convert the file in a exe file

JsonToCsv

Starting date :

November 2021

Comment :

JsonToCsv is a project to convert a Json file to a Csv file. The conversion work for only 1 Json file.

Acquired skills :

> Use of Python
> Convert a Json file to a Csv file

R projects

Estimation by sampling

Starting date :

May 2022

Comment :

On this project, we was 2 and we made une estimation on the Belgium inhabitants. With the help of r, we calculate many indicators. For example, confidence interval, p-value... You will find a r script and a study report.

Acquired skills :

> Use of r
> Make an estimation with a data set in R

Prediction of Dengue fever

Starting date :

April 2022

Comment :

This project was to predict the total cases of Dengue fever in 2007 with the helps of multiple variables. With the help of the variables of the year 1991 to 2006, we had to predict the total cases of Dengue fever of 2007. We use a linear regression to do that.

Acquired skills :

> Use of R
> Do a linear regression and use 2 functions of R (preidct, model)

VBA projects

Terrastid

Starting date :

June 2022

Comment :

This project is the final project of my first year (repetition year) of study. The aim of this project is to visualize the distribution of the interships of many training of the Poitiers university. You can select one or many training, and Terrastid is able to give you many indicators (number of internship...) and give the distribution of the abroad internships on a world map.

Acquired skills :

> Use of VBA, Excel
> Make a tool to visualize an important data set (Internships made by the students)

Calculo'Stid

Starting date :

December 2021

Comment :

Calculo'Stid is a project to calculate your mean of the formation 'statistics and business intelligent'.

Acquired skills :

> Use of VBA, excel
> Create an ergonomic Excel file
> Create a GUI (Graphics user Interface)

Minestid

Starting date :

January 2021

Comment :

MineStid is an Excel project. This project was realized in my first year of university.

Acquired skills :

> Use of VBA, excel
> Create a mini-game with the theme of Minecraft with Excel

Dataviz projects

Conception of decision-making tool

Starting date :

December 2023

Comment :

In this project by group of 4, we generated data with Mockaroo on dental clinic and we use ETL tools to prepare the data and we answer to multiple problematics with dataviz on PowerBi. The data have been stored in a Oracle database server and not in local.

Acquired skills :

> Use of SQLDeveloper, Talend, PowerBi
> Answer to multiple problematics with graphs and of generated and prepared data

Qliksense Dataviz

Starting date :

October 2023

Comment :

In this project, I made a dataviz on a dataset about cars accidents in France (open data). I was incharge to clean the data in Qliksense and think for a problematic (In which department is the most dangerous to drive ?) and answer it with a conclusion.

Acquired skills :

> Use of Qliksense Cloud
> Creation of a consistent dataset and a dataviz to answer to a problematic

Dataviz Day 2022

Starting date :

May 2022

Comment :

On this day, we made a datavisualisation with the software Tableau desktop. This study was realized with 4 other classmates, on quality of the air in France.

Acquired skills :

> Use of tableau desktop
> Give a problematic and answer

Dataviz Day 2021

Starting date :

May 2021

Comment :

On this day, I made a web site who present a study. This study was realized with 4 other classmates, on the renewable energies.

Acquired skills :

> Use of HTML, CSS, PHP
> Create a website to be used for an oral presentation

Study reports

Forecast on stock exchange

Starting date :

April 2023

Comment :

In this project, I produce a report with forecast on Canadien stock exchange. With the help of a Excel file with economics indicators, I was able to analyze these data and produce differents charts and choose between differents models (Exponential, Linear...)

Acquired skills :

> Choose models to predict future (Exponential, linear...)
> Production of charts to predict the next year on Canadian stock exchange

Managing data with GDRP

Starting date :

November 2022

Comment :

This project was made in group of 3. We need to imagine a firm with a customer. The customer ask a couple of questions about the way we use theyre data and we produce a report with a lot of explanation about the General Data Protection Regulation (GDRP).

Acquired skills :

> Knowledges about the General Data Protection Regulation (GDRP)
> Contextualization with an imaginary firm

Performance indicators

Starting date :

May 2022

Comment :

On this project, we established many indicators with Excel on the firm Poujoulat. With the help of a intermediate management balance, we made a study report.

Acquired skills :

> Use of Excel
> Increasing the skills in management and accounting

Social protection in the United States

Starting date :

May 2022

Comment :

On this project, we chose a subject and we made a study report. We chose the social protection in the USA.

Acquired skills :

> Study of a abroad subject
> Study of a abroad subject (Social protection in USA)

Food Survey

Starting date :

January 2022

Comment :

This project was made with multiple steps. Firstly, we had to gather answer on the food habits of the Niortais students and after that, build a report.

Acquired skills :

> Use of sphinx
> Create a report with graphics and statistics on the collected data of a survey

Survey on inhabitants of Paris

Starting date :

November 2021

Comment :

This study was made on the inhabitants of Paris. We look for many indicators on many district of Paris and we had to give many solutions to reduce unemployment.

Acquired skills :

> Use of Excel
> Create a study report with a data set of the INSEE

Phone survey

Starting date :

April 2021

Comment :

This project was made into 2 days. Louis Michelangeli has participated in this project. This project was made to show the using time of students on their smartphones. We also use the software Sphinx.

Acquired skills :

> Use of sphinx
> Create a report with data collected on a survey

Video projects

C'est pas sourcé

Starting date :

May 2021

Comment :

On this project, we were 3 classmates. On this video, we present a higher education establishment.

Acquired skills :

> Use of Sony Vegas Pro
> Collect data, summarize and presents them into a parody video

Talend projects

Data in datawarehouse

Starting date :

January 2023

Comment :

This project was made in group of 3. We needed to integrate data into a datawarehouse with the help a Talend. After that, we produce a couple of charts with PowerBi and we produce a report.

Acquired skills :

> Use of Talend, PowerBi, SQLDeveloper
> Knowledges about the process of ETL (Extract Transform Load)

SAS projects

Multivariate analysis reporting

Starting date :

March 2023

Comment :

In this project, I made an algorithm on SAS to produce analysis (ACP, Descriptives Statistics...) with a macro. The macro will adapt every Excel files. And I produce charts on PowerBi on the same project with a database that we transform with the help of Power Query. This project was not completed.

Acquired skills :

> Use of Macro in SAS, Power BI, Power Query
> Knowledges about the process of principal component analysis (ACP in French)

Other projects

Creation of a map "Bordeciel"

Starting date :

March 2020

Comment :

In this project, I reconstitute my high school in a software of 3d modeling. The map can be used in the game Garry's Mod..

Acquired skills :

> Use of Hammer editor
> Make a 3D model of a building