What is ChatGPT – Is it the rise of the Skynet era?
An interesting conversation with the ChatGPT artif...
2023-02-13
13,322 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
How to Import Data in Power BI Using R
This article shows how you can use an R script to import data into Power BI.
2023-01-23
2,084 reads
How to work with web information, maps, and images in Power BI
In this article, you will learn how you can add the map and image visuals to your Power BI report and have them update as you select different data values.
2023-01-16
2,112 reads
How to Create a Power BI report using MySQL data
Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]
2023-01-09
4,534 reads
How to create a Power BI report using REST API data
In this article, we will learn how to use a REST API from Power BI to get data for a report.
2022-12-16
24,742 reads
Tutorial to Create a Power BI Report Using PostgreSQL
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
6,384 reads
MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
14,146 reads
How to work with Python in Azure Data Studio
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
14,412 reads
How to Visualize Python Charts in Power BI Part 4
In this fourth part of the series, we look at various other plot types in Power BI using Python.
2022-09-26
1,522 reads
How to visualize Python charts in Power BI part 3
In Part 3, we look at how to use Python to create more charts for Power BI.
2022-09-19
1,711 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers