Dot Analytics

BACKGROUND

Please describe your company and position.

I am the Marketing Manager of Pibox

Describe what your company does in a single sentence.

Hi, My name is Maria and I’m a marketing manager at Pibox. Pibox is an all-in-one app where creators and teams collaborate to produce audio, video, and other creative content. We work with the most innovative creative companies like Universal, Red Bull, Epidemic Sound, and others to optimize the remote content collaboration process.

Pibox substitutes 5+ different file, communication, and management apps. Our solution helps scale remote collaboration and save time for managers and content creators.

OPPORTUNITY / CHALLENGE

What specific goals or objectives did you hire Dot Analytics to accomplish?

• Set up Analytic system
• BI & Analytics: the right Mixpanel setup
• Set up dashboards in Looker (ex. Data Studio)

SOLUTION

How did you find Dot Analytics?

Recommendation

Why did you select Dot Analytics over others?

Good value for cost

How many teammates from Dot Analytics were assigned to this project?

1 Employee

Describe the scope of work in detail. Please include a summary of key deliverables.

Currently we have been working with Dot Analytics since July 2023 and they did a lot of tasks for us. To make things simple I can divide tasks into 2 parts: Mixpanel configuration and Looker dashboards. During this time they solved issues with MIxpanel’s API-method /identificate . Previously we double counted users since one user had a Mixpanel’s user_id and Pibox’s user_id. Guys showed how to put user data correctly into Mixpanel parameters.

Also, they helped us to correctly track the Gross Revenue in Mixpanel and build DAU, MAU, WAU, Marketing Funnel, Registration dashboards according to our requirements. The next step was to show data about user subscriptions, trials, features usage and essential collaboration metrics, since Pibox is all about collaboration. This data was in our product MySQL database. So to make connections secure we give them access to our data by making the VPN connections to our servers.

After that Dot Analytics created one big dashboard with five tabs which aggregated data from MySQL and blended it with GA4 data. Additionally Dot Analytics provides us with a lot of analytical insides about our product.

RESULTS & FEEDBACK

What were the measurable outcomes from the project that demonstrate progress or success?

Mixpanel analytic events have been configured by Dot Analytics and the company built the dashboard in Looker Studio that provides necessary information about users. They give attention to data security and data access.

Describe their project management. Did they deliver items on time? How did they respond to your needs?

Everything was on time, good-organised. We used Telegram as a communication channel, all technical documentation was saved on our Google Drive. The guys are flexible and we could have a meeting with them in Google Hangouts at any time.

What was your primary form of communication with Dot Analytics?

• Virtual Meeting
• Email or Messaging App

What did you find most impressive or unique about this company?

They've offered an excellent match of the services' costs and the obtained results.

Are there any areas for improvement or something Dot Analytics could have done differently?

It would be perfect if they have a full stack developer available in their team.

BACKGROUND

Please describe your company and your position there.

I'm CEO of the DataDuck - data analytics and software company.

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Dot Analytics?

DataDuck partnered with Dot Analytics to make the series of dashboards and visualizations based on logs received from elevators. At the outset, it was clear that the team faced a series of challenges regarding data analytics and data visualizations: Elevators send signals in a format that is hard to analyze. Each elevator generates a massive amount of data but the calculations of statistics should be fast to keep the good user experience.

SOLUTION

How did you select this vendor and what were the deciding factors?

DataDuck was looking for a data visualization service provider with a strong track record in data visualization, utilizing tools such as SQL, Python, Plotly Dash. Comprehensive English language proficiency and excellent communication skills were essential pre-requisites.

Describe the project in detail and walk through the stages of the project.

The project may be divided into three phases: design of the proof of concept, development of the proof of concept web application, adaptations of the POC web application to the production environment. The first phase ran over four weeks and the second phase ran over two month. The conclusions of the first two phases were successful and gave the basis for the third phase. The main goal of the third phase was to prepare the platform architecture for moving to Google or AWS cloud.

How many resources from the vendor's team worked with you, and what were their positions?

The team consists of four persons: Analytics Team Lead, Data Visualization Expert and Data Engineer, Graphic Designer. The communication was made by email and Whatsapp. From the DataDuck side we worked with the Senior Data Engineer.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

The application has been deployed, but it's not available publicly.

How effective was the workflow between your team and theirs?

The majority of communication was conducted through email, along with weekly meetings with the principal data engineer at DataDuck.

What did you find most impressive or unique about this company?

Dot Analytics are the strong data analytics guys. They were listening to our needs and provided solutions very quickly.

Are there any areas for improvement or something they could have done differently?

Quicker MVP, simplified.

BACKGROUND

Please describe your company and your position there.

I am the CTO of ClassTag. ClassTag is an advanced parent-teacher communication platform that helps every student succeed. ClassTag allows teachers and parents to easily engage with one another and share resources. Whether you're in the classroom, at home, or anywhere in between, ClassTag makes it easy to connect and build an amazing classroom community.

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Dot Services?

We were looking for a team that can support us long-term with Google Analytics implementation. We needed help to configure our analytics, tag manager, and reporting.

SOLUTION

How did you select this vendor and what were the deciding factors?

We were interested in the Dot Services profile on Upwork. The Tech stack in the description was suitable for our needs. We scheduled a meeting and decided to hire Dot Services because analysts are highly professional.

Describe the project in detail and walk through the stages of the project.

We had a problem with tracking custom event parameters in Google Analytics. Google Analytics didn’t display custom event parameters. After some research Dot Analytics identified the cause of the tracking problem. Because of the small number of events, it was impossible to see them in Google Analytics.

Dot Services suggested the following solution: they transferred data from Google Analytics to BigQuery. Such action allowed getting all event parameters using SQL. After that, Dot Analytics built a dashboard in Data Studio with all information about custom event parameters.

How many resources from the vendor's team worked with you, and what were their positions?

One Data Analyst who worked full time on issues.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

Dot Services built a dashboard in Data Studio that provides clear information about our Google Analytics issue.

How effective was the workflow between your team and theirs?

All communication was going through Upwork and we had meetings with the data analyst.

What did you find most impressive or unique about this company?

The data analyst has the expertise, understands what is the root cause of the problem, and effectively solves it.

Are there any areas for improvement or something they could have done differently?

We are pleased with Dot Services' outputs.

BACKGROUND

Please describe your company and your position there.

I am the CEO at Organization.GG, a marketplace for online Experienced in web3.

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Arcane Future?

We have quite developed system with Presto DWH and Tableau dashboards on our projects. We were looking for an expert who can build something by using the existing data infrastructure.

SOLUTION

How did you select this vendor and what were the deciding factors?

We made a few interviews with the team and they demonstrated high level of the understanding of our needs and competency in Tableau and SQL. Also, they had relevant experience in social sites and dating apps which was a big plus for us. They also helped us with some of our design needs. We were looking for someone to help us with our deck presentation and they referred us to their partner - Dot Design. They also did a great job on time.

Describe the project in detail and walk through the stages of the project.

At first team learned how the data structured and where the data is stored. They used and learned the product and received technical requirements from executive department. Then guys developed the dashboards, tested them and published to the production environment.

How many resources from the vendor's team worked with you, and what were their positions?

Tableau Expert, Senior Data Analyst and a Designer.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

They successfully developed the necessary dashboards with all the necessary financial KPIs and created a well-designed and structured deck with solid illustrations.

How effective was the workflow between your team and theirs?

Management of the project was via Slack and the team maintained very high response rate from start to the project completion. Work with them was easy.

What did you find most impressive or unique about this company?

They don’t waste time and carefully listen to our feedback. But most important is that I got both analytics and design services through their monthly subscription. It took away all the hassle away on bargaining the price and tracking work. Additionally, this gives an opportunity to receive a turn-key solution both for the analytics and design.

Are there any areas for improvement or something they could have done differently?

I assume no. Definitely we would like to use their services for the next projects.

BACKGROUND

Please describe your company and your position there.

I am executive assistant of COO in dating company

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Arcane Future?

We have quite developed system with Presto DWH and Tableau dashboards on our projects and required an expert who can build something by using the existing data infrastructure.

SOLUTION

How did you select this vendor and what were the deciding factors?

We made a few interviews with the team and they demonstrate high level of the understanding of our needs and competency in Tableau and SQL. Also, they had relevant experience in social sites and dating apps. This was a big plus for us.

Describe the project in detail and walk through the stages of the project.

At first team learned how the data structured and where the data is stored. They used and learned the product and received technical requirements from executive department. Then guys developed the dashboards, tested them and published to the production environment.

How many resources from the vendor's team worked with you, and what were their positions?

Tableau Expert and Senior Data Analyst.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

They successfully developed the dashboards with all the necessary financial KPIs.

How effective was the workflow between your team and theirs?

Management of the project was via Slack and the team maintained very high response rate from the beginning to the project completion. Work with them was easy.

What did you find most impressive or unique about this company?

Guys don’t waste time, carefully listen to the feedback and like what they are doing. Together these qualities make from them a very good analytical team.

Are there any areas for improvement or something they could have done differently?

I assume no. Definitely we would like to use their services for the next projects.

BACKGROUND

Please describe your company and your position there.

Fulcrum Rocks designs and develops sites, mobile and desktop applications. We work with companies from such industries: Video Games, Blockchain, Cybersecurity, Real Estate, Education, etc. I'm a CFO, so to speak, I manage capital resources across the company.

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Arcane Future?

In 2019 we purchased and implemented the financial product Finbase System. This product has already had automatic financial dashboards. During its exploitation, we noticed that the default dashboards don't answer all financial and project managers' questions. Therefore we decided to find a team that will develop new project and financial dashboards based on the Finbase System's data.

What were your goals for this project?

We anticipate the incorporation of the dashboards into our weekly meetings. So that every project manager has data instrument to monitor and to increase the team performance. Also, we wanted to have a tool that visualizes team members' workload for a period greater than one month. Last but not least, we wanted to gather all our KPIs at one dashboard.

SOLUTION

How did you select Arcane Future?

Based on satisfying feedback from other projects, we knew that experts from Arcane Future could find a solution to our problem. Therefore we invited them and conducted three interviews at which we agreed about project deliverables, estimates, and deadlines.

Describe the project in detail.

The scope of the project can be divided into three parts. The first part was to research the current data storage and define its use cases. The second part was to change the data architecture so that the legacy functionality remains available. The third part was to create the dashboards and present them to the Fulcrum Rocks team.

In this project, I coordinated the work between our and Arcane Future's teams. Therefore I gave them information and task requirements and controlled the results. Arcane Future's team created the operational plan and divided it into small iterations. The length of each iteration was one week. After each iteration, we scheduled a retrospective session on which we discussed done changes and future tasks.

What was the team composition?

The team consists of the data architect and dashboard developer.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

We discovered the information and the format we want to have on the dashboards within a few iterations. This data helps our managers to conduct meetings and focus more on weak points of the working process. Compared to our expectations, Arcane Future's team outperformed our expectations since they not merely execute tasks based on requirements but take an active part in negotiating the right solution.

How effective was the workflow between your team and theirs?

The vendor's team manages their workflow intrinsically by using the Notion app. We maintain communication via Telegram. Ihor - he is the Arcane Future team representative, was responsible for scheduling a weekly meeting at a convenient time for us. Also, he translated everything spoken on the meetings into the tasks for Arcane Future's team.

What did you find most impressive about this company?

We have a complex system with a lot of hidden intrinsic dependencies that should be saved. They perfectly understood our case and were able to suggest improvements not only on the level of the task - but on the level of the whole project architecture.

Are there any areas for improvement?

We will be working with Arcane Future in the future; nonetheless, we think that there is always room for improvements, but actually, everything is fine.

BACKGROUND

Introduce your business and what you do there.

I’m the owner of a gaming application.

OPPORTUNITY / CHALLENGE

What challenge were you trying to address with Arcane Future?

I was looking for someone to help me with math modeling and machine learning for my gaming application.

SOLUTION

What was the scope of their involvement?

I wanted to create a game with a custom control mod, utilizing the device’s the front camera and either the hand or something in hand to control the game.

The project involved doing research on how to use computer vision libraries to determine what needs to happen in front of the device through the front camera. They built a motion tracking model based on neural network. They created an MVP, and we are now working on the real application for iOS and Android.

What is the team composition?

I’m in contact with three people from their team. There may be other people working on the project, but I’m not in touch with them.

How did you come to work with Arcane Future?

A friend of mine recommended Arcane Future. I chose them because they know how to do math model with machine learning.

How much have you invested in them?

I’ve spent around $12,000 so far.

What is the status of this engagement?

I began working with them in February 2019, and the work is still ongoing.

RESULTS & FEEDBACK

What evidence can you share that demonstrates the impact of the engagement?

So far, all of their work has been a success. The math model works with the computer vision feature, which was our first success point and following that, the MVP works well on any type of browser. We’re now waiting for the final application for iOS and Android.

How did Arcane Future perform from a project management standpoint?

Everything is good and there have been no problems. We mostly use Slack, email, and Skype to communicate.

What did you find most impressive about them?

Their experience in machine learning technologies and the speed of the research they did were both impressive.

Are there any areas they could improve?

Everything has been fine, and I’m happy with them.

Do you have any advice for potential customers?

They’re a good choice for smaller projects as the team isn’t too large and can be flexible. If a bigger project requires a lot of people and management, it might be better to use a bigger company.

BACKGROUND

Please describe your company and position.

 I am the CEO of an advertising & marketing company 

Describe what your company does in a single sentence.

Digital Marketing Agency

OPPORTUNITY / CHALLENGE

What specific goals or objectives did you hire Dot Analytics to accomplish?

• Enhanced ecommerce tracking to GA4 at Shopify
• Javascript development of GTM data layer

SOLUTION

How did you find Dot Analytics?

Other

Why did you select Dot Analytics over others?

Company values aligned

How many teammates from Dot Analytics were assigned to this project?

2-5 Employees

Describe the scope of work in detail. Please include a summary of key deliverables.

We get integration insights from Dot Analytics' expert in the Q&A. They Installed enhanced ecommerce tracking to Google Analytics 4 and developed a custom GTM dataLayer for sending data to GA4. They delivered accurate order tracking mechanism and events flow tracking to Google Ads campaigns at Shopify platform.

RESULTS & FEEDBACK

What were the measurable outcomes from the project that demonstrate progress or success?

The ultimate goal was to set up precise conversion tracking.

Describe their project management. Did they deliver items on time? How did they respond to your needs?

We communicated directly to their CEO, Ihor Syzon, he was always in touch, and the speed of work was in line with the deadlines.

What was your primary form of communication with Dot Analytics?

• Virtual Meeting
• Email or Messaging App

What did you find most impressive or unique about this company?

Their experience with Google Cloud Platform (GA4, GTM) and Shopify e-commerce was a valuable asset for us.

Are there any areas for improvement or something Dot Analytics could have done differently?

Our request was mostly for data engineering services. But given the amount of data we collect we need to test their skills as data analysts and data scientists to grow our marketing and product.

BACKGROUND

Please describe your company and position.
I am the CEO of Mo Meditation Inc.

Describe what your company does in a single sentence.
Mo is a mobile application for sleep, meditation, and relaxation.

OPPORTUNITY / CHALLENGE

What specific goals or objectives did you hire Dot Analytics to accomplish?
Now we are in the process of scaling our marketing campaigns. We started to spend more money on marketing and we were looking for an instrument which will show us what our campaigns are profitable and what didn’t. What was also important for us is understanding how the prediction algorithm works inside and what is the logic behind the prediction. So we hired Dot Analytics guy’s to make those algorithm for us and launch it on our Google Cloud.

SOLUTION

How did you find Dot Analytics?
Online Search

Why did you select Dot Analytics over others?

• Great culture fit
• Good value for cost

How many teammates from Dot Analytics were assigned to this project?
2-5 Employees

Describe the scope of work in detail. Please include a summary of key deliverables.
One data analyst, Anton H., worked mainly on the prediction algorithm and the dashboard. And one more data analyst, Ihor Syzon, made the roadmap, worked with GCP infrastructure and Vertex AI. We say thank you, since we get the dashboard where we see the accurate proceeds prediction by campaign, country and media source.

RESULTS & FEEDBACK

What were the measurable outcomes from the project that demonstrate progress or success?
The script was launched on our Vertex AI. The analysts helped us to schedule the daily refresh of the prediction algorithm which save results to BigQuery tables. Then Looker Studio takes data from those BigQuery tables and shows the forecast in the dashboard with 4 filters.

Describe their project management. Did they deliver items on time? How did they respond to your needs?
The workflow was smooth. We added Ihor Syzon to our Slack, and had meetings via Google Hangouts. We appreciate that they can manage themselves without extra supervision.

What was your primary form of communication with Dot Analytics?

• Virtual Meeting
• Email or Messaging App

What did you find most impressive or unique about this company?
They're professional, energetic, creative, and open-minded.

Are there any areas for improvement or something Dot Analytics could have done differently?
Hard to answer this tricky question.

BACKGROUND

Please describe your company and your position there.

I'm a director at Aim44 Limited; a professional services consultancy specialising in delivering video streaming strategy, design and integration of cloud based streaming services to broadcasters.

OPPORTUNITY / CHALLENGE

For what projects/services did your company hire Dot Analytics?

Aim44 Limited partnered with Dot Services to integrate Conviva’s streaming analytics platform into the itv data ecosystem, which was focused in the first instance on Splunk logs, Google Analytics and BigQuery tables. At the outset, it was clear that the team faced a series of challenges regarding streaming data analytics and data based decision making:

• Only the service delivery department understood how the streaming data should be formatted
• Only the service delivery department understood errors and inconsistencies in the data
• Other departments were unable to make decisions based on the data without the direct involvement of the service delivery department to provide the insights

The challenge was to bring order and transparency to this data and drive adaptation and utlisation of this data across departments at itv.

SOLUTION

How did you select this vendor and what were the deciding factors?

ITV was looking for a data analytics service provider strong track record in data optimisation, utlilising tools such as BigQuery, SQL, Data Studio. Along with the provision of specialist data analytics services, the service provider was expected to engage regularly with internal stakeholders through online meetings; gathering requirements, explaining complex concepts in easy to understand ways. Comprehensive English language proficiency and excellent communication skills were essential pre-requisites.

Describe the project in detail and walk through the stages of the project.

The first phase, conducted as a proof of concept (POC), ran over eight weeks with three main objectives: Integrate Stream Sensor into a defined subset of players, measure the quality of the data, and finally compare the data between the old and new systems. The conclusion of the POC was successful and gave ITV the basis to sign a long term contract with Conviva and thus continue with the integration work.

The second phase was devoted to integration of the Ads data with the Conviva platform and substitution of the Splunk alerts by Conviva alerts. AI and Manual alerts help to eliminate manual search for errors; therefore it was crucial this process be codified. The goals of the third phase was to educate the employees from other departments to use Conviva independently of the service delivery department and set up the weekly errors reporting process.

How many resources from the vendor's team worked with you, and what were their positions?

One data analyst on the itv side worked full time on data comparison issues and errors analysis. Providing assistance to anyone in the team with questions related to the Conviva service.

RESULTS & FEEDBACK

Can you share any outcomes from the project that demonstrate progress or success?

Conviva successfully integrated into the itv data ecosystem; substituting the old system in terms of alerting, reporting and analysis to the degree that the service delivery department and other departments started to use it in their own analysis and reporting. This state is a qualitative step forward from the previous state where departments outside of data analytics did not have access to this data to drive their decision making.

How effective was the workflow between your team and theirs?

The majority of communication was conducted through Slack, along with weekly meetings with the principal data analyst at itv.

What did you find most impressive or unique about this company?

Their data analyst has the capability and understanding to operate proactively and autonomously. Ihor was thus able to set prioritisations and schedules, deliver the implementation and get around issues without requiring extensive external input.

Are there any areas for improvement or something they could have done differently?

We are very happy with the results of the work delivered by Dot Analytics and hope to continue working with them on future projects.