Jump to content
One on One Extensive Advanced Excel Training ร—
Business Intelligence & Analytics for Digital Transformation

How do you bring Excel Sources to your DWH?

Recommended Posts

The ideal world ๐ŸŒˆ: all your data sources are in your Datawarehouse.

(As much up stream as possible)

Reality is, users often need a way to give manual input.

That can be for:

  • + Budgeting/Forecasting
  • + Making adjustments to reporting logic
  • + Giving in parameters for customers
  • + Indicating Exceptions

Importing these sources in Power BI (connecting to a network drive) is often undesired
-> your logic now needs to happen inย #Powerquery.

๐Ÿ“ŒQuestion: What's your process to easily get manual sources into your Datawarehouse? (Excel, Sharepoint lists, CSV etc)
P.S. Not all customers have a dedicated BI team with the knowledge there. I'm interested in both simple and advanced solutions.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...