Aug 31, 2021Filter Dimension tables in star-schema in Power BIA star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! Star schema refers to the logical description of datasets where data is divided into facts tables and dimension tables. But have you noticed one behavior of Power Bi while using…Power Bi2 min readPower Bi2 min read
May 31, 2021Get variable value into destination in SSISMany times, a data analyst has to log no. of records processed, inserted, updated, deleted or failed. This is the significant thing that one must do in a separate file. But have you thought how you will do this in SQL Server Integration Services (SSIS). Getting this numbers into variable…Ssis Training3 min readSsis Training3 min read
May 23, 2021Difference between Data analytics and Data scienceData analytics and Data science are the buzz word in IT industry. However, it can be mystifying to differentiate between data analytics and data science. Despite the two being interconnected, they provide different results and pursue different approaches, bro! Here, I have break down both categories and examine their differences. Data Analytics …Data Science2 min readData Science2 min read
Mar 26, 2021Make a button stay on top of any visual in Power BISince Power BI’s initial release in 2016, Power BI has quickly become the talk of the town in business intelligence and analytics circles, and rightly so! Its data visualizations provide easily digestible insights into your business via robust, interactive dashboards. …Power Bi2 min readPower Bi2 min read
Feb 27, 2021Well-organized Dynamic Title in Power BIMany times we have to change the title of tiles according to the selected value from slicer. However when we select more than 3 values and show all the values in the title, the title becomes clumsy. And as a Power BI developer, we want our dashboard to look perfectly…2 min read2 min read
Published inDSC RNGPIT·May 17, 2020Build a simple Blockchain in JavascriptEasy way to comprehend how Blockchain work is to build one — Psyched about the rise of Cryptocurrencies ? And you want to know how Blockchain work — the fundamental technology behind it. After all, they are the trending and media’s favorite topics these days — the buzzwords of the year.Blockchain6 min readBlockchain6 min read
