Logo Freelancer
Se connecter S'inscrire
Publier un projet
EXPLORER
Business Analysis
Excel
Excel Macros
Excel VBA
Visual Basic
Photo de couverture du profil
Vous suivez désormais
Erreur de suivi de l'utilisateur.
Cet utilisateur n'utilise pas les utilisateurs à le suivre.
Vous suivez déjà cet utilisateur.
Votre plan d'adhésion ne permet que 0 suivis. Améliorez ici.
Ne suit désormais plus
Erreur lors de l'arrêt du suivi de l'utilisateur.
Vous avez désormais recommandé
Erreur lors de la recommendation de l'utilisateur.
Une erreur a eu lieu. Veuillez rafraîchir la page et réessayer.
E-mail désormais vérifié.
Avatar de l'utilisateur

Ihala D.

@TDRWork

monthly-level-three.svgverified-v2.svg
5,0
11
4,0
4,0
100%

Microsoft excel and Power BI Expert

$18 USD / Heure
・
Drapeau de
Sri Lanka (9:15 PM)
・
Inscrit depuis le décembre 25, 2019
$18 USD / Heure
・
As an Excel specialist boasting over 7 years of proficiency in both Microsoft Excel and Google Sheets. Holding a degree in Industrial Statistics and Mathematical Finance from the esteemed University of [login to view URL] expertise also lies in the design Excel template, design Google sheets template, creating excel formulas and excel automation by using VBA/Power query. Here's what I can do for you: Streamline your workflow by automating Excel reports with VBA/Power Query. Develop custom Excel macros to enhance productivity and efficiency. Design visually appealing and functional Excel templates for various purposes. Engineer complex formulas to extract meaningful insights from your data. Provide comprehensive data analysis and reporting services. Execute meticulous data entry tasks and conduct web scraping as needed. I'm here to make your life easier.Don't hesitate to reach out and entrust your project to me today.
Vérifications
Dans les temps
100 %
Dans le budget
100 %
Taux d'acceptation
100 %
Taux de réembauche
43 %
Freelancer Excel Experts Sri Lanka
Voir tous les Excel Experts en Sri Lanka

Portfolio

Portfolio

12405858
Developed a highly interactive and customized Power BI dashboard designed to provide a comprehensive overview of sales performance. The dashboard offers detailed insights into sales data categorized by country, payment method, sales type, sales amount, sales quantity, and yearly and monthly performance trends. To ensure accurate and consistent reporting, I used Power Query to clean, transform, and standardize the raw data from multiple sources, preparing it for seamless integration into the Power BI model. Leveraging advanced DAX, I created dynamic measures to calculate critical metrics such as total sales, total quantity, sales growth, and year-over-year comparisons. These measures enabled the dashboard to generate real-time and actionable insights into sales trends and performance metrics. Additionally, calculated columns were implemented to derive additional data points required for detailed analysis, ensuring all business requirements were met. The dashboard features a user-frien
Sales Overview Power BI dashboard
12404714
Developed a tailored Power BI dashboard for a retail client, using advanced data modeling and DAX to transform complex sales data into valuable insights. Utilized Power Query to clean and standardize the data, ensuring accuracy across multiple sources. Designed dynamic measures, calculated columns, and interactive visuals, including slicers and drill-through features, for detailed, real-time data exploration. This custom solution enabled the client to efficiently track sales performance by payment method, order states and Product category, supporting data-driven decision-making and business growth.
Profitability Analysis Dashboard
12404651
I worked with a retail client who needed a Power BI dashboard to track and analyze sales data across various categories, including country, payment method, sales type, and yearly performance. Their main goal was to gain actionable insights to drive growth and optimize sales strategies. One of the challenges faced was the inconsistency in data formats from different sources, which made it difficult to analyze effectively. To overcome this, I used Power Query for data cleaning and standardization. I then built a comprehensive data model using DAX to create key metrics like revenue growth and sales performance. The final solution provided interactive visuals with filters and drill-through options, allowing the client to explore data by specific regions or payment methods, making it easier to identify trends and inform business decisions.
Sales Analysis Dashboard in Power BI
11709499
This project showcases the creation of an Excel-based project management template with a focus on timeline visualization using Gantt charts. It incorporates features such as conditional formatting and advanced Excel functions to provide a comprehensive solution for project planning and tracking. Users can efficiently manage tasks, allocate resources, and monitor project progress. By leveraging advanced Excel functionalities like conditional formatting and complex formulas for data analysis, the template enhances project visibility and facilitates informed decision-making throughout the project lifecycle.
Excel Project Management Template
11709543
In my recent project, I utilized Excel Power Query automation to streamline data management processes. Starting with a CSV file, I efficiently cleaned and formatted the data, ensuring its accuracy and consistency. Leveraging the capabilities of DAX (Data Analysis Expressions), I implemented complex calculations to derive valuable insights. This comprehensive approach not only enhanced efficiency but also facilitated informed decision-making. By integrating Excel Power Query automation into my workflow, I have successfully optimized data manipulation and analysis, paving the way for more effective project outcomes.
Excel Power Query Automation
11709585
In my recent project, I focused on creating advanced Excel formulas to enhance data analysis and decision-making processes. One such formula I developed is a complex nested IF statement: =IF(IF(B96*C76<=C73,"yes", "No")="No",IF(C$71>0,IF(C90>0,C$71/(C90*12),0),0)) This formula evaluates multiple conditions and returns a calculated result based on the specified criteria. Additionally, I designed a new Excel template to complement these formulas, ensuring an intuitive and user-friendly interface for efficient data input and analysis. Through this project, I aimed to improve productivity and accuracy in data-driven tasks, empowering users to make informed decisions with confidence.
Advanced Excel formula creation
12405858
Developed a highly interactive and customized Power BI dashboard designed to provide a comprehensive overview of sales performance. The dashboard offers detailed insights into sales data categorized by country, payment method, sales type, sales amount, sales quantity, and yearly and monthly performance trends. To ensure accurate and consistent reporting, I used Power Query to clean, transform, and standardize the raw data from multiple sources, preparing it for seamless integration into the Power BI model. Leveraging advanced DAX, I created dynamic measures to calculate critical metrics such as total sales, total quantity, sales growth, and year-over-year comparisons. These measures enabled the dashboard to generate real-time and actionable insights into sales trends and performance metrics. Additionally, calculated columns were implemented to derive additional data points required for detailed analysis, ensuring all business requirements were met. The dashboard features a user-frien
Sales Overview Power BI dashboard
12404714
Developed a tailored Power BI dashboard for a retail client, using advanced data modeling and DAX to transform complex sales data into valuable insights. Utilized Power Query to clean and standardize the data, ensuring accuracy across multiple sources. Designed dynamic measures, calculated columns, and interactive visuals, including slicers and drill-through features, for detailed, real-time data exploration. This custom solution enabled the client to efficiently track sales performance by payment method, order states and Product category, supporting data-driven decision-making and business growth.
Profitability Analysis Dashboard
12404651
I worked with a retail client who needed a Power BI dashboard to track and analyze sales data across various categories, including country, payment method, sales type, and yearly performance. Their main goal was to gain actionable insights to drive growth and optimize sales strategies. One of the challenges faced was the inconsistency in data formats from different sources, which made it difficult to analyze effectively. To overcome this, I used Power Query for data cleaning and standardization. I then built a comprehensive data model using DAX to create key metrics like revenue growth and sales performance. The final solution provided interactive visuals with filters and drill-through options, allowing the client to explore data by specific regions or payment methods, making it easier to identify trends and inform business decisions.
Sales Analysis Dashboard in Power BI
11709499
This project showcases the creation of an Excel-based project management template with a focus on timeline visualization using Gantt charts. It incorporates features such as conditional formatting and advanced Excel functions to provide a comprehensive solution for project planning and tracking. Users can efficiently manage tasks, allocate resources, and monitor project progress. By leveraging advanced Excel functionalities like conditional formatting and complex formulas for data analysis, the template enhances project visibility and facilitates informed decision-making throughout the project lifecycle.
Excel Project Management Template
11709543
In my recent project, I utilized Excel Power Query automation to streamline data management processes. Starting with a CSV file, I efficiently cleaned and formatted the data, ensuring its accuracy and consistency. Leveraging the capabilities of DAX (Data Analysis Expressions), I implemented complex calculations to derive valuable insights. This comprehensive approach not only enhanced efficiency but also facilitated informed decision-making. By integrating Excel Power Query automation into my workflow, I have successfully optimized data manipulation and analysis, paving the way for more effective project outcomes.
Excel Power Query Automation
11709585
In my recent project, I focused on creating advanced Excel formulas to enhance data analysis and decision-making processes. One such formula I developed is a complex nested IF statement: =IF(IF(B96*C76<=C73,"yes", "No")="No",IF(C$71>0,IF(C90>0,C$71/(C90*12),0),0)) This formula evaluates multiple conditions and returns a calculated result based on the specified criteria. Additionally, I designed a new Excel template to complement these formulas, ensuring an intuitive and user-friendly interface for efficient data input and analysis. Through this project, I aimed to improve productivity and accuracy in data-driven tasks, empowering users to make informed decisions with confidence.
Advanced Excel formula creation
Modifications enregistrées
5.0 · 11 Reviews
Commentaires
A
Excel Financial Dashboard creating • $600 USD
Ihala is very professional and clever in his field of work.
Aran A.
@Aran2202
•
Drapeau de
Vancouver, Canada
•
il y a 3 mois
Partager
A
Excel VBA automation project • $50 USD
Good job on the Excel Automation.
Aran A.
@Aran2202
•
Drapeau de
Vancouver, Canada
•
il y a 5 mois
Partager
A
Data automation in Excel • $140 USD
Good job on the Data Automation
Aran A.
@Aran2202
•
Drapeau de
Vancouver, Canada
•
il y a 5 mois
Partager
A
Complete the automation in Excel • $100 USD
Good job at completing Pivot
Aran A.
@Aran2202
•
Drapeau de
Vancouver, Canada
•
il y a 5 mois
Partager
D
Sales Reports Automation in Excel • $10 AUD
Ihala D did an excellent job on my project, delivering high-quality work ahead of schedule. Their professionalism, attention to detail, and effective communication made the entire process smooth. I highly recommend Ihala D and look forward to working with them again!
Donna K.
@DonnaKat
•
Drapeau de
Canberra, Australia
•
il y a 5 mois
Partager
Expérience
Data Processing with Excel and Power BI
oct., 2017 - Présent
•
7 ans, 1 mois
Freelancer
oct., 2017 - Présent
•
7 ans, 1 mois
I’ve been helping other business owners to develop their reports in a way that turns fast and simple. I’ve created excel reports, Excel macros and other types of analysis report to numerous clients. I will automate excel reports. create Excel Macros. develop Excel template. make excel formulas. Provide other data analysis and report. do data entry work and scraping.
oct., 2017 - Présent
•
7 ans, 1 mois
Demand Planning Analyst
août, 2016 - juil., 2017
•
11 mois
Unilever Sri Lanka limited
août, 2016 - juil., 2017
•
11 mois
As a Demand Planning Analyst focused on MIS, I specialized in data analysis and reporting to support the demand planning team. My role included preparing accuracy reports, conducting stock analyses, generating sales reports and other analysis reports. Effective communication and a proactive approach were key to fulfilling my responsibilities and contributing to the team's success.
Drapeau de
Colombo, Sri Lanka
août, 2016 - juil., 2017
•
11 mois
Formation
University of Colombo
2013 - 2017
•
4 ans
BSc Honours in Industrial Statistics and Mathematical Finance
Drapeau de
Sri Lanka
2013 - 2017
•
4 ans
Qualifications
Data Skills for Excel Professionals
2024
Corporate Finance Institute
The courses cover fundamental aspects, including Data Analysis in Excel, Power Query Fundamentals, and Power Pivot Fundamentals. The recommended pre-work for participants is to have a basic familiarity with Excel. The specialization aims to enhance professionals' proficiency in leveraging Excel for data driven decision-making and is a valuable resource for individuals seeking to sharpen their data skills in a corporate finance context.
2024
Data Science Foundations - Level 1
2022
IBM
This Professional Certificate provides comprehensive insight into the transformative potential of data science, analytics and big data bring to new applications in any industry.
2022
Excel for Sales Professionals
2021
LinkedIn Learning
Track, analyze, and then forecast sales efficiently and accurately using Microsoft Excel. Learn how to import your sales data into Excel. Then, see how to clean up that data by removing redundancies, fixing incorrect information, and applying formatting. Next, step through the various methods of analyzing sales data in Excel, from filtering and sorting to using Quick Analysis and slicers. Additionally, explore how to create a leaderboard, spot trends, forecast sales, create dashboards, and more.
2021
Certifications
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Freelancer Orientation
Freelancer Orientation
Data Entry
Data Entry
Invitation désormais envoyée !
Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Logo Freelancer France / Français
Aide & Assistance
 Freelance
CatégoriesProjetsConcours FreelancesEntreprise Développement d'IA AdhésionProgramme de Freelance PréféréGestion de projetEmplois locauxPhoto AnywherePrésentationAPI pour les développeurs Obtenir la certification Application Desktop
 À propos
À propos de nousComment cela fonctionneSécuritéInvestisseurPlan du siteHistoiresNouveautésÉquipeRécompensesCommuniqué de presseOffres d'emploi
 Termes
Politique de ConfidentialitéTermes et ConditionsPolitique de CopyrightCode de conduiteFrais et charges
Partenaires
Escrow.comLoadshiftWarrior Forum
 Applications
Logo d'Apple App StoreLogo Google play
Échec de copie dans le presse-papier, veuillez réessayer après avoir ajuster vos permissions.
Copié dans le presse-papier.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.