Finance BI

We build modern data infrastructure on Azure

Building on the cloud is hard. But it can give your company the flexibility it needs to do business in this fast changing world.

We can help you build a solid, flexible and cost-effective solution.

We are experts in Microsoft Azure and Databricks solutions, and have helped over 50 companies in their transformations across the years.

Ready for data to speed up your business instead of slowing it down? Let’s chat

Owner and Azure Data Consultant

Data Walnut

You worked hard to get your B2C e-commerce store off the ground. And now it’s doing well

But what is the potential of your store: how much better can it do ?

What would happen if you knew the customer lifetime value and could segment your customers ? 
And then find the best action for each segment?
What would happen if you knew the ROI of your marketing campaigns ?
What would happen if you knew the customers at risk of churn and how to retain them ?

You already have all the data, now it’s about getting your data to work for you.

Let’s take your store to the next level together

Founder

L'Oréal

Data and Finance Manager

Unilever

Strategy Analyst

Golder Associates (Italy)

Controller

Academy of Math and Science (USA)

Accountant/Controller

CPA turned Data Engineer: cut data crunching by 10 hours/week with automated processing and data quality checks ⚡️Azure - Databricks - Power BI

I can help you leverage your data in 2 ways:

1- Consulting activity: Azure data consulting
I help companies build a modern data infrastructure (data lake, data warehouse) on the Azure cloud.
Expertise: Azure, Synapse, Databricks, SQL, Python, Power BI

2- Data product: help e-commerce sites with customer retention
My solution helps e-commerce sites segment their customers, approach the segments differently and increase retention.
Expertise: Customer lifetime value, customer retention, customer upsell, B2C e-commerce.

Luca Zanna

Jump - Advisor AI

Staff Data Engineer

Orem Data

***Currently only taking advisory clients***

Modernizing data processes and tools to help startups drive revenue. I also do developer advocacy including technical writing as part of my independent work. 

● Managing full business operations, from client acquisition to solution development.
● Designing data strategies tailored to client needs, selecting the right tools, practices, and constructing a comprehensive data roadmap.
● Engineered an open-source-focused serverless stack with DuckDB, SQLMesh (Python models with Ibis), and S3 for a client.
● Developed data transformations in Python Polars while mentoring and empowering a data science team.
● Revamped and optimized a dbt project by automating the generation of source models from YAML and SQL files.
● Built an automated data system that parses emails, extracts attachments, and saves data to Google Drive.
● Producing technical content, blog articles, LinkedIn posts, and book(s) to educate, inspire, and support fellow data professionals.

Independent Consultant

Estuary

Content Partner

Humana

● Leading the BI user group across the department, delivering live training and consultations on BI implementations.
● Spearheading a CI/CD initiative using Azure DevOps for BI artifacts, enhancing the analytics lifecycle management.
● Managing stakeholders across teams and departments, ensuring seamless communication and collaboration on analytics projects.
● Developing end-to-end BI solutions, from gathering business requirements to building data models, metrics and visualizations.
● Integrating Azure Synapse Analytics with Power Platform (Power BI, Power Automate, Power Apps) to streamline BI solutions.

Senior Business Intelligence Engineer

Packt

I wrote "Polars Cookbook":
- Amazon: https://www.amazon.com/Polars-Cookbook-practical-transform-manipulate/dp/1805121154
- Packt:https://www.packtpub.com/en-us/product/polars-cookbook-9781805121152

Author

MasterControl

Business Intelligence Engineer

Data Clymer

● Implemented ELT pipelines and dashboards using Fivetran, BigQuery, Snowflake, Looker, Sigma, and Power BI.
● Developed a Fivetran custom connector in Python/Cloud Functions to unlock new data sources for analysis.
● Automated data pipelines to streamline investment decision-making, reducing manual effort by ~5 hours per week.
● Built an advanced Power BI data model supporting dynamic unit of measure conversions and analytics across multiple fact tables.
● Worked within an activity schema framework to standardize data modeling processes.
● Led business discussions to ensure technical solutions aligned with strategic objectives.

Analytics Engineer

Amplify Consulting Partners Inc

Working on the Microsoft project

● Led BI data model optimization efforts, reducing the dataset size and total refresh time by 50%~.
● Reengineered a dashboard, cutting the finance team’s manual workload by 40 hours per week, saving an estimated $100K annually
● Facilitated communications between business and the reporting team to translate the requirements into BI solutions.
● Acted as a bridge between business and reporting teams, ensuring effective translation of requirements into BI solution.

Analytics Consultant

Health Catalyst

Worked with/for Stanford Healthcare

● Developed Power BI solutions with advanced SQL, DAX, and Power Query to enhance visualization and analytics.
● Led a security initiative implementing a row/object level security along with metadata deployment in Power BI.
● Advised on BI architecture improvements to optimize data processing and modeling frameworks.
● Served as an internal BI expert, providing strategic guidance and best practices within the professional services department.

Analytics Engineer Intern

DigiCert, Inc.

●	Developed a Python package for upsert operation and improved the runtime of an ETL job from 3hrs to 10s.
●	Helped implement and maintain ETL jobs for our data warehouse with dimensional modeling.
●	Created a Python script to scrape over 1000 tables through web pages on Netcraft.

Data Engineer Intern

Analytics Engineer | Data Consultant

I'm currently working at Jump full-time. I still do independent consulting work in a limited capacity though. 

Reach out to me:
- yuki@oremdata.com
- https://oremdata.com
- cal.com/yuki-kakegawa

Blogs:
- https://thedatatoolbox.substack.com/
- https://stuffbyyuki.com/

Yuki Kakegawa

One stakeholder reached out to me on a problem he encountered. 

It seemed trivial but it was taking him a while to even figure out what's going on in his report. 

I went in, and after 15 min, all the issues were identified and solved. 

As a data hire, you bring a different perspective than others in the business. 

And this is just one of the many ways you can make an impact in your role. 

#data

Data @ Jump | Independent Data Consultant

You might think your decision was a waste of money and time.

For example, spending a lot of money to attend university.

Maybe 90 out of 100 classes you take aren't that useful.

But you might find 10 classes useful and be using what you learned to this day, with or without you knowing. 

And even if you think you paid just for those 10 classes, it might be worth it. 

This is just an example but I believe there are many more things like this in life. 

You might be benefiting from what you believed to be something completely useless and wasteful. 

#life #learning

A perfect guide to be successful as a husband:

1. If your spouse asks you to do something, do it yesterday
2. You keep everything in the house clean so your spouse doesn't even think of a need for cleaning
3. Cook or order the food your spouse loves before she knows she wants it

Anything I missed? 

#life #marriage #husbandcareer

Sometimes all you need is another set of eyes.

Your colleagues bring a different perspective you’d never think of.

They bring insights into your ideas because they come with different experiences than yours.

You might have an experience where you were struggling with a problem for hours and had someone take a look at it and they solved it in minutes.

That's the power of collaboration.

When you invite others into your thought process, you borrow their clarity.

You shorten your path to the solution and you learn faster! 

#careers #learning

My wife and I are starting to see the light at the end of the tunnel of this parenting challenge. 

The key has been both getting some outside help and being more observant about the situation. 

You're always learning as parents...

Open article: An Unexpected Parenting Challenge by open.substack.com

We often forget to be grateful for what we already have.

It's great that you work towards your goals but sometime it's as crucial if not more to take a step back and realize how far you've come.

And see what you've accomplished and realize that you have enough. 

Maybe that's all you need to do to find happiness and satisfaction in your work. 

#careers

taplio

The Battle

Luca Zanna

Yuki Kakegawa

Followers

Posts

Engagements

Likes

Performance ScoreYuki Kakegawa's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

Luca Zanna

Yuki Kakegawa

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Yuki Kakegawa's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreYuki Kakegawa's LinkedIn Performance