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 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 »

TDWI Minneapolis Chapter Event: BI Strategy, KPI’s and Leading Indicators – June 10

Posted by denglishbi on May 23, 2014

The next TDWI Minneapolis Chapter meeting has been scheduled for Tuesday, June 10 and it will take place at the Hilton in Bloomington, MN. The meeting will feature Laura Madsen and she will be talking about BI strategy.

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

Here are all of the details:

When: Tuesday, June 10, 2014, 8:00 a.m. – 12:45 p.m.

Where:  Hilton Minneapolis/Bloomington

3900 American Blvd. West
Bloomington, MN 55437

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. – Healthcare Business Intelligence, Laura Madsen
9:30 – 10:00 a.m. – Break and Networking
10:00 – 11:00 a.m. – Continued: Healthcare Business Intelligence, Laura Madsen
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:

"BI Strategy, KPI’s and Leading Indicators"

Laura Madsen spearheads strategy and product development for the healthcare sector and works with key accounts across the country in the provider, payer, and healthcare manufacturing markets.   Even if you are not in the healthcare industry, learning about how they proactively monitor and measure their key performance indicators will still be fascinating and give insight on how other industries could learn from their lessons.

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

Minnesota Microsoft BI User Group 2014 Q2 Meeting–June 3

Posted by denglishbi on May 22, 2014

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, June 3. This meeting we will have two presentations starting out with a presentation on effective visualizations and the second one is a case study by Polaris on using the Microsoft BI tools to monitor warranty claims and resolve quality issues. 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, June 3, 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 : Show Me the Numbers: Five Principles for Creating Effective Data Visualizations
  • 4:15-4:30 : Break
  • 4:30-5:30 : Using Microsoft BI for Early Warning, Warranty and Quality Management
  • 5:30-6:00 : Social and Networking

Presentations:

Session 1: Show Me the Numbers: Five Principles for Creating Effective Data Visualizations

Data visualization skills are essential in today’s data environment. It allows for actionable insight and faster decisions. Data visualization is a key skill in the current data and analytics mission and the Microsoft BI and Office tools are important delivery vehicles for organizations looking to make sense of their data with great charts and dashboards.

However great visualizations require that we make good decisions around a few essential design principles. Many of us don’t consider ourselves as designers or well-equipped to make good design decisions. This session will try to help by validating the important role of data visualization and provide five principles that are key to extracting value from your growing data environment. These five principles are distilled directly from great data visualization thought leaders like Edward Tufte and Stephen Few. You will explore these principles with specific best practices that work, sprinkled with a sampling of charts and approaches that fail to deliver insight. We will explain why that 3D exploding pie chart that you occasionally see was not designed with these principles in mind. Additionally, the session will provide resources that you can use to help you make good decisions and to get inspiration.

Speaker: Don Frederisken

Don Frederiksen (@donfred) is currently Data Services Manager at G&K Services where he leads a team of data and business intelligence professionals. G&K Services, Inc. is a service-focused market leader of branded uniform and facility services programs in the United States, and is the largest such provider in Canada.

As a veteran information architect and manager, he has shepherded the launch of business intelligence and data management programs at four different companies. As a BI developer he has created dashboard solutions at two organizations. As an educator and entrepreneur, Don has over twenty years of experience in helping professionals and organizations understand and maximize their technology investments. 

Session 2: Using Microsoft BI for Early Warning, Warranty and Quality Management

Polaris Industries, a pioneer in the snowmobile industry, is one of the world’s largest off-road vehicle manufacturers. Polaris needed much better visibility to component failures on products. Warranty claims account for a significant amount of money and some components failures could even possibly result in safety concerns. By providing advanced notice of failures, the service and engineering teams can react faster to remedy the issues by quickly getting answers to questions like, ‘what components have the most failures over time,’ ‘what regions have the highest number of claims and why,’ ‘how many average miles on units with claims,’ and many other metrics.

In this presentation we will see how Polaris leverages data and Microsoft BI tools to make it easier to monitor warranty claims and other data to spot and resolve quality issues swiftly in order to achieve and maintain its commitment to quality.

Speakers: John Antholz and Michael Wissink

John Antholz has worked in IT as a developer, DBA, Data Architect and manager for over 20 years, and is currently the BI Manager at Polaris Industries. The past five years he has been focused on how companies can leverage data as a strategic asset by working to implement business intelligence solutions in a cost effective manner, which offer flexibility for all levels of the organization.

Michael Wissink has spent the past two years working in Business Intelligence and SharePoint Administration at Polaris. He has experience using many different BI tools and has done everything from ETL in SSIS to dashboards in PerformancePoint. With development experience in QlikView, PowerPivot, SSIS, SSRS, SSAS and PerformancePoint, he has a broad skill set and has delivered many quality analytics solutions.

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

PASS Business Analytics VC Meeting–May 29

Posted by denglishbi on May 20, 2014

The next PASS Business Analytics Virtual Chapter meeting is coming up next week. This month’s meeting is going to be talking about Power Query.

Here are the meeting details:

Date: Thursday, May 29BAVCLogo

Time: 4 to 5 p.m. (CDT)

Session: As data sources proliferate integration is becoming a key part of the analytical toolkit. Join Lee on a fact seeking journey as he uses Power Query to integrate and shape data.

Outline
1. Self service data integration – fact or fiction?
2. Power Query 101
3. Introduction to M
4. Data Enrichment

Presenter: Lee Hawthorn (b|t) is a Chartered Management Accountant who is responsible for BI and planning and analysis. Lee has worked on several BI projects. His battle scars have healed since Power BI arrived in his tray.

RSVP URL: http://bit.ly/PASSBAVC052914

Posted in Training | Tagged: , , , | 1 Comment »

“Hello Wisconsin” SQLSaturday Madison #287

Posted by denglishbi on March 19, 2014

The time is ticking and we are just a week and a half away from the SQLSaturday Madison event which kicks off on Friday, March 28 with three pre-conference events – SQLSaturday Madison #287 Pre-Cons Registration Now Open.  Then on Saturday the main event and the schedule is rockin’ with a jam packed day with presentations from the SQL community, MVPs, and MCMs – SQLSaturday Madison #287 Schedule.  Just to name a few there is Jonathan Kehayias, Joseph Sack, Lara Rubbelke, Paul Timmerman, Jason Strate, Jes Borland, Ted Krueger, Steve Jones, Brent Ozar, Kalen Delaney, and many more!sqlsat madison

I will be heading over to Madison Thursday and will be doing an all-day pre-con event Self-Service BI to the Max.  I am looking forward to going over the Power BI suite covering Power Query, Power Pivot, Power View, Power Map, and more.  As of right now there are still a few seats remaining, so if you are attending the event or are in the general area get signed up and join us:)

On Saturday I will be continuing the adventure and doing my talk on Delivering Self-Service BI with Power.

Delivering Self-Service BI with Power

In this session, we will discuss the enhancements and new features that are provided with Excel 2013 as Microsoft continues its roadmap with self-service BI. First we will go over the changes that have been made in Excel 2013, covering the new features. From there we will show how Power Pivot models can be used to integrate and load data to be used for analysis. Lastly, we will look at using Power View inside Excel to provide self-service reporting capabilities that are highly interactive.

So what are you waiting for, head over to the event site and checkout what is going on and follow the hashtag #sqlsatMadison – SQLSaturday Madison #287 event home.

Hope to see you there!

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

Minnesota Microsoft BI User Group 2014 Q1 Meeting–Feb 25

Posted by denglishbi on February 6, 2014

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, February 25. This meeting we will have two presentations starting out with a presentation on what the Data Scientist role is all about and then Mr. PowerPivotPro (b|t) will be in town to talk about…Power Pivot. Please register so that we can have your name badge pre-printed.image

MN Microsoft BI User Group 2014 Q1 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, February 25, 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 : You are a Data Scientist when…
  • 4:15-4:30 : Break
  • 4:30-5:30 : Visualizing Your Data with Microsoft Power View
  • 5:30-6:00 : Social and Networking

Presentations:

Session 1: You are a Data Scientist when…

New job title dubbed the most interesting job of the century, is causing many of us to rewrite our resumes and reassess our skills.  What is a Data Scientist?  How have our roles changed? How will our roles change in the future?  This talk will examine the abilities, tools, and business acumen to be considered this emerging title.  Ideas will be shared on how to work with management to obtain this recognition and mentor a group of peers to share knowledge.

Speaker:

Cheryl Stepney has over 40 years of experience with working with data to form insights that have affected the IT industry.  Having worked for Oracle Corporation and Macromedia as start-up organizations, she has a unique perspective on using and visualizing data.  She also worked for Microsoft to evangelize SQL Server for a five state district and continues to consult in all aspects of the data lifecycle.

Session 2: Fact or Fiction:  The “Free Lunch” Promise of Power Pivot

Dramatically shortened lead times, drastically reduced costs, AND “same day” agility:  these are the promises of the “Self-Service BI” generation.  These sorts of claims naturally elicit a healthy amount of skepticism.  We are, after all, analytical people, and we’ve learned that there are no “free lunches.”

So – do tools like Power Pivot deliver what they promise, and if so, our natural next question is “ok, what’s the catch?”

You are right – there IS a secret missing from the marketing and hype.  But it probably is not what you are expecting, and it is simpler than you would ever guess.

Come see “Skeptic turned High Priest” and former Microsoft engineer Rob Collie “de-cloak” these mysteries with firsthand experiences and hands-on demos.  Regardless of your background, you will never view data the same way. 

Warning:  learning these secrets has been known to re-vitalize your career.

Speaker: Rob Collie, @PowerPivotPro, Author of DAX formulas for PowerPivot

One of the founding engineers behind PowerPivot at Microsoft during his 14-year career in Redmond and former CTO at Pivotstream, Rob Collie is one of the world’s foremost authorities on self-service business intelligence and the revolutionary power of next-generation spreadsheet technology. His experience extends from software design and engineering through market strategy, and he is the author of the world’s #1-selling PowerPivot book.

Rob is currently in the process of launching a new software company in his areas of expertise, specifics to be announced later this spring. In the interim, he is advising and training organizations in their adoption of PowerPivot, using a complete-system approach that encompasses model and report design, collaboration with IT/DBA, server-based distribution, and cultural best practices.

BONUS: Get 5% on Rob Collie’s Online PowerPivot Training. At checkout use code MNBIUSR.

Link to purchase:  https://powerpivotpro.digitalchalk.com
20+ hours video on comprehensive Power Pivot 
Entertaining, easy-to-understand style 
Bonus e-book and guides
Concepts demystified via clear animations & examples
Designed for Excel people
Bulk discounts available for multiple attendees

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

Minnesota Microsoft BI User Group 2013 Q4 Meeting–Dec 3

Posted by denglishbi on November 26, 2013

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, December 3. This meeting we will have two presentations starting out with a presentation on BI in the Cloud with Azure Iaas and Power BI in Office 365 and then I will be presenting on Microsoft Power View. Please register so that we can have your name badge pre-printed.image

MN Microsoft BI User Group 2013 Q4 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, December 3, 2013image

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 : Extend BI to the Cloud with Azure and Office 365
  • 4:15-4:30 : Break
  • 4:30-5:30 : Visualizing Your Data with Microsoft Power View
  • 5:30-6:00 : Social and Networking

Presentations:

Session 1: Extend BI to the Cloud with Azure and Office 365

As mobile, social media, and data growth continue to fundamentally alter how companies operate, business leaders are beginning to look to the Cloud in order to achieve optimal performance while reducing costs. This presentation will show how you can extend and scale your BI infrastructure with simple set-ups and minimal maintenance using Microsoft Azure and Office 365. Demonstrations will include Azure IaaS, SharePoint and SQL Server; as well as the capabilities of Power BI with Office 365.

Speaker:

Chaitanya Khaladkar 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 Productivity and Business Intelligence platform. Chaitanya has worked on several successful solution development projects to build rich web and collaborative applications on SharePoint since 2005.

Session 2: Visualizing Your Data with Microsoft Power View

This session will cover how Power View can be used to provide highly interactive reporting solutions. We will go over the requirements; the layout of the new report authoring and data exploration tool; cover the basics of report authoring, filtering, and slicing; and the more advanced charting options with scatter, maps, and drill down. Who knew analyzing data could be so fun! Come and find out more and see how it all works.

Speaker:

Dan English is a Microsoft SQL Server MVP and is the BI Practice Manager at SCS. He has been developing with Microsoft technologies since 1996, with a focus on data warehousing and business intelligence for the past eight years. Dan has screencasts and videos on Vimeo, is an avid blogger and regularly posts on Twitter. Dan is currently on the leadership team for the MN Microsoft BI user group. He is also coauthor of the book “Visualizing Data with Microsoft Power View.”

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

 
Follow

Get every new post delivered to your Inbox.

Join 93 other followers