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.

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,Continuar lendo “The Drunkard’s Walk, a book worth reading twice, or more. A Data Analyst perspective”

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, andContinuar lendo SQL Soccer Questions

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,Continuar lendo “SQL Interview Questions”

Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)

I highly recommend reading the first three links on References, at the end of this post. About XML What says the official documentation: “Each group in an XML source definition is analogous to a relational table, and the Designer treats each group within the XML Source Qualifier transformation as a separate source of data.” TheContinuar lendo “Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)”

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 unconnectedContinuar lendo “Informatica Powercenter – Stored Procedure Transformation”

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 whatContinuar lendo “Informatica Powercenter – Update Strategy Transformation SCD1 SCD2”

Informatica Powercenter – Joiner Transformation

Here’s what the official documentation says about the Joiner Transformation: Use the Joiner transformation to join source data from two related heterogeneous sources residing in different locations or file systems. You can also join data from the same source. The Joiner transformation joins sources with at least one matching column. The Joiner transformation uses aContinuar lendo “Informatica Powercenter – Joiner Transformation”

Informatica Powercenter – Filter Transformation

Let see what the official documentation says about Filter Transformation: “Use the Filter transformation to filter out rows in a mapping. As an active transformation, the Filter transformation may change the number of rows passed through it. The Filter transformation allows rows that meet the specified filter condition to pass through. It drops rows thatContinuar lendo “Informatica Powercenter – Filter Transformation”

Informatica Powercenter – Lookup Transformation

What is lookup? Whoever is familiar with Excel’s VLOOKUP might understand what this is about, but, anyway, let’s check what the official documentation says about it: https://docs.informatica.com/data-integration/powercenter/10-4-0/transformation-guide/lookup-transformation/lookup-transformation-overview.html“ “Use a Lookup transformation in a mapping to look up data in a flat file, relational table, view, or synonym. You can import a lookup definition from anyContinuar lendo “Informatica Powercenter – Lookup Transformation”

Carregando…

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