Eliminate manual entry and replace a proliferation of off-line spreadsheets and documentation when you connect a bank account in Business Central. Does your organization rely on manual processes for payments, cash receipts, and bank account reconciliation? Manual processing apart from the accounts receivable and accounts payable systems is not only inefficient and error prone, but […]
Now more than ever, leaders of small and midsize businesses (SMBs) need to ensure their people are enabled to deliver on customer expectations, no matter where they are or what comes next. Microsoft Dynamics 365 Business Central is a comprehensive business management solution that helps small and midsize companies connect their finance, sales, service, and […]
Creating a Power BI data model from a flat file source hosted on SharePoint or Azure Data Lake Store can be cumbersome. I recently found this out trying to create a simple data model for a demo, which involved files sized over 3 gigabytes. Every time I performed a transformation in Power Query and hit Close […]
Welcome to the second blog of my two-part blog series on Enhancing KPI indicators and visuals in Power BI. As a recap, Part 1 focused on displaying a green ‘up’ or a red ‘down’ arrow indicator for our KPI card visualization based on a pre-defined threshold. Another common request by business users is the ability to see at-a-glance […]
In the September 2018 release of Power BI Desktop, Microsoft introduced a new game-changing feature in the world of data analytics: “Aggregations”. I feel that Aggregations will provide much flexibility when it comes to handling large data sets in Power BI. With this new feature, users can define detail-level and aggregate-level information separately and Power BI […]
On the surface, Power BI might seem like a simple reporting tool offering a set of common visuals and capabilities to transform data into insights. But once you start exploring the tool, you will find that it’s the magic wand to unlock those amazing reporting features every business has been looking for. All you need […]
As part of Fortude’s weekly “tech talk” series, Madushan Dahanayake, Associate Consultant – BI at Fortude, took Fortudites on a fascinating journey deep into the world of machine learning. What is machine learning? Machine Learning is the use of algorithms to find patterns in data. It then uses those patterns to predict the future on […]
Obviously, T-SQL and DAX are two different query languages and they serve entirely different purposes. However, as someone from a database development background, when I learnt DAX initially, I started thinking SQL and tried to achieve the same thing from DAX. The reason for that thinking process is that it is always easy to learn something new when we […]
It was only a matter of time till the complete Microsoft on-premise Business Intelligence stack was moved to the Azure Paas service. With the introduction of Azure Data Factory (ADF) back in 2015 and the recent launch of ADF V2, which is in public preview for the moment, it is now possible to orchestrate complex […]
As a business analyst, what exactly should we know to be able to convert the requirements of end users into Power BI reports? What should we learn to be good at using Power BI? These were questions directed at me by two business analysts (BA) at a recent meetup. They were getting into Power BI […]