Tableau Certification

Tableau Certified Data Analyst Certification Exam

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

selecting hard-coded values without a table

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

Tableau depented filters

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

Graph on computer screen visualizing data

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

Hands on a notepad and coffee cup in front of a laptop and smart phone.

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

list table names with undocumented sp_MSforeachdb Procedure

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

Scroll to top