Dan English's BI Blog

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

Posts Tagged ‘msbimn’

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 »

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 »

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 »

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 »

Minnesota Microsoft BI User Group 2013 Q3 Meeting–Sep 10

Posted by denglishbi on August 12, 2013

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, September 10. This meeting we will have two presentations starting out with a presentation on master data management (MDM) and master data services (MDS) and then a presentation on parallel data warehouse (PDW). Please register so that we can have your name badge pre-printed.image

Are you planning to attend the PASS 2013 Summit October 15 – 18 in Charlotte, NC? Use the MS BI User Group discount code and receive 10% off!

Your chapter: Minnesota Microsoft BI User Group

Unique Discount Code: SUM156CH

To register for PASS 2013, click here: http://www.sqlpass.org/summit/2013/

Here is the remaining schedule for the quarterly meetings this year:

2013 Meeting Schedule

  • Tuesday, September 10
  • Tuesday, December 3

MN Microsoft BI User Group 2013 Q3 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, September 10, 2013

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 : Master Data Management and Microsoft Master Data Services
  • 4:15-4:30 : Break
  • 4:30-5:45 : Recognizing The Parallel Data Warehouse (PDW) Workload
  • 5:45-6:00 : Social and Networking

Presentations:

Session 1: Master Data Management and Microsoft Master Data Services

As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you ensure that your MDS data is up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project

Speaker:

Jeff Prom, Data Architect , Silver Bay Realy Trust Corp – Jeff Prom is a Data and BI Developer with over 15 years of experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect.

Session 2: Recognizing The Parallel Data Warehouse (PDW) Workload

If you are like many, you’ve been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft’s appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads.  But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture?  In this session, we’ll review that question and more with a run through of how to identify MPP workloads?  As part of the session, we’ll also review some of the key components and differentiators of the PDW platform.

Speakers:

Jason Strate, SQL Server Database Architect, Pragmatic Works – Jason Strate is a SQL Server database architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms.  As a PASS community member, Jason has lead user groups, organized SQL Saturdays, and is currently a Regional Mentor for PASS’s North Central US region.  Jason is a well-known presenter and author on SQL Server and data platform topics.  He has been author or editor on five books and blogging at www.jasonstrate.com.  He’s also presented at the PASS Summit, TechEd NA, dozens of SQL Saturdays, and other SQL Server community events.  And if that isn’t enough, he’s never been too far away from the karaoke after parties which may include an occasional unicorn.

Sanjay Kaul, Technology Specialist, Microsoft – Sanjay Kaul is a Technology Specialist at Microsoft who specializes in helping customers envision, design, and deploy data life cycle, data warehouse, and business intelligence focused solutions using the Microsoft platform. In his 12th year at Microsoft, Sanjay has spent time in Microsoft’s consulting group, enterprise SQL Server sales, SQL Server & BI Architect at the Microsoft Technology Center in Minneapolis, before moving to his current role of Data Warehouse Technology Specialist. With all the experience gained in the industry ranging from data architecture, disaster recovery planning, governance, database optimization, and data warehousing, his goal is to gain a deep understanding of the customer’s needs and help create solutions that exactly meet their needs.

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

Minnesota Microsoft BI User Group 2013 Q2 Meeting–Jun 4

Posted by denglishbi on May 14, 2013

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, June 4. This meeting we will have two presentations starting out with a case study by Smead on replacing IBM Cognos BI with Microsoft BI and then a presentation on Excel 2013 with Data Explorer, GeoFlow, and Power View. Please register so that we can have your name badge pre-printed.image

Are you planning to attend the PASS 2013 Summit October 15 – 18 in Charlotte, NC? Use the MS BI User Group discount code and receive 10% off!

Your chapter: Minnesota Microsoft BI User Group

Unique Discount Code: SUM156CH

To register for PASS 2013, click here: http://www.sqlpass.org/summit/2013/

Here is the remaining schedule for the quarterly meetings this year:

2013 Meeting Schedule

  • Tuesday, June 4
  • Tuesday, September 10
  • Tuesday, December 3

MN Microsoft BI User Group 2013 Q2 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, June 4, 2013

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 : Smead Case Study: Introducing a New BI Toolset
  • 4:15-4:30 : Break
  • 4:30-5:30 : Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View Maps
  • 5:30-6:00 : Social and Networking

Presentations:

Session 1: Smead Case Study: Introducing a New BI Toolset
Smead Manufacturing Company recently completed a migration project that replaced their IBM Cognos BI Toolset with the Microsoft suite of BI Tools (SharePoint Integrated). In this presentation, they will share their approach, benefits, challenges and insights as they introduced new BI Technologies to 100 users across 12 departments. Many aspects of their journey will be covered, including use of the MS tools, data and architecture considerations, implementations, training, and project management. Whether your role focuses on development, analysis, and/or management, learn from their experiences as they replaced a legacy toolset that was relied upon by many as their source of timely, detailed Business Intelligence information.

Speakers:

Cindy Kummer, Lead EDW/BI Analyst at Smead Manufacturing Company – Cindy has held a number of positions in the IT industry for 14 years, spending the last 4 years in the Business Intelligence arena as the Team Lead for the EDW/BI team at Smead Manufacturing Company in Hastings, MN. She recently led their project to migrate their BI platform from IBM Cognos to the suite of Microsoft BI Tools. Cindy has been involved in projects in the Transportation, Insurance, and Manufacturing industries with a wide variety of roles, including developer, analyst, and project manager.

Will Weber, BI Consultant – Will is currently working as a business intelligence consultant in the Twin Cities. He started his career as a juggler. Almost got a degree in Theatre. Actually got a degree in Chinese. He’s a Board member for the MNPASS user group. He also thinks that the robots probably won’t rise up against their human creators – probably. But we’ll have to wait and see on that one.

Session 2: Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View Maps
Business Intelligence has now been a global discipline for several years, and with new Microsoft tools you can now bring the globe to Business Intelligence. Microsoft Data Explorer for Excel 2013 enables you to access, harness, transform, and mash-up data like never before. Data that is separated by source type, format, location and more will be reviewed and mashed up in Data Explorer. GeoFlow is a new geospatial Business Intelligence tool which literally adds another dimension to data visualization. The power of GeoFlow to transform inanimate data into a story will be demonstrated. Power View for Excel 2013 has the capability to recognize geospatial data and create reports that integrate with Bing Maps, enabling global data BI report development from a desktop computer. The ease of use, intuitive design, and value of maps with Power View 2013 will be reviewed with some interesting examples leveraging publically available data. Take your data global.literally.

Speaker:

Greg Beaumont, BI Architect at GNet Group – Greg Beaumont is a Business Intelligence Consultant at GNet Group. He joined GNet Group in 2009, and has industry vertical experience including healthcare, manufacturing, logistics, retail, and public/government data. His professional focus is upon building industry standard reporting methodologies into BI solutions. He enjoys staying up-to-date with technology related to his career within the world of Microsoft BI.

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

Minnesota Microsoft BI User Group 2013 Q1 Meeting Follow Up

Posted by denglishbi on April 15, 2013

Just wanted to do a quick post to let everyone know that the presentations and demos from the last MN Microsoft BI User Group meeting are available for download.  This includes the opening announcement materials for the meeting, Brian Larson’s Reporting Services demos, and Ross McNeely’s top down data modeling presentation.image

You can access the material from the user group site in the past events and presentations location.

Effective Reporting through SSRS and Top Down Data Modeling for BI

Thanks to everyone that attended, it was a great turnout and special thanks to C2 for the post-event happy hour.

Next month we will be sending out the invite for our next meeting that will be on Tuesday, June 4th, so stay tuned.

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

Minnesota Microsoft BI User Group 2013 Q1 Meeting–Mar 28

Posted by denglishbi on February 15, 2013

UPDATE (3/22/2013): Because of the snow storm on March 5 the meeting was rescheduled and is on March 28.

The next MN Microsoft Business Intelligence User Group is coming up on Thursday, March 28. This meeting we will have two presentations starting out with a talk on Reporting Services (SSRS) and then a presentation about Data Modeling. Please register so that we can have your name badge pre-printed.image

Here is the schedule for the quarterly meetings this year:

2013 Meeting Schedule

  • Thursday, March 28
  • Tuesday, June 4
  • Tuesday, September 10
  • Tuesday, December 3

MN Microsoft BI User Group 2013 Q1 Meeting

Sponsored by:

MSFT_logo_Page

Date: Thursday, March 28, 2013

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 : Effective Reporting through SSRS Advanced Authoring Features (Brian Larson)
  • 4:15-4:30 : Break
  • 4:30-5:30 : Top-Down Data Modeling for BI (Ross McNeely)
  • 5:30-6:00 : Social and Networking
  • 6:00: Happy Hour Sponsored by C2 at Macaroni Grill! 7651 France Ave S, Edina, MN 55435

Presentations:

Effective Reporting through SSRS Advanced Authoring Features – Effective reporting is not simply the output of data, but the meaningful presentation of that data in a manner that informs the user. SQL Server Reporting Services provides a myriad of features to create a clear, instructive, and interactive experience. This session will demonstrate techniques to utilize SSRS advanced authoring features to facilitate more informative communication. These features include: nesting data regions, leveraging scope, geographic/geometric reporting, complex charting, rich formatting, incorporating managed code assemblies, intuitive drilldown, data from multiple datasets in a single data region, datasets that update source data, and more.

Brian Larson, Vice President of Technology, Superior Consulting Services. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the Vice President of Technology for Superior Consulting Services and has presented at national conferences including SQL Server Connections, the PASS Summit, and the Microsoft BI Conference. Brian is a former columnist for SQL Server Magazine and 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,” all from McGraw-Hill Professional.

Top-Down Data Modeling for BI – Business Intelligence platforms are offering capabilities, such as, in-memory analytics, ad hoc reporting, and self-serve report development. These capabilities allow for rapid development and do not require a Data Warehouse. A Business Intelligence platform without a Data Warehouse works well during the pilot phase, but tends to fail when deployed to the enterprise. Join as I lay out how to implement a Top-Down Data Model that will allow Business Intelligence to be created before or in parallel with the Data Warehouse. This will allow for rapid BI development while reducing the DW development cycle.

Ross McNeely, BI Practice Manager,  C2 IT Solutions. Ross has presented at several SQL Saturday events in Minnesota, Wisconsin, and Iowa. Recently, Ross presented at ERWorld2012 on data modeling. Ross adds real-world examples from the Financial Services, Logistics, and Retail 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. Please join Ross McNeely for a fun and informative meeting.

This is our first meeting of the year and our first meeting as an official chapter of PASS, looking forward to a great meeting, hope to see you there!

image

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

MN Microsoft BI User Group Official Chapter of PASS!

Posted by denglishbi on December 18, 2012

Just a quick announcement that I am happy to announce, yesterday the Minnesota Microsoft Business Intelligence (MSBIMN) user group completed the process and is now officially affiliated with the national PASS association.  The user group is part of the U.S. North Central region.  I am really excited about this and looking forward to another exciting year in 2013 when we resume our meetings.image  You can check out the content from our 2011 and 2012 meetings here – past presentation content.

The Leadership Team

  • Neelesh Raheja, GNet Group
  • Dan English, Superior Consulting Services
  • Terry McDonald, Pentair Technical Products
  • Jin Cho, Microsoft

2013 Meeting Schedule

  • Tuesday, March 5
  • Tuesday, June 4
  • Tuesday, September 10
  • Tuesday, December 3

In 2013 we are also planning on organizing a couple of special session meetings, stay tuned for information about those as well and to stay in touch don’t forget we also have a group setup on LinkedIn that you can get associated with.

Thanks to everyone on the Leadership Team, the speakers, and the user group for another great year! 

Happy holidays to everyone and see you all next year!

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

 
Follow

Get every new post delivered to your Inbox.

Join 93 other followers