Treinamentos

Do banco de dados relacional à tomada de decisão!

Propósito:

Quando trabalhamos com BI, enfrentamos cenários transacionais que precisam de respostas dinâmicas no qual os relatórios convencionais não possuem a agilidade/inteligência necessária para responder. A proposta deste treinamento é capacitar o aluno a transformar o ambiente relacional em uma modelagem de Data Warehouse (DW) para ser processado e cruzado no ambiente analítico. Entenderá quando criar uma tabela Dimensão ou tabela Fato e também como calcular as Medidas. Aprenderá a criar uma plataforma de tomada de decisão ao invéz de somente entregar relatórios convencionais. O aluno terá o conhecimento necessário para sair do ambiente transacional e a capacidade para desenhar a arquitetura do ambiente analítico propiciando aos tomadores de decisões montarem suas análises.

Próxima turma

Online: 04 a 08/02/2013 – das 19h as 22h
Presecial: N/A
In-Company: N/A

Público Alvo:

Profissionais de Banco de Dados, analistas de negócios, Tomadores de Decisões Tecnicos (TDM)

Duração:

Workshop de 16h ou Hand’s On de 24h.

Formato:

Online, presencial (Av. Paulista – próximo ao Metro Consolação) ou In-Company.



Valores:

Online: R$660,00 R$500,00
Presencial: A Definir
In-Company: A Negociar

Conteúdo:

  • Diferença entre BI e SQL
    • OLTP vs. OLAP
    • Normalização e Desnormalização
    • I/O no Disco
    • Conceito de SQL Server
    • Conceito de BI
    • Conceito de DW
    • Ferramentas
      • SSIS
      • SSAS
      • SSRS
  • Construção do DW
    • Tabelas Dimensões
    • Tabelas Fato
    • Primeira Carga – FULL
    • Cargas Incrementais
      • Higher Wather Mark
      • Change Data Capture
    • Column Store Index
  • Infra para o Ambiente
    • Edições do SQL Server
      • Standard
      • Business Intelligence
      • Enterprise
    • Produção de OLTP
    • STAGE
      • Dev e Homologação
    • Produção do DW
    • Produção do SSAS
  • Utilização do SSIS
    • Explicação da Ferramenta
    • Control Flow
    • Data Flow
    • DQS e MDS
    • JOBs
    • Processamentos
  • Utilização do SSAS
    • Explicação da Ferramenta
    • Criação do Cubo
      • Tabular
      • Multidimensional
    • Processamento Segmentado
    • Publicação do Cubo
    • Calculo de Measures
  • Utilização do SSRS
    • Explicação da Ferramenta
    • Criação de Relatórios
    • Gráficos e Mapas
    • KPI
    • Publicação de Relatórios
  • Sharepoint e outras ferramentas
    • PowerView
    • Power Pivot
    • Data Alert
    • BISM

Informações

Qualquer duvida sobre o curso, inclusive valores, mande um e-mail para nogare@outlook.com

77 thoughts on “Treinamentos

  1. I’m writing to make you understand of the awesome experience my cousin’s princess went through reading the blog. She learned several pieces, with the inclusion of what it is like to possess an ideal giving style to get the rest effortlessly understand selected hard to do topics. You undoubtedly exceeded my expected results. Thanks for supplying such important, trusted, revealing and even easy tips on your topic to Mary.

  2. A lot of thanks for all your effort on this web page. My daughter enjoys engaging in investigation and it’s really obvious why. All of us hear all concerning the powerful way you give helpful tricks by means of your web blog and therefore invigorate participation from visitors on the article plus my simple princess is always studying a great deal. Enjoy the rest of the new year. Your conducting a superb job.

  3. Thanks a lot for giving everyone remarkably superb chance to read from here. It is always so pleasant plus full of amusement for me and my office mates to visit the blog at minimum thrice every week to see the new items you have got. And indeed, we’re at all times satisfied with all the incredible information you serve. Selected 2 points on this page are undoubtedly the finest we have all ever had.

  4. A lot of thanks for all your valuable work on this web site. My aunt enjoys conducting investigations and it is obvious why. Many of us learn all regarding the powerful way you convey sensible tactics via the blog and even encourage contribution from others on that subject and my girl is without question understanding a lot. Take advantage of the remaining portion of the year. You’re conducting a very good job.

  5. I intended to compose you a tiny observation to say thanks yet again for your personal amazing methods you have contributed above. This is extremely generous of you to give openly exactly what a lot of people would have made available for an e-book to end up making some profit for themselves, especially since you could possibly have done it if you ever desired. The suggestions likewise served as the great way to comprehend many people have the same dreams the same as my own to understand very much more when it comes to this problem. I’m sure there are lots of more pleasurable instances up front for individuals that start reading your blog post.

  6. I must express appreciation to the writer for bailing me out of this particular instance. Just after researching throughout the online world and coming across thoughts that were not pleasant, I was thinking my life was gone. Existing minus the answers to the difficulties you have solved by means of your main review is a critical case, and those which might have badly damaged my career if I hadn’t come across the blog. Your talents and kindness in touching all the pieces was priceless. I’m not sure what I would’ve done if I had not come upon such a solution like this. I am able to at this moment look ahead to my future. Thanks for your time very much for the professional and effective guide. I won’t think twice to endorse the blog to any person who will need recommendations about this problem.

  7. Thanks so much for giving everyone such a brilliant possiblity to discover important secrets from this website. It is usually very amazing and stuffed with fun for me and my office friends to search your site at least three times in a week to learn the latest guides you have got. Of course, we are usually fascinated for the wonderful things you give. Some 3 points in this article are unequivocally the most suitable we’ve ever had.

  8. I am glad for writing to make you know what a fantastic encounter my wife’s daughter enjoyed reading through the blog. She even learned a lot of details, which include what it is like to have a marvelous teaching character to let most people just grasp several advanced topics. You really did more than our own expected results. Thanks for supplying these precious, healthy, edifying and in addition cool tips about this topic to Tanya.

  9. Thank you a lot for sharing this with all of us you actually realize what you are speaking about! Bookmarked. Kindly also discuss with my website =). We may have a hyperlink change agreement among us!

  10. You ave made some decent points there. I checked on the web to learn more about the issue and found most individuals will go along with your views on this website.

  11. I’m writing to make you know of the beneficial discovery my wife’s daughter gained using yuor web blog. She mastered a good number of things, with the inclusion of what it is like to possess an ideal teaching spirit to let many others very easily comprehend a number of impossible subject areas. You really exceeded people’s expectations. Thank you for providing those effective, safe, informative not to mention unique tips about the topic to Tanya.

  12. It seems like you are generating problems oneself by trying to remedy this concern instead of looking at why their can be a difficulty in the first place

  13. Terrific work! This is the type of information that should be shared around the web. Shame on the search engines for not positioning this post higher! Come on over and visit my website. Thanks =)

  14. Thanks a lot for providing individuals with remarkably memorable chance to discover important secrets from this web site. It is usually very great and jam-packed with a good time for me and my office peers to visit your web site really thrice in one week to see the new guidance you will have. And indeed, I’m actually astounded with all the amazing methods you give. Certain 1 tips on this page are indeed the best I have ever had.

  15. Very couple of internet sites that occur to become in depth below, from our point of view are undoubtedly well worth checking out.

  16. Loving the article.. thanks for your insight Value the admission you delivered.. My web searches seem complete.. thank you. of course, analysis is paying off.

  17. You made some decent points there. I checked on the internet to learn more about the issue and found most individuals

  18. Thank you so much for giving everyone an extremely remarkable chance to read in detail from this blog. It can be so pleasurable and also packed with a good time for me personally and my office colleagues to visit your site at minimum three times in 7 days to learn the new tips you have. Not to mention, I’m so actually happy for the gorgeous tactics you serve. Some 1 points in this article are basically the most effective we have had.

  19. Thank you for all your labor on this web page. My daughter loves participating in investigations and it is easy to see why. A lot of people know all of the compelling manner you provide important information via your blog and even strongly encourage response from some others on this subject while our own princess is really learning a lot of things. Take pleasure in the rest of the new year. Your carrying out a good job.

  20. You have mentioned very interesting details ! ps decent internet site. I didn at attend the funeral, but I sent a nice letter saying that I approved of it. by Mark Twain.

  21. I will immediately seize your rss as I can not find your e-mail subscription hyperlink or e-newsletter service. Do you have any? Please permit me realize in order that I may just subscribe. Thanks.

  22. Usually I don at read post on blogs, but I would like to say that this write-up very forced me to try and do so! Your writing taste has been amazed me. Thank you, very nice article.

Deixe uma resposta

O seu endereço de e-mail não será publicado.