Excel Power Pivot and VBA Automation (4346560)

Programming & Development

Excel Power Pivot and VBA Automation

$10/hr Starting at $60

I am proficient in developing complex yet easy to understand data model in Microsoft Power Pivot. I have over 3 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. If you have a business, you are bound to generate tons of data which can provide valuable insights through creative data analysis To achieve the goal of extracting insights out of your data, I use a wide range of tools and techniques such as formulas, pivot tables, power pivot, power query, VBA coding, Dax formulas, automated connection to the database, SQL query via VBA code and so on. Also I can create full cycle reporting system - from data preparation and ETL to advanced level reporting. I am a Microsoft certified analyst in Analyzing and Visualizing Data in Excel. 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.

About

$10/hr Ongoing

Download Resume

I am proficient in developing complex yet easy to understand data model in Microsoft Power Pivot. I have over 3 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. If you have a business, you are bound to generate tons of data which can provide valuable insights through creative data analysis To achieve the goal of extracting insights out of your data, I use a wide range of tools and techniques such as formulas, pivot tables, power pivot, power query, VBA coding, Dax formulas, automated connection to the database, SQL query via VBA code and so on. Also I can create full cycle reporting system - from data preparation and ETL to advanced level reporting. I am a Microsoft certified analyst in Analyzing and Visualizing Data in Excel. 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.

Skills & Expertise

AnalyticsCreativeData ManagementEtlFinancial AnalysisMicrosoftMicrosoft ExcelMicrosoft Excel Pivot TablesModelingOracle Bi PublisherReport WritingSchoolSoftware DevelopmentSQLSystems EngineeringTooling DesignVBA

Related Work Collections

5 Reviews

Jason 142 says,

Good work with prompt responses to my requirements

for Excel sheet development on Apr 26, 2020
Hessa 2 says,

Very satisfied with Mahmud work, very good excel skills, finished all requirements on time and was very cooperative and quick responding. He is very understanding and highly recommended. Also, I appreciate his honesty for clearly defining what he can and cannot do.

for Make AHP Analysis using excel on Dec 31, 2019
Theman says,

great work

for Data Analysis case study on Jul 20, 2019
zeramzi says,

thanks for this good analysis

for Data Analysis case study on Jun 15, 2019
J_Dhingra says,

Mahmud was very knowledgeable and delivered everything that was expected of him. Will hire again

for Excel Financial Model for Capital Budget on May 08, 2019

Mahmud Hasan11