Dan English's BI Blog

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

Archive for the ‘Training’ Category

PASS Business Analytics Virtual Group Feb 21 “Using Self-service Analytics to Build Strong Data Teams”

Posted by denglishbi on February 15, 2018

The next PASS Business Analytics Virtual Group meeting will be next week on Wednesday, February 21.  We welcome Julie Hyman who will be talking to us about building strong data teams using self-service analytics.PASSBA_Logo

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

February 21 – Using Self-service Analytics to Build Strong Data Teams

Session Abstract

We understand that organizations like yours are looking for more efficient ways to tap into the data generated by your marketing and sales efforts, customer engagement, back-end operations, and more. If you want your business to be data-driven, you’ve got to strategically synthesize and analyze all of this data to turn it into actionable business intelligence. During this webcast, Quest product manager, Julie Hyman will explain the differences between full-service and self-service analytics, making the case for self-service as a way to eliminate analytic silos and data bottlenecks.

And, you’ll discover how the Toad solution helps create strong data teams:

• Non-technical business users can connect to nearly any data source.

• Users can standardize best analytics practices using a collaborative platform.

• Data teams can publish workflows and share information.

• Analysts can present fully prepped data to the rest of the business.

Speaker Bio –

Julie Hyman is a Sr. Product Manager for Quest Software. With 20+ years of experience in Development, Project Management and Product Management, Julie currently manages Toad Solutions, including Toad Data Point, Toad Intelligence Central and the new Toad Edge, among others.

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

Also, we will be doing a random drawing after the webinar and giving away seven $50 Amazon gift cards to anyone that attends and fills out the survey!

Advertisements

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

PASSMN February 2018 Meeting

Posted by denglishbi on February 12, 2018

The next Minnesota SQL Server User Group meeting is on Tuesday, February 20. This month I will be doing a presentation on how to use Power BI Desktop to build reports off SQL Server database information and creating a dashboard.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive and so that we will have an accurate headcount for ordering food.PASSMNLogo

The sponsor for this month’s meeting is DallasDBAs.

DallasDbas.com_KevinHill

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

Agenda:

  • 3:30-4:00 : Registration, Networking, and Food
  • 4:00-4:10 : Kickoff / Announcements
  • 4:10-5:25 : How to: Build a SQL Server Dashboard with Power BI (Dan English)
  • 5:25-5:35 : Closing

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

Presentation

How to: Build a SQL Server Dashboard with Power BI

Abstract: This session will provide an overview of Power BI tools including the Desktop, Service, and Mobile application. We will use Power BI to pull some information about SQL Server databases such as the count, sizes, last backup, recovery model, and file information. We will explore some of the recent capabilities that were added to Power BI Desktop like drill through and bookmarks. The example will be provided after the meeting so that you can review the code, try it out, and enhance the reports on your own.

About Dan: Dan is the Sr. Data Warehouse Architect at Constellation, Inc., a Microsoft Data Platform MVP, speaker, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 20 years, and over 13 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 and now using 2017! Dan has videos on YouTube and Vimeo, is blogger, and tweets. Dan is the group leader for the PASS Business Analytics Virtual Group and the Director of Technology for the MN SQL Server User Group.

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

PASS Business Analtyics Virtual Group Jan 25 “Power BI: How to take advantage of ArcGIS Maps, SandDance and Synoptic Panel”

Posted by denglishbi on January 22, 2018

The next PASS Business Analytics Virtual Group meeting will be this week on Thursday, January 25.  We welcome Marek Matuszewski who will be showing us some of the new cool data visualizations in Power BI.PASSBA_Logo

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

January 25 – Power BI: How to take advantage of ArcGIS Maps, SandDance and Synoptic Panel

Session Abstract

Join us and learn best practices and some of the most powerful features which are available in all 3 Power BI visuals: ArcGIS Maps, SandDance and Synoptic Panel.

Speaker Bio –

Marek is the Managing Partner & Head of Business Intelligence at the Efexcon AG,+8 years Software Development Experience, Business Intelligence Specialist, Entrepreneur, extraordinary performer, Visionary leader. In 2017 at – O365 Business Tag, Microsft Munich; CeBIT 2017 Hannover, Microsoft Partner stand; SQL Saturday 656 in Denmark, Microsoft Kopenhagen. First person in Germany who gave a speech at ALL German Power BI User Groups. One of his biggest audience was 40 000 people hearing him live, broadcasting an Audition about IT in the local radio station. He is very energetic and always give a lot of positive energy for the Audience. Power BI expert -one of his report “Regular Crimes in Central London” was featured on Microsoft Power BI blog.

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

Also, we will be doing a random drawing after the webinar and giving away eight $50 Amazon gift cards to anyone that attends and fills out the survey!

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

PASSMN January 2018 Meeting

Posted by denglishbi on January 11, 2018

The next Minnesota SQL Server User Group meeting is on Tuesday, January 16. This month Brian Glas will be doing a presentation on the impact of GDPR on database design and controls.

Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive and so that we will have an accurate headcount for ordering food.PASSMNLogo

 

The sponsors for this month’s meeting are nVisium and LRS Consulting Services.

 

nVisium Logo

LRS Consulting Services Logo

 

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

Agenda:

  • 4:00-4:10 : Kickoff / Announcements
  • 4:10-5:25 : GDPR (General Data Protection Regulation) overview and impact on database design and controls (Brian Glas)
  • 5:25-5:35 : Closing

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

Presentation

GDPR (General Data Protection Regulation) overview and impact on database design and controls

Abstract: The new European privacy law (General Data Protection Regulation or GDRP) is due to take effect on May 25, 2018. The GDPR is taking privacy law to a new level and will require changes for many companies and applications. We will cover a high level overview of GDPR and potential impacts on application and database design and controls.

About Brian: Brian Glas is the Director of Strategic Services at nVisium. He spends the majority of his time working with the Software Assurance Maturity Model (SAMM), building security programs and related processes, and working on Architecture Reviews/Threat Modeling.

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

PASS Business Analytics Virtual Group December 5 “What’s New SQL Server 2017 Reporting Services”

Posted by denglishbi on November 22, 2017

The next PASS Business Analytics Virtual Group meeting will be next week on Tuesday, December 5.  We welcome Anupama Natarajan who will be showing us some of the new features in SQL Server 2017 Reporting Services.PASSBA_Logo

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

November 29 – What’s New SQL Server 2017 Reporting Services

Session Abstract

In this session, you will get to know the new features that are released as part of SQL Server 2017 Reporting Services.

– Power BI Report Server

– REST API

– VS 2017 and Reporting Services

– MS Build Support

Speaker Bio –

Anu is a Software Professional with over 15 years experience in designing and developing Web, Data Warehouse, Business Intelligence and Mobile solutions. She is a Microsoft Certified Trainer (MCT) and really passionate in sharing knowledge. Anu loves solving complex business problems for her clients with innovative solutions using Microsoft Technologies and uses that experience in her trainings.

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

Also, we will be doing a random drawing after the webinar and giving away eight $50 Amazon gift cards to anyone that attends and fills out the survey!

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

PASS Business Analytics Virtual Group October 19 “R visual in Power BI: with pbiviz and ggplot2”

Posted by denglishbi on October 18, 2017

The next PASS Business Analytics Virtual Group meeting will be this week on Thursday, October 19.  We welcome back Leila Etaati who will be showing us how to use R to visualize data in Power BI.PASSBA_Logo

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

October 19 – R visual in Power BI: with pbiviz and ggplot2

Session Abstract

The integration of R inside Power BI provides lots of possibilities for doing machine learning and providing more data visualization options. In this session, I will first show how to write R code inside the R visualization area. Then, how to create some visuals that we do not have currently in Power BI visualizations like Slope chart, Facet chart and Column width chart with the help of ggplot2 package. Moreover, there is a possibility to create your own custom visual as pbiviz file by writing R codes and importing it into your Power BI report. I will go through the process of creating a pbiviz file.

Speaker Bio –

Leila is a Microsoft Data Platform MVP, PhD, mentor, speaker, trainer, and consultant. She spoke in some important SQL server conference such as Data insight Summit, SQLNexus, SQL Rally and Microsoft ignite New Zealand, PASS BA, PASS 24 H, and so on. She has over 10 years’ experience working with SQL server. She was involved in many large-scale projects for big sized companies as SQL server and BI consultant. She worked in Industries including banking financial, power and utility, manufacturing .Leila is PhD of Information System department, University of Auckland, New Zealand. She is a lecturer of BI and Machine Learning courses.

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

Also, we will be doing a random drawing after the webinar and giving away eight $50 Amazon gift cards to anyone that attends and fills out the survey!

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

PASS Business Analytics Virtual Group September 21 “Visualizing Financial And Economic Data”

Posted by denglishbi on September 18, 2017

The next PASS Business Analytics Virtual Group meeting will be this week on Thursday, September 21.  We welcome back Mark Wilcock who will be showing us how to visualize financial and economic data using Power BI and R.PASSBA_Logo

–> REGISTER NOW <–

September 21 – Visualizing Financial And Economic Data (Using Power BI and R)

Session Abstract

Firms make massive efforts to collect, clean, aggregate and report on their data but this is only meaningful when people use it to get insight, make better then take action. We’ll show several examples of visualisations of financial and economic data, and discuss how they were built and analyse how effective they are. These examples include market risk chart to compare trading profit & loss (P&L) against measures of risk and regulatory limits and a version of the famous visualisation by Hans Rosling of the health and wealth of nations over 200 years, and also many others.

Speaker Bio –

Mark Wilcock is an independent consultant specializing in the analysis, reporting and visualization of financial data. Over the last 20 years, he worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He’s the organizer of the London Business Analytics Group, a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalized Medicine. He blogs at zomalex.co.uk

–> REGISTER NOW <–

Also, we will be doing a random drawing after the webinar and giving away eight $50 Amazon gift cards to anyone that attends and fills out the survey, we will also be giving away a free comp to the PASS Summit (assuming you haven’t already registered and can use the complimentary invite)!

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

MN SQLSaturday #682–Oct 7

Posted by denglishbi on August 31, 2017

The schedule has been posted for this year’s Minnesota SQLSaturday event which will be held on October 7 at Saint Paul College.SQLSaturday #682 - Minnesota 2017

I will be speaking in the afternoon on Analyzing Healthcare Open Data with Power BI.

In this session we will explore and evaluate Healthcare data that is freely available to the public. You will see how easily we can consume and integrate the data to analyze and investigate. In the demos you will see some of the latest enhancements and features that have been included with Power BI such as ArcGIS (Esri) maps, forecasting, Top N filtering, grouping / binning, clustering, custom R visuals, and maybe a few more along the way. If you are interested in Open Data, Healthcare, or have to perform a lot of data manipulation in Excel or other tools to provide analysis for your job then this is the session for you. Leverage the free capabilities of Power BI, advanced analytics, and help simplify your everyday workload and wow your boss!

image

Hope to see you there!

Posted in Training | Tagged: , , , | 2 Comments »

MN PASS Microsoft BI User Group Meeting–Aug 28

Posted by denglishbi on August 25, 2017

The next MN Microsoft BI User Group meeting is next week on Monday, August 28. There will be two presentations, the first one is an introduction to Machine Learning and the other is using maps in Power BI.

Please Register Now (Please register so that your name badge is pre-printed)

MN Microsoft BI User Group August 2017 Meeting

Date: Monday, August 28, 2017

Check In: 1:00 PM Event Time: 1:15 PM – 4:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435

Please Register Now (Please register so that your name badge is pre-printed)

Agenda:

  • 1:00-1:15 : Check-In
  • 1:15-1:30 : Microsoft BI User Group Updates and Announcements
  • 1:30-2:15 : Intro to Machine Learning (Jared)
  • 2:15-3:00 : Pizza & Networking
  • 3:00-3:45 : How to become a data surveyor: Maps in Power BI (Alex)
  • 3:45-4:00 : Closing & Giveaways

Presentations:

Session 1: Intro to Machine Learning

Come to this session to get your toes wet with machine learning. What types of questions it can answer? What types of models it can produce? What are some techniques used? There will be practical demos using Azure Machine Learning as well. Enough info to get you started, or enough to quit while you’re ahead, either way, you’ll come out with some concrete ideas of what ML is all about.

Speaker: Jared Zagelbaum

Jared Zagelbaum is a highly experienced IT professional, specializing in the Microsoft Data Platform suite of technologies since 2007. He expertly leads projects and teams through enterprise solution design and implementation for data management, analytics, and information delivery.

Jared regularly speaks at user groups and events across the Midwest, as well as blogging and providing technical review for SQL Server publications. He is a Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics, and a graduate of the University of Florida with a BS in Finance, Accounting and Economics. https://jaredzagelbaum.wordpress.com/about/

Session 2: How to become a data surveyor: Maps in Power BI

Have you been using maps in Power BI to present your geographic data? Do you want to map your data to see what cities have the best sales, but don’t know where to begin? Join us in this session to learn the practical steps to mapping your data, what you need to get started, and how to make beautiful maps to see your data in a whole new light. We will also discuss when you may not want to map your data, and some of the roadblocks you might encounter.

Speaker: Alex Barbeau

Alex Barbeau is a BI Consultant with Nihilent Technologies, focusing on SSAS, data modeling, and EDW design. Alex has extensive experience in designing and developing analytics and reporting solutions in Sales, Manufacturing, Inventory Management, Healthcare, and Commodities verticals across the span of the Microsoft BI platform.

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

PASS Business Analytics Virtual Group August 17 “R-Ternatives in Power BI”

Posted by denglishbi on August 16, 2017

The next PASS Business Analytics Virtual Group meeting will be tomorrow on Thursday, August 17.  We welcome Ryan Wade who will be showing us the different options for utilizing R code in Power BI.PASSBA_Logo

–> REGISTER NOW <–

August 17 – R-Ternatives in Power BI

Session Abstract

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI. There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, or you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

Speaker Bio –

Ryan Wade is a data analytic professional with close to 20 years of experience. My education and work experience enables me to understand things from a technical, analytical, and business viewpoint. I have the ability to present complex data in an intuitive way using sound analytical and visualization methods. I have an advanced analytical and technical skill-set. My technical background includes the following tools and programming languages: Power BI, T-SQL, Excel, DAX, M, R, SQL Server R Services, Python, VBA, Office 365, SSIS, SSRS, & SSAS Tabular. I also have an elementary understanding of Azure ML and Octave.

–> REGISTER NOW <–

Also, we will be doing a random drawing after the webinar and giving away eight $25 Amazon gift cards to anyone that attends and fills out the survey!

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