Koly
Insegnante verificato, moderato dal team di Classgap
92 lezioni
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)
