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”
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)”
Data Vault Basics from Dan Linstedt
Data Vault Basics, by Dan Linstedt. The writing on this article reflects Data Valt’s creator, Dan Linstedt, view over its own creation. Data Vault Basics In order to properly create and apply data vault modeling one must know and understand your business well. It is very easy to convert from 3rd normal form and fromContinuar lendo “Data Vault Basics from Dan Linstedt”
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”
Data Warehouse ETL Toolkit – Chapter 03 – Part 1
Chapter 03 – Extracting Integrating all the different data sources are usually one of the biggest challenges the ETL team faces, and without data there is not data warehouse. In this chapter Kimball teach us how to interface with those various source systems, how to create your logical data map and how to deal withContinuar lendo “Data Warehouse ETL Toolkit – Chapter 03 – Part 1”
Data Warehouse ETL Toolkit – Chapter 02
Chapter 02 – ETL Data Structures In this chapter Kimball start once again talking about staging data, which he says that (sic) in this context staging means writing to disk. He also reminds us that they recommend 4 staging points, between each major steps of the ETLS (ECCD). This chapter focus on describing general designContinuar lendo “Data Warehouse ETL Toolkit – Chapter 02”
Data Warehouse ETL Toolkit – Chapter 01
Hello everyone, I’m trying to improve my english skills, so from now on I will try to in english write as much as possible. I’m also reading Kimballs’ and Casertas’ “The Data Warehouse ETL Toolkit”, and here I will post my chapters summaries. Hope it can help you like its helping me 🙂 — ChapterContinuar lendo “Data Warehouse ETL Toolkit – Chapter 01”
Somando Tipos Diferentes no SQL
Precisei fazer um relatóriozinho aqui no trabalho e confesso que bati a cabeça com esse problema que é bem simples de resolver, mas que só consegui com ajuda do meu grande amigo Nelsinho! Valeu irmão!!! Eu tinha uma tabela com uma lista de IDs e cada ID tinha um status, então eu precisava mostrar emContinuar lendo “Somando Tipos Diferentes no SQL”
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”
Power BI DAX Total Acumulado Mês Anterior
No post passado sobre total acumulado (esse post aqui), falei sobre como podemos criar totais acumulados em DAX e um comentário nesse post perguntava o seguinte: Deixa eu ver se entendi o que ele quer dizer… Então ele fala que fez uma função similar levando em consideração o mês, ok, no código dele tem ALLSELECTED()Continuar lendo “Power BI DAX Total Acumulado Mês Anterior”
Power BI DAX Calculate Evaluation Order
Comecei a fazer uns testes simples com DAX e Calculate pra entender exatamente, passo a passo, como o DAX e a CALCULATE() funcionam. Para esse exercício vamos considerar o seguinte cenário: Perceba que temos: uma tabela fato chamada mini uma dimensão chamada dim_dish relacionamento 1:N entre dimensão e fato X, um visual de tabela comContinuar lendo “Power BI DAX Calculate Evaluation Order”
Carregando…
Ocorreu um erro. Atualize a página e/ou tente novamente.