Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

Menu

Skip to content
  • Home
  • My Books
  • Presentations
  • Best Practice Resources: Blogs & Books from the Experts
  • Video Tutorials
  • COVID-19 Daily Updates Report
  • Visualizations
  • About/Bio
  • Paul’s Bio
  • Note to SPAMers

Tag Archives: PASS BAC Blog Feed

What’s Happening at the PASS Business Analytics Conference?

May 7, 2014 by Paul Turley

1

Watch below for live updates during the conference

Stay tuned and you’ll find out what’s going on during this week in San Jose.  I’ll be blogging from the conference as announcements are made and as the rest of the community buzzes about new developments in the community and here at the BAC in San Jose, California.

BAC_ESignature

If you haven’t downloaded the pocket Guidebook, do it now.  Just go to http://guidebook.com/g/passbac/, install and then search for PASS Business Analytics.

Tuesday, May 6

I arrived this evening, flying in from Portland.  I met up with my long-time friend and co-author, Grant Paisley from Sydney, Australia.  It all starts to happen tomorrow with the all-day pre-conference sessions.  This is where the deep learning takes place.  Every year, people who have serious interest in learning to use a technology or business tool spend a full day with some of the most respected industry professionals.  They go deep and thorough, usually showing how to apply bet-practice skills to build a complete solution or tackle some serious issues. Registration for the preconference sessions will still be open on Wednesday morning until the rooms are at capacity.

Wednesday Precon Schedule:

  • Data Science Master Class: Exploring More Exotic Patterns in Data (AAT-199-P)

    Mark Whitehorn (Penguinsoft Consulting Ltd.)

  • Implementation and Design on the Parallel Data Warehouse (BD-399-P)

    Jason Strate (Pragmatic Works)

  • PowerPivot: Fundamentals and Patterns to Make You Effective TODAY (AV-199-P)

    Rob Collie (PowerPivotPro.com )

  • Predictive Analytics for Absolute Beginners (AAT-299-P)

    Artus Krohn-Grimberghe (Analytic Information Systems and Business Intelligence), Mark Tabladillo (SolidQ)

  • Real-World Small Big Data (BD-199-P)

    Lynn Langit (lynnlangit)

  • Superhero Power BI (AV-299-P)

    Peter Myers (Bitwise Solutions)

Wednesday, May 7

07:00 AM – 08:00 PM
Registration

07:30 AM – 08:30 AM
Continental Breakfast**, Exhibit Hall

08:30 AM – 4:30 PM

Precon Sessions

Thursday, May 8 

07:00 AM – 06:30 PM
Registration

07:00 AM – 08:00 AM
Continental Breakfast, Exhibit Hall

08:00 AM – 09:15 AM
Keynote – Amir Netz and Kamal Hathi

09:15 AM – 10:00 AM
Refreshment Break, Exhibit Hall

10:00 AM – 6:15 PM

Sessions

Friday, May 9

07:00 AM – 04:00 PM
Registration

07:00 AM – 08:00 AM
Continental Breakfast, Exhibit Hall

08:00 AM – 09:15 AM
Keynote – David McCandless

09:15 AM – 10:00 AM
Refreshment Break, Exhibit Hall

10:00 AM – 5:00 PM

Sessions

———————————————————————————————————

Thursday Keynote

It’s 8:00 AM Pacific Time on the 8th of May, 2014 and the keynote session is beginning…

Welcome by Tom LaRock, President of PASS

”we get paid to work with data everyday – it’s just hard to explain to our family what we do”

For over 14 years, PASS has connected data professions for all over

PASS has over 100,000 members

WP_20140508_001

John Whittaker from Dell:

“Is big data really happening in the middle market?”

WP_20140508_002

Outcome is successful when there is business and IT alignment

“It’s easy to be clever with big data but it’s easy to be freaky with it”

Top big challenges:

  • Variety of types & structures
  • Sheer volumes
  • Budget limitations
  • What data to use for business decisions
  • Getting business to share across org silos
  • Inaccurate/data quality
  • Understanding where to focus decisions, metrics, KPIs, etc.

Dell has a large software division (manage, integrate & analyze data) – audience poll showed that about 20% of attendees knew that

Amir Netz & Kamal Hati from Microsoft on stage

“Satya loves data…”

WP_20140508_005

This change in leadership at Microsoft will mean a greater focus on data and analytic technologies, especially cloud services.

Kamal: “Satya is making Indian accents cool at Microsoft”

  • 2 million Power Pivot  downloads
  • 100,000 Power Query downloads

Power BI demos, using Power Q&A to explore the Power BI usage statistics

  • Sept: usage spike when Q&A went public in preview
  • March: huge spike when Power BI was released
  • Over 1 million Q&A questions answered in April
  • Power BI demo contest winner was Michael Carper – “can tweeting affect the outcome of an NBA game?” https://fb-3785439.strutta.com/entry/5477264
  • Kamal demo: analyzing Internet browser usage
  • Announcements:
  • The Power BI iOS app will be available this summer
    Reporting Services will run in Power BI – by the end of summer
    Power BI will work with on-prem data sources without using scheduled data refresh
  • Forecasting & Time series analysis – 
    line chart provides time-series prediction with error ranges & outlier correction adjustments – WOW!

WP_20140508_009 

    • Demo: Hawaii tourism survey:
      • Interesting insights about the spending per island and where visitors come from
      • Question: “why do Japanese tourists show more affection than other cultures?” – answer: More Japanese honeymoon in Hawaii

Julie, a volunteer from the audience, is doing the next unrehearsed demo…

      • WE HAVE HEAT MAPS in Power VIEW!!!!  — Jun Underwood is hyperventilating
      • Drag a chart data point out to create another visual and drill-down – very cool!
      • Power View snaps and resizes

    WP_20140508_011

    Bump and Shake gestures added – automatically separates a chart into multiples or combines two charts into one visual by dragging them together with two fingers on a touch screen.

    In conclusion, the features shown today will be introduced in the next couple of months through Power BI in Office 365.

    ———————————————————————————————————

    Attended a great session presented by Devin Knight for beginners about building an end-to-end BI solution using Power View

    Devin is a very good presenter and was able to very clearly articulate the value of the Power Pivot and Power View toolset through live demonstrations.

    ———————————————————————————————————

    Great quote from Gartner in Michael Trjedor’s session on Microsoft Analytics & Visualization:
    "By 2015, organizations that build a modern information management system will outperform their peer financially by 20 percent."
    – Gartner, Mark Beyer, "Information Management in the 21st Century"

    WP_20140508_012

    ———————————————————————————————————

    WP_20140508_021

    Rob Collie: Your own Data Revolution

    “It doesn’t have to be industrial scale to be industrial strength”

    “The human prison”: The human brain is naturally trained to work within the boundaries established from past experience.  If only certain questions could be answered by a system/report/spreadsheet/database/model/whatever, we’re not likely to ask other questions.

    “apples and oranges”: Low hanging fruit…We often make unfair comparisons and establish benchmarks (e.g. KPI targets).  There are often/usually more variables to consider in a comparison.

    These tools & techniques allow our brains to thin the way they want to rather than the way they’ve been trained to think.

    “The Data Gene”:  1/16 people have the data gene – in all demographics & at all levels of the organization.

    You’re a data/business analytics conference… That’s not normal.

    The people who mock those who built the pyramids are “normal”.

    Data gene is an interest not a level of intelligence, no PhD necessary

    There is no cure

     

    ———————————————————————————————————

    Alberto Ferrari: DAX Solutions from the Field

    “I’ve stopped believing in Santa Clause, the Tooth Fairy  and Microsoft Marketing”

    “The primary key in the fact table is your worst enemy”

    • The first step to optimizing performance should always be to reduce unnecessary distinct column values
    • Use Kasper’s memory size Power Pivot model to analyze the memory footprint of tables & columns
    • Use SQL Server Profiler, clear cache
    • Build the model with necessary columns
    • Find columns using the most memory

    ———————————————————————————————————

    Dejan Sarka: Advanced Analytics in Excel 2013

    if you would like to get a complete picture of the end-to-end data analytics capabilities in Excel, watch the recording of this session.  Dejan covered all the essentials at an advanced level.  This excellent presentation moved very quickly.  Emphasis on data mining/predictive analytics.

    WP_20140508_027

     

    FridayKeynote

    It’s 8:05 AM Pacific Time on the 9th of May, 2014 and the keynote session is beginning…

    This session is highly visual and to get the message, I will update this post with pictures that become available after the conference.

    David McCandless, keynote speaker, is visualizing a billion dollars using a tree map/heat map

    WP_20140509_004

    “Debtres” … animated tetris visual that assembles a heat map

    Trendline example:  what trends up in the Spring near Easter and Christmas and then a little each holiday and weekend?

    …relationship breakups via FaceBook

    WP_20140509_012

    Data must be visualize in context (e.g. pure sum vs ratio… )

    Strip out the labels and leave the colors and shapes to set the visual context

    …then add labels and numbers to add value

    Share this:

    • Click to email this to a friend (Opens in new window)
    • Click to print (Opens in new window)
    • Click to share on Twitter (Opens in new window)
    • Click to share on LinkedIn (Opens in new window)
    • Click to share on Facebook (Opens in new window)
    • Click to share on Reddit (Opens in new window)

    Like this:

    Like Loading...
    Posted in Business Analytics, Microsoft BI Platform, MVP Community, PASS, Power View, PowerPivot, Self-service BI, SolidQ, SQL Syndication. Tagged PASS BAC Blog Feed

    Post navigation

    Blog Stats

    • 1,386,273 hits

    Email Subscription

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 5,075 other subscribers

    Recent Posts

    • Doing Power BI the Right Way: 4. Power Query in Dataflows or Power BI Desktop
    • A First Look at Gen 2 Composite Models with Live Power BI Datasets
    • Power BI: The Week in Graphics
    • Doing Power BI the Right Way: 5. Data Modeling Essentials & Best Practices (2 of 2)
    • Doing Power BI the Right Way: 5. Data Modeling Essentials & Best Practices (1 of 2)
    • Composite Models Gen 2 and DirectQuery over Power BI Datasets
    • Power BI Expert Resources
    • Doing Power BI the Right Way: 7. Planning for separation – data models and reports
    • Doing Power BI the Right Way: 6. Validating data model results – Part 2
    • Doing Power BI the Right Way: 6. Validating data model results – Part 1

    Category Cloud

    BI Industry BI Projects Business Analytics Microsoft BI Platform MVP Community PASS Power BI PowerPivot Power View Self-service BI SolidQ SQL Server SQLServerPedia SQL Server Pro Magazine SQL Syndication SSAS Administration SSAS Design SSRS Administration SSRS Design Tabular Models

    Archives

    • January 2021 (3)
    • December 2020 (4)
    • November 2020 (1)
    • October 2020 (2)
    • September 2020 (1)
    • August 2020 (1)
    • July 2020 (4)
    • May 2020 (1)
    • April 2020 (3)
    • March 2020 (3)
    • February 2020 (1)
    • January 2020 (1)
    • December 2019 (2)
    • November 2019 (5)
    • October 2019 (1)
    • September 2019 (1)
    • August 2019 (2)
    • July 2019 (5)
    • May 2019 (1)
    • April 2019 (3)
    • March 2019 (1)
    • February 2019 (2)
    • December 2018 (3)
    • November 2018 (1)
    • October 2018 (1)
    • September 2018 (3)
    • July 2018 (5)
    • May 2018 (2)
    • April 2018 (2)
    • March 2018 (3)
    • February 2018 (3)
    • January 2018 (3)
    • December 2017 (3)
    • November 2017 (4)
    • October 2017 (1)
    • September 2017 (2)
    • August 2017 (1)
    • July 2017 (1)
    • June 2017 (4)
    • April 2017 (8)
    • March 2017 (1)
    • February 2017 (2)
    • January 2017 (8)
    • December 2016 (4)
    • November 2016 (3)
    • October 2016 (2)
    • September 2016 (1)
    • July 2016 (3)
    • June 2016 (3)
    • May 2016 (3)
    • March 2016 (6)
    • February 2016 (5)
    • January 2016 (2)
    • December 2015 (4)
    • November 2015 (3)
    • October 2015 (2)
    • September 2015 (2)
    • August 2015 (3)
    • July 2015 (6)
    • June 2015 (1)
    • May 2015 (5)
    • April 2015 (4)
    • March 2015 (1)
    • February 2015 (2)
    • January 2015 (4)
    • December 2014 (3)
    • November 2014 (1)
    • October 2014 (4)
    • September 2014 (1)
    • August 2014 (2)
    • July 2014 (5)
    • June 2014 (4)
    • May 2014 (2)
    • April 2014 (6)
    • March 2014 (3)
    • February 2014 (7)
    • January 2014 (5)
    • December 2013 (2)
    • November 2013 (1)
    • October 2013 (1)
    • September 2013 (2)
    • July 2013 (4)
    • June 2013 (5)
    • April 2013 (1)
    • March 2013 (4)
    • February 2013 (3)
    • January 2013 (1)
    • December 2012 (4)
    • November 2012 (4)
    • October 2012 (3)
    • September 2012 (3)
    • August 2012 (2)
    • July 2012 (2)
    • June 2012 (2)
    • May 2012 (3)
    • March 2012 (2)
    • February 2012 (3)
    • December 2011 (1)
    • November 2011 (3)
    • October 2011 (11)
    • September 2011 (7)
    • August 2011 (4)
    • July 2011 (2)
    • June 2011 (4)
    • May 2011 (5)
    • April 2011 (5)
    • March 2011 (4)
    • February 2011 (2)
    • January 2011 (4)
    • December 2010 (4)
    • November 2010 (4)
    • October 2010 (1)
    • September 2010 (1)
    • August 2010 (2)
    • June 2010 (1)
    • May 2010 (2)
    • April 2010 (1)
    • March 2010 (19)
    • December 2009 (1)
    • June 2009 (1)

    Tag Cloud

    " & Workspace and Database Recovery Techniques Aaron Nelson Ad-hoc reporting Add columns Add controls Albert Ferrari Alternate row colors Analysis Services Operations Guide Apple Are There Rules for Tabular Model Design? Article Assemblies Azure Azure Reporting Azure SQL Database BARC Survey best practices BI BI Center of Excellence BI COE BI Conference Bill Gates Birds-of-a-Feather BI Roles and Team Composition BISM BI Survey 10 Blogging Breakcrumb links Browser settings Build career Business Intelligence Business Intelligence for Visual Studio 2012 Business scorecard Can I Use Reporting Services with Tabular & PowerPivot Models? Checkbox in report Checkbox list Check mark Chris Webb Cloud computing Column chart Community Conditional formatting Conference presentation Conference review Conference session Conference Session Topics Cortana Power BI Integration Custom code Custom coding reports Custom Functions Dashboard design Dashboard standards Database Lifecycle Management Data Modeling 101 for Tabular Models Data Quality Services Dataset filter nulls Datazen Datazen control selection Date parameters DAX DAX: Essential Concepts DAX: Some of the Most Interesting Functions DAX: Some of the Most Useful Functions DAX functions DAX reference DAX syntax Demo scenario Denali CTP3 DevTeach DLM Do I Write MDX or DAX Queries to Report on Tabular Data? Do We Need to Have SharePoint to Use Tabular Models? Drill-down Drill-through Drillthrough Dynamic column visibility Dynamics CRM Dynamics reporting Embedded formatting ENterprise SSAS Errors Estimating BI European PASS Filter by user Formula Firewall Funnel charts Garner Magic Quadrant Microsoft BI Getting Started with DAX Calculations Global Summit Live Feeds Greenbar report Grocery shopping demo Hans Rosling Happy Birthday Power BI Hide columns Hitachi Consulting How Do You Design a Tabular Model for a Large Volume of Data? How Do You Secure a Tabular Model? How to Deploy and Manage a Tabular Model SSAS Database How to Promote a Business-created PowerPivot Model to an IT-managed SSAS Tabular Model HTML text integrated mode Interview Interviews Isn’t a Tabular Model Just Another Name for a Cube? James Phillips Julie Koesmarno King of Spain KPI indicator Licensing Login prompt Manually starting subscription Map Visualization Marco RUsso Master-detail report Master Data Management MDM MDX datasets MDX queries Microsoft Architecture Journal Microsoft humour Microsoft MVP Microsoft news Mobile Reporting Mobile Reports MVP community MVP Deep Dives 2 MVPs support the community MVP Summit navigation Nested tables Null filter Olivier Matrat Olympia WA Oracle vs Microsoft in the movies Oregon SQL Saturday Parameter controls Parameterize Parameters PASS 2012 PASS BAC Blog Feed PASS community leaders PASS Conference PASS Global Summit 2012 PASS Keynotes PASS Summit PASS Summit 2017 PASS Summit 2018 PASS Summit Announcements Paul te Braak PDF image distortion dithering fonts PerformancePoint Pinal Dave Poll About Product Usage Poll Results Pop-up window; Java script Portland OR Power BI Administration Power BI Best Visuals Contest Power BI DAX Power BI Partner Showcase Power BI Premium Power BI Pro Power BI Training Power BI World Tour Power Pivot PowerPivot Power Pivot DAX Power Query Power Query Training Power View Power View multidimensional cubes Preparing Data for a Tabular Model Project Phoenix Recipes Redmond SQL Saturday Reed Jacobson Remove columns Repeating list Report controls report dependencies Report deployment Reporting Services 2016 Reporting Services Training Report navigation Report parameters Report recipe book Reports for MDX Return specific row Rob Collie DAX Book Robert Bruckner Scheduled Refresh Scripting Tabular Model Measures Self-service reporting Seth Bauer SharePoint SharePoint 2012 SharePoint integration Simplifying and Automating Tabular Model Design Tasks SolidQ SolidQ Journal Solid Quality Mentors Spatial queries; happy holidays; Merry Christmas SQLAuthority SQLCAT SQL Saturday SQL Saturday 446 SQL Saturday Portland Oregon SQL Server SQL Server 2012 Upgrade Guide SQL Server community SQL Server Data Tools – Business Intelligence for Visual Studio 2012 SQL Server Denali SQL Server Denali; Self-service reporting SQL Server Denali CTP3 SQL Server MVP SQL Server Optimization SQL Server Pro Magazine SQL Teach SSAS SSAS Performance Logger SSAS Tabular SSAS Tools BI Development Tools SSDT BI SSRS 2016 SSRS dynamic columns SSRS PowerShell SSRS version control standards Start subscription Steve Jobs StreamInsight Strip line style Subscription Survival Tips for Using the Tabular Model Design Environment Tabular DAX Tabular Model & " Tabular Model Common Errors and Remedies Tabular Model Design Tabular Model Design Checklist Tabular Modeling Tabular models Tabular report design TechEd TechEd 2011 Sessions TechSmith Snagit Pro themes Threshold line Top values Training clsses Unconference User-related report content User authentication User prompted to login Using DAX to Solve real-World Business Scenarios Vancouver BC Vern Rabe Visualisation Visualization Visual Report Design Volunteers Weather and Climate Web.Contents Web API What About Multidimensional – Will Tabular Replace It? What are the Naming Conventions for Tabular Model Objects? What Do You Teach Non-technical Business Users About PowerPivot and Tabular Models? What’s the Best Business User Tool for Browsing & Analyzing Business Data with Tabular Models? What’s the Best IT Tool for Reporting on Tabular Models? What’s the Difference Between Calculated Columns & Measures? What’s the Difference Between PowerPivot and Tabular Models? Why Tabular? Wrox book
    RSS
    RSS Feed
    Powered by WordPress.com.
    loading Cancel
    Post was not sent - check your email addresses!
    Email check failed, please try again
    Sorry, your blog cannot share posts by email.
    %d bloggers like this: