In the journey of building and maintaining robust data pipelines...
Ir al contenido...
In the realm of analytics engineering with dbt (data build...
Ir al contenido...
In the journey of building and maintaining robust data pipelines with dbt (data build tool), mastering the core commands—run, test, docs, and seed—is crucial. These commands are the backbone of dbt’s functionality, enabling analytics engineers to transform raw data into Read More …
In the realm of analytics engineering with dbt (data build tool), one of the most crucial skills is translating complex business logic into performant SQL queries. This ability ensures that data models not only accurately represent the business requirements but Read More …
In the field of analytics engineering, especially when working with dbt (data build tool), developing modular models and adhering to DRY (Don’t Repeat Yourself) principles is not just a best practice—it’s a necessity for scalable, maintainable, and efficient data transformation Read More …
In the landscape of analytics engineering, dbt (data build tool) plays a pivotal role in transforming raw data into valuable insights. A fundamental concept within dbt that every analytics engineer must grasp is that of materializations. Materializations dictate how dbt Read More …
In the realm of analytics engineering, especially with tools like dbt (data build tool), developing efficient and reliable models is foundational to data transformation and analysis. A critical step in this development process is identifying and verifying any raw object Read More …
DBT (Data Build Tool) is an open-source tool that helps data analysts and engineers manage their data transformations in a scalable and maintainable manner. One of the key features of DBT is the ability to use macros to write reusable Read More …
Una de las grandes ventajas de dbt es que existen múltiples paquetes con soluciones a problemas comunes, mismos que puedes aprovechar en tus propios proyectos. En el paquete de dbt-utils existen distintas macros que te pueden ayudar con el día Read More …
Pandas profiling en python La librería pandas profiling en python ha estado por ahí desde 2016, aunque me parece que es injustamente impopular, pues ofrece la posibilidad de obtener una vista muy rápida y resumida de un conjunto de datos, Read More …
DBT (data build tool) es una librería en python creada por la compañía Fishtown Analytics (https://www.fishtownanalytics.com/). La versión más reciente (Junio de 2021) es dbt 0.19.1. Y es una gran herramienta para administrar las transformaciones y análisis que ocurren en Read More …
Macros en otro archivo de Excel Probablemente hayas pasado por esta situación en algunos de tus procesos manejando macros en VBA con Excel: necesitas ejecutar una macro, pero esta macro está en otro archivo, y en realidad no quieres pasar Read More …
