PASS BA Conference Blog


From the BI/BA Blogosphere: March 29 Update

It's a Good Friday to catch up on your business intelligence and analytics reading with the community's top bloggers:

Why I Am Attending PASS Business Analytics Conference in Chicago

Cross-posted from BI with an accent...
By Rafael Salas

The PASS BA Conference is less than 3 weeks away, and if you are still pondering whether to attend, let me share with you a few good reasons – my reasons, of course – to attend.

  1. Catching Up. The last couple of years, the analytics and BI landscape has experienced dramatic changes as new technologies make their way in, and the heavy buzzword marketing machinery from vendors makes it harder to separate the wheat from the shaft. You can use this conference to see if Big Data is really for you, or to get your head around advanced data analytics, and perhaps to find out if data science is real or just marketing fiction.
  2. Agenda & Speakers. The lineup of speakers is great, and the topics are well balanced across 5 different tracks that promise to deliver first-hand, real-world experiences: Big Data, Advanced Analytics, Data Visualization, Information Delivery and Collaboration, and Strategy and Architecture.
  3. Networking. Yes, the usual but important part we tend to miss when we go to conferences. Being around 1000s of professionals with similar challenges and interests is a unique opportunity to get connected and learn how others are doing it.

I will be one of the PASS networking ambassadors for Thursday's evening event and will be hanging out at either the Experience Lounge or the Microsoft Kiosk, so if you decide to attend,  please make sure to stop by and say "Hi."

This is a 2-day conference plus a pre-conference day. Registrations are still open, and you can get $200 off the registration fee by using  code BAC945MVP.

Contest: Win the BA Conference Session Recordings!

Watch Twitter (#passbac) and Facebook Wednesday this week through Monday next week for a chance to win one of 10 PASS Business Analytics Conference session recordings, featuring 60+ conference sessions and the Microsoft keynote.

We’ll be asking questions from the following PASS Business Analytics Virtual Chapter webinars (Hint: check out the archives to refresh your memory or catch up if you missed them). We’ll be drawing daily from all the correct answers. Good luck!

A Case for Business Analytics Learning – Mark Tabladillo

What’s New for BI in Excel 2013? – Chris Webb

A Big Data Primer – Stacia Misner

Terms and Conditions: 
No refunds will be issued for conference session recordings already purchased by competition winners.

From the BI/BA Blogosphere: March 22 Update

It's been a busy week! Catch your breath and catch up on what's happening in the business intelligence and analytics world with the community's top bloggers, including a special Big Data focus and a Stephen Few editorial to ponder over the weekend:


'How is your role becoming more analytics focused' Facebook Competition Answers

With under a month to go before the inaugural PASS Business Analytics Conference, the industry is buzzing about business intelligence and business analytics. We asked our @passbac and PASS BA Conference Facebook followers how their roles are becoming more analytics focused and awarded five registration passes to the conference for the best answers. Some great insights and experiences were shared, and we’ve compiled them for your interest:

As the only DBA I am the point for our new BA / BI projects. We want to leverage PowerPivot and SharePoint with our existing Data Warehouse. Our goal as a manufacturing company is to better prepare to meet the demands of our customers.

Our DBA services team supports more and more self-service BI each month and is gaining unprecedented momentum as Office 2013 reaches more desktops enterprise wide. We're all asked to do more with less and self-service BI leveraged correctly is going to become the vehicle to meet that goal for our customers.

Using historical data to stock product for manufacturing, using prior sales to project the effect of changing pricing nets on internal costs, monitoring changing trends in the marketplace and the ability to confirm current system invoicing is calculating correctly. Current data requests have doubled in the past year.

I was hired as a Business Analyst to write basic reports and software requirements. My role has morphed into building the tools and infrastructure to provide actionable data to our clients. Knowledge on where they need to take action is what's really needed and basic reports can't accomplish that.

I was hired as a Business Analyst to write basic reports and software requirements. My role has morphed into building the tools and infrastructure to provide actionable data to our clients. Knowledge on where they need to take action is what's really needed and basic reports can't accomplish that.

We are using data and BI to gain insights on how to improve scholastic achievement in K12 Students (I work for a school).

Analytics help us discover the questions we are not asking yet.

We're increasingly getting more and more requests for forward-looking insights rather than rear-view metrics. This involves a lot more data mining and information intelligence than ever before. True data scientist work!

Analytics at our casino are moving more towards not only giving our guests offers, but giving them offers they'll enjoy - and doing so in a manner that takes external factors into account. Different segmentation in revolutionary ways, with a smart, fresh new outlook and appreciation for our data.

At Ernst & Young, we increasingly use analytics to provide business units and supporting risk functions with a comprehensive set of capabilities to analyze and assess business data to support key risk and performance indicators (e.g., control exceptions, potential irregular activities, excessive change activity, KPIs, KRIs).

Digging deeper into healthcare data, I have realized there are a lot of life saving answers buried under the terabytes (growing exponentially with ObamaCare coming) of prescription, encounter, demographic data we work with. I want to do a better job finding patterns, so care providers become proactive, instead of reactive.

I primarily work in the ePrescribing engineering group - writing code for the back-end and also win-form apps for various tools, but the last few years I'm called upon more and more to perform data mining tasks to research data. I looking for the good, the bad, and the ugly data that pops up during production.

I work as a BI Consultant and have seen analytics take over discussions at all organizational levels at my clients. With the ease of use in today’s BI tools applying data and contextual analysis is easier so salespeople, CFO’s and everyone in between is looking for behaviour patterns.

My role is increasingly based on performance measured by numbers. I use analytics to spot trends so small decisions can be made quickly.

We sit upon mountains of data where I work, but we're just beginning to learn how to turn it into true information. This conference would be a HUGE step toward that goal!

Our customer websites used to be nothing but operational grids of data. Now I define the dimensions and let users slice through the information to find trends meaningful to them.

I work @PROS_Inc and analyzing BIG DATA is our bread-and-butter. As we state on our website, "PROS big data analytics software helps you compete and win more effectively."

My role on enhancing data driven BI for processing our daily captured environmental data, performance measurements - will be accelerated attending this conference.

As a small business, Management is always looking for improved efficiency. More and more we are finding that by analyzing our existing data we can spot inefficiencies and track progress on process improvements.

Part of my role is to use analytics to optimize operational systems and processes (smarter operations). Also working on developing analytical dashboards for category managers helping them to monitor sales current status and identify local actions to launch.

Every second we are getting familiar with the incremental Analytics continuum to turn the data into real information and use data in imaginative ways to gain maximum value. Becoming a part of the #passbac conference would definitely help me to find out the story behind data.

I would just love to have the opportunity to attend this event as I feel it would greatly help my beginning in the BI/BA field that I started @2012pass

Employers expect students to be at ease with numbers and to using analytics to make decisions. As a college professor in market research, my courses are increasingly oriented around new technologies and analytic techniques.

So much data, so little time. Need to understand!

Our conversion to a new BI tool empowered myself and my colleagues to know that clear metrics are the reason for a well-developed DBMS.

I am becoming the defacto excel expert at my company. Keep them surprised by making large data pretty. :)

For years I've been telling them the What and the When ... now they're asking me What if? and Why? I need to attend the @passbac conference!

The Affordable Health Care Act has requirements for HealthCare providers participating in the HealthCare Exchanges. As we worked to build the functionality to participate in the exchanges with our partners the need for analytics quickly became apparent. In order to truly measure our health services against others that will be competing in the new exchange market we know that the better we build our BI analytics the better we can complete. With HealthCare data streams (including Medicare), as a provider the primary concern is always with patient care but we can easily leverage some of the BI tools to strip relevant facts and dimensional data from that stream to build our new Analytics system. With the sweet integration of the platform tools, SQL Server 2012, SSIS, SSAS, and Excel 2013 PowerPivot we were able to quickly build a prototype and are now in the process of developing a more robust system using those same tools.

We are a small custom software and consulting company and everyone we work with are finally coming around to the fact that their Data is important and want to know how to use BI tools to analyze and learn from what they have collected. We are trying to educate them and move them toward the latest SQL Server 2012 and Excel 2013 to expose all the new possibilities they can have at their fingertips. I would love to win registration to the PASS BA Conference and learn more about all the new tools.


From the BI/BA Blogosphere: March 15 Update

Catch up on your business intelligence and analytics learning with some of the community's top bloggers. Enjoy these recent articles and blog posts from around the world of data analytics:

McDowell Interview: PASS Business Analytics Conference, Microsoft Data Mining

Excerpt cross-posted from KDnuggets
By Gregory Piatetsky

I interviewed Douglas McDowell about the PASS Business Analytics Conference, SQL Server, Microsoft Data Mining, less known but useful features of SQL, NodeXL, Big Data and more.

Douglas McDowell is the CEO of North America for SolidQ ( He is a Microsoft Most Valuable Professional (MVP) for SQL Server and serves on the Board of Directors for the Professional Association for SQL Server (PASS). He is an author and contributing editor for SQL Server Magazine.

I spoke to Douglas ahead of the PASS Business Analytics Conference in Chicago April 10-12. (Note: KDnuggets readers can save $150 when you register for the PASS BA Conference by using the BAC13KDN discount code.)

GP: What is the  PASS Business Analytics Conference?
McD: It's a very exciting time for data professionals as more and more organizations turn to data-driven insights to stay ahead in today's competitive marketplace. Staying up to speed in this constantly changing world of data can be a challenge - that's where the PASS Business Analytics Conference fits in.

The conference was established to meet the needs of a growing Business Analytics community affiliated with Microsoft technologies such as Excel, SharePoint, SQL Server, Parallel Data Warehouse, Azure, Hadoop and more. The event is geared towards data and business analysts, data scientists, architects, and business analytics/business intelligence professionals and covers a wide range of information from data exploration and visualization, predictive analytics, content management and architecture, information strategies, and much more.

GP: What is the role of SQL Server in the Microsoft eco-system?
As a partner and insider I have listened to Microsoft's vernacular shift from "SQL Server" to "Data Platform" and other similar terms. Some might think it a de-prioritization of SQL Server, but that would be a mistake. Microsoft is focused on the exploding business analytics (BA) needs of clients and understands it requires a complete toolbox of complementing technologies to deliver it all. As far as I can see, SQL Server is and will be a core component to BA for Microsoft going forward. Whether it be in the cloud or on-premise, SQL Server will hold critical features and therefore the Microsoft licensing model for core BA functionality. I see SQL Server getting more robust and more integrated with the rest of the Microsoft BA platform (since SQL Server will not and should not contain everything). ...

Read the full interview

Looking for Big Data Value in All the Wrong Places

Cross-posted from the SQL Server Blog's PASS BAC Preview Series
by Hyoun Park

When Johnny Lee wrote his country classic, Looking for Love (In All The Wrong Places), he wrote with such heart, such pain, and such meaning that you just knew that he was writing about the challenge of creating a business plan for Big Data. For those of you who know the song, you might have missed this detail because you were so caught up in the story. Or perhaps maybe the soothing melody just took you away. But in any case, even a cursory understanding of the lyrics makes it clear that this song was meant to provide guidance to the enterprise analysts and project managers trying to figure out why Big Data is going to help them out.

Just think of the first line, "Well, I spent a lifetime looking for you/Singles bars and good time lovers were never true"

Who hasn't spent a lifetime thinking about how data could help their organization? But the challenges of integrating Big Data into sales, marketing, service, product development, HR, operations, and manufacturing were just too challenging. You could never settle on the correct solution. And when you chose that simple SaaS solution for a one-time need, it never quite worked out the way you expected.

If only there were a roadmap for figuring out how and where to begin in a cost-effective manner. And a way to prioritize how to set a realistic business goal for analytics. And it didn't take a lifetime to find...

"Playin' a fool's game hoping to win/And telling those sweet lies and losing again"

Amen to that. How many promises were analytics supposed to solve? When these analyst firms start throwing around claims like "Analytics pays back $10.66 for every dollar spent," people start to think that kind of return is possible and expected. (OK, I may be guilty for that last statistic.)

But how do you get to that kind of return? How do you play the game of analytics so that this is a realistic business return and not just a sweet lie you tell to your CIO before finding that those returns aren't happening after all?

"I was looking for love in all the wrong places/Looking for love in too many faces/Searching their eyes looking for traces of/What I'm dreaming of"

The vendor landscape for Big Data analytics and data management is enormous. There are a few short lists and short cuts for general analytics deployments, but there are so many specialized tools and new vendors that it is hard to keep up with them. It would be a lot easier if there was a simple way to weed out the contenders from the pretenders without pulling out a full-fledged RfX.

"Hoping to find a friend and a lover/I'll bless the day I discover/another heart ,looking for love."

Somewhere out there is that One True Pairing for your company: Big Data that has the functionality that the IT office wants, the usability that the line-of-business wants, the cost structure that the CFO wants, the support that service and help desk personnel want; and the agility and scalability buzzwords that your executives keep going off about. Should all of these be equally as important? Or are there certain areas where you can skimp on your analytics investment so that you can focus on the areas that truly matter?

"And I was alone then, no love in site/I did everything I could to get me through the night/I don't know where it started or where it might end/I'd turn to a stranger just like a friend."

When you're tasked with building the business case, it sure feels lonely. And you do go out to anyone in Project Management or IT land who has done this before to get some advice. Do I use TCO or ROI and how do I do that without leaving anything out? Am I just looking for some basic business requirements? Will I ever finish this business case or are we just going to end up taking a blind leap into building a data warehouse or implementing a Big Data appliance? Is this going to end up being an all-nighter to figure all this out? Is SQL Server enough or is it time for Hadoop?

"Then you came a-knocking at my heart's door/You're everything I been looking for"

That's the goal, isn't it? Unfortunately, it's probably not going to be as easy as having your analytics solution and all of the value propositions fall in your lap. But there are a number of basic findings that can help you to estimate some of the value propositions you're looking for, such as the keys to maximizing potential ROI, the best way to measure indirect benefits, the four stages of the Analytic Enterprise, the five key components of analytic benefits that Nucleus has identified through over 60 case studies, and attributes that provided Big Data users with an average incremental 241 percent ROI over their existing analytics efforts.

If, like Johnny Lee, you've been trying to build the business case for Big Data in all the wrong ways and in all the wrong places, you should stop by my session at the PASS Business Analytics Conference on April 11th so I can help you find everything you've been looking for in a Big Data business case.

Learn more from Hyoun at his PASS BA Conference session, "Building the Business Case for Big Data."  


Win Registration to the PASS BA Conference

This could be your lucky week! With just a month to go, excitement’s in the air around the PASS Business Analytics Conference. We’ve heard that many of you are interested in attending and are looking to get the best rate by registering by this Friday, March 15. But wouldn’t free be even better?

For those who haven't signed up yet, here’s your chance to win registration to what’s going to be an incredible 2 days of business intelligence and analytics learning. Keep an eye on Facebook and Twitter today through Wednesday (March 11-13), and share how your job function is becoming more analytics focused for your chance to win one of five passes*.

Make sure you’re following the BA Conference on Twitter (@passbac/#passbac) and Facebook to participate. Only one entry per person please, and remember to post your answer by midnight Pacific Time Wednesday, March 13. We’ll announce the winners on Thursday.

Good luck! And even if you don’t win, you can get $200 off registration by using the discount code from your local or virtual PASS chapter or favorite blogger – just remember to register by March 15 for the best rate.

See you in Chicago!
The PASS Business Analytics Team

* Prize includes: One full-conference registration to the PASS Business Analytics Conference. Travel, accommodation, and other expenses not included.

From the BI/BA Blogosphere: March 8 Update

Got 5 minutes? Take a reading break with these blog posts from around the world of business intelligence and data analytics:

Pages: 12NextReturn Top
  1. Re: Business Analytics and PASS: Yes, Please!

    I take much learning here through following your every new post. Your write up is a fine example of


  2. Re: Taking Business Analytics to the Next Level

    Analytics has traditionally been performed by data scientists whereas Business Intelligence has gene


  3. Re: From DBA to Data Analyst: My Story

    That is really good Data Analyst job is more tough and informative because in this job you have many

    --Clare Jones

  4. Re: Win Registration to the PASS BA Conference

    blogcomments awd awdqwr qwerd qwre


  5. Re: Business Analytics and PASS: Yes, Please!

    Derivative academic fields of study may both interact with and develop independently of filmmaking,

    --enduro salt cell

  6. Re: PASS BA Conference: Another First

    I am really appreciate for arranging such a fabulous conference by all the attendees, speakers, vol


  7. Re: Business Analytics and PASS: Yes, Please!

    It is a good way to tackle the stress which is not allowing the individuals to perform Cheap mobile

    --Cheap mobile wallet

  8. Re: Business Analytics and PASS: Yes, Please!

    Business Analytics may be the capability of testing business metrics regarding achieving sustainable

    --Best company for Mobile wallet

  9. Re: Business Analytics and PASS: Yes, Please!

    Business analytics is the practice, finding of a company’s data and found new technics for company u


  10. Re: Business Analytics and PASS: Yes, Please!

    Thanks for sharing this post Thanks Managerial Accounting Assignment Help

    --Online Assignment Help UK

There are no tags.