Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Power BI Preview Layout Overview

Posted by denglishbi on March 26, 2015

In the first post, Getting Started with Power BI Preview, I discussed briefly the “new” Power BI and went over how to get access to this service.  Now that you have access I want to go over the layout of the land and show the different items you have access to on the Power BI Preview site.

image

1. Microsoft Power BI Public Preview – this is your landing / home page. If you access other areas such as getting data, reports, datasets, etc. you can click on the top right to return to the home page to view your currently selected dashboard.

2. Get Data – using the Power BI Preview web site interface this is the area where you will be able to bring in your data to create datasets, reports, and eventually dashboards.  In the next post of this series we will explore this area in more detail.

3. Content Pane – you have the ability to search and filter the existing content you have available in the datasets, reports, and dashboards.  These areas expand and collapse and the plus sign next to the datasets will send you to Get Data and the one next to Dashboards will allow you to create a new dashboard.  Once you create a new dashboard you can then get data, create reports, and pin items to it.

4. Dashboard Title & Share – the current dashboard title you are viewing and a link that allows to to invite others to view as well as possibly share your dashboard you have created along with the data.

5. Q&A – this is the natural query language capability, the same one that is provided in the current Power BI in Office 365.  You have the ability to ask questions of your data just like asking questions on Bing or Google to get results.

6. Dashboard content – this is the content that has been selected from the reports that were developed on the dataset as well as results possibly from Q&A that have been pinned.  These items (tiles) can be resized and rearranged once they have been pinned. This reminds me of the Windows 8 and Windows Phone start screen – live tiles.

7. Support, Help, and Feedback menu – just grouping these last remaining items together that are in the top-right.

  • The first icon which looks like the typical settings / configuration icon we are used to is actually the download area and will provide access to the Power BI for iOS app, Power BI Designer Preview, and the Analysis Services Connector Preview.
  • The second icon is the Support / Help icon which gives you access to Getting Started material, Contact Support (email the team), What Should We Build Next (forum and voting area), Help Topics, Power BI for Developers (yes there is a developer area and API information), About Power BI (version number information).
  • The third icon is simply the feedback one to rate and let the team know what you think of the Power BI Preview.
  • The final icon is your account and provides option to sign out.

Next up, we will go over creating your first dashboard, dataset, and reports.  Stay tuned for more!

Posted in Power BI | Tagged: | Leave a Comment »

Data Security–Superior Spotlight 5 part blog series

Posted by denglishbi on March 25, 2015

This 5 part blog (3rd part was broken out into 3 separate parts) series on Data Security was written by Senior BI Consultant and colleague Rick Bielawski from my BI team. I wanted to share the series and hope you find it interesting and make you think when it comes to the data that you work with and are in responsible for.

Here is an intro from the first part to get a feel for what the series will cover:

This blog is the first in a three-part series describing how to properly assess your data security needs. Like buying any insurance, there is no reason to pay for protection you don’t need. Yet, your business can’t afford to leave significant risk on the table. To get all (and only) useful protection, you must become your own actuary, quantifying and prioritizing potential losses and then developing a plan to mitigate loss cost effectively.

In this series, part one covers sources of risk. Part two gives you an idea of the significant number of attack vectors possible. Part three talks about the mindset needed to design proper protections and how to look at the extent to which various protection types mitigate various risks.

- Data Security: Critical Knowledge (part 1)image

- Data Security: Mechanisms for Malicious Loss (part 2)

- Data Security: Critical Knowledge – Designing Protection (part 3a)

- Data Security: Critical Knowledge – Design Approaches (part 3b)

- Data Security: Critical Knowledge – Implementations (part 3c)

I hope you find the information useful.

Posted in Uncategorized | Leave a Comment »

Getting Started with the Power BI Preview

Posted by denglishbi on March 24, 2015

Last year Microsoft began working on a “new” Power BI version / capability.  This was released to a limited group of users for feedback and then last December was released within the U.S. and I posted this first post – Installing Power BI Designer Preview Experience.  Now this past week it is available in over 140 countries – Power BI Preview now available worldwide.image

So what it so special about this new experience?

Well first of all to get started using Power BI you no longer need to use Excel.  Excel has been the main driver of Power BI capabilities and the container where data and reports would be created to then share with others through SharePoint and/or Power BI in Office 365.  Now the data can be collected using either the new Power BI Designer or directly through the new browser based Power BI preview experience.

The next item that makes this interesting / attractive is the price.  Yes, how much does this end up costing you?  Well to get started all you need is to create an account and the rest is actually free.  Yes, that is correct, free.  Of course the “Free” version does come with some limitations, but for the most part you have the same capabilities as the version that is the paid Pro service of $9.99 user/month.  And that is price cut from the previous Power BI online experience of $40/month.  Here is more information about the new pricing and feature comparison between the Free and Pro paid versions – Power BI Preview Pricing.

In order to get started you simply need to do the following:

1. Go to the following web site – http://powerbi.com

image

2. Next sign up by entering your business or educational email address

image

image

3. Complete the Microsoft Power BI sign up process by following the link in the email you receive

image

image

4. Once you enter in the information and click start you will get a confirmation and depending on the current usage you might have to wait 15 minutes or so for everything to get spun up and ready for you to begin

image

5. Sign In to the Power BI site specifying that you are using a work or school account

image

Now in my case this is actually a personal Microsoft account and not provided by my organization, I am simply using my work email for my Microsoft account.  I will now switch over and login with my organization provided email, I just wanted to show what the process would look like to get started with the process.

6. Once you are logged in you will now be able to access the Microsoft Power BI Public Preview site

image

That is all it takes, so in less than 15 minutes or so you can be logged in and ready to roll.  Next up, we will go over a quick tour of the layout of the site.  Stay tuned!

Posted in Power BI | Tagged: | 4 Comments »

PASS Business Analytics Virtual Chapter February Meeting – Crime Analytics & Predictions System

Posted by denglishbi on February 24, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up this week on Thursday, February 26.  This month we welcome Third Eye founder Dj Das.

February 26 – Crime Analytics & Predictions SystemBAVCLogo (1)

Abstract -

Committing Crime is the final frontier – where a human starts to degenerate into a renegade, a social waste and capable of causing huge personal and financial loss to individuals, businesses and the government. Thus, battling crime, reducing the number of occurrences, preventing and predicting crime has become a huge commitment for police forces around the world.
This webinar along with a live demo will showcase how police departments can leverage predictive analytics on Big Data to understand the various factors that affect crime and develop comprehensive strategies for countering them.

The Big Data Analytics Demo will slice & dice, analyze & visualize crime data (Open Data) made publicly available by the City of Chicago.

In this one-hour webinar, we will showcase & discuss the following Microsoft products:

Azure:
- HDInsight
- SQL Azure

Power BI:
- Power Q&A, Power View, Power Pivot, Power Query, Power Map

AUDIENCE
Technical & Management leaders.

Bio – Dj Das is a senior-level consulting services & product executive with a deep technology bend and global operations background. He has a visionary entrepreneurial spirit, and proven track record as creator of commercially successful enterprise and consumer web applications. He has delivered many new products to markets for both start-ups and Fortune 500 companies. He is a results oriented, decisive leader who combines an entrepreneurial spirit with corporate-refined execution in product marketing, business strategy and planning, user experience, delivery management and revenue optimization. He is an adept strategic partnerships builder across global businesses. Dj founded Third Eye in 2009 with a single vision – to provide consulting services & solutions around Big Data, even when Big Data was not such a buzz word. He brings in strategy, execution & operational values to Third Eye. Dj is an avid Big Data evangelist, runs & operates a meetup group named “Big Data Cloud” which is a not-for-profit organization for evangelizing and training around Big Data & Cloud technologies. The group has 3400+ members and has monthly meetups and annual events. Dj is also the founder & managing partner of Das Capital, LLC. through which he makes indirect & passive private equity investments. His previous investments are NeoTeris (acquired by NetScreen), Indivos (acquired by PayByTouch), YouSendIt (private exit), Efficient Frontier (acquired by Adobe Systems), Kosmix (acquired by WalMart), Aster Data Systems (acquired by Teradata), theFind.com, Mobissimo Travel, Jasper Design Automation and Xora among others. Prior to Third Eye, Dj served as the VP of Business Development for LG CNS America where he developed and executed strategies to launch LG CNS’s consulting services on American soil. He opened up initial marquee accounts and brought the first dollar in. Previously, he worked in numerous engineering roles at Microsoft, Siebel Systems among others. Dj received his Bachelor’s degree in Electronics & Communications from National Institute of Technology, Kurukshetra, Haryana, India.

–> REGISTER NOW <–

Just a reminder if you want to stay in touch with the PASS BA Virtual Chapter here are some ways:

image

image

image

If you are interested in speaking we are always looking for speakers, please leave a comment or send me an email at denglishbi@gmail.com

Posted in Training | Tagged: , , | Leave a Comment »

MN PASS BI User Group Q1 2015 Meeting – March 3

Posted by denglishbi on February 12, 2015

The first meeting of the 2015 year is coming up in a couple of weeks on Tuesday, March 3 for the MN Microsoft BI User Group.  This meeting will have two presentations, the first one is a healthcare case study and the second one is on Power Query.  Please register so that we can have your name badge pre-printed.


image

MN Microsoft BI User Group 2015 Q1 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Tuesday, March 3, 2015

Check In: 2:45 PM Event Time: 3:00 PM – 6:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435 (in LOW 1, 2, and 3)

Please Register Now (Please register so that we can have your name badge pre-printed)

Agenda:

  • 2:45-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : Healthcare Case Study: DW and BI
  • 4:15-4:30 : Break
  • 4:30-5:30 : Power Query: Data Chemistry for the Masses
  • 5:30-6:00 : Eval Collection, Prizes, Networking, and Pizza

Presentations:

Session 1: Healthcare Case Study: DW and BI

Implementing and enhancing a vendor supplied Data Warehouse and Business Intelligence solution in Healthcare is a significant undertaking. Join Ann Warner and Ross McNeely as they discuss the benefits of launching a vendor supplied solution, and the challenges in expanding the data model to meet the needs at HealthEast Care System. As an Accountable Care Organization (ACO) HealthEast required a new platform to support new analytics across current and legacy systems. We will breakdown how dashboards were developed to help drive down duplicate patient records using Microsoft’s MDS and Power BI. Analyzing health systems and payers will give hospitals and clinics insight into care quality, cost accountability, and patient loyalty.

Speaker: Ann Warner and Ross McNeely

Ann Warner is the Data Engineering and Application Manager at HealthEast Care System.  As the Manager of the Data Engineering team, Ann is responsible for building and managing the team for Data Governance, Operational Data Store, and Epic’s Cogito Data Warehouse.  Ann has experience creating and staffing data warehouse development efforts for higher education, finance, banking, credit card risk, manufacturing, logistics, sales, and marketing.

Ross McNeely is a Principle Consultant and the BI Practice Manager at Tail Wind. Ross has presented at DAMA-MN, SQLSaturday, PASSMN, Microsoft BI User Group MN, and ERworld 2012. Ross adds real-world examples from various industries in his presentations. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic he presents.

Session 2: Power Query: Data Chemistry for the Masses

ETL Developers have being doing chemistry with data for years in tools like SQL Server Integration Services. These tools require training, experience, and time that few business users have. But in the age of self-service BI, those business users need a way to shape data to support their analysis.
This session will show how Power Query can be easily used to take advantage of data’s properties to drive the change we need to support our goals.
We will discuss/demonstrate:

  • The simple process of accessing a wide variety of data sources
  • The ease with which simple transformations can be achieved using the Power Query Ribbon
  • Power Query’s fantastic ability to travel through time to see every step taken with the data
  • The foundations of the Power Query Formula Language, informally known as "M"
  • Using "M" to take Power Query WAY beyond what the Ribbon has to offer.

Come learn about what may well be the most exciting member of the Power BI family.

Speaker: Mark Vaillancourt

Mark Vaillancourt is a SQL Server MVP and a Business Intelligence Enterprise Consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.

PASS Business Analytics Conference 2015 Discount Code – save $150 – USMO03

Save $150 on your registration to PASS Business Analytics Conference, April 21-22 in Santa Clara, CA, using our chapter’s discount code: USMO03. Feel free to share this discount code with friends or colleagues!
http://passbaconference.com/2015/Home.aspx

Posted in Training | Tagged: , , | Leave a Comment »

Free Business Analytics webinar marathon tomorrow, Tue. Feb 3!

Posted by denglishbi on February 2, 2015

Don’t miss out tomorrow on Tuesday, February 3 for the free Business Analytics Webinar Marathon. You’ll get a taste of what’s to come at the BA Conference in April and skills to enhance your organization’s analytics potential the same day!

Here are the six back to back sessions scheduled for BA marathon:

Session Title – Date/Time

Introducing the Reimagined Power BI Platform (Jen Underwood) – 03 Feb 2015, 14:00 GMT

Unlocking Big Data: The Power of Cognitive Computing (James Kobielus) – 03 Feb 2015, 15:00 GMT

What’s next for Business Analytics in the 21st Century? (Hyoun Park) – 03 Feb 2015, 16:00 GMT

Visualization Tools for Data Discovery (Lynn Langit) – 03 Feb 2015, 17:00 GMT

An Overview of Predictive Analytics for Practitioners (Dean Abbott) – 03 Feb 2015, 18:00 GMT

Productivity Revolution in Excel (Avi Singh) – 03 Feb 2015, 19:00 GMT

RSVP NOW!

Click here to register for BA MARATHON!

Also, if you are planning on attending the PASS BA Conference you can use the following discount code and save $150 off registration!

Discount code: PASSBAVC

Hope that you are able to join one of the sessions tomorrow, I will be hosting the 4th session done by Lynn Langit!

Enjoy!

Posted in Training | Tagged: , , | Leave a Comment »

Windows 10 Technical Preview Install Experience

Posted by denglishbi on January 29, 2015

Updated (2/2/2015): Included 6 more pictures of doing the upgrade through the Windows Insider site and going through the Windows Update process.  I had to rebuild my ASUS this past weekend, so grabbed a few more pictures to complete the process.  I had to rebuild because I tried into install the Chrome browser and it installed some malware on my device:S

This past weekend I decided to take the leap and install the latest Windows 10 Technical Preview after the big Windows 10 Online Streaming event last week.  You can check out the news and the recording is available on-demand to watch here – Windows 10 Story.  Before I get started the highlights that I saw in the event coming were the following:

  • Windows 10 will be a free upgrade for Windows 8.1, Windows 7, and Windows Phone 8.1 users within the first year of release
  • Ability to stream Xbox One games to Windows 10 devices
  • New browser coming to Windows 10, project Spartan – Cortana coming to browser, ability to annotate web pages, save pages to offline reading list, and reading mode
  • Tablet mode for better touch experience and new revamped start menu (integration of start screen into start menu)
  • Cortana is now on the desktop (hello personal assistant!)
  • Windows HoloLens and Windows Holographic and Studio – augmented reality, holograms in your everyday life

If you want to check out a couple of quick videos to get an overview of some of the new features check out these:

Okay, now on to my install experience.  I decided I would test out the new OS on an actual device instead of setting it up on a virtual machine.  I wanted to get the full experience.  Before I took the plunge though I did a couple of things with my ASUS Transformer Book (64GB model) – created a USB recovery drive and also created a backup image (done with PowerShell).  Once I felt confident I had some recovery options if things went terribly wrong I proceeded forward with the upgrade.

First thing I decided to do was download the latest ISO image and try performing the upgrade by mounting that and installing Windows 10.  I took a few pictures of that process (sorry for the quality, was trying to do with my phone as the process was going on):

WP_20150124_08_31_09_ProWP_20150124_08_31_57_Pro

WP_20150124_08_32_32_ProWP_20150124_08_49_45_Pro

WP_20150124_08_50_20_ProWP_20150124_08_52_07_Pro

As you can possibly see I went through the process and it tried to setup my ASUS device with the upgrade, but it did not succeed.  The very cool thing about this process though was that upon the blue screens (it did this twice and rebooted each time) the process then went ahead and recovered my device with my previous version of Windows, very cool, thanks!

Since that process did not work I thought I was pretty much out of luck and needed to find a different test device, but then I thought, well maybe I will simply go to the Windows Insider site and try the upgrade from the web site directly.  Sounds like a logical next step, and maybe I should have gone that direction to start with, I have typically done my upgrades (with the exception of going from Windows 8 to 8.1 through the Windows Store) from an ISO image file.

So after going back to the Windows Insider site and starting the upgrade through this process it had me download an executable that I ran that then proceeded me through the Windows Update process to download and install the Windows 10 Technical Preview.  Here is a walkthrough of this process:

WP_20150131_10_16_23_ProWP_20150131_10_17_12_Pro

WP_20150131_10_17_48_ProWP_20150131_10_18_07_Pro

WP_20150131_10_23_02_ProWP_20150131_12_09_21_Pro

WP_20150124_10_18_30_ProWP_20150124_10_27_19_Pro

WP_20150124_10_28_51_ProWP_20150124_10_34_39_Pro

WP_20150124_10_35_35_ProWP_20150124_10_36_31_Pro

WP_20150124_10_36_43_ProWP_20150124_10_37_20_Pro

WP_20150124_10_37_27_Pro WP_20150124_10_37_51_Pro

WP_20150124_10_37_56_Pro WP_20150124_10_38_56_Pro

WP_20150124_10_39_58_Pro WP_20150124_10_40_56_Pro

WP_20150124_10_41_13_Pro WP_20150124_10_41_22_Pro

The process did take a bit to do the complete configuration and setting up my device, quite a longer process than my first attempt, so I had a pretty good feeling this time it was going to work and it did!

For the first time I am sharing a picture of my family, that is my lock screen and my picture password screen is of Butterball and Buddy our pet sugar gliders (father and son)!

After testing out the new merger of the start menu and start screen (okay, still could use a little work) I then kicked the tires on Cortana (really no different than having her on my phone, just now we can continue our chats on the tablet / laptop and she has a few new moves with being able to send emails).

First thing Cortana wanted to know was what to call me

WP_20150124_10_49_19_Pro WP_20150124_10_49_53_Pro WP_20150124_10_50_15_Pro

Then I asked her a few questions such as “what’s the weather”, “tell me a joke”, “do an impression”, “what was the score of the Timberwolves game”, and “who’s going to win the Super Bowl”.

WP_20150124_10_52_49_Pro WP_20150124_10_53_05_Pro  WP_20150124_10_53_18_ProWP_20150124_10_59_25_ProWP_20150124_10_53_39_Pro

Not bad weather here in MN this time of the year, practically t-shirt and shorts temperatures!  Poor MN Timberwolves, very young team.

I was a tad surprised that Microsoft didn’t have Cortana pick the Seahawks, but maybe I will ask her again as we get closer to game time and see if there is a new answer.

That is it for now, Windows 10, I like it so far, looking forward to checking out new features and providing feedback as this journey continues this year until the official release!

Posted in Computers and Internet | Tagged: , | Leave a Comment »

PASS Business Analytics Virtual Chapter January Meeting – Data Analytics Explained for Business Leaders

Posted by denglishbi on January 13, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up this week on Thursday, January 15.  This month we welcome Predictive Analytics Architect Alex Jones.

January 15 – Data Analytics Explained for Business LeadersBAVCLogo (1)

Abstract - The world is becoming more efficient. Today, seventy percent of the companies that graced the Fortune 1000 list a mere decade ago have vanished. Agility and survival are function of innovation, culture, and the ability to predict the future. To that end, data analytics offers a lifeline, a means of survival that will drive productivity and continue to disrupt and redefine business. However, the resources available to today’s business leaders sit on two vastly different ends of the spectrum. On the one hand, highly technical academic resources and on the other largely fluffy overviews of value propositions and potentials. The state of the industry shouldn’t be surprising. The same dynamics played out in early years of the internet. Software providers, technical leaders, and consulting firms greatly benefit from mystifying the world of data analytics into something that is incomprehensible. That lack of conceptual understanding is incredibly risky and propels the cost of analytics initiatives upwards. This webcast aims to bridge that gap between the technical data scientists and business leaders. Ultimately, this understanding will help to: – Connect the strategic goals of business leaders with the capabilities of technical advisers – Focus investments and initiatives within analytics and technology – Distill immensely complex subject matter into comprehensible examples – Accelerate the path to value and increase the ROI of analytics initiatives

Bio – Alex Jones is a Predictive Analytics Architect in the Oil and Gas industry with a passion for distilling complexity into insights and evangelizing data science. His work has been featured on KDNuggets and he was recognized by DataScienceCentral as a top 180 blogger in 2014.

–> REGISTER NOW <–

Just a reminder if you want to stay in touch with the PASS BA Virtual Chapter here are some ways:

image

image

image

If you are interested in speaking we are always looking for speakers, please leave a comment or send me an email at denglishbi@gmail.com

Posted in Training | Tagged: , , | Leave a Comment »

Installing Power BI Designer Preview Experience

Posted by denglishbi on December 18, 2014

Today Microsoft announced the new Power BI features including the new Power BI Designer tool that provides a separate downloadable standalone application that can be used for Power BI features such as Power Query and Power View!  This is completely separate from Excel – now users can connect to data, relate data, create reports, and also import them to Power BI dashboards to share!

imageimage

imageimage

imageimage

image

imageimage

imageimage

image

So in this example I was able to connect to an existing Excel file I had with some preloaded data (Customer and Geography tables), relate the data (queries) together, create a report (as you can see there are new visualizations available such as treemap, gauge, filled map, funnel, combo chart, etc.), and save the file locally (pibx file extension).

Now that I have a Power BI file with a report I can go to the Power BI Dashboard site and upload this file to share the content.

image

image

Once you get the report loaded you can then continue your design experience, pin items to a dashboard, and share (within your own organization for now)!  All of this is done in HTML5, so no worries about Silverlight.

Quite a few of the new visualizations are not supported to be pinned yet, but at some point they will, so hold on.

image

image

Very cool, a whole new user and sharing experience!

There is also a ton of great help and support documentation, videos, and walkthroughs available as well

image

Enjoy and thanks to the Power BI team!

Posted in Power BI | Tagged: , , , | 1 Comment »

Minnesota Microsoft BI User Group 2014 Q4 Meeting–Dec 2

Posted by denglishbi on November 25, 2014

The fourth quarter and final meeting of the year is coming up next week for the MN Microsoft BI User Group.  This meeting will have two presentations, the first one on Azure Machine Learning and the second one is a case study on monitoring Analysis Services usage.  Please register so that we can have your name badge pre-printed.


image

MN Microsoft BI User Group 2014 Q4 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, December 2, 2014image

Check In: 2:30 PM Event Time: 3:00 PM – 6:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435 (in LOW 1, 2, and 3)

Please Register Now (Please register so that we can have your name badge pre-printed)

Agenda:

  • 2:30-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : Predictive Analytics for the Masses: Azure ML
  • 4:15-4:30 : Break
  • 4:30-5:30 : Case Study: Monitoring SSAS Usage with Extended Events
  • 5:30-6:00 : Happy Hour at Pinstripes – Meeting will adjourn with a special networking opportunity hosted by Slalom Consulting. Join everyone at Pinstripes Edina at 3849 Gallagher Drive for refreshments, fun and networking.

Presentations:

Session 1: Predictive Analytics for the Masses: Azure ML

Predictive Analytics generally has the strongest ROI attached to it, but is unfortunately usually one of the last analytical capabilities on the modern enterprise’s Analytical Roadmap. Part of this is due to the fact that predicting the future generally requires some foundational data pieces and tools to be in place. The advent of the Cloud has disrupted many commonly held historical approaches as it can greatly reduce the time to market for the foundational pieces.

The Machine Learning product will be reviewed and a demonstration of the ML set-up and “how to” model 1-3 scenarios will also be covered.

Speaker: Joe Berg and Matthew Lawrence

Joe Berg is a Managing Director with Slalom Consulting and is responsible for the National Information Management & Analytics (IM&A). Joe has spent over 8 years working on business intelligence and data warehouse platforms as a consultant for Microsoft. In addition to his implementation and leadership roles on these projects, Joe has led a variety of successful engagements helping some of the worlds largest organizations develop a world-class Business Intelligence and Analytics capability.

Matthew Lawrence is an accomplished analytics professional with vast experience across many Fortune 500 companies using predictive and descriptive modeling skills in a variety of technical environments to solve a host of business problems. He has led successful analytics engagements from vision to implementation across technology platforms in a variety of data environments. He is skilled at asking the questions to get to the heart of the matter to uncover relationships that lead to actionable insight.

Session 2: Case Study: Monitoring SSAS Usage with Extended Events

How do you measure the success of a Self Service Business Intelligence initiative? While the answer to that question has several components, a vital one is Adoption. Are people using the assets created for that initiative? Since Business Intelligence is using data to make better decisions, why not use data to help answer this question? At Capella University, we did just that.

This case study will describe how we used Analysis Services Extended Events to track the usage of Tabular Models that Capella built for Self Service BI users. We will demonstrate the following:

  • The business case for capturing asset usage
  • The particular goals Capella had in this case
  • How easy it is to get started with SSAS Extended Events (far easier than it looks)
  • The end-to-end solution created: from the event trace itself thru to the Power Pivot model created for analysis
  • Lessons learned (some learned the hard way)

We hope you will come away from this presentation with less trepidation around SSAS Extended Events as well as a foundation you can use for your own solution.

Speakers: Prashant Tolia and Mark Vaillancourt

Prashant Tolia is the Senior Technical Architect for the Information Delivery department at Capella University. He has over 16 years of experience in IT and a passion for Business Intelligence and Data Warehousing. Prashant earned his MBA form Capella and holds certifications as an Oracle DBA and in Cognos BI suite. In his current role, Prashant ensures that all technical solutions are cost effective, appropriate, and adhere to Capella standards and best practices.

Mark Vaillancourt is a SQL Server MVP and a Business Intelligence Enterprise Consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.

Posted in Training | Tagged: , , | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 1,837 other followers