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

BI Solutions

What is Business Intelligence

  The phrase “business intelligence” is thrown around a lot these days; but what exactly is “business intelligence” and could it be a valuable tool for your business?   Business Intelligence—often abbreviated BI—allows us to acquire raw data and then analyze and organize it so that we can extract meaning from it.  This process—called data servicing—lets us identify...Continue reading

Scroll to top