Nr: 305
SQLSaturday #305 - Dallas - BA Edition 2014
SessionID: 10616
Integrating Power BI Technologies with HDInsight
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Blake Price
Title: Integrating Power BI Technologies with HDInsight
Abstract:
This session will focus on the Microsoft technologies surrounding HDInsight, Microsoft's cloud-based Hadoop solution. We will cover HDFS integration through Power Query, Hive integration through Power Pivot, and HDInsight data integration through the SSIS Connector. In addition, we will also look at joining structured Big Data with semi-structured Hadoop data using Parallel Data Warehouse and the Polybase query technology.
SessionID: 10754
Build Analytics Models with Excel Power Pivot
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: Brian Gogle
Title: Build Analytics Models with Excel Power Pivot
Abstract:
This session will cover building models in PowerPivot, the semantic layer of Power BI. It will include examples from both dimensional and non-dimensional models, along with limitations, workarounds and best practices. You will also learn how to incorporate images and other types of content. The session will include a basic introduction of the Data Analysis Expressions Language (DAX) and cover some of the most common expressions that are used in data models.
SessionID: 11037
Natural Language Query in Power BI
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Bryan Smith
Title: Natural Language Query in Power BI
Abstract:
Natural language query (NLQ) allows users to quickly answer questions using simple English-language questions. In this session, we will learn how to enable NLQ in your data models and explore the mechanisms behind this functionality.
SessionID: 11038
Finding and Cleansing Data with Excel Power Query
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: Bryan Smith
Title: Finding and Cleansing Data with Excel Power Query
Abstract:
The hardest part of the analyst's job is finding data to support his or her work. And once that data is found, it is often in less than ideal shape for our needs. With Excel Power Query, the analyst now has capabilities to find and cleanse data, resulting in huge time savings. In this session, you will learn the basics of working with Power Query.
SessionID: 11039
Overcoming Complex Data Cleansing Challenges with Excel Power Query
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: Bryan Smith
Title: Overcoming Complex Data Cleansing Challenges with Excel Power Query
Abstract:
Building off the earlier session, "Finding Cleansing Data with Excel Power Query", we will explore more advanced techniques for cleansing data using Excel Power Query including the use of Power Query expressions. Armed with these techniques, analysts should feel confident tackling some of the gnarliest data cleansing challenges.
SessionID: 11825
How to Train your business users to create their own BI reports?
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Paras Doshi
Title: How to Train your business users to create their own BI reports?
Abstract:
In this session, I'll walk you through strategies tactics that you could use to empower your business users to create their own BI reports.
SessionID: 12139
Data Discovery and Insights using Excel 2013 Power BI
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Derek Dai
Title: Data Discovery and Insights using Excel 2013 Power BI
Abstract:
In this session you will learn how to provide valuable data insights through data discovery and visualisation with Microsoft’s Power BI capabilities. You'll learn how to connect and discover the world's data to enhance data discovery over your own and externally available datasets and how to combine multiple datasets together. You'll also learn how to use existing and new data visualisation capabilities together using Power View and Power Map in Excel 2013, and get a deep drilldown into the Power BI capabilities.
SessionID: 12894
Enterprise Business Intelligence: Past, Present and Future
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: David Browne
Title: Enterprise Business Intelligence: Past, Present and Future
Abstract:
SessionID: 13364
Using Mahout R to Turn Text into Measurable Value
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Big Data
Speaker: Don Hilborn
Title: Using Mahout R to Turn Text into Measurable Value
Abstract:
Regardless of what business we are in, we are generating large volumes of data. Most of this data is unstructured. Valuable information exists in unstructured data. The challenge is how do we find this information, and perhaps even more importantly; draw meaningful correlations with structured data. Mahout and R allow us to find patterns in unstructured data and correlate text and numbers.
SessionID: 13783
An Introduction to Hadoop
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Big Data
Speaker: Eric Mizell
Title: An Introduction to Hadoop
Abstract:
What is Hadoop you ask? Hadoop is an open-source software framework for storage and large-scale processing of data sets on clusters of commodity hardware. In this session, Eric will walk you through Apache Hadoop, what it is and what it isn’t, deployment options, how to use it, and finish with some interesting use cases.
SessionID: 15579
Modern Data Warehousing
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Big Data
Speaker: James Serra
Title: Modern Data Warehousing
Abstract:
SessionID: 16872
Self-Service Data Visualizations with Excel Power View
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: Jeff Johnston
Title: Self-Service Data Visualizations with Excel Power View
Abstract:
In this session, we will continue your Power BI journey and discuss the compelling visualization capabilities of Excel Power View. You will learn just how easy it is to create presentation-ready visualizations and tell an interactive story with your data. If you are intrigued by what capabilities you can unlock with Power BI, then come learn how you can leverage Power View to enhance your analytics experience and maximize value for your organization.
SessionID: 17520
Time Intelligence with Excel Power Pivot
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: Josh George
Title: Time Intelligence with Excel Power Pivot
Abstract:
SessionID: 19194
Don’t Miss Out on Excel Cube Functions
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Meagan Longoria
Title: Don’t Miss Out on Excel Cube Functions
Abstract:
SessionID: 19195
Choose Your Geospatial/Mapping Adventure
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Meagan Longoria
Title: Choose Your Geospatial/Mapping Adventure
Abstract:
SessionID: 19508
Tell Better Stories with Microsoft BI and PowerMap
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Power BI
Speaker: marek koenig
Title: Tell Better Stories with Microsoft BI and PowerMap
Abstract:
Storytelling seems to be a lost art form; in this fast-paced world people are more interested in getting as many bits of information as they can. But without a story, something to pull all the data together, the target audience will probably gloss over your message. Throwing a few numbers and charts at the reader has become pretty acceptable nowadays. But to make something truly memorable, and hopefully shared with someone else, you need some kind of story. You need something to tie it all together, to give it some meaning. That’s where Microsoft steps in with its latest addition to the Business Intelligence Analytics space with an add-in to Excel called PowerMap.
SessionID: 22968
Data Lake and Interactive Query In Hadoop
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Big Data
Speaker: Rommel Garcia
Title: Data Lake and Interactive Query In Hadoop
Abstract:
SessionID: 23684
SSIS project deployments with multiple developers
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Russel Loski
Title: SSIS project deployments with multiple developers
Abstract:
Before SQL Server 2012, it was easy to develop several SSIS packages in a project and deploy each package as you complete it. However SQL Server 2012 introduces the project deployment model. With its awesome features comes the limitation that you can no longer deploy a single package. You must deploy the whole project every time! How do you deploy a project that contains a mix of deployed packages, ready to deploy packages and packages in development?
In this session I demonstrate common problems that arise in the package development lifecycle that affect project deployment. I will then demonstrate how to use Team Foundation Server to address these problems. I will develop the story for handling packages at various stages of development using TFS.
SessionID: 24578
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Sanjay Kaul
Abstract:
SessionID: 26527
Dimensional Modeling 101
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Thomas LeBlanc
Title: Dimensional Modeling 101
Abstract:
This session is going to help create a dimensional Data Mart from the AdventureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.
SessionID: 26799
Pro Tips: Tuning the data flow in SSIS
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Tim Costello
Title: Pro Tips: Tuning the data flow in SSIS
Abstract:
It's not too hard to build a data flow in SSIS quickly. Building a FAST data flow can be a little tricky. In this session I'll show you the things you should be thinking about when designing your data flow and some tricks that can help you move your data faster. In this demo heavy session we will work through examples of slow data flow scenarios and fix them with simple techniques you can put to work Monday morning!
SessionID: 28166
Data Manipulation with Pig
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Big Data
Speaker: Wesley Floyd
Title: Data Manipulation with Pig
Abstract:
This talk will cover the basics of Apache Pig and how it relates to the Hadoop ecosystem. Wes will start with the basics of the Pig scripting language and move towards how it can be used to power your traditional ETL tasks in a Hadoop cluster. The agenda includes:
• History and overview of Pig scripting language
• Examples of how to use Pig
• Demo of how to use Pig to complement your existing ETL jobs
SessionID: 8930
Configuring Security in SharePoint for SQL BI
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Information Delivery
Speaker: Abhishek Srivastava
Title: Configuring Security in SharePoint for SQL BI
Abstract:
Yet, this tends to be a little tricky because the SQL Server Professionals do not understand all SharePoint aspects and vise versa.
To make matters worse, SharePoint architecture underwent a huge change from kerberos to claims and this meant a lot of pervious concepts don't appy and lot of new tools are not claims aware.
The objective of this session is to clarify
- Clarify how to configure SQL BI in a Claims based SharePoint 2013 environment.
- What works and what does not work with claims.
- All necessary terms and concepts provided to SQL Professionals who will them be able to work with the SharePoint teams fearlessly.
- Advanced consultants, will be able to configure the integration between SharePoint and SQL BI completely.
SessionID: 9972
Applied Predictive Analytics
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Visualization Analytics
Speaker: Andy Eggers
Title: Applied Predictive Analytics
Abstract:
The session will take a common Business customer loyalty program problem from beginning to end results. We will cover a framework of analyzing the business problem identifying additional sources of data or business considerations. Then applying techniques to identify the potential customers and placing the business problem into an opportunity, which not only helps the customer but also benefits the company. The results of these efforts I was able to generate 40.1 million dollars of additional sales revenue, which translated into 18 million of Earnings before interest and taxes.