FACTS AND DIMENSIONS LIMITED’s Post

Over 100 people have passed our Basic SQL Joins course now! Pass: 74 Merit: 7 Distinction: 15 Congratulations to you all. I have asked a few random students for permission to share their success. See pics of their certificates. Some are passes and some distinction. I should point out, generally students getting distinction have already got SQL experience and those getting passes are new, so all are equally impressive. Well done Khaled Elfeky, Henry Cheung, Geethu Thottungal Harilal, Marlene Steinbach and all the other students. Please share your success in the comments. I have been delivering this training weekly over Teams and also at the Snowflake HQ in London and at various NHS sites. Thanks also to KeyAnalytics for helping me design the course and to AnalystX for promoting the course. Students can use their certificate towards their National Competency Framework level (SA13 Technological Specialisms) I will keep giving up my time to train everyone in the NHS who wants it. Just keep signing up on AnalystX website (https://lnkd.in/ek_w_mQE) and on Snowflake's website (https://lnkd.in/eAPTUNdX) Thank you all :)

What data would you like? CURRENT BUSINESS MODEL: Customer pays an annual subscription. Fixed annual licence fee, unlimited use. NEW ADDITIONAL MODEL Customers wanting just a few datasets no longer need to pay the full annual subscription, but can instead Pay As You Go! See offering here: https://lnkd.in/eKWHJxyf To ask us to add new datasets not yet in the catalogue, just ask :) Current catalogue: https://lnkd.in/dwGJSfzV

If you or you have team members who need basic SQL training, please join AnalystX and visit this discussion: https://lnkd.in/eiDNrrE2

Help Us Create Our Free Basic SQL Query Training Course. We have been made a Strategic Partner of AnalystX. As is the spirit of the group, we all give a bit. My input will be to provide a weekly drop in course to deliver basic SQL training to anyone who wants it. For free. This means NHS analysts will gain much needed basic skills and I get to show off Facts and Dimensions as I will use the FAD data for the training. This training is for giving analyst the basic skills needed to confidently analyse data themselves. What will be covered. 1 Basic understanding of star schema (facts and dimension tables) 2 All main elements of SELECT query (SELECT, LEFT JOIN, INNER JOIN, WHERE, GROUP BY, HAVING, ORDER BY, TOP) 3 All main summation elements (COUNT, AVG, SUM, MAX, MIN) 4 DISTINCT when to and when not to use it 5 NULL, ISNULL, = NULL 6 IN, BETWEEN 7 LIKE expressions 8 Common Table Expressions 9 Dynamic SQL 10 Openquery 11 How to write performant queries, especially over linked servers How to connect using Tableau, Power BI, Excel, Access, R, etc 12 Cursors 13 Temp tables Items 1 to 7 are the ones that I consider critical. I plan to make sure the course is a maximum of 6hrs long and will at least cover those critical elements. So, can I have one or two volunteers to try out the training on please. Ideally two days of your time as it will be a bit stop-start as we together neaten up the training programme for a single day. For this development of the course, I am only wanting people from our existing customers, who are already at least a bit experienced using the FAD database and who are wanting to better understand how to use SQL to query data. Please get in touch directly. Longer term, the course will be improved by making use of smartR AI's SCOTIE (aka myGPT) tool which we have trained with the training materials I wrote with help of Keystream . We'll train using Snowflake's SnowSQL and Microsoft's TSQL.

Shall I add my diet data to FAD? https://lnkd.in/e8pMSmXU

Probably the best attended show we exhibit at. Thanks to Neil Hadland and his team -the best in the biz!

Try #factsanddimensions and smartR AI myGPT

Test Scripting! https://lnkd.in/g_w4wrg I'm filling in for a late pull out at the AI World Congress 2023 on Tuesday! Oliver King-Smith, CEO of smartR AI is giving a talk on Monday! We're working very closely with them, developing an absolutely awesome GPT layer for our customers to make far better use of the Facts and Dimensions database. Oliver's talk is a very interesting talk on AI in Data Analytics. Because I am a very late fill in, I am going to give a talk I gave to 500 devs at BT 8 years ago on the importance and advantages of Test Scripting. I will explain to the audience how Test Scripting is the corner stone of how and why the #factsanddimensions service came to be so well trusted. I think it is relevant at this AI event as, when all is said and done, it is us devs and users and business owners, etc who know what we want from all this new tech. And, more importantly, what we don't want. Test Scripting is how we can ensure the tech we develop stays within the boundaries we want.