Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 15
This session you will see how SanDisk in a simple way can help you to accelerate your application, why wait for hours to get the response to your query when you can have it in minutes or seconds.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This half day session is ticket only.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft Excel provides a huge variety of possible standard charts in the Chart Wizard(Insert | Charts | Recommended Charts). Only a few of them are really useful. Many of themshouldn’t be used at all. Even worse, many useful charts are missing, although they shouldbe provided by default.  A closer and critical look at Excel’s standard charts: which ones are useful, whichones are less useful and which shouldn’t be uses at all (and why?)Presentation of a selection of useful non-default charts include:? Description of the chart type (Tornado, Waterfall, etc.): what is it good for?? Showcase: a real use case for this chart type? combination charts / dual axes? formulas and NV data series? dummy data series? invisible data series? formatting tricks? error barsPossible further use cases for this chart type in business and science.Although none of the presented charts are available in Excel by default, the necessarytweaks and hacks are all based on Exce
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Topics:•	Excel Power pivot models: which paths are available?•	Using Excel as prototyping tool and Visual Studio as application building tool.•	The difference between applications, made by the SQL professionals and Excel users.•	Recognize some of the pitfalls in the migration process from Excel to other platforms.•	What will be the role of the Excel user during and after migration to VS.It is very easy to port your Excel Power pivot model to SQL server, Analytic Server and then return the results to Excel of a SharePoint server. Technical spoken no sweat at all, piece of cake. But looking closer at a practical point of view there are many hurdles to be taken in the process. So why should you, as SQL expert,  accept Excel Power pivot models as a source of professional applications? What are there benefits? How can you support the Excel user?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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 valueDave Lawrence Technical Support Consultant – Profisee Software (UK) Limited
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduction to Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this mobile-first, cloud-first era – data is at the intersection – with apps, devices and sensors creating tremendous volumes of data.  To get value out of that data, we must be able to reason over it,  tap into processing power to quickly analyze it and accelerate the insights,  which ultimately lead to better decisions, actions and business results. Companies that put data at the heart of their business operations outperform those that don’t by a significant margin, which we call releasing the ‘Data Dividend’.  We will take a walk through the key technologies from PowerBI to AzureML and IoT to show how to start driving your Data Culture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft Finance - Delivering Business Impact with Excel. Come along and find out how Microsoft Finance use Excel and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

How a Fortune 1000 Silicon Valley data networking equipment manufacturer used all-flash memory storage to consolidate both the number of Data Centers and transformed their business with faster than anticipated RoI and improved business agility.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD


See how the characters from Lord of the Rings can be applied to Business Intelligence. 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.

The Race of Presenting Men:
Avi Perez  (King Aragorn)
Ian Macdonald (Boromir)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

You already know that you can accomplish a lot within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require some knowledge of advanced functionality, including the M language. This session will examine what these requirements might be, how to implement them, and how best to deploy them to end users. We will cover how to create common types of calculations in M, how to best use functions, calling to web services, and OData data sources, and more. We will also discuss the best way to use Power Query with the rest of the Power BI stack, especially PowerPivot.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you'll see a how a data literate business person can use predictive modelling to solve business problems using modern tools. Session outline:1. Gain an understanding of the CRISP-DM methodology that makes advanced analytics easier to comprehend.2. Learn how RapidMiner can be used with CRISP-DM to solve a typical business problem3. Take away best practices that maximise your chance of success4. Next steps
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Many BI projects aim to tell us “what happened?” but sometimes the more interesting question is “what would happen if?”.  To do this we have to generate some plausible scenarios and model our business under these scenarios and then communicate the results effectively.  This talk will present one small example of this.  We will generate the scenarios using R, an open source language for munging data and stats.  We’ll organise the results in a SQL Server database and an Analysis Services cube so that we can compare the different outcomes of each scenario.  Finally we’ll use Power View to explore and visualise the results.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Many people have been put off using Slicers as they think they consume too much of the screen “real estate”, and are plain ugly. This is very true when used straight “out of the box”, and Microsoft have not made it easy to expose the methods of formatting them into objects which can be very pleasing on the eye as well as effective in filtering data.This session will show users how they can format Slicers, and some of the pitfalls and workarounds when trying to group some data items – especially dates.The session will then continue showing how Slicers can be used in Excel 2010 and later to control multiple Pivot Tables with a single click, as opposed to having to write VBA as in previous Excel versions.It will then include information on how to use Slicers with The Table object, which has been made available since Excel 2013. Coupled with the use of the Aggregate function, this can provide a very useful method of summarising data without having to create a Pivot Table first.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Excel has been the main tool for presenting data in a digestible form almost forever. The wealth of facilities on top of the basic spreadsheet functions have helped to power Excel to this position, and to keep it there. As well as the bread and butter spreadsheet function, there are facilities for querying databases, filtering data, grouping, charting, pivoting, and many, many more. Even Microsoft have realised Excel's role, adding more data analysis/BI/BA functionality in the latest Excel releases, 2010, 2013 and Office 365. Even with all of this richness, it's still never enough is it? Sometimes it just doesn't do the thing(s) you need it to do now.You want to do something and it is not in the Excel tool-set? With VBA you can create custom functions, trap use action, format/modify data, even build a complete application.In this session, we are going to build such an application. It will be fast-paced and quite intensive, but all of the files will be made available afterwards.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 15
Back to Top cage-aids
cage-aids
cage-aids
cage-aids