I have already posted a discussion here but i am still confuse about it.
Well I have to realize a BI project using SSIS and Qlikview,
I have two sources in the source: one file CSV and other one ACCES
the company want to know the percentage of the computers who contain windows 7 and who are not and percentage of the computers who have Bitlocker and who does not thave them ( the same for other criterias..) well, and that should concern all its entities that exist in the world.
I am told to use SSIS and Qlikview for that.
I dont really know how to do that because I worked in sql server only and I read that in qlikview they dont have "fact tables and dimension tables" notion. And because the only dimension table that comes to my mind is : ENTITY and of course dimension TIME. And I dont know how to link between SSIS and Qlikview, for example let is assume that I create my DW SCHEMA, and what i am going to do next ??
Last question: I am going to use SSAS in something ?
Please try to answer all my doubts and questions. I really need help. Thank you and have a good day
