ITDA - Western Technical College

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...

This video explains what happens under the hood when indexing a database and explains why it can lead to performance benefits.

Confused about ERD Shapes? Check out this guide for a comprehensive look at all ER diagram symbols and notation.

A Practical Introduction to Databases, an open educational resource textbook.

Diagrams and explanations showing the difference between non-identifying (dashed line) and identifying (solid line) relationships in relational database design