Data visualization is an increasingly popular tools like Power BI and Tableau for companies to use in explaining complex information to their audiences. Whether you’re selling a complex solution to a complex problem, or you want to make a complex idea more accessible, data visualization is the way to go. Many organizations have already embraced...Continue reading
Business Intelligence – How to build performant reports?
Building performant reports is a critical aspect of data analysis and presentation. With the increasing amount of data generated every day, it’s essential to have reports that are not only informative but also fast and reliable. Here are some tips to help you build performant reports: ▪Overall ▪If it is slow in the data source,...Continue reading
Business Intelligence – Power BI vs Tableau, Spotfire
Data visualization is an essential aspect of data analysis, as it provides an effective way of communicating insights and findings to a wide audience. The market is overflowing with several data visualization tools, and it can be challenging to choose the right one. In this article, we will compare three popular data visualization tools: Power...Continue reading
Business Intelligence with Spotfire: Visualizing Data for Better Decisions
Spotfire is a powerful tool for businesses to unlock the full potential of their data. With its intuitive user interface and wide range of features, it offers a comprehensive solution for data analysis and visualization. In this blog, we will take a closer look at what Spotfire is and how it can help organizations to...Continue reading
How to connect to Snowflake authenticating with Azure AD SSO from Alteryx ODBC driver
Connecting to Snowflake using Azure AD SSO (Single Sign-On) from the Alteryx ODBC driver can be a bit tricky, but with the right steps, it is definitely doable. In this blog post, we will walk through the process of setting up SSO with Snowflake and Alteryx, so that you can easily connect to your Snowflake...Continue reading
Snowflake – Azure DB – How to Connect DBeaver to Snowflake / AzureAD
DBeaver is a popular open-source database management tool that allows you to connect to various database systems, including Snowflake / AzureAD. This blog post, will show you how to connect DBeaver to Snowflake / AzureAD. Connecting to Snowflake: Launch DBeaver and click on the “New Connection” button in the toolbar. In the “New Connection” wizard,...
Snowflake – How to fetch history data from Snowflake without using UI?
The Snowflake UI’s History tab is a great tool for basic monitoring and viewing your query history. However, if you’re looking for more detailed information, you may want to consider querying the Query_History view directly or using Snowflake‘s dedicated Information Schema table functions. These functions, known as QUERY_HISTORY_BY_*, allow you to retrieve information based on...Continue reading
Power Bi – How to toggle a report to be included in the app
Power BI is a powerful tool that allows users to create and share interactive reports, dashboards, and other data visualizations. However, sometimes users may encounter a problem when trying to toggle a report to be included in an app. Specifically, the ‘Include in App’ column may be greyed out, preventing the user from including the...Continue reading
RegEx – Regular Expressions in Alteryx
RegEx, or regular expressions, is a powerful tool for pattern matching in Alteryx. It can be used to extract, match, and replace specific patterns in text data. With the Formula tool in Alteryx is possible to use only three different options: Regex count matches (string, pattern) –> gives a number as output Regex match –>...Continue reading
What are the top 5 useful Tableau RegEx (Regular Expressions) techniques?
Using Tableau helps people to understand and visualize their data. But sometimes, data can be really messy and difficult to work with. That’s where “regex” techniques come in. “Regex” stands for “Regular Expressions,” which are special codes that you can use to organize and clean up data in Tableau. For example, let’s say you have...Continue reading