Browse categories
Explore
Fiverr Pro
English
$
USD
I will transform data using power query, power pivot, mcodes, and dax
Microsoft Certified Excel Expert: Adding Value, Solving Data Problems
I'm a MICROSOFT CERTIFIED EXCEL EXPERT with 6+ years of experience in solving complex data problems and analyzing data using advanced tools like MS Excel, Power Query, Power Pivot, DAX, SQL, VBA, Macr...
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
About this Gig
Hi,
Handling messy data can be a real challenge. Being a Microsoft certified Excel expert with 5+ years of experience in data processing and analysis, I will automate data extraction, transformation, and analysis using Excel, Power Query, Power Pivot, and Power BI.
I offer:
- Data Extraction from any source including PDFs, Tables, CSV, APIs, databases, SQL, Oracle, & SharePoint etc.
- Data Transformation including text modifications, date & time manipulations, filtering data, & duplicates handling etc.
- Data manipulation with conditional logic, M-codes, custom functions, & error management.
- Consolidation using advanced merge and append with custom match criteria.
- Data modelling using power pivot, DAX measures, table connections, and logics.
- Data analysis and reporting via advanced story-based interactive dashboards with interconnected pivot tables, pivot charts, slicers, and timelines.
- Automated reports containing balance sheets, profit & loss, and cashflows.
- All power query and data analysis related assignments.
Let me automate your workflows & turn data into valuable insights.
Tags: Excel, Power Query, Power Pivot, Data Analysis, Data Modelling, Power BI, DAX, M-Codes, Assignment
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
•
Other
My Portfolio
Other Data Processing Services I Offer
FAQ
From which sources you can extract data and transform it?
I can extract data from virtually any data sources like Excel, CSV, PDF, text files, Access databases, APIs, Oracle data bases, and web scraping, etc.
Will you provide consultation and post-order support services?
Yes. I will provide consultations over calls and will continue to support even after order delivery.
I want customized solutions for my automation and transformation tasks. Can you do it?
Yes. I will build the workflows as per your custom needs so that manual task repetition can be avoided.
Do you provide free mockup filies before the order?
Yes. I do provide free mockup file with the most plausible solution and if the solution meets your requirements, you place an order with me.
Do you provide advanced level automated visualizations after the ETL process?
I am offering complete analysis package starting from raw data till creation of automated and insightful dashboards. I will surely create the business intellignece reports and dashboards that you require.
Do you create data models and pivot tables?
Yes. After data is cleaned up and loaded, I use power pivot to create table connections and create advanced data models like star schema, snow flake models, and flat table based models.
Reviews
22 reviews for this Gig
| (21) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
O omar_ct1
Repeat Client
United States
good got the results needed
$50-$100
Price
1 day
Duration
Helpful?O omar_ct1
Repeat Client
United States
Good. got the results I needed
Up to $50
Price
1 day
Duration
Helpful?E egliptor
Repeat Client
United Kingdom
Good, professional
Up to $50
Price
2 weeks
Duration
Helpful?E 
ekabalka
Repeat Client
United States
Delivered as promised.
Up to $50
Price
1 day
Duration
Helpful?E ekabalka
Repeat Client
United States
Requested a high-level power query template with multiple data source sheets. Provided exactly what I requested.
$200-$400
Price
7 days
Duration
D 
Seller's Response
Helpful?
Reviews
22 reviews for this Gig
| (21) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
O omar_ct1
Repeat Client
United States
good got the results needed
$50-$100
Price
1 day
Duration
Helpful?O omar_ct1
Repeat Client
United States
Good. got the results I needed
Up to $50
Price
1 day
Duration
Helpful?E egliptor
Repeat Client
United Kingdom
Good, professional
Up to $50
Price
2 weeks
Duration
Helpful?E ekabalka
Repeat Client
United States
Delivered as promised.
Up to $50
Price
1 day
Duration
Helpful?E ekabalka
Repeat Client
United States
Requested a high-level power query template with multiple data source sheets. Provided exactly what I requested.
$200-$400
Price
7 days
Duration
D Seller's Response
Helpful?
