advertisement

Siena calling! Project Siena a RBID App?

54 %
46 %
advertisement
Information about Siena calling! Project Siena a RBID App?
Technology

Published on March 7, 2014

Author: tillmanneitelberg1

Source: slideshare.net

Description

With Project Siena Microsoft has introduced a beta release of a new technology for business experts, business analysts, consultants, and other app imagineers. This session will review if Siena is useful for Business analysts. We will show how to combine simple app development (Rapid R Business Intelligence BI Development D) with different data sources from Excel Sheets (Power Query driven) , RSS Feeds, SharePoint Lists or Windows Azure Tables and how to deploy your little app in minutes. We will discuss the use cases of Siena from a BI perspective, what you can do already and what is missing.
advertisement

Siena calling! Project Siena a RBID App? Oliver Engels | Tillmann Eitelberg

Our Sponsors

Speakers Oliver Engels • • • • • • CEO of oh22data AG PASS Regional Mentor Germany President PASS Germany Chapter Leader Frankfurt, Germany Microsoft MVP Microsoft vTSP Tillmann Eitelberg • • • • • CTO of oh22information services GmbH PASS Regional Mentor Germany Vice-president PASS Germany Chapter Leader Cologne/Bonn, Germany Microsoft MVP

RAD! RBID! Rapid Application Development Rapid Business Intelligence Development eh, what...?

Rapid application development (RAD) is a software development methodology that uses minimal planning in favor of rapid prototyping. The "planning" of software developed using RAD is interleaved with writing the software itself. The lack of extensive pre-planning generally allows software to be written much faster, and makes it easier to change requirements http://en.wikipedia.org/wiki/Rapid_application_development RAD is associated with a wide range of approaches to software development: from hacking away in a GUI builder with little in the way of analysis and design to complete methodologies expanding on an information engineering framework. http://dictionary.reference.com/browse/Rapid+Application+Development

RAD > Für Business Intelligence  RBID: Rapid Business Intelligence Development  Actual generic problems in BI:  Application backlog:     More data More applications More user More devices  Self-Service BI: The solution?

Self-Service BI: Definition Self-Service Integration of privat or local data Modification and Generation of Datamodels Modify Reports and Dashboards Generating Reports and Dashboards ad-hoc Data Stewardship (Optimizing Dataquality) Data Governance Adopted by BARC, Aspekte der Self-Service BI, 2012

Self-Service BI – Microsoft Toolset Power Query Power View SharePoint MDS / DQS Power Pivot Power Map Visio Power BI Portal

Self-Service BI – Landscape Personal Team Team Cloud Visio Visio Services 2013 Excel Power Map Reporting Services Q&A Excel Power View Power View Power View SharePoint Power BI Desktop

Wait! Is this all?

Business Intelligence Applications  Business Intelligence is an island?  NO:  Applications for Data Entry >besides the LOB Systems (ERP, CRM, Web)  Applications for Analysis >besides Portals, Reporting, Cube Browser  Applications consuming „BI“ data  Mobile applications >using just a subset of BI

Business Intelligence Application  With the new Self-Service Toolset MS created a powerfull set of Excel Add-Ins  Is there something similar for building „BI“ applications?

RBID Tool Number 1  Excel      #1 „database“ in the world since 1985 Cell, Matrix, Sheet, Workbook driven Form functions, charts Macro and VBA driven programming File based

RBID Tool Number 2      No. 2 Microsoft RAD Tool since decades More database driven than Excel Better access to form and reporting functions Multiuser functionality Run time engine

RBID Tools: Other kids on the block  Popfly  Rich Internet Application  allowed users to create web pages (Game Creator, Mashup Creator, Web Creator, Popfly Space)  discontinued in 2009  Light Switch  Rapid Application Development  But no self-service tool  Windows Phone App Studio  Rapid Application Development  Build Windows Phone 8 Apps  generates your source code

Project Siena  Microssoft claims:  Create powerful apps for the device-first and cloudconnected world  Enabling Business Users to Create Mobile Apps for the Enterprise  Project Siena is for     business experts business analysts consultants and other business users  Using little more than PowerPoint- and Excel-level skills

Project Siena Is "Project Siena" the RBID we're looking for?

Development Process

Functionality  Build Windows 8 Apps  Completely in HTML5 and JavaScript  works with corporate and web data and media content      SharePoint lists Excel Windows Azure Media Services RSS feeds RESTful services

Sample App

Sample App

Sample App

Sample App

Sample App

Windows Azure Mobile Service  easy way to store data in the cloud  use Windows Azure SQL database, blob storage, table storage or third party services  Easily authenticate users through SingleSign-On Providers (Facebook, Twitter, Microsoft, Google)  Powerful and flexible REST API  SDK for different platforms (Windows, Android, iOS, HTML)

Windows Azure Mobile Service  Create a new Windows Azure Mobile Service  Create different data tables  Create a control table zz_config  Key  Value  Add any table to zz_config

Windows Azure Mobile Services

Windows Azure Mobile Services

Windows Azure Mobile Services

Windows Azure Mobile Services

Provide Images with Windows Azure Storage

Provide Images with Windows Azure Storage

Provide Images with Windows Azure Storage  CloudBerry Explorer for Azure Cloud Storage  Freeware  Commercial Pro Version available  Also available for Google Storage, Amazon S3, HP Cloud, Openstack, Rackspace

Provide Images with Windows Azure Storage

Provide Images with Windows Azure Storage

Provide Images with Windows Azure Storage

Publish Siena Projects  Get a Developer License  Show-WindowsDeveloperLicenseRegistration  Publish the App to the Marketplace  Only with Visual Studio  Convert a „Project Siena“-Project to Visual Studio Solution http://aka.ms/ProjectSienaProductAppForStore  sideloading “line-of-business” apps  Windows-Intune-Company-Store

Publish Siena Projects *.siena Installer Windows Store Editing Yes No No Developer License No Yes No Siena Dev App Yes No No Visual Studio 2012 No No Yes Apllication Start Siena Dev App Windows Start Menue Windows Start Menue Windows 8/8.1 Yes Yes Yes Windows 8/8.1 RT Yes No Yes

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Publish Siena Projects

Limitations  Size restrictions when importing Excel data  Number of rows: 15.000  Number of columns: 100 Local Files (Excel) are stored with absolut path Publish to Windows Store is no Business User job AMS returns max. 300 records, no paging Network-heavy apps may be terminated at startup  Beta doesn’t support SharePoint Office 365    

How to properly close Windows 8 applications Pull and hold until the application is turning

Links  Microsoft Project Siena (Beta) http://technet.microsoft.com/en-us/ProjectSiena  Get Siena http://apps.microsoft.com/windows/en-us/app/microsoft-projectsiena/5ae47651-e8f3-4e41-aab7-e19ab1b80180  Project Siena Function Reference http://aka.ms/ProjectSienaFunctionReference  TechNet Forum Project Siena http://bit.ly/1i2vIsk  Windows Phone App Studio http://appstudio.windowsphone.com/  Microsoft Project Siena (Beta) | Channel 9 http://bit.ly/1mVrZeQ

Links  Microsoft Projekt Siena (Beta) - der AppBaukasten für Windows 8.1 http://www.microsoftvirtualacademy.com/trainingcourses/microsoft-projekt-siena-beta-der-app-baukasten-fuerwindows-8-1  Convert to Visual Studio Solution http://aka.ms/ProjectSienaProductAppForStore

Free ebooks from Microsoft Press Introducing Windows Azure for IT Professionals Programming Windows Store Apps with HTML, CSS, and JavaScript, Second Edition (Second Preview) http://www.microsoftvirtualacademy.com/LandingPageHan dler.ashx?lPage=ebooks&cID=5#appdevelopment

THANK YOU!

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

SQLSaturday #280 - Vienna 2014 > Sessions > Details

Siena calling! Project Siena a RBID App? ... With Project Siena Microsoft has introduced a beta release of a new technology for business experts, ...
Read more

SQLSaturday #313 - Rheinland 2014 > Sessions > Details

Siena calling! Project Siena a RBID App? ... With Project Siena Microsoft has introduced a beta release of a new technology for ... and other app ...
Read more

PASS Summit 2014 > Sessions > Details - sqlpass.org

Siena calling! Project Siena a RBID App? ... With Project Siena Microsoft has introduced a beta release of a new technology for ... and other app engineers.
Read more

SQLSaturday – SSIS-Components.net

Mit unseren Vorträgen “Siena calling! Project Siena a RBID App?”, ... SqlTechMike hat im Windows Phone Store eine App veröffentlich, ...
Read more

SQLSaturday – SSIS-Components.net

... verschiedenen SQLSaturday bei unseren euopäischen PASS Freunden teilnehmen. Mit unseren Vorträgen “Siena calling! Project Siena a RBID App?”, ...
Read more

Siena | LinkedIn

Palio di Siena photo essay. My latest project was to cover the world's oldest horse race in the Italian ... Siena calling! Project Siena a RBID App? 1,426 ...
Read more

08.11.60 by The Anchor - issuu

... Issuu is a digital publishing ... Catherine.,;of Siena prov- Calif ... was A Delocious Project Hope headquarters here concentration .camp ...
Read more