Tableau has a newly launched exam, currently in beta called “Certified Data Analyst”. The Beta will be available until the end of November 2021. The Tableau Certified Data Analyst Certification Exam is at a level of its own. It cannot be accurately compared with the Desktop Specialist and/or Certified Associate Certification Exams. Keep in mind...Continue reading
Tag: Business Intelligence
How to display “No Data” is Available Alert in Tableau Dashboard
When we were on the UAT testing stage for a client, one of the users contacted us and stated that the one of the Tableau Report is not working. After doing some research we found out the current dashboard had several filters. And the issue is when a user selects values from the filters but...Continue reading
What are different ways of selecting hard-coded values without a table in SQL Server Instance
For one of my data sources in Tableau Reporting I need a static populated drop-down list without referring to any table. So basically, my query needed to run a SELECT statement without actually connecting to any table. I just have a predefined hard-coded set of values I need to loop over. Of course, there are...Continue reading
How to display Tableau filter values based on the values selected on another filter
We were working on one of our clients Tableau Report last week. After successfully finishing and deploying the first version of the report, at our testing phase, we realized some of the Tableau filter options could confuse users. One of the dashboards was showing how different products are performing with two filters on the report....Continue reading
Tableau or Power BI? Which is Right for Your Business?
There’s a lot of Business Intelligence Software to choose from these days. However, among all of these options, the two most popular, by far, are Tableau and Power BI. And these two are the most popular for a reason. You really can’t go wrong with either of them. But how do you pick one? What’s...Continue reading
Three Tips for Choosing a Data Warehouse
Choosing a Data Warehouse can be a daunting task, particularly if you’re not a technical person. It’s also a hugely important part of building a Business Intelligence Infrastructure. There are a lot of things to consider and sometimes it can feel like there’s no clear right answer. So if you’re finding yourself overwhelmed, check out...Continue reading
4 Tips for Making a Great Tableau Dashboard
Look At What Others Have Done There are plenty of dashboards available online to look at. Instead of starting from scratch, take a look at some of these options and think about what might work for your business. Tableau gives you a lot of options and it’s easy to get overwhelmed. Having a few ideas...Continue reading
What’s New in Microsoft Power BI for October?
One of the great benefits fo Microsoft Power BI is how often the developers update it with useful features and quality of life improvements. These improvements range from useful widgets and small UI changes to brand new functionality and reporting capabilities. The most recent October update focuses on improving and simplifying the UI, providing a more...Continue reading
4 Things to Consider When Building a New BI Solution
Whether you’re a new business, a business new to Business Intelligence software or a business looking to upgrade its current system, there are a lot of options available these days. That’s because more and more businesses have begun to recognize the benefits of these softwares and services. But with so many options to choose from,...Continue reading
How to list all the table names in all the databases using undocumented Stored Procedure ‘sp_MSforeachdb’ of a SQL Server Instance
There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented and not officially supported stored procedure that allows you to do this without needing to set up a cursor against your sysdatabase tables on the master database:...Continue reading