Excel Expert - SQL - Web DEV - Data Analyst (>8 years' experience)
Hello, I'm Koly, I have a degree in computer science and engineering from ENSA. I worked for more than 8 years as a Web Developer, Web Project Manager, SEA Consultant and Data Analyst. For 5 years, in parallel with my professionnal activities, I have devoted myself to the world of online education because I am quite motivated by the dissemination of knowledge. I have experience giving online courses to students and professionals...
Excel Expert - SQL - Web DEV - Data Analyst (>8 years' experience)
Hello, I'm Koly, I have a degree in computer science and engineering from ENSA. I worked for more than 8 years as a Web Developer, Web Project Manager, SEA Consultant and Data Analyst. For 5 years, in parallel with my professionnal activities, I have devoted myself to the world of online education because I am quite motivated by the dissemination of knowledge. I have experience giving online courses to students and professionals. I like to organize lessons according to the needs of each student, I will be happy to help you achieve your goals! 👋🏻
Here are my areas of intervention:
Programming languages :
✅ Learn C language.
✅ Create static websites with HTML & CSS.
✅ Create dynamic websites with PHP&MYSQL.
✅ Query databases with SQL
✅ Learn programming with Python
✅ Learn programming with VBA
Master Microsoft Excel :
✅ EXCEL from A - Z (beginner level)
✅ EXCEL from A - Z (advanced level)
Practical EXCEL for Data Analyst:
✅ Create reports (advanced formulas, PivotTables)
✅ Create Dashboards
Microsoft Power BI Data Analyst training:
✅ What is Business Intelligence (BI) ?
✅ Prepare data (Power Query)
✅ Model data (Star Schema, DAX)
✅ Visualize and analyze data
✅ Deploy and maintain assets
Tools: Power BI Desktop, Power Query, DAX, Power BI Service.
Relational databases:
✅ Database modeling (E/R, Merise, UML)
✅ Master ACCESS (tables, queries, macros, etc.)
✅ Master MySQL & PostgreSQL DBMS
Creation of Websites without technical knowledge:
✅ Master the WordPress CMS
✅ Learn to create Showcase Sites (company, institution, NGO, medical office, Hotel, Restaurant, construction, etc.)
✅ Learn how to create landing pages
✅ Learn to create E-commerce Sites (woocommerce)
NB: Practically oriented training.
Learn how to deploy ERP/CRM Dolibarr :
✅ Learn how to integrate Dolibarr ERP/CRM into any company.
✅ Learn how to create Dolibarr modules/extensions.
Become a CMS Webmaster:
✅ Job of the CMS Webmaster
✅ Web technologies (HTML, CSS, PHP, MYSQL, ...)
✅ Master web hosting techniques with Cpanel / WHM
✅ Master domain name management techniques
✅ Master the WordPress CMS to create and manage all types of websites ( Portals, E-commerce).
✅ Master the fundamentals of Web marketing (SEO, SEA, SMO)
Webmarketing / Digital Marketing training:
✅ Get started with Web marketing
✅ Learn Search Engine Optimisation (SEO)
✅ Learn Search Engine Advertising (SEA) with Google Ads
✅ Master E-mailing (Mailchimp, mailpoet, ...)
✅ Learn Social Media Marketing (Facebook Ads, etc.)
✅ Learn Web Analytics with Google Analytics
Web Project Management:
✅ Waterfall Methodology
✅ Learn about agile methods (SCRUM)
