Dan English's BI Blog

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

Posts Tagged ‘passbavc’

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!

Advertisements

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 »

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 »

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

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 »

PASS Business Analytics Day – Jan 11 in Chicago

Posted by denglishbi on November 3, 2016

Immerse yourself in a day of intense learning guided by expert speakers. Connect with like-minded business analytics professionals. Choose one of two in-depth full-day sessions packed with case studies and expert advice. Walk away with real-world analytics knowledge that you can use immediately! PASS BA Day Jan 17 Chicago

PASS Business Analytics Day – January 11 in Chicago (home of the World Series Champions – Chicago Cubs!!!)

Join us for an exceptional learning opportunity with leading experts. Choose from one of the two following sessions for $595:

image

Advanced Analytics Track: In-database Analytics with R and SQL Server 2016
Speakers: David Smith, R Community Lead, and Seth Mottaghinejad, Data Scientist, Microsoft
Learn More

Data Visualization Track: Mastering Power BI Solutions
Speaker: Paul Turley, Mentor with SolidQ, BI Architect, and Microsoft Data Platform MVP
Learn More

<<- REGISTER NOW –>>

Who Should Attend?

Whether you work in finance, operations, marketing, sales, or customer service, PASS Business Analytics Day is designed for professionals who want to improve their business and data analytics skill set and learn best practices for making data-driven decisions and recommendations. Join us in Chicago, IL for this opportunity to learn from world-class analytic leaders and to network with the local analytics community.

Seating is limited, so register now!

<<- REGISTER NOW –>>

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

PASS Business Analytics VC September Meeting – Building Real-Time Scorecards with Mobile Report Publisher

Posted by denglishbi on September 13, 2016

The next PASS Business Analytics Virtual Chapter meeting has been postponed and will be on Thursday, October 20.  We welcome George Carlisle who will be going over the new SQL Server Mobile Report Publisher that is available in SQL Server 2016.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

Oct 20 – Building Real-Time Scorecards with the Mobile Report Publisher

Abstract

Organizations are complex and there is a need to keep things simple. Scorecards can help and now the Mobile Report Publisher formerly the Datazen Publisher can make this data available on desktop and mobile so you can make the best decisions in real time. Information is vital to business today but many organizational leaders wonder how to stay focused on strategic goals with so much operational data at their fingertips? The Scorecard is a strategy performance management tool to help you do this.

Bios –

George Carlisle is building a cloud genetic cloud startup in Maryland. Prior to this, he worked at Ericsson, Verizon Federal, and Hewlett-Packard supporting global accounts in solution architect roles. Also, he is an Adobe, Intel and Microsoft Partner.

image

–> REGISTER NOW <–

If you are planning on attending the PASS Summit 2016 use the following discount code and save $150

Save $150 right now using discount code VC15BKR3

If you are interested in speaking at an upcoming PASS BA Virtual Chapter meeting we are always looking for speakers, please leave a comment or send us an email at PASSBAVC@SQLPASS.ORG

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