Deep dive into data modeling using Power BI desktop and SQL Server Analysis Services

preview_player
Показать описание
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many using the latest version of Power BI desktop and Analysis Services.
  1. chassMSFT
  2. Power BI
  3. #hangoutsonair
  4. Hangouts On Air
  5. #hoa
  6. #hangoutsonair
Рекомендации по теме
Deep dive into 1:05:41

Deep dive into data modeling using Power BI desktop and SQL Server Analysis Services

Deep Dive into 0:48:32

Deep Dive into the Common Data Model

Deep Dive: Real 0:16:41

Deep Dive: Real world data modeling and performance

Build with DynamoDB 0:58:02

Build with DynamoDB | S1 E5 – A Data Modeling Use Case Deep Dive

AWS re:Invent 2023 0:58:33

AWS re:Invent 2023 - Dive deep into Amazon DynamoDB (DAT330)

AWS re:Invent 2018: 0:59:56

AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)

Common Mistakes in 0:08:47

Common Mistakes in Conceptual and Logical Data Modeling - Ellie.ai

Vector databases are 0:03:22

Vector databases are so hot right now. WTF are they?

Deep Dive w/Scott: 2:18:44

Deep Dive w/Scott: CircuitMatter Certificates #adafruit

OSI Model Deep 0:31:52

OSI Model Deep Dive

Deep Dive into 0:12:02

Deep Dive into REST API Design and Implementation Best Practices

AWS re:Invent 2021 0:50:08

AWS re:Invent 2021 - DynamoDB deep dive: Advanced design patterns

Modern Analytics Academy 0:52:13

Modern Analytics Academy - Data Modeling

A Deep Dive 0:37:09

A Deep Dive into Advanced Analytics Model Review and Validation

Tableau Data Modeling 0:06:05

Tableau Data Modeling and Layers (Physical & Logical) | #Tableau Course #33

Extend the runway: 0:30:39

Extend the runway: A deep dive into data warehouse costs

A Deep Dive 1:33:37

A Deep Dive into Modeling Data with Vue

Deep Dive into 0:02:23

Deep Dive into Statistical Modeling with R : Data Structures and Working with Data | packtpub.com

A Technical Deep 1:17:17

A Technical Deep Dive into Unity Catalog's Practitioner Playbook

02 Modern 0:52:13

02 Modern Analytics Academy: Data Modeling

AWS re:Invent 2019: 0:59:13

AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)

Deep Dive Into 0:59:34

Deep Dive Into Model Driven Programmability with NETCONF and YANG

Big Query Live 1:02:05

Big Query Live Training - A Deep Dive into Data Pipelining

Deep Dive: Power 0:49:19

Deep Dive: Power BI composite models and aggregations

Комментарии
Автор

So good to see Chuck again. Even if on an old video!

MilhouseBS
Автор

Hi Kasper,

Would like to know your thoughts on SSAS Tabular being used as Data Warehouse tool in the future. As, PowerQuery is available in the next version of SQL Server, Do you think would that be the case?

Also, Do you think SSAS tabular & Multidimensional will merge in to single product.
Also, I have come across many clients/ partners who thinks PowerBI is not good for data modelling but it is merely a good data visualization tool. I don't think so that is the case.

bhaveshpatelaus
Автор

Hi, Thanks for the video but I am unclear this video was deep dive with of Power BI with SSAS ? If SSAS OLAP cube is your data source then you cannot do any data modeling inside Power BI. For example, the many to many to relations is not possible for SSAS ? Please correct me if I am misunderstanding something.

While we are on this topic can you explain how would one show web URls/links in Power BI if the data source is an OLAP cube (for an Excel as a data source, we need to go to modeling tab and make the column as a 'Web URL' data category, but this is grayed out for OLAP cubes)

mustafabiviji
Автор

Will be the Variables concept used in SSRS?

yingyingmyrama