João Marcelino
DevScope, BI Specialist | Data & AI Solutions
Porto, Portugal
I began my career in the business and financial world.
Now I live and breathe IT and data: modelling, analysis, dashboards and visualizations.
I am passionate about knocking down data with Microsoft tools and the way Power BI helps us problem-solving and improve inefficiencies.
I love spreading the word about Power BI and recently became Super User in the Power BI community.
Links
Area of Expertise
Topics
Turbocharged Insights: Harnessing Direct Lake in Power BI with Microsoft Fabric
In the landscape of data analytics, the ability to swiftly access and analyze large datasets is critical. This session goes deep into the power of Microsoft Fabric as a robust foundation for data engineering and analytics.
We'll kick off with a theoretical exploration, explaining how data is stored and managed within Microsoft Fabric and Onelake. This foundational knowledge will set the stage for the practical demonstrations that follow.
During the session, we will build an end-to-end flow as we import a substantial volume of data using a streamlined ETL process. Once loaded into a lakehouse, the spotlight will shift to Power BI. Here, we'll showcase the Direct Lake mode, a feature that allows users to tap into vast datasets with remarkable speed and efficiency, ensuring almost real-time insights without the typical lag.
Ascend and Influence: How to Leave a Lasting Mark in the Data Community
Embarking on a journey to establish a presence in the data community can be both exciting and daunting. In this session, join three data professionals as they unfold their stories, share the highs and lows of their journeys, and impart invaluable wisdom for aspiring influencers in the field.
Discover the personal challenges they faced, the fears they overcame, and the strategies they employed to make out their own niches in the data world. From building networks to showcasing expertise, they will delve into the practical aspects of making a mark, providing a roadmap for those at the start of their journey.
Whether you are a data enthusiast or a seasoned professional seeking to expand your influence, this session is designed to equip you with the insights and tools needed to ascend in the data community.
Don’t miss this opportunity to learn from the experiences of those who have navigated the path and start paving your own way to influence and recognition in the data community.
Unleashing Productivity: Empowering Workflows with Power Query
Introduction to Power Query: A brief overview of what Power Query is and how it fits into the Microsoft ecosystem.
Streamlining Data Acquisition: Exploring how Power Query simplifies the process of importing data from various sources, including databases, websites, and files.
Data Transformation Made Easy: Demonstrating the power of Power Query in transforming and shaping data to meet specific requirements, such as filtering, merging, and pivoting.
Data Cleaning and Error Handling: Highlighting the robust capabilities of Power Query in cleaning and handling errors within data sets, including removing duplicates, handling missing values, correcting inconsistencies and data compression.
Automating Data Refresh: Discussing the automation features of Power Query, allowing for seamless data refreshing and updating without manual intervention.
Combining Multiple Data Sources: Showcasing how Power Query enables the combination of data from different sources, facilitating comprehensive analysis and reporting.
Working with Complex Data Structures: Explaining how Power Query simplifies working with complex data structures, such as nested tables, JSON, and XML, enabling efficient data extraction and manipulation.
Creating Custom Functions: Illustrating the ability to create custom functions in Power Query, which can be reused across multiple data sets, enhancing productivity and maintaining consistency.
Power Query and Data Modeling: Exploring the integration of Power Query as a catalyst of modeling capabilities, empowering further advanced analysis and visualization.
Collaboration and Sharing: Discussing how Power Query promotes collaboration and sharing by allowing users to create reusable queries and how the usage of parameters fosters a culture of efficiency and productivity.
Power Up Skills with Power BI
This is a complete training session for the audience to start their journey with Microsoft Power BI. In the end of the training, the audience will leave the room with a fully functional Power BI report created using a real-world dataset.
Agenda:
1. Introduction to Business Intelligence
2. Introduction to Power BI
• This will include going through the Power BI eco-system – Power BI Desktop & Power BI service
3. Data Cleaning
• Import data to Power BI
• Exploring Data profiling options
• Learn about basic transformations in Power Query editor
• Basics to Advance Editor
• Best practises around naming the transformations & data-types
• Custom Columns creation – scratch or by examples
• Date table creation
• Quiz
4. Data Modelling basics
• Creating basic relationship
• Understanding the cardinality
• Hide/view capabilities
• Best practises around Comments & Naming conventions
• Quiz
5. DAX basics
• Measures vs columns
• Quick measures
• Basic DAX functions
• Date table using DAX
• Quiz
6. Data Visualisations
• Introduction to the page canvas, background & settings
• Visuals in Power BI
• Custom visuals
• What visuals to use when
• Analytics feature in visuals
• Conditional formatting in visuals
• Best practises around layout of visuals in a report
• Usage of buttons/bookmarks to create interactive reporting
• Drill down, drill up & drill throughs capabilities
• Colour schemes and themes in Power BI
• Creating a brand specific custom theme
• Quiz
7. Power BI report from scratch in Power BI Desktop
• By using all the learning above, a Power BI report will be created from scratch
8. Power BI Service
• Basics of Power BI Service
• Creating your first workspace
• Publish & share your first report
• Quiz
9. Introduction to Gateways
• Installing personal gateway
• Configuring gateway in Power BI Service
• Quiz
10. Summary
11. Q&A Time
Getting started with Power BI: 10 steps (+1)
Power BI is one of the most amazing tools from Microsoft Power platforms environment. It's easy to start, you just need to know how and way to unleash it's power!
From Excel to Power BI: the journey that shapeshifted my career
Power BI is one of the most amazing tools from Microsoft Power platforms environment. It's easy to start and might change your life!
João Marcelino
DevScope, BI Specialist | Data & AI Solutions
Porto, Portugal
Links
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