KMB, which stands for Kongolese Microfinance Business, was founded by Ade Kasereka B. Vickya, and assisted by a group of congolese with background and experience in finance. It is a microfinance project which is motivated by the desire to empower Congolese diaspora living in the UK with access to affordable financial services and products but also to the best possible financial knowledge as their needs arise.

As a Data analysis Excel specialist with skills in using Excel along with Power Query and Power Pivot by manipulating and connecting data, creating and visualising insights from raw data to enhance company's productivity.  

​

Skills gained are:

- Data collection

- Data transformation

- Data modeling & Analysis

- Data visualisation

​

​​​​

• Looking up data using different methods, then using conditional formulas and conditional formatting, using sumproduct functions and its different functions, then excel tables, dynamic arrays, then finish of visualising data with visual charts. 

• Transform data with conditional formulas, Lookup functions, and SUMPRODUCT

• Analyze data to highlight insights with conditional formatting, Excel Tables, and Dynamic Arrays

• Visualize data effectively by creating and formatting Excel Charts

• Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot.

• Extract information from fields that combine two or more values.

• Transform datasets by grouping or combining data from different tables or even multiple files from the same folder.

• Avoid, interpret, and fix errors and exceptions that you experience in Power Query.

• Load transformed data into Excel for use as automated data feeds.

• Problem-solving using grouped rows

• Column splitting functions to extract data

• Switching layouts by pivoting data

• Solving logical scenarios with conditional columns

• Problem-solving dynamic scenarios with header rows

​

​

​