Dan English's BI Blog

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

Posts Tagged ‘training’

PASS Business Analytics Virtual Chapter October Meeting–Incorporate “Big Data” in Analysis Services

Posted by denglishbi on October 14, 2014

The next PASS BA Virtual Chapter meeting is coming up this Thursday at 11 a.m. EDT (10 a.m. CDT).  This month the topic is covering how to incorporate unstructured data into Analysis Services.

October 16 – How to incorporate “Big Data” in Analysis Services cubes?BAVCLogo (1)

Abstract - Free form text is estimated to make up 70% to 80% of a company’s data assets and is considered significantly underutilized from an analytical perspective. There are numerous sources for this growing pool of unstructured data such as customer email, call center notes, chat logs, satisfaction surveys or claim forms to name a few. Is your company leveraging all of its data assets? Historically, it has been very difficult to analyze text records for trends or patterns due to the free-form nature of this data.

Recent advances in text mining have helped to distill and expose their content. The key to realizing the business value of text mining isn’t found in the sophistication of the clustering algorithms, but rather in the way those clusters are combined with structured data and then presented to the business analyst. Text clustering involves the logical grouping of text records based on the similarity of important terms in the documents. While some insights will likely surface through the examination of the text clusters themselves, the most significant value will occur when the text clusters are analyzed in combination with related structured data. Important facts reflected in thousands or millions of documents can be analyze along with structured data elements such as time, location or products to turn new business insights into a sustainable competitive advantage

Bio – Reid Karabush is President of Decision Systems Inc., based in Northbrook, IL. His expertise includes over twenty years specializing in the field of business performance management and analytics, and is recognized nationwide as an expert in these field. His experience includes architecting and designing systems for various organizations including ArcelorMittal, American Pharmaceutical Partners, APAC, AT&T, Bristol-Myers Squibb, Chamberlain Group, Corning Inc., Fleet Bank, GMR Marketing, HSBC Bank, IPEX, J.D. Power & Assoc. and The Major League Baseball Players Association. Reid has published various articles related to business analytics and business performance management and has mentored and trained a number of software vendors including Hyperion, Pillar and Applix. His background includes working within the software product management groups of Comshare and Wang Laboratories, where he focused on multi-dimensional database, analytics, and executive information systems.

–> 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 SQLSaturday #332–Oct 24, 25

Posted by denglishbi on October 2, 2014

The 5th Annual MN SQLSaturday event is coming in less than 4 weeks!  This year the pre-cons are back as well this year and there are 4 great pre-con events scheduled for Friday, October 24.

Choose from one of these expert sessions!! Reserve your spot now for only $99!  Hands down, these sessions are the best bang for your training dollars!!

DB1 – Argenis Fernandez image
A Day of SQL Server Internals and Data Recovery

DB2 – David Klee
Virtualization for SQL Server DBAs 

BI1 – Jason Strate & Adam Jorgensen
Architecting the Modern Data Warehouse

BI2 – Mark Vaillancourt
Microsoft Excel: The Business Intelligence Platform For The Masses

The main event will be on Saturday, October 25.  The schedule is posted and there are 7 tracks with 35 presentations!

https://www.sqlsaturday.com/332/schedule.aspx

There will be 3 of us speaking from Superior Consulting Services:

Dan English
Getting Down with Power Query and Power Map

In this session you will learn about the self-service ETL capabilities that have been added into Excel. See how easy it is to pull in data from the web and integrate it and enhance your existing data to provide useful insights. We will also take a look at the new data visualization capabilities provided with Power Map and see how easy it is to interact with and explore geographic and temporal data. These are two new self-service capabilities that have been added and are part of Power BI, don’t miss out!

Brian Larson
Structured Ad Hoc Reporting-Case Study of an Oxymoronic Reality

The large franchise corporation in this case study was looking to provide franchisees with a mechanism to create their own custom reports from a PC, Android device, or iPad. In order to minimize training and support, the desired environment was to be highly structured while still providing reporting flexibility. Come see how SSRS and SSAS along with custom .NET code were used to fulfill these requirements and create a solution which franchisees called intuitive, revolutionary, and life changing.

Rick Bielawski
Mastering queries into XML data.

If you’ve never queried an XML column you definitely want to attend. After this hour there won’t exist an XML element whose value you won’t be able to retrieve. If you’ve been querying for years there is still a fair chance you’ll learn something new.

Be sure to stop by and visit the sponsors, lots of great sponsors have stepped up to make this event possible – https://www.sqlsaturday.com/332/sponsors.aspx

Hope to see you there!

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

Speaking: MindSurf Conference–Oct 9

Posted by denglishbi on September 26, 2014

The 7th Annual MindSurf conference in Minneapolis is just two weeks away and I will be speaking there in the Office Technology Track!  I will be talking about empowering data analysts using Excel and the Power BI features including Power Query and Power Map.

Delivering Self-Service BI with Power
8:15–9:45

Dan English, Superior Consulting Services
Session Level: 200 – Intermediate
Audience: Business analysts

In this session, we will discuss the new additions made available to Excel as Microsoft continues its roadmap with self-service BI. You will see how Microsoft has empowered you to discover, analyze and visualize data all on your own. We will use Power Query to load and integrate data into a model that can then be analyzed and enhanced with Power Pivot. From there, we will dive into Power Map; you will see how to visualize and create tours of your data to explore and share your insights!

Along with me presenting at MindSurf my fellow colleague and BI team member Eric Ness will also be presenting in the Business Analysis Track on forecasting!

Forecasting: Methods and Benefits
1:15–2:30

Eric Ness, Superior Consulting Services
Session Level: 200 – Intermediate
Audience: Business analysts, data analysts

Forecasting techniques gives business analysts a peek behind the scenes of what will happen to the business in the future. Forecasting can be used with any quantitative amount that fluctuates over time, such as revenue or costs. Recently, software vendors have released tools that hide the complexity of the techniques behind automatic tests and a graphical interface. This session will discuss the methods and benefits of forecasting as well as an overview of available software.

In total there are 8 tracks with 32 sessions and 29 speakers!  Check out the event here – MindSurf Conference at the Minneapolis Convention Center.

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

PASS Business Analytics Virtual Chapter September Meeting–Insider’s Intro to Microsoft Azure ML

Posted by denglishbi on September 17, 2014

The next PASS BA Virtual Chapter meeting is tomorrow, Thursday September 18 at 12 EST and Mark Tabladillo will be presenting on the recently released Microsoft Azure Machine Learning.

September 18 – Insider’s Introduction to Microsoft Azure Machine Learning (AzureML)BAVCLogo (1)

Abstract: Microsoft has introduced a new technology for developing analytics applications in the cloud. The presenter has an insider’s perspective, having actively provided feedback to the Microsoft team which has been developing this technology over the past 2 years.

This session will:

1) provide an introduction to the Azure technology including licensing,

2) provide demos of using R version 3 with AzureML, and

3) provide best practices for developing applications with Azure Machine Learning.

Bio: Mark Tabladillo is a Microsoft MVP and SAS expert. He helps teams become more confident in making actionable business decisions through the use of data mining and analytics. Mark provides training and consulting for companies in the US and around the world. He also teaches part-time with the University of Phoenix. He tweets @marktabnet and blogs at http://marktab.net/

–> REGISTER NOW <–

image

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 »

TDWI Minneapolis Chapter Event: BI Strategy, KPI’s and Leading Indicators – Sept 8

Posted by denglishbi on September 4, 2014

The next TDWI Minneapolis Chapter meeting is next week Monday, September 8 and it will take place at the Courtyard by Marriot in Bloomington, MN. The meeting will feature Wayne Eckerson and he will be talking about the new analytical ecosystem.

http://tdwichapters.org/Minneapolis (or http://www.tdwimpls.org/)

Here are all of the details:

When: Monday, September, 2014, 8:00 a.m. – 12:45 p.m.

Where:  Courtyard at Marriot/Bloomington

7800 Bloomington Avenue South

Bloomington, MN 55425

Click here to register for the next upcoming event

Agenda:

8:00 – 8:30 a.m. – Networking and Registration
8:30 – 8:45 a.m. – Introduction and Chapter Business
8:45 – 9:30 a.m. – The New Analytical Ecosystem, Wayne Eckerson
9:30 – 10:00 a.m. – Break and Networking
10:00 – 11:00 a.m. – Continued: The New Analytical Ecosystem, Wayne
11:00 – 11:30 p.m. – Q&A – Discussion
11:30 – 12:45 p.m. – Closing Comments & Wrap-Up

Click here to register for the next upcoming event

Abstract:

"The New Analytical Ecosystem: Bridging the Worlds of BI and Big Data"

Wayne will be talking about The New Analytical Ecosystem: Bridging the Worlds of BI and Big Data.  For too long, organizations have tried to shoehorn all analytical users and activities into a single, monolithic architecture. Forward-thinking organizations are now augmenting their classic report-centric data warehouses with real-time, analytical, and content-based engines to support multiple types of users, data, and applications. This presentation describes the fundamental business forces at work that make it difficult to deliver successful BI programs. It then describes a new organizational architecture, data architecture, and analytical architecture that enable organizations to optimize business dynamics and reap value from their data analytics assessments. In short, the presentation shows how to create a new analytical ecosystem for the 21st century.

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

Minnesota Microsoft BI User Group 2014 Q3 Meeting–Sept 9

Posted by denglishbi on September 3, 2014

The next MN Microsoft BI user group meeting is coming up next Tuesday on September 9 from 3 to 6.  This meeting will have two presentations, the first one on forward looking dashboards & KPIs and the second on 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 Q2 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, September 9, 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 : Looking Through the Windshield: Creating Forward-Looking Dashboards and KPIs
  • 4:15-4:30 : Break
  • 4:30-5:30 : Case Study: Monitoring SSAS Usage with Extended Events
  • 5:30-6:00 : Social and Networking

Presentations:

Session 1: Looking Through the Windshield: Creating Forward-Looking Dashboards and KPIs

It is dangerous to drive forward while looking through the rear window. The same is true about guiding our organizations forward while looking only at the past. Yet, much of our business intelligence shows only the past. This session explores simple techniques to make our dashboards and KPIs visualize what is likely in the future. No fancy predictive algorithms are necessary–just an appreciation of what we know about our organization’s future and a recognition of past trends that are likely to continue.

Speaker: Brian Larson

Brian Larson is the Chief Technology Officer at Superior Consulting Services and has presented at SQL Server Connections, the PASS Summit and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2012 Reporting Service: 4th Edition” and “Delivering Business Intelligence with SQL Server 2012: 3rd Edition” as well as co-author of “Visualizing Data with Microsoft Power View.”

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 »

PASS Business Analytics Virtual Chapter August Meeting–Creating Forward Looking Dashboards and KPIs

Posted by denglishbi on August 7, 2014

The next PASS BA Virtual Chapter meeting is tomorrow, Thursday August 21 at 12 EST and Brian Larson will be presenting on designing dashboards and KPIs for your organization.

August 21 – Looking through the Windshield: Creating Forward-Looking Dashboards and KPIs (presented by Brian Larson)BAVCLogo (1)

Abstract: It is dangerous to drive forward while looking through the rear window. The same is true about guiding our organizations forward while looking only at the past. Yet, much of our business intelligence shows only the past. This session explores simple techniques to make our dashboards and KPIs visualize what is likely in the future. No fancy predictive algorithms are necessary–just an appreciation of what we know about our organization’s future and a recognition of past trends that are likely to continue.

Bio: Brian Larson is the Chief Technology Officer at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2012 Reporting Service: 4th Edition” and “Delivering Business Intelligence with SQL Server 2012: 3rd Edition.” as well as co-author of “Visualizing Data with Microsoft Power View.”

–> REGISTER NOW <–

Just a reminder if you are planning on attending the upcoming PASS Summit Conference in Seattle, WA this November, you can save an additional $150 by using the following discount code – VCSUM04

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

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 »

PASS Business Analytics Virtual Chapter July Meeting–7 Ideas on Encouraging Advanced Analytics

Posted by denglishbi on July 16, 2014

The next PASS BA Virtual Chapter meeting is tomorrow, Thursday July 17 at 12 EST and Mark Tabladillo will be presenting on ways to encourage advanced analytics within your organization.

July 17 – 7 Ideas on Encouraging Advanced Analytics (presented by Mark Tabladillo)BAVCLogo (1)

Abstract: Many companies are starting or expanding their use of data mining and machine learning. This presentation covers seven practical ideas for encouraging advanced analytics in your organization.

Bio: Mark Tabladillo is a Microsoft MVP and SAS expert based in Atlanta, GA. His Industrial Engineering doctorate (including applied statistics) is from Georgia Tech. Today, he helps teams become more confident in making actionable business decisions through the use of data mining and analytics. Mark provides training and consulting for companies in the US and around the world. He has spoken at major conferences including Microsoft TechEd, PASS Summit, PASS Business Analytics Conference, Predictive Analytics World, and SAS Global Forum. He tweets @marktabnet and blogs at http://marktab.net.

–> REGISTER NOW <–

Just a reminder if you are planning on attending the upcoming PASS Summit Conference in Seattle, WA this November, you can save an additional $150 by using the following discount code – VCSUM04

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

Minnesota Microsoft BI User Group 2014 Q2 Meeting Follow Up

Posted by denglishbi on June 6, 2014

This past Tuesday we had our Q2 meeting.  This was our 3rd meeting of the year.  We had a great turnout and the room was full with over 80 people in attendance. Needless to say the night did not go off with a hitch, technical difficulties including one projector not working so a temp replacement was used, speakers not working in all of the rooms, and then we lost power during the middle of the second presentation.  Microsoft did a fabulous job working on getting these issues resolved, it was just not our night.  I want to thank everyone for their patience, including the speakers.

The content from the meeting should be posted in our Archive area soon – Past Events and Presentations.

In the meantime you can view the opening announcement slide deck here and checkout the upcoming events including TDWI Minneapolis Chapter, PASSMN June Meeting (Lightning Talks this month), and PASS BA VC session.

image

We had two great presentations – Don covered the 5 Principles for Creating Effective Data Visualizations (outstanding content and examples)

image

The one resource link that was excluded was the Interactive Demo, Katz Dialect Survey Maps, http://spark.rstudio.com/jkatz/SurveyMaps/.

Here are a couple of other resources that you might find helpful that are posted on the Microsoft downloads done by Stephen Few:

And then Polaris did a case study on how they ended up replacing QlikView with the Microsoft BI stack and demoed their dashboards using PerformancePoint and SSRS.

Here are a few links that Michael Wissink mentioned with regards to using perspectives in PerformancePoint and also security for the Save As My Defaults for the Apply Filters functionality

I also want to mention that we have now received our discount code for the PASS Summit 2014 Conference for the user group.  If you are planning on attending make sure you use the following code and you will save $150 and this will also help benefit our user group as well!

Event – PASS Summit 2014 Conference (Nov 3-7)

Minnesota Microsoft BI User Group
Discount Code: USNCS27

Thanks to everyone that attended our meeting and don’t forget there is a Special Training Event this month on Thursday, June 27 from 3 to 5 (seating is limited, so register now):

Deep Dive into ETL Implementation with SQL Server Integration Services

Registration Link

This session will focus on demonstrations and implementation details covering:

- Leveraging common ETL patterns/options to handle change data capture and covering new capabilities of SQL Server 2014

- Leveraging scripting in Data Flow and tips/tricks to improve performance

- Best practices in ETL Implementation with SSIS

- Executing projects with SSIS catalog; design considerations, best practices and performance monitoring.

At the end of the session, sample code and examples will be provided to all attendees. Complimentary refreshments will be provided during breaks.

About Our Speaker: Anton Rozenson is a Solutions Architect with GNet Group. He has in-depth experience in developing architectures, and leading business productivity projects that span the entire Microsoft Business Intelligence platform. Anton has worked on several successful solution development projects to build end-to-end Data Warehouses with Microsoft SQL Server.

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

PASS BA & BI Virtual Chapter June 2014 Sessions

Posted by denglishbi on June 5, 2014

Just wanted to do a quick post to let everyone know about the upcoming presentations this month for both the PASS Business Analytics and Business Intelligence Virtual Chapters.

June 10 – Administering and Managing the Power BI Environment (presented by Melissa Coates, BlueGranite)

Power BI for Office 365 is Microsoft’s new self-service BI offering. Just because it emphasizes self-service doesn’t mean a system administrator isn’t an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources and how those OData feeds affect Enterprise Data Search functionality.

June 19 – The Accidental Report Designer: Data Visualization Best Practices in SSRS (presented by Meagan Longoria, Valorem Consulting)

Whether you are a DBA, a developer, or an analyst, there is a good chance that you will have to create reports for coworkers, company executives, or clients. As with any UI design, careful consideration should be given to your data visualization design to ensure you are effectively communicating the intended message and providing a good user experience. While the principles are applicable across reporting platforms and tools, this session will contain demos and examples implemented in Reporting Services using SQL Server Data Tools. Learn how to make information (not just data) the focus of your report and provide your audience with something better than just shiny!

June 23 – Common Analysis Services Multidimensional cube design mistakes and how to avoid them (presented by Chris Webb, Crossjoin Consulting)

When you’re starting out on your first Analysis Services cube project it’s very easy to make design mistakes that can cause problems for you later on. In this session you’ll learn about the mostly frequently make Analysis Services design mistakes, what the consequences of making them are, and how to fix them.

Lots of great content to check out this month.  Make sure you visit the Virtual Chapter sites and you can also login to your myPASS account on the PASS site and join these chapters so you can be notified about upcoming sessions.

image

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

 
Follow

Get every new post delivered to your Inbox.

Join 89 other followers