Author

Mr Abayomi Folorunsho is a fellow of the Institute of Chartered Accountant of Nigeria and a Certified Information System Auditor(CISA). He has about three decades of banking experience spanning banking operations, internal audit, business development, process improvement and strategy development. He left EcoBank Nigeria Plc as a Branch Manager to Join the Central Bank of Nigeria in 2003.

Over the years, he has distinguished himself as a highly resourceful data analyst. Developing solutions and capacity in others.

He started using spreadsheet with Lotus123 and developing applications with dBase III+ in in the early nineties. He then moved to developing applications with FoxPro, Visual Basic and then Java. He now develops applications using Excel VBA, Javascript, IDEA Script, Python and PHP.

He has developed various data models and solutions including

• Developing Companies Financial Data Analysis(CFDA) for CBN Statistics Department using Excel VBA
• Analytics scripts for audit using IDEA Script
• Developing Models for:
  • Ascertaining the correctness of bank charges computation
  • Reconciling hydra-headed accounts
  • Tracking ownership of BDC
  • Consolidating thousands of accounts belonging to 89 banks in disparate applications to just 24 banks
  • Ascertaining the correctness of pensioners' pay based on year of exit, years of service, grade at exit, salary structure at exit etc

• Basic Microsoft Excel
• Using IDEA Data Analytic Tool
• Scripting with IDEA for Auditors
• Data Analytics for Statisticians
• Intermediate/Advanced Microsoft Excel etc

Background

I started data analytics in the early nineties. I was using Lotus 123 and its Macro to automate treasury operations tasks back then. From here, I, along with one Adamu Balanti, started using Dbase III+ when it was installed in our Office(ICON Ltd Merchant Bankers), Kano Branch. I used this Dbase III+ to automate treasury(money market) monthly interest accrual.

I have developed different data analytic models over the years and used various tools such as Lotus 123, Microsoft Excel, IDEA etc, for data analytics. I had a challenge using Excel to solve a problem sometime in 2018. I searched through the net for tips using MS Excel and the solution proferred almost worked. Before this time, a consultant mentioned Python when discussing great data analytics tools while discussing IDEA, a great data anaylytic tool. Though I had read about Python as a progarmmer, I knew little about its data analytic prowess. I decided to learn Python to solve the challenge and discovered fantastic packages for solving various data analytics challenges.

This endeavour led to the development of this data analytic web application aimed primarily at helping me and others with various data analytics tasks.

Among the projects successfully carried out with this application include:

• Converting Wide Data to Narrow Data set for further analysis

  Grade	Level	Year 1	Year 2	Year 3...
  1	1	1000	2000	3000
  1	2	4000	5000	6000
  1	3	7000	8000	9000
  2	1	10000	11000	12000
  2	2	13000	14000	15000

  To Narrow

  Grade	Level	Year	Amount
  1	1	Year 1	1000
  1	1	Year 2	2000
  1	1	Year 3	3000
  1	2	Year 1	4000
  1	2	Year 2	5000
  1	2	Year 3	6000
  1	3	Year 1	7000
  1	3	Year 2	8000
  1	3	Year 3	9000

• Changing from Narrow to Wide for insighful information

  Indicator	Country	Year	Value
  1	Angola	2005	6
  2	Angola	2005	13
  3	Angola	2005	10
  4	Angola	2005	11
  5	Angola	2005	5

  To Wide

  Country	Year	1	2	3	4	5
  Angola	2005	6	13	10	11	5
  Angola	2006	3	2	7	3	6

• Spreading text in a column to create other column(s) for data clarity

  Name	Address
  Davesther Logistics	1, Sunnyvale Home, Dakwo
  Nkiru Awa	33, Yohanna Street, Abuja
  Ahman Yakubu	17, Mandella Street, Ikeja
  Joseph Odekhian	23, Adenuja Road, Ibadan

  Auto create columns for "First Name" and "Last Name"

  First Name	Last Name	Address
  Davesther	Logistics	1, Sunnyvale Home, Dakwo
  Nkiru	Awa	33, Yohanna Street, Abuja
  Ahman	Yakubu	17, Mandella Street, Ikeja
  Joseph	Odekhian	23, Adenuja Road, Ibadan

• Spreading text in a row to create other row(s) to create distinct records

  BDC	Directors
  Travel Go BDC	Brand Belivers;Ganiyat Haruna;Musa Adamu
  Me and Sons BDC	Olabopo Ashake Kehinde; Shuqrat Taiwo

  To

  BDC	Directors
  Travel Go BDC	Brand Belivers
  Travel Go BDC	Ganiyat Haruna
  Travel Go BDC	Musa Adamu
  Me and Sons BDC	Olabopo Ashake Kehinde
  Me and Sons BDC	Shuqrat Taiwo

• Grouping data into Daily, Weekly, Monthly, Yearly transactions
• Data extraction based on time of the day(e.g all transactions on weekends or late(12:00am to 8:00am)
• Data extraction based on various operators(Like, equal, not equal etc)
• Grouping data into bands(i.e stratification) (0-10,11-20,21-30 etc)
• Merging and joining data from various sources into just one set of data
• Removing numbers from text in a column
• Removing non-numbers from text in a column
• Searching part of text in a column
• Replacing text in a column
• Plotting stunning and insightful graphs/charts etc

Please DO NOT hesitate to contact me in the event that any of the features here do not meet your requirements as it may just be lack of understanding the design on the application.

Contact

Please feel free to contact me as below:

• Email: afolorunsho@gmail.com; abayomifolorunsho@pubtechltd.com
• Phone: +234(0) 805 328 1398