Fun with Power BI and Color Math
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
416 reads
Meagan Longoria
- Website: http://DataSavvy.me
I’m Speaking at Virtual PASS Summit 2020
PASS Summit has gone virtual this year, but that isn’t keeping PASS from delivering a good lineup of speakers and activities. I’m excited to be presenting a pre-con and...
2020-08-06
36 reads
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to...
2020-07-21 (first published: 2020-07-09)
421 reads
Data Visualization, Context, and Domain Expertise
I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...
2020-06-18 (first published: 2020-06-04)
425 reads
Power BI Data Viz Makeover: From Drab to Fab
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
14 reads
An Updated Version of the Power BI Enterprise Deployment Whitepaper is Available
A new version of the Microsoft whitepaper “Planning a Power BI Enterprise Deployment” is now available. Once again, Melissa Coates (b|t) and Chris Webb (b|t) are the authors. I...
2020-06-16 (first published: 2020-05-28)
308 reads
Using Logic Apps in a Data Factory Execution Framework – Part 1
Data Factory allows parameterization in many parts of our solutions. We can parameterize things such as connection information in linked services as well as blob storage containers and files...
2020-05-22 (first published: 2020-05-07)
561 reads
Power Up: Exploring the Power BI Ecosystem, May 27-28
Next week I’m speaking at at the Dynamic Communities Power Up event titled “Exploring the Power BI Ecosystem“. It takes place on May 27 & 28, 2020. This exciting...
2020-05-21
24 reads
Check Out My MBAS Presentation on Power BI Report Accessibility
I had the privilege of working with Tessa Hurr (PM on the Power BI team) on a presentation for the 2020 Microsoft Business Applications Summit (MBAS) about five features...
2020-05-14
22 reads
Stress Cases and Data Visualization
Times are stressful right now. There is an ongoing pandemic affecting people’s health and livelihoods. Schedules are messed up, kids are home. People who aren’t used to working remotely...
2020-04-02 (first published: 2020-03-26)
419 reads
Blogs
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...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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...
Alamat Kontak Resmi BCA KCP Kertajaya ??/Wa 08218154393
WA:08218154393 Jl. Kertajaya No.35, Airlangga, Kec. Gubeng, Surabaya, Jawa Timur 60281
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...
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