Pedro Reis
Microsoft Data Platform (MVP), Microsoft Certified Trainer (MCT)
Porto, Portugal
Pedro is passionate about Leading Teams and turning data, technology, and people together into value.
During the last 15 years, Pedro has managed multiple teams in Banking, Supply Chain, and Operations, and also planned and coordinated the construction and migration of thousands of Reports to Power BI, SSRS, and other BI tools.
Data Platform MVP, Microsoft Certified Trainer and Co-Founder and Leader of the Power BI Portugal Meetup group
Links
Area of Expertise
Topics
Power BI for Kids
Let's build together your very first report! We will use animated visuals that will be a lot of fun, while showing you how to use data to make decisions.
Functions & Parameters in Power BI
In this session, I will teach you how to create a parameter and a function in Power BI, so that you can recursively do things like getting data from Web pages, handling data from entire folders and much more.
Top 10 Power BI Features for Managers
As a Manager, besides having the right reports at the right time, it's important to take advantage of it's entire analytical power and many of the hidden gems of Power BI.
During this session you will learn the top 10 Power BI features you take advantage of as a Manager
Introduction to DAX
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI.
In this session, you will learn how you can set up the foundation to learn DAX, write DAX Queries, test your code and share it with other people.
All this on the Browser, no need for any installation!
From non IT to MVP in 6 years - The story of a career change
During this session, I will tell you my story. How I changed career and decided to step into IT, and the steps I took to improve myself as a professional and eventually become MVP.
From Power BI to PowerPoint Presentation - Done in 5 seconds!
PowerBI Reports are widely used across organizations, but when it comes to preparing executive presentations it's still common to see someone taking screenshots from reports to PowerPoint.
With the new PPT / PBI Integration not anymore! In this session I will show you:
- How to seamlessly integrate PowerBI Reports into PowerPoint
- Preparing your report for the perfect integration
- How to save snapshots of your reports into PowerPoint or refresh your entire PPT
Power BI Metrics - How to track and manage goals in your organization
During this session, you will see a complete Demo of Power BI Metrics.
I will quickly walk you through the basics and deep dive into technical and report-building considerations for leveraging Metrics.
This session is fully updated with the most recent releases. I will also discuss current limitations and the roadmap.
Authoring Datasets in Power BI Service
Since December 2022, Power BI allows users to perform modeling operations in the Power BI Service. In this session, we will cover some of the operations that are enabled such as the ability to add new measures or columns to an existing dataset, edit the format strings, and edit the RLS of the model.
We will cover what is already possible in the service compared to the desktop and analyze the pros and cons of using one or the other.
"DAX" for SQL guy
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI.
If you know SQL, I'll show you how similar DAX can be, and how you can quickly understand the foundation of DAX, write DAX Queries, test your code and share it with others.
All this on the Browser, no need for any installation!
5 Fascinating principles to get things done
In this session, I'll show you 5 principles that might be holding you back from getting things done.
Warning: Just by knowing these you might be able to relate to previous situations, recognize them and start taking action, making yourself more confident, productive, and happier.
Getting Started with Power BI
In this session, you will quickly learn the key features of Power BI, from no data and a blank Report, up to a beautiful published Report and Dashboard in the cloud. All this in 5 simple steps!
Some of the things you will learn:
- Importing data from Excel and from a SQL Server Database
- Enriching your report with DAX time intelligence, Artificial Intelligence Insights, Maps and much more
- Reusing elements from other Power BI reports
- Difference between Power BI Free and Pro
- Publishing a report to the cloud
- Creating a Dashboard from your report
- Best Resources to continue learning about Power BI
"DAX" the way to do it
Love it or hate it, you just can't ignore DAX, the amazing language of Power BI. In this session, I'll show you it's true power and how knowing it can even make you completely rethink your data models.
No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core.
I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
From Power BI to Excel - The best of two worlds
Power BI is "the" tool of the moment. But did you know that once you have Power BI Data in the cloud, you can also Analyze it in Excel? I'll show you how to do it and why.
This session will help:
- A business user who wants to have flexibility in analyzing Power BI Datasets in Excel, and learn more how to leverage both together
- An IT professional who wants to provide the best options in his model and governance for the user from the datasets he manages
In a glance, I'll show you:
- How to connect from Excel to the Data Model stored in a Power BI cloud dataset
- Which are the reasons for doing so
- Things you can do in Excel which you cannot do in Power BI
- How to do some amazing things with formulas connected to the cube by using MDX, named ranges and much more!
- How to publish charts and other elements from Excel to Power BI in the Cloud
Global Power Platform Bootcamp 2023 - Mumbai India Edition
#PBIMCR September - Power BI Goals
Power BI Scorecards session at Manchester User Group
Data Platform VIrtual Summit 2022
Session presented: Power BI Goals: The Ultimate Piece for Top Management - Pedro Reis
Agenda: https://dataplatformgeeks.com/dps2022/sessions-agenda-schedule/
Global Azure Lüdinghausen 2022
Power Platform Zaragoza 2022
Data Saturday Portugal 2021
BizApps LATAM Summit
Porto.Data #68
"DAX" for SQL guy by Pedro Reis & Susana Sousa
Global Azure 2021-India
Global Azure Lüdinghausen 2021
Global Power Platform Bootcamp Paris
SQL Saturday 1010
DAX Session
SQL Saturday 1018
DAX Session
SQL Saturday 997
DAX Session
Power BI Portugal Meetup #20
"DAX" The way to do it
Porto.Data #56
Power BI - Great Custom Visuals + DAX = Amazing Reports!
Power Platform World Tour Munich
2 Sessions + Panel
Porto.Data #55
From Power BI to Excel: the best of the two Worlds
SQL Saturday 925
DAX Session
Power BI Portugal Meetup #10
From Excel to Power BI and Back
Power BI Portugal Meetup #6
Getting Started with Power BI
Pedro Reis
Microsoft Data Platform (MVP), Microsoft Certified Trainer (MCT)
Porto, Portugal