Banner Image

All Services

Business & Finance data science & analytics

Automation/Macros/Google Scripts

$80/hr Starting at $950

There are three services related to Excel:

Advanced Statistical/Predictive/Diagnostic Data Analysis (e.g., regression analysis, logistic regression, correlation analysis, Hypothesis testing) & DAX, MDX, cube functions, Data Modeling, PowerPivot, 10 to 20 Macro/Script/Form, Explanatory Video

Data Segmentation (e.g advanced customer segmentation)

Predictive Modeling: Building models (e.g., using Scenario Manager) to predict customer churn, and sales based on marketing campaigns, or inventory needs. + Charts if needed


Showcase:

Auto Invoice


Data Modeling, DAX & Cubefunctions, what are they and what do they do? 

A centralized, organized database within your spreadsheet. Data modeling for large and scattered data will allow applying functions to tables instead of repeating pivot tables as it is the foundation for cube functions and DAX to process them in bulk amounts as these functions deal with tables not individual cells as normal formulas. For example: You manage a retail chain with data on sales, inventory, and customer demographics scattered across multiple Excel spreadsheets. Manually consolidating and analyzing this data is time-consuming and error-prone. 


What can 20 macros do for you? 

At this level, you want autonomous & holistic solutions. You are likely someone who will repeat the same process for 5/10/20 years. You write an invoice or stocks or sales or whatever over and over and maybe with a static template then check in a tedious process and if this changes anything else (e.g if some items check out with the invoice then the stocks will be updated and check the stocks lack this item and if it is lacking then you have to alert that this item is about to end or check with the colleagues and you have to print some reports, maybe sales report or the invoices for the accountant or the warehouse and so on while this can all be automated to free your mind for the more important stuff. all the problems I mentioned earlier can be automated (with a click of some buttons or on its own) with so much customizability. All of this is just one scenario for illustration.


For Consultation and if there is any need for clarification,

Contact me anytime

About

$80/hr Ongoing

Download Resume

There are three services related to Excel:

Advanced Statistical/Predictive/Diagnostic Data Analysis (e.g., regression analysis, logistic regression, correlation analysis, Hypothesis testing) & DAX, MDX, cube functions, Data Modeling, PowerPivot, 10 to 20 Macro/Script/Form, Explanatory Video

Data Segmentation (e.g advanced customer segmentation)

Predictive Modeling: Building models (e.g., using Scenario Manager) to predict customer churn, and sales based on marketing campaigns, or inventory needs. + Charts if needed


Showcase:

Auto Invoice


Data Modeling, DAX & Cubefunctions, what are they and what do they do? 

A centralized, organized database within your spreadsheet. Data modeling for large and scattered data will allow applying functions to tables instead of repeating pivot tables as it is the foundation for cube functions and DAX to process them in bulk amounts as these functions deal with tables not individual cells as normal formulas. For example: You manage a retail chain with data on sales, inventory, and customer demographics scattered across multiple Excel spreadsheets. Manually consolidating and analyzing this data is time-consuming and error-prone. 


What can 20 macros do for you? 

At this level, you want autonomous & holistic solutions. You are likely someone who will repeat the same process for 5/10/20 years. You write an invoice or stocks or sales or whatever over and over and maybe with a static template then check in a tedious process and if this changes anything else (e.g if some items check out with the invoice then the stocks will be updated and check the stocks lack this item and if it is lacking then you have to alert that this item is about to end or check with the colleagues and you have to print some reports, maybe sales report or the invoices for the accountant or the warehouse and so on while this can all be automated to free your mind for the more important stuff. all the problems I mentioned earlier can be automated (with a click of some buttons or on its own) with so much customizability. All of this is just one scenario for illustration.


For Consultation and if there is any need for clarification,

Contact me anytime

Skills & Expertise

Data AnalysisData ManagementData VisualizationFinancial ModelingGoogle SheetsMicrosoft ExcelR Programming

Related Work Collections

0 Reviews

This Freelancer has not received any feedback.