Fabric Tutorial – Lakehouse and Warehouse with Power BI
Credit Github Files: Stephen M. GitHub Files: https://github.com/samaguire/Sqlbi-Contoso-As-Parquet Pick your Contoso parquet file dataset size, as suites you best.
Fabric Tutorial – Let’s get started
Microsoft Fabric is here. This is the first tutorial from PowerÆgg where we look at data ingestion, data transformation and data distribution. Subscribe for more Videos!
Power BI – Field Parameters and Use Cases
For this Power BI video tutorial we will look at all the use cases for field parameters I could think of. RLS & OLS Add field parameters. Add field parameter fields to visual. Create security roles for row level security. Add object level security to the appropriate fields. Note: When adding OLS, be [...]
Power BI – R Script Fun with ChatGPT
For this video we will look at using ChatGPT to write an R Script query in Power BI. We will look at creating a mutate function that manipulates the sales fact quantity data creating a jitter effect every time the data is refreshed. The end result will be a line chart with the [...]
Power BI – Dynamic Benchmarking
For this video we will look at benchmarking business years for sales and profit. We will look at modelling the data so that we can compare values by creating references to our sales and date table. Both fact tables however will share the same dimensions allowing us to dynamically chose [...]
Power BI – Multiple Fact Tables
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 [...]
Power BI – Self-Service Reporting
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. [...]
Power BI – Currencies
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.
Power BI – Log Data and Query Folding
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:
Power BI – Buttons, Bookmarks and Formatting
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.