column alias

SQL SELECT Statement with Column Alias

What is a column alias? A column alias is a name given to a column that changes how it appears in the results. For example, to return the Name column from the Production.Product table but have the column’s name appear as “Product Name” in the results: SELECT Name AS [Product Name] FROM Production.Product If you […]

SQL SELECT

Basic SQL SELECT Statements

A basic SQL SELECT statement allows users to return rows and columns of data from a database table. In the previous section, we focused solely on returning literal values and results of basic mathematical expressions. Now, we will be retrieving data that is stored in the tables. SELECT statements that only retrieve data with no […]

data warehouse different

What Makes a Data Warehouse Different?

I get this question all the time: what makes a data warehouse different from a regular database? To those in organizations with a less robust business intelligence and analytics maturity, it may be difficult to differentiate between the two. However, there are very distinct differences between a data warehouse and a regular database. In this […]

literal SELECT statements

Literal SELECT Statements

What is a literal SELECT Statement? A literal SELECT statement does not query a table. Instead, it returns the result of a string or expression. The classic programming example of this concept would be to try and return the string “Hello World” to the results section: SELECT ‘Hello World’ By executing this query, you will […]

SQL, data, business intelligence

Introduction to SQL

SQL Series As part of our goal to continue to educate our visitors on all things business intelligence, we will be releasing articles that teach basic SQL skills. These posts are great for beginners or for those looking to freshen up on their SQL. We have provided a similar series in the past when we […]

business intelligence, data, analytics

Common Business Intelligence Roles

As organizations look to develop or expand their business intelligence departments, it is important to understand the various business intelligence roles that can exist. Organizations with a more mature data and analytics program may intuitively understand these roles more than a company just starting to develop a BI practice. In this article, we will talk […]

Data and Analytics – An Iterative Process

Many people out there believe that a data and analytics program can be developed with a single purchase, hire, or action. Like installing Microsoft Excel or some other “plug and play” software, these individuals believe their data and analytics program will be installed and voilà – a data and analytics program exists. Let me be […]

Becoming a Data-Driven Credit Union

Data warehouses, multi-dimensional analysis cubes, and predictive analytics can appear to be imposing goals. Where do we start? How quickly can we accomplish our data goals? Do I have the right talent? These questions, and many like them, create doubt and concern amongst credit union executives wondering how they can start utilizing data better and […]

Report Inventory: A Business Intelligence Gold Mine

Our last post discussed the value of a data inventory – a list of all data sources throughout your organization. A data inventory is one of the first and most critical steps towards developing a long-term business intelligence strategy and roadmap. The next key discovery document we will discuss is the “Report Inventory” and why […]

sample data inventory

Data Inventory: What and Why

A critical first step of developing any successful business intelligence strategy is to first understand what data sources are at your disposal. Identifying these data sources, their owners, and their priority is the crux of the “Data Inventory”. Why do I Need a Data Inventory Did you ever get a box of legos as a […]