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

📢 𝗕𝗜: 𝗗𝗮𝘁𝗮 𝗟𝗶𝗳𝗲𝗰𝘆𝗰𝗹𝗲 𝗳𝗼𝗿 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 👉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…

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

📊𝗖𝗼𝗺𝗽𝗮𝗿𝗶𝘀𝗼𝗻𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗗𝗮𝘁𝗮 𝗦𝗲𝗿𝗶𝗲𝘀 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…

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

📢 𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗶𝗰𝗲 𝗼𝗳 𝗣𝗮𝗿𝘁𝗻𝗲𝗿𝘀𝗵𝗶𝗽 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

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

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

📢 𝗘𝗥𝗣: 𝗘𝗰𝗼𝘀𝘆𝘀𝘁𝗲𝗺𝗶𝗰 𝗩𝗶𝗲𝘄 [.] 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…

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

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

📢𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗣𝗲𝗿𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲 #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…

📢 𝗕𝗜: 𝗡𝗮𝘃𝗶𝗴𝗮𝘁𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗨𝗻𝗸𝗻𝗼𝘄𝗻 "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…

🚧𝗦𝘁𝗮𝘁𝘂𝘀 𝗨𝗽𝗱𝗮𝘁𝗲: 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 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…

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…

📊Graphical Representation: Graphics We Live By (Part III: Exchange Rates in Power BI) I started posting also in @substack open.substack.com/pub/sqltro…

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

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