MSC Technology

Join us

BI Meetup

Agenda:

18,30 Welcome
19,00 Marco Russo (SQLBI)
19,50 Alberto Paruta (MSC Technology Italy)
20,15 Mattia Coluccia (MSC Technology Italy)
20,40 Q&A
21,00 Buffet & Networking

Sessions:

Marco Russo (SQLBI) - Optimizing DAX in Power BI: tools and techniques
Overview of the techniques and the tools (free and commercial) available to optimize the performance of DAX expressions in Power BI models. We will see what you can do with Performance Analyzer included in Power BI, how to extract query plans and statistical information with DAX Studio (free and open-source), and the results achievable with the DAX Optimizer service, which uses a revolutionary static analysis of the entire model.

Alberto Paruta (MSC Technology Italy) - Tabular parallel development using TFVC
We will illustrate the development process, version control strategy and CI/CD pipeline used in MSC BI for AAS Tabular models.

The main goals are to incentivize a collaborative approach, allowing multiple people to work simultaneously, and automate deployment and delivery steps.

Mattia Coluccia (MSC Technology Italy) - Dynamic Event Comparison
We will leverage a use case from the shipping industry to demonstrate a DAX pattern for events comparison. This approach allows us to single out an event and to benchmark it against a cluster of previous events with similar characteristics.

Speakers:

Marco Russo is a notable expert in the field of business intelligence and data analysis. He is renowned for his work in SQL Server Analysis Services (SSAS), Power BI, and DAX (Data Analysis Expressions). With extensive experience in teaching and consulting, he contributes to the dissemination of best practices in business data analysis. His industry expertise is recognized internationally, and he has authored numerous books and articles on topics related to business intelligence and data modeling. Moreover, he is frequently engaged as a speaker and trainer at conferences and workshops on these subjects. Marco Russo is regarded as a leading authority in the realm of business intelligence and data analysis.

Alberto Paruta
Business Intelligence Specialist with a robust background in ETL, Data Warehousing, and Advanced Analytics.

Currently enhancing data-driven strategies at MSC Mediterranean Shipping Company, Alberto has expertise in leveraging the Microsoft technology stack (SQL Server, AAS Tabular and PowerBI) to transform complex datasets into actionable insights.

Mattia Coluccia is an experienced Senior Business Intelligence Developer with a passion for turning data into valuable assets. He is currently involved in designing and maintaining BI solutions, actively mentoring younger team members, and advocating for Agile methodologies. His certifications include Microsoft DP-203, Microsoft PL-300, Databricks Associate Developer for Apache Spark 3.0, and Databricks Certified Data Engineer Associate.

Community:

The PBIUG Italy (Power BI User Group Italy) is a community of Business Intelligence professionals that come together to share knowledge, learning resources and best practices, with a strong focus on Power BI. They organize virtual events every two weeks on their social channels with guests from the Italian and international community, to foster continuous learning and improvement for their members. With close to 3000 followers on LinkedIn and a group of 250+ professionals connecting daily on Telegram, it's the place to be to grow both your skills and your network in the field of BI.

Torino Technologies Group is a local community, based in Turin but focused particularly on Piedmont, that provides opportunities for networking and exchanging experiences among those who develop solutions using Microsoft technologies (and beyond). The goal is to organize gatherings with a certain frequency.