EESTEC LC Athens @ two-day workshop under the theme "Data Warehousing and Business Intelligence"


EESTEC LC Athens in co-operation with Accenture Greece (https://www.accenture.com/gr-en/) organizes an exclusive two-day workshop under the theme "Data Warehousing and Business Intelligence" which is about SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Tabular Modeling and Power BI.

Agenda

DAY 1 (November 9, 2017)

Introduction

○ Accenture Presentation

○ Who we are (presenting ourselves)

○ What we do (business areas, projects)

○ How we do (technical tools overview, work methodology/ADM)

Technical Overview – Data warehousing

○ Data warehousing concept (Theory, design approaches, best practices)

○ ETL Methodology (Data Integration, topologies, ETL vs E-LT)

○ Business Intelligence (Front-end, reporting and visualization)

Workshop Data Integration (ETL Methodology)

○ Overview

○ Setting-up our project/workspace

SQL Server Integration Services (SSIS)

• Visual Studio and SSDT (SQL Server Data Tools)

○ Create Integration Services Project

• Developing SSIS Packages

○ SSIS Packages Data Stream (Approaches and best practices)

○ SSIS control and data flow

○ Working with different data sources

○ Working with data transformations

○ Working with different data destinations

○ Handling errors and alternatives flows

○ Putting all together

Deliverable overview (Day 1 work)

DAY 2 (November 10, 2017)

Day 1 Recap

Business Intelligence (Theory)

○ Essentials of Business Intelligence

○ Multi – dimensional modeling

○ Data Mining

Workshop Tabular Modeling in SSAS

• Working with Tabular Model

○ Building a Tabular Model

○ Working in diagram view

○ Deploying a tabular Model

○Querying Tabular Models

• Working with Power BI

○ Querying tabular models with Power BI Desktop

○ Building Power BI report

○ Interacting with Power BI reports

Advanced Topics

○ DAX Language (Theory & Exercise)

○ Tuning Tabular Models

Deliverable overview (Day 2 work)

Final discussion & References overview

-----------------------------------------------------------------

Presented by: Accenture Greece

There will be given Participation Certificates!

Register now: https://goo.gl/forms/ID7AnoDf4GKRq6Mq2

Deadline for applying: 3/11/17.

More information here: https://goo.gl/ChpLhx