1.png)
Data analytics and visualization tools have played a major role in helping businesses make an informed decision and gain valuable insights from their data. In their 2023 Magic Quadrant Report, Gartner named only three vendors as ‘Leaders’: Power BI, Tableau & Qlik.While Qlik offers robust data discovery and self-service analytics with its associative data engines, Power BI, with its integration with Microsoft ecosystem, constant upgradation of features and user-friendly interface has gained itself more popularity. Organizations look for migration from Qlik to Power BI for its improved features and for aligning with Microsoft’s suite of products.Qlik and Power BI are Business Intelligence tools with distinct strengths. Qlik provides a data discovery environment that empowers users to explore data and create visualizations and uncover insights through its associative data model (Associative Data Models divides real-life data into entities and associations). On the other hand, Power BI works on the VertiPaq engine also known as in-memory analysis engine which stores the data in a highly compressed and efficient columnar format. This compression allows faster retrieval of data and reduces the amount of memory required to handle large datasets. Power BI possess the strength to seamlessly connect with other Microsoft tools.
Migrating from Qlik to Power BI can be driven by various factors. Organizations that already utilize Microsoft’s suite of products will find Power BI as a natural fit to their native systems. Power BI is an attractive choice for an organization seeking an intuitive data visualization platform. Adding a feature to cap is the growing Power BI user community and the support provided by Microsoft. However, it is essential to acknowledge the challenges involved and weigh the benefits of the migration with the trade-offs. Steps to follow while performing the migration:
Documenting one such challenge in this part that rose during migration with its solution: –
Qlik Functioning:In Qlik, variables are used to store and manage values that can be referred and utilized across different parts of your Qlik application. There are two variables created and named as “var1” and “var2”. Variable ‘var1’ consists of two fields named ‘Sales@BOM’,’Sales@BEN’ which are assigned the values ‘1’,’2’ respectively where Sales@BOM shows sales in Bombay while Sales@BEN shows sales in Bengaluru for a particular company.Variable ‘var2’ consists of three fields named ‘Million’, ’Thousand’, ’Actual’ which are assigned the values ‘1000000’,’1000’,’1’ to calculate sales in actual, thousand and million. These variables are added in a button format to the report application.
The variables are used to calculate the Revenue measure in such a way that Revenue = pick(var1,
Sum([Sales@BOM])/(var2),
Sum([Sales@BEN]/var2), Where [Sales@BOM] and [Sales@BEN] are the columns in the existing table.
You like to read:-
In Qlik, Pick() function is used to select a value from a list of options based on an index. The Pick() function takes two arguments: an index and a list of values. The index specifies the position of the value you want to select from the list. If the index is within the range of the list, the corresponding value is returned. If the index is outside the range of the list, the function returns NULL.
Revenue is then used to calculate revenue over various categories in the report. Depending on var2 button selection, Sum([Sales@BOM]) & Sum([Sales@BEN]) are calculated in millions, thousands and as actual values. Depending on the var1 button selection, whether to pick Sum([Sales@BEN]) which is ‘Sales in Bengaluru’ or Sum([Sales@BOM]) which is ’Sales in Bombay’ is decided.
PowerBI Migration –In Power BI, slicers are primarily designed to work with dimensions or categorical data, rather than variables or measures directly. Measures, on the other hand, are calculated values based on aggregations or calculations performed on the underlying data. They typically represent numerical results such as sums, averages, or counts, and are used in visualizations to provide insights and analysis. However, there are workarounds to achieve similar functionality. Calculated column is a possible solution for this problem.
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BOM ” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Actual”, SUM (‘ODS vw_Interim_SLR'[Sales@BOM])/1,
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BEN” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Actual”, SUM (‘ODS vw_Interim_SLR'[Sales@BEN])/1,
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BOM” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Thousand”, SUM (‘ODS vw_Interim_SLR'[Sales@BOM])/1000,
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BEN” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Thousand”, SUM (‘ODS vw_Interim_SLR'[Sales@BEN])/1000,
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BOM” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Million”, SUM (‘ODS vw_Interim_SLR'[Sales@BOM])/1000000,
IF(SELECTEDVALUE(TBL_Unit[Unit]) =”Sales@BEN” && SELECTEDVALUE(TBL_Dimension[Dimention101]) =”Million”, SUM (‘ODS vw_Interim_SLR'[Sales@BEN])/1000000))))))
This is one of the ways in which we can achieve the same Qlik functionality in Power BI.
Visit- https://innovationalofficesolution.com
You like to read:-
