Freelancer logo How It Works Browse Jobs
Log In Sign Up
Post a Project
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$10 USD / hour
Flag of EGYPT
hurghada, egypt
$10 USD / hour
It's currently 1:48 PM here
Joined May 15, 2016
0 Recommendations

Daniel K.

@daniel3emad

 0.0 (0 reviews)
0.0
0.0
0%
0%
$10 USD / hour
Flag of EGYPT
hurghada, egypt
$10 USD / hour
N/A
Jobs Completed
N/A
On Budget
N/A
On Time
N/A
Repeat Hire Rate

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
See all Python Developers in Egypt

Contact Daniel K. about your job

Log in to discuss any details over chat.

Portfolio

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

Reviews

Changes saved
No reviews to see here!

Experience

Regional Concept Developer

Eva Cosmetics
Mar 2020 - Oct 2022 (2 years, 7 months)
• 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
Dec 2018 - Mar 2020 (1 year, 3 months)
• 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.

Education

Bachelor of Pharmacy

The German University in Cairo, Egypt 2013 - 2018
(5 years)

Qualifications

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

Contact Daniel K. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Top Skills

Python
Data Processing
Excel
SQL
Web Scraping

Browse Similar Freelancers

Python Developers in Egypt
Python Developers
Data Processing Executives
Excel Experts

Browse Similar Showcases

Python
Data Processing
Excel
SQL
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo United Kingdom / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App About About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers Terms Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges Partners Escrow.com Loadshift Warrior Forum Apps Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.