PowerBI

PowerBI

Unboxing New Power BI Composite Models

Discover the features in the new composite models introduced in the December 2020 version of Power BI Desktop in this video by YouTuber SQLBI. You can connect to a Dataset published on powerbi.com (or to Azure Analysis Services) and add tables, columns, and relationships to an existing data model. You can also mash up local […]

Read More
PowerBI

Summary of ALL Power BI updates in December 2020

Curbal walks us through the PowerBI December 2020 updates quickly so you can stay up to date with all the new features on Power BI Desktop, Power Query, Dataflows and Power BI service.

Read More
PowerBI

Write IF Statements Like a Pro in Power Query

Curbal shows you how to write if-statements like a pro. Contents: 00:40 if stamentent in Excel wont work 01:50 Use power query user interface to write if statement 03:00 Nested if-statements 03:38 AND/OR conditions in if statements 04:48 NOT condtition in if statements 05:20 Manage errors in if statements 06:13 Advanced if statements 08:19 Order […]

Read More
Azure Data Data Warehouse

Modern Data Warehousing Part 1: Azure Data Ingestion Options

In this video, Chris Seferlis  discusses stage one of the Modern Data Warehouse Process: Data Ingestion. Related Links: Azure Data Factory – https://azure.microsoft.com/en-us/services/data-factory/ Azure Databricks – https://azure.microsoft.com/en-us/services/databricks/ Azure HDInsight – https://azure.microsoft.com/en-us/services/hdinsight/ Azure Synapse – https://azure.microsoft.com/en-us/services/synapse-analytics/ Azure Data Box – https://azure.microsoft.com/en-us/services/databox/ Event Hubs – https://azure.microsoft.com/en-us/services/event-hubs/ Kafka on HDInsight – https://docs.microsoft.com/en-us/azure/hdinsight/kafka/apache-kafka-introduction IoT Hub – https://azure.microsoft.com/en-us/services/iot-hub/

Read More
PowerBI

Recreating the Financial Times Graph Corona Virus Spread Graph in PowerBI

In todays video Curbal shows you how to recreate the financial times graph in power bi where they compare the spread of confirmed cases after the countries hit their first 100 cases. Learn how to do the calculation using DAX and will plot the graph in Power BI. 

Read More