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 VC July Meeting–How to calculate ROI of analytics

Posted by denglishbi on July 21, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up on Thursday, July 23.  This month we welcome Othniel Denis and will learn about ROI calculations.PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

July 23 – How to calculate ROI of analytics

Abstract

Whether you’re performing business analytics with small data or big data every project needs to deliver ROI (Return on Investment). This session will focus on teaching participants the fundamentals of ROI calculations. We will include case studies, best practices and common pitfalls to avoid.

Bio – Othniel is currently Principal of Excellent Ones Consulting LLC. His firm provides training on finance, Microsoft Excel and creates financial models for businesses. He brings with him a background in finance, training, and information management systems. Prior to opening his own firm, Othniel spent his 13 years in finance at various organizations. His responsibilities included: building financial models, forecasting revenue, developing budgets and analyzing data to support strategic decisions.

–> REGISTER NOW <–

This month we will also be giving away a $25 Amazon gift card as well!  You need to not only register for the event, but also attend in order to qualify for the give away.

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 VC June Meeting–Tools for Initial Exploratory Data Analysis

Posted by denglishbi on June 9, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up on Thursday, June 11.  This month we welcome Mark Wilcock and we are teaming up with the Data Science Virtual Chapter for this webcast.PASS_BAVC_Logo_New_201502

June 11 – Tools for Initial Exploratory Data Analysis

Abstract

We do exploratory data analysis (EDA) when we take a first look at the source data we will use in our analytics project. EDA helps us to get a good idea of the usefulness, relevance, completeness and quality of the data for our purposes and to explore patterns in the data to give us some insight. With this session we’ll explore a public dataset – the Titanic passenger list. Most people know the of the tragic events. The RMS Titanic sailed from Southampton on 10th April 1912, hit an iceberg in the Atlantic 4 days later and sank. Of the 2000 people on board, only 700 survived.

We’ll build some rough and ready visualisations and crunch some basic statistics on this dataset using 4 different tools

• Excel and Power Query as our benchmark,

• R with the ggplot2 graphics and dplyr data manipulation packages,

• Azure Machine Learning and

• the free starter edition of RapidMiner

The purpose of the session is to introduce you to some tools that you may not be familiar with so that you can decide which tools you prefer for exploring and analysis data. Or you may decide to use all these tools at different times for different tasks.

Bio – Mark Wilcock Mark Wilcock is an independent consultant specialising in the analysis, reporting and visualisation of financial data. Over the last 20 years, he has worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He is the organiser of the London Business Analytics Group (http://www.meetup.com/London-Business-Analytics-Group/), a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalised Medicine. He blogs intermittently at http://zomalex.co.uk.

–> REGISTER NOW <–image

This month we will also be giving away a $25 Amazon gift card as well!  You need to not only register for the event, but also attend in order to qualify for the give away.

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: , , | 1 Comment »

MN Microsoft BI User Group Special Edition Meeting–June 10

Posted by denglishbi on June 9, 2015

We are pleased to announce that there will be a Special Edition meeting tomorrow on June 10.  Devin Knight from Pragmatic Works is in town and he will be presenting on SSIS tomorrow night for our user group. Please register ahead of time and make sure to bring a photo id to get into the meeting.

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

MN Microsoft BI User Group 2015 Special Edition Meeting

Sponsored by:

image

Date: Wednesday, June 10, 2015

Check In: 5:00 PM Event Time: 5:30 PM – 7: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:

  • 5:00-5:30 : Registration, Announcements, Hospitality and Networking
  • 5:30-6:45 : Adapting your SSIS Solutions to use the Project Deployment Model
  • 6:45-7:00 : Prize giveaways sponsored by Pragmatic Works

Presentations:

Session: Adapting your SSIS Solutions to use the Project Deployment Model

SSIS in SQL Server 2012 had a significant overhaul to its architecture and it is important to understand how these changes can make your development life easier. These changes impact how you deploy, configure and manage SSIS packages. This session will guide you through how to integrate the features that come with the Project Deployment Model in SSIS into your solution as well as how you can upgrade existing solutions to use the new model.

Speaker: Devin Knight

Devin is the Training Director for Pragmatic Works. He is a Microsoft SQL Server MVP, an author of five SQL Server books and leads his local user group in Jacksonville (JSSUG).

PASS Summit Conference 2015 Discount Code – save $150 – LC15FML4

Members of the PASS Chapter, Minnesota Microsoft BI User Group can save $150 off their

PASS Summit 2015 registration by using the unique Chapter discount code: LC15FML4

http://sqlpass.org/summit/2015/RegisterNow.aspx

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

MN PASS BI User Group Q2 2015 Meeting – June 2

Posted by denglishbi on May 29, 2015

The next meeting for the Minnesota Microsoft BI User Group is next Tuesday, June 2.  This meeting will have two presentations, the first one is on the new Power BI Preview and the second one is on Datazen.  Please register so that we can have your name badge pre-printed.

*There will be a HP Stream 7 tablet given away during the networking session!
image

MN Microsoft BI User Group 2015 Q2 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Tuesday, June 2, 2015

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

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

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

Agenda:
  • 2:45-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : The “New” Power BI Service Walkthrough
  • 4:15-4:30 : Break
  • 4:30-5:30 : Achieving Enlightenment with Datazen. Anywhere!
  • 5:30-6:00 : Eval Collection, Prizes, Networking, and Pizza

*There will be a HP Stream 7 tablet given away during the networking session!

Presentations:
Session 1: The “New” Power BI Service Walkthrough

In this session, we will discuss the changes that are coming to Power BI and the new features that are provided with the Power BI Designer as Microsoft continues its roadmap with self-service BI. If you haven’t seen this yet, Power BI features are now available in a standalone application outside of Excel! You will see with the new designer that you will be able to easily integrate data, create stunning and interactive visualizations, and even create cloud based Power BI dashboards to share and it is even Free!! In this session we will also cover the mobile side of Power BI looking at the new Power BI apps for both Windows and iOS.

Speaker: Dan English

Dan English is the BI Practice Manager at Superior Consulting Service and is a SQL Server MVP, co-author, and technical editor. He has been developing with Microsoft technologies for over 15 years, and over 8 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 through 2014 and is getting ready to explore 2016. Dan has screencasts and videos on Vimeo, is an avid blogger, and tweets. Dan is on the executive leadership team for the MN Microsoft BI user group and the chapter leader for the PASS Business Analytics Virtual Chapter.

Session 2: Achieving Enlightenment with Datazen. Anywhere!

In this session we will examine the capabilities offered by Datazen, one of Microsoft’s latest acquisitions. Datazen allows you to present a highly customizable unified view of data across the enterprise. We will look at the authoring experience and integration with data sources ranging from ad hoc Excel reports to SQL Server and SSAS cubes.

The best part of it all? You can take everything with you. With native apps on Android, iOS, and Windows 8 and HTML5 rendering, your data is available anywhere, anytime.

Speaker: Greg Baldini

Greg Baldini is a BI Analyst with GNet Group. He is an experienced BI professional who has executed multiple projects delivering Enterprise BI and data warehouse solutions using the Microsoft BI Stack, which includes SSIS, SQL Server, Analysis Services, Power Pivot, Reporting Services, SharePoint, Power BI and Datazen. An expert in creating Agile BI solutions using PowerPivot/Tabular/ DAX. His experience spans verticals such as – manufacturing, healthcare, fraud analysis, marketing pipelines, and sales performance.

PASS Summit Conference 2015 Discount Code – save $150 – LC15FML4

Members of the PASS Chapter, Minnesota Microsoft BI User Group can save $150 off their

PASS Summit 2015 registration by using the unique Chapter discount code: LC15FML4

http://sqlpass.org/summit/2015/RegisterNow.aspx

Analytics with Power BI Workshop – 6/9,10 (Discount Code)

Pragmatic Works has created a discount code that will give users 25% off their workshop purchase. This code is valid until May 31, 2015
Discount Code: WSDISCOUNT

http://pragmaticworks.com/Training/Workshops/Business-Analytics/Schedule/6-9-2015_MinneapolisAnalyticswithPowerBIWorkshop

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

PASS Business Analytics VC May Meeting–The Art of Prototyping Analytics

Posted by denglishbi on May 27, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up tomorrow on Thursday, May 28.  This month we welcome Ken Raetz.

May 28 – The Art of Prototyping AnalyticsPASS_BAVC_Logo_New_201502

Abstract – Have you been underwhelmed by the promised enterprise data warehouse and business intelligence implementation? Do you find yourself stuck attempting to grow the use of analytics within your organization? Is your company culture still stuck in doing it the “long and hard way”? Does IT still hold the keys to implementing deep analytics? With the introduction of Power BI and a growing set of cloud-based analytics capabilities, Microsoft has opened the door to agile analytics and enterprise reporting capabilities. Like never before, leaders are able to develop and deliver the value of analytics “early and often”, and use this as a springboard to change the culture of analytics throughout the organization. Power BI can be a critical component of a corporate analytics strategy, and by empowering business users to do what they do best (analyze the business), IT and business leaders can finally begin to change the culture of analytics.

In this session, you will learn:

• To identify the barriers to changing your organization’s data culture

• To find ways to create a bridge between IT and business leaders to gain access to critical resources and people

• The importance of ROI on your analytics projects

• To use Excel and Power BI as an effective tool to develop prototypes and production-ready analytic solutions.

• How to empower key business leaders and analysts to further the data culture change throughout the organization.

Bio – Ken Raetz (b|t) a technology professional who has spent the past 15 years as a business intelligence and data warehouse architect, as well as a technical team manager for solutions across multiple BI platforms, including Cognos, Business Objects, Microsoft SQL Server and Power BI. In 2014, Ken stepped into the brave, new world of entrepreneurship, co-founding Think Data Insights, a company focused on helping companies of all sizes effect data culture change throughout their organizations.

–> REGISTER NOW <–

This month we will also be giving away a $25 Amazon gift card as well!  You need to not only register for the event, but also attend in order to qualify for the give away.

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: , , | 1 Comment »

PASS Business Analytics VC April Meeting – Transforming Reporting Requirements Into a Visual Masterpiece

Posted by denglishbi on April 2, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up next week on Thursday, April 9.  This month we welcome Microsoft SQL Server MVP Paul Turley.

April 9 – Transforming Reporting Requirements Into a Visual MasterpieceBAVCLogo (1)

Abstract – Starting with an understanding of user objectives and business needs, we’ll talk about choosing the right visual theme for a report or dashboard; choosing the right tool and then explore techniques to deliver a functional reporting experience. We’ll talk about reporting on different data sources such as a SQL Server data mart, SSAS multidimensional & SSAS Tabular model. We’ll also consider a choice of visualization tools like SSRS, Power View and Excel Services.

Bio – Paul Turley (Blog | LinkedIn | Twitter) is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.

–> REGISTER NOW <–

This month we will also be giving away a $25 Amazon gift card as well!  You need to not only register for the event, but also attend in order to qualify for the give away.

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 »

SQLSaturday #387 Madison–April 11 #SQLSatMadison

Posted by denglishbi on March 30, 2015

“Hello Wisconsin” round 2:)  We are just two weeks out now and the next SQLSaturday #387 Madison is coming up (interested, last year it was #287) on April 11, my second trip out to Madison, WI.  The event officially kicks off on Friday, April 10 with three pro-conference events image

Then on Saturday the main event will begin and the schedule is loaded with 8 tracks and 40 presentations!

I will be presenting at 10:30 in Room 309 (Track 5)

The "New" Power BI Self-Service Walkthrough

In this session, we will discuss the changes that are coming and the new features that are provided with the Power BI Designer as Microsoft continues its roadmap with self-service BI. If you haven’t seen this yet, Power BI features are now available in a standalone application outside of Excel! You will see with the new designer that you will be able to easily integrate data, create stunning and interactive visualizations, and even create cloud based Power BI dashboards to share and it is even Free!!

Heading out there with me from my team is Rick Bielawski and he will be in Room 220 (Track 2) at 9:00

Mastering queries into XML data.

If you’ve never queried an XML column you definitely want to attend. While targeted to beginners this isn’t a "Just do this" session. After this hour I’d like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.

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 #387 event home.

Hope to see you there!

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

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

Posted by denglishbi on February 24, 2015

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

February 26 – Crime Analytics & Predictions SystemBAVCLogo (1)

Abstract

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

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

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

Azure:
– HDInsight
– SQL Azure

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

AUDIENCE
Technical & Management leaders.

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

–> REGISTER NOW <–

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

image

image

image

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

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

MN PASS BI User Group Q1 2015 Meeting – March 3

Posted by denglishbi on February 12, 2015

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


image

MN Microsoft BI User Group 2015 Q1 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Tuesday, March 3, 2015

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

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

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

Agenda:

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

Presentations:

Session 1: Healthcare Case Study: DW and BI

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

Speaker: Ann Warner and Ross McNeely

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

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

Session 2: Power Query: Data Chemistry for the Masses

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

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

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

Speaker: Mark Vaillancourt

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

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

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

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

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

Posted by denglishbi on February 2, 2015

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

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

Session Title – Date/Time

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

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

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

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

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

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

RSVP NOW!

Click here to register for BA MARATHON!

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

Discount code: PASSBAVC

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

Enjoy!

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

 
Follow

Get every new post delivered to your Inbox.

Join 1,925 other followers