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”

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, orContinuar lendo “4 Insights you can gather from Michael Lewis’ Moneyball as a Data Analyst”

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”

[Solved, Spoilers] SQL Murder Mystery – Can you find out whodunnit?

Here: https://mystery.knightlab.com/ So, couple of friends of mine send me this challenge, and it’s really fun. Go there and try it! The plot is: someone killed someone else, and you, as the detective, need to find out who did it. Your weapons are SQL, table and relationships. Off you go! My solution to this OnContinuar lendo “[Solved, Spoilers] SQL Murder Mystery – Can you find out whodunnit?”

Informatica Powercenter 10.4.1 Basics – First Steps

The Informatica Powercenter is a 4 post series, see all posts clicking here. Before starting creating workflows and integrations let’s create our repository, here’s how. Open PowerCenter Repository Manager. Click to add new repository. Right click your Repository and add domain. Connect to your repository, Administrator / Administrator should do it. Select your REP andContinuar lendo “Informatica Powercenter 10.4.1 Basics – First Steps”

Informatica Powercenter 10.4.1 Basics – Install Client

The Informatica Powercenter is a 4 post series, see all posts clicking here. Now that we have Informatica Powercenter Server already installed, let’s proceed with Informatica Powercenter client. Here I show how. Go to the files you have downloaded and find this path: \part1\informatica_1041_client_winem-64t\Client That’s it, next next finish, and your client will be installed.

Informatica Powercenter 10.4.1 Basics – Install Server

The Informatica Powercenter is a 4 post series, see all posts clicking here. Before installing Informatica powercenter client (such as the informatica powercenter designer) you need to install the Informatica Powercenter server. Here I show how. Go to the files you have downloaded and find this path: \part2\informatica_1041_server_winem-64t\Server\ Double click install.exe. On step 6, ifContinuar lendo “Informatica Powercenter 10.4.1 Basics – Install Server”

Informatica Powercenter 10.4.1 Basics – Where to download?

The Informatica Powercenter is a 4 post series, see all posts clicking here. You can download INFORMATICA POWERCENTER at: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery Search for: “Oracle Informatica PowerCenter and PowerConnect Adapters” Select your software > click on top right “continue”. On the new page, select your Operational System > continue. On the new page >  accept the terms.Continuar lendo “Informatica Powercenter 10.4.1 Basics – Where to download?”

Data Vault Hands On – First approach

Well, so after much reading, it is time to get my hands on the job and start actually modeling some data vault models. Be aware that this is my very first attempt of turning a 3NF model in DV model. For this I’m using SQL Server Northwind database, you can get it here: https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql TheContinuar lendo “Data Vault Hands On – First approach”

Data Vault Summary of Official Standards Document Version 1.0

This text is just a summary of all information that I found relevant while reading Data Vault official documentation. The documentation is a 41 page book, and you can find it over here: https://www.amazon.com.br/gp/product/B009I8FW9Y/ref=ppx_yo_dt_b_d_asin_title_o00?ie=UTF8&psc=1 Introduction This text focus on the standards for Loading and Modeling the Data Vault. However, Data Vault is now in itsContinuar lendo “Data Vault Summary of Official Standards Document Version 1.0”

Database Concepts, Third Normal Form (3NF)

As I was studying Data Vault concepts I found myself in a dire desire of understanding more of the third normal form, 3NF. Here in this article I will present you everything I’ve gathered so far about the 3NF. Why is the 3NF important to Data Vault? Well, you certainly don’t need to be aContinuar lendo “Database Concepts, Third Normal Form (3NF)”