Speaker

Riccardo Perico

Riccardo Perico

BI & Power BI Engineer @ Lucient | Microsoft Data Platform MVP

Bergamo, Italy

Back in 2010 I started working in Information Technology.
After a brief experience as ERP Consultant, I moved into Data Realm.

I spent these years exploring Data world from different points of view, both as DBA and Business Intelligence Engineer.

I'm a Microsoft Certified Professional (MCP), Microsoft Data Analyst Associate, Microsoft Technology Associate (MTA), Microsoft Certified Solution Associate (MCSA) in database, BI and Azure areas.

Microsoft MVP for Data Platform category.

I'm one of the leaders of Power BI User Group in Italy and I'd been speaker during the Power Platform World Tour and Power Platform Bootcamp stops in Italy.

I'm also speaker during Azure Saturday, SQL Saturday and Data Saturday events in Europe.

Last but not least, Hard Rock and Heavy Metal addicted!

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • Azure
  • Microsoft Power BI
  • Microsoft SQL Server
  • Azure Synapse Analytics
  • Azure Data Factory
  • Azure SQL

Better database design with Local Development Experience for Azure SQL

Database development it's been always an overseen task.

How many times did you see CREATEs, ALTERs, INSERTs, UPDATEs etc. performed manually over production databases to perform a deploy?
How many times did new object version released on the wrong server?

Sometimes it's not developers' fault, a development server and database aren't always available but, many times, laziness and wrong approach win against a structured approach to database desing and deploy.

Whatever situation is, with Local Development Experience for Azure SQL you can run an emulation for Azure SQL directly on your laptop that allows to build database projects without breaking existing databases and to inject database design in structured DevOps CICD pipelines.

In this session we'll learn what Local Development Experience for Azure SQL really is, we'll see its pros and cons and we'll put it in a real CICD approach orchestrated by Azure DevOps.

Houston, We have a P…ower BI Report, cronache di un report dal mondo reale

Power BI è indiscutibilmente il tool di reportistica più in voga degli ultimi anni. Uno dei suoi punti forti è sicuramente la facilità con cui è possibile costruire modelli e report.
Sulla carta anche le integrazioni con il mondo esterno sono supportate out of the box, ma la realizzazione si complica? E se sì, di quanto?
In questi 60 minuti ripercorriamo le disavventure di cui può essere lastricata la realizzazione di un report di questo tipo in un caso tratto dal mondo reale.

Power BI dataflows deep dive

Power BI dataflows allow to centralize and to standardize data preparation phase using Power Query and M language in the cloud, without leaving your browser.

In which scenarios are they suitable?
Which best practices do you need to keep in mind?
Which is the new frontier they're drawing?

Let's try to answer these and other questions with practical examples.

On-Premises Data Gateway monitoring strategy, why do I care?

You have carefully prepared your fantastic reports with Power BI Desktop and the time has come to share them with your colleagues. Obviously you don’t want to simply show the visuals frozen at the release state, but you want the underlying dataset to be refreshable so that the data visuals show up-to-date information. Therefore, after publishing the report on Power BI Service, you will certainly take care to install and configure an On-premises Data Gateway in Enterprise mode on a machine from which the data source is reachable, so that you can schedule a dataset refresh appropriately.

Whenever you are dealing with a Data Gateway no matter how powerful your sources and Power BI capacity are, the Gateway is a crucial part of your architecture and you should be ready to react if problems arise.

During this session we'll see how to establish monitoring and troubleshooting strategy accordingly leveraging default logging and building a comprehensive solution.

PBIRS for dummies

360° overview of Power BI Report Server looking to the "on-prem version of Power BI".
Let's see how to install and configure it and let's take also a look to the engine and how it works behind the scenes.
In the end we will compare PBIRS and Power BI Service in order to do the best choice when designing our Power BI ecosystem.

An introduction to Azure Data Factory

Azure Data Factory v2 è un servizio di integrazione dati nel cloud flessibile, scalabile, sicuro.

Grazie ad un'intuitiva interfaccia visuale ed a più di 60 connettori nativi creare, pianificare e gestire attività di trasferimento dati non è mai stato così immediato, sia che essi si trovino nel cloud oppure on-premise.
Il nuovo Integration Runtime, inoltre, consente di trasferire con semplicità i propri pacchetti SQL Server Integration Services (SSIS) in Azure.

In questa sessione vedremo alcune delle possibilità offerte dalla piattoforma ed i servizi con cui essa si integra nativamente.

PBI modeling at warp speed with Tabular Editor Advanced Scripting

Well designed model is core aspect for any successful BI project regardless the technology you are using.
Microsoft oriented BI solutions tend to use SSAS Tabular, Azure Analsysis Services and Power BI nowadays, and Microsoft provides its own tools to develop solutions for these products.

Designing model according to best practices and following standards is a must but sometimes could be an annoying and long process due to some lack in functionalities of the standard tools, because of this new "Community's Tools" born and they're used more and more.

Since 2020 Power BI is embracing "External Tools" to make developers' life easier, one of them is Tabular Editor.
During this session we'll se how to leverage "Advanced Scripting" feature in order to create model at the speed of light always following best practices and making BI development agile.

Explain me Azure Data Platform services in 60 minutes

If you're a seasoned data professional very used to on-premises environments, or if you're a junior approaching Azure for the first time, it could be hard to find the right Azure services to use in our projects.

During this session we'll try to give a 360 overview of available services for data management, comparing them, explaining overlapping and describing pros and cons for Azure Data Platform services.

We'll talk about storage services, data engineering services, SQL Server provisioning options etc.

At the end of the session it'll be easier to approach Azure for what concerns Data and architecture creation/estimation will be much more simple.

Working in the (Azure Data) Factory the right way

Azure Data Factory is a fully managed, serverless data integration service.

It's super easy to start developing powerful pipelines to move data in and out cloud and on-premises services, but there're many features that could be useful to get the best out this tool that you may not be aware off.

This, full of demo session, is a collection of lessons learnt and tip and tricks collected implementing real world scenarios in Azure Data Factory.

Riccardo Perico

BI & Power BI Engineer @ Lucient | Microsoft Data Platform MVP

Bergamo, Italy