IT guy: 25y in BI/Analytics/Dataviz PowerBI/Synapse/Fabric SSIS/SSRS, ERP/migrations/support/PM/DataMgmt, D365FO/HR/CRM, SQLServer/Oracle, Ops/Soft-Eng, O/M365
Joined December 2009
- Tweets 649
- Following 2,211
- Followers 456
- Likes 45
18 Photos and videos
21 Sep 2025
๐"Understanding is accomplished through: (a) the use of relative size of the shapes used in the graphic; (b) the positioning of the graphic-line forms; (c) shading; (d) the use of scales of measurement; and (e) the use of words to label the forms in the graphic." R Lefferts 1981
28
9 Aug 2025
๐ข ๐๐: ๐๐ฎ๐๐ฎ ๐๐ถ๐ณ๐ฒ๐ฐ๐๐ฐ๐น๐ฒ ๐ณ๐ผ๐ฟ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐
๐In the context of #BI/#Analytics one talks about #ingestion, #preparation, #storage, #analysis and #visualization, ignoring aspects like #data #generation, #collection or #interpretation
๐sql-troubles.blogspot.com/20โฆ
35
3 May 2025
๐ข ๐I: ๐ ๐ผ๐ฟ๐ฒ ๐ผ๐ป ๐๐ฎ๐๐ฎ ๐ฉ๐ถ๐๐๐ฎ๐น๐ถ๐๐ฎ๐๐ถ๐ผ๐ป
There are many reasons why the #dataviz available in the different mediums can be considerate as having poor #quality and unfortunately there is often more than one issue [.]
#gaps #issues #BI
sql-troubles.blogspot.com/20โฆ
50
2 May 2025
๐๐๐ผ๐บ๐ฝ๐ฎ๐ฟ๐ถ๐๐ผ๐ป๐ ๐๐ฒ๐๐๐ฒ๐ฒ๐ป ๐๐ฎ๐๐ฎ ๐ฆ๐ฒ๐ฟ๐ถ๐ฒ๐
For comparing two data series, one can use line charts (A-C), column charts (E), stacked column charts (D), area charts (F), water charts (G), tornado charts (H) and even ribbon charts (I).
sql-troubles.blogspot.com/20โฆ
1
37
24 Apr 2025
๐ข ๐๐: ๐ง๐ต๐ฒ ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ถ๐ผ๐ป
Given any amount of #data, the #knowledge that can be obtained from it can be limited by many factors - the degree to which the data, #processes and #models built reflect #reality [.]
sql-troubles.blogspot.com/20โฆ
26
22 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐ง๐ต๐ฒ ๐ฃ๐ฟ๐ถ๐ฐ๐ฒ ๐ผ๐ณ ๐ฃ๐ฎ๐ฟ๐๐ป๐ฒ๐ฟ๐๐ต๐ถ๐ฝ
When one proceeds on a journey, itโs important to have a precise destination, a good map to show the road, [.] good gear, enough resources [.] but probably more important, good companions [.]
sql-troubles.blogspot.com/20โฆ
#ERP
36
20 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐ง๐ฎ๐บ๐ถ๐ป๐ด ๐๐ต๐ฒ ๐ ๐ผ๐ป๐๐๐ฒ๐ฟ๐
#ERP #implementations "are often a matter of endurance with many junctions, skirts, turns, shortcuts, ups and downs, a continuous carousel in which the various issues tend to misbehave like little monsters"
sql-troubles.blogspot.com/20โฆ
42
19 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐๐โ๐ ๐๐น๐น ๐๐ฏ๐ผ๐๐ ๐ฃ๐ผ๐น๐ถ๐๐ถ๐ฐ๐
An #ERP #implementation takes place within a political #context and #politics can make or break implementations. Politics occurs whenever individuals or organization #groups interact to make #decisions
sql-troubles.blogspot.com/20โฆ
39
18 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐๐ฐ๐ผ๐๐๐๐๐ฒ๐บ๐ถ๐ฐ ๐ฉ๐ถ๐ฒ๐
[.] the network of interconnected #systems, technologies, applications, users [.] through their [.] interactions form an #ecosystem governed by common goals, principles, values, policies, processes and resources.
sql-troubles.blogspot.com/20โฆ
25
16 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐ ๐ก๐ฒ๐๐ฒ๐ฟ-๐๐ป๐ฑ๐ถ๐ป๐ด ๐ฆ๐๐ผ๐ฟ๐
"An #ERP #implementation is occasionally considered as a one-time endeavor after which an organization will live happily ever after. In an ideal world that would be true, though the work never stops [.]"
sql-troubles.blogspot.com/20โฆ
41
16 Apr 2025
๐ข ๐๐ฅ๐ฃ: ๐ข๐ป ๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐
Given its intrinsic #complexity and extended implications, an #ERP #implementation can be considered as the real test of endurance for a Project Manager, respectively the team managed.
sql-troubles.blogspot.com/20โฆ
#PMO #projects
43
15 Apr 2025
๐ข๐๐ฅ๐ฃ: ๐ง๐ต๐ฒ ๐ฃ๐ฟ๐ผ๐ฐ๐ฒ๐๐ ๐ฃ๐ฒ๐ฟ๐๐ฝ๐ฒ๐ฐ๐๐ถ๐๐ฒ
#Technology can have a tremendous impact on #organizations, helping them achieve their strategic #goals and #objectives, however it takes more than an #ERP #implementation to leverage that potential.
sql-troubles.blogspot.com/20โฆ
34
27 Mar 2025
๐ข ๐๐: ๐ก๐ฎ๐๐ถ๐ด๐ฎ๐๐ถ๐ป๐ด ๐ถ๐ป๐๐ผ ๐๐ต๐ฒ ๐จ๐ป๐ธ๐ป๐ผ๐๐ป "One of the important challenges in #BI [.] is that people try to oversell ideas, overstretching, shifting, mixing and bending the definition of concepts and their use to suit the sales pitch"
sql-troubles.blogspot.com/20โฆ
44
6 Mar 2025
๐ง๐ฆ๐๐ฎ๐๐๐ ๐จ๐ฝ๐ฑ๐ฎ๐๐ฒ: ๐๐ผ๐ฝ๐ถ๐น๐ผ๐ Until #Copilot for #SQLServer is ready, one can use #M365 or #Edge Copilot to #learn writing #code in #TSQL. The starts are modest, though enough for creating the basic scaffolds required for more #programming.
sql-troubles.blogspot.com/seโฆ
45
Azure SQL now offers 10 free databases per subscription for life, empowering AI enthusiasts, data analysts, & developers to build, analyze, & innovate without costs! Learn more on Data Exposed with @AnalyticAnna & @PatilAmar.
Watch ๐บ: bit.ly/41BfjoI #AzureSQL
1
9
28
1,475
Adrian Nastase retweeted
26 Feb 2025
Tons of great #DataEngineering capabilities in the Feb release! ๐ CI/CD support for T-SQL notebooks, better monitoring for high concurrency, snapshots for running #notebooks & more! โจ Check out the details here:
blog.fabric.microsoft.com/enโฆ
1
18
50
2,454
26 Feb 2025
I tested the creation of #tables and #CRUD operations encapsulated in #storedprocedures or #views via #M365 #Copilot and the results are more than promising. I wonder what the Copilot for #SQLServer brings!
sql-troubles.blogspot.com/20โฆ
37
19 Feb 2025
๐Graphical Representation: Graphics We Live By (Part III: Exchange Rates in Power BI)
I started posting also in @substack
open.substack.com/pub/sqltroโฆ
30
17 Feb 2025
๐ข ๐I: ๐ ๐ง๐ฎ๐น๐ฒ ๐ผ๐ณ ๐ง๐๐ผ ๐๐ถ๐๐ถ๐ฒ๐
"Do not try to rush things; ignore matters of minor #advantage" but people love to rush in and make #progress rapidly, respectively discuss minor things until they get exhausted.
sql-troubles.blogspot.com/20โฆ
#dataanalytics #BI #600words
53
17 Feb 2025
Sadly, I saw similar results in other contexts. Usually, somebody hasn't understood the #processes and the #businessrules that apply. More likely is that #data's #quality is poor in some areas or the #integration with the clouds of heavens is missing or faulty... #misinformation
According to the Social Security database, these are the numbers of people in each age bucket with the death field set to FALSE!
Maybe Twilight is real and there are a lot of vampires collecting Social Security ๐คฃ๐คฃ
68