Hello. I am waweru, a Microsoft Certified Analyst in Analyzing and Visualizing Data in MS Excel. I have expertise with all the tools and techniques needed to conduct insightful analysis of your data. Starting from formatting your data set to creating data model connection, writing DAX queries, using Solver for optimization, you will get a complete data analysis solution from me.
I have years of experience in analytics, modeling and automation. My specialization is in Finance and I am a Finance Graduate from one of the top business schools of my country. I have a solid theoretical practical problem solving knowledge in Excel, VBA, Power BI Desktop and data modeling to extract, modify and visualize data.
Following are the key services I will provide for you:
- Complex and analytical, yet user-friendly Excel and Power BI models
- VBA macro to automate your tasks
- Dynamic Dashboards which will help you measure performance effortlessly
- Advanced DAX skills to create reports and dashboards
- Thorough Financial Models for project valuation or capital budgeting purpose
My Excel Skills are briefly summarized as follows
-Formula Skills= I have hands on experience of working with tons of Excel formulas such as sumif, sumifs, countif, countifs, averageifs, vlookup, hlookup, iferror, ifisblank, NPV, XNPV, IRR, nper, rate, max, date, if and so on
-Pivot table
-Power Pivot
-Dax formula= calculate, all, filter, all except, all selected, hasonevalue, hasonefilter, crossfilter, values, isfiltered, summarize, calculatetable, maxx, sumx, average etc.
-Power query
-Date Model
-Dashboard Creation with dynamic charts and reports
-Excel solver for optimization
-Goal seek, data table, scenario manager
I have already been working as a Power BI and Excel expert at the freelance platform named Guru.I am here to have a long term working relation with all my clients.
Please, feel free to contact me. The ideas and requirements that my clients come up with give me a real chance to improve on my skills and I am always on the lookout to learn from you to develop new techniques to solve problems. I would be glad to discuss any of your interesting ideas and projects.