Facebook Twitter LinkedIn YouTube E-mail RSS

Azure ML Minnesota Training Event Follow-Up

share save 120 16 Azure ML Minnesota Training Event Follow Up

azureml 300x169 Azure ML Minnesota Training Event Follow Up

I am publishing this blog post as a follow-up to my Azure ML training session on December 10 at the Microsoft Experience Center in Edina. We appreciate the attendance and feedback from all of you who attended the session. Our marketing team has sent out a follow-up email with the slide deck and the links which were referenced in the presentation. If you have any additional feedback or questions about Azure ML or the presentation, please feel free to reach out and contact me.  My contact information is as follows:

Twitter: @GRBeaumont

LinkedIn: https://www.linkedin.com/in/gregbeaumont

Following are some links that were referenced during the presentation, and which should be helpful for those of you who are looking to learn Azure ML:

Microsoft Links

Data Links Read more…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Managing Deliverable Expectations for Business Intelligence Project Success

share save 120 16 Managing Deliverable Expectations for Business Intelligence Project Success

EV3 1024x545 Managing Deliverable Expectations for Business Intelligence Project Success

Business Intelligence (BI) projects are usually intended to meet a hybrid of different needs, frequently including standardized reports and dashboards, self-service reporting, and data discovery tools. Quite often, unexpected relationships and architectural challenges are found in data during the course of a project. Experienced BI teams are not strangers to mid-project discoveries such as many-to-many relationships instead of traditional dimensions, key relationships that do not map properly, and calculations that need to be modified for the unique needs of the business users.

Despite detailed working sessions with business users and preliminary data analysis, sometimes changes to requirements are needed for a project to meet the needs of the business. Even the most carefully planned projects can end up with initial SOWs that don’t fully capture the details of the actual development required to complete a project. Read more…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2

share save 120 16 Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2
Automated Bus Matrix Process 1024x576 Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2

Use an Automated Bus Matrix to Verify Specifications of a Tabular Model

This is Part Two, the final of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.

In the first part of this blog post series, which can be found at this link, I discussed the benefits of a Business (Bus) Matrix that can be automatically generated from a SQL Server Analysis Services Tabular Model. Typically, Project Managers and Lead Architects cannot always confirm that a Tabular Model is built to Requirements & Design planning specifications until development is complete and testing begins. An automated Bus Matrix would allow for the Tabular Model to be compared to a Project Management specifications checklist, which usually includes a Bus Matrix that was manually created before development began. With this methodology, discrepancies can be mitigated much earlier in the development process, minimizing rework. Existing Tabular Models that have sparse documentation, or which undergo frequent iterative changes, could also benefit from an automated Bus Matrix.

As promised in the first half of this blog post series, we are going to get to the nuts and bolts of building an automated Bus Matrix using DMV queries from a Tabular Model.

Read more…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 1

share save 120 16 Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification   Part 1
Bus Matrix Screen Shot 300x275 Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification   Part 1

An automated Tabular Model Bus Matrix using a DMV query

This is Part One of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.  UPDATE: Part 2 is now published and can be viewed at this link.

Have you ever spent several hours making a Business (Bus) Matrix for an existing cube, and wondered why you couldn’t automate the documentation process? Well, keep reading.

Anyone working in business intelligence (BI) knows that all projects always have thorough, detailed, and accurate documentation. Just kidding. Cuts in budget, crashed schedules, disconnected remote teams, resource turnover, and iterative development cycles frequently lead to lapses and shortcomings in the documentation of solutions.

So how can a Project Manager or Lead Architect have confidence that a BI solution is being built to specifications before it can be tested? I’m sure many of you have nervously awaited the completion of a long development process, hoping that it is does not need to be followed up by a change request for the solution architecture.

Read more…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 

SQL Saturday 332 Minnesota Follow Up and Links for Open Data & Microsoft BI Tools Presentation

share save 120 16 SQL Saturday 332 Minnesota Follow Up and Links for Open Data & Microsoft BI Tools Presentation

We had the opportunity to sponsor and participate in SQL Saturday 332 in Minneapolis this past weekend and attendance at the event was exceptional. The event was completely full with a long waiting list, so we thought a re-cap of my presentation on Open Data & Microsoft BI Tools would be helpful to those who were not able to attend.

You can download a copy of the slide deck which contains links and references at this link. If you have questions about the presentation or material I covered, feel free to reach out to me on Twitter or LinkedIn.

If you’d like to learn more about the consulting work we do at GNet Group, here are a few good places to start:

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments