reports

With Power BI integration and lineage we are embarking on a journey to the world of BI solutions and their representation in Collibra, which will empower organizations to make better data-driven decisions.

Today, as data has become a lifeblood of industry leading firms, competing on analytics has become an unquestioned mantra, and firms have anointed Chief Data Officers to occupy the C-Suite.

At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and business-impactful insight to the users. I'd like to share this with you! This is based on Power BI, so I'll talk about DAX and Power BI report design, but it could be adapted to any tool. Using the Adventure Works sample database I created a couple of examples. It reads like a DevOps User Story, which is good as it switches to being busines-driven over data-driven. Some of ou

Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos. - powerbi-desktop-samples/README.md at main · microsoft/powerbi-desktop-s...

Contribute to KornAlexander/PBI-Tools development by creating an account on GitHub.

Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Reports for Power BI and Dataverse. - GitHub - mscottsewell/Power-BI-D365-Sales: Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Re...

This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

Have you ever wished Power BI knew the optimal number of periods to show? It is possible with my Smart Axis Magic :) ! Here is how to improve UX by creating a smart date axis that automatically picks the optimal calendar period based on the timeframe. In this step-by-step explanation we dive deeper into field parameters, data modeling, and DAX. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles *See improved solution in the download files, where you don't need the bridge table and can use a between date slicer -------------------------------- 📊 TRAININGS 📊 --------------------------------- New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly support@datatraining.io --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 01:43 Step 1 - Creating a field parameter with periods 03:23 Step 2 - Creating a helper table 07:17 Step 3 - Creating the relationships 09:14 Step 4 - Applying a TopN filter 10:14 Demo - smart date axis 10:55 Finishing touch - Dynamic title 13:40 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Facebook: https://www.facebook.com/groups/howtopowerbi LinkedIn: https://www.linkedin.com/company/datatraining-io Insta: https://www.instagram.com/howtopowerbi/ Twitter: https://twitter.com/HowToPowerBI --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://a.co/69HEjRu 📚 Power BI books MUST READ! https://a.co/5q5k6Dv 💡 General books I recommend https://a.co/05I4W2L 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://a.co/4V5CUJN * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Quick Tip:Are you OCD like me?Wish you could align your tables in the model view but there are no alignment tools?1. Select the tables you want to align.2. Click on the lowest aligned table and smash it into the ceiling.3. Click and drag another table back down.#PowerBI pic.twitter.com/pV3ooZSJG1— Kim Preece (@KNPBI) November 3, 2022

Probably one of the most annoying things about creating bookmarks is... updating them! However, there is a trick that will make your life so much easier and the process a lot faster. And the trick is... GROUP YOUR VISUALS and always select the option "SELECTED VISUALS" when creating your bookmark Let me get into the details now... The steps you need to do for this technique are: Group the visuals/shapes in your report (create kind of reporting areas) Using the Selection Pane, select the grou

This session will teach campers how to use the new SDK support to initiate an embedded Quick Create session which allows the user to dynamically build a new dataset and report on the fly.

In this post, we look at how to create our own SQL Database and fill it with data from the Contoso Data Generator, so we can get some hands-on Power BI experience.

Blogging about Power BI, Power Platform and other things I find interesting.

How does the Optimize ribbon, with Pause visuals, Refresh visuals, Optimization presets, and Performance analyzer, as well as Edit relationships in the properties pane work to streamline your authoring experience? Here are some scenarios they can help you with! 1. Make changes to an existing DirectQuery report without running queries until you are ready 2. Create new visuals without running a query until you are ready 3. Create measures in a DirectQuery model without the visuals refreshing until you are ready 4. Quickly edit relationships between DirectQuery tables 5. Quickly learn about and apply query reduction settings to your DirectQuery report 6. Adjust the query reduction settings to the level you need in your DirectQuery report 7. Quickly revert to the full interactivity after a data source change in your report

Step-by-step guide! Thrive to enhance user experience by adding any of the three different visual user guides to the Power BI report.

The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...]Read More »

Smart date axis with Field parameters

Recently, I’ve published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and u…

The ultimate snapshot report shows the latest snapshot while showing the evolution at the same time. It's easy to select a previous snapshot and more.

Here's the rough draft of a few key paragraphs from The Art of Insight : I respect but also disagree with the Tuftean and Bertinian function...

Is your data issue a business intelligence problem... or a change management issue? Can you distinguish these perspectives, or is it differing views on the same thing

What mistakes Power BI / data visualization beginners, who learned (a bit of) a BI tool from a YouTube video, make? They have no idea … Read More

Field parameters allow the report designer to switch the content of a visual with ease. This feature allows the report consumers to interact with data without needing to create their reports

Analyzing data is much like the natural world in many ways. For example, if we walk around a forest, we see the trees towering over the ground.

Can you spot the difference between the following two report pages? Yeah, neither do I! But, there is a huuuuuge difference between those two reports! What if I tell you that the report on the right is 5x faster than the one on the left? Would you believe me? No? Then keep reading and I will show yo

Hi everyone! Quick method to save a bit of report space by using shorter names for date granularity selection within the slicers 🔎🔎 Following example... 14 comments on LinkedIn

Here's a quick post on how to add audio or video to your Power BI report. In general, media should be used sparingly, and I cannot emphasis that enough. Let your data do the talking. If you are convin…