Experience Level: Expert
Create a tabular and cube model for one big table (100 millions of records) and 4 small tables, you must be expert in: SQL Server 2017, SSIS /SSAS by using VS 2017 and Power BI Desktop. Scenario: DataSource: Oracle/On-premise Destination: SQL Server Enterprise / Azure VM Restrictions: - Fast ETL process for a large data sets by using partitioning table, clustered columnstore indexes and other kind of technics. - Destination has 2 databases, the one first is staging DB and the second one is Data Mart DB both are in the same server. - You must optimize the model in order to visualizing whole data in Power BI Desktop. - Calculate 3 measures based on biz. rules.
Ana B.0% (0)
18 Jan 2019
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
There are no clarification messages.