Posts

• Mar 11, 2023

  Power BI Design Techniques

  Power BI design settings for metrics, bar charts, maps, and other visuals.

• Mar 10, 2023

  **Unsolved**: Power BI freezes on Windows Azure VM

  Unsolved: Power BI freezes in a Windows Azure VM when connecting RDP from Linux using Remmina.

• Mar 9, 2023

  Power BI Publish to a Website

  How to publish a Power BI report to a website using Power BI Service.

• Mar 8, 2023

  BigQuery SQL Subtract Two Aggregations By Date

  In BigQuery SQL how to subtract values of two aggregations by date.

• Mar 7, 2023

  Python os.system vs subprocess.call

  How to use Python subprocess to run OS commands.

• Mar 6, 2023

  PowerBI PowerQuery Create a Dimension Date Table in M

  Create a dimension Date table in PowerBI PowerQuery using M.

• Mar 5, 2023

  Power BI Create a Hierarchy with Lookupvalue

  How to create a hierarchy in Power BI with Lookupvalue.

• Mar 4, 2023

  Azure Cost By Resource Over Time

  How to review the cost of Azure by resource over time.

• Mar 3, 2023

  Power Query Permission Required to Run Native Database Query

  In Power BI getting data from SQL Server using Windows authentication and opening Power Query shows Permission is required to run this native database query.

• Feb 27, 2023

  Azure Data Factory Data Flow

  Creating a data flow to join CSV files for an ETL pipeline in Azure Data Factory.

• Feb 26, 2023

  Build a Pipeline with Azure Data Factory

  Building a pipeline with Azure Data Factory.

• Feb 26, 2023

  CSS Not Loading on Jekyll and Github Pages

  CSS was not loading on my website and other strange errors. I found a bug in Visual Studio Code.

• Feb 26, 2023

  Azure Virtual Network

  Create a virtual network (Vnet) in Azure.

• Feb 26, 2023

  Azure Resource Group and Network Security Group

  Organize your Azure resources with a Resource Group and a Network Security Group.

• Feb 26, 2023

  Azure Data Factory Linked Service

  Create a Linked Service in Azure Data Factory.

• Feb 26, 2023

  Azure Data Factory Dataset

  Create datasets in Azure Data Factory.

• Feb 25, 2023

  Create an Azure Data Factory

  How to create an Azure Data Factory.

• Feb 23, 2023

  Install Visual Studio in Azure VM

  Installing Visual Studio in an Azure VM.

• Feb 23, 2023

  Deploy a Power BI Model to Azure Analysis Services

  Can we apply software engineering patterns like separation of concerns, single responsibility, and not repeating yourself to BI workflows?

• Feb 22, 2023

  Separate instrument tracks from a song

  How to separate instrument tracks from a song into vocals, drums, bass, and other.