Smart Data Collective

APRIL 14, 2021

Main features include the ability to access and operationalize data through the LookML library. It also allows you to create your data and creating consistent dataset definitions using LookML. Formerly known as Periscope, Sisense is a business intelligence tool ideal for cloud data teams.

Business Intelligence 135

Business Intelligence Business Intelligence Tableau SQL 135

Hacker News

JULY 18, 2023

What if you could automatically shard your PostgreSQL database across any number of servers and get industry-leading performance at scale without any special data modelling steps? If you skip one of these steps, performance might be poor due to network overhead, or you might run into distributed SQL limitations.

Database 123

Database Data Modeling Data Models SQL 123

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

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. Is dbt an Ideal Fit for YOUR Organization’s Data Stack? It is a compiler and a runner. Proceed as you see fit.

SQL 52

SQL Database Data Quality Data Warehouse 52

phData

MAY 25, 2023

The June 2021 release of Power BI Desktop introduced Custom SQL queries to Snowflake in DirectQuery mode. While the loss of certain DAX functions is definitely a shortcoming that we hope Microsoft will address in the near future, the impact of these lost DAX functions is not necessarily as big as you would expect.

Power BI 84

Power BI Analytics Analytics Azure 84

Pickl AI

AUGUST 11, 2024

Consider factors such as data volume, query patterns, and hardware constraints. Document and Communicate Maintain thorough documentation of fact table designs, including definitions, calculations, and relationships. Establish data governance policies and processes to ensure consistency in definitions, calculations, and data sources.

Data Quality 52

Data Quality Data Warehouse Data Governance Business Intelligence 52

ODSC - Open Data Science

SEPTEMBER 27, 2023

Understanding Data Lakes A data lake is a centralized repository that stores structured, semi-structured, and unstructured data in its raw format. Unlike traditional data warehouses or relational databases, data lakes accept data from a variety of sources, without the need for prior data transformation or schema definition.

Data Lakes 98

Data Lakes Data Warehouse Database Big Data 98

Mlearning.ai

FEBRUARY 13, 2023

With the use of keys, relational databases can easily define relationships between data elements, making them ideal for structured data like customer information, financial transactions, and product inventory. Some of the most popular relational databases include Oracle, MySQL, and Microsoft SQL Server. Popular relational DBs 2.

Database 52

Database Data Modeling Data Models Big Data 52

Pickl AI

JUNE 7, 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. Definition and Explanation of the ETL Process ETL is a data integration method that combines data from multiple sources.

ETL 40

ETL Data Quality Data Pipeline Data Warehouse 40

Tableau

OCTOBER 8, 2021

With its LookML modeling language, Looker provides a unique, modern approach to define governed and reusable data models to build a trusted foundation for analytics. Additionally, Tableau allows customers using BigQuery ML to easily visualize the results of predictive machine learning models run on data stored in BigQuery.

Tableau 137

Tableau Analytics Analytics Machine Learning 137

Alation

FEBRUARY 13, 2020

This achievement is a testament not only to our legacy of helping to create the data catalog category but also to our continued innovation in improving the effectiveness of self-service analytics. A broader definition of Business Intelligence. Enabling workers to find the right data is crucial to promoting self-service analytics.

Business Intelligence 52

Business Intelligence Business Intelligence Analytics Analytics 52

Pickl AI

OCTOBER 21, 2024

It handles the underlying operations and ensures efficient data processing. The performance of the database engine significantly affects the overall efficiency of data transactions. Data Definition Language (DDL) DDL allows users to define the structure of the database.

Database 52

Database Apache Kafka Machine Learning Machine Learning 52

Tableau

OCTOBER 8, 2021

With its LookML modeling language, Looker provides a unique, modern approach to define governed and reusable data models to build a trusted foundation for analytics. Additionally, Tableau allows customers using BigQuery ML to easily visualize the results of predictive machine learning models run on data stored in BigQuery.

Tableau 98

Tableau Analytics Analytics Machine Learning 98

phData

JULY 14, 2023

Data Analysis Expressions (DAX) is the formula expression language employed in Power BI. With DAX, you can construct intricate calculations and queries on data residing in the Power BI data model. If you’re familiar with SQL, it is similar to a CASE statement, allowing for versatile conditional logic statements.

Power BI 52

Power BI Data Analyst Business Intelligence Business Intelligence 52

AWS Machine Learning Blog

AUGUST 21, 2023

Data professionals such as data scientists want to use the power of Apache Spark , Hive , and Presto running on Amazon EMR for fast data preparation; however, the learning curve is steep. Solution overview We demonstrate this solution with an end-to-end use case using a sample dataset, the TPC data model.

AWS 90

AWS Data Lakes Clustering Data Preparation 90

ODSC - Open Data Science

FEBRUARY 14, 2023

While this technology is definitely entertaining, it’s not quite clear yet how it can effectively be applied to the needs of the typical enterprise. The database would need to offer a flexible and expressive data model, allowing developers to easily store and query complex data structures.

Database 124

Database AI AI Natural Language Processing 124

Pickl AI

DECEMBER 4, 2023

and ‘‘What is the difference between Data Intelligence and Artificial Intelligence ?’. Criteria Data Intelligence Data Information Artificial Intelligence Data Analysis Definition Data Intelligence involves the analysis and interpretation of data to derive actionable insights. Look at the table below.

Data Analysis 52

Data Analysis Data Analysis Artificial Intelligence Artificial Intelligence 52

The MLOps Blog

OCTOBER 3, 2023

Mikiko Bazeley: You definitely got the details correct. I definitely don’t think I’m an influencer. You see them all the time with a headline like: “data science, machine learning, Java, Python, SQL, or blockchain, computer vision.” It’s almost like a very specialized data storage solution.

ML 52

ML ML Data Scientist Machine Learning 52

DagsHub

OCTOBER 23, 2024

Here’s the structured equivalent of this same data in tabular form: With structured data, you can use query languages like SQL to extract and interpret information. In contrast, such traditional query languages struggle to interpret unstructured data. This text has a lot of information, but it is not structured.

Machine Learning 52

Machine Learning Machine Learning AI AI 52

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. The following figure shows schema definition and model which reference it.

AWS 112

AWS Machine Learning Machine Learning ML 112

Mlearning.ai

JUNE 16, 2023

Generative AI can be used to automate the data modeling process by generating entity-relationship diagrams or other types of data models and assist in UI design process by generating wireframes or high-fidelity mockups. GPT-4 Data Pipelines: Transform JSON to SQL Schema Instantly Blockstream’s public Bitcoin API.

AI 52

AI AI Data Analysis Data Analysis 52

phData

NOVEMBER 13, 2023

Sidebar Navigation: Provides a catalog sidebar for browsing resources by type, package, file tree, or database schema, reflecting the structure of both dbt projects and the data platform. Version Tracking: Displays version information for models, indicating whether they are prerelease, latest, or outdated.

Database 52

Database Business Intelligence Business Intelligence Data Silos 52

phData

JULY 18, 2023

Support for Numerous Data Sources: Fivetran supports over 200 data sources, including popular databases, applications, and cloud platforms like Salesforce, Google Analytics, SQL Server, Snowflake, and many more. Additionally, unsupported data sources can be integrated using Fivetran’s cloud function connectors.

Data Warehouse 52

Data Warehouse Analytics Analytics SQL 52