Nr: 396
SQLSaturday #396 - Dallas - BI Edition 2015
SessionID: 9940
Kimball's not Dead: Modeling Basics
Event Date: 02-05-2015 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Allen Smith
Title: Kimball's not Dead: Modeling Basics
Abstract:
SessionID: 10755
Easy, Scalable Data Solutions in SQL Azure
Event Date: 02-05-2015 - Session time: 08:30:00 - Track: Big Data Azure
Speaker: Brian Gogle
Title: Easy, Scalable Data Solutions in SQL Azure
Abstract:
For companies looking to achieve data scalability without large capital expenses, SQL Azure provides a flexible, economical alternative to hosting your data on-prem. In this session we will demonstrate how to create a SQL Azure database and how to manage scalability and geo-replication. We will also explore how SQL Server Management Studio allows you to interact with your data on-prem, as well as key differences between SQL Server and SQL Azure. There will also be a demonstration of creating a SQL Azure API using Azure Mobile Services.
SessionID: 20680
Cash in on the data dividend: how Power BI can realize the untapped value of your data
Event Date: 02-05-2015 - Session time: 08:30:00 - Track: Power BI
Speaker: Mike Diehl
Title: Cash in on the data dividend: how Power BI can realize the untapped value of your data
Abstract:
IDC estimates that the economic value gap between companies that are innovative about data analytics and those that maintain a status quo is $1.6 trillion worldwide over the next four years. This presentation will look at the ways that the data dividend can be realized, and provides an overview of Microsoft Power BI (the tools in Excel and the cloud-based services) so you can understand how it can be applied to your organization.
SessionID: 23691
Introduction to BIML and BIMLScript
Event Date: 02-05-2015 - Session time: 08:30:00 - Track: Information Delivery
Speaker: Russel Loski
Title: Introduction to BIML and BIMLScript
Abstract:
SessionID: 9938
BI Basics - Finding Return on Data
Event Date: 02-05-2015 - Session time: 08:30:00 - Track: Information Delivery
Speaker: Allen Smith
Title: BI Basics - Finding Return on Data
Abstract:
In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint. This session is non-technical.
SessionID: 11465
Connected Car Analytics with Raspberry Pi, Windows Azure, and Pow
Event Date: 02-05-2015 - Session time: 09:45:00 - Track: Power BI
Speaker: Chris Baudo
Title: Connected Car Analytics with Raspberry Pi, Windows Azure, and Pow
Abstract:
This session is suited for the computer hobbyist and will cover gathering metrics from an automobile On-Board Diagnostics (OBD) port with a small Raspberry Pi computer. Data elements such as VIN, rpm, and speed will be loaded from the Raspberry Pi to Windows Azure for analysis with Power BI.
SessionID: 14838
Rise of the Machine (Learning) – Azure ML in BI, in Apps, and as a product in Azure Marketplace
Event Date: 02-05-2015 - Session time: 09:45:00 - Track: Big Data Azure
Speaker: Greg Beaumont
Title: Rise of the Machine (Learning) – Azure ML in BI, in Apps, and as a product in Azure Marketplace
Abstract:
Machine Learning no longer requires expensive infrastructures and knowledge of specialized statistical coding languages. Azure ML lowers the barriers of entry for predictive analytics using Machine Learning. In this session, review the similarities and differences of Machine Learning compared to traditional Predictive Analytics, Data Mining, Data Science, and Artificial Intelligence. I will demonstrate how a BI solution using only Excel with Power Pivot can connect to an Azure ML Model in the cloud for predictions and new types of analysis. Learn how Azure ML can be used to add value to Apps. Also, review ways to turn your Azure ML Model into a source of revenue using Azure Marketplace. Machine Learning is now quietly rising all around us as it integrates with technology, improves processes and workflows, and transforms how data drives business. Empower your organization with new competitive advantages using Azure ML.
SessionID: 15771
SQL Geography DataTypes and Applications in BI
Event Date: 02-05-2015 - Session time: 09:45:00 - Track: Data Visualization Business Analytics
Speaker: Jared Nielsen
Title: SQL Geography DataTypes and Applications in BI
Abstract:
At some point in your SQL life you will be asked to calculate or visualize geospatial data. Microsoft SQL server has unique optimizations and frameworks for handling just this circumstance. Not to be confused with Geometric data (square and linear), Geographic data offers even more complexity as you deal with the curvature of the earth and its radial impact on queries. Jared Nielsen is the Principal of the FUZION Agency and the CTO of Online and Digital for Universal Weather and Aviation and contends with geographic data on a daily basis. FIR Boundary intersection, optimized flight planning, weather map overlay and multi-level airspace computations all involve some very interesting SQL Server geographic manipulations that may be interesting for you to experience if you haven't already. Please join me for an in-depth review with helpful resources to guide you on your way as you incorporate Geospatial data into your own applications.
SessionID: 26645
Building Bullet-Resistant SSIS Packages
Event Date: 02-05-2015 - Session time: 09:45:00 - Track: Information Delivery
Speaker: Tim Mitchell
Title: Building Bullet-Resistant SSIS Packages
Abstract:
In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
SessionID: 36871
Visualizing Geospatial Data with Power Map (Bryan Smith, Microsoft)
Event Date: 02-05-2015 - Session time: 09:45:00 - Track: Power BI
Speaker: MSBIC Admin
Title: Visualizing Geospatial Data with Power Map (Bryan Smith, Microsoft)
Abstract:
Power Map is a new Excel feature for exploring map and time-based data. Come see how Power Map for Excel 2013 can take your geo-spatial analysis to the next level.
Bryan is a Business Intelligence Technology Specialist with Microsoft and Adjunct Professor at Southern Methodist University in Dallas, TX. Prior to his current role, Bryan served as a consultant and trainer with Hitachi Consulting, assisting a variety of customers in designing, implementing, and supporting Business Intelligence solutions. He is co-author of several books on Microsoft technologies including Microsoft SQL Server 2008 Analysis Services Step by Step, Microsoft SQL Server 2008 MDX Step by Step, and Professional SQL Server 2008 Reporting Services.
SessionID: 11522
Row-Based Security in SSRS and SSAS
Event Date: 02-05-2015 - Session time: 11:00:00 - Track: Data Visualization Business Analytics
Speaker: Chris Hyde
Title: Row-Based Security in SSRS and SSAS
Abstract:
It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.
SessionID: 11538
Power Query: Pulling It All Together
Event Date: 02-05-2015 - Session time: 11:00:00 - Track: Power BI
Speaker: Chris Johnson
Title: Power Query: Pulling It All Together
Abstract:
SessionID: 14582
One is the Loneliest Number: Scaling out your Data Warehouse
Event Date: 02-05-2015 - Session time: 11:00:00 - Track: Big Data Azure
Speaker: Greg Galloway
Title: One is the Loneliest Number: Scaling out your Data Warehouse
Abstract:
If your current data warehouse is overworked and underpaid, maybe it needs a friend to share the load. Do you want to be able to scan your 1TB fact table in 20 seconds? Do you want to maintain performance even if data volumes triple without rewriting any code? Do you want a data warehouse which extends to the cloud?
This demo heavy session will be a deep dive into scaling out your data warehouse onto the Analytics Platform System appliance from Microsoft and querying it with familiar T-SQL. You will learn performance tuning best practices for taking advantage of a distributed data warehouse. See demos of hybrid connectivity to Azure Blob Storage through a technology called Polybase and learn how a modern data warehouse can handle structured data, semi-structured data, and streaming data.
SessionID: 19220
Building your ETL Framework with BIML
Event Date: 02-05-2015 - Session time: 11:00:00 - Track: Information Delivery
Speaker: Meagan Longoria
Title: Building your ETL Framework with BIML
Abstract:
SessionID: 36617
Event Date: 02-05-2015 - Session time: 12:45:00 - Track: Sponsor Sessions
Speaker: MSBIC Admin
Abstract:
Imagine the ultimate restaurant experience – great food and service, timely food delivery, entertainment and on-demand check payment. Ziosk delivers this idyllic experience through thoughtful technology and improved data and analytics capabilities. Tablet technology allows diners to relay orders directly to the kitchen, play interactive games, and pay at the table, and also substantially increases the likelihood of survey responses and loyalty enrollment. With real-time data collection, analytic and content management capabilities, wait staff, management and corporate can optimize the customer experience. Kevin Mowry (Ziosk), Al Pappa (Ziosk) and Jeff Johnston (Artis Consulting) share how Ziosk is changing the restaurant game with technologies such as the Analytic Platform System, HDInsight, Azure Machine Learning, Azure Data Factory and Power BI.
SessionID: 36621
Event Date: 02-05-2015 - Session time: 12:45:00 - Track: Sponsor Sessions
Speaker: MSBIC Admin
Abstract:
Customer Engagement is alive, growing and changing faster than ever. It has completely reinvented itself in a handful of years and is creating challenging problems for companies, marketers and data professionals.
Social media and digital advertising is not only making and breaking companies in record time, but is also changing the data landscape and roles of data professionals with the same speed.
Join Rani Monson and John Ellis for a discussion about winning in the Age of the Customer and how you, as a data professional, can be at the center of this exciting new frontier.
SessionID: 36622
Event Date: 02-05-2015 - Session time: 12:45:00 - Track: Sponsor Sessions
Speaker: MSBIC Admin
Abstract:
This session provides an overview of Agile BI strategy and approach and demonstrates how Power BI can be used to jump start BI initiatives within an organization. Please join Gordon D’Souza and Greg Baldini for this discussion.
SessionID: 36723
Event Date: 02-05-2015 - Session time: 12:45:00 - Track: Sponsor Sessions
Speaker: MSBIC Admin
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:
• Create a golden record for any subject area in a matter of minutes
Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 14806
A Date With DAX: Time Intelligence in Tabular and PowerPivot
Event Date: 02-05-2015 - Session time: 14:00:00 - Track: Power BI
Speaker: Greg Baldini
Title: A Date With DAX: Time Intelligence in Tabular and PowerPivot
Abstract:
This session will focus on the time intelligence functions built in to DAX along with writing custom date logic to deal with a range of common reporting requirements.
We will cover the use of the built in functions as well as how to recreate their logic with non-standard calendars.
Some key topics include:
- DAX time intelligence functions
- Date tables
- Filter expressions
SessionID: 20679
Event Date: 02-05-2015 - Session time: 14:00:00 - Track: Information Delivery
Speaker: Mike Diehl
Abstract:
SessionID: 22614
Event Date: 02-05-2015 - Session time: 14:00:00 - Track: Information Delivery
Speaker: Randy Dyess
Abstract:
Join this session for 10 basic SSAS performance improvements you should include in your SSAS environment. Learn how to utilize these basic performance improvements to help improve your ETL, Cube processing, or reporting speeds.
SessionID: 24238
Big Data Analytics with SQL Server 2014
Event Date: 02-05-2015 - Session time: 14:00:00 - Track: Big Data Azure
Speaker: Scott Rylie
Title: Big Data Analytics with SQL Server 2014
Abstract:
During this session we will review the powerful features used to build a Big Data analytical solution on SQL 2014. You will hear many optimization techniques used to load, process, and present over 9 Billion records of data. We will discuss practical tips and real-world examples around core SQL Server, Integration Services, and Analysis Services including Clustered Columnstore Indexes, Table Partitioning, Balance Data Distributor, and Analysis Services partitioning.
SessionID: 26648
Event Date: 02-05-2015 - Session time: 14:00:00 - Track: Information Delivery
Speaker: Tim Mitchell
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
SessionID: 13189
Practical Power BI – Patterns for the Real World
Event Date: 02-05-2015 - Session time: 15:15:00 - Track: Power BI
Speaker: Derek McKee
Title: Practical Power BI – Patterns for the Real World
Abstract:
SessionID: 19219
Overcoming Chartaphobia: Moving Your Organization Toward Interesting and Enlightening Data Viz
Event Date: 02-05-2015 - Session time: 15:15:00 - Track: Data Visualization Business Analytics
Speaker: Meagan Longoria
Title: Overcoming Chartaphobia: Moving Your Organization Toward Interesting and Enlightening Data Viz
Abstract:
SessionID: 21619
Sentiment Analysis with Big Data
Event Date: 02-05-2015 - Session time: 15:15:00 - Track: Big Data Azure
Speaker: Paco Gonzalez
Title: Sentiment Analysis with Big Data
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 23602
In Memory Tables; Not Just For OLTP
Event Date: 02-05-2015 - Session time: 15:15:00 - Track: Information Delivery
Speaker: Russ Thomas
Title: In Memory Tables; Not Just For OLTP
Abstract:
SessionID: 10458
Somebody Got BIDS Helper in My Data Tools
Event Date: 02-05-2015 - Session time: 16:30:00 - Track: Information Delivery
Speaker: Bill Fellows
Title: Somebody Got BIDS Helper in My Data Tools
Abstract:
SessionID: 10460
A guide to loving ETL
Event Date: 02-05-2015 - Session time: 16:30:00 - Track: Information Delivery
Speaker: Bill Fellows
Title: A guide to loving ETL
Abstract:
Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
SessionID: 22045
Big Data Analytics with Excel
Event Date: 02-05-2015 - Session time: 16:30:00 - Track: Big Data Azure
Speaker: Peter Myers
Title: Big Data Analytics with Excel
Abstract:
SessionID: 36627
A Look at Power BI Preview
Event Date: 02-05-2015 - Session time: 16:30:00 - Track: Power BI
Speaker: Rodrigo Gomez
Title: A Look at Power BI Preview
Abstract:
This session will take a look at Microsoft Power BI, specifically the latest Power BI Designer preview and the Power BI app. Utilizing the Power BI service, analysts and BI professionals can quickly create rich visual analytics and leverage data query functionality. The session will also take a look at how BI professionals can utilize the Microsoft Power BI Analysis Services connector.