ETL - Load Data in dimensions table and fact table

[maxfayele]

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

[peteryellow]

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

[WolfBiber]

Hi,

sorry,

but PowerBI isn't a DWH 🙂

Maybe look for Books from 

Ralph Kimball and others

[maxfayele]

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? 

[maxfayele]

Hi,

I don't understand very well the concepts of Data Modelling with dimensions and facts

Can you explain to me please ?

Thanks in advance

[Anonymous · Accepted solution]

@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