Karim El Otmani

Data Specialist & Excel Master

I transform complex data into interactive dashboards and automated solutions that drive decision-making and optimize business processes.

Discover My Projects

Hello, I'm Karim.

Passionate about problem-solving, I specialize in creating tools in Excel and Power BI to make data clear, accessible, and actionable. My goal is to build effective solutions that eliminate manual tasks, ensure reliable reporting, and provide valuable insights for business growth. Having worked at Amazon and as a freelancer, I know how to adapt to various needs and deliver concrete results.

Advanced Excel Power Query & Power Pivot VBA & Macros Power BI Data Analysis Automation

My Main Projects

Here is a selection of projects that illustrate my expertise in dashboard creation, analysis, and automation.

Operational Analysis

Daily Performance Dashboard | Amazon

Created an automated dashboard to analyze team performance and detect outliers (missed calls, extended breaks). This tool allowed managers to get a comprehensive overview and drill down into details to make informed decisions.

Key Skills:

Dashboard Building Automation KPI Analysis

Business Intelligence

Sales & Conversion Tracking | Fitness Coach

Developed a comprehensive dashboard for a coach selling programs on Instagram. The solution tracks conversion rates by closer, identifies top-performing programs, and analyzes trends to optimize sales strategy.

Key Skills:

Interactive Dashboard Sales Analysis Visualization

Market Research

Competitive Analysis | TikTok Shop Launch

A scraping and analysis mission of a competitor's products (Lancôme) for a client launching their TikTok shop. I provided a detailed report with top-rated products and strategic proposals for their market entry.

Key Skills:

Web Scraping Data Analysis Reporting