Relationship functions in Power BI allow you to access fields within DAX measures or calculated columns through either physical or virtual relationships between tables. Common Use Cases for Relationship Functions in Power BI Defining calculated columns or measures using fields from related tables. Handling relationships between calendars and multiple date fields (transaction date, stock date, due […]
Data + Intelligence
Implementation of a Data Governance Program in an Organization
Data is the biggest asset of every organization as it drives the business, so it is very important to implement data governance correctly to avoid making wrong decisions that will pull an organization down, with fines, with a lot of frustrations, and with wrong business decisions. Data Governance defines rules on how the data should […]
QA Test Management using Xray Tool
Xray is the leading Quality Assurance and Test Management Jira plugin, which helps companies in effective and efficient testing. It is the best test management tool that covers the entire testing life cycle: test planning, test specification, test organization, test execution and test reporting. Before diving deep into Xray, we will first see Test Management […]
July 1, 2023: End of Universal Analytics and Beginning of Google Analytics 4
Why Migrating to Google Analytics 4 (GA4) Should be a Priority “Often, when you think you’re at the end of something, you’re at the beginning of something else.” Fred Rogers There has already been a lot of buzz and panic around Google Analytics 4, but we’d like to offer you the highlights of what this […]
Automate the Office of Finance with Corporate Performance Management
Financial leaders have access to a vast amount of data to help make business decisions that grow their organization. Data is one of the most valuable and powerful tools in a leader’s arsenal. However, many leaders find that they cannot trust their data due to a variety of reasons, including: Multiple legacy systems, including multiple […]
ChatGPT is the most useful tool in the world
If you have not heard of ChatGPT yet, I highly recommend you check it out. And if you want me to tell you, how I about I just show you? Hey GPT, how would you explain yourself to a consulting agency in 4 sentences, focusing on how you could add value to technical and business […]
Star vs Snowflake Schema – Which To Use When & Where
Introduction People and organizations constantly produce a lot of data. Generally, we want to store generated data to access it later. Data storing should be efficient in all aspects, including speed, cost, reliability, security, etc. That’s why different approaches to data storage exist. One of the most popular approaches is a data warehouse. Data warehouses […]
Row-level security (RLS) with Power BI
What is RLS with Power BI Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn’t […]
A Glimpse of the Power BI Dashboard
Reports In Power BI A Power BI report is nothing but a multi-perspective view of a data set with visualizations that represent different findings and insights from that data set. A report may be a single visualization or pages full of visualizations. Visualizations can be pinned to dashboards and if you select the pinned visualization, it will […]
Guide to Power BI Visuals
Introduction Without the right visuals, your Power BI report is redundant. To showcase powerful insights you need to understand when and how to use different visuals so that you can avoid wasting valuable time on building reports that don’t make an impact. We’ll walk through the process we use to decide which visuals to use […]
Tracking Insights with Usage Metrics In Power BI
Usage metrics help you understand the impact of your dashboards and reports. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization, who’s using them, and for what purpose. Usage metrics reports are read-only. However, you can copy a usage metrics […]
Different Licenses in Power BI – Which One to Choose for your Organization?
The Different Power BI Licenses There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User. Determining which type of license a user needs is going to depend on where content is stored, how they will interact with the content, and if that content needs to utilize any Premium features. Content […]