I am currently volunteering as an instructor to teach young women about Data & SQL. Right in the first module we covered core data types as shown here: For this blog post I’d like to write about FLOAT and DECIMAL and why in most cases I think that DECIMAL is a much better choice. Approximate values According to the MySQL documentation float (and double) represent approximate numeric data values This is the reason where the general problem comes from. But…
It has already been three weeks since the end of the Code First Girls course on Data & SQL. We have celebrated the achievements on LinkedIn. I am greatly impressed by the final projects of my students. This article is for them to show possibilities how to continue learning SQL and excel as well as for others who have just begun their journey with SQL. It is well-known that practice is essential for mastering any new subject learnt. One way…
This week has been great for me as a learning opportunity by going to SQLBits for the first time ever. Well…actually not going but logging in from home watching online. So as SQLBits as all good things is petering out/comes to an end time to do a personal summary. Blogging I aimed to to a summary blog post for each day. However eagle eyed readers will notice that I stopped on Thursday which was the first conference day. Reason for…
I’ll try to highlight the top takeaways per session from my side. Keynote – Level Up with Azure Data This was an entertaining show by Microsoft’s Bob Ward and Buck Woody . They pretended that Bob has a dream about presenting and could do everything. Great consequence was that they had a lot of great people from the Microsoft Team invited presented including Pedro Lopes, Anna Hoffmann, Patrick Leblanc (Guy in a cube) and much more. Demos were given with…
This is part 2 of my series on learning at SQLBits. Today I had the pleasure to learn from Adam Jorgensen what it’s like to be a leader and how you can thrive being one. My personal motivation for this ist that I have been doing work as a BI engineer for over a decade now and am currently evaluating how to move on.# The session was truly worthwile…Adam kept it very interactive and Victoria Holt made sure that the…
It’s learning time again…with my first time at SQLBits. Sadly it’s just virtual as there is still a corporate travel ban due to Covid, but I had a great first day and learned a ton. My wife just approached me this morning telling me “Hey if you gonna learn all day take this as a chance for your blog and share what you’ve learnt there…but keep it short and simple and don’t write essays”. With the latter part…I have my…
I am currently volunteering as an instructor in a course on Data & SQL by Code First Girls. Read more about it here. Yesterday has been my first round as a teacher for a whole module. Here are some reflections on it and what I learned from it. TLDR: Don’t put too much content into one session…time catches up sooner as you think. Also allow some extra time for tech problems and Q&A. Be sure to have a dry run…
I have the great pleasure and honor to be a volunteer for Code First Girls. This is a UK based non profit organization with the mission to encourage young women to pursue a job in the Tech sector by giving them foundamentals in relevant skills such as programming or (in my case) SQL and Databases. I have been given the opportunity by Experian to volunteer in that course and share my expertise as a data professional. What does that mean…
Note: This blog post is in German as it is about a German conference and I expect mainly German readers. Moreover I have to admit it is easier to write German early in the morning than english :-P. Anyway feel free to run it through google translate if you are non-german-speaking and interested in the content. Wow…endlich mal wieder ein Blogeintrag nach langer Zeit. Ich finds zwar ganz gut, wenn man nicht immer was zu sagen haben muss aber zugegen…
TLDR In case you don’t have time reading my writing about PowerShell and the coding process and just would like to have a script up and running feel free to jump right to the end of the blog post where the final scripts are provided. What’s this all about? As a BI/Analytics Practitioner my most common tool for communicating data to business users is Excel. I have been working to build a modern analytics infrastructure leveraging OLAP cubes for a…