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