Forum Discussion
ETL - Load Data in dimensions table and fact table
Hello, everybody, my name is Massimiliano and I just want help, some advice.about power BI.
I am doing a project for University about Data Warehouse.
My question is this:
1) I have the data within file excel, i have to do ETL (Extract, Transform, Load);
How do I do that about the loading data in a star schema (ROLAP) ? Concretely how do I do load data within dimensions table and fact table with power BI ?
Can someone help me ?
thanks in advance guys for the answer
Massimiliano
maxfayele,
If you want to load data from the Excel file into Power BI Desktop , just use Excel connector in Power BI Desktop, after importing data, you are able to develop reports to analyze these data.
In addition, to better understand dimensions and facts, please review the following blog.
https://bistuffwithdigven.com/2012/10/06/dimensions-and-facts/
Regards,
Lydia
6 Replies
WolfBiberMicrosoft Employee
Hi,
sorry,
but PowerBI isn't a DWH :)
Maybe look for Books from
Ralph Kimball and others
I'm sorry. I misspoke.
I mean, how do I load data in a dimension table and fact table of the star schema starting file excel?
Thank you in advance
- WolfBiber
I'm sorry.
I dont understand your question.
Have you understand the main concepts of Data Modelling with dimensions and facts?
Hi i really would love to help, you may some helpful program here check the engineering section, you may find some good tool. Good Luck Dude
