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 Summit 2017 Discount Code–VC15BKR3 (Save $150)

Posted by denglishbi on April 17, 2017

If you are planning on attending the PASS Summit conference this year use the following code and save $150 off registration!PASS Summit 2017

Discount Code: VC15BKR3

The sooner you register the cheaper the price will be too, next week the price will go up, so register now!

image

image

Hope to see you there!

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

PASS Business Analytics Day–June 21 Atlanta, GA

Posted by denglishbi on March 30, 2017

The 2nd PASS Business Analytics Day event is coming up and this time the location will be in Atlanta, GA on Friday, June 21.image

Once again there will be two tracks you can pick from, either Data Visualization focusing on Power BI and the other on Data Science.

There are two outstanding trainers setup featuring Patrick LeBlanc and Jen Underwood.

image

Get practical hands-on experience and guidance from the industry experts to increase your skillset and boost performance!

Register here –> http://bit.ly/passbadayjune21

Seating is limited, so sign up today!

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

Power BI Wide World Importers Demo Walk-Through

Posted by denglishbi on March 28, 2017

Last August at the MN Microsoft Power BI User Group I presented a walk-through of Power BI based on the new SQL Server 2016 sample database Wide World Importers.  I thought I had done a follow up post to share the content, but I believe I just posted this on the LinkedIn Group and possibly on Twitter and it might have been posted on the old user group site.

image

image

I apologize for not posting this on my blog as well for reference.  All of the files for the walk-through are available out on my OneDrive and this includes the presentation slides, Power BI sample files, instructions, logo, and DAX calculations. You can download the files individually or simply download the single zip file.

image

In this example I walk through the process of getting the data, building out the data model, and then performing the report development with the visualizations.

Here is a screenshot of what the final output looked like:

image

Sorry for the delay on posting this content and I hope you find it useful. If you like the example let me know and I can include some additional updates to this material and build it out a bit more.

Thanks and enjoy!

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

PASS Business Analytics Virtual Group March 21 – Excel to Power BI

Posted by denglishbi on March 14, 2017

The next PASS Business Analytics Virtual Group meeting will be next week on Tuesday, March 21.  We welcome Avi Singh who is a Microsoft Data Platform MVP, trainer, and author and he will be presenting on taking the leap from Excel to Power BI.PASSBA_Logo

–> REGISTER NOW <–

March 21– Excel to Power BI: 5 lessons you need to Unlearn to unlock Analytical Superpowers

Session Abstract

Are you struggling to make the transition from Excel to Power BI? As Avi Singh found out, through his own experience and that of hundreds of his students, there are key habits you need to UNLEARN before you can embrace the awesomeness of Power BI. Join us to learn what’s been holding you back.

Speaker Bio –

Avi Singh is a Power BI trainer and consultant based out of Seattle. He is a Microsoft MVP, co-author of the top-selling book “Power Pivot and Power BI: An Excel User’s Guide” and a regular speaker at conferences and user events. Avi has personally experienced the transformation and empowerment that Power BI can bring, going from an Excel user to building large-scale Power BI solutions. His mission now is to spread the word and share his knowledge about Power BI. You can follow him on his blog at www.avising.com or video blog at https://www.youtube.com/ModernExcel

–> REGISTER NOW <–

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

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

PASS Business Analytics Marathon–March 29

Posted by denglishbi on March 6, 2017

The next PASS Business Analytics (BA) Marathon is coming up this month on March 29 and there is a great list of topics and speakers lined up. Register now and get the sessions on your calendars in preparation for the big event.image

Register here – http://bit.ly/passbaspring2017

Here is the schedule:

  • Compelling Visuals in Power BI

    • 29 Mar 2017 17:00 GMT – Prathy Kamasani
    • In this demo-focused session, Prathy Kamasani will be using Airbnb dataset to walk through most of built-in and custom visualisations available in Power BI Desktop.Prathy will walk through how to use and format these visualisations to create compelling visualisations.We will also look at how we can use R visualisations in Power BI with minimal knowledge of R.

  • Power BI Twitter Brand Awareness Dashboard

    • 29 Mar 2017 18:00 GMT – David Moss
    • Just launched a media campaign, monitoring your brand awareness and you need to understand LIVE social media insights?David Moss Power BI Solutions Architect will show you how to summarise your live social media twitter streams in a single Power BI dashboard.Visualising and monitoring live Twitter trends and comments can assist to control social insights by addressing social interaction when and where it arises, help monitor positive & negative sentiments on your Twitter feed and drill down into specific tweets to reach out to your customers to manage & control your social brand awareness. Even find engagement opportunities and discover influencers and monitor @brand mentions and #hashtags.In this session you will learn about the Azure Power BI & Cortana Intelligence Suite architecture solution required for your Social Media Power BI dashboard.An exciting technical social media marketer’s brand awareness toolset.

  • Hands-On Data Analysis With Power BI Desktop

    • 29 Mar 2017 19:00 GMT – Koen Verbeeck
    • There are lots of flashy Power BI demos everywhere. But most of the time, you don’t see the internal mechanics. In this demo-heavy session, we’re going to build a Power BI demo from scratch. We’ll combine data from various sources, build a simple data model and start creating data visualizations. We’ll also take a quick look at the analytical capabilities of Power BI Desktop. After this session, you’ll have a good overview of the features Power BI Desktop has to offer and you can start your own data analytics journey.

  • Storytelling with Infographics

    • 29 Mar 2017 20:00 GMT – Jen Underwood
    • Visual storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of unprecedented data volumes, variety and velocities, infographics can help us make sense of the ocean of data. Telling an effective story through infographics requires accurate data, planning, compelling design, and visualization choices. Please join me in this fun, visual eye candy session to learn the art of storytelling with infographics.

  • Three Data Preparation Essentials for Predictive Modeling

    • 29 Mar 2017 21:00 GMT – Dean Abbott
    • Every predictive modeler or analytics professional knows the importance of data preparation; experts place the time expended in this stage from 50% to even 90% of the time one spends building predictive models. It is time-consuming and daunting because there are so many ways data can be wrong. Yet there are many principles that are reused in nearly every data set.This session focuses on three essential steps in data preparation, taking into consideration the data itself and how algorithms sometimes dictate the kinds of data preparation we do. The principles apply not only to predictive models, but also to data visualization and dashboards. Examples from actual modeling projects will illustrate the principles.

 

Register here – http://bit.ly/passbaspring2017

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

PASS Business Analytics Virtual Chapter January 26–Take Power BI Visualizations to the Next Level

Posted by denglishbi on January 25, 2017

The next PASS Business Analytics Virtual Chapter meeting will be tomorrow on Thursday, January 26.  We welcome back Reza Rad who is a Microsoft Data Platform MVP and BI Rockstar and he will be presenting on Power BI and data visualizations.PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

January 26 – Take Power BI Visualizations to the Next Level

Session Abstract

Visualization is the front end of every BI system, and getting it right will affect tremendously on the data analysis solution. In this session you will learn tips and tricks of data visualization with Power BI, examples of effective visualizations, and you will learn when is best to use which type of chart. You will learn about best way of visualizing elements through built-in visualizations or custom visuals.

Speaker Bio –

Reza Rad (http://www.radacad.com/reza) speaks in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis for seven years, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI book from Rookie to Rock Star (http://radacad.com/online-book-power-bi-from-rookie-to-rockstar).

–> REGISTER NOW <–

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

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

PASS Business Analytics VC December 20 – The Civic Technology Movement

Posted by denglishbi on December 13, 2016

The next PASS Business Analytics Virtual Chapter meeting will be next week on Tuesday, December 20.  We welcome Adam Hecktman who is Microsoft’s Directory of Technolgoy and Civic Innovation for Chicago who will be teaching us about the new Civic Technology movement.PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

December 20 – The Civic Technology Movement

Session Abstract

Civic Technology is a relatively new movement of people with technical skills who want to work towards the public good. Developers, designers, and…yes…data folks are working together to build tools to make our democracy work for everybody and to solve some of the most intractable social problems in cities around the country. But that is only part of the story. Learn what is being done and how you can participate by joining this webinar

Speaker Bio –

Adam J. Hecktman is Microsoft’s Director of Technology and Civic Innovation for Chicago. In this capacity, Adam helps Chicago’s civic leaders – and the communities they serve – use cutting-edge ideas around technology to solve the city’s biggest challenges. He provides thought leadership on the key issues and opportunities facing Chicago today and in the future.

Prior to this role, Adam was the Director of the Microsoft Technology Center – Chicago, helping organizations maximize business value and ensure long-term success when facing their toughest business challenges and opportunities. He has been with Microsoft in Chicago since 1991. Prior to Microsoft, Adam was a consultant for Accenture.

Adam received a Bachelor of Science in commerce and business administration from the University of Illinois at Urbana-Champaign and is pursuing his Masters of Data Science at the Illinois Institute of Technology. He regularly appears on television, print, and radio, and has authored numerous articles.

–> REGISTER NOW <–

Also, make sure you check out some of the other exciting events coming up:

The world of data and analytics is rapidly changing, and we’re pleased to offer the Business Analytics (BA) Marathon for data professionals looking to use data to make better business decisions. This edition features six back-to-back webinars focused on R and predictive analytics.

http://www.sqlpass.org/bamarathon/2016/december/Schedule.aspx

PASS BA Day 2017

Join us on January 11, 2017 in Chicago!

Immerse in a full day of intense learning guided by expert speakers. Connect with like-minded business analytics professionals. Walk away with real-world analytics knowledge that you can use immediately!

http://passbaday.com/2017/chicago/Home.aspx

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

MN PASS Microsoft BI User Group Meeting – Dec 12

Posted by denglishbi on December 6, 2016

The next MN Microsoft BI User Group meeting is on Monday, December 12. We will have two presentations, the first one is embedding Power BI in applications and the other is on Data Visualization best practices.

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

MN Microsoft BI User Group December 2016 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Monday, December 12, 2016

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

  • 12:45-1:30 : Check-In, Pizza, Networking
  • 1:30-1:45 : Microsoft BI User Group Updates and Announcements
  • 1:45-2:45 : Embedding Power BI Visuals within your application for internal and external users
  • 2:45-3:00 : Break
  • 3:00-4:00 : A Bigger Boat: Data Visualization Lessons from the Movie Theater
  • 4:00-4:30 : Wrap Up & Networking

Presentations:

Session 1: Embedding Power BI Visuals within your application for internal and external users

Power BI Visuals can be consumed in different ways and fashions. You can either consume them directly from PowerBI.com or by embedding them within applications (both for internal and external users). In this session, we will cover how to embed Power BI Visuals into application for internal users (using Power BI Developers API’s) and for external users (using Power BI Embedded).

Speaker: Prateek Gandhi, Data Platform Solution Architect

Prateek works at Microsoft as a Data Platform Solution Architect. As a Microsoft employee for the last 4.5 years, he has worked with several large enterprise customers in the Twin Cities helping them with SQL Server, Azure and SQL BI. He has also been working with Microsoft database technologies for the last 15 years with a lot of emphasis on SQL Server.

Session 2: A Bigger Boat: Data Visualization Lessons from the Movie Theater

When Chief Brody first sees the shark in Jaws, he carefully backs away from the stern of the Orca and quietly, but certainly, tells Quint, “You’re gonna need a bigger boat.” That one line, combined with a terrific delivery by Roy Sheider, packs a great deal of contextual information into six words.

Making efficient use of space to convey meaning is a vital part of good Data Visualization.

In this session, we will discuss the fundamentals of human visual perception, including the important distinction between Pre-Attentive and Attentive Processing. We will use examples from feature films like Jaws, Alien, and Sneakers to show important aspects of visual analysis around Color, Form, Position, and Motion. We will then put these concepts into practice via demos in Excel and Power BI. By the end of this session, you will have a solid understanding of the importance of data visualization and how to use it to enable better decisions.

Speaker: Mark Vaillancourt, Data Solutions Architect

Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. 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 »

PASS Business Analytics Marathon–Dec 14

Posted by denglishbi on November 18, 2016

Next month is the next PASS Business Analytics (BA) Marathon on Wednesday, December 14. Six great sessions to check out! I will be kicking it off as well, so please register and join me during the event!

Stay ahead of the curve in the rapidly changing business analytics (BA) field and join us for the latest edition of the BA Marathon on December 14, 2016.

Industry experts will deliver six back-to-back webinars on R, Power BI and predictive analytics – topics that are highly relevant to today’s BA professional. Attend any of the webinars or all six!

Webinar Date: Wednesday, December 14, 2016

Start time: 17:00 GMT

Session 1: Analyzing Healthcare Open Data with Power BI
Dan English, Senior Data Warehouse Architect, Constellation

Session 2: Big Data Analytics with SparkR
Jen Underwood, Founder of Impact Analytix, LLC

Session 3: Disrupt the Static Nature of BI with Predictive Anomaly Detection
Uri Maoz, Vice President of US business, Anodot

Session 4: Using R to Clean and Transform Small Data
Mark Wilcock, Technical Delivery Manager, ‎Credit Suisse

Session 5: Visualizing Multiple Time Series with R in Power BI
Bill McLellan, BI Team Lead and Sr. BI Solutions Specialist, TKC Holdings

Session 6: Real-World Predictive Analytics
Miguel Molina-Cosculluela, Managing Partner & Analytics Evangelist, Analytikus
Diwakar Rajagopal, Senior Director of Partnerships, Pyramid Analytics


Register for any of the webinars and even if you are unable to attend the live events, we’ll notify you to access the session recordings.

Thank you to our presenting sponsor

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

PASS Business Analytics VC December Meeting–R; One Ring to Rule Them All

Posted by denglishbi on November 18, 2016

The next PASS Business Analytics Virtual Chapter meeting will be next month on Wednesday, December 7.  We welcome Microsoft Data Platform MVP Leila Etaati who will be going over the use of R and the new capabilities provided with R Server and in SQL Server 2016.PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

December 7 – R; One Ring to Rule them All

Session Abstract

R is one of the most popular and powerful analytics languages. That helps data scientists to prepare data, predict data and visualize it. Microsoft offers several deployment options to bring next-generation advanced analytics to your business. Microsoft R Server delivers R-based analytics to where your data lives. In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data cleaning, visualization, and prediction will be presented. Subsequently, an introduction to using R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML and Power BI with R will be presented.

Speaker Bio –

Leila is a PhD, mentor, speaker, and Senior Consultant. She spoke in some important SQL server conference such as PASS Summit, PASS BA, 24 Hours of PASS, SQL Rally and Microsoft ignite New Zealand. 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 <–

Also, make sure you check out some of the other exciting events coming up:

The world of data and analytics is rapidly changing, and we’re pleased to offer the Business Analytics (BA) Marathon for data professionals looking to use data to make better business decisions. This edition features six back-to-back webinars focused on R and predictive analytics.

http://www.sqlpass.org/bamarathon/2016/december/Schedule.aspx

PASS BA Day 2017

Join us on January 11, 2017 in Chicago!

Immerse in a full day of intense learning guided by expert speakers. Connect with like-minded business analytics professionals. Walk away with real-world analytics knowledge that you can use immediately!

http://passbaday.com/2017/chicago/Home.aspx

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