Adrian Nastase

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

[Adrian Nastase @sql_troubles]

📋"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

[Adrian Nastase @sql_troubles]

📢 𝗕𝗜: 𝗗𝗮𝘁𝗮 𝗟𝗶𝗳𝗲𝗰𝘆𝗰𝗹𝗲 𝗳𝗼𝗿 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
👉In the context of #BI/#Analytics one talks about #ingestion, #preparation, #storage, #analysis and #visualization, ignoring aspects like #data #generation, #collection or #interpretation

👇https://t.co/V4P4NLVDux

[Adrian Nastase @sql_troubles]

📢 𝗕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

https://t.co/CjoKMSggF7

[Adrian Nastase @sql_troubles]

📊𝗖𝗼𝗺𝗽𝗮𝗿𝗶𝘀𝗼𝗻𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗗𝗮𝘁𝗮 𝗦𝗲𝗿𝗶𝗲𝘀
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).
https://t.co/aroCM4UF6B

[Adrian Nastase @sql_troubles]

📢 𝗕𝗜: 𝗧𝗵𝗲 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻
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 [.]

https://t.co/K8dyfrXte5

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗶𝗰𝗲 𝗼𝗳 𝗣𝗮𝗿𝘁𝗻𝗲𝗿𝘀𝗵𝗶𝗽
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 [.]
https://t.co/V2o7b50XBP
#ERP

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗧𝗮𝗺𝗶𝗻𝗴 𝘁𝗵𝗲 𝗠𝗼𝗻𝘀𝘁𝗲𝗿𝘀
#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"

https://t.co/HK1jD1Ms5J

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗜𝘁’𝘀 𝗔𝗹𝗹 𝗔𝗯𝗼𝘂𝘁 𝗣𝗼𝗹𝗶𝘁𝗶𝗰𝘀
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

https://t.co/mwmgsRepyq

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗘𝗰𝗼𝘀𝘆𝘀𝘁𝗲𝗺𝗶𝗰 𝗩𝗶𝗲𝘄
[.] the network of interconnected #systems, technologies, applications, users [.] through their [.] interactions form an #ecosystem governed by common goals, principles, values, policies, processes and resources.
https://t.co/62YOftrlt5

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗔 𝗡𝗲𝘃𝗲𝗿-𝗘𝗻𝗱𝗶𝗻𝗴 𝗦𝘁𝗼𝗿𝘆
"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 [.]"

https://t.co/0mxMXxVoHm

[Adrian Nastase @sql_troubles]

📢 𝗘𝗥𝗣: 𝗢𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁
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.
https://t.co/dYewkBaSBa

#PMO #projects

[Adrian Nastase @sql_troubles]

📢𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗣𝗲𝗿𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲
#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.
https://t.co/M1n8D9Qnac

[Adrian Nastase @sql_troubles]

📢 𝗕𝗜: 𝗡𝗮𝘃𝗶𝗴𝗮𝘁𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗨𝗻𝗸𝗻𝗼𝘄𝗻 "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"
https://t.co/mO9FtipnKB

[Adrian Nastase @sql_troubles]

🚧𝗦𝘁𝗮𝘁𝘂𝘀 𝗨𝗽𝗱𝗮𝘁𝗲: 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 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.
https://t.co/q6QScwP5f2

[Azure SQL @AzureSQL]

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 📺: https://t.co/xEjCCOrcXG #AzureSQL

[Justyna Lucznik @JustynaLucznik]

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:

https://t.co/FLWwqqZr2B

[Adrian Nastase @sql_troubles]

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!

https://t.co/oRdGzGGPuM

[Adrian Nastase @sql_troubles]

📊Graphical Representation: Graphics We Live By (Part III: Exchange Rates in Power BI)
I started posting also in @substack

https://t.co/jUy0Xfuzzn

[Adrian Nastase @sql_troubles]

📢 𝗕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.
https://t.co/Li0NTo8kKa
#dataanalytics #BI #600words

[Adrian Nastase @sql_troubles]

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

[Elon Musk @elonmusk]

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 🤣🤣