NEW - Google Analytics Report (GA4)
Provides a detailed report built off Google Analytics data. Allowing for a deep dive analysis on page views, user statistics, event counts, sessions and engagement, conversions, top pages visited, traffic source trends over time, and more.
This detailed report makes use of all the latest and greatest Power BI features such as: Field Parameters, SVG charts for Matrix tables, dynamic format strings, new KPI cards and button slicers, and more!
If you would like to try out the report before downloading this customizable file. You can test the online only version in the Microsoft AppSource store here. This version can be refreshed, however the data model, Power Query applied steps, and DAX cannot be edited.
Uber User Data Report
Provides a detailed report built off your downloaded Uber user data. Allowing for a detailed analysis of your Uber rides and Uber eats deliveries. The report includes two pages of various visuals focused on your user data: such as date and time information, geo location details, and dynamic metric selection for most visuals.
To use this report you must first download the user data from your Uber account. It can take up to 30 days for them to export your data, but commonly is within a week. Detailed instructions on how to download your user data be found here. Instructions for connecting your user data to the Power BI report is included on the first page of the report, which can be viewed by accessing the embedded report below.
Spotify User Data Report
Provides a detailed report built off your downloaded Spotify user data. Allowing for a detailed analysis of your streaming history, saved album information, and created playlist details. The report includes two pages of various visuals focused on your user data, plus hyperlinks to track, artist, and album info on Spotify.
To use this report you must first download the user data from your Spotify account. It can take up to 30 days for them to export your data, but commonly is within a week. Detailed instructions on how to download your user data can be found here. Instructions for connecting your user data to the Power BI report is included on the first page of the report, which can be viewed by accessing the embedded report below.
Dynamics 365 Opportunity Revenue Report
Provides a detailed report built off your Dynamics 365 opportunity data. Allowing for a detailed analysis of opportunity history, top performing accounts, best selling products, and revenue performance.
To attach your downloaded user data in this template app. You'll need to obtain your root Dynamics CRM URL. Information on how to do that can be found on our Instructions Page.
Company Dashboard Template
The beauty of Power BI is that each report page is a blank canvas when it comes to authoring, design, and aesthetics. This template provides a creative perspective on how to present summarized information by category, with the ability to drill down on categories to show additional metrics and KPI’s.
Four detail perspectives are included in this template, each with their own unique layouts and visuals. Our Power BI template provides you with ideas for: report tooltips, bookmarks, buttons, conditional formatting, and visual layering.
This report is not built off a common dataset, rather it is designed to be disassembled for (or take inspiration from) its various visuals, elements, and report techniques to be used in other reports.
Extracting Report-Level Measures Template
This template (PBIT) provides a report that will connect to any local (PBIX) file that is using a live connection, and extract any report-level measures from that file. Report-level-measures are measures added to the local PBIX file, measures from the live connected model will not be extracted. Live connections include (PBIX) files connected to: SQL Server Analysis Services (SSAS) models, Azure Analysis Services (AAS) models, and Power BI Shared Datasets.
This report provides a summary table of extracted DAX measures that include the name, expression, and other measure properties and attributes. Video tutorial can be watched here.
PBI Report Template With Custom Calendar
Power BI report templates are amazing as starter reports. They can be built with or without data sets. Design practices such as a slicer pop-out window, standardized calendar, company logo, visualization arrangement, background, formatting, and more.
Our Power BI template provides you with ideas for a standardized layout, default visualization settings, DAX Measures table, color theme, and a custom calendar.
PBI Report Template (Dark Mode) With Custom Calendar
Our standard Power BI Report template, but with a dark mode toggle added. Allowing for user flexibility to choose either mode at any time. Design practices such as a slicer pop-out window, standardized calendar, company logo, visualization arrangement, background, formatting, and more.
Our Power BI template provides you with ideas for a standardized layout, default visualization settings, DAX Measures table, color theme, and a custom calendar.
Custom Calendar Table With Time Intelligence
We've created an amazing custom calendar table in Power BI that incorporates fiscal and intelligent time dimension columns. It includes easy ways to filter by rolling periods of various time dimensions as granular as day and up to year. It also includes Offset columns for Days, Weeks, Months, Quarters, and Years.
Each offset column is a numerical column that starts as 0 for the current time period (E.g. Current Day, Month, etc...). Any rows for a time period in the past is then assigned with a negative number (E.g. -1, -2, etc...), and time periods in the future are assigned a positive number (E.g. 1, 2, etc...).
This logic allows for easy filtering for relative time windows. DAX Measures can also utilize these columns for easier time intelligence calculations as well. The table also includes Parameters that allow the client to easily choose the calendar start and stop date ranges and the fiscal year start date when creating the table.
KPI Scorecard Report
Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Even the best data model can lose value when it is not paired with good report design.
This report lays out a grid of DAX measures across rows and columns in a card-like fashion. It leverages native and custom visuals, DAX calculations, and some design wizardry to build out a quality Power BI scorecard template to use for your business.
KPI Scorecard Report (With Switch Measure)
This version of the KPI Scorecard Report also includes a Slicer that lets you toggle the entire Scorecard between Amount and Quantity.
Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Even the best data model can lose value when it is not paired with good report design.
This report lays out a grid of DAX measures across rows and columns in a card-like fashion. It leverages native and custom visuals, DAX calculations, and some design wizardry to build out a quality Power BI scorecard template to use for your business.
Budget and Forecast Vs. Actuals Report
This report provides a good perspective on common financial comparisons for companies. Comparing Actuals against Budget and Forecast. Both native and custom visuals are utilized in this report to display the variances in an effective way.
The What If Scenario feature in Power BI is also utilized to allow easy adjustments of the Budget and Forecast values for quick analysis.
Performance Analyzer Report
Provides a detailed report built off the Performance Analyzer data that is exported from Power BI Desktop. The Performance Analyzer captures operations that occur while a user interacts with a report. This report summarizes those operations so users can see detailed information about each visual. Additionally, it includes the underlying performance events for all user operations.
Report operations are broken down into three primary categories: Report Canvas, Data Shape Engine (DSE), and Data Model Engine (AS). More details about these operations can be found in the report.
Consulting & Training
We provide many consulting services related to Power BI reporting or Fabric Platform development. Including everything from Data Acquisition with Power Query, Data Modeling, or Visualization & Design.
Our services range from customized co-development, to structured training depending on the client's needs.
Videos & Articles
We also have numerous videos, articles, and other content we publish multiple times a month on various media platforms.
Many of these articles showcase great practices, techniques, or other important information related to Power BI or the Fabric Platform.