Microsoft Dynamics AX is an enterprise resource planning (ERP) solution that helps enterprises increase the speed of doing business. Last week at the Dynamics AX Technical Conference, we were excited to announce the availability of two Dynamics AX 7 content packs for Power BI: Financial Performance and Retail Channel Performance. The Financial Performance content pack, designed specifically for CFOs, provides access to insights about your organization’s financial performance. The Retail Channel Performance content pack is for channel managers who focus on sales performance to predict trends and uncover insights by drawing directly from Retail & Commerce data.
To connect to either of the content packs, simply provide the URL to your AX 7 environment and sign in. Once the connection is complete, Power BI will automatically create a dashboard, report, and dataset with data from your Dynamics AX account. The out-of-the-box dashboards offer an overview of the insights included in the content pack, and you can select any of the tiles to drill into the multiple pages of reports behind the dashboard.
In the Retail Channel dashboard, you can select the Total Amount tree map visual to drill into the Statewise Sales Distribution report page.
In each report you can switch to edit mode, where you can edit or add additional visuals to your reports. On the right, you’ll see a list of all the tables and fields you have access to in the content pack. Editing the Expense Analysis page in the Financial Performance report shows the seven different data tables included in the content pack, as well as the fields used for each of the visuals.
From any of the reports you can pin visualizations or tiles to the dashboard by hovering over them and selecting the pin icon. Pinning the visuals will prompt you to select a destination dashboard, allowing you to customize and bring in data from multiple sources.
After the initial import, the dashboard and the reports continue to update daily with the latest content, and you can control the refresh schedule on the dataset. With the Dynamics AX content packs for Power BI, you have an initial set of insights for your Retail Channel manager and your Finance manager to explore your Microsoft Dynamics AX data even further.
Thanks
Shivam Kotwalia
ReplyDeleteMicrosoft has actively sustained what they call “a blistering pace of innovation” and, whilst listening to user needs, they continue to update Power BI with monthly updates.
Microsoft Power BI is new, but excitingly it’s evolving virtually on a monthly basis.
So just when you realize how brilliant the Power BI tool is, you suddenly discovered it’s just got even better!
Data Bear is one of the many companies helping clients with this powerful self-service business intelligence (BI) offering, and it didn’t take long for their team to identify Power BI as a serious game changer. Specializing in business intelligence consulting, Data Bear founder, Johann Joubert believes Power BI has become the single most powerful tool for businesses to use to ensure the full range of businesses are ahead of the rapidly changing BI world and the opportunities it offers.
Microsoft is determined to deliver modern BI and analytics solutions for all types of users and to remain a leader and visionary in a competitive BI platform environment.