I will automate oracle material transactions using power query in excel or power bi

Egypt

I speak English, Arabic

Turning Complex Data into Business Ready Insights

Experienced in Data Modeling, Processing, and Analysis with over 5 years in analytics and 12+ years in Project Cost Control & Reporting covering contracts, cost estimating, incurred cost, cash calls, ...
About this Gig

After importing material transactions from the Oracle system as CSV file, which normally have more than 5K transactions, we need to charge every single transaction to its related Projects and provide material type based on its description just imagine how long those could take in manual work!

Instead, by using this model it takes only 30 seconds with a single click.

Power Query is a magical tool embedded in Excel and Power BI that can create a model that automates many tasks in a fast and efficient way to save time.

Technology:

Excel

Expertise:

Classification

•

Data acquisition

•

Data extraction

My Portfolio