Business Problem

An investment company XYZ, wanted an expert to use analytical skills to evaluate the performance of African Countries’ GDP over the years.

A business analyst would help the company:

1. Identify opportunities of investment
2. Discover performance of the existing investment
3. Reduce the time taken every time they want to understand the business performance.

The management could use the solution in product rating and reviews, while developing metrics for continuous product improvement. Advanced data preparation and modelling skills were required to automate the repetitive process by creating interactive dashboards and reports. The final solution would have a positive impact to the management in that, decision makers can make informed decisions on the strategies to build economic development activities for the general country growth and sustainability.

Approach

The initial step was business understanding and project requirements then collect the required data. Secondly, I planned a design direction while reviewing the design and specifications for changes that affect respective modules. I could propose the best analytical software for the project and work closely with cross-functional teams for product enhancement to ensure project controls are in place.

Solution

With deep analytical background, and skills in business intelligent tools I created an automated Tableau dashboard for the state of African economy while paying attention to details and specific business questions. My ability to make a positive business impact by developing real-time reports enabled XYZ Company to make data driven investment decision to shape the future with low risk. The solution saved the company 40 percent of the time used every month in this analysis and saved 56 percent losses incurred in unprofitable investments. The annual financial reports recorded an increase of 6 percent profits from 3.7 percent of the previous year. You can Interact with the solution through this Link.