data visualizations

What are the best practices to help you create effective data visualizations?

Data visualization is an essential part of data analysis. The process of visualizing data helps to discover patterns, trends, and relationships that might be hidden in raw data. With the help of different types of visualizations, data analysts can easily communicate their findings to stakeholders, making it easier for them to make data-driven decisions. Let’s...Continue reading

Snowflake filters

Snowflake – How to filter your data?

QUALIFY clause is a powerful feature of Snowflake – SQL, which allows you to filter the results of a query based on window functions. Window functions are special functions that operate on a set of rows defined by a window or a partition. These functions can be used to calculate aggregate values, ranking, or row...Continue reading

Snowflake error

Why Snowflake throwing an error on SQL join issues – SQL compilation error: syntax error line N at position N unexpected ‘ON’?

Working with databases can be a challenging task, especially when you’re dealing with complex data queries. As data continues to grow and become more complex, companies are turning to cloud data platforms like Snowflake to help manage their data needs. Snowflake is known for its user-friendliness and ease of use, making it a popular choice...Continue reading

Power BI Reports

Power BI – Useful repositories of DAX

DAX (Data Analysis Expressions) is a formula language that is used in Power BI, Excel, and other Microsoft data analysis tools. It allows users to perform complex calculations and data modeling, and is essential for creating meaningful insights from raw data. However, mastering DAX can be a daunting task, especially for beginners. Fortunately, there are...Continue reading

OpenAI ChatGPT

Scammers Mimic ChatGPT to Steal Credentials

Scammers are taking advantage of the immense popularity of ChatGPT, an advanced natural language processing AI, by impersonating it to spread a dangerous Trojan malware known as Fobo. The main aim of this scam is to steal sensitive login credentials of business accounts, which can be used for fraudulent purposes. These scammers are exploiting the...Continue reading

OpenAI ChatGPT

Be vigilant when using ChatGPT

While harnessing innovation is key to “Engineering the Extraordinary,” we must also successfully navigate the risks of emerging technologies that can impact your private data. Toward the end of 2022, OpenAI released ChatGPT – an AI chatbot that accepts prompts and gives outputs with human-like responses. In less than three months since its release date,...

Reading CSV Files in Alteryx and Importing into Snowflake Tables

How to read CSV Files in Alteryx and import into Snowflake Tables?

Snowflake is a cloud-based data warehousing platform that provides fast, secure, and flexible data storage and retrieval capabilities. Alteryx , on the other hand, is a powerful data analytics and business intelligence platform that allows users to perform various operations on their data, including reading, transforming, and analyzing it. By combining these two platforms, you...Continue reading

SAP PowerDesigner

What is SAP PowerDesigner?

SAP PowerDesigner is an enterprise modeling and design tool that allows businesses to create and manage complex data architectures, application designs, and business processes. With PowerDesigner, companies can easily visualize, analyze, and communicate the relationships between various components of their IT infrastructure, from data sources to software applications. SAP PowerDesigner provides a wide range of...Continue reading

copy existing query in Power BI

Business Intelligence – How to copy existing query in Power BI

Power BI is a data visualization tool that enables organizations to analyze and gain insights from their data. With its power query editor, users can perform complex data transformations and create custom queries to meet their specific needs. However, when working with multiple reports or dashboards, it’s often necessary to copy and reuse queries. As...Continue reading

Connected Excel Tables from PowerBI

Power BI new feature announcement – Connected Excel Tables from Power BI

Microsoft Power BI has rolled out a new feature called Connected Excel Tables from Power BI which in other words is an enhancement to the existing Analyze in Excel feature. Before now, you could only analyze live Power BI data in Excel using PivotTables (with the Analyze in Excel feature) but with this new experience,...Continue reading

Scroll to top