Turning 445 Summary Tables into Usable Calendar Tables in Power BI
If you’re used to working in Excel you’re quite familiar with the idea that there’s about a dozen ways to do anything. In this video we look at yet another
Transform siloed data into actionable intelligence. Skypoint’s AI Platform accelerates data-centric AI initiatives for healthcare, so you see results in weeks, not months.
Quickly access quality data, business intelligence, analytics, and automation through Skypoint’s industry-tailored platform infrastructure.
Our secure AI Platform for regulated industries helps you unify your data, uncover insights, and optimize productivity.
Learn AI and BI strategies and techniques from our data solutions experts.
Our team of AI and BI experts helps healthcare, public sector, and financial services organizations solve operational inefficiencies and enhance productivity through unified data and industry-specific compound AI systems.
Stay up to date with the latest healthcare data & AI blogs, thought leadership, and resources.
If you’re used to working in Excel you’re quite familiar with the idea that there’s about a dozen ways to do anything. In this video we look at yet another
The art of visualization layout is a tricky one. Once you start throwing more than one or two charts onto a page it can start to turn into a tricky-to-navigate
Relative Month and Year columns in calendar tables are indispensable. They let you create simple, easy to read time intelligence measures that don’t require recoding at the end of each
(AKA “Pleased to Meet You, I Hope You Guess My CSVs Name.”) This is based on a question that floated into my inbox this week. If you’re combining a folder
Month label columns are invaluable for things like slicers and report axis. When users see 9 then don’t immediately get that you’re talking about September, but put a “Sep” on
List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary,
Say a customer wants a line chart with a sales line, a 3 month moving avg, a 6 month moving avg, a 12 month moving average, and a same period
Many organizations, particularly in the retail and manufacturing industries, use a 445 calendar. If yours is such an organization, then you need to “roll your own” (in terms of DAX
Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom,
Most people are aware that Power Query lets you work with tables that have columns containing other “inner” tables. The classic example is a table representing an Excel workbook where
Skypoint is a HITRUST r2 certified data unification and agentic AI platform that accelerates productivity and efficiency for healthcare organizations.