Entries by sciencegeek_admin

7 Fun Things to do with your NAS Whilst in Self Isolation

Let’s all be clear about this – COVID-19 absolutely and categorically sucks. Been the ever-growing concern we have for our family and friends, as well as the stability of many people’s livelihoods coming out of this, there are plenty of reasons to be negative about the current situation. https://nascompares.com/2020/04/22/7-fun-things-to-do-with-your-nas-whilst-in-self-isolation/

The best Power BI roadmap

The Power BI team at Microsoft publishes a “release plan,” which is essentially the public product roadmap. Anyone can use it to understand what new capabilities and improvements are planned, and when they’re expected to be released[1]. https://ssbipolar.com/2020/10/09/the-best-power-bi-roadmap/

Power BI modelling

When you think of modelling, what do you think of? A lot of intricate joins, look ups, or maybe just frustrations? Have you experienced this before? You have a measure, but it doesn’t give you the correct answer. You wonder why. You are not exactly sure why, so you tweak the measure. https://towardsdatascience.com/power-bi-modelling-bcd4431f49f9

Loading data in Azure Synapse using Copy

Azure Synapse Analytics (formerly SQL DW) )is the next evolution of Azure SQL Data Warehouse. It is a combination of enterprise data warehousing and Big Data Analytics. A Synapse SQL Pool is the enterprise data warehousing feature that is generally available in Azure Synapse Analytics. https://www.sqlservercentral.com/articles/loading-data-in-azure-synapse-using-copy

Loading data in Azure Synapse Analytics using Azure Data Factory

In my last article, Loading data in Azure Synapse using Copy, I discussed about loading data in the SQL Pool of Azure Synapse Analytics using the COPY command. Here, I will discuss the step-by-step process for data loading in the SQL Pool using Azure Data Factory (ADF). https://www.sqlservercentral.com/articles/loading-data-in-azure-synapse-analytics-using-azure-data-factory

Using Visual Studio Code to query Power BI

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, but sometimes you have a requirement that doesn’t quite fit DAX Studio. https://dax.tips/2020/08/24/using-visual-studio-code-to-query-power-bi/