Articles
VIDEO: Creating the Calendar Table in Power BI
We recommend using the Calendar function: TableName = Calendar ([Start Date], [End Date]). If you don’t know the start and...
Read More
VIDEO: Cleaning and Formatting Sales Tables in Power Query
Upon importing the sales table to the Power Query editor, users can rely on functions, such as trim and format...
Read More 
With Updates to Power BI, Microsoft Raises the Bar in Self-Service Analytics
During the Business Applications Summit (MBAS), Microsoft showed it is working to build its own eco-system to create a full...
Read More
VIDEO: Clean and Transform Financial Data in Power Query
Watch our short video to see how you can quickly transform financial data into a proper database format for further...
Read More 
Smart Narratives in Power BI to Help Reporting
Power BI introduced the smart narratives feature that allows users to add and tailor dynamic and interactive narratives to reports.
Read More
VIDEO: Why and When Merge Queries in Power Query
When merging tables in Power BI, you are joining them side-by-side using a matching column. Watch our video to learn...
Read More 
Power BI Dashboard Helps Companies Check on Remote Employees
With businesses around the world adapting to the remote work environment during the COVID-19 pandemic, Microsoft came up with a...
Read More
VIDEO: Append Multiple Excel Files From One Folder
When a new month report comes out, many still use a manual method by copying and pasting the new month...
Read More
VIDEO: Using Power BI Relationships Instead of Excel VLOOKUP
The Power BI data modeling feature allows users to connect a bunch of tables from different sources together using a...
Read More Let's discuss your strategy
If these issues sound familiar, the underlying problem is usually structural. We help organisations turn fragmented planning and reporting processes into coherent steering systems.