Alation

SEPTEMBER 7, 2021

In the previous blog , we discussed how Alation provides a platform for data scientists and analysts to complete projects and analysis at speed. In this blog we will discuss how Alation helps minimize risk with active data governance. So why are organizations not able to scale governance? Meet Governance Requirements.

Data Governance 59

Data Governance Data Scientist Data Quality Data Profiling 59

phData

JULY 10, 2024

Sigma Computing , a cloud-based analytics platform, helps data analysts and business professionals maximize their data with collaborative and scalable analytics. One of Sigma’s key features is its support for custom SQL queries and CSV file uploads. These tools allow users to handle more advanced data tasks and analyses.

SQL 52

SQL Data Warehouse Analytics Analytics 52

Pickl AI

FEBRUARY 6, 2023

Preparing for the SQL interview questions to become more proficient in data science with example questions and a framework for answering them. Amongst the different tools that data scientists must have in their arsenal, SQL holds a special significance.

Data Analyst 52

Data Analyst SQL Data Science Database 52

Data Science Blog

NOVEMBER 15, 2023

Example Event Log for Process Mining The following example SQL-query is inserting Event-Activities from a SAP ERP System into an existing event log database table. They offer consistency and standardization across data structures, improving data accuracy and integrity.

Data Modeling 245

Data Modeling Data Models Business Intelligence Business Intelligence 245

Data Science Blog

MAY 15, 2023

Darüber hinaus können Data Governance- und Sicherheitsrichtlinien auf die Daten in einem Data Lakehouse angewendet werden, um die Datenqualität und die Einhaltung von Vorschriften zu gewährleisten. Mit der zunehmenden Datenmenge und -vielfalt wurde die Verwaltung von Data Warehouses jedoch immer schwieriger und teurer.

Data Warehouse 147

Data Warehouse Data Lakes Azure AWS 147

Data Science Dojo

JULY 6, 2023

It offers extensibility and integration with various data engineering tools. dbt (Data Build Tool): dbt is an open-source data transformation and modeling tool. It allows data engineers to build, test, and maintain data pipelines in a version-controlled manner.

Data Engineering 195

Data Engineering Data Engineering Data Engineering Data Engineer 195

Data Science Dojo

JANUARY 12, 2023

Insights of data warehouse A data warehouse is a database designed for the analysis of relational data from corporate applications and transactional systems. The results of rapid SQL queries are often utilized for operational reporting and analysis; thus, the data structure and schema are set in advance to optimize for this.

Data Lakes 221

Data Lakes Data Warehouse Hadoop Machine Learning 221

Alation

MARCH 8, 2022

Aligning disparate departments on key terms creates shared understanding, so data is used consistently and appropriately. Empowers people to innovate with intelligent SQL editor. Of course, once users find the data they need, self-service data analytics must help them use the data independently.

Analytics 52

Analytics Analytics Data Governance SQL 52

AWS Machine Learning Blog

MAY 9, 2024

Data governance – With a wide variety of users accessing the platform and with different users having access to different data, data governance and isolation was paramount. It also did exceedingly well at SQL generation, better than any other model they tested.

AI 130

AI AI AWS Data Governance 130

phData

AUGUST 25, 2023

The migration of SSRS (SQL Server Reporting Services) reports to Power BI Service marks a significant shift in data visualization and reporting capabilities. During the migration process, existing.rdl reports are pointed to a Snowflake Data Cloud database from an existing data source in Power BI Report Builder.

Power BI 52

Power BI SQL Data Governance Database 52

Data Science Dojo

OCTOBER 10, 2023

Link to event -> IMPACT 2o23 Key topics covered IMPACT brings together the data community to showcase the latest and greatest trends, technologies, and processes in data quality, large-language models, data and AI governance, and of course, data observability. Link to event -> Live!

AI 243

AI AI Data Observability Artificial Intelligence 243

phData

JUNE 6, 2023

This series is meant to keep the data community up-to-speed on the latest and greatest project accelerators, data governance enablement, and automation that phData has to offer. This toolkit is leveraged by our staff and customers as we continue to work with customers across a variety of data practices, verticals, and projects.

SQL 52

SQL Data Governance AWS Database 52

Analytics Vidhya

FEBRUARY 2, 2023

Introduction Data analytics solutions collect, process, and analyze data to extract insights and make informed business decisions. The need for a data analytics solution arises from the increasing amount of data organizations generate and the need to extract value from that data.

Analytics 301

Analytics Analytics Data Visualization Data Analysis 301

Alation

FEBRUARY 20, 2020

Experts who understand certain datasets often play the stewardship role of ensuring that data consumers can make accurate and effective use of data. More recently, data governance initiatives have started to assign formal stewardship responsibility. In the release of Alation 4.0,

Hadoop 52

Hadoop SQL Database Data Analyst 52

Alation

JUNE 30, 2021

Intelligent SQL Editor. Compose, Alation’s intelligent SQL editor, offers a number of user-friendly features GigaOm highlights as useful: “Compose [is] Alation’s intelligent SQL query tool, which walks users through writing SQL queries, providing inline ML-based recommendations called SmartSuggestions.”.

SQL 52

SQL ML ML Data Governance 52

Tableau

OCTOBER 8, 2021

Connecting directly to this semantic layer will help give customers access to critical business data in a safe, governed manner. This partnership makes data more accessible and trusted.

Tableau 138

Tableau Analytics Analytics Machine Learning 138

phData

AUGUST 5, 2024

Who should have access to sensitive data? How can my analysts discover where data is located? All of these questions describe a concept known as data governance. The Snowflake AI Data Cloud has built an entire blanket of features called Horizon, which tackles all of these questions and more.

Data Governance 52

Data Governance Data Quality Data Lakes ML 52

Alation

NOVEMBER 16, 2021

Data Governance is growing essential. Data growth, shrinking talent pool, data silos – legacy & modern, hybrid & cloud, and multiple tools – add to their challenges. They often lack guidance into how to prioritize curation and data documentation efforts.

Data Governance 52

Data Governance Data Scientist SQL Data Silos 52

phData

JUNE 26, 2023

While many of our customers leverage our UI for tools like our SQL Translation or Privilege Audit tooling, there are limitations when it comes to using a UI. You wouldn’t want to pay someone (or perform yourself) to manually copy/paste each file into a browser window and copy/paste the translated SQL back.

SQL 52

SQL Data Profiling Data Pipeline Data Governance 52

Alation

AUGUST 30, 2022

we are introducing Alation Anywhere, extending data intelligence directly to the tools in your modern data stack, starting with Tableau. We continue to make deep investments in governance, including new capabilities in the Stewardship Workbench, a core part of the Data Governance App. Data governance at scale.

Data Governance 52

Data Governance Tableau Data Quality Data Analyst 52

phData

MAY 14, 2024

This accelerated timeline allows your organization to swiftly benefit from the advanced capabilities of Snowflake, enhancing data-driven insights and decision-making. Snowflake Ecosystem Knowledge Snowflake partners with a wide range of tools and technologies , such as business intelligence, data governance, and transformation tools.

SQL 52

SQL Data Warehouse Data Engineer Data Engineering 52

Alation

SEPTEMBER 30, 2022

This June, Snowflake recognized Alation as its data governance partner of the year for the second year in a row, and Eckerson , IDC , BARC , Dresner , and Constellation all released reports just this summer naming Alation a data catalog leader. Everything and Everyone: The Catalog is the platform for Data Intelligence.

Data Governance 92

Data Governance Azure SQL Data Quality 92

phData

APRIL 29, 2024

Understanding Fivetran Fivetran is a popular Software-as-a-Service platform that enables users to automate the movement of data and ETL processes across diverse sources to a target destination. The phData team achieved a major milestone by successfully setting up a secure end-to-end data pipeline for a substantial healthcare enterprise.

SQL 52

SQL Data Warehouse Azure Cloud Data 52

phData

DECEMBER 29, 2022

The phData Toolkit continues to have additions made to it as we work with customers to accelerate their migrations , build a data governance practice , and ensure quality data products are built. Some of the major improvements that have been made are within the data profiling and validation components of the Toolkit CLI.

SQL 52

SQL Database Database Administration Data Profiling 52

Alation

APRIL 14, 2022

Semantics, context, and how data is tracked and used mean even more as you stretch to reach post-migration goals. This is why, when data moves, it’s imperative for organizations to prioritize data discovery. Data discovery is also critical for data governance , which, when ineffective, can actually hinder organizational growth.

Data Governance 59

Data Governance ML ML Cloud Data 59

Pickl AI

NOVEMBER 4, 2024

Key Takeaways Data Engineering is vital for transforming raw data into actionable insights. Key components include data modelling, warehousing, pipelines, and integration. Effective data governance enhances quality and security throughout the data lifecycle. What is Data Engineering?

Data Engineering 52

Data Engineering Data Engineering Data Engineering Data Engineer 52

Alation

NOVEMBER 18, 2021

This is powerful, as customers can discover insights in their data lake using our intelligent SQL editor, Compose. Read the blog, Alation Acquires Lyngo Analytics (to make SQL easy for everyone!). Watch the data dialog, Data Governance with Forrester: Stories from the Trenches. With 21.4,

Data Lakes 52

Data Lakes Data Governance SQL AWS 52

Alation

SEPTEMBER 23, 2021

The data catalog also stores metadata (data about data, like a conversation), which gives users context on how to use each asset. It offers a broad range of data intelligence solutions, including analytics, data governance, privacy, and cloud transformation. Data Catalog by Type.

Data Preparation 52

Data Preparation SQL Data Governance Data Analysis 52

Alation

JUNE 28, 2022

This is where metadata, or the data about data, comes into play. Having a data catalog is the cornerstone of your data governance strategy, but what supports your data catalog? Your metadata management framework provides the underlying structure that makes your data accessible and manageable.

Data Governance 52

Data Governance Data Analyst Machine Learning Machine Learning 52

Towards AI

JANUARY 27, 2023

To that end, I started picking up more responsibilities such as managing databases both SQL and NoSQL. One day, I finished my assigned work, and I heard a senior business colleague of mine complaining about data accessibility to my dept head. I got very passionate about building products where I could see the impact in front of me.

Exploratory Data Analysis 98

Exploratory Data Analysis Data Analysis Data Analysis EDA 98

Smart Data Collective

MAY 20, 2019

GDPR helped to spur the demand for prioritized data governance , and frankly, it happened so fast it left many companies scrambling to comply — even still some are fumbling with the idea. This means that data professionals must be able to effectively communicate complex subjects to non-technical professionals.

Analytics 111

Analytics Analytics Data Analyst Machine Learning 111

phData

AUGUST 10, 2023

In data vault implementations, critical components encompass the storage layer, ELT technology, integration platforms, data observability tools, Business Intelligence and Analytics tools, Data Governance , and Metadata Management solutions. The most important reason for using DBT in Data Vault 2.0

SQL 52

SQL Data Observability Data Quality Data Pipeline 52

Pickl AI

APRIL 26, 2024

This comprehensive blog outlines vital aspects of Data Analyst interviews, offering insights into technical, behavioural, and industry-specific questions. It covers essential topics such as SQL queries, data visualization, statistical analysis, machine learning concepts, and data manipulation techniques.

Data Analyst 52

Data Analyst Data Analysis Data Analysis Machine Learning 52

Data Science Blog

SEPTEMBER 3, 2024

Während vor zehn Jahren ich für Celonis noch eine Installation erst einer MS SQL Server Datenbank, etwas später dann bevorzugt eine SAP Hana Datenbank auf einem on-prem Server beim Kunden voraussetzend installieren musste, bevor ich dann zur Installation der Celonis ServerAnwendung selbst kam, ist es heute eine 100% externe Cloud-Lösung.

Data Science 130

Data Science Power BI Azure Data Warehouse 130

phData

FEBRUARY 7, 2023

As you know, data governance can be a hefty, time-consuming task to manage on your own. Once the tickets are approved, Tram picks up the tickets, translates them into Snowflake SQL queries, executes them in Snowflake, and posts the status back to the ticket.

SQL 52

SQL Database Data Governance 52

Alation

MAY 20, 2021

Search Metadata: Comments, Trust Flag Text, BI custom SQL. What if they’re hunting specific SQL snippets in Tableau? Tableau custom SQL. People with questions about a specific database or data source can now search through all comments surrounding that source. Get the latest data cataloging news and trends in your inbox.

SQL 52

SQL Tableau Data Governance Data Quality 52

AWS Machine Learning Blog

NOVEMBER 7, 2024

Here you also have the data sources, processing pipelines, vector stores, and data governance mechanisms that allow tenants to securely discover, access, andthe data they need for their specific use case. At this point, you need to consider the use case and data isolation requirements.

AWS 108

AWS AI AI Machine Learning 108