SQLSaturday #388 - Edinburgh - BI Edition 2015
Event Date: 06/13/2015 00:00:00
Event Location:
- John McIntyre Conference Centre
- 18 Holyrood Park Road
- Edinburgh, , United Kingdom
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Better Data Visualisation for CRM and ERP
Abstract: Come and learn best practices for designing charts to help people understand their business data effortlessly. Need to create charts and dashboards for people to get insight from their complex data and make better business decisions? This session will show you what to do, and more importantly why. Understand the way our brains are wired and take advantage of our ability to process some types of visual data far more easily than others. You will learn some great tips for better visualisation, and common pitfalls to avoid, rather than the technical ins-and-outs of how to achieve this with a specific piece of software. The main focus will be on charts and dashboards for CRM or ERP systems, but the approaches are just as valid using Excel, PowerPivot, SSRS or big analytics products from any data source.
Speaker(s):
- Adam Vero - Dynamics CRM MVP
Track and Room: The Business of Business Intelligence - Pentland East
Title: Customising the Excel Ribbon
Abstract: All applications need some method for the user to interact with. Excel built-in functionality is accessed via the Ribbon, and Excel provides the capability to customise the Ribbon to organise it to your preference. More interestingly, it is possible to create your own Ribbon tabs that can interact with your applications.
This session will briefly show how to add items to the QAT and personalise the existing Ribbon, and then we will develop a Ribbon to manage a number of VBA macros, demonstrating dynamic Ribbon capabilities such as changing the image, and adding/removing items to/from dropdowns and dynamic menus. It will also show how to develop this code for 32 and 64 bit environments, and protect the ribbon from context loss.
Speaker(s):
- Bob Phillips
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Learning R through a typical BI task
Abstract:
R is a language for data munging and stats that is growing in popularity. Many Microsoft BI professionals are curious about R but few have used it on a real project yet. This talk aims to introduce you to the capabilities of R by comparing the implementation of a typical BI task both in Power BI and in R. We’ll load some data from a SQL database, explore the data and ask some basic questions, draw some insightful conclusions and then communicate these to a broader audience.
The purpose of this session is to show R strengths and weaknesses to help you decide if R is a useful language that is worth investing time and effort to learn and master.
Speaker(s):
- Mark Wilcock
Track and Room: Business Analytics Track - Pentland West
Title: Understanding SharePoint reporting options for SQL Server
Abstract: The SharePoint landscape has changed dramatically over the last few years, and this session is designed to help Business Decision Makers, IT Managers and SQL Professionals understand what it offers as reporting platform. Exploring the different options, benefits and considerations for using SharePoint to report on data in SQL Server. Explaining that there are important decisions to make about which platform to use, and whether cloud based services should be considered. It will show a number of SharePoint options including Business Connectivity Services, Reporting Services, Excel Services and Power BI. It will consider the differences in functionality and configuration for different versions of SharePoint and SQL. Including comparing the platforms of SharePoint Server, SharePoint Foundation and Office 365. Finally it will challenge attendees to think about the purpose of the solution being delivered, who it is for and the long term strategy.
Speaker(s):
- Peter Baddeley
Track and Room: The Business of Business Intelligence - Pentland East
Title: Power BI- best practices to deliver just-in-time insights
Abstract: We will overview a detailed options about how to deploy Power BI, how to implement configuration parameters and package BI features as a part of Office 365 roll out in your organisation.
Having said that, cloud computing is another aspect of this technology made is possible to get data within few clicks and ticks to the end-user. Let us review how to manage connect on-premise data to cloud capabilities that can offer full advantage of data catalogue capabilities by keeping data secure as per Information Governance standards. Not just with nuts and bolts, performance is another aspect that every Admin is keeping up, let us look into few settings on how to maximize performance to optimize access to data as
Speaker(s):
- Satya Jayanty
Track and Room: Business Analytics Track - Pentland East
Title: Best practices for collecting and combining data with Power Query
Abstract: So you’ve played around with Power Query in Excel; now it’s time to put it to work. In this session you’ll learn how to ‘think’ in Power Query. You’ll see a number of examples of how Power Query can be used to solve real world problems and understand the best practices and patterns that you can take back to work and use immediately. Examples will include: • Creating and using a parameter table • Combining data from multiple Excel workbooks into a single data set • Handling errors and unavailable data sources • Calling web services, handling authentication and working with XML • Performing sentiment analysis in Excel with Power Query and Azure Machine Learning
Speaker(s):
- Chris Webb
Track and Room: The Technology of Business Intelligence - Pentland West
Title: Business Analytics 101 Jumpstart using Azure Machine Learning
Abstract: Business analytics platforms have always been tools built for statisticians and data scientists. However, these tools are increasingly being directed at business analysts, and Gartner’s rankings on its well-known “completeness of vision” and “ability to execute” axes now ride as much on “ease of use” as they do on offering advanced analytical algorithms. How does this change in landscape affect businesses? Are you new to the world of business analytics? Are you taking over an existing analytics program, or starting one from scratch? This session will help you to understand how to craft a strategy, provision the right business analytical capabilities, and move towards actionable results. We’ll identify common pitfalls to avoid as you start or reinvigorate your business analytics program. In particular, we’ll explore how companies are using self-service and data discovery techniques to deliver more agile analytics using Azure Machine Learning.
Speaker(s):
- Jen Stirrup
Track and Room: Business Analytics Track - Pentland West
Title: Web Scraping with Python - scraping the web, without the sting
Abstract: Need to download data from a website without an API? Scrape it!
Web scraping is a technique for collecting information from websites, especially in ways not intended by the publisher.
Many business have web scraping in their data strategy to open up new business opportunities and remain competitive. It is something that we can all use to make existing data acquisition tasks easier and make new goals possible.
Python is well suited to the task of web data acquisition. Thanks to its simple, clean syntax and interactive shell, it is easy and fun to learn. It is accessible to Business Intelligence professionals with an SQL background.
Scrapy provides an infrastructure for writing scraping programs called spiders. It allows you to achieve more with shorter, more declarative code. It can be used for small and large scraping projects.
In our demo we will study the anatomy of a spider, then use it pull data from a website into Microsoft SQL Server for further analysis.
Speaker(s):
- Iain Elder
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Microsoft SQL Server Data Warehouse Fast Track – Understanding the Program
Abstract: The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimized for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity. This presentation discusses the process undertaken to achieve the certification of a 90TB SanDisk solution whilst achieving an efficient out-of-box balance between SQL Server data processing capability and hardware resources.
Speaker(s):
- Niall MacLeod
Track and Room: The Technology of Business Intelligence - Pentland East
Title: One BI Platform to Rule Them All
Abstract: Whether you are a Data Wizard, a Dwarf mining for insights, an Elf creating elegant visualisations or an ordinary Hobbit seeking business enlightenment before second breakfast, BI Office from Pyramid Analytics can help you achieve your quest for insights and timely business information. By demonstrating how to build a BI Solution in 45 minutes, this session will show you how BI Office can make you a BI Superhero in your organisation!
Speaker(s):
- Ian Macdonald
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Advanced Analytics is where to place your bet
Abstract: We are not short of data and it’s growing at an exponential rate; what we are short of is insight. This talk will cover the latest announcements around advanced analytics, machine learning, and big data technologies to guide you through the future direction of the analytics journey we should all be placing our bets on.
Demos of Machine Learning, Stream Analytics, PowerBI, DataZen
Speaker(s):
- Ric Howe
Track and Room: Business Analytics Track - Pentland West
Title: Big Data’s Missing V: Visualisation. How do you BigViz your Big Data?
Abstract: We all know about Big Data: Velocity, Volume and Variety. What about the missing ‘V” - Visualisation? What does “big data” look like? It has to be more than beautiful; it needs to convey the information and insights in a way that people understand. Further, people expect to be able to make actionable insights from their data, and how can we make big data friendly to users? In this session, we will look at a mix of open source and Microsoft technologies for visualising big data sources, and ways of achieving BigViz harmony in your Big Data
Speaker(s):
- Jen Stirrup
Track and Room: The Business of Business Intelligence - Pentland East
Title: The European Economic Crisis and the Euro-A Data Tale
Abstract: Investigative exploration of data is very often ad-hoc in nature. We might need to interact with many types and soures of data. The Questions we need to ask, and the data we might need to answer them are not set in stone, and as a result following traditional modelling is not always an option. Rather, we follow the data, to an unknown end.
In this session, we take the European Economic Crisis, and the Euro, and see what publically available data can do to give us insights into one of the largest currencies in the world.
See the Microsoft Power BI stack used to tell a real world story
Speaker(s):
- Carmel Gunn
Track and Room: Business Analytics Track - Pentland West
Title: Blue Sky Thinking: SQL Azure Geospatial Mashup
Abstract: In this session we’ll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it’s built in Geospatial features such as nearest neighbour. Then we’ll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business.
Speaker(s):
- Thomas Sykes
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Improve Data Quality, Drive BI Value through Master Data Management
Abstract: Today’s Business Intelligence (BI) systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. Learn how you can use Microsoft SQL Server Master Data Services and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
Speaker(s):
- Dave Lawrence
Track and Room: The Business of Business Intelligence - Pentland East
Title: Optimizing databases with server side flash, understanding what lies beneat
Abstract: In this short technical presentation we will look at some of the options available today which can be employed to optimize database workloads. During the presentation we will look at results from various experiments and try to understand the impact of performance relative to different database components and workloads.
Speaker(s):
- peyman blumstengel
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Creating Dashboards with DataZen
Abstract: With Microsoft’s acquisition of DataZen dashboard and mobile BI is not easier than ever, with DataZen being bundled with SQL Server. Come along and see how to get started with DatZen. We will be showing an end to end demo of creating and publishing dashboards for a mobile and tablet devices.
Speaker(s):
- Bob Duffy
Track and Room: Business Analytics Track - Pentland West
Title: Data Management Gateway Deep Dive
Abstract: Deep dive into the DMG and the hybrid architecture involved by Power BI. How does it work ? Security, Firewall, Certificates, Multiple gateways, Admin delegation, Scale out, Disaster Recovery…. All that topics will be covered during that technical session.
Speaker(s):
- Jean-Pierre Riehl
Track and Room: The Technology of Business Intelligence - Salisbury Room
Title: Troll Hunting on the Internet
Abstract: The phenomenon of anonymous cyber bullies trolling individuals, as a pack, has increased over the years. One of the things that makes this appealing for the trolls is that they feel that they can act with impunity due to the anonymity provided by many social networks. In this presentation we’ll walk through the development of a theoretical application to identify these trolls, and the multiple accounts they hold, via computational lingustics, before using predictive analytics to suggest likely locations for their homes and places of work/education. By removing the anonymity of the Internet we can drive these trolls off of social media.
Speaker(s):
- Gary Short - C# MVP
Track and Room: Business Analytics Track - Pentland West
Title: Visualising and Generating SQL data with Microsoft Visio 2013
Abstract: David will demonstrate how easy it is to not only visualise data from SQL Server, on-prem. or in the cloud, with Visio 2013 Professional , but how you can use structured diagrams and validation rules to create data for your database from a drawing. He will also demonstrate how Visio diagrams stored in SharePoint 2013 can be become interactive dashboards available on any modern device and in any modern browser.
Speaker(s):
- David Parker
Track and Room: The Business of Business Intelligence - Pentland East
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Bob Phillips
Twitter: - @WessexBob
LinkedIn: Bob Phillips
Contact: https://wessexbi.wordpress.com/
I am an independent consultant based in the UK, specializing in all things Excel, especially delivering BI within Excel.
I came to appreciate the power and versatility of Excel as an enterprise tool in the mid-90s when managing the delivery of a data warehouse project.
Now a freelance consultant, I specialize in Excel automation and BI delivered via Excel. An 11 year veteran of Microsoft#39;s MVP program, my life mission is to persuade small and medium corporates that data analysis and BI is important to them too, and that Power BI can help then find that information, in a straight-forward and cost-effective manner.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Bob Duffy
Twitter: - @bob_duffy
LinkedIn: Bob Duffy
Contact: http://blogs.prodata.ie/author/bob.aspx
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.
Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.
Gary Short - C# MVP
Contact: http://uk.linkedin.com/in/garyshort/en
Freelance Data Scientist and Big Data engineer / architect. Weapons of choice include, but are not limited to: Hadoop, HDInsight, HBase, Hive, Pig, Cassandra, Solr, R, SPSS, Python, NodeJS, NLTK, UCINet, Numpy, Scala, F#, Deedle, OCaml, MSSQL and Java.
I’m also a C# MVP and cook up a mean Win8* app, but if it has a data science bent to it, then I’m happier.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Ric Howe
Twitter: - https://twitter.com/ijanric
LinkedIn: Ric Howe
I have always been interested in how we can use technology to enhance the our experience of the world. Technology makes things simpler, but it#39;s often difficult to traverse the myriad of solutions out there, so I have made it my mission to help people achieve the unthinkable by using technology the right way. Cloud computing has revolutionised how we consume technology and made complex and expensive solutions simple and accessible for all businesses.
Chris Webb
Twitter: - @cwebb_bi
LinkedIn: Chris Webb
Contact: https://blog.crossjoin.co.uk/
Chris Webb is a member of the Power BI CAT team. He is the author of “Power Query for Power BI and Excel” and a co-author of “SQL Server Analysis Services 2012: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”.
Iain Elder
Twitter: - @iainsme
LinkedIn: Iain Elder
Contact: http://basetable.wordpress.com
Iain Elder is a data professional focussing in data collection, data management, and process automation.
He began his career scraping the web data barrel to integrate dozens of heterogeneous sources, and now as a database administrator manages a SQL Server estate of hundreds of servers.
His favourite tools for getting things done are SQL, PowerShell, Python and Java.
Dave Lawrence
Twitter: - profiseeuk
LinkedIn: Dave Lawrence
Contact: http://www.profisee.com
Dave has over 30 years’ experience in providing sales support for data management software vendors, at Profisee he works with customers to build help them unleash the power of Microsoft SQL Master Data Services using Profisee’s Maestro Software.
Adam Vero - Dynamics CRM MVP
Twitter: - AdamVero
LinkedIn: Adam Vero - Dynamics CRM MVP
Contact: http://blog.crmguru.co.uk
I help organisations of various sizes and industries to make better use of technology and software to increase efficiency, improve internal processes, enable better decision making, manage collaboration across teams and become more agile in their operations. As an MVP for Dynamics CRM and Microsoft Certified Trainer I deliver various Microsoft Official Courseware “MOC”) courses in Dynamics CRM 4.0, 2011 and 2013 as well as my own bespoke training courses in a range of Microsoft technologies.
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Niall MacLeod
Niall is a Senior Applications Architect for SanDisk, specializing in Microsoft SQL Server and Flash Storage Solutions. Niall has extensive knowledge and experience in utilizing infrastructure resources to deliver application performance. Having began his career in IT in the late 1990s at Data General and EMC, Niall has since worked with several enterprise storage companies; the latter being Fusion-io where he was responsible for the direction of technical marketing in EMEA.
peyman blumstengel
Twitter: - @blumstengel
Peyman Blumstengel, Director of Enterprise sales, Micron, 20+ years in hardware industry, Memory Murali Nagaraj, CacheBox VP Engineering, 20+ years in software development; key implementer in Cluster File System at VERITAS/Symantec; 7 patents in file system amp; storage technology.
David Parker
Twitter: - @VisioRules
LinkedIn: David Parker
Contact: http://blog.bvisual.net
David has been creating data diagrams since the late ‘80s since he was an RIBA architect, and has primarily utilised Visio since 1996 with a variety of data sources, which has often been SQL Server. He has been an MVP for Visio for over 11 years, written three books about customising Visio, maintains an intermediate / developer blog about Visio, provides Visio training and consultancy around Europe. He started his own data visualisation company, bVisual ltd, in 1998.
Carmel Gunn
Twitter: - @carmelgunn
LinkedIn: Carmel Gunn
Contact: http://blogs.prodata.ie
Carmel is the Managing Director of the Prodata SQL Centre of Excellence in Dublin, Ireland, where she is a data management specialist, working in the areas of analytics and visualisations.
As a committee member for the SQL Server Ireland User Group, she has played an active roll in bringing 2 SQLSaturdays to Dublin, and is heavily involved in the SQL community.
Peter Baddeley
Contact: http://www.baddaz.com
Peter is a Solution Architect focusing on delivering Microsoft solutions including SharePoint, Dynamics CRM and Office 365. He has been working with SharePoint since 2004, lives in Cambridgeshire (United Kingdom) and can often be found on Twitter (@Baddaz) or his blog (www.baddaz.com). Peter is one of the organisers of East Anglia Region of the SharePoint User Group UK. His working life is spent leading a team of consultants delivering Microsoft Solutions to companies across UK and Ireland.
Thomas Sykes
Twitter: - @sqltomato
LinkedIn: Thomas Sykes
Contact: http://sqltomato.com/
Tom is a Senior SQL Server consultant for Quorum Network Resources, a Microsoft Gold Data Platform Partner based in Edinburgh. He is a MCT in addition to being multiple MCSE in Data and Cloud. Current projects include SQL Infrastructure and Performance Tuning, Hybrid Azure SQL Solutions and SQL 2014 migrations.
Jon Woodward
Twitter: - @jlwoodward
LinkedIn: Jon Woodward
Jonathan Woodward is the UK Business Lead at Microsoft focused on the Data Platform covering:
- Business Intelligence
- Analytics
- Big Data
- Data Science
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Ian Macdonald
LinkedIn: Ian Macdonald
Contact: http://uk.linkedin.com/pub/ian-macdonald/1/381/2a1
Ian is a data wizard, who has nearly 30 years’ experience in the Enterprise Business Intelligence market. Starting in Technical Support, training and consulting with Information Builders in 1986, he subsequently developed a career in presales, product marketing and marketing , holding senior VP positions with companies such as Microsoft, Hyperion Solutions and HP. Ian has been working with Pyramid Analytics for five years, initiating their UK presence in 2011.
Mark Wilcock
Mark is an independent consultant specializing in the analysis, reporting and visualization of financial data. Over the last 20 years, he worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He#39;s the organizer of the London Business Analytics Group, a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalized Medicine. He blogs at zomalex.co.uk
Jean-Pierre Riehl
Twitter: - djeepy1
LinkedIn: Jean-Pierre Riehl
Contact: http://blog.djeepy1.net
Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.
Sponsors
The following is a list of sponsors that helped fund the event: