Saturday, April 22, 2017

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users


Thu, Apr 27 2017 20:00 GMT Daylight Time

Power BI Dashboard within an hour for Excel users


Power BI Dashboard within an hour for Excel users

If you are an experienced Excel user or Someone in your organisation mentioned about Power BI and you want to understand what you can do with it, then this session is for you. In this demo-focused session, Prathy will show how one can extract, transform, analyse and visualise the data using Microsoft Power BI. She will give a quick introduction to different features of Power BI, some of them are similar to Excel, and some are pretty new relate to Excel. Prathy will also talk about resources More...

Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organises London PASS Chapter. She is a regular speaker at events like SQL Saturdays and local user groups.

Wednesday, April 19, 2017

SQLShack Arcticle and Upcoming PASS Events

The latest article on SQLShack continues on the path of Data Warehouse development with SQL Server Analysis Services. The first step after designing the Data warehouse is conneting to the Data Source. All good DW implementations have a central database to store the data. Analysis Services is a great tool to centralize the business logic (or intelligence) - Connecting to Data Source(s) with SQL Server Analysis Services

Upcoming PASS Events

24 Hours of PASS – 24 back to back session June 29th-30th 2017

BA Marathon Recordings – Business Analytics last virtual sessions

Virtual Groups

Streamline SQL Implementations - Prakash Heda

In-Memory OLTP - What can it do for me? - Martin Catherall

Effortless Backups with Minion Backup - Jennifer McCown

Initial impressions of SQL Server v.Next Public Preview - Haidong Ji

Indexes: Everything You Wanted to Know -- Help or Hinder - Mike Byrd

ColumnStore Index in SQL Server 2016 and Azure SQL Database - Sunil Agarwal




SQLSaturday #594 - Edmonton 2017



SQLSaturday #621 - Silicon Valley 2017



SQLSaturday #623 - Israel 2017



SQLSaturday #598 - Costa Rica 2017



SQLSaturday #607 - Calgary 2017



SQLSaturday #619 - Rochester 2017


Tuesday, March 21, 2017

SSIS Articles on SQLShack

Please check out for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package or packages. The parameters are at the project level so you only have to change them once to effect multiple packages.

I use a simple example like changing the database name and server (instance) name for the Project level Connection Manage WHICH is another big change for SSIS. Starting in 2012, you can share connections among packages in a project. Enjoy!!!

Parametering Database Connection in SQL Server Integration Services

Deploying Packages to SQL Server Integration Services Catalog (SSISDB)

How to execute a Deployed Package from the SSIS Catalog with various options

Friday, March 17, 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session at or

Featured Presentation:  Improvements to Excel Pivot Tables
Alexander Lahuerta, Program Manager Microsoft

The Excel team is working on several interesting new features to Excel. Join us to take a look at some really interesting improvements to Excel that are soon to be released.

About Alexander:
I’m a Program Manager on the Excel Team at Microsoft. I’ve been here for three and a half years. For the past two years, I’ve been diving deep into Business Intelligence and making it easier for people to dig into their data. I want you to love PivotTables as much as I do.

Wed, Mar 22 2017 15:00 (UTC+00:00) Dublin, Edinburgh, Lisbon, London

Improvements to Excel Pivot Tables


Thursday, February 23, 2017

Upcoming PASS Events

There is a new website from PASS. Go to instead of The change does not really concern me but marketing is something I am not into…yet!!!

The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what I found coming up in the PASS community.


BA Marathon – Business Analytics

There will be six back-to-back live webinars and the next BA Marathon will be spring 2017.

While you wait, why not access recordings from previous Marathons?


Here are some Virtual Chapter Recordings

SQL Server DBA Tips That Can Save Your A$$ -- Part 2 - Guy Glantser

Implementing New Security Features in SQL Server 2016, Part 2 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Why Your Data Type Choices Matter - Andy Yun

Implementing (and cracking) new Security Features in SQL Server 2016, Part 1 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Take Power BI Visualizations to the Next Level - Reza Rad

Azure SQL Database Elastic Pool – introduction and usage scenarios – sponsored by Hewlett Packard Enterprise - Kun Cheng

How SQL Server 2016 SP1 Changes the Game - Parikshit Savjani

Advanced Power BI: Solving the Hard Problems - Devin Knight

An (Advanced) Introduction to DAX - Eugene Meidinger


Here are some upcoming SQLSaturdays

25 FEBRUARY - SQLSaturday #585 - Boston 2017


25 FEBRUARY - SQLSaturday #589 - Pordenone 2017


25 FEBRUARY - SQLSaturday #596 - Denver - BI Edition 2017


04 MARCH - SQLSaturday #603 - Dallas - BI Edition 2017


11 MARCHSQLSaturday #583 - Lisbon 2017


11 MARCH - SQLSaturday #592 - Raleigh 2017


11 MARCH - SQLSaturday #600 - Chicago 2017


Friday, January 27, 2017

Upcoming PASS Free Training

Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.

January, 2017


Introduction to Oracle SQL and PL SQL

More Details

February, 2017


Linux OS Fundamentals for the SQL Admin

More Details



More Details


Why Physical Database Design Matters By Kimberly L. Tripp

More Details


Partitioning Basics: Treating your tables like Lego

More Details


Detecting and Preparing for Corruption

More Details


Converting Unreliable Deployments Into Consistent Releases

More Details


Why Your Data Type Choices Matter

More Details


Feb 04, 2017    SQLSaturday #595 - Cleveland 2017

Feb 11, 2017    SQLSaturday #582 - Melbourne 2017

Feb 18, 2017    SQLSaturday #587 - Sydney 2017

Feb 18, 2017    SQLSaturday #586 - Guatemala 2017

Feb 25, 2017    SQLSaturday #589 - Pordenone 2017

Feb 25, 2017    SQLSaturday #596 - Denver - BI Edition 2017

Feb 25, 2017    SQLSaturday #585 - Boston 2017

Mar 04, 2017    SQLSaturday #603 - Dallas - BI Edition 2017


Saturday, January 14, 2017

Upcoming SQL Server Events from PASS

There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see “bad” tweets about one of these events.

image    image

SQLSaturday is just one of the many ways to earn about Microsoft Data Technologies. Click this link to see if an event is coming close to your town or city.

24 Hours of PASS happens a couple of times a year when there 24 hours of consecutive sessions. This is a Free event online.

Another way is to watch a virtual user group online for free. Click this link for a list of Virtual User Groups. Below is a list of upcoming events. This list can be viewed on the main page of for your profile after you login.

Upcoming Events of Interest

There is a View All link to see a drill down of all the events.

Paid events include Pre-conference sessions at SQL Saturday, a week of sessions at the SQL PASS Summit and the Business Analytics area just had their first Day of Business Analytics in Chicago.

An individual can create many ways to take advantage of these resources to advance in his or her career. I have seen many people get involved with PASS and totally change the direction of there career. Some in consulting, some with a new company or some even get to work for some of the great software companies that are sponsors of PASS events. Start at to find out what you can do to help in your current career or trying something new.