Direct Lake in Fabric: The next step in Semantic Models after Import and Direct Query

Fabric brought new features to the Power BI world and one of the main changes is on the storage mode. Until now users could use Import mode and Direct Query, both options with their pros and cons, for those that wanted a little bit more they could use Composite Models to get the best of both worlds, but that added a level of complexity in modelling.

With this innovative approach to the data, Fabric brings the Direct Lake approach to semantic models and changes the way we access data in Power BI.
In this session we will investigate Direct Lake mode and understand the main concepts alongside the main differences with the other available options for connectivity. We will also investigate what are the requirements for using this new modelling option, and the current limitations.

Direct Lake in Fabric: Advancing Semantic Models Beyond Import and Direct Query

Fabric brought new features to the Power BI world and one of the main changes is on the storage mode. Until now users could use Import mode and Direct Query, both options with their pros and cons, for those that wanted a little bit more they could use Composite Models to get the best of both worlds, but that added a level of complexity in modelling.

With this innovative approach to the data, Fabric brings the Direct Lake approach to semantic models and changes the way we access data in Power BI.
In this session we will investigate Direct Lake mode and understand the main concepts alongside the main differences with the other available options for connectivity. We will also investigate what are the requirements for using this new modelling option, and the current limitations.

Navigating DAX complexity: how to make it easier for Power BI developers

Besides the love for data there is one thing that brings together Power BI developers the "fear" of DAX. The complexity around the filter, row and query context always turns people head around, in fact the catch phrase DAX is simple but no easy is always on everyone's mind when the discussion starts about calculations.

Is there a way make DAX easier?
Can we find a straightforward way of writing complex DAX functions?

In this session we will show you how the new functions on DAX and Power BI functionalities allow you to facilitate DAX writing.

Let us look at how the Running Totals, Moving Average, Previous Rows and Next Rows among others, can make a shift from long and complex calculation into a few lines of code or at least easier to read.

Demystifying Power BI Developer Mode for Business User

The new Power BI Developer Mode changes dataset and report development, providing a faster, more accessible approach. This mode includes source control and seamless integration with DevOps and Fabric, making it an impressive tool for advanced users and IT professionals.

However, the good news is that you don't need to be a full-time developer or have an extensive IT background to benefit from this feature. In this session, I will demonstrate how you can take advantage of Developer Mode without the need for advanced integrations like DevOps and Fabric.

I will showcase how this option enables you to:
- Perform actions like renaming, sorting, duplicating, and deleting report pages.
- Seamlessly copy and paste entire pages between reports.
- Update your dataset with new calculations and queries.
- Create or modify table Model Views.
- Manage bookmarks through renaming and deleting.
- Duplicate visualizations effortlessly.
- And much more.

Join me to discover how you can enhance your reports and datasets without even opening Power BI Desktop.

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.

Power BI Developer Mode - Is it for me?

The new developer mode in Power BI allows the development of datasets and reports in an easier and fast way, it includes source control and full integration with DevOps and Fabric.

This is impressive however for users that are not advanced users and proficient in the technical terms this seems to be only for full time developer or IT background users.

In this session I will show how you can leverage the use of the Developer mode even if you do not go to the advanced capabilities with the integration of DevOps and Fabric.

I will highlight, the use of this option for you to achieve:
• Start collaborating with developer mode.
• Renaming, sorting, duplicating, and deleting pages from your report
• Copy+paste entire pages from one report to the other.
• Update your dataset by creating new calculations or queries within your dataset.
• Create or update table Model Views
• Renaming/Deleting Bookmarks
• Duplicating visualizations
• Other things

Join me and see how you can update your reports and/or datasets “without opening” Power BI Desktop.

Take off with Dataflows Gen 2

One of the best know features of Power BI service now has an updated version, Dataflows Gen 2, but do you know exactly what they are and if you should use them?

Although with a look and feel experience that we know and love, The new generation of Dataflows brings important updates to the Dataflow experience.

In this session we will do a walkthrough on the main differences between both generations of Dataflows, what the advantages, a demo on creating and using Gen 2 and how we can migrate from Gen 1 to Gen2.

Come and find out how to take advantage of Dataflows and keep your disconnect data fully compatible with the Fabric and Power BI Experience.

From Takeoff to Touchdown: Navigating End-to-End Power BI Development in the Cloud

When it comes to development in Power BI, Power BI Desktop has been a go to tool for all the Power BI developers for the last few years.
But have you ever thought, with the improvements coming to Power BI product in the last few years; you can now actually think of developing your complete Power BI solution in Power BI Service.

So you think you can develop in Power BI? Let's see in this training how to step away from Power BI Desktop app and jump into a 100% cloud solution.

In this workshop we will showcase an end-to-end Power BI solution using the new/updated online Power BI Service capabilities.

The training will start from connecting to data-sources, doing some transformations on the ingested data, creating a tabular model on top of which creating DAX calculations. Finally developing and sharing a full report on the Power BI service.

The training will also focus on concepts like Dataflows Gen2, transforming data using Databricks notebooks, data model optimization by connecting model to external tools and yes we will cover more Microsoft Fabric capabilities.

At the end of the training, users will have a fully fledged end-to-end Power BI solution in Power BI Service without touching the Power BI Desktop.

Do you have a Mac, a Linux or a windows computer? Don't worry any more.

We welcome all the users to our training. No more boundaries can restrict Power BI development based on what operating system or machine you use.

Are you ready to see a different approach to building your Power BI Solutions?
Take this smooth take-off to embark on an exciting journey to Power BI development the cloud way! 😊

From Excel to Power BI: the journey that shapeshifted our careers V2

Have you ever wondered what would happen to your life if you decide to go in a different direction?

Everyday we have to take decisions, some of them have little impact on your life, however some of them are life changing.

Join us on the Journey that shapeshift our careers from working in finance area and being Excel users to full time Power BI developers and content delivery users.

Get to know the challenges, decisions, options, that took us to the current. Let us take you on the path to career change and how you can have a new perspective on life.

Power BI is one of the most amazing tools from Microsoft Power platforms environment. It's easy to start and might change your life!

Power BI Calculation Groups - SELECTED functions to know

The use of calculation groups allows the increase of flexibility without the need to rewrite code, on this session we will do a quick tour on 4 functions that are used to create calculation groups.
Learn on the SELECTEDMEASURE (), ISSELECTEDMEASURE(), SELECTEDMEASURENAME (), and SELECTEDMEASUREFORMATSTRING() are used in the creation of calculation groups and can help improve your DAX syntax.

In this session we will learn how the use of calculation groups can increase the flexibility of your reports but also allow the shifting of the user experience.

Power BI Developer Mode - Non technical

The new developer mode in Power BI allows the development of datasets and reports in an easier and fast way, it includes source control and full integration with DevOps and Fabric.

This is impressive however for users that are not advanced users and proficient in the technical terms this seems to be only for full time developer or IT background users.

In this session I will show how you can leverage the use of the Developer mode even if you do not go to the advanced capabilities with the integration of DevOps and Fabric.

I will highlight, the use of this option for you to achieve:
• Start collaborating with developer mode.
• Renaming, sorting, duplicating, and deleting pages from your report
• Copy+paste entire pages from one report to the other.
• Update your dataset by creating new calculations or queries within your dataset.
• Create or update table Model Views
• Renaming/Deleting Bookmarks
• Duplicating visualizations
• Other things
Join me and see how you can update your reports and/or datasets “without opening” Power BI Desktop.

How Power BI change my life: the journey that shapeshifted my career

When we first started working with Power BI we could not image how this tool would impact our future life, not only professional but also personally.

Join us in remembering the steps that we gave to be a part of an amazing community around the world. Let's start by looking on how we were working, before Power BI, what was the mind change we needed to do when this tool started to be a part of our day to day.
Learn how our first steps on the Power BI community allows us to get more engaged and turn our experience into discussions, presentations that allows us to share some of the knowledge we everyday get from the interactions with people all around the world.

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

Power Query - Going Back to Basics

Although we all love to do complex things in Power Query sometimes it is nice to go back to basics and refresh our knowledge on the concepts and helpful parts of the M Language. In this session we will be showing what are values and expressions, how to debug our code and some few tricks on Power Query.

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!

Bidirectional model with DAX formulas

Turning on the filter on the relationship to be bidirectional can create a lot of problems on calculations however sometimes is needed.

On this session we will see how we can have bidirectional filtering but keeping our model relationships intact.

DAX common questions and how to tackle them

The usage around Power BI brings a lot of doubts, especially when talking about DAX we get to the conclusion that DAX is simple, but it is not easy. In the community, every day there are new questions however some are recurrent, and in this session, we will talk about some of the most common questions in the community and how we can solve them.

Conditional formatting - tips and tricks

Conditional formatting can be used to highlight our stories however sometimes it's a tedious road to get the final result.

In this session I will show some tips and tricks how we can make take advantage of conditional formatting but with a easy setup approach.

Think inside the box

Power BI allows to add custom visualizations to make storytelling really interesting, however that may come at some price, that may vary from performance to losses of support over time.
In this session we will show how we can create some custom visualizations using the standard visualizations.

DAX common questions and how to tackle them

The usage around Power BI brings a lot of doubts, especially when talking about DAX we get to the conclusion that DAX is simple, but it is not easy. In the community, every day there are new questions however some are recurrent, and in this session, we will talk about some of the most common questions in the community and how we can solve them.

PowerBI, What is it & How to leverage it?

Most BI solutions out there are expensive and take a lot of technical expertise, with a self-service tool Microsoft Power BI closes the gap between data and decision making, allowing for users to create their own reports with an easy and low cost option.

In this session we will take a first approach to what is Microsoft Power BI and it's several uses and show how we can have a quick start on the tool without the need of big investments or technical expertise.

If you want to perform the workshop demo on your side, here are the pre-requisites you need to have ready :
* Power BI Desktop (Version: 2.87.762.0 64-bit (November 2020)
- Microsoft Store - Search Power BI Desktop
- Download from link: https://www.microsoft.com/en-us/download/details.aspx?id=58494
* Financial Sample Excel Workbook
- Download from link: https://docs.microsoft.com/en-us/power-bi/create-reports/sample-financial-download

Combine the Power of Power BI with External Tools

While developing in Power BI, there are some tasks that are time consuming. From the creation of metrics to the deployment of models the usage of Power BI can be optimized using external tools.

In this session we will take a look into some external tools and how they can help us take our development skills to another level.
DAX Studio: How can we check the performance of our data model, or return the result of a DAX query.

ALM Toolkit: How to compare, update and deploy models.
Tabular Editor: How to automate the creation of metrics, changes measures and columns properties in a bulk or tweak some advanced metadata in our model
Power BI Helper: How to see where a specific metric or column is used, create documentation automatically.

This session is for intermediate users that already know their way into Power BI but want to increase their development skills and speed.