Ignorar navegação principal
Eventbrite
Pesquisar eventos
Organizar um evento
Ajuda
Iniciar sessãoRegistar
Menu
Conteúdos da página
Este evento terminou.

Painel de Ações

out 16

SSAS Basics by Régis Baccaro

Por Tuga Association

Quando e onde

Data e hora

quinta, 16 de outubro de 2014, 09:00 – 17:00 WEST

Localização

Rumos - Porto Edifício D. Henrique Rua do Bolhão, 221 B, 1º 4000-112 Porto Portugal

Mapa e direções

Como chegar lá

Política de reembolsos

Entre em contato com o organizador para solicitar um reembolso.

Descrição

Abstract

SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.
Cubes are multi-dimensional data sources, which have dimensions and facts (also known as measures) as its basic constituents. From a relational perspective, dimensions are like master tables and facts measureable details. These details are generally stored in a pre-aggregated proprietary format and users can analyze huge amounts of data and slice this data by dimensions very easily. Multi-dimensional expression (MDX) is the query language used to query a cube, in the same way T-SQL is used to query a table in SQL Server.

This session will give you an understanding of the basics of OLAP development from the eyes of an OLTP practitioner.


Attendee’s pre-requisites/profile

Prerequisite:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Profile:

  • Want to become a BI professional and want to understand the full depth and breadth of Microsoft’s approach to BI
  • Already working in a BI environment and you want help solving challenges in your job right now.
  • Has worked in BI before, using tools from other companies or previous versions of Microsoft’s BI technology, and want to learn what Analysis Services and related products bring to the table.

Contents

  • Prerequisite
  • High level cube development process
  • Difference between OLAP and OLTP - What is a multidimensional model
  • Data source creation
  • Data source views
  • Cube creation
  • Dimension fundamentals
  • Dimension Hierarchies
  • Dimension attribute relationships
  • Dimension storage
  • Dimension discretization
  • Parent/Child dimension hierarchies
  • Star and snowflake schemas
  • Creating calculated measures and named sets using MDX
  • Cubes Security
  • Deploying and processing cubes
  • Browsing cubes for Analysis
  • Consuming Multidimensional models

About Régis

Régis is a Senior Consultant working with databases and administrations since 1999.

He has been working with Business Intelligence since SQL Server 2000 and with SharePoint since 2003.

He specializes in mentoring, performance tuning and scalable architecture of datawarehouses and bi-solutions.

His background and work experience mixes technology and business, providing him a unique edge to contribute to datawarehouse and SharePoint projects, being able to effectively interact with technical and business decision makers.

Régis is a frequent speakers at SQL Server conferences and is a board member of the Danish SQL Server User Group and the founder of the SQL Saturday Denmark community event.

Required/Suggested Materials and Software

A working installation of SQL Server 2012 (at least SP1)/2014, SQL Server Analysis Services 2012 (at least SP1)/2014 in Multidimensional mode, Visual Studio 2012 or more, Excel 2013.

Either on a physical or a virtual machine.

Etiquetas

  • Eventos em Portugal
  • Eventos em Porto
  • Coisas para fazer em Santo Ildefonso
  • Aulas em Santo Ildefonso
  • Aulas de Ciência e Tecnologia em Santo Ildefonso
Evento finalizado

SSAS Basics by Régis Baccaro


Siga este organizador para se manter informado sobre os próximos eventos

Tuga Association

Criador do evento

Eventos que você pode gostar

  • Roadshow Amazon Web Services - Porto

    Roadshow Amazon Web Services - Porto
    Roadshow Amazon Web Services - Porto

    Qua, fev 15, 10:30
    Palácio da Bolsa • Porto
    Gratuito
  • [Open Day] Come visit our campus in Porto

    [Open Day] Come visit our campus in Porto
    [Open Day] Come visit our campus in Porto

    Qua, fev 15, 14:00
    Le Wagon Porto Coding Bootcamp • Matosinhos
    Gratuito
  • Women's Coding Brunch [Porto] | Intro to Javascript

    Women's Coding Brunch [Porto] | Intro to Javascript
    Women's Coding Brunch [Porto] | Intro to Javascript

    Sáb, fev 18, 10:00
    Le Wagon Porto Coding Bootcamp • Matosinhos
    Gratuito
  • SEI'23 - Semana da Engenharia Informática

    SEI'23 - Semana da Engenharia Informática
    SEI'23 - Semana da Engenharia Informática

    Ter, fev 14, 21:00
    Universidade do Minho • Braga
    Gratuito
  • Tratar o cancro por tu - Braga

    Tratar o cancro por tu - Braga
    Tratar o cancro por tu - Braga

    Qui, fev 9, 18:30
    Auditório do Centro de Juventude de Braga • Braga
    Gratuito
  • Frontend  Conference - "Frontend Festival Porto 2023"

    Frontend Conference - "Frontend Festival Porto 2023"
    Frontend Conference - "Frontend Festival Porto 2023"

    Sáb, abr 22, 09:00
    4050-430 • Porto
    45 € - 75 €
  • Tomorrow Needs You  - Dias do Emprego da Escola de Engenharia UMinho 2023

    Tomorrow Needs You - Dias do Emprego da Escola de Engenharia UMinho 2023
    Tomorrow Needs You - Dias do Emprego da Escola de Engenharia UMinho 2023

    Ter, fev 28, 09:00
    Universidade do Minho • Guimarães
    Gratuito
  • PRODEI Symposium

    PRODEI Symposium
    PRODEI Symposium

    Qua, fev 8, 09:00
    Faculty of Engineering - University of Porto • Porto
    Gratuito
  • HPC ADMINTECH 2O23 · Oporto

    HPC ADMINTECH 2O23 · Oporto
    HPC ADMINTECH 2O23 · Oporto

    Qua, mai 31, 11:00
    TRYP Porto Expo Hotel • Matosinhos
    Gratuito
  • iTechStyle Summit  +  ETP Annual Conference 2023

    iTechStyle Summit + ETP Annual Conference 2023
    iTechStyle Summit + ETP Annual Conference 2023

    Qua, mai 10, 09:00
    Porto Cruise Terminal • Matosinhos
    50 € - 150 €

Navegação no website

Utilizar a Eventbrite

  • Como funciona
  • Quanto Custa

Planejar eventos

  • Inscrições Online
  • Musica
  • Cursos & Workshops

Procurar eventos

  • Pesquisar eventos: Porto
  • Obter a aplicação Eventbrite

Ligue-se a nós

  • Denunciar este evento
  • Centro de Ajuda
  • Termos
  • Privacidade
  • Acessibilidade
  • Diretrizes da comunidade
Eventbrite + Ticketfly

© 2023 Eventbrite