Freelancer-logo
Log Ind Tilmeld dig
Slå et projekt op
UDFORSK
Business Analysis
Excel
Excel Macros
Excel VBA
Visual Basic
Profil coverbillede
Du følger nu
Fejl under følg af bruger.
Denne bruger har ikke tilladt andre bruger at følge dem.
Du følger allerede denne bruger.
Din medlemsskabsplan tillader kun at følge 0. Opgrader her.
Du følger nu ikke længere
Kunne ikke stoppe med at følge bruger.
Du har nu anbefalet
Kunne ikke anbefale bruger.
Noget gik galt. Forny venligst siden og prøv igen.
Email verificeret.
Brug Avatar.

Ihala D.

@TDRWork

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

Microsoft excel and Power BI Expert

$18 USD / Time
・
Flag for
Sri Lanka (7:46 PM)
・
Tilmeldt december 25, 2019
$18 USD / Time
・
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.
Verifikationer
Til tiden
100 %
Indenfor budgettet
100 %
Accept andel
100 %
Genansættelse andel
38 %
Freelancer Excel Experts Sri Lanka
Se alle Excel Experts i Sri Lanka

Portfolio-mappe

Portfolio-mappe

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
Ændringer gemt
5.0 · 12 Reviews
Bedømmelser
Brug Avatar.
Excel Data Cleanup - Email Filtering • $10 USD
The data sheet rearranged as requested and job was done ontime. Excellent communication and service since the job was done right in first attempt. Great Job.Thanks!
Lakshan M.
@lmadhuwantha91
•
Flag for
Colombo, Sri Lanka
•
14 timer siden
Del
A
Excel Financial Dashboard creating • $600 USD
Ihala is very professional and clever in his field of work.
Aran A.
@Aran2202
•
Flag for
Vancouver, Canada
•
3 måneder siden
Del
A
Excel VBA automation project • $50 USD
Good job on the Excel Automation.
Aran A.
@Aran2202
•
Flag for
Vancouver, Canada
•
5 måneder siden
Del
A
Data automation in Excel • $140 USD
Good job on the Data Automation
Aran A.
@Aran2202
•
Flag for
Vancouver, Canada
•
5 måneder siden
Del
A
Complete the automation in Excel • $100 USD
Good job at completing Pivot
Aran A.
@Aran2202
•
Flag for
Vancouver, Canada
•
5 måneder siden
Del
Erfaring
Data Processing with Excel and Power BI
okt., 2017 - Til stede
•
7 år, 1 måned
Freelancer
okt., 2017 - Til stede
•
7 år, 1 måned
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.
okt., 2017 - Til stede
•
7 år, 1 måned
Demand Planning Analyst
aug., 2016 - jul., 2017
•
11 måneder
Unilever Sri Lanka limited
aug., 2016 - jul., 2017
•
11 måneder
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.
Flag for
Colombo, Sri Lanka
aug., 2016 - jul., 2017
•
11 måneder
Uddannelse
University of Colombo
2013 - 2017
•
4 år
BSc Honours in Industrial Statistics and Mathematical Finance
Flag for
Sri Lanka
2013 - 2017
•
4 år
Kvalifikationer
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
Certifikationer
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Freelancer Orientation
Freelancer Orientation
Data Entry
Data Entry
Invitationen blev sendt!
Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Freelancer-logo Denmark / Dansk
Hjælp & Support
Freelancer
Kategorier Projekter KonkurrencerFreelancereEnterprise AI udviklingMedlemskabForetrukken Freelancer-programProjektledelseLokale jobsPhoto AnywhereFremvisningAPI for udviklereBliv VerificeretDesktop-app
 Om
Om osSÃ¥dan fungerer detSikkerhedInvestorSitemapHistorierI nyhederneTeamTildelte priserPressemeddelelserKarrierer
 Betingelser
PrivatlivspolitikVilkår og betingelserCopyright politikAdfærdskodeksGebyrer og afgifter
 Partnere
Escrow.comLoadshiftWarrior Forum
 Apps
Apple App Store logoGoogle Play-logo
Kopiering til clipboard fejlede. Prøv venligst igen efter justering af dine tilladelser.
Kopieret til udklipsholder.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.