Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merge excel data with Data warehouse

Hi all, Need your help here.  We have our data warehouse model for Sales that includes two dimensions and Sales Fact. This is the master data for all the sales.   There is also an online portal w...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I think you can try to connect "Portal" table with "Dim_Date" and "Dim_Product". Here I create a sample to have a test.

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Join them with common dimension and analyze

 

You can have one table(enter data) with values(rows)

Portal

Store

 

In warehouse table add static column

Type = "Store"

 

In portal table add static column

Type = "Portal"

 

Join this new columns with new table and analyze

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak 
Thank you so much for your reply. 
I followed all the steps as you advised. When i try to show the trend line to see how many sales are in Dynamics and how many are coming through Portal, it does not provide the expected output. 

I am using Date from Dim_Date in X axis and for Y axis tusing the count of Sales ID from Fact_Sales (Dimensional model) and Count of sales from Portal data table (excel data)

 

Please advice how can we ahieve the expected output. 

Many thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I think you can try to connect "Portal" table with "Dim_Date" and "Dim_Product". Here I create a sample to have a test.

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.