advertisement

Operational Dashboarding and Reporting With Microsoft Business Intelligence Solutions

100 %
0 %
advertisement
Information about Operational Dashboarding and Reporting With Microsoft Business...
Technology

Published on March 10, 2014

Author: diverdown1964

Source: slideshare.net

Description

A great looking, relevant, informative dashboard for the executive is the ultimate end goal for most Business Intelligence projects. Microsoft has all of the tools that are necessary to get data from your transactional systems into an effective dashboard. What is less clear is to how to go about achieving it. Which tools should you use? As with most things, we have different tools for different requirements, and it isn't always clear as to how they match up.

This session will focus on what the various reporting and dashboarding tools from Microsoft can do for you, where you should use them, and how to get them working for you. Both on premises and cloud based scenarios will be discussed. At the conclusion of this session, you should have a fundamental understanding of the Microsoft products in this space fit together, including Excel, Reporting Services, SharePoint, Power View, and PerformancePoint.
advertisement

Operational reporting and dashboarding using Microsoft Business Intelligence Solutions jpw@unlimitedviz.com

Futures, Q &A Agenda Business Intelligence tools Prerequisite s

Power BI Dashboard strategies PerformancePoi nt SharePoint Mashup On Premises Cloud Azure VMs

ONE DOES NOT SIMPLY RETURN HIS RAW DATA FROM THE DATABASE

Data Marts Extract, Transform, and Load (ETL) Middleware Server(s) Data Warehouse Storage Design and Visualization Data Cubes and Tabular Models E T L Reporting Server(s) BI and Designer Clients Source data

EE SQL Server DB SQL Server Integration Services (SSIS) SharePoint (with) • Excel Services • PowerPivot for SharePoint • SSRS SharePoint Mode • PerformancePoint SQL Server DB Storage Design and Visualization SQL Server Analysis Services Multidimensional and Tabular modes L SQL Server Reporting Services (SSRS) Excel SQL Data Tools Report Builder 3rd party tools ETL E T Source data

Worksheets Tabular Data Model (xVelocity) Pivot Charts and Tables Power View (Analytic reports) Power Map (Geospatial and time series data) Power Pivot (Model design) Power Query (ETL) Power Pivot Import (EL)

Power Pivot Worksheets • Pivot Tables and Charts • Power View Data Marts and other Data Cubes and Tabular Models Standard Worksheets • Pivot Tables and Charts PerformancePoint Reports • Analytic Charts and Grids • Decomposition trees SQL Server Reporting Services Reports • Standard • Power View PerformancePoint Scorecards and KPIs

Power BI Excel, Power X, Mobile, Data Management Gateway Dashboard tools PerformancePoi nt (Dashboard Designer) SharePoint (Pages and Filters) On Premises Office 365

Business Intelligence Center 2007 - Excel and Connections 2010 - PerformancePoint 2013 - PerformancePoint and Power Pivot Reports Excel and Connections Web Part Pages SharePoint KPIs

Minimum Viable Product

BISM PowerView in SSRS EffectiveUserNam e() Excel Services PerformancePoint Per User Document Level

Data freshness PowerPivot for SharePoint* Power BI SQL Server Integration Services

SharePoint Excel Services PerformancePoint Filters

Power BI Licensing PerformancePoi nt SharePoint On Premises Office 365

PerformancePoi nt SharePoint Enterprise Power BI Licensing PerformancePoi nt SharePoint On Premises Office 365

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

Operational Dashboarding and Reporting with Microsoft ...

Operational Reporting and Dashboarding using Microsoft Business Intelligence Solutions . John P White. jpw@unlimitedviz.com. @diverdown1964. http ...
Read more

Operational reporting and dashboarding using Microsoft ...

Operational reporting and dashboarding using Microsoft Business Intelligence Solutions. ... on what the various reporting and dashboarding tools ...
Read more

Operational Dashboarding and Reporting With Microsoft ...

1. Operational reporting and dashboarding using Microsoft Business Intelligence Solutions jpw@unlimitedviz.com . 2. Futures, Q &A Agenda Business ...
Read more

Operational reporting and dashboarding using Microsoft ...

... most Business Intelligence projects. Microsoft ... Operational reporting and dashboarding using Microsoft Business Intelligence Solutions ...
Read more

Operational dashboarding and reporting with Microsoft ...

Share Operational dashboarding and reporting with Microsoft Business ... reporting and dashboarding ... Microsoft Business Intelligence Solutions.
Read more

Comment Feed for Channel 9 - Operational reporting and ...

... for most Business Intelligence projects. Microsoft has ... Operational reporting and dashboarding using Microsoft Business Intelligence Solutions ...
Read more

Operational reporting and dashboarding using Microsoft ...

Operational reporting and dashboarding using Microsoft Business Intelligence Solutions, Microsoft SharePoint Conference 2014 IT Professional Office 365 ...
Read more

Operational reporting and dashboarding using microsoft ...

Operational reporting and dashboarding using microsoft business intelligence solutions Jifeed.net
Read more