Power BI

Power BI

9059 bookmarks
Newest
Customised Interactive Legends with Deneb in Power BI
Customised Interactive Legends with Deneb in Power BI
Legends are a necessary part of many visuals, and in this video we look at how you can fully customise your Legend using Deneb in Power BI, and set them up to include them interactive and functional features. Referenced documentation: https://vega.github.io/vega-lite/docs/legend.html
·m.youtube.com·
Customised Interactive Legends with Deneb in Power BI
Lazy, Streamed, Immutable: Try Building a Table
Lazy, Streamed, Immutable: Try Building a Table
Lazy evaluation, streaming and immutability are key Power Query concepts which must be understood to truly grasp how Power Query “thinks.” Want to test your understanding in these foundational areas—and try to grow it—by tackling an assignment?!Your TaskCode up a single row table containing the follo
tommypuglia·flip.it·
Lazy, Streamed, Immutable: Try Building a Table
Power BI and PowerPoint: A Powerful Combination for Data Visualization is now generally available
Power BI and PowerPoint: A Powerful Combination for Data Visualization is now generally available
We are happy to announce the general availability of Power BI integration with PowerPoint. This integration makes presentations more engaging and informative by allowing users to create rich, interactive visualizations that can be embedded in PowerPoint slides. The is now available also in national clouds. The integration has also added new features such as the ability to use a single visual, leverage Smart Insights to generate text that summarizes the data in the slide, and a “What’s new” banner to keep users informed of new capabilities.
tommypuglia·powerbi.microsoft.com·
Power BI and PowerPoint: A Powerful Combination for Data Visualization is now generally available
T-Mobile saves thousands of hours and achieves 12x gains in process efficiency with Power Platform
T-Mobile saves thousands of hours and achieves 12x gains in process efficiency with Power Platform
T-Mobile, one of the largest wireless carriers in the United States, has used Power Platform to save the company over $4M USD and 97,000 hours with a single Power Apps app. In addition, with Power Automate capabilities, they improved core process efficiencies by 12x while reducing errors from 7% to 0%.
tommypuglia·powerapps.microsoft.com·
T-Mobile saves thousands of hours and achieves 12x gains in process efficiency with Power Platform
Speed up Distinct Count calculations in Power BI using Aggregations - Phil Seamark on DAX
Speed up Distinct Count calculations in Power BI using Aggregations - Phil Seamark on DAX
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations
tommypuglia·dax.tips·
Speed up Distinct Count calculations in Power BI using Aggregations - Phil Seamark on DAX
Power BI Datamart – February 2023 Feature Summary
Power BI Datamart – February 2023 Feature Summary
Welcome to the February 2023 updates on Power BI Datamarts. This month, we’ve added a variety of new features based on your votes on ideas.powerbi.com. There’s more to explore, as well as a sneak peek of what’s coming soon, so please read on!
tommypuglia·powerbi.microsoft.com·
Power BI Datamart – February 2023 Feature Summary
Query parallelization helps to boost Power BI dataset performance in DirectQuery mode
Query parallelization helps to boost Power BI dataset performance in DirectQuery mode
We are excited to announce significant query processing improvements in the Power BI engine around query parallelization in DirectQuery mode, which can help to accelerate query response times, specifically for DAX and MDX expressions that generate multiple storage engine (SE) queries.
tommypuglia·powerbi.microsoft.com·
Query parallelization helps to boost Power BI dataset performance in DirectQuery mode
Getting Crazy with the Power Query UI - Guy in a Cube
Getting Crazy with the Power Query UI - Guy in a Cube
Using Merge statements? Alex shows you how that can break the fold in Power Query! He’s got you covered though and shows you a different way to approach it to make folding work! Using the UI! Alex Powers: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/
tommypuglia·guyinacube.com·
Getting Crazy with the Power Query UI - Guy in a Cube
The (Almost) Definitive Guide to Query Folding - It's Not About The Cell
The (Almost) Definitive Guide to Query Folding - It's Not About The Cell
There’s only one rule. Don’t break the fold! Before we start enforcing all these rules, we should start with something like a solid foundation of what does and doesn’t fold in Power Query and their SQL equivalents. Now, if you found this page and we’re like “what in the world is query folding?” read this […]
tommypuglia·itsnotaboutthecell.com·
The (Almost) Definitive Guide to Query Folding - It's Not About The Cell
Data Model Cleaner for Power BI and Analysis Services (SSAS)
Data Model Cleaner for Power BI and Analysis Services (SSAS)
Is your data model turning into an unfriendly monster full of unnecessary columns and measures with long refresh time? Or after cleaning up your data model, do you find that connected reports break so you manually go through each one to find the cause? In this post I will introduce you to the first version […]
tommypuglia·datamartin.ca·
Data Model Cleaner for Power BI and Analysis Services (SSAS)
Storyframing And Storyforming: Two Essential Steps That Precede Data Storytelling
Storyframing And Storyforming: Two Essential Steps That Precede Data Storytelling
Most of the focus on data storytelling is centered on the crafting and telling of data stories. However, to become a better data storyteller, it's important to recognize and understand the two essential steps that precede the telling of a data story--storyframing and storyforming. This article explores the roles that these two exploratory steps can play in identifying meaningful insights before they are crafted and shared as data stories.
but insights are much more elusive
automated dashboards is constantly refreshing, potential story points become moving targets
storyframing step to quickly generate useful observations
it can highlight results that are unusual or unique
n my experience, they are interwoven and iterative
Before you start any analysis to find insights, you must first have a good grasp of your audience’s needs, interests, and key questions
tommypuglia·effectivedatastorytelling.com·
Storyframing And Storyforming: Two Essential Steps That Precede Data Storytelling
Power Automate Natural Language and Approval Flows - Carl de Souza
Power Automate Natural Language and Approval Flows - Carl de Souza
In this post, we will look at a new preview feature in Power Automate, the ability to use natural language to create Power Automate flows, and also the ability to build approvals with Dataverse using Power Automate. The technology behind the natural language flow creation is OpenAI, a descendant of GPT-3, which also powers GitHub Co-Pilot and Power Apps Ideas. First, let’s go to Power Automate and click on Create, … Continue reading Power Automate Natural Language and Approval Flows
tommypuglia·carldesouza.com·
Power Automate Natural Language and Approval Flows - Carl de Souza
GitHub for Data Analyst and Power Platform Developers
GitHub for Data Analyst and Power Platform Developers
Shine Brighter Your project makes you shine but when properly documented and showcased, you shine brighter.   Power BI Data Analyst and Power Platform Developers can use GitHub too. Yes, You can! Leveraging GitHub for project documentation and showcasing is another way to get more value from your ...
tommypuglia·techcommunity.microsoft.com·
GitHub for Data Analyst and Power Platform Developers
Pipelines in Power Platform is Generally Available (GA)
Pipelines in Power Platform is Generally Available (GA)
We are pleased to announce that pipelines within Power Platform is generally available. Pipelines within Power Platform aim to democratize application lifecycle management (ALM) for Power Platform and Dynamics 365 customers by bringing deployment automation capabilities into the product in a manner that’s more approachable for all makers, admins, and developers.
tommypuglia·powerapps.microsoft.com·
Pipelines in Power Platform is Generally Available (GA)