Home

Exam DA-100: Analyzing Data with Microsoft Power BI

Nesse blog vou colocar tudo que estou usando para estudar e tirar a certificação DA-100 para Power BI da Microsoft. Meu objetivo é poder compartilhar com todos que possam fazer uso desse conteúdo.

Google Looker – the basics

First part gives a macro overview on Google Looker, so it’s time to start digging deeper. Is Looker free? No, Looker is not free. Looker Studio is free, but that is a different product. I really wish they could change names, remove one of those products or I don’t know…. so much confusion, even harder…

Google Looker – First steps

So, I am trying to learn Looker for a new project, and, as usual, I will share here all materials I am using to better understand this new tool. Let me first start saying that, start to learn a new tool from scratch, with no help from anyone, is really hard, you will usually get…

Azure DP-900: Microsoft Azure Data Fundamentals | Notes and Highlights

Just passed Azure DP-900 exam! Here is what and how I did it: And here are all notes I’ve taken during my study process: Document Data Store Azure Storage Azure SQL Database Graph Database Azure HDInsight Azure Data Explorer Azure Table Storage Key / Value Data Store Spark Structured Streaming Azure Cosmos DB

The Drunkard’s Walk, a book worth reading twice, or more. A Data Analyst perspective

As you know, if you follow my LinkedIn profile (which, if you doesn’t, you should) I was reading Leonard Mlodinow’s “The Drunkard’s Walk”, a really great book if you want to get a grasp on how chance, or how randomness, affects our lives, and, what is better, how we fail to perceive what is chance,…

4 Insights you can gather from Michael Lewis’ Moneyball as a Data Analyst

If you follow me on LinkedIn you already know that I’m, or actually was, reading Moneyball. Just finished the book today, and so I thought it would be fun to share what I got from this book using my perspective, in other words, a data analyst’s perspective. It’s no surprise that this book is, or…

SQL Soccer Questions

Recently I came across a SQL interview question, the “SQL Soccer Matches” question, have you seen this already? This is the kind of question you can find in an interview exam. Anyway, in order to answer that I developed many approaches to solve it: using union, using many ctes and union, using case sum, and…

SQL Interview Questions

I’m going big on SQL these days. I always loved SQL, but this couple last days I’m going hard on learning and mastering it. There’s still lot to do, many courses to take, many books to read, and many exercises to do. Talking about exercises, this guys Nick Singh just lunched a site with questions,…

Informatica Powercenter – Stored Procedure Transformation

Let’s start checking out what the official documentation has to say: “A Stored Procedure transformation is an important tool for populating and maintaining databases. Database administrators create stored procedures to automate tasks that are too complicated for standard SQL statements. The Stored Procedure transformation is a passive transformation. You can configure a connected or unconnected…

Informatica Powercenter – SQL Overrides

I did not really find any super good resource on this topic, but the overall idea of SQL override is to override a transformation default behavior by writing a SQL query instead. Of course, SQL overrides works only on relational data. There is no SQL Overrides for flat file. For instance, take a source qualifier…

Informatica Powercenter – User Defined Functions

User Defined Function (UDF’s) is a way Powercenter gives us to create our own personal, reusable, functions. We can use our UDF’s in Expression Transformations in order to reuse expression logic. For instance, if you want to RTRIM() LTRIM() and UPPER() several ports, so, instead of writing all these 3 functions all the time you…

Informatica Powercenter – Mapplets

Here what official documentation says about Mapplets: A mapplet is a reusable object that you create in the Mapplet Designer. It contains a set of transformations and lets you reuse the transformation logic in multiple mappings. When you use a mapplet in a mapping, you use an instance of the mapplet. Any change made to…

Informatica Powercenter – Update Strategy Transformation SCD1 SCD2

Something worth keeping in mind: in order to Update Strategy to work properly you need to make sure that your target table has a primary key. Here’s what the official documentation says about Update Strategy Information: “The Update Strategy transformation is an active transformation. When you design a data warehouse, you need to decide what…

Carregando…

Ocorreu um erro. Atualize a página e/ou tente novamente.