Power BI Pulse Chart vs. Dancing bars in Excel
[2016-Jun-30] Recently Microsoft Power BI has been enhanced with a new Pulse Chart custom visualization (Visual Awesomeness Unlocked: Pulse Chart) which...
2016-06-30
2,554 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,687 reads
Power BI Box and Whisker visualization vs. Box Plot chart in SSRS
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,354 reads
Excel Power Map vs. Power BI Globe Map visualization
[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...
2016-02-09 (first published: 2016-02-02)
5,859 reads
Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell
[2015-Dec-24] My story: two SSRS items (main report and its sub-report) need to be deployed to SharePoint. Trivial task, and...
2015-12-24
1,773 reads
PowerMap with Custom Region shapefiles - Demystified
[2015-Nov-18] Today is a global GIS Day (http://www.gisday.com/) where people across the globe celebrate and promote the use of various geo...
2015-11-25 (first published: 2015-11-18)
10,601 reads
Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting
[2015-Oct-20] A sourcing system failed to return correct results (returned value was a very high figure with double digit number...
2015-10-26 (first published: 2015-10-20)
2,271 reads
Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better
[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...
2015-08-12
1,293 reads
Single value filters and custom error messages in Power BI
"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief...
2015-07-27
1,122 reads
Setting specific colors for PowerView charts
I was listening for Phil Collins' "True Colors" song in my car audio this morning and it reminded me about...
2015-07-21
5,382 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers