Data Perspective in Power BI
Data Perspective in Power BI In this era, where we have a strong need to understand the data around; it is essential to have a skill where one can turn data into a story and explain it using the right tools, which can be well received by the audience. In this session I will take you on a journey where we will try to find insights in the data by visualising it using Microsoft Power BI and then further turn this data into a story that is easy to understand by the audience. Topics: • Importing a public data in Power BI • Overview of the data in Power Query to see the distributions • Creating visuals using the data to get strong evidence of the insights we derive in the data • Summarising & visualising data at different granularities to create rich insights • Create Drill through to the data points and understand the data better • Best practices around choosing the right visuals • Tips and tricks around communicating a story to your audience • Best practices around choosing the theme colours • Bes practices around creating consistency/uniformity in your report • In the end, demonstrating a ready interactive Power BI report that has a story to be explained Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Pragati Jain: Pragati has been recently awarded with Microsoft Most Valuable Professional award (MVP) under Data Platform category. Currently, she is working as a Senior Consultant at Avanade in UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London. She is skilled in various tools and technologies like Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure Databricks Pyspark and SQL. She has been using Power BI for few years now and started participating on Power BI Community from last few months where she is one of the community Superusers. Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting. This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat.
HampshirePowerBIUserGroup - 14th June - Power BI Pipelines, Dataflows
This is the meetup for the VIRTUAL event. << link provided shortly before the event >> Registration will open two weeks before the event VIRTUAL - SotonDataCloud - 14th June - Power BI Pipelines, Dataflows, Wed, Jun 14, 2023, 6:00 PM | Meetup Wednesday, May 31, 2023 6:00 PM Agenda (UK time) 18:00: Welcome and Intros 18:00: Odeta Jankaitienė - From Development to Production: The Benefits of Power BI Deployment Pipelines 18:30: Marthe Moengen - Power BI Dataflows - why should you care? 19:30: Rosie Djurovic - Powering Up Dataverse and Power BI with Azure Functions 20:00: Finish Session details: 1. Odeta Jankaitienė - From Development to Production: The Benefits of Power BI Deployment Pipelines In this session, Odeta will present the creation and usage of Power BI deployment pipelines for the seamless transition of Power BI solutions from development to production environments. Attendees will learn how deployment pipelines help to streamline and automate the deployment process, reduce errors, and improve collaboration between developers and end users. Odeta will also provide real-world examples of how organizations have leveraged Power BI deployment pipelines to accelerate business intelligence initiatives, increase agility, and improve overall operational efficiency. By the end of the presentation, attendees will have a comprehensive understanding of the benefits of Power BI deployment pipelines and how to implement them within their organizations. 2. Marthe Moengen - Power BI Dataflows - why should you care? Power BI Service is providing new solutions and ways to solve challenges. One of those features is Power BI Dataflows. So what is that, and why should you care? In this session, we will take a look at the Power BI Service-specific feature dataflows, and dig into how dataflows can improve the performance of how you consume, create and share business insights. What is the difference between dataflows and Power Query, how can you use dataflows to enable non-technical report developers and are there any AI features you can take advantage of? 3. Rosie Djurovic - Powering Up Dataverse and Power BI with Azure Functions Azure Functions give you the power to extend the capabilities of Dataverse and Power BI using code (you choose the language!) In this session I'll talk about how and why I use Azure Functions to run Python in the cloud. I'll demo - How to setup your Azure Function - Retrieve data from Dataverse - Trigger Power BI refresh This session will be ideal for beginners who have never used Azure Functions or experienced users who are interested in learning about other use cases. About Odeta Jankaitienė I have been working as a data analyst for 10 years and teaching others how to use SQL, Power BI, and R. I am passionate about data and sharing my knowledge with others. About Marthe Moengen 26-year-old digitalization geek from Oslo enjoying the sweet spot between analyst and developer. About Rosie Djurovic I am a BI Developer with experience of developing solutions using the Microsoft Power Platform, Power BI, Python and SQL. I am hugely grateful to the Data and BI community and hope that by sharing my experiences I can help others who are on similar journeys.
Microsoft Fabric + Power Platform + Azure Open AI = Magic Mix
Intro to a use case to understand how to leverage a new PowerApps with Copilot land the data into Dataverse and pick it up from Microsoft Fabric to enable a LakeHouse and via DirectLake stream analytics with Power BI. Real use case scenarios to share on this session. The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm. Join our Meetup: https://www.meetup.com/madison-power-bi/ ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then the 2nd exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutate
Incremental Refresh with Dataverse
Hi!! Im wrtiting today in order to know if Incremental refresh works with Dataverse? The issue is because ive been trying to apply incremental refresh to some .xlsx files inside a sgarepoint folder without success. So before giving to my customers the option of taking the data into an SQL Database, I was wondering if they can do it through connecting the sharepoint to the dataverse and then apply the Incremental Refresh to the Dataverse as a source. Haven´t found any info about it and dont really know how to dataverse works so if you can help me it will be a big help. Thanks & Regards
Paginated Reports and dataverse global opition set data
How do you get the global option set data and opition set data in datavese when using the dataverse connection in Report Builder for PowerBI? The only solution I can come up with so far is to create a dataset for every single option set and then do a lookup in an expression whenever any data contains the the optionset value to get the localized label. Please remeber this is about Report Builder, not power apps or PowerBI. If you don't know anyting about dataverse or Report Builder please don't answer.
Power Automate Flow Button to a Power BI report from another environment
From Power BI, I am trying to use Flow to update a table from Environment B within Dataverse. My Default environment is Environment A. Is it possible to change environments in Power BI to create a flow within Environment B or is it possible to use an "Update a Row" and select the environment? The current "Update a Row" in Dataverse option only shows tables from environment A (see image).
