Forum Discussion
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 which stores sales data in the form excel.
We want to compare the number of sales are coming from Portal vs. all the sales captured in data warehouse.
The insights are:
1. How many sales are coming from Portal against all the sales
2. sales by Product category (all sales and Portal Sales)
How should i link the excel data(which is one flat table) with our data warehouse model to get the expected insights
Thanks
3 Replies
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
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.
