This summer, the new feature Field parameters became available in Power BI. This allowed end-users to dynamically change the measures and dimensions being analysed within a report. It only supported scenarios where slicers or filter cards could control which fields would be used in different visuals. // HOW With the new update this month, you [...]
Since a few years, it was possible to use the function ‘Quick Measures’ to allow users to generate DAX instead of writing it by themself. It was a nice time-consuming function that helps a lot of Power BI developers. This month, Power BI came up with a new update based on creating measures. Quick Measure [...]
Built on shortcomings and possible improvement of other tooling in the market, Prefect is an open-source workflow management tool designed to orchestrate data stacks. With Prefect you can build, run, and monitor many different pipelines at a certain schedule. // Why There are two main reasons why orchestration tools have emerged: In the past, different [...]
DBT and Airbyte complement each other perfectly. DBT enables analysts and engineers to easily and efficiently transform their data in their data warehouse environment, but the data first needs to be present in that environment. This is where Airbyte comes into the picture by enabling those same engineers and analysts to easily and reliably transfer [...]
Matillion ETL is a cloud ELT solution purpose-built with cloud data warehouses like Snowflake, Azure Synapse and Google BigQuery in mind, with a separate custom version for each provider. The cloud native design with all data jobs running in your cloud environment offers maximum speed, scalability, and efficiency and is optimized for both resource and [...]
At DataSense, we believe building a data platform always starts with a well-defined plan. Custom-built solutions tend to be difficult to maintain and are especially not future proof. Therefore, we like to work with an open standard, namely Data Vault 2.0. This standard combines methodology with a modelling approach and architectural guidelines. Automation In Data [...]
General Metadata management is the management of data about other data. It comprises, among other things, data modeling, data governance and metadata administration. In this piece, we will focus on data lineage, a key component in metadata management. Data lineage describes the complete data life cycle by providing insight in the data flow from start [...]
Challenge Companies dispose of enormous amounts of data, ranging from operational data over financial data, to benchmarks, social media data, … This data is then transformed into comprehensive reports to inform strategic decision-making processes. To ensure the accuracy and reliability that is expected of these reports, we must first ensure that the data itself is [...]
Challenge Companies collect enormous amounts of data over time going from operational data such as stock values, supplier data, orders,.. to financial data such as pricing, payments, bank statements, accounting,.. and even external information such as demographics, benchmarking data, social media,….Only a few legacy software companies supply an all-in-one package. These packages may give you [...]
Challenge Usually, business stakeholders are no data experts. They are primarily interested in getting valuable insights out of data, upon which they can take the appropriate actions. As a result, it is difficult for stakeholders to know what is possible until an analyst shows them. Furthermore, they have no idea about the effort it requires [...]
