Business Intelligence Infrastructure
Developing a data warehouse in Snowflake to act as the single source repository of multiple data sources used by Finance, Marketing, Sales, and Customer Success orgs. Including migration of data from disparate instances of Salesforce, Netsuite, Zendesk, etc. via Talend as the ETL tool. Essentially an Extract-Load-Transform (ELT) approach;
Data Source ⇒ Extract and Load to Data Warehouse (Talend) ⇒ Transformation using views for standard joins/unions and regularly applied data manipulation (Snowflake)
Once in the data warehouse, use Tableau as the front-end BI tool to analyze and develop dashboards for reoccurring business reports.
Kaggle Competition
There is a pretty significant prize out there for you data geeks if you have some free time to take on the Zillow “Zestimate” machine learning algorithm. Submissions are evaluated on Mean Absolute Error between the predicted log error and the actual log error. The log error is defined as
logerror=log(Zestimate)−log(SalePrice)
I have started some preliminary data visualization and summary statistics on the variables. Please comment below if you’d like to join my team. The cool thing about this competition is you can submit unlimited results to see how you compare to others.