Freelancer logo
Přihlásit se Zaregistrovat se
Zveřejněte projekt
OBJEVUJTE
Business Analysis
Excel
Excel Macros
Excel VBA
Visual Basic
Fotografie na titulní straně profilu
Nyní sledujete
Chyba při sledování uživatele.
Tento uživatel neumožňuje ostatním uživatelům, aby jej sledovali.
Tohoto uživatele již sledujete.
Váš členský plán povoluje pouze 0 sledovaných. Aktualizujte zde.
Úspěšně odebráno sledování
Při rušení sledování uživatele došlo k chybě.
Úspěšně jste doporučili uživatele
Chyba při doporučování uživatele.
Došlo k chybě. Obnovte stránku a zkuste to znovu.
E-mail byl úspěšně ověřen.
Avatar uživatele

Ihala D.

@TDRWork

monthly-level-three.svgverified-v2.svgpreferred-freelancer-v3.svg
5,0
13
4,1
4,1
100%

Microsoft excel and Power BI Expert

$18 USD / hodinu
・
Pochází z
Sri Lanka (3:26 odp.)
・
Připojen prosince 25, 2019
$18 USD / hodinu
・
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.
Ověření
Na čas
100 %
Dle rozpočtu
100 %
Přijmout sazbu
100 %
Opakovat nájemní sazbu
44 %
Freelancer Excel Experts Sri Lanka
Zobrazit všechny Excel Experts v 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
Změny byly uloženy
5.0 · 13 Reviews
Hodnocení
M
Macro creating project • $110 USD
He was very prompt and great with communication. He understood my concerns and worked with me step by step to get the best results.
May .
@mayh2
•
Pochází z
Hilliard, United States
•
před 16 dny
Sdílet
Avatar uživatele
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
•
Pochází z
Colombo, Sri Lanka
•
před 18 dny
Sdílet
A
Excel Financial Dashboard creating • $600 USD
Ihala is very professional and clever in his field of work.
Aran A.
@Aran2202
•
Pochází z
Vancouver, Canada
•
před 3 měsíci
Sdílet
A
Excel VBA automation project • $50 USD
Good job on the Excel Automation.
Aran A.
@Aran2202
•
Pochází z
Vancouver, Canada
•
před 5 měsíci
Sdílet
A
Data automation in Excel • $140 USD
Good job on the Data Automation
Aran A.
@Aran2202
•
Pochází z
Vancouver, Canada
•
před 6 měsíci
Sdílet
Zkušenosti
Data Processing with Excel and Power BI
říj, 2017 - Současnost
•
7 roků, 2 měsíce
Freelancer
říj, 2017 - Přítomnost
•
7 roků, 2 měsíce
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.
říj, 2017 - Současnost
•
7 roků, 2 měsíce
Demand Planning Analyst
srp, 2016 - čvc, 2017
•
11 měsíců
Unilever Sri Lanka limited
srp, 2016 - čvc, 2017
•
11 měsíců
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.
Pochází z
Colombo, Sri Lanka
srp, 2016 - čvc, 2017
•
11 měsíců
Vzdělání
University of Colombo
2013 - 2017
•
4 roky
BSc Honours in Industrial Statistics and Mathematical Finance
Pochází z
Sri Lanka
2013 - 2017
•
4 roky
Kvalifikace
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
Osvědčení
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Freelancer Orientation
Freelancer Orientation
Data Entry
Data Entry
Pozvánka byla úspěšně odeslána!
Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Freelancer logo Czech Republic / Čeština
Pomoc & Podpora
Freelancer
KategorieProjektySoutěžeFreelancersEnterpriseAl vývojČlenstvíProgram preferovaných freelancerůProjektový managementMístní nabídka prácePhoto AnywherePrezentaceAPI pro vývojářeNechte se ověřitDesktop aplikace
 Info
O násJak to fungujeZabezpečeníInvestorMapa stránekPříběhyV tiskuTým OceněníTiskové zprávyKariéra
 Všeobecné podmínky
Zásady ochrany osobních údajůVšeobecné podmínkyZásady ochrany autorských právEtický kodexPlatby a poplatky
 Partneři
Escrow.comLoadshiftWarrior Forum
 Aplikace
Logo Apple App StoreGoogle Play logo
Kopírování do schránky se nezdařilo. Zkuste to znovu po upravení vašeho přístupu.
Zkopírováno do schránky.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.