Data Modeling and Why It’s Important

Data transforms global processes, from disease research to revenue strategies, construction, and social media ads. Machine-readable data requires context; e.g., customer data needs to correspond to product purchases or price points. Data Modeling assigns relational rules, simplifying data for strategic decision-making. What is Data Modeling? Data modeling is a process of creating a visual representation […]

SQL do’s and don’ts

Originally posted here SQL do’s and don’ts Why bother? When I first learned SQL, my mindset was mostly “Meh, if it runs, it’s done”. Over time and with some reality checks, I have gone to the opposite of the spectrum and learned to — for lack of a better word —‘scrutinize’ SQL queries, for 2 […]

Data modeling pitfalls and where to find them

There are many works related to the data modeling task – technical side and business side of things, below are some important lessons I have learned along the way implementing data projects, as DA and AE. This post aims to draw some conclusions on the common pitfalls in data modeling works, why we (me) may […]

BI tools choice and its impact on model planning

  Sometimes well into the process of creating a dashboard, you may realize “uh oh, expected outcome isn’t compatible with current data model, due to some BI tool limitations”.  This article aims to explore some limits of different BI tools and what they mean for the data model planning stage (that should happen before creating […]

Exploratory Data Analysis (EDA) using SQL and Datagrip

Exploratory Data Analysis (EDA) is something that we do pretty frequently. This is the first and foremost step to do at the beginning of any project, before we jump into more sophisticated work like refactoring or modeling. It’s like saying ‘hi’ to your fellow lovely dataset so that we could gain confidence in every extracted […]

Contact Us!

Do you have a question or need more info? Please enter your information and describe your inquiry, and we’ll get back to you as soon as possible. Thanks!

Check out our Case Study!

We’d love to hear more from you. Tell us more about yourself and we’ll message you with our case studies as soon as we receive your message!