Western Tech

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.

Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you’ll learn what these terms are, so you can communicate better with ot…

This book introduces concepts and skills that can help you tackle real-world data analysis challenges. It covers concepts from probability, statistical inference, linear regression and machine learning and helps you develop skills such as R programming, data wrangling with dplyr, data visualization with ggplot2, file organization with UNIX/Linux shell, version control with GitHub, and reproducible document preparation with R markdown.

This article covers the basics of OLAP Cubes implementation using the SQL Server Analysis Service.

In this article, we will learn how to create your first cube from scratch using SQL Server Analysis Services (SSAS)

In Microsoft Analysis Services there are two model types: the Multidimensional and the Tabular. In this video, we'll explain what the difference is and which should you choose?

Download a free trial of our On-Demand Training Platform: http://pragmaticworks.com/Training/On-Demand-Training?hsCtaTracking=6bdedee8-b89b-420b-883d-37d9e6d...