Automated Weekly Reporting for SBI: Excel Dashboard and Automation Training

Table of Contents

In short

Skillspark delivered an eight-hour, in-person corporate training programme for a State Bank of India team at its Pattom office in Trivandrum. The team faced a recurring reporting challenge involving data from approximately 1,000 branches, with three to four employees involved in manual data preparation. Working within SBI’s Excel-only software restriction and without accessing confidential bank data, Skillspark developed a simulated Excel reporting model to demonstrate dashboard development, data processing and reporting automation.

Project snapshot

Client State Bank of India (SBI)
Industry Banking (public sector)
Location Skillspark Pattom Office, Trivandrum, Kerala
Training topic Data analytics, dashboard building and reporting automation
Software Excel (SBI allows no other software)
Mode Offline (in person)
Duration 8 hours, in one day

About the client

State Bank of India (SBI) is a public-sector bank. This training was for an SBI team, and it took place at Skillspark’s Pattom office in Trivandrum, Kerala.

The team deals with complex analysis. It receives large volumes of data from about 1,000 branches, including loan data, pending loans and other operational numbers.

The results go into a weekly meeting. SBI’s master data is confidential, so this page describes the problem and the solution without using or showing any real SBI data.

What skill gap was the SBI team facing?

The biggest problem was the weekly meeting presentation, which meant copying and pasting bulk data from about 1,000 branches by hand.

It took a lot of time every week and needed three to four people.

The data covered loans, pending loans and other operational numbers. The team wanted a quicker way to turn all of it into graphs for each meeting, one that works the same way every time.

Working conditionSBI allows only Excel. No other software could be used, so everything had to be built in Excel.

How did Skillspark work without SBI’s confidential data?

Skillspark built the training on a model with similar, simulated data, because SBI’s real master data is confidential and Skillspark was not allowed to access or use it.

Confidentiality noteNo real SBI data was accessed, used or shown at any point. All practice and demonstration used simulated data only.

How Skillspark prepared

  1. Two joint discussions with the SBI team to understand their main challenges.
  2. One in-person visit to see how the work is actually done.
  3. R&D to design a model that mirrors the real problem, built in Excel.
  4. A mock project on simulated data, ready before the training began.

That way, the training dealt with a real business problem without exposing any real SBI data, and without any software other than Excel.

What did the 8-hour programme cover?

The one-day, 8-hour in-person training covered data analytics, dashboard building and automation in Excel, all applied to the weekly reporting problem.

It was delivered at Skillspark’s Pattom office in Trivandrum.

What the programme covered

  • Data analytics: working with large datasets from many branches, including loan data, pending loans and other operational numbers.
  • Dashboard building: creating an Excel dashboard that shows the graphs and visuals the team needs.
  • Automation: setting up automatic data processing and reporting in Excel, so nobody has to copy and paste any more.

What Skillspark built

Skillspark built an Excel dashboard with automatic data processing and reporting. It turned the manual weekly process into an automated one.

Methodology

Participants worked through a realistic business problem using simulated data. That kept the training practical and kept SBI’s real data confidential.

What results did the SBI team achieve?

The SBI team went from a manual weekly process that needed 3–4 people to an Excel dashboard that builds the reports from a date range.

3–4people’s weekly manual work, now automated
~1,000branches processed automatically
1date range change builds the full presentation
8 hrsof in-person training, in one day
  • Manual work automated: what needed 3–4 people is now done automatically.
  • No more copy and paste: data from about 1,000 branches is processed automatically.
  • Reports from a date range: change the date range and the team gets the presentation with every graph it needs.
  • No manual steps: nothing has to be done by hand to produce the weekly presentation.
  • Within SBI’s limits: everything runs in Excel, the only software SBI allows, and was built on simulated data with no real SBI data used.

Before vs after

Before After
Data handling Bulk data from about 1,000 branches copied and pasted by hand Processed automatically
People needed 3–4 people Automated
Time A lot of time every week Reports built by changing the date range
Graphs and visuals Made by hand Made automatically
Manual steps Needed every week None

Key takeaways

  • Confidential data doesn’t have to stop practical training. A well-built simulated model can still teach a real business problem.
  • Software limits don’t stop automation. Excel alone was enough for a dashboard and automatic reporting.
  • Preparation makes a difference. Two joint discussions, a visit and a mock project came before the training day.
  • Automation removes repetitive work. Weekly reporting that took 3–4 people no longer needs manual effort.
  • Reporting gets simple. Changing the date range now produces the full presentation.

Frequently asked questions

Can Skillspark train our team to automate weekly or monthly reports?

Yes. Skillspark trains teams to turn repetitive reporting into an automated process, where data is processed and graphs are produced automatically. At SBI, a weekly report that needed three to four people now generates by changing a date range. Contact Skillspark to discuss your own reports.

What kind of teams and companies is this training for?

It suits any organisation that works with data and wants to save time on analysis or reporting, whatever its size or industry. Teams in operations, finance, HR, sales, MIS or management can all benefit. Skillspark delivered it for State Bank of India, and the approach adapts to your own data and requirements.

Can you train us if we are only allowed to use Excel?

Yes. Skillspark has built a dashboard and automated reporting entirely in Excel for a client that permits no other software. If your IT policy restricts what can be installed, Skillspark designs the training and the solution within that limit, so your team can use it without installing anything new.

Can you train us if our data is confidential?

Yes. You do not need to share your real data. Skillspark learns your challenges through discussions and a site visit, then builds a realistic model with similar, simulated data. Your team practises on its own kind of problem, and your confidential records are never accessed, used or shown.

How does Skillspark understand our requirements before the training starts?

Skillspark begins with joint discussions and an offline visit to see how your team works today. It then runs R&D and builds a mock project, so the training matches your real workflow. For SBI, this took two discussions and one visit before the training day.

How long does the training take?

Skillspark has delivered a full programme in eight hours, in a single day, offline. The programme covers data analytics, dashboard development and automation, so teams leave with a working solution. The right length for your team depends on your reports and data, so share your requirement and Skillspark will propose a plan.

Can our team run the solution on its own after the training?

Yes. Once the dashboard is in place, the team generates its presentation, with all required graphs and visualisations, simply by changing the date range, with no manual intervention. Skillspark builds it inside the software your organisation permits, so your people can run it themselves.

Facing Similar Reporting Challenges in Your Organisation?

Skillspark helps organisations identify repetitive reporting tasks, explore practical automation solutions, and develop employees’ capabilities through customised corporate training.

Share your current challenges with our team to explore a suitable training approach.

Discuss Your Training Requirements