Dan English's BI Blog

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

Posts Tagged ‘sqlpass’

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


– 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


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


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


  • 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


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


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.


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 »

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.


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!



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.


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 »

Analyzing Healthcare Open Data with Power BI

Posted by denglishbi on March 24, 2017

Back in December I presented the topic Analyzing Healthcare Open Data with Power BI at the PASS BA Marathon. I want to apologize for not posting this follow up post sooner, December was just a busy month with the holidays, vacations, and after that I just kept putting this off. Well no more, here is the follow up finally. In addition to this post I have also posted the Power BI example I prepared into the Data Stories Gallery.

Here is a screenshot of the demo that I presented which was based on the World Health Organization world wide expenditure data


The presentation material and a recording of the presentation is available on the PASS web site here – Analyzing Healthcare Open Data.

Just a heads up that during the presentation I lost my Internet wifi signal but it was only for a couple of minutes and I was able to get reconnected and resume the content from where I left off.

Here is a list of some of the Healthcare Open Data sites that I shared:

I would have liked to have spent more time on reviewing some of the sites listed above to showcase some of the data that is freely available, but with the technical difficulty I had to skip over that to allow time for the Power BI demo that I had planned and to allow time for Q&A. In the demo I showed some of the new capabilities in Power BI that were released such as the dropdown slicer option, forecasting, clustering, R visuals, Top N filtering, and a few more.

I will plan on revising the content and doing an updated version that hopefully I can present for the PASS Business Analytics Virtual Group later this year. There were a bunch of great questions asked and I am appreciative for the feedback that was provided from all of the attendees. I am glad people were able to walk away with a few nuggets of information regarding Healthcare Open Data and Power BI capabilities.

Posted in Power BI | Tagged: , , , , | 1 Comment »