We help companies build epic Excel Spreadsheets and Dashboards
I have a management consulting background with strong corporate experience. Highly focused & obsessed with customer service and value delivery.
Capabilities:
Microsoft Excel Report Development (17 Years Experience)
Website Development (15 Years experience)
Supply Chain Management (12 Years Experience)
Languages:
CLIENT BRIEF Simplify all macros and logic on the existing loan calculator. Fix faulty macros and optimise and improve the process.
SOLUTION Using power BI, all source data was extracted, transformed, validated and loaded into the tool. All macros were eliminated.
VALUE ADD The logic and functionality of the tool was evolved to the next level, intelligent predictors, insightful charts and scenario planning was developed and incorporated.
Related Services: Excel Troubleshooting and Problem Fixing
Skills & Industries: Advanced Excel, Advanced Reporting, Automation, Data Aggregation, Data Extraction, DAX, Excel, Financial Planning, Loan Calculator, Loans, Macros, Power BI, Power Query, Reports
CLIENT BRIEF Rapid extraction and turnaround required from a Real Estate Portal. Detailed and complex filtering rules and data transformation logic to be incorporated into the extraction script.
SOLUTION All 1600 records were extracted within the specified timelines with razor sharp precision and accuracy using specialized tools.
VALUE ADD Solution was white labeled and all scripting was fully shared with client during a thorough handover that included training and skills, knowledge and IP transfer.
Related Services: Excel Reporting,
Skills & Industries: Automation, Data Extraction, Excel, Macros, Scripting, VBA, Web Scraping
ABOUT THE PROJET I love hearing things like: "We never knew Excel could do that?" or "That doesn't even look like Excel anymore"
We cleaned, normalized, validated and transformed our clients data to build an interactive sales dashboard. The client really responded well to the visual nature of the reporting and the overall simplicity of the data model.
Tools used: Power Query, Power Pivot, Power BI
Related Services: Excel Reporting, Business Intelligence
Skills & Industries: Data Processing, Excel, Business Intelligence, Data Cleansing
Excel Reporting Services hasn't been reviewed yet.
Tell us what you need and connect with local freelancers.
Post a projectCreate your profile and connect with Australian clients.
Create your profile