ODSC - Open Data Science

SEPTEMBER 27, 2023

In this article, we will delve into the concept of data lakes, explore their differences from data warehouses and relational databases, and discuss the significance of data version control in the context of large-scale data management. Schema Enforcement: Data warehouses use a “schema-on-write” approach.

Data Lakes 98

Data Lakes Data Warehouse Database Big Data 98

ODSC - Open Data Science

JUNE 12, 2023

This article is an excerpt from the book Expert Data Modeling with Power BI, Third Edition by Soheil Bakhshi, a completely updated and revised edition of the bestselling guide to Power BI and data modeling. in an enterprise data warehouse. What is a Datamart?

Power BI 52

Power BI Data Warehouse ETL Data Preparation 52

Pickl AI

NOVEMBER 4, 2024

Summary: The fundamentals of Data Engineering encompass essential practices like data modelling, warehousing, pipelines, and integration. Understanding these concepts enables professionals to build robust systems that facilitate effective data management and insightful analysis. What is Data Engineering?

Data Engineering 52

Data Engineering Data Engineer Data Engineering Data Engineering 52

Tableau

APRIL 3, 2023

Madeleine Corneli Senior Manager, Product Management, Tableau Adiascar Cisneros Manager, Product Management, Tableau Bronwen Boyd April 3, 2023 - 5:27pm April 3, 2023 Google Cloud’s BigQuery is a serverless, highly-scalable cloud-based data warehouse solution that allows users to store, query, and analyze large datasets quickly.

Tableau 98

Tableau SQL Data Warehouse Database 98

phData

JULY 17, 2023

Over the past few decades, the corporate data landscape has changed significantly. The shift from on-premise databases and spreadsheets to the modern era of cloud data warehouses and AI/ LLMs has transformed what businesses can do with data. Data modeling, data cleanup, etc.

Data Warehouse 52

Data Warehouse Data Pipeline Cloud Data ETL 52

Mlearning.ai

FEBRUARY 16, 2023

The ultimate need for vast storage spaces manifests in data warehouses: specialized systems that aggregate data coming from numerous sources for centralized management and consistency. In this article, you’ll discover what a Snowflake data warehouse is, its pros and cons, and how to employ it efficiently.

Data Warehouse 52

Data Warehouse Business Intelligence Business Intelligence Database 52

phData

OCTOBER 9, 2023

Understanding Data Vault Modeling Created in the 1990s by a team at Lockheed Martin, data vault modeling is a hybrid approach that combines traditional relational data warehouse models with newer big data architectures to build a data warehouse for enterprise-scale analytics.

ETL 69

ETL Clustering Data Warehouse SQL 69

Tableau

APRIL 3, 2023

Madeleine Corneli Senior Manager, Product Management, Tableau Adiascar Cisneros Manager, Product Management, Tableau Bronwen Boyd April 3, 2023 - 5:27pm April 3, 2023 Google Cloud’s BigQuery is a serverless, highly-scalable cloud-based data warehouse solution that allows users to store, query, and analyze large datasets quickly.

Tableau 52

Tableau SQL Data Warehouse Database 52

phData

SEPTEMBER 26, 2023

The necessary access is granted so data flows without issue. SQL Server Agent jobs). Either way, it’s important to understand what data is transformed, and how so. More often than not, the SQL code used to perform the transformation won’t be able to run as-is from the current system to Snowflake.

SQL 52

SQL Database ETL Data Models 52

Pickl AI

JULY 3, 2023

It is the process of converting raw data into relevant and practical knowledge to help evaluate the performance of businesses, discover trends, and make well-informed choices. Data gathering, data integration, data modelling, analysis of information, and data visualization are all part of intelligence for businesses.

Business Intelligence 52

Business Intelligence Business Intelligence SQL Data Visualization 52

phData

AUGUST 16, 2023

In the era of data modernization, organizations face the challenge of managing vast volumes of data while ensuring data integrity, scalability, and agility. What is a Data Vault Architecture? It is agile, scalable, no pre-modeling required, and well-suited for fluid designs. Using dbt is one of the best choices.

Data Warehouse 52

Data Warehouse Data Governance Data Modeling Data Models 52

Pickl AI

AUGUST 9, 2024

Hierarchies align data modelling with business processes, making it easier to analyse data in a context that reflects real-world operations. Designing Hierarchies Designing effective hierarchies requires careful consideration of the business requirements and the data model.

Data Warehouse 52

Data Warehouse Data Quality Business Intelligence Business Intelligence 52

phData

AUGUST 10, 2023

Data Vault - Data Lifecycle Architecturally, let’s understand the data lifecycle in the data vault into the following layers, which play a key role in choosing the right pattern and tools to implement. Data Acquisition: Extracting data from source systems and making it accessible.

SQL 52

SQL Data Observability Data Quality Data Pipeline 52

Pickl AI

JUNE 7, 2024

Also Read: Top 10 Data Science tools for 2024. It is a process for moving and managing data from various sources to a central data warehouse. This process ensures that data is accurate, consistent, and usable for analysis and reporting. This process helps organisations manage large volumes of data efficiently.

ETL 40

ETL Data Quality Data Pipeline Data Warehouse 40

Smart Data Collective

JUNE 16, 2022

There are a lot of important queries that you need to run as a data scientist. This tool can be great for handing SQL queries and other data queries. Every data scientist needs to understand the benefits that this technology offers. You need to utilize the best tools to handle these tasks. Using OLAP Tools Properly.

Analytics 131

Analytics Analytics Data Scientist Data Warehouse 131

phData

OCTOBER 17, 2024

dbt offers a SQL-first transformation workflow that lets teams build data transformation pipelines while following software engineering best practices like CI/CD, modularity, and documentation. But you still want to start building out the data model. The Translation Tool takes care of all of that for you.

AI 52

AI AI SQL Data Quality 52

Pickl AI

JULY 25, 2023

Data engineers are essential professionals responsible for designing, constructing, and maintaining an organization’s data infrastructure. They create data pipelines, ETL processes, and databases to facilitate smooth data flow and storage. Data Visualization: Matplotlib, Seaborn, Tableau, etc.

Data Engineering 52

Data Engineering Data Engineer Data Engineering Data Engineering 52

Pickl AI

APRIL 6, 2023

Understand the fundamentals of data engineering: To become an Azure Data Engineer, you must first understand the concepts and principles of data engineering. Knowledge of data modeling, warehousing, integration, pipelines, and transformation is required. Hands-on experience working with SQLDW and SQL-DB.

Azure 52

Azure Data Engineering Data Engineering Data Engineering 52

phData

JUNE 27, 2023

Using SQL-centric transformations to model data to be deployed. dbt is also great for data lineage and documentation to empower business analysts to make informed decisions on their data. Data Ingestion with Fivetran Fivetran is used to move your source(s) into a centralized space for storage.

SQL 52

SQL Database Data Quality Data Warehouse 52

phData

NOVEMBER 2, 2023

From real-time streaming to batch processing and beyond, these tables offer a new level of flexibility and efficiency for data teams. Snowflake Dynamic Tables are a new table type that enables data teams to build and manage data pipelines with simple SQL statements. What are Snowflake Dynamic Tables?

Data Pipeline 52

Data Pipeline SQL Data Warehouse Data Engineer 52

phData

MAY 25, 2023

One of the easiest ways for Snowflake to achieve this is to have analytics solutions query their data warehouse in real-time (also known as DirectQuery). The June 2021 release of Power BI Desktop introduced Custom SQL queries to Snowflake in DirectQuery mode. This ensures the maximum amount of Snowflake consumption possible.

Power BI 84

Power BI Analytics Analytics Azure 84

Pickl AI

AUGUST 11, 2024

Retail Sales In a retail data warehouse , the sales fact table might include metrics such as sales revenue, units sold, discounts applied, and profit margins. Web Analytics In a web analytics data warehouse, the page views fact table might include metrics such as total page views, unique visitors, session duration, and bounce rate.

Data Quality 52

Data Quality Data Warehouse Data Governance Business Intelligence 52

phData

FEBRUARY 8, 2024

Data Modeling, dbt has gradually emerged as a powerful tool that largely simplifies the process of building and handling data pipelines. dbt is an open-source command-line tool that allows data engineers to transform, test, and document the data into one single hub which follows the best practices of software engineering.

Data Modeling 52

Data Modeling Data Models Data Warehouse Database 52

IBM Journey to AI blog

JANUARY 5, 2023

The right data architecture can help your organization improve data quality because it provides the framework that determines how data is collected, transported, stored, secured, used and shared for business intelligence and data science use cases. Perform data quality monitoring based on pre-configured rules.

Data Quality 52

Data Quality Data Lakes Data Warehouse Business Intelligence 52

IBM Journey to AI blog

SEPTEMBER 19, 2023

And you should have experience working with big data platforms such as Hadoop or Apache Spark. Additionally, data science requires experience in SQL database coding and an ability to work with unstructured data of various types, such as video, audio, pictures and text.

Data Science 98

Data Science Analytics Analytics Data Scientist 98

phData

JULY 12, 2023

Businesses today are grappling with vast amounts of data coming from diverse sources. To effectively manage and harness this data, many organizations are turning to a data vault—a flexible and scalable data modeling approach that supports agile data integration and analytics.

Clustering 52

Clustering Data Warehouse Data Quality Data Modeling 52

Alation

OCTOBER 27, 2022

Few actors in the modern data stack have inspired the enthusiasm and fervent support as dbt. This data transformation tool enables data analysts and engineers to transform, test and document data in the cloud data warehouse. Jason: How do you use these models? How does this help the end user?

Data Analyst 52

Data Analyst Data Scientist Analytics Analytics 52

IBM Journey to AI blog

JULY 6, 2023

It uses advanced tools to look at raw data, gather a data set, process it, and develop insights to create meaning. Areas making up the data science field include mining, statistics, data analytics, data modeling, machine learning modeling and programming.

Machine Learning 80

Machine Learning Machine Learning Data Science Big Data 80

Alation

SEPTEMBER 7, 2021

Organizations need to ensure that data use adheres to policies (both organizational and regulatory). In an ideal world, you’d get compliance guidance before and as you use the data. Imagine writing a SQL query or using a BI dashboard with flags & warnings on compliance best practice within your natural workflow. In Summary.

Data Governance 59

Data Governance Data Scientist Data Quality Data Profiling 59

The MLOps Blog

MARCH 15, 2023

If you will ask data professionals about what is the most challenging part of their day to day work, you will likely discover their concerns around managing different aspects of data before they get to graduate to the data modeling stage. Uses secure protocols for data security.

Data Pipeline 59

Data Pipeline ETL SQL Data Quality 59

Alation

JULY 19, 2022

The traditional data science workflow , as defined by Joe Blitzstein and Hanspeter Pfister of Harvard University, contains 5 key steps: Ask a question. Get the data. Explore the data. Model the data. A data catalog can assist directly with every step, but model development.

Data Scientist 59

Data Scientist Data Quality Data Science Data Analyst 59

Dataconomy

MARCH 24, 2023

Some of the common career opportunities in BI include: Entry-level roles Data analyst:  A data analyst is responsible for collecting and analyzing data, creating reports, and presenting insights to stakeholders. They may also be involved in data modeling and database design.

Business Intelligence 70

Business Intelligence Business Intelligence Data Analysis Data Analysis 70

Dataconomy

MARCH 24, 2023

Some of the common career opportunities in BI include: Entry-level roles Data analyst:  A data analyst is responsible for collecting and analyzing data, creating reports, and presenting insights to stakeholders. They may also be involved in data modeling and database design.

Business Intelligence 70

Business Intelligence Business Intelligence Data Analysis Data Analysis 70

phData

JULY 18, 2023

With the birth of cloud data warehouses, data applications, and generative AI , processing large volumes of data faster and cheaper is more approachable and desired than ever. First up, let’s dive into the foundation of every Modern Data Stack, a cloud-based data warehouse.

Data Warehouse 52

Data Warehouse Analytics Analytics SQL 52

phData

APRIL 20, 2023

In today’s world, data-driven applications demand more flexibility, scalability, and auditability, which traditional data warehouses and modeling approaches lack. This is where the Snowflake Data Cloud and data vault modeling comes in handy. What is Data Vault Modeling?

Data Warehouse 72

Data Warehouse Data Governance Clustering Database 72

AWS Machine Learning Blog

SEPTEMBER 18, 2024

Additionally, Feast promotes feature reuse, so the time spent on data preparation is reduced greatly. It promotes a disciplined approach to data modeling, making it easier to ensure data quality and consistency across the ML pipelines.

AWS 120

AWS Machine Learning Machine Learning ML 120

phData

NOVEMBER 13, 2023

Streamlined Metric Creation and Management: With MetricFlow, you can easily establish and oversee company metrics through flexible abstractions and SQL query generation. Efficient Data Retrieval: Quick access to metric datasets from your data platform is made possible by MetricFlow’s optimized processes.

Database 52

Database Business Intelligence Business Intelligence Data Silos 52