Category: Power BI

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/ingest-healthcare-open-data-into-azure-and-power-bi-using-new-github-repository/2278523 Numerous Government agencies make Healthcare Open Data available to the public at no cost. Data from the CDC, CMS, FDA, World Bank, US Census, USDA and many others provide rich sources of valuable data. These vast sources of robust and useful data…

  • This tutorial review the process to add existing M scripts (could be from Power BI or Excel Power Query) to DataFlows.

  • This video walks through a quick demo of Power BI Q&A for Natural Language Queries running over Azure Synapse.

  • This video walks through a quick demo of the Power BI Decomposition Tree running over Azure Synapse.

  • This video walks through a quick demo of Power BI Small Multiples (Trellis Chart) running over Azure Synapse:

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/updated-end-to-end-azure-synapse-and-power-bi-cms-medicare-part-d-solution/2145136 Back in December I worked with a colleague from the Azure team, Kunal Jain, to release an end-to-end Azure Synapse and Power BI solution using real CMS Medicare Part D data. The solution can be deployed with a few clicks in Azure…

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/deploy-an-end-to-end-azure-synapse-analytics-and-power-bi-solution-using-cms-med/1940720 For many people, hands-on experience is often the best way to learn and evaluate data tools. I’ve been working with a colleague from our Azure team, Kunal Jain, to put together an end-to-end Azure Synapse and Power BI solution using 120+ million…

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/use-power-automate-with-azure-sql-db-to-trigger-a-power-bi-import-dataset-refres/1348614 Power BI Import Datasets are simple to build and highly performant. Power BI literally imports and compresses an optimized cache of reporting data. Most of the time, Power BI architects will schedule their Import Datasets to refresh on a schedule. Sometimes the…

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/combine-azure-synapse-and-power-bi-rls-to-analyze-aggregated-data-while-controll/1332312 Let’s start this article off with a simple summary of the use case: Consider the diagram below. A User can see aggregated data for all Specialties, but only two States. When the User drills to detail, they can only see detail data containing PII…

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/track-the-covid-19-growth-curve-in-power-bi/1234137 COVID-19 has rapidly become a world-changer. While the world’s Healthcare professionals prepare for the unknown, many of us are seeking useful news and updates. Recently, The Center for Systems Science and Engineering (CSSE) at Johns Hopkins University released a COVID-19 Dashboard that…