GLOBAL FINANCE & BUSINESS MANAGEMENT “VIRTUAL INTERNSHIP” GUIDE forage.

Abdullah Farooq
5 min readDec 5, 2022

Since a childhood I always been enthusiastic about corporate world. I used to check online websites and read and gets updates. One day upon checking I got to know the virtual internship experience opportunity officially on their website. I felt immense.

I’m an experienced individual before a virtual experience, I worked with the multinational companies and my work is to related with the Data management, performance and data analytics and business analytics.
I worked with the leading top IT industry (Trg), US based retail industry (Walmart) & worked with a food delivery company Delivery hero subsidy (foodpanda Pakistan) and working with the Qatari’s second largest brand of food delivery company (Snoonu).
I’m enthusiastic about numbers, data, management, visualization and analytics.

When I enrolled into the virtual internship program of J.P Morgan chase. Co, I felt amazed and when I started, I got the first project based on Actual vs budgeted analysis. At their point, I felt I need help to move forward with the project. Unfortunately, I google it, there is no single guidance or help related to “Global finance and business management” virtual internship. But after a lot of other research and tactics and I managed to complete my first task and What I got to know?
It was correct… Yes, the answers are same as I’ve completed the project. I felt very happy and I decided to move forward with another projects/task of the internship. Beside I decided I’ll write my article/blog for help or guidance for those who wants help in the internship. I’ll guide step by step and with an attachment.

The complete internship is based on 5 modules.

Data Analysis and Simple Visualization
Data Visualization Dashboard
Storytelling with PowerPoint
Concise Written Communication: Variance Commentary
Concise Verbal Communication: Manager Update Video

Data Analysis & Simple Visualization:

This is the first task you’ll received after the enrollment. I urge you all to please carefully read and follow the instructions of the Manager. Once you enrolled you’ll received the video message from the manager with an instruction of further proceedings and requirements.

The requirements are: Which projects are over or under budgeted hours? Which projects are over or under budgeted costs? Which personnel are over or under budgeted hours?

BUDGET VS ACTUAL HOURS & COST ANALSIS DATA

You’ll get the data from the team and requirements. The data is huge, I understand. First, just apply the =SUM formula in excel and sum up all the budgeted hours and actual hours. Same goes with cost. You’ll get the results. This is called a “Data Analysis”
Further once you’ve done with the analysis, go through once again and just check what’re you understanding after reading the data? What data is telling to you? Create a PowerPoint report and show all the business elements that are required.

Following below is the example of PowerPoint work.

PPT REPORT AND DATA VISUALIZATION AND PROJECT ANALYSIS

Data Visualization Dashboard:

After completing the first task, you’ll assigned second task which is to create a dashboard and show the analysis of budget vs actual (Cost, Project, Task, Personnel's) on Tableau.

Whether you can create a dashboard on aggregated or a single sheet of Tableau dashboard or separately create the analysis of task on each sheet it’s an optional.
Start analysis the all the business elements and visual it on dashboard.

BUDGET VS ACTUAL HOURS
BUDGET VS ACTUAL PROJECT ANALYSIS
BUDGET VS ACTUAL TASKS ANALYSIS
BUDGET VS ACTUAL COST ANALYSIS

Once you created a dashboard on Tableau then submit a task :)

Story telling with PowerPoint:

Tell or write a short story to your management regarding an improvement plan, discuss performance of various personnel's and projects task and analysis which task/project has an capability to improve or which hasn’t.
Figure out and submit it to the portal.

Concise Written Communication: Variance Commentary

What is Variance report or commentary? Well, that was my first time when I was working for a variance commentary report. I read an article and I understand the norms when writing a variance commentary report.
Figure out the least problems in service and product and analysis it accordingly and submit it to the manager the instructions.

My project and loss variance report is slightly a different the work methods are difference however the outcome are same.

P&L VARIANCE COMMENTARY REPORT

Figure out the numbers and read meticulously and differentiate the projects that are generating loss or projects. I’ve prolong the Commentary and take a half screenshot for just a guidance.
Figure out and aggregate into simple word report and submit it.

Concise Verbal Communication: Manager Update Video:

Here is the final and ends of your virtual internship and record a concise verbal communication video and tell the overall required plans of improvement and appreciate the task that are generating profits and submit it to the manager.

My certificate “GLOBAL FINANCE AND BUSINESS MANAGEMENT”

After a complete guidance, I hope you’ll be able to complete the task without a hesitation or correctly.
Further I’m giving my services on a Fiverr related to Data management, Data analysis and Dashboard creating solution. I’m creating a single click solution for a huge data and creating a dashboard for business.

Checkout my portfolio or DM into my official email for a sample: abdullahfarooqfreelance@gmail.com

Link of Fiverr: https://www.fiverr.com/share/DgplWA

--

--