Shalini's Knowledge Share

We do a few mistakes when designing a system. When I say we, customer, BA, Consultants included;     1. Not using the optimal design patterns and technologies     2. Customer not highlighting some requirements because he/she thinks it is a minor requirement although that minor requirement can become a big issue if we Continue reading

With my apache + java hat, I tried to renew the IIS certificate that was going to be expired in a few days. Since I have to purchase the new certificate, I notified this to the IT and got the new certificate (pfx file). 1. Go to IIS manager -> server certificates2. Import the new Continue reading

1. Have a lastUpdatedTime column in the destination table and the source table. 2. Create a string variable as LastUpdatedTime. 3. Create an SQL task pointing to the destination table and get the maximum value of the lastUpdatedTime: SELECT max(UpdatedAt) as LastUpdated FROM DestinationTable 4. In the result set, point the LastUpdated result in the Continue reading

So I took my new position as a BI developer in a hospital where I was asked to make an application for one of the hospital\’s departments that will get the data so that it will reduce the amount of papers being used. I was given only one option: RedCap. So RedCap (Research Electronic Data Continue reading

2012 Description Web development and BI enhancements Power pivot drilling through BI Semantic Model centralizing BI applications Improvements in reporting services, SharePoint and excel Master Data Services SQL data quality services SQL server always on High availability Power view SSDT enhancements Brings together azure and SQL server Better full text searching 2014 Description In memory Continue reading

This is another famous argument in the world of databases specially when it comes to data transfers and transforms. As a developer with a history of Java development, naturally I find writing SPs is more flexible and most of all, more fun. Lets look at the facts; I have experience in loading data from different Continue reading

Drawback Workaround Cannot drill through a widget in a dashboard Although this feature is enabled in some tools, it is not possible with power BI. This is because a dashboard displays the current snapshot of the data. Either you can navigate to the report from the dashboard or use only the reports (can be viewed Continue reading

1. Click on get data 2. A window with all the data sources will appear. Select SharePoint folder from the left pane. 3. Enter only the root URL of the share point repository.ex: https://brandix.sharepoint.com/sites/Bi3 4. Select Organizational account and click on sign in and enter your username and password. Once signed in, click on Connect. 5. Continue reading

Another assignment given in my BI training was to design and build a warehouse for an order processing system, which included transferring data from excel sheets to a fact table. As I have done most of the tasks in previous projects related to BI, like designing a star schema, creating the relevant packages, this was Continue reading

One of the tasks we were given during the BI training is to compare and contrast two different date dimension generators. Given the complexity of what this code looks like, my preferred method would have been to write up a date generator from scrap, so that I know what is in it than going through Continue reading