Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Thursday, March 15, 2012

Conv12 - Here we come!




I hope everyone has had a great week so far. Personally I've been super busy, and getting ready for next weeks Conv12! It's packed with a host of great sessions, materials, speakers, training & network opportunities. You can get full access to all the sessions, and tracks by going to the following resource.: Convergence 2012 - Session Catalog, Content, Tracks and more!



One of the great parts about Convergence, specifically for me, is the involvement of AXUG, and it's DayOne Events. These are always some really great sessions, round tables, panels and the like. Specifically I will be involved in leading, or help leading in the following session at Convergence.

UBAX03 - AXUG Special Interest Group (SIG) Roundtable Discussion: Software Architects
"Join fellow Microsoft Dynamics AX technical gurus who share the need to better understand how development and infrastructure in Microsoft Dynamics AX can be administered and utilized to support your company's needs. Listen, learn, and share your experiences around maintaining the environment, delivering quality X++ solutions, and how best to manage the Microsoft Dynamics AX performance with your database."

This event already has a good amount of people registered, and I will be helping host this session, along with some other great, and very active AXUG community contributors, including: Mike Simms, Joel Pietrantozzi, Jason Thorpe & Christian Fordham.

Right after that, we have the next section I will be involved in.:
UBAX14 - AXUG Special Interest Group (SIG) Roundtable Discussion: Business Intelligence & Reporting
" In this exciting session, join fellow Microsoft Dynamics AX users who share the need to better understand how best to utilize Microsoft Dynamics AX reporting to meet user needs. This AXUG SIG breakout session will discuss the various approaches and techniques that users are utilizing to meet reporting requirements, including both standard Dynamics AX and SSRS approaches."

This event should be a great one as well, and once again I will be joining with other community giants, to help make this a wonderful event like: Mike Simms, Joel Pietrantozzi & Jason Thorpe

Directly related to the above session, keep your eye open, and sign up for my upcoming three part series I'm putting on through the AXUG Academy BI with Dynamics AX 2012: Options, Development, and Delivery I will cover more about that series, right after Convergence. So if your attending the BI & Reporting SIG at AXUG DayOne, then joining us for the three part series will carry over and help you create a true BI story for your company, using AX 2012. Further, I will dive into the upcoming SQL Server 2012 BI abilities & AX 2012 RC2



Moving right along into the week at Conv12, and along these same topic lines, for both Monday and Tuesday, I will facilitate two "Birds of a Feather: Microsoft Dynamics AX" sessions. These will be open discussions, specifically focused around BI & Reporting for Microsoft Dynamics AX.

If you are a regular reader of my blog, you understand that BI is one of my expertise, and specifically a topic in which I believe a lot of customers never fully get the full benefit of. There is a lot of value that can be added through understanding the BI as it relates to Dynamics AX 2012. Having the knowledge of working with the right tools, for the right job, is critical is driving that value, through BI concepts.

Further, I will continue to post and dive into real world BI examples, and needs, with the goal, once again of driving the most value out of your existing AX investment.

Finally, I will close with there is going to be a lot going on at Convergence 2012, so make sure you have used your schedule builder, and get the most out of your visit. You can follow my tweets as I do live event coverage while at Conv12 at: @DynamicsERP. Well that's all for this post, I will have one more tomorrow, and then it's off to see everyone at Conv12. Further there will be plenty of blog post during, as well as post Convergence as we continue this Dynamics AX journey together. Till Next Time!
Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , , , , , ,

Friday, March 02, 2012

Understanding Business Intelligence Semantic Model (BISM) & Future with AX 2012







Visit Hillstar Business Intelligence (www.HillstarBI.com) in order to truly unlock your data trapped in your Microsoft Dynamics investment. With our value driven business intelligence strategy Hillstar help you transform into a data informed company.


I hope everyone is doing well on this fine Friday! Hopefully you have had a very productive week, focused on your Dynamics AX projects. I wanted to continue today, the forward looking exercise of diving into the future of Business Intelligence and it's use with AX. We started the look, with an early post, focused around SQL Server 2012 & the Future of BI with Dynamics AX.



That was an introduction really, and resource post on getting access to SQL Server 2012 RC0, as well as focused on the new reality of Personal BI also known as Self-Service BI. From there, the next post was an high level introduction SQL Server 2012 - SSAS Tabular Modeling.



This included an introduction to a recently released book, pictured above, that helps dive into the topics of BI, empowered by SQL Server 2012. Now have these introduction post, it's time to take a step back a bit, and look at the larger picture, and vision of BI. Enter Business Intelligence Semantic Model (BISM).


Image Courtesy of Microsoft


From the above image, we can see that BI is taking shape in three real domains of context, and therefore development. First we have the Personal BI, followed by Team BI & finally Operational BI. A key understanding from this point, at least from the vision point of view, is Microsoft's focus on 'One Model for all End User Experiences'.

This was a driving theme behind Microsoft's adoption of technologies like VertiPaq that are enabling the Tabular Modeling concepts. As well, this still very much includes, vs. excludes, traditional BI concepts like OLAP Cubes.

If we look at this starting from the personal BI, we see technologies, that are very much apart of Microsoft Dynamics AX 2012 total solution. Starting with Personal BI and it's heavy use of Microsoft PowerPivot, through SharePoint and finally Analysis Services.


Image Courtesy of Microsoft


Moving forward, into the architecture of what will make up the BI Semantic Model, we see again, familiar and current use technologies that enable this reality. technologies, like SQL Server, Cloud based Data Services as we as OData Feeds.



We can see, already, that technologies like Microsoft PowerPivot can be used with enabling technologies like the Open Data Protocol or OData Feeds, can be used, correctly with AX 2012, to consume Query objects, for example, which enable this Personal BI, today. Having the above understanding of the BI Semantic Model, mixed with this understanding and we can see again how SQL Server 2012 will be used, and enable it's reality natively with Microsoft Dynamics AX 2012 RC2, scheduled for release in 2013.

To help better understand this vision & Microsoft roadmap, a great article was authored last May, that goes deeper into these topics.: Analysis Services – Vision & Roadmap Update

From the article:
"The BI Semantic Model is one model for all end user experiences – reporting, analytics, scorecards, dashboards, and custom applications. All client tools in the Microsoft BI stack – Excel, PowerPivot, SharePoint Insights and Reporting Services (including Crescent) – operate on this model. BI professionals can create the model in Visual Studio and deploy it to an Analysis Services server. Interestingly, the model can also be created by business users with PowerPivot for Excel and shared via PowerPivot for SharePoint. PowerPivot and Analysis Services are two different products; one targets business users and the other targets BI professionals and IT. However both use the BI Semantic Model under the covers."


Image Courtesy of SQLServerPerformance


Taking this understanding around the vision further, and going back to a focus around technical understanding, there is another great article, created by the SQLServerPerformance Site.: Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012

From the post:
"The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack."

As you can see, the landscape of BI, offered from Microsoft, natively within the stack and products is getting a massive overhaul, and going to truly enable the 'BI for the Masses' tag line that has been a goal for many years now for Microsoft. These new offerings, are going to be natively used and very much a part of Microsoft Dynamics AX 2012 RC2. This will have a lasting impact, positive one in my thoughts, for how we even define Business Intelligence within the Dynamics Community.

That's all for this Friday, I hope that these post so far has your wheels turning, and your thinking hard about how this can benefit you and your companies Dynamics AX investment. Value is the focus, reducing time-to-value is the art, and for BI what we are seeing with SQL Server 2012's release brings the tools. Till Next Time!


Visit Hillstar Business Intelligence (www.HillstarBI.com) in order to truly unlock your data trapped in your Microsoft Dynamics investment. With our value driven business intelligence strategy Hillstar help you transform into a data informed company.



Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , , , , , , ,


Copyright 2005-2011, J. Brandon George - All rights Reserved