Women Tech Makers Event – How to Improve your Company’s Data Governance Video

Access the channel for more content

Hello!!

It’s been a while since I’ve been here, but I’ returned with exciting news!

In April I was accepted to be one of the speaker at one event dear to my heart: the Women Tech Makers, more specifically the Montreal chapter. I was so excited when I got in!

There’s a little downside: we had technical issues on the day and the audio was not recorded on the live presentation, BUT I SWEAR IT HAPPENED, I HAD WITNESSES!

Anyways, I recorded a video, with the same content of the talk, and you can watch it on the link above.

I loved all of the talks I watched on that day, and it was my first time in this event in person. Everything was above all my expectations, I am already looking forward to the next one. Huge shoutout to all the organizers/volunteers. If you want to check out all of the talks, go into the channel, and search for the playlist of the 2023 videos, you won’t regret it.

T-SQL Tuesday Round up – Let’s check our contributions

Thanks for everyone that participated on my April’s theme of “TSQL Advice to your younger self”!

I had a lot of fun reading your different takes on it! Here are the posts of everyone who contributed (and dutifully linked it back to me 😉 ).

If you want to go back and read my invite to talk about “TSQL Advice you’d give to your younger self”, click here.

See you next time!

#TSQL2sday #149: T-SQL Advice you’d give to your younger self

Hello! As I mentioned on my invitation post, this month I’m hosting the T-SQLTuesday and my theme was “T-SQL Advice you’d give to your younger self”. Here’s my contribution.

If I could go back in time, and maybe send myself an anonymous email (which would probably go to my spam box? hmmm), this is what I’d like to find:

  • It’s ok to use Google, like every day multiple times a day. Sometimes we face issues and we may tend to get super deep into it, but forget that we do not need to re-invent stuff. Others have likely been through what you are living and if they were great human beings they even talked about it on the internet. Isn’t that wild? We must learn to be humble. It’s OK to have your colleagues and managers see an open Google tab, as long as you are delivering the job you’ve been given, you’ll be just fine.
  • Comment your code! I’ll give you a week and you’ll forget what you were doing anyways so leave some useful comments. That will help you and others who will pick up on your work after you. I like to add the following to all my scripts: author, date, project name and a little description. Sometimes I even add the name of the person who requested the work, makes it easier to talk directly whit whom I need to.
  • Do you know those times when you find yourself repeating the same piece of code over and over? There are better ways to version your code, but as a starting point, you can create a folder on your documents and start adding sql files there that you can refer to later. Here’s what I have on my folder:
    • how to search for a column or table with a specific name;
    • how to use date functions with examples such as DATEADD, DATEDIFF;
    • how to check for temp tables column names;
    • how to format phones when they’re all messed up;
    • how to find databases, filenames and paths;
    • getting a path for sql server log error message;
    • check you database size;
    • how to check for used and used space on the database
    • and whatever else your heart desires! This is the type of work that I do and that later will save my time. I’ll probably make more posts to show my solutions to this handy scripts 🙂
  • Always ident your code and use Uppercase for all commands. You’ll notice that one day you won’t even trust people who don’t do that (oh, the drama).
  • If you have someone senior than you at work, ask them questions when you’re stuck, they probably will solve the problem faster, more elegantly and you’ll learn how to do it by watching them!
  • Make it a habit of NOT using “*” when you are doing a SELECT query. It’s ok to do it once so you can see the table, but then your real query should list the fields you want to see, by name. ✨ Marie Kondo your query and let go of what does not serve you anymore ✨
  • Don’t wait until you are an accidental DBA to learn the fundamentals. Even if you just want to be able to discuss problems with them.
  • Learn how to read the query execution plan. It will help with understanding bottlenecks and how to optimize your queries.
    • …also, when optimizing, don’t struggle about the milliseconds you might save. Nobody will notice. You want to focus on the changes that will give you the biggest differences on execution time. Think about how big the impact will be by projecting “if I don’t fix this will someone come to my table with a very angry face?”
  • Whenever you start writing an UPDATE or DELETE statement, immediately write FROM… WHERE… This will save you the headaches of forgetting to finish your command and updating or deleting everything at once.

That’s it for me. Hope this was helpful for some beginners out there. Now tell me…

What do you wish you knew earlier? 🙂

#TSQL2sday #149 Invitation: Blog about T-SQL Advice you’d give to your younger self

T-SQL Tuesday is a monthly blogothon where a host chooses one topic and bloggers around the world give their ideas about it. This month is my first time being the host and I’m so excited!

April’s theme: if you could give advice about T-SQL to your younger self, what would you say? I’m not defining any more specific sub-topics here, I’m opening the floor to hear ideas about your past experiences and what you wish you knew better back then.

Some rules:

  • You have to publish your post next Tuesday, on April 12th.
  • Include the T-SQL Tuesday logo, and if somebody clicks on the logo, it has to link back to this post.
  • Include a link to this blog post, or after you publish it, leave a comment here so I can track you down for the roundup blog post next week. If you want to share via Linkedin as well or other social media, please do and I’ll link you too.
  • Isn’t this idea awesome? Do you want to join? For future hosts, please reach out to Steve Jones via Twitter on @way0utwest. Just a heads up that there is a line of people who also want to host, so if you’re uncertain, do it anyway because you have time to prep!
  • Why host? Well, as a blogger, this is a wonderful way to ramp up your visualizations and to get another bloggers to know your work. Plus, it’s one way to give back to the community. Check out how great are the posts by looking into the previous topics.

I hope this is going to be fun and I’m definitely looking forward to reading your thoughts on my theme. Let’s get writing!

my very advanced drawing skills, as always

Para outras meninas tentando se encontrar na tecnologia

Ola! Esse post é como uma carta para minha eu do passado. Talvez as coisas fiquem meio pessoais demais, mas eu espero que sendo vulnerável aqui, outras meninas vejam que não estão sozinhas e que as coisas vão melhorar.

Por que eu escolhi a carreira de tecnologia?

Quando eu estava terminando o ensino médio, minha cidade tinha um projeto de incluir ensino técnico no nosso último ano e meio da escola, para que quando acabasse teríamos mais chances de conseguir emprego logo e começar uma carreira como estagiários. Eu gostei da ideia e fui estudar Ciência da Computação. No final do curso, podíamos escolher entre programação ou banco de dados. Naquele tempo eu não podia nem ter percebido, mas minha professora principal do tema de banco de dados era uma mulher. Ela era jovem e inteligente. Eu acredito que ela me inspirou a aprender mais, então eu me inscrevi na turma de banco.

Eu gostei das aulas e me sentia boa naquilo. Então, quando foi o momento de entrar pra faculdade, minha escolha foi Banco de Dados novamente. Naquela época existia um curso voltado apenas para isso. A diretora do nosso grupo de banco era a mesma professora que ministrava nossas aulas principais de tecnologia de banco de dados. Ela era incrível. Era elegante. Entrava na sala de aula, geralmente de salto e saias ou vestidos (o que eu não via nunca nos outros professores – homens). E ela dava um baile em todos. Eu imediatamente gravitei na sua direção, e ficou claro pra mim que ela era alguém que eu me inspirava, e mais interessante ainda: outros também se inspiraram nela, porque ela era super inteligente e claramente sabia o que estava fazendo. Eventualmente, ela foi minha mentora no TCC, algo que eu sou eternamente grata por ter feito, eu adorava nossas reuniões e as suas ideias.

O trabalho não é o que eles ensinam nas escolas

Na faculdade eu tive pouquíssimas colegas mulheres, o que me levou a pensar que no trabalho seria o mesmo… e foi. Era muito difícil encontrar outras mulheres (ainda é, apenas um pouquinho melhor), especialmente em cargos de liderança. Na minha experiência, a maior parte do tempo eu era parte de um grupo pequeno de mulheres do time, que também faziam mais parte de gerenciamento e planejamento de projetos do que desenvolvimento ou banco de dados. Um fato curioso: a primeira vez que fui trabalhar para uma empresa grande, o meu futuro time tinha apenas uma outra mulher, e foi ela quem falou para os homens que me entrevistaram que eu deveria entrar no time de TI e não em um outro time que lidava com os negócios. Eu não fazia ideia de quão importante a ajuda dela seria pra mim, eu sou grata por suas ações, e aprendi muito com ela depois. Porém, uma coisa que eu nunca perguntei nem pensei muito foi: por que um grupo de homens viu meu currículo e assumiu que meu perfil era mais de uma vaga não técnica e foi preciso outra mulher lê-lo para entender que não era?

Eu acho que apenas tive uma gerente mulher quando comecei a trabalhar no Canadá. Foi uma experiência boa ter alguém com quem você pode ser completamente aberto sobre tópicos pesados como misoginia no trabalho, e não ter tanto medo do que suas falas podem te causar.

Eu queria contar essa parte da minha história para dar um exemplo de quanto significou pra mim, ter mulheres com quem eu pudesse contar. Claro que eu também trabalhei com homens incríveis e aprendi muito com eles, mas os momentos em que eu mais acreditava em mim era quando eu tinha outra ela para me apoiar.

Ter uma mulher em uma sala cheia de homens não faz com que ela seja excepcional, isso significa na verdade que erramos em alguma coisa durante o caminho e deixamos muitas outras de fora.

Como ajudar?

  • Se você puder e se o assunto te interessa, eu sugiro ser mentor(a) de alguém. Você não faz ideia de quanto um pouco de conselho pode chegar longe. Esteja aberto para ouvir, ver e tomar ação.
  • Quando você ver mulheres passando por situações difíceis no trabalho, fale sobre elas e deixe claro que em você elas tem uma parceria. Se você tem medo de consequências (o que por sinal sinto muito pela situação!), procure alguém que possa te ajudar, alguém que você sabe que não vai te deixar em um momento difícil. Seja vulnerável e você entenderá quem está com você.
  • Por último, consuma referencias femininas. Esteja consciente e faça escolhas de ver e dar o devido valor ao trabalho de mulheres, apenas pelo fato delas serem brilhantes no que fazem e na capacidade de te contar histórias das quais você não tem contato.

Para aquelas passando por dificuldades

  • Você não está sozinha. Busque por outras na mesma posição que você. Não subestime o poder de estar em um grupo que te entenda.
  • Encontre a sua âncora. Eu sempre procurava alguém que eu sabia que me ajudaria em momentos complicados. Siga-os, faça com que te vejam e vão te ouvir.
  • Não deixe os medos te paralisarem. Faça com que te escutem. E caso você não encontre forças pra falar quando for preciso: está tudo bem, você não precisa resolver os problemas do mundo sozinha.
  • Para aquelas passando por momentos difíceis: eu entendo, eu te escuto, eu te vejo. Fale comigo se você precisar de alguém pra desabafar.

Espero que nos tornemos melhores para nossas futuras gerações.

For girls struggling to find their way in tech

Hi! This post is kind of a letter to my past self. Things may get personal here but I’m being vulnerable with the hope that girls will see they are not alone and that things get better.

Why did I chose tech?

When I was finishing high school, my city had a project to include a technical to our last year and a half of school so that when we were done we could potentially be trainees somewhere. I liked the idea and I went to study Computer Technology. At the end of the course, we could choose between programming or databases. At that time I may not have realized, but my main database fundamentals teacher was a woman. She was very young and bright. I believe she inspired me to learn more, so I signed up for databases.

I then liked the classes and thought I was good at it. So, when I signed up for college my choice was Databases again. At the time we had a full course designed just for that. The director of our database groups was a teacher that lead the main DB classes. She was fierce. She was gorgeous. She would enter the room to teach, usually wearing high heels and skirts and dresses (which is not what you saw the other male teachers using). And she would kick ass. I immediately gravitated towards her, and then it was clear to me I looked up to her, and more interestingly: other people looked up to her, because she was intelligent and she knew what she was doing. Eventually, she was the one who mentored me on my final project, which I’m forever grateful for, I loved our on to one meetings and insights.

Work is not what they teach you at school

In my class at college I had few women colleagues, which lead me to think that at work it would be the same…and it was. It was hard to find women at the workplace (still is, but slightly better), specially in leadership roles. From my career experience, most of the time I was part of the very small group of women in the team, who also would take more project management than development or databases. Fun fact: the first time I joined a big company, there was only one other woman on the team of my hiring managers. She was the one that read my CV and made sure I was being sent to the tech team instead of the business one. I had no idea how important her braveness would be for me, I’m grateful for her actions, someone whom I learned a lot with. Something that I never asked and never gave much thought about is the fact that a group of men saw my resume, and still thought I was more suited to the business team (spoiler: I was not).

I believe it wasn’t until I got to Canada that I had my first woman manager. It was a nice experience to have someone who you can be open about misogyny at work, and not worry so much about what the throwback may be.

I wanted to tell you this part of my history to give an example of how much it means to me to have women who I can look up to and count with. Of course I also worked with wonderful men and learned a bunch with them, but the times I would believe myself the most was when I had other she to walk with me.

Having one woman in a class full of men does not mean she is exceptional, it means we screwed up something along the way and left many others out.

How can you help?

  • If you can and this is a topic that interests you, I’d suggest mentoring someone. You have no idea how much a little bit of guidance goes a long way. Be open to hear, see and take action.
  • When you see women struggling at work, speak up and also give them a hand and help them get up on their feet. If you are afraid of facing consequences (which I’m sorry if you do), find someone at work who can help you, someone you know that will back you up. You manager is not your only option. Be vulnerable and you’ll see right away who’s with you.
  • Lastly, consume female references. Be mindful of seeing and praising women’s work, for the sake of their brilliance and the stories you would not hear from others.

For the girls struggling

  • You are not alone. Seek for others in the same position as you are, do not take for granted the comfort and power of being in a group that supports you.
  • Find your anchor. I would always gravitate towards someone who I knew would back me up. Follow them, make them see you and you’ll be heard.
  • Don’t let the fears wear you down. Make yourself heard. And if you don’t have the strength to speak up when you need, that’s ok too, you don’t have to solve the worlds problems by yourself.
  • For all the girls out there struggling: I feel you, I hear you, I see you. Reach out if you need someone to talk to.

I hope we get better for our future generations.

Mulheres na Tecnologia

Olá! Já faz um tempinho que eu não apareço aqui, mas hoje eu gostaria de falar sobre mulheres na tecnologia, já que em 8 de março nós celebramos o Dia Internacional da Mulher! Já que esse tópico é algo que eu gosto muito, eu vou dividir minhas ideias em alguns post pequenos que vou compartilhar durante o mês.

Alguns fatos históricos rápidos sobre mulheres na tecnologia

Você sabia que…

  • A primeira pessoa a escrever um algoritmo foi uma mulher? O nome dela era Ada Lovelace. Ela tem até uma linguagem, Ada, nomeada em sua homenagem.
  • O termo “bug” (inseto em inglês) foi inventado por Grace Hopper quando ela literalmente removeu um inseto de um computador.
  • Quando as universidades começaram a criar cursos de ciência da computação, a maioria dos alunos eram mulheres? O motivo era por que se imaginava que trabalhar com um computador seria um trabalho para funções como secretarias, que eram na sua maioria mulheres.
  • Quando não introduzimos meninas à ciência durante uma idade escolar, nós estamos provavelmente desencorajando-as a seguir carreiras em ciência e tecnologia? Ter referências com as quais nos identificamos faz muita diferença.

Para terminar, eu gostaria que você pensasse sobre, e talvez deixar um comentário aqui embaixo, quem são as mulheres da tecnologia que te inspiram hoje? Quais são suas referências femininas? Caso sua lista seja pequena, seria por que essas mulheres não existem (dica: existem sim!!) ou porque você ainda não teve exposição a elas? Tire um tempinho para refletir sobre 🙂

Até logo!

Women in Technology

Hello! It’s been a while and I wanted to talk about women in tech, given that in March 8th we celebrate the International Women’s Day! Since this is a topic dear to my heart, I’m dividing my ideas into some posts which I’ll be sharing during this month.

Quick historical facts about women in tech

Did you know that…

  • the first person to write an algorithm was a woman? Her name was Ada Lovelace. She even has a language, Ada, named after her.
  • the term “bug” was invented by Grace Hopper when she literally removed a fly – bug from a computer.
  • when universities started to create computer science courses, they were majority filled by women? The reason behind that is because using a computer was seen as a job secretaries would do, hence something more women used to do than men.
  • by not introducing girls to science during their early ages we may actually discourage them to get into STEM? Seeing references which we can relate to are a big deal.

To finish, I wanted you to think about, and maybe share below, who are the women in tech that inspire you today? What are your female references? If your list is short, is that because you think they don’t exist (hint: they do!!) or because you haven’t exposed yourself to them yet? Take some time to reflect on that 🙂

See you soon!

Book review – “Storytelling with Data”, by Cole Nussbaumer Knaflic

Hello! As you may have noticed from my Reading List page here, I like to read. Recently, with the new job, I was looking for a book that talked about Data Visualization. While searching, I came across “Storytelling with Data”, and it was not the first time I saw it. After checking a few reviews, I decided to invest my time reading it. Turns out it was a great decision! I liked it so much that I wanted to talk about it here, so here it comes, grab your reading glasses.

Who should read this book?

I believe this book is great for beginners to BI and Data Visualization. However, it does not require any fancy tools. In fact, the author claims to have used Excel in all the examples. In short, if you work with and have to present data to others, this will be a valuable reading.

What’s covered in this book?

In some of the main chapters, you’ll find information about how to pick the right design for the story you are trying to tell. Bellow is a very brief summary for some chapters covered.

The importance of context

Sometimes we get so into the analytics part of the visualization, the we can easily forget the context behind it. Which is why it’s good t think about who’s this data for, what they are planning to do with it and which questions are trying to be answered by this viz. If you don’t considered this, then you’re just plotting numbers on a report that people will not know what to do with.

Key points: engage with the audience, leave some prompts with call to actions that will guide them to where they should look to understand what is being presented.

Effective visuals

Sometimes, the shine things are not the best. As a BI dev, you may want t go crazy and try something that is rarely used, because it’s cool. However, when you do this, you let go of the main objective of your work: you’re not doing this for yourself. Somebody or some team requested this, and people are more at ease with things they already know how to operate. If they only use excel and visualize data with tables, they may not be interested in seeing a area or stacked bar, because that translates to extra brain effort.

Key points: avoid pizza and donuts charts always, because our eyes can misinterpret them. When possible, stick to familiar forms for the audience (bars, line graphs etc).

Eliminating clutter

This is a hard one for me. I find it one of the most difficult things to do, which is eliminate what is unnecessary. If you want to tell too much at once, you end up not telling anything at all. It’s a good practice to keep it short, keep it simple. Answer what is being asked, and remember you do not need to make the audience take the analyzing journey with you. That was your job! Their precious time will be used to see the final results. You can brag about the hard work you do in a meeting with your managers, for example (performance reviews exists for this!)

Key points: Only show what’s important for the context of the story, remove repetitive things and summarize when possible. Even considere plain big old numbers to highlight very specific topics instead of showing a whole graph for it (for example, when showing a product price range through time, instead of using a graph, just say “Product X had an increase of XX% in x years.”)

Focusing attention

When looking at a data visualization, it’s easy to get lost. If it’s too colourful, too bright, or dull, you may not know what is the key point being presented to you. As mentioned, the audience is not there to go through the analysis with you. That part should be done and you can call out to the audience’s attention by using:

  • color: you could tone everything down, for example by making use of gray tones, and use 1 single color that would pick someone’s attention because it stands out so much.
  • bold letters: bold letters are good because they don’t make your viz look clutter as underline may do, and are more perceptive than italic.
  • sizing: you can make things bigger to call attention, just make sure it’s an appropriate size.

Think like a designer

Wearing your design hats! She mentions in the book that people tend to think that beautiful is in fact perceived as more efficient. This may be a neglected point when you don’t have much time to put into the design, but taking this extra step shows respect for your audience and your data (awn!).

Key points: who doesn’t like pretty things???

Storytelling

Storytelling is what ties it all together. You could have done a great analysis, found awesome stuff about the data, presented it beautifully, but if you’re missing the context because you can’t put it into a “story”, and just like that, you may have lost the audience.

Heard of Death by Powerpoint? Yeah. Creating a narrative that guides the people to your findings, using their language, showing the steps, involving them and asking them to follow along with you is important.

Key points: she really got me thinking about the prompts we can make to the audience. Using questions is an awesome way of inviting people to think about what they are seeing. And when that is narrated by a story, it’s more compelling. It’s hard to follow numbers on a page, it’s easy to see a story develop itself in front of you.

Would I recommend this book?

It’s clear by now that I loved it. It feels like I took a shortcut to avoiding some headaches that would have come with experience in BI. With that being said, don’t go in thinking you’ll see technical stuff about how to actually create vizes, specially with a tool like Tableau or Power BI, there is nothing in there about this.

Other resources

Cole has a blog called (brace yourselves) Storytelling with Data! It’s full of resources and has more info about the workshops and material they have.

That was it for me. I’m excited to check books that were mentioned on this one, and if they’re interesting I may write a review for them too. See you soon!

My scketchnotes from Tableau Conference 2021 – Data Culture & Data Governance

Hello! Recently I’ve started a new job as a Business Intelligence Analyst (I’m thrilled about this :D). One of my team’s main tool is Tableau, which is used to create data visualizations. I’ve always loved this topic, but it was not something necessary to apply at work… until now!

Tableau has a conference that is happening from November 9-12. I attended the first day yesterday, specially the sessions that talk about Data Governance and Data Culture, given these are topics that will be present in my day to day work.

Something things about me:

  • I’m a visual learner;
  • I like to take notes, they help me structure what I just listened;
  • I love drawing (love does not equal being great at it, you can love it too!);
  • Sometimes it’s hard for me to just sit there and listen to a talk, my mind can drift away very quickly.

Once I saw Kendra Little’s method of sketchnotes and thought it was awesome so I’m giving it a try now. Basically, during the live conference you take notes, but not writing too much. This method forced me into condensing the topic even more, and using visual aids to make the notes more appealing. For my first try it was interesting. It was a great help for me, because I learn better if I’m writing something down, and doing it this way allowed it more freedom.

Without further ado, here are the notes so far! I hope that by checking them out you could understand what the session was and inspire you to try your own!

Data for the win: how two olympic athletes use data
Data Literacy: How to get your company involved in data
Empower users to know, use & trust governed data
Creating Data-Driven Organizations

I know there are typos in there, my goal was not to take perfect notes, but to absorb as much information as possible. I hope this was useful and let me know if you try it!

Let’s all data!

#Data21 #Tableau