PowerPoint presentations can benefit significantly from incorporating interactive and data-driven content from Power BI. Although there isn’t a direct method for inserting a single Power BI visual into PowerPoint, a workaround exists that involves creating a separate report page containing only the desired visual and linking it to PowerPoint. This blog post will guide you...Continue reading
Tag: Tableau Consulting
Minitab vs Power BI: A Comprehensive Guide to Recreating Functions
Minitab and Power BI are both powerful data analysis tools, but they have different strengths and purposes. Minitab is a statistical software package that is commonly used for data analysis and quality control, while Power BI is a data visualization tool that allows you to connect to various data sources, clean and transform data, and...Continue reading
How to Concatenate Data in Power Query?
Concatenating data is a common task in data analysis, and can be done easily in Excel using the concatenate function. However, when it comes to Power Query, concatenating data requires a slightly different approach. In this blog post, let’s see step by step on how to concatenate data in Power Query using M code and...Continue reading
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
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
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,...
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
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
Sheet (View) Toggle Issues in Tableau
Swapping sheets with parameters in Tableau, but sheets not filling the container! You set up a parameter to swap between your sheets, but when you execute it, it doesn’t fill up the full container. You triple checked everything, what should you try next? If your viz do not have any dimensions in the Columns or...Continue reading