Menu
Cart 0

Our Blog — Business Intelligence

Self Service Reporting In Dynamics AX 2012 Using Excel and Power BI Visual Walkthrough Guide Now Available

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Having users perform their own reporting has been a dream on both sides of the organization. The IT group don’t particularly like creating reports for the users when they could be spending their time on cooler projects, and users don’t particularly like waiting for IT to create the reports that they need to track the …

Read More

Read more →

Make Common Queries Available For Everyone By Saving Them To Office365

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Queries are like mining for gold, because everyone is searching for the motherload of data that is hidden within Dynamics AX, and once they find it, they mine it until it dries out and they have to start prospecting again.  Also, the secret maps to that data are hidden away, usually on someone’s own personal …

Read More

Read more →

Creating PowerView Reports From Analysis Services Cubes In Excel Using PowerPivot

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

If you have ever tried to create a PowerView report within Excel that is populated directly from an Analysis Services Cube, then you may have come across a small roadblock where PowerView refuses to work.  All is not lost though, you can trick Power View into thinking that it is querying a real table by …

Read More

Read more →

Embedding PowerView Reports Into Your Role Centers

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

PowerView is a great way to create your own dashboards and analysis for Dynamics AX because everyone is able to use it… even the non-technical of you out there.  If you create a cool dashboard though, you don’t need to keep it in the shadows of your own personal files, you can share it with …

Read More

Read more →

Create Reports Directly Off the Dynamics AX Cubes Through Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Excel is probably the number one reporting tool because it is on everyone’s computer, and also because it is so easy to manipulate the data and create your own analysis, charts and tables.  In the past though, the more technical users have had a slight advantage over the general users because they knew the secret …

Read More

Read more →