About: aluo

Avatar photo

Bio: Alan has been working in the field of Ecommerce for 4 years and has extensive knowledge in Online Marketing and Data Analytics. He has practical experience scraping and cleaning data and has tackled a few data science projects in his career. During his free time, he would listen to 80s pop and J-rock, or would try a few riffs on his guitar.

Posts by aluo:

How to Effectively Compare Data from Two Different Salesforce Systems

Posted on: 14 Oct 2021

Comparing data between systems is necessary for businesses that are looking to migrate, adjust or back up data. The issue, however, is that data comparisons are tedious, repetitive, and time-consuming. Users have to detect changes that occurred in multiple cells under the same record, with potentially millions of records existing in the compared objects.

Create Better Membership Dashboards With Apache Superset

Posted on: 11 Mar 2021

Dashboards have always been a crucial part of analytics. As the demand for Business Intelligence (BI) tools increase each year, the amount associations spend on BI products has followed suit. Robust platforms, such as Einstein Analytics and Domo, mainly charge fees by user count. This in turn might limit the number of users that can see visualizations. Should an association have hundreds or even thousands of employees that need to look at internal data, being limited by budget towards BI tools is not a great way to start your data deep dive.

Leverage Einstein Prediction Builder For Your Association

Posted on: 31 Aug 2020

For Einstein Prediction Builder to work, you need a well structured dataset that contains multiple variables and one predictive outcome. The prediction outcomes that Einstein Prediction Builder can generate is limited to a Yes/No answer or a Numerical Value. For instance, if you want to predict how much revenue a contact is likely to generate (customer lifetime value), you can set your total sales as your numerical outcome.

Superset – An Open Source Dashboard Builder

Posted on: 18 Jun 2020

Superset is an open source BI tool that is used for building dashboards. It can connect to a variety of data sources, such as relational database management systems (e.g. mysql, sql server), Enterprise Data Warehouses (e.g. AWS Redshift) and certain apps (e.g. Google Sheets).