For this video we will look at multiple fact tables. We will look at modelling the data so that both fact tables can share dimensions to reduce workload. On top of having multiple fact tables, we will look at how to deal with changes in dimensions between fact tables. Business [...]
For this video we will look at building a self-service report. We will provide the user with the freedom to select a visual type from several options and chose what fields to assign to it. Additionally we have the option of switching between a light theme and a dark theme. [...]
For this video we will look at building a solution around currencies. We will try and find a way allowing the user to view either all currencies in their right formatting or exchange the values to a currency of choice.
In this video we will transform status log data using m query, DAX and finally SQL. We will try several approaches: Query Editor and Dax, Query Editor and Merges, Native SQL, SQL View using SSMS and both import and direct query. SQL Script:
In this video we will build an interactive report where the user has the full app experience using buttons, bookmarks and formatting. The end result is a dynamic interactive report with a conditional filter pane, visual selection option and a print view.
In this video we will implement a What IF scenario where the user can customize a number of stores added to a country.
In this video we will build a report where the user can choose a timeline, measures, and columns dynamically.
In this video we will find cluster data into percentiles and find a great way to visualise the data.
In this video we look at different ways of conditionally formatting dynamic KPIs using various visuals, different DAX formatting options and a KPI tooltip.
Part 3 of the PowerÆgg RLS & OLS videoseries (3 videos) where we try and find the best possible solution for implementing Row Level Security (RLS) and Object Level Security (OLS) in the same Power BI report.