SQLSaturday#546 Porto 2016
SQLSaturday#546 Porto 2016
No dia 1 de Outubro realiza-se de novo o maior evento de tecnologia no Porto.
Este ano ainda com mais sessões, mais oradores nacionais/internacionais, são quatro tracks com temas diversos que cobrem na totalidade a maioria das novas ferramentas pertencentes a plataforma de dados da Microsoft. O melhor disto tudo, é que o evento é completamente gratuito…!
O evento principal é precedido por 2 dias de Masterclasses (quinta-feira 29 de Setembro 2016 | sexta-feira 30 de Setembro 2016) com 3 oradores nacionais de topo, sendo dos melhores especialistas nas suas respetivas áreas:
PRE-CONFERENCE MASTERCLASSES
Implementing Modern BI Solutions
The main objective of this workshop, is to share real world experience implementing a BI solution, starting from the basic concepts until real problems that is not written and explained in the books. The tools used in this workshop are SQL Server (SSIS, SSAS and SSRS), Excel and Power BI in the latest versions. At the end, the beginner attendees should be prepared to create a BI solution from the scratch, and more advanced attendees should be prepared to improve existent BI solutions.
(b) Understand the best practices to follow on the key steps
(c) Know tips & tricks from real world scenarios experience
Overview
- Share several BI real word solutions
- Dimensional Modeling techniques
Data Integration
-
- ETL overview through SSIS
-
- SSIS framework to create dynamism to process
- Data quality
Data Exploration
- Data Exploration through cubes
- Understand the differences between multidimensional and tabular cubes in practice
- Create most often used calculations in MDX and DAX
Data Visualization
- Create interactive reports through Power BI
- Understand the Power BI architecture
- Another perspective to visualize data through Excel
SQL Server Database Administrators
BI Professionals / Developers
Basic knowledge about PowerBI & Microsoft Data Platform
Bring your own Device
Pedro was born in 1977 in Portugal and currently works as BI Senior Consultant and Invited Lecture in several BI master degrees. He’s also founder and owner of a BI company named “Culto de BI”. He received in 2010, 2011 and 2012 the Microsoft MVP award for all the dedication and contribution helping theoretical and practical issues in the various BI communities. He’s also co-author and editor of several books from Packtpub and Syncfusion.
SQL Server Professional Configuration & Optimisation Workshop

(a) Sharing the SQL Server Installation & Configuration Best Practices from over 25 years of combined Database Experiences
(b) Introduction to the RapidConfig Script that allows you to configure your instances
(c) Easy Performance Optimisation Technics guide
Twitter: @NikoNeugebauer
About André Batista