PASS Business Analytics Conference 2013
2013-04-10..2013-04-12
Chicago, United States
[PASS Business Analytics Conference 2013, PASS Business Analytics Conference 2015]
who it's for
bi developers, excel power users, data engineers, bi architects, business analysts, analytics managers, database administrators, data scientists
topics
PowerPivot and Excel 2013; Power View visualizations; HDInsight Hadoop and Hive; Hive ODBC to Excel pipelines; DAX time-based analysis; SQL Server Integration Services (SSIS) ETL; Analysis Services cubes and tabular models; Parallel Data Warehouse and columnstore; NoSQL (HBase and MongoDB) tradeoffs; Recommender systems with matrix factorization; Data Explorer and OData data feeds; Data quality with MDS and DQS
| title | author | length |
|---|---|---|
| Big Data Analytics with Excel 2013 | Peter Myers | 58m |
Demo builds a pipeline from HDInsight (preview) Hadoop (Hive) to Excel 2013 using the Hive ODBC driver, loading four years of CSV weblogs into a Hive external… | ||
| Mastering the CUBE Functions in Excel 2013 | Peter Myers | 01h 00m |
Covers the seven CUBE functions in Excel 2013 and shows working examples: converting a pivot to formulas, building a sales KPI summary with slicers, sparklines… | ||
| Overview of Microsoft Appliances | James Serra | 01h 03m |
Explains concrete options for a SQL Server data warehouse: follow the Fast Track reference architecture or buy an appliance. Lists Dell/HP appliances: a… | ||
| Building an Effective Data Warehouse Architecture | James Serra | 01h 00m |
Recommends a pragmatic hybrid: build a normalized Enterprise data warehouse as a single source, spawn star-schema data marts and cubes for reporting, and… | ||
| Feed Your Data! OData Data Feeds for PowerPivot Users | Chris Webb | 01h 03m |
Demos pull a public Excel survey from Office 365 into Excel, PowerPivot and Data Explorer via OData, with a live run capturing 48 responses despite Wi‑Fi… | ||
| Measuring the Subscription Economy | Angel Abundez | 01h 02m |
Explains a Kimball-style dimensional model that turns Chargeify/Recurly-style source rows into a factless fact table for monthly churn and a separate… | ||
| Big Data - Top Ingredient to Improve Healthcare | Paul Bradley | 52m |
Describes a working pipeline that pulls HIS/EMR flat files into a staging SQL Server, runs validation and stored‑procedure processing, scores accounts with SQL… | ||
| NoSQL: An Analysis | Andrew J. Brust | 01h 01m |
Argues that NoSQL is about tradeoffs not hype, lays out four concrete categories and demos two: HBase on HDFS with immutable files where writes are logged and… | ||
| Self-Service Data Modeling | Marco Russo | 59m |
Advanced Excel users can build a usable star schema and compare sales vs. budget without writing SQL by using Power Pivot to host measures and lookup tables… | ||
| Recommender Systems – A Walkthrough | Artus Krohn-Grimberghe | 58m |
A practical roadmap: recommender pipelines use only user–item interactions and the best-performing method is matrix factorization learned by stochastic… | ||
| Using Power View and Hadoop to Unlock Hidden Markets | Stacia Varga | 01h 01m |
Uses Hadoop + Hive + Excel Power View to load CSVs from set‑top boxes, query via Hive ODBC, and analyze in PowerPivot. Works with one week of set‑top data (Jul… | ||
| Taking BI to the Next Level: Collaboration | Stacia Varga | 01h 00m |
Claims that adding SharePoint-based collaboration to BI raises adoption (from single-digit to double-digit) and cuts decision time from days or weeks to under… | ||
| Modern Data Warehousing Strategy | Marco Russo | 01h 01m |
Argues that the data warehouse remains essential while Power Pivot, Data Explorer and Hadoop create new pressures and opportunities; recommends a hybrid SQL‑BI… | ||
| Mobile Business Intelligence, Apprentice Style! | Jen Stirrup | 01h 01m |
Claims that 70% of organizations expect 25% of users to be mobile-only within two years clash with Gartner numbers showing fewer than 10% currently… | ||
| Data Analysis with R and Julia | Mark Tabladillo | 54m |
Compares hands-on R tooling (RStudio and Rattle GUI) against Julia, loading a 10,000-row Excel sample to predict marital status; a decision tree rule surfaces… | ||
| Analytics for Business Strategy | Cristian Vava | 45m |
Organizations lose 25–35% of performance without analytics, only 1 in 12 achieves expected returns, and 40% of decisions still ignore data, so the talk… | ||
| What Is Data Science? | Mark Whitehorn | 01h 01m |
Defines data science by concrete problems and results: analyzing proteomics mass‑spectrometer traces (~8 GB wiggle files) to identify peptides from ~18,000… | ||
| Sports Analytics: Big Data in the Big Time | Wayne Winston | 56m |
Covers concrete methods and results: uses OPS outperforms complex regressions for hitter value, applies regression and FanGraphs data, uses walks‑strikeouts‑HR… | ||
| Excel Charting Tips | Wayne Winston | 01h 01m |
Shows concrete Excel 2010 steps: put pictures inside column bars, use Ctrl+T table so new rows auto-update charts, and save custom charts as a template. Uses… | ||
| Data Visualization with Power View and the Tabular Model | Jen Stirrup | 54m |
Shows a working pipeline: a Visual Studio tabular model (VertiPaq/Velocity column compression) feeding Power View visualizations, with DAX measures and… | ||
| Office as Your BI Platform | Ashvini Sharma | 55m |
Office 365 provisions a SharePoint site in minutes and streams Office 2013 to a PC via click-to-run streaming so Excel 2013 runs side-by-side with older Office… | ||
| Drive Smarter Decisions with Microsoft HDInsight | Tim Mallalieu | 01h 01m |
Demonstrates HDInsight on Azure using Azure Blob as the default digital shoebox, Hive queries compiled to MapReduce over that storage, and Data Explorer’s… | ||
| From Data to Insight – Views from Microsoft Finance | Marc Reguera | 01h 03m |
Microsoft Finance shows how Excel 2013 + Power Pivot/Power View + SharePoint and PowerPoint turn raw sources into actionable dashboards: an American Express… | ||
| Present and Futures: Roadmap and Strategy | Kamal Hathi | 59m |
Microsoft frames its BI roadmap as a concrete stack: Excel + SharePoint + SQL Server drive self-service analytics that IT can inherit. Live demos show Flash… | ||
| Advancing Analytics at Microsoft Advertising | Naga Krothapalli | 38m |
Microsoft Advertising combines Cosmos consumer logs and campaign logs, builds a simple web UI scheduler that runs queries on huge clusters and returns Excel… | ||
| Visualization Choices: What, When, and How? | Paul Turley | 01h 01m |
Shows a concrete workflow: a three‑year FAA on‑time dataset is modeled in PowerPivot with DAX KPIs, visualized interactively in Power View (including an… | ||
| Inside Atento: Strategies for a Corporate Data Warehouse | Savita Moreno | 59m |
Global contact‑center firm standardizes 16-country data into a corporate warehouse on Azure, using SQL Server 2012, SSIS, SharePoint and multi‑dimensional SSAS… | ||
| Self-Service Business Analytics in 2013 | Rod Colledge | 52m |
Argues that managed self-service BI works only when IT supplies an 80% corporate data base and users add the remaining 20% with governable tools; demonstrates… | ||
| Power to the Pivot - Practical Intro to PowerPivot 2012 | Hope Foley | 47m |
Live demo shows how to use PowerPivot 2012 Excel add-in (Office 2010/2013) to build a timesheet-to-targets model: import tables, create concatenated composite… | ||
| Delivering Agile BI Solutions | Dave DuVarney | 58m |
Moves a stalled waterfall program that needed an extra $500,000 into an agile Scrum flow that actually ships working BI: physical user-story cards for… | ||
| Big Data: Threat or Opportunity? | Shaun Connolly | 57m |
Claims that Hadoop is a practical platform not vaporware: core pieces are HDFS and MapReduce, clusters scale from a few nodes to ~5,000 servers holding 100… | ||
| 60-Minute Demo: Microsoft BI Tools on SAP Data | Michael Raheem | 01h 02m |
Live demo links Microsoft BI stack to SAP: PowerPivot + Excel 2013 loads a SQL staging copy, creates relationships and DAX measures, and publishes interactive… | ||
| Mastering Time-Based Analysis in DAX | Dan Clark | 59m |
Practical recipe for date-driven DAX: use a designated date table marked as such, rely on 35 built-in time functions for YTD/MTD/QTD, and force filter context… | ||
| Why BI Projects Fail (And What You Can Do About It) | Craig Utley | 57m |
Lists the actual failure modes and fixes: politics and lack of a high-level business champion block decisions; data quality eats projects (one agency shows 40%… | ||
| My Brain Hurts: Presenting Data with Microsoft Tools | Craig Utley | 54m |
Survey of Microsoft BI tools with concrete tradeoffs: PerformancePoint is strong for scorecards/dashboards and browser analytics but only works against cubes… | ||
| MDS and DQS - Beyond the TLAs to Data Quality | Neil Hambly | 01h 00m |
Demonstrates using Microsoft Data Quality Services with Master Data Services and SSIS DQS components to profile, cleanse and match records, reference… | ||
| The Future of Apache Hive and Hadoop 2.0: Bigger, Faster, Stronger | Carter Shanklin | 01h 03m |
Roadmap and hard numbers: Hive 0.10 ships decimals and rollups, 0.11 adds windowing and base optimizations, 0.12 targets richer types; Stinger initiative… | ||
| Social Text, Sentiment, and Tone Analysis | Ruben Pertusa Lopez | 01h 05m |
Demo captures ~3,000 tweets over a week (1,000 retweets, 500 users, activity peaks 3–9pm) and shows a pipeline that ingests raw JSON into HDInsight/Hive… | ||
| Crossing the Last Mile with Predictable Hospital Readmissions | Drew Minkin | 54m |
Predictive model scores on a 20,000-patient cohort give a baseline 13% 30‑day readmission rate; the top 10% by score hits ~66% and targeting the top 70% can… | ||
| Hailing Frequencies: Analysis Services Terms and Concepts | Mark Vaillancourt | 53m |
Overview of SQL Server Analysis Services shows two concrete models and working examples: a multi‑dimensional cube queried with MDX and browsed via Excel 2013… | ||
| The ABCs of Scoring: Why, How, and Getting a Good Grade | Dan Bulos | 55m |
Scoring normalizes disparate KPIs to a common scale so percent growth, returns and customer counts become comparable, then aggregates weighted KPI scores into… | ||
| Advanced Data Visualization with SQL Server Reporting Services | Oliver Engels | 01h 01m |
Shows how SQL Server Reporting Services actually delivers: templates driven from Master Data Services and the Excel MDS add‑in to enforce corporate… | ||
| Charting Collections of Social Media Connections with NodeXL | Marc Smith | 01h 03m |
Turns raw social media logs into spreadsheets, computes centrality (degree, betweenness, eigenvector/PageRank), and auto-renders publishable network maps… | ||
| Business Intelligence on Mobile Devices | Leif Brenne | 32m |
Microsoft shows mobile BI as Office 365 + SharePoint + Office Web Apps with concrete features: a native SharePoint iPad app and Windows Phone Office hub, Excel… | ||
| Microsoft Data Explorer for Excel: Data Discovery & Transformation | Faisal Mohamood | 01h 03m |
Demonstrates an Excel add‑in that finds and previews 2 million Wikipedia tables, connects to SQL, Hadoop/HDInsight, web APIs and CSVs, and applies stepwise… | ||
| SQL Server Predictive Analytics: Customer Stories | Raman Iyer | 52m |
Shows a full SQL Server workflow: Analysis Services models built from relational data via an Excel add‑in, 30% held‑out validation, and a profit chart that… | ||
| Yahoo!, Big Data, and Microsoft BI: Bigger and Better Together | Denny Lee | 01h 06m |
Yahoo builds a Tau analytics pipeline that combines Hadoop (2 PB in a 14 PB cluster) with Oracle staging and SSAS cubing to serve ad optimization queries in… | ||
| Data Analytics: Realizing the Full Potential | Mike Stringer | 47m |
Central claim: process beats hype — start with a concrete problem and prototype interfaces before optimizing models. Examples: Google query logs deliver a… | ||
| Dark Matter: Domain Experts & Nextgen Spreadsheets Are Our Future | Rob Collie | 01h 01m |
Argues that spreadsheets are the hidden majority of analytics, claiming 90+% of data crunching flows through Excel because subject-matter experts avoid costly… | ||
| Online Advertising: Hybrid Approach to Large-Scale Data Analysis | Dmitri Tchikatilov | 01h 04m |
Agency and Microsoft build a hybrid pipeline that keeps raw logs on HDInsight on Azure, runs MapReduce/Hive for predictive scoring, then pulls selected subsets… | ||
| Extending PowerPivot into a Scalable Component for Enterprise BI | Avi Perez | 54m |
Shows how a PowerPivot workbook becomes a server-hosted BI component by uploading an Excel PowerPivot into SQL Server 2012 Tabular, applying role security, and… | ||
| Parallelizing Large Excel-Based Calculations on HPC Server & Azure | Antonio Zurlo | 01h 02m |
Demonstrates running Excel/VBA Monte Carlo workloads on Windows HPC Server (integrated with Azure) by copying spreadsheets to compute nodes, adding four VBA… | ||
| nothing matches | ||