Mekki MOURADI

Data Analyst

Rabat, Maroc

Mekki MOURADI
mekkimouradi@gmail.com

À Propos

Data Analyst Junior avec une solide expérience en marketing numérique et des compétences approfondies dans l’utilisation de Microsoft Excel, SQL, Tableau Software et Python.

Excel Projects

Build Critical Path Visualizations in Excel and Tableau

Liens

Certificat

Compétences & Outils

Microsoft Excel
Tableau Software
Critical Path

Description du projet

Créer un Dashboard Interactif pour la Gestion de Projets via les éléments suivants :

  • Calcul du Chemin Critique
  • Création d’un Dashboard Interactif représentant le Chemin Critique

Objectifs de l'analyse

Créer et Visualiser un Chemin Critique Interactif
  1. Découverte du Dataset
Project TaskProject Task DetailPreceding TaskDependant TaskEarly StartEarly FinishLate StartLate FinishDUR (days)SlackFloatCritical PathFloatCritical Path
AContractDiscuss project scope- A014193314719Not Critical Path19Not Critical Path
A1ContractConfirm project scopeAA2142133407319Not Critical Path19Not Critical Path
A2ContractNegotiate priceA1A3212440433219Not Critical Path19Not Critical Path
A3ContractAgree to priceA2A4242543441219Not Critical Path19Not Critical Path
A4ContractFinalize contract termsA3A52535445410319Not Critical Path19Not Critical Path
A5ContractSign contractA4B353654551419Not Critical Path19Not Critical Path
BDomainResearch competitor namesA5B2364353607217Not Critical Path17Not Critical Path
B1DomainResearch keywordsA5B2434660633217Not Critical Path17Not Critical Path
B2DomainPropose domain namesB1B3465063674217Not Critical Path17Not Critical Path
B3DomainClient approves final nameB2B4505167681317Not Critical Path17Not Critical Path
B4DomainPurchase Domain NameE7C585968691310Not Critical Path10Not Critical Path
CHostingCompare options A5C1363955583219Not Critical Path19Not Critical Path
C1HostingPresent 3 options to clientCC2394158602119Not Critical Path19Not Critical Path
C2HostingSelect hostingC1C3414360622119Not Critical Path19Not Critical Path
C3HostingSecure HostingC2D 434562642119Not Critical Path19Not Critical Path
DCMSExplore Content Management SystemsA5D1454664651119Not Critical Path19Not Critical Path
D1CMSReview CMS plan with ClientDD2464965683219Not Critical Path19Not Critical Path
D2CMSLoad CMS into HostingD1F10495068691119Not Critical Path19Not Critical Path
EBrandingResearch Competitor BrandingA5D2363847492111Not Critical Path11Not Critical Path
E1BrandingBranding BrainstormDD2383949501111Not Critical Path11Not Critical Path
E2BrandingPresent 5 options to clientD, D1D3394050511111Not Critical Path11Not Critical Path
E3BrandingRevise branding looksD2D4404751587311Not Critical Path11Not Critical Path
E4BrandingPresent 3 branding options to the clientD3D5475058613111Not Critical Path11Not Critical Path
E5BrandingRevise final brand designD4D6505561665211Not Critical Path11Not Critical Path
E6BrandingPresent final designD5D7555766682211Not Critical Path11Not Critical Path
E7BrandingClient approves final design D6E575868691111Not Critical Path11Not Critical Path
FSite BuildPrepare Lofi WireframeA5E136403640430Critical Path0Critical Path
F1Site BuildPresent LoFI to ClientEE240414041110Critical Path0Critical Path
F2Site BuildReview Client contentE1E341484148730Critical Path0Critical Path
F3Site BuildCreate New ContentE2E448554855730Critical Path0Critical Path
F4Site BuildGather Social Media linksA5E855575557210Critical Path0Critical Path
F5Site BuildPresent HiFi Wireframe to ClientE2E757585758110Critical Path0Critical Path
F6Site BuildContent Accuracy checkE3E1358615861310Critical Path0Critical Path
F7Site BuildRevise WireframeE5E861666166520Critical Path0Critical Path
F8Site BuildActivate linksE4E1166686668210Critical Path0Critical Path
F9Site BuildFinal Wireframe Approval from ClientE7E1068696869110Critical Path0Critical Path
F10Site BuildImplement WireframeB4, C3, E9E1169706970110Critical Path0Critical Path
F11Site BuildPresent website to client for preliminary ReviewE10E1270717071110Critical Path0Critical Path
F12Site BuildRevise WebsiteE11E1371767176520Critical Path0Critical Path
F13Site BuildFinal Website presentationE12F76787678210Critical Path0Critical Path
GFinal AcceptanceMake client the senior adminstrator on the siteE13F178807880210Critical Path0Critical Path
G1Final AcceptanceRemove agency from siteFF280828082210Critical Path0Critical Path
G2Final AcceptanceAssign all copyrights to clientF1F382858285310Critical Path0Critical Path
G3Final AcceptancePresent final invoice to clientF2-85928592730Critical Path0Critical Path
  1. Calcul et Création du Chemin Critique
  1. Création du Dashboard Interactif représentant le Chemin Critique
Excel Projects