Logo de Freelancer Cómo funcionaBusca trabajos
Iniciar sesión Registrarse
Publica un proyecto
Foto de portada de perfil
Ahora estás siguiendo a
Error al seguir a usuario.
Este usuario no permite que los usuarios lo sigan.
Ya estás siguiendo a este usuario.
Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.
Dejaste de seguir correctamente a
Error al dejar de seguir al usuario.
Has recomendado exitosamente a
Error al recomendar al usuario.
Algo salió mal. Por favor, actualiza la página e intenta de nuevo.
Email verificado correctamente.
Avatar del usuario
$10 USD / hora
Bandera de EGYPT
hurghada, egypt
$10 USD / hora
Aquí son las 10:28 p. m.
Se unió el mayo 15, 2016
0 Recomendaciones

Daniel K.

@daniel3emad

 0,0 (0 comentarios)
0,0
0,0
0%
0%
$10 USD / hora
Bandera de EGYPT
hurghada, egypt
$10 USD / hora
N/A
Trabajos finalizados
N/A
Dentro del presupuesto
N/A
A tiempo
N/A
Tasa de recontratación

Data Analyst | Data Processing | Python Developer

I utilize my knowledge with data to help clients achieve their business goals. Client satisfaction is my highest priority and I aspire to achieve it through professional communication and delivering high quality output tailored to client's needs in a timely manner. Skills: - Python (Pandas, NumPy, Matplotlib) - SQL - Tableau - Excel - Data Cleaning - Data Visualization - Exploratory Data Analysis - Statistics
Freelancer Python Developers Egypt
Ver todo Python Developers en Egypt

Contacta Daniel K. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Portafolio

10972283
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
10910300
A dashboard was created using Tableau to visualize Youtube data in the US. Top trending videos and channels were visualized along with most liked and disliked categories.
Youtube Data Visualization with Tableau
10910234
In this project A/B test results for a landing page was analyzed using Pandas. The probability of conversion of customers who are served old vs. new landing page was calculated. In order to perform this statistical analysis, techniques such as sampling distribution and hypothesis testing were used. Also p-value was calculated to know the significance of the results.
Landing page A/B test results Statistical Analysis
10907767
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
10907615
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
10896767
In this program, I learned advanced Data Analysis concepts and gained hands on experience. I learned to query databases through SQL and applied this skill on "Digital Music Store Data Analysis" project. I also learned statistics and hypothesis testing, which helps in decision making and A/B testing. In addition, was trained on data visualization using Tableau.
Data Analysis Advanced Nanodegree by Udacity
10972283
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
The purpose of this project was to create an Excel sheet to track optics lab services for an optics store. The services the lab provides to the store are recorded in sheet 2 of the excel file with their prices. In sheet 1 "Main" each row represents an optics job the store requests from the lab. The user checks checkboxes that represents the needed services for this job. When this happens, the date is automatically populated in the first column and the total cost of the job is calculated in the last row. A macro was created to automatically create checkboxes in the middle of selected cells and linking them to the underlying cells in order to use those cells to make the date population and cost calculation formulas. Another macro was also used to convert cells with automatically populated dates to static upon closing the document because the TODAY() function will always evaluate to current day and will not be useful to keep track of past optics jobs.
Excel Macros & VBA Project
10910300
A dashboard was created using Tableau to visualize Youtube data in the US. Top trending videos and channels were visualized along with most liked and disliked categories.
Youtube Data Visualization with Tableau
10910234
In this project A/B test results for a landing page was analyzed using Pandas. The probability of conversion of customers who are served old vs. new landing page was calculated. In order to perform this statistical analysis, techniques such as sampling distribution and hypothesis testing were used. Also p-value was calculated to know the significance of the results.
Landing page A/B test results Statistical Analysis
10907767
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
In this project a dataset from a digital music store was queried using SQL. These queries required joining tables, grouping data, using conditions and sorting data. After that the data (in the form of CSV) resulted from each query was plotted using Microsoft Excel for visualization and extracting insights. The findings would then be collected and presented in a PowerPoint presentation.
Explore Digital Music Store data using SQL
10907615
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
In this Jupyter Notebook, a dataset about medical appointments of patients in Brazil was processed and investigated, The dataset was assessed and cleaned using Pandas. After that it was investigated for the correlation between patients gender, age, age group, medical condition and whether or not they show up to their medical appointments. In this Exploratory Data Analysis Pandas was used to work with the dataset and manipulate it and Matplotlib was used to plot charts for better results visualization. Finally, a conclusion was drawn at the end of the report and the cleaned dataset was exported as a CSV file.
Medical appointment no-shows in Brazil
10896767
In this program, I learned advanced Data Analysis concepts and gained hands on experience. I learned to query databases through SQL and applied this skill on "Digital Music Store Data Analysis" project. I also learned statistics and hypothesis testing, which helps in decision making and A/B testing. In addition, was trained on data visualization using Tableau.
Data Analysis Advanced Nanodegree by Udacity

Comentarios

Cambios guardados
¡No hay comentarios para ver aquí!

Experiencia

Regional Concept Developer

Eva Cosmetics
mar 2020 - oct 2022 (2 años, 7 meses)
• Analyzed product and market research to innovate new brands and product lines and introduce them to the market. • Worked with more than 4 different fellow teams in order to convert product ideas into physical products in the market.

Regional Junior Concept Developer

Eva Cosmetics
dic 2018 - mar 2020 (1 año, 3 meses)
• Delivered in-depth research and analysis reports on 5 - 4 new trending concepts per year. • Follow up the concept development process to ensure timely delivery of each milestone.

Educación

Bachelor of Pharmacy

The German University in Cairo, Egypt 2013 - 2018
(5 años)

Calificaciones

Data Analysis Advanced Nanodegree

Udacity
2022
In this program, I learned advanced Data Analysis concepts and gained hands on experience. I learned to query databases through SQL and applied this skill on "Digital Music Store Data Analysis" project. I also learned statistics and hypothesis testing, which helps in decision making and A/B testing. In addition, was trained on data visualization using Tableau.

Data Analysis Professional Nanodegree

Udacity
2021
In this Nanodegree program, I had hands-on experience in Python programming and acquired intermediate knowledge on popular data libraries in Python such as NumPy and Pandas. Also I created an Analysis report on "Medical Appointments no-show in Brazil" using Jupyter Notebooks.

Data Analysis Challenger

EgyptFWD
2021
Awarded Data Analysis Challenger Certificate as a first step in the Data Analysis track provided by EgyptFWD in collaboration with Udacity

Contacta Daniel K. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Verificaciones

Freelancer preferente
Identidad verificada
Pago verificado
Teléfono verificado
Email verificado
Facebook conectado

Principales habilidades

Python
Data Processing
Excel
SQL
Web Scraping

Explorar freelancers similares

Python Developers in Egypt
Python Developers
Data Processing Executives
Excel Experts

Explorar galerías similares

Python
Data Processing
Excel
SQL
Usuario anterior Usuario siguiente
¡Invitación enviada correctamente!
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Logo de Freelancer Argentina / Español Ayuda y soporte Freelancer CategoríasProyectos Concursos Freelancers Empresarial MembresíaPrograma de Freelancers Preferentes Gestión del proyecto Trabajos localesPhoto Anywhere GaleríaAPI para desarrolladoresVerifícate Software de escritorio Información Quiénes somos Cómo funciona Seguridad Inversionista Mapa del sitio Historias NoticiasEquipoPremiosComunicados de prensaEmpleos Términos Política de privacidadTérminos y condicionesPolítica de derechos de autorCódigo de conductaCargos y TarifasSociosEscrow.comLoadshiftWarrior Forum Apps Logo de "App Store" de AppleLogo de Google Play
Falló el copiado al portapapeles. Intenta de nuevo después de ajustar tus permisos.
Copiado al portapapeles.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.