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.

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”

Data Vault a glimpse

Well, I had to stop my studies on Kimball’s The Data Warehouse ETL Toolkit for now, and it is because I have to dig as deep as possible in the Data Vault subject, which, I must say, is a very very interesting topic. I love data modeling and Data Vault seems to be a strongContinuar lendo “Data Vault a glimpse”

Retrospectiva 2021

Última semana do ano, minha cabeça está explodindo com ideias do que fazer, quais serão os próximos passos, o que quero alcançar em 2022. Todo ano é assim, fico sempre animado com um ano novo que se inicia, cheio de possibilidades! Em 2020 fiz a primeira retrospectiva do blog, que você pode ler aqui, eContinuar lendo “Retrospectiva 2021”

Carregando…

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