You will get Advanced Dashboard in Excel

Mahmoud D.
Mahmoud D.
5.0
Top Rated Plus

Let a pro handle the details

Buy Data Visualization services from Mahmoud, priced and ready to go.

You will get Advanced Dashboard in Excel

Mahmoud D.
Mahmoud D.
5.0
Top Rated Plus

What's included $1,000

Excel Dashboard

Advanced Dashboard in Excel that presents all insights and KPIs out of your data

  • Delivery Time 3 days
  • Number of Revisions 3
  • Number of Graphs/Charts 20
    • Interactive/Animated Visuals
3 days delivery — Jun 21, 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. Mahmoud gets paid once you are satisfied with the work.

Let a pro handle the details

Buy Data Visualization services from Mahmoud, priced and ready to go.

Project details

1- Build interactive dashboard for you connected to slicers and timeline to easily filter your data by certain criteria(s) and/or by day(s)/month(s)/year(s). This dashboard will have based analysis like sales per month and such analysis using pivot tables.

2- Add some KPIs and insights as following:
2.1 New customers each month
2.2 Churn customer
2.3 Turn Rate
2.4 Churn Revenue
2.5 Cutomer life value in years
2.6 Cutomers life value in dollars

3- Build a forecast model for you
Data Tool
Microsoft Excel
What's included $1,000 These options are included with the project scope.
$1,000
  • Delivery Time 3 days
  • Number of Revisions 3
  • Number of Graphs/Charts 20
    • Interactive/Animated Visuals
5.0
460 reviews
100% Complete
1% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
5.0
Deadlines
5.0
Skills
5.0
Cooperation
5.0
Quality
5.0
Communication
5.0

DG

Derek G.
5.00
Jun 11, 2024
Need Microsoft Power BI specialist I recommend to work with him for BI needs.

GE

Gal E.
5.00
Jun 10, 2024
Data Analyst Great work, super professional, recommend to hire for sure.

PS

Purvish S.
5.00
Jun 5, 2024
Excel Formulas needed Excellent service provider, great communication skills and quick to understand project needs. Highly recommend

AL

Anne Marie L.
5.00
Jun 4, 2024
Data Analyst Mahmoud has been a tremendous asset to Shawmut. His advanced knowledge of Excel, PowerQuery and PowerBI have been instrumental in solving some difficult problems for Shawmut. In addition to performing complicated analysis, he provides solutions very timely. He is always available for a quick discussion, meetings, or for small changes. It has been a pleasure to work with him and look forward to his ongoing contributions in future Shawmut projects.

OG

Oscar G.
5.00
May 27, 2024
Data Visualization for Survey Results We needed data visualisations from a comprehensive set of survey results. Mahmoud was able to build a dynamic dashboard that completely exceeded our expectations, ahead of the deadline. We would highly recommend Mahmoud!
Mahmoud D.

About Mahmoud

Mahmoud D.
Data Analyst, Excel, PBI, SQL Expert, Loughborough Engineering, MBA
100% Job Success
5.0  (460 reviews)
Cairo, Egypt - 2:29 pm local time
"I offer a FREE LIFETIME GUARANTEE & FREE TECHNICAL SUPPORT for all my work"
..
I am Excel, Power BI, SQL, Power Query, DAX, Power Pivot, M Language and VBA expert with more than 10 years of experience, ~500 Jobs on Upwork with a 100% Success Score and a Top Rated Plus Badge!
..
My academic journey includes an MBA "Master of Business Administration", an engineering bachelor’s degree from Loughborough University, UK, and a PMP Diploma, equipping me with a robust foundation to innovate and excel.
..
Engaging my services guarantees access to my reservoir of creativity and unconventional solutions. My proficiency ensures expedited delivery of:

1. Customized interactive dashboards that summarize your data, revealing pivotal insights, trends, and performance metrics. These dashboards are enhanced with intuitive slicers, filters and timelines to easily filter the whole dashboard using different criteria(s) and date range(s). The dashboard will contain time intelligence analysis such as MTD, YTD, MoM% change, YoY% change, Actual Vs Budget “if applicable” and many other advanced calculations

2. A suite of KPIs and insights, including but not limited to:
2.1 Acquisition metrics for new customers
2.2 Customer attrition rates
2.3 Turnover rates
2.4 Revenue impacts of customer churn
2.5 Longitudinal customer value assessments
2.6 Monetary customer lifetime value
2.7 Cohort analysis

3. Robust financial models, proformas, and comprehensive financial assessments.

4. Predictive forecasting models to anticipate future trends.

5. Scenario analysis through ‘What If’ explorations, gauging the impact of variable adjustments.

6. In-depth statistical evaluations using Excel such as encompassing regression, P-Value analyses, and more.

7. Experience in training and mentoring teams on best practices in data analysis tools, fostering a culture of continuous learning and improvement.

8. Adept at creating dynamic simulation models to predict outcomes under different operational scenarios, aiding in risk assessment and management.

--- This summary is just a brief of what I can do and my capabilities. There’s a whole lot more for you to find out with a vast expanse of skills awaiting your discovery!

Steps for completing your project

After purchasing the project, send requirements so Mahmoud can start the project.

Delivery time starts when Mahmoud receives requirements from you.

Mahmoud works on your project following the steps below.

Revisions may occur after the delivery date.

Free Presentation for the sheet

Dear Sir, Please contact me and I can present this sheet for you for free then you can take your decision.

Review the work, release payment, and leave feedback to Mahmoud.