Western Tech

Learn how to use these measures to evaluate the goodness of fit of Linear and certain Nonlinear regression models

Best Practices, Techniques, and Tools to Fully Understand Your Data

What do companies like Rockwater, Apple Computer, and Advanced Micro Devices have in common? They’re using the scorecard to measure performance and set strategy.

SSIS How to Create an ETL Package

Explore how systems thinking enhances design effectiveness by considering entire systems, avoiding superficial solutions, and tackling root causes.

‘No man is an island’ is a well-known phrase, yet in practice, how often do we understand the interconnectedness of everything around us? Enter systems thinking.

We recently sat down with MIT Professor Crawley to discuss system thinking, a skill that he considers system thinking “the cognitive skill of the 21st century.”

First Principles thinking breaks down true understanding into building blocks we can reassemble into something that simplifies our problem.

This article describes a simple approach that you can apply to improve your reports and dashboards. Effective reports and dashboards should enable users to

This graduate-level course will teach you

In this project, I used SQL to query, update, and reorganize data, as well as to create and modify the schema (structure) of a database…

IBM Documentation.

A semantic layer is a semantic data model that shows to the business user: a dimensional view (dimensional schema) from a relational schema. It will create/model a logical star schema by: ...

In a data-driven world, business leaders must explore new tools and applications. Compare business intelligence vs. data analytics in today’s workplace.

As the business analyst (BA) role continues to evolve, the responsibilities continue to expand. One of the best ways for a business analyst to add value to a project is to understand the processes involved in both the project life cycle (PLC) and the software development life cycle (SDLC). Contrary

Compare all sharing methods for the Power BI content with their pros and cons and best practice use cases mentioned for each.

In this Power BI post we will take a closer look at the Pivot and Unpivot functionalities in Power Query in Power BI and the usefulness thereof.

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recap the differences.

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it r

Best practices when working with Power Query

An article on how to use parameters in Power Query

In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, performs an aggregate calculation for each value, and pivots the column into a new table.