Riccardo Perico
BI & Power BI Engineer @ Lucient Italia
Bergamo, Italy
Actions
Back in 2010 I began my career in IT.
After a brief stint as ERP Consultant, I transitioned into Data Realm.
Over the years, I explored the world of data from various perspectives, working both as a DBA and a BI Engineer.
I'm a Microsoft Certified Professional at different levels in databases, BI and Azure areas.
Microsoft MVP for Data Platform category from 2021 to 2024 and Microsoft Fabric Super User.
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 Global Power Platform Bootcamp stops in Italy.
You can find me speaking at Azure Saturday, SQL Saturday, Data Saturday, and other community events across Europe.
I served as a technical reviewer for the books “Extending Power BI with Python and R”, "Microsoft Power BI Quick Start Guide" and “Power BI Cookbook, 3rd Edition”.
Last but not least, Hard Rock and Heavy Metal addicted!
Awards
Area of Expertise
Topics
SQL Database Projects deep dive
In an Agile world with constantly changing scenarios and requirements, all of our software needs to adapt quickly, and DevOps tools are crucial for releasing reliable applications.
Databases are also applications, and the same principles should be applied to them.
If you work with SQL Server, DACPACs are your Swiss Army knife for DevOps. They allow you to put your databases under version control, speed up development with schema comparison, and simplify and automate deployments, even in the cloud.
No more altering, updating, inserting, or deleting directly in production with SSMS.
Power BI CICD, 2024 edition
In 2023, Microsoft released Power BI Projects (.pbip) with the aim of introducing native CICD support to Power BI.
One year later, the functionality is still in preview but has become much richer, thanks to the support for TMDL (Tabular Model Definition Language), which allows semantic model versioning in a human-readable format (YAML style).
Improvements have also been made from a layout perspective, introducing the Power BI Enhanced Report Format (PBIR), which facilitates versioning, "change tracking," and "two-face" editing in an easy and supported manner.
In this session, we'll see PBIP in action with TMDL and PBIR to explore the strengths and weaknesses of this powerful technology and how it's integrated in the Fabric ecosystem with git integration.
Deep Dive into Database Projects for Fabric Warehouse
Fabric is a team sport, and teams need tools to work better together.
SQL Database Projects are the Microsoft de-facto standard for authoring, building, debugging and publishing a database (even offline), and they supports Microsoft Fabric Warehouse as a destination.
Let's see how Database Projects and Fabric Warehouse work together, best practices, pitfalls and how you can insert DACPACs (Database project build outcome) into your DevOps pipeline.
Demystifying Power BI enhanced report format
The Power BI enhanced report format allows developer teams to version their reports from a visual perspective in an easier way.
Changes are more understandable and time-spending manual tasks can be addressed faster and with a "code-first" approach.
In this demo intensive session we'll see what's behind the scenes, how it works and how happy our developers could be having a real CI/CD for layout :-).
We won't forget to mention limitations also, since it's a preview feature.
Transitioning from Azure Data Factory to Data Factory in Fabric
Azure Data Factory had been the de-facto standard for ETL/ELT projects in Azure based data platform architecture for years. Now that Fabric has come do we need to learn everything from scratch? Data Factory is a workload in Fabric SaaS offer so we can leverage previous skills but we need to be aware of the differences between the two offers. As of now, ADF and Data Factory in Fabric are not the same thing. Let’s dig in.
Fabric: I love you, I love you not
On May '23 data professionals from all around the globe felt like a kid on Christmas day eager to unbox the new toy: Microsoft Fabric.
The new kid of the block generated a lot of reactions on the internet, and Fabric became the only topic to speak of.
Anyway, being a consultant obliges not to be overwhelmed by the hype and to study a product carefully in order to tailor solution on customer needs.
Moreover Fabric is not a tool it's an entire ecosystem.
Studying Fabric for more than one year, since private preview, I had the possibility to see aspects that I truly love (the concept of "The Great Unifier", Direct Lake, Shortcuts and more), but I also found things that I don't like and should be improved IMHO (few artifacts supported by CI/CD, different behaviors on Delta tables according to the workload, busting and smoothing like a black box and more).
In this session I'll try to show you many different aspects that I loved and I hated explaining pros and cons and how I would apply them in a real world scenario.
I won't expect participants to find answers in this session, I expect them to find the right questions :-).
Integrating Power BI with realtime API calls
Power BI natively supports external API calls, but what happens if your customer asks to ensure real-time interaction between a report and an API? Can we guarantee that a user can interact with an API without leaving a Power BI report?
In this session, we'll revisit a real customer use case, analyze all the different options we had, and explain why we discarded some of them. Finally, we'll reveal the working solution.
Spoiler: Something has been recently announced that could improve the working solution.
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.
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.
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.
Power BI & Fabric Summit 2025 Sessionize Event Upcoming
datasaturdays.com Pordenone 2025 Sessionize Event Upcoming
WPC 2024 Sessionize Event
Data Saturday Parma 2024 Sessionize Event
Power BI Ticino Conference 2024 Sessionize Event
1nn0va Saturday 2024 Sessionize Event
SQL Start! 2024 Sessionize Event
datasaturdays.com Pordenone 2024 Sessionize Event
WPC 2023 Sessionize Event
Data Saturday Parma 2023 Sessionize Event
SQL Start! 2023 Sessionize Event
Global Azure Torino 2023 Sessionize Event
datasaturdays.com Pordenone 2023 Sessionize Event
Global Power Platform Bootcamp 2023 | Milan Edition Sessionize Event
Data Saturday Parma 2022 Sessionize Event
WPC 2022 Sessionize Event
1nn0va Saturday 2022 Sessionize Event
SQL Start! 2022 Sessionize Event
datasaturdays.com Pordenone 2022 Sessionize Event
SQL Start! 2021 Sessionize Event
datasaturdays.com Pordenone 2021 #0001 Sessionize Event
Power Platform Bootcamp Milan 2020 Sessionize Event
Azure Saturday Pordenone 2019 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top