Case Studies - Marketing Company
Take your Business from Good to Great
Digital Marketing Company gains back control on business by moving away from spreadsheets to Power BI
The client uses Harvest for time tracking, invoicing, and expense recording while Google Sheets for capturing the budget and various targets.
It was almost impossible to see the performance on day-to-day basis as data was in disparate sources. Lot of manual efforts were required to bring data together and create a single report.
One of the most time-consuming activity was to calculate incentive of team members which is based on various parameters.
Client’s team was also not able to see business performance and their own performance as there was not easy way to visualize data
The client was already aware of advantage of having a robust BI solution so the project had a good head start.
The client uses lot of Google technologies, so they wanted to set up Data Warehouse in Google BigQuery. Based on this, we designed an architecture as:
The Power BI reports were created for three levels of the organization 1. Consultants 2. Management Team 3. Board members.
The reports and dashboards were shared with these three teams by using Power BI Pro licenses.
The consultants were very pleased as they could see company’s performance and their performance. They could also see how much incentive ther are going to get as soon as the period was over.
CEO of the company is using the reports every day and is so thrilled with the solution that he is already planning to develop it as a product for other marketing companies.
The client team now wants to cover all their business processes into the BI solution.