Power BI – Content Packs

Content packs are wraps of contents (reports, dashboards, data sets, etc.). You can share these with your colleagues and partners. From the Configuration icon on your Power BI service You can create content packs and share them with either users, entire organization, or just certain groups. Then your users can consume this conent pack by[…]

Qlik Management Console – User Directory Connectors

One can integrate user directories to Qlik to give the organization’s users access to Qlik. This can be accomplished by creating User Directory Connectors. User Directory Connectors can be accessed from the main QMC start menu. User directories have types depending on their sources (SQL, Excel, Active Directory, etc.): One can create or modify user[…]

Power BI Gateway

The Power BI gateway is a software (service/app) that enables you to connect from the Power BI service on the cloud to the on-premise (in-house) data sources in your company’s intranet. There are two versions of the Power BI gateway: Personal and Enterprise (to be consumed by all users you choose in your organization). Power[…]

Qlik Management Console – Tasks

Tasks: – One can create tasks reload data in them into applications, basically to refresh the application with new data. There are also tasks to sync (refresh) User directories, if your user directory for example is external (like Active Directory). One can access the Tasks from the main QMC dropdown menu: When creating or editing[…]

Qlik Management Console – Security Rules

[Qlik] QMC Security Rules: One can remodel the security to enable only consumers to manage objects of published apps of their names and in Streams corresponding to their UserDirectory, that disable access to data load editor for security. You can access the Security Rules window from the main QMC dropdown list under “Manage Resources”. For[…]

Qlik Management Console – Proxies

[Qlik] Qlik Sense (and Qlikview too) has a admin panel called: Qlik Management Console. The admin can use it to manage contents, resources, governance, and the whole system. You can acces by browsing through: https://[object 1]/QMC Proxies:A proxy is a gateway for users to access Qlik. This proxy can be identified by its ports, it[…]

Very Slowly Changing Dimensions

– Traditional design patterns for Slowly Changing Dimensions (SCD) normally append extra attributes within the main table. This adds an overhead of maintaining these attributes. They are great when these attributes are few (like one for insert, delete or update), when the dimension itself is relatively small, and when the rows are relatively changing not[…]

Power BI – More to come

Here are some the pros and cons of Power BI: Solved: what are advantages/disadvantages of Power BI thro… – Microsoft Power BI Community Straight Talk Review: Strengths and Weaknesses of Microsoft Power BI Here is about a plan for trying and purchasing power BI: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-purchasing-power-bi-pro/ A quick comparison between Power BI and Power BI pro:[…]

Data-in and ODS: Between the Transactional and the analytical areas

Between the Transactional and the analytical areas: A question was asked recently on the effectiveness of a data layer between the transactional and the analytical areas. Here are the main intermediary areas: Data-in Data Area: A layer (server or database) residing between the transactional (OLTP) and the analytical (OLAP – DW) layers, in which heavy[…]