Excel Reporting Services

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

http://www.excelreporting.com.au

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

http://www.excelreporting.com.au

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

http://www.excelreporting.com.au