No database to display
I must thank you for visiting this page. To use this fantastic web-based data analytic solution, you need to register as indicated above and contact me to enrol you or just signon if you have registered and enrolled
Possible Tasks |
---|
Data Grouping and Data Summary |
Data Stratification(i.e bands) |
Data Matching(Approximate and Exact) |
Text search and Text replacement |
Data Periodisation(Daily, Weekly, Monthly, Semi-monthly, Quarterly etc) |
Data Compare and Data Extraction |
Data Cleaning/Normalisation |
Duplicate detection and reporting |
Charts and Graphs etc |
Benefits |
---|
Performing reconciliation of items(i.e matching items) |
Merging data from different sources based on similar column(s) |
Extracting desired information from data set |
Ascertaining the existence of text in data |
Performing data summary for different reports |
Stratifying data into different bands |
Data pivoting, narrowing, widening for various uses |
Preparing stunning charts and graphs etc |
About Me
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 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 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 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 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
Help
Cell Split to rows
Text to columns
It is possible to receive data with several records in just a cell. For example a column for directors of a company might have this structure:
BDC | Directors |
---|---|
Travel Go BDC | Brand Belivers;Ganiyat Haruna;Musa Adamu |
Me and Sons BDC | Olabopo Ashake Kehinde; Shuqrat Taiwo |
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 |
To achieve this,
- use the "Select column to split" to select the column containing data to split into rows(e.g Directors)
- enter the data separator/delimiter in the "Enter data delimiter" box(in this instance ;)
- Click the Process button to process
Extract Numbers
Remove Numbers
Columns to row
Pivot: Value
Pivot: Date
Search by string
Search by sub-string
Replace column text
Stratification
Categorisation
Periodisation
Extraction
Duplicate
Compare Value
Compare Date
Match Exact
Match Nearest
Bar Chart
Horizontal Bar
Line Chart
Pie Chart
Stackplot
Histogram
Scatter Plot
Date Series
Please feel free to contact me as below:
- afolorunsho@gmail.com; abayomifolorunsho@pubtechltd.com
P: +234(0) 805 328 1398