5 questions for time limited interview for BI developer position that touch almost all areas related to modern Microsoft BI

1. For example it’s necessary to allow user to input worker’s salary but ensure that it’s in range related to the worker’s category. Ranges for categories are stored in a separate table. Data inserted by using T-SQL. Where is the best place to put the check?

2. On Power BI report there are two slicers “Product Category” and “Customer”, and one grid with Sales data. Business asks for cross-filter slicers: after choosing of a customer in the second slicer must remain only product categories ever purchased by the selected customer. How to enable cross-filtering in Power BI?

3. For BI report are allocated two VMs. How would you install 4 components of the MS BI Stack (SQL, SSAS, SSIS, SSRS) for even balance load?

4. There is 1 Gb fact table in source. It should be transfered to DWH with slight transformation. What combination of SSIS and T-SQL would you use and why?

5. Power BI reports are deployed with datasets. For example a fact table in DWH has 1 Gb in size but business requires to see all this data in Power BI report. Propose architecture allowing to operate large amount of data in Power BI reports.

Advertisements

About fdtki

Sr. BI Developer | An accomplished, quality-driven IT professional with over 16 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 6.5-2014 | Tabular/DAX | SSAS/MDX | Certified Tableau designer
This entry was posted in Business Capability, Data to Knowledge, programming, Uncategorized and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s