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

24 Hours of PASS Summit Preview July 19-20

Posted by denglishbi on July 12, 2017

The next 24 hours of PASS is coming up next week on July 19.  This is the preview edition getting everyone ready for the PASS Summit coming up at the end of October.

Here is a list of the scheduled sessions that will be showcased:image

  • Last Season’s Performance Tuning Techniques (Brent Ozar, Erik Darling)
  • Create and Load a Staging Environment from Scratch in an Hour with Biml (Scott Currie)
  • Writing User Stories and Slicing Epics for DW/BI Teams (Lynn Winterboer)
  • SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love. (Martin Wild)
  • Why Did My Clever Index Change Backfire? [Preview] (Kendra Little)
  • DevOps and the Agile DBA (Kellyn Pot’Vin-Gorman)
  • The SQL Server 2017 Availability Story on Linux (Allan Hirt)
  • Help me, Query Store. You’re My Only Hope (Erin Stellato)
  • Building Polyglot Data Solutions in Azure with Azure Cosmos DB (Sidney Andrews)
  • PowerShell ❤️ SQL Server: Modern Database Administration (Chrissy LeMaire, Constantine Kokkinos)
  • Melissa Data Session (To Be Announced)
  • A Lap Around Azure Big Data and MPP Offerings (Ike Ellis)
  • Implementing Advanced Analytics with SQL Server 2017 and Python (Ginger Grant)
  • Lessons on Linux for the SQL Server Professional (Joseph D’Antoni)
  • Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together (Paul Turley)
  • Virtual CPUs: Right to Ludicrous Speed (David Klee)
  • Azure SQL VM – Implementing Basic AG in SQL 2016 STD (Kenneth Urena)
  • Getting the most from SQL Server – Deploying and Optimizing on Hyperconverged Infrastructure (Greg White)
  • Tools and Tips: From Accidental to Efficient Data Warehouse Developer (Cathrine Wilhelmsen)
  • PowerShell for DBAs, What’s in it For Me? (Ben Miller)
  • SQL Server Data Compression (Kathi Kellenberger)
  • Becoming Proficient with Columnstore Indexes (Niko Neugebauer)
  • A Guided Tour of the SqlClient Namespace (Jay Robinson)
  • On Transactions and Atomic Operations (Gail Shaw)

Lots of outstanding topics and speakers lined up, I can’t wait!

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

Microsoft Data Insights Summit 2017 Sessions Available On-Demand

Posted by denglishbi on June 14, 2017

If you missed out on attending or watching the live streaming event the last two days you can now watch the content on the MS Power BI YouTube channel.

image

And if you missed out on the 2016 event, those videos are also available.

Enjoy!

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

MN PASS Microsoft BI User Group Meeting – Jun 19

Posted by denglishbi on June 12, 2017

The next MN Microsoft BI User Group meeting is on Monday, June 19. There will be two presentations, the first one is Analyzing Healthcare Open Data with Power BI (presented by me) and the other is Time Intelligence in DAX (by Marco Russo!).

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

MN Microsoft BI User Group June 2017 Meeting

Date: Monday, June 19, 2017

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

  • 3:45-4:00 : Check-In
  • 4:00-4:15 : Microsoft BI User Group Updates and Announcements
  • 4:15-5:15 : Analyzing Healthcare Open Data with Power BI (Dan English)
  • 5:15-6:00 : Break, Dinner, Networking
  • 6:00-7:00 : Time Intelligence in DAX (Marco Russo)
  • 7:00-7:30 : Closing / Prizes

Presentations:

Session 1: 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, 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!

Speaker: Dan English, Sr Data Warehouse Architect and Microsoft Data Platform MVP

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 2016 and test driving 2017! Dan has videos on YouTube and Vimeo, is blogger, and tweets. Dan is the group leader for the PASS Business Analytics Virtual Group.

Session 2: Time Intelligence in DAX

Time Intelligence is probably the most interesting feature of any analytical solution. Quick measures in Power BI can help you up to a certain point, because if you have more than one date column in your data model, it is also important creating the right data model, having the right Date table, and using the right DAX function to compute calculations such as Year-To-Date, Month-To-Date, Same-Period-Last-Year, and others.

In this session, you will see how to properly use time intelligence calculations in Power BI, avoiding data modeling and DAX mistakes, and using the right work around for the missing “Mark as Date table” feature that you have in Power Pivot.

Speaker: Marco Russo, Microsoft Data Platform MVP

Marco Russo is a Business Intelligence consultant and mentor. He has worked with Analysis Services since 1999, and written several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on www.sqlbi.com, mentoring companies’ users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, PASS BA Conference, and SQLBits.

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

PASS Business Analytics Marathon–June 7

Posted by denglishbi on May 22, 2017

The next PASS Business Analytics (BA) Marathon is coming up next month on June 7 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/passbasummer2017

  • Analyzing Real-Time Data Using Azure Streaming Analytics

    • 07 Jun 2017 17:00 GMT – Michael Johnson

      In today’s fast-paced world, businesses require up to the minute information to support critical decisions. Traditional business intelligence solutions, however, are not able to keep up with this demand and a new approach is required. Azure Stream Analytics is a real-time event processing engine capable of analyzing millions of events every second. During this session, you will learn some of the key concepts needed to work with streaming data before stepping through an end-to-end streaming data solution.


  • Replacing Brio: Practical Advice for Analysts

    • 07 Jun 2017 18:00 GMT – Julie Hyman
    • Brio, or Hyperion Interactive Reporting, was a staple of reporting for a long time. Following Oracle’s announcement to terminate premium support in April 2015, Brio users have been working without a safety net.

      During this session Quest product manager, Julie Hyman will examine the crossroads at which many organizations find themselves as they replace Brio. She will explain the environment, common use cases and must-haves for a self-service data preparation tool for reporting. Julie will go on to share how to safely move from Brio to a more modern self-service data preparation solution to:

      • Overcome challenges such as data-source proliferation, spreadsheet sprawl, manual processes and more.

      • Understand the top three workflows any reporting solution must handle efficiently.

      • Compare criteria for a replacement tool, such as integrating/preparing data, building queries and workflows, managing workloads and more.

      Julie will give you expert advice so you can move forward confidently while reducing risks.


  • From Hours to Milliseconds: Using GPUs to Accelerate Data Discovery and Visual Analytics

    • 07 Jun 2017 19:00 GMT – Todd Mostack
    • Technology advancements have created an explosion of human data — millions of tweets, hours of video, and patterns every day. However, analyzing and acting on this data in a timely manner is still prohibitive – until now. Born out of video game technology, GPUs are now being used to rapidly accelerate query times from hours to milliseconds for companies small and large. Todd will discuss how GPUs are disrupting the way we do data-driven business with lightning fast analytics and how business leaders can harness the tools available to them to explore and visualize data in real-time.


  • A Lazy Data Scientist’s Toolkit

    • 07 Jun 2017 20:00 GMT – Mark Wilcock
    • The client has some burning business questions and you have the client’s data. So which tools will help you to understand that data quickly and tell your client something they did not know already? In this session, Mark will take you through his personal choices, demo each of them, explain their value and show how quickly and easily the client can start making decisions with their data. The tools are

      • Tableau, a data visualisation tool, for exploring and presenting data beautifully,

      • R and packages for data manipulation, plotting, text mining and predictive analytics,

      • Excel – for pixel perfect reports,

      • Power BI, an analytics and visualisation tool, for doing just that!,

      • A SQL database in the cloud for improving data quality,

      • A cloud-based machine learning toolkit (Azure ML),

      • And cognitive services APIs for text analysis (and how to call them easily from R).

      We’ll use a wide variety of public datasets in our examples. These include:

      • The recent results of the strength of EU banks from the European Banking Authority,

      • Health, wealth and populations stats from the Gapminder foundation,

      • Lifespan data from the Lancet and the corporate responsibility reports from a large bank.

      The examples will also use some fictional data, but based on a real project, about a trading firm’s revenue reporting and other activities.

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

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

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 »