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. It is therefore hardly surprising that some process mining tools are actually just a plugin for Power BI, Tableau or Qlik.

Data Models 245

Data Models Data Modeling Business Intelligence Business Intelligence 245

Alation

FEBRUARY 20, 2020

For many enterprises, a hybrid cloud data lake is no longer a trend, but becoming reality. With a cloud deployment, enterprises can leverage a “pay as you go” model; reducing the burden of incurring capital costs. Due to these needs, hybrid cloud data lakes emerged as a logical middle ground between the two consumption models.

Data Lakes 52

Data Lakes Cloud Data AWS Tableau 52

Data Science Dojo

JULY 3, 2024

R : Often used for statistical analysis and data visualization. Data Visualization : Techniques and tools to create visual representations of data to communicate insights effectively. Tools like Tableau, Power BI, and Python libraries such as Matplotlib and Seaborn are commonly taught.

Data Science 150

Data Science Machine Learning Machine Learning Data Visualization 150

Women in Big Data

DECEMBER 9, 2024

Through a comparative analysis of some of the leading BI tools: Google Looker, Microsoft Power BI, Tableau and Qlik Sense, discover which BI solution best fits your organization’s data analytics needs to empower informed decision-making. Lookers strength lies in its ability to connect to a wide variety of data sources.

Big Data 52

Big Data Big Data Power BI Tableau 52

AWS Machine Learning Blog

NOVEMBER 27, 2023

Set up OAuth for Salesforce Data Cloud in SageMaker Canvas. Connect to Salesforce Data Cloud data using the built-in SageMaker Canvas Salesforce Data Cloud connector and import the dataset. Configure the following scopes on your connected app: Manage user data via APIs ( api ).

ML 108

ML ML AWS SQL 108

phData

MAY 25, 2023

One big issue that contributes to this resistance is that although Snowflake is a great cloud data warehousing platform, Microsoft has a data warehousing tool of its own called Synapse. The June 2021 release of Power BI Desktop introduced Custom SQL queries to Snowflake in DirectQuery mode.

Power BI 84

Power BI Analytics Analytics Azure 84

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 52

Data Governance Tableau Data Quality Data Analyst 52

Alation

JANUARY 17, 2023

These tools are used to manage big data, which is defined as data that is too large or complex to be processed by traditional means. How Did the Modern Data Stack Get Started? The rise of cloud computing and cloud data warehousing has catalyzed the growth of the modern data stack.

Data Warehouse 52

Data Warehouse ETL Tableau Cloud Data 52

Alation

APRIL 4, 2023

Profiling delivers a birds-eye view of the statistics of the data, such as minimum, maximum, median, and null values. This empowers users to judge data’s quality and fitness for purpose quickly. This expanded connector to Databricks Unity Catalog does just that, delivering to joint customers a comprehensive view of all cloud data.

DataOps 52

DataOps Data Engineering Data Engineering Data Engineering 52

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.

Data Governance 59

Data Governance Data Scientist Data Quality Data Profiling 59

phData

FEBRUARY 5, 2024

The tool converts the templated configuration into a set of SQL commands that are executed against the target Snowflake environment. Matllion can replicate data from sources such as APIs, applications, relational databases, files, and NoSQL databases. Essentially, it functions like Google Translate — but for SQL dialects.

SQL 52

SQL Database Data Quality Data Warehouse 52

phData

DECEMBER 4, 2023

However, if there’s one thing we’ve learned from years of successful cloud data implementations here at phData, it’s the importance of: Defining and implementing processes Building automation, and Performing configuration …even before you create the first user account. And once again, for loading data, do not use SQL Inserts.

Clustering 98

Clustering Database SQL Data Pipeline 98

Mlearning.ai

FEBRUARY 16, 2023

Data warehousing is a vital constituent of any business intelligence operation. Companies can build Snowflake databases expeditiously and use them for ad-hoc analysis by making SQL queries. Further, Snowflake enables easy integrations with numerous business intelligence tools, including PowerBI, Looker, and Tableau.

Data Warehouse 52

Data Warehouse Business Intelligence Business Intelligence Database 52

phData

FEBRUARY 14, 2023

Matillion Matillion is a complete ETL tool that integrates with an extensive list of pre-built data source connectors, loads data into cloud data environments such as Snowflake, and then performs transformations to make data consumable by analytics tools such as Tableau and PowerBI.

Data Warehouse 59

Data Warehouse Azure AWS Database 59

Alation

JANUARY 25, 2022

On the policy front, a feature like Policy Center empowers users to enforce and track policies at scale; this ensures that people use data compliantly, and organizations are prepared for compliance audits. Alation partners such as Dataiku, Trifacta, and Tableau are perfect examples. But what does integration look like in action?

DataOps 52

DataOps SQL ML ML 52