Excel Expert - VBA - PowerPivot - PowerBI
Strong Excel and dashboarding skills, with extensive experience in the following:
? Excel Spreadsheet Formulas, Charts and Pivot Tables
? VBA for Macros, User-Forms, reporting tools and web scraping
? Reports & Dashboard Design with Excel, PowerPivot and Power BI
? Advanced DAX for PowerPivot / Power BI Data Models
? Data mashup using Power Query 'M' formula language
? Database design and implementation with MS Access and SQL queries
*** +12 Months Experience as an Excel / PowerPivot / Power BI Data Analyst. Major accomplishments include:
- Automation of data analysis periodic reports with improvements on the metrics used to measure performance in the Operations Department with PowerPivot
- Dashboard design comprising main KPIs of Operations Department with Power BI
- Implemented the Corporate KPIs Excel dashboards and input tables for CEO and Line Managers of a major venezuelan Oilfield Drilling Contractor using Excel
- Designed a Catering Nutritional values-based and Costs-based KPI dashboard for a Service of 1800 daily served meals, based on the analysis of 1 year data after normalizing and repairing it
*** Bachelor Telecommunications Engineer
Do not hesitate to contact me if you are in need of help from an Excel expert. Getting in the list of this solutions portfolio may save you considerable time and money.
Work Terms
I'm available 24/7 via whatsapp and skype, to give my clients the best support they can get.