Dan English's BI Blog

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

Posts Tagged ‘training’

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

TDWI Minneapolis Chapter Event: Intro to Hadoop and NoSQL – Dec 10

Posted by denglishbi on November 18, 2013

The next TDWI Minneapolis Chapter meeting has been scheduled for Tuesday, December 10 and it will take place at the University of St. Thomas in St. Paul. The meeting will feature Dr. Brad Rubin  and r. Saeed Rahimi and they will be talking about Hadoop as well as NoSQL.

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

Here are all of the details:

When: Tuesday, December 10, 2013, 8:00 a.m. – 12:45 p.m.

Where:  St. Thomas University

McNeely Great Room – MCH100
University of St. Thomas
2115 Summit Avenue
St. Paul, Minnesota 55105

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. – Introduction to Hadoop, Dr. Brad Rubin
9:30 – 10:00 a.m. – Break and Networking
10:00 – 11:00 a.m. – NoSQL: how Pig, Hive, and HBase integrate to perform Analytics, Dr. Saeed Rahimi
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:

"Hadoop & NoSQL"

Dr. Rubin and Dr. Rahimi will talk about these two technologies and several others that have gained traction in the industry to deal with the increasingly massive amounts of data and the desire to efficiently analyze them and turn them into information.  The technologies provide alternatives to traditional SQL-based relational databases and are better optimized for the fast-growing amount of unstructured and semi-structured data.

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

PASSMN November 2013 Meeting

Posted by denglishbi on November 15, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, November 19. This month Mark Vaillancourt will be doing a presentation on the art of presenting.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group

The sponsor for this month’s meeting is Digineer.

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Agenda:

  • 4:00-4:30 : Registration / Networking / Announcements
  • 4:30-4:45 : DANGER: The Art and Science of Presenting by Mark Vaillancourt
  • 6:45-7:00 : Prizes / Giveaways

Please click here for meeting details and to RSVP for the event

Presentation

DANGER: The Art and Science of Presenting

Abstract: Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room–including you

About Mark: Mark Vaillancourt is an Information Management consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server for 5 years 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 »

PASSMN August 2013 Meeting

Posted by denglishbi on August 13, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, August 20. This month SQL Server MVP and Microsoft Certified Master Joe Sack will be presenting on resolving performance issues.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group

The sponsor for this month’s meeting is RBA.

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Live Meeting:

Agenda:

  • 4:30-5:00 : Registration / Networking / Announcements
  • 5:00-6:00 : Performance Issue Patterns by Joe Sack
  • 6:00-6:15 : Prizes / Giveaways

Please click here for meeting details and to RSVP for the event

Presentation

Performance Issue Patterns by Joe Sack

Abstract: While a SQL Server professional may encounter various one-off situations over the course of a career, there are also several shared patterns and scenarios.  In this session we’ll walk through a few of these patterns interactively – where I’ll reproduce the issue and we’ll work through the scenario until we get to the root cause.

About Joe: Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry.  Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability.  In 2006 Joe earned the “Microsoft Certified Master: SQL Server 2005” certification and in 2008 he earned the “Microsoft Certified Master: SQL Server 2008” certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011.

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 »

Final Call for the MN SQL Saturday 238 Speakers

Posted by denglishbi on August 10, 2013

This is the final call to submit your sessions for the Minnesota SQL Saturday event coming up in October. The speaker abstracts can be submitted through Tuesday, September 13 and then the fun begins to start selecting the sessions and setting up the official schedule.image

So far on 47 sessions have been submitted by 27 different speakers and 12 of those submitted more than one session.

If we do a breakdown of the current list that has been submitted it looks like the following so far:

image

Just a word of warning, if you have only submitted 1 session you might want to review the list that has already been submitted.  If your topic is a duplicate the chances of you making the final cut might be tough, particularly if the duplicate submission speaker only submitted 1 as well:)

So if you were holding out to submit a session to speak your time is up, time to submit.  If you already submitted, time to review the full list and re-evaluate your submission(s) to secure your spot.

Call for Speakers

Submitted Sessions

Good luck to all the speakers that submitted and can’t wait for the big event.

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

PASSMN July 2013 Meeting

Posted by denglishbi on July 20, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, July 23. This month SQL Server and Pragmatic Works founder Brian Knight is in town and will present.

Brian Knight is in town doing his two-day SSIS Master training course, something else to check out if you are available – http://pragmaticworks.com/LearningCenter/Workshops/DataIntegration/7-23-2013_MinneapolisMasterSSISWorkshop.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group

The sponsor for this month’s meeting is Pragmatic Works.

Pragmatic Works

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Live Meeting:

Agenda:

  • 5:00-5:30 : Announcements / Registration / hospitality / networking
  • 5:30-6:45 : Data Visualization Moves, by Brian Knight
  • 6:45-7:00 : Prize giveaways

Please click here for meeting details and to RSVP for the event

Presentation

Ninja Data Visualization Moves by Brian Knight

 

Abstract: PowerPivot and Power View brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before. See how the new PowerPivot and Power View features in Excel 2013 take your data to the next level of visualization. We’ll also show how you can visualize map data with GeoFlow and tie disparate data together with Data Explorer.

About Brian: Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He ran the local SQL Server user group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com. He is the author of more than a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

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

PASSMN July 2013 Meeting

Posted by denglishbi on July 2, 2013

The next Minnesota SQL Server User Group meeting is on Tuesday, July 23. This month SQL Server and Pragmatic Works founder Brian Knight is in town and will present. 

Brian Knight is in town doing his two-day SSIS Master training course, something else to check out if you are available – http://pragmaticworks.com/LearningCenter/Workshops/DataIntegration/7-23-2013_MinneapolisMasterSSISWorkshop.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group

The sponsor for this month’s meeting is Pragmatic Works.

Pragmatic Works

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Live Meeting:

Agenda:

  • 5:00-5:30 : Announcements / Registration / hospitality / networking
  • 5:30-6:45 : Data Visualization Moves, by Brian Knight
  • 6:45-7:00 : Prize giveaways

Please click here for meeting details and to RSVP for the event

Presentation

Ninja Data Visualization Moves by Brian Knight

Abstract: PowerPivot and Power View brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before. See how the new PowerPivot and Power View features in Excel 2013 take your data to the next level of visualization. We’ll also show how you can visualize map data with GeoFlow and tie disparate data together with Data Explorer.

About Brian: Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He ran the local SQL Server user group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com. He is the author of more than a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.

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

 
Follow

Get every new post delivered to your Inbox.

Join 90 other followers