http://www.sqlserverlaunch.com/WW/Agenda
Check out the complimentary public Power
View Sandbox for hands-on evaluation.
Social Analytics
Social analytics enables companies to keep a constant pulse on the marketplace by reviewing customer sentiment, likes, dislikes and hot topics at any given moment. Extended Results has built several incredibly useful, free, social analytics solutions for Microsoft Business Intelligence using PowerPivot and Visual Studio Tools for Office. There is a solution for Twitter, LinkedIn and Facebook. Extended Results also has related analytics tools for monitoring retail TAG campaigns. You can review and download the social analytics PowerPivot's at http://www.extendedresults.com/products in the Social Insights section.
The December 2011 Cumulative Update for SharePoint 2010
further improves the iPad SharePoint BI experience. The SharePoint
Product Team Blog announcement was made on December 19, 2011. With this
cumulative update, users can better view Microsoft BI artifacts on iPad
devices running the iOS 5 Safari browser.
Here is a TechNet article
http://technet.microsoft.com/en-us/library/hh697482.aspx that provides
the iPad viewing and configuration details.
Playing with the Big Data Hadoop ODBC Driver
http://blogs.msdn.com/b/sqlcat/archive/2011/12/14/helping-to-make-hadoop-easier-by-going-metro.aspx
There are multiple ways to manage Microsoft BI metadata, impact analysis, dependency analysis and lineage. In SQL Server 2012, these features will be available in the "Project Barcelona" SQL Server Feature Pack installs. A live preview can be tooled with at http://projectbarcelona.cloudapp.net.
A current option fan favorite is the low cost BI Documenter by Pragmatic Works:
http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx.
BI Documenter works with the full BI stack - database, SSIS, SSAS, SSRS
- with versions 2005 and up. It has many nice features such as a
metadata editor, object change compare viewer, dependency graphing, workflow
and totally automated solution documentation.
Another current
option is the Microsoft Metadata 2008 Toolkit at
http://sqlmetadata.codeplex.com.
The metadata toolkit tracks data
lineage, technical metadata, and performs impact analysis for SSIS, SSAS,
SSRS, and SQL. Features include:
-
Database Repository to store the metadata
-
Stand-alone Dependency Analyzer program to view dependencies.
-
Report model for ad hoc reporting on technical metadata.
-
Reports on impact analysis, dependency analysis, lineage
|
Tool / feature |
Description |
|
Dependency Analyzer (DependencyAnalyzer.exe) |
|
|
Dependency Viewer (DependencyViewer.exe) |
Show dynamic graph of dependencies for SSAS,
SSIS, SQL RDBMS (dependencies and lineage of objects in the lineage
repository) |
|
Data Source View |
A DSV that connects to the lineage repository
(SSIS META database) that can be used by Reporting Services. |
|
Lineage Repository |
A database called SSIS_META that can be used
to house metadata from nearly any system. |
|
Reports |
Standard reports for impact analysis studies.
You will find two key reports out of the box with several
sub-reports |
|
Report Model |
A report model that you can use with Report
Builder to allow end-users to create ad-hoc reports. |
|
Integration Services Samples |
A few sample packages to start auditing and
viewing lineage on. |
Additional Metadata Management Resources
SQL Server Metadata Toolkit
http://archive.msdn.microsoft.com/SqlServerMetadata/Release/ProjectReleases.aspx?ReleaseId=1174
Managing
Metadata in SQL Server
http://msdn.microsoft.com/en-us/library/cc966384.aspx
http://ecn.channel9.msdn.com/o9/te/Europe/2010/pptx/bin308.pptx
http://msdn.microsoft.com/en-us/library/ff487016.aspx
http://www.microsoft.com/download/en/details.aspx?id=28145
Microsoft® SQL Server® 2012 PowerPivot® for Microsoft® Excel® 2010
Release Candidate 0 (RC0)
http://www.microsoft.com/download/en/details.aspx?id=28150
http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/11/17/what-s-new-in-power-view.aspx
http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx
Are you thinking about deploying PowerPivot, Excel Services, Reporting Services and/or PerformancePoint dashboard tools in your environment? If yes, then the following Microsoft IT Showcase articles and downloadable white papers are a must read to jump start your project. They cover topics like having the right onboarding processes in place, governance controls and much more.
-
Using SharePoint and Microsoft Consolidated Business Intelligence to create a Personalized, Company-Wide Business Intelligence Portal and an Enterprise Report Catalog
http://technet.microsoft.com/en-us/library/bb735122.aspx -
Using Excel Services to Improve Data Retrieval Performance
http://technet.microsoft.com/en-us/library/hh530055.aspx -
Using Microsoft PowerPivot for Excel 2010 and SharePoint 2010 to Deliver Data as a Service for Centralized Reports, Dashboards, and BI Applications
http://technet.microsoft.com/en-us/library/hh499043.aspx
http://blog.oraylis.de/2011/08/semi-additive-measures-in-dax-bism-tabular/
Public Preview of SQL Azure Reporting
A live demo of Azure Reporting can be reviewed at http://oakleaf-ssrs.cloudapp.net. A general public preview release of SQL Azure Reporting is now available. This technology may have a lot of interesting field applications. If you want to tool around with it, here are the steps:
-
You will need a Windows Azure Platform account in order to participate in this preview. If you already have an account, proceed to step 2. If you do not already have an account, please visit the "Start Now" section on http://www.microsoft.com/en-us/sqlazure/database.aspx. You will find Free Trial offers which will allow you to participate.
-
Logon to Windows Azure portal (http://windows.azure.com), click "Reporting" on the left side navigation menu, then click "Create a New SQL Azure Reporting Server" in the main content area. After you accept the "Terms of Use", you can proceed with the self-guided wizard to complete the rest of the provisioning procedures. One tip of best practice is to choose a "Region" that is close to the physical location of your business for better performance, presuming you have already chosen the same location for your SQL Azure database server.
-
Once you have a new SQL Azure Reporting server, you can then deploy reports to the new server and test the new release.
If you have any questions regarding the release, please
post questions to the following forums:
SQL Server Reporting Services forum:
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/
SQL Azure forum:
http://social.msdn.microsoft.com/Forums/en-CA/ssdsgetstarted/
SQL PASS Announcements on Denali = SQL 2012
Literally some BIG announcements today and demos of mobile BI on a variety of devices (even an iPad) at SQL PASS Summit: http://www.sqlpass.org/summit/2011/ . Super quick summary of my take away points. There will be much more to come on these topics.
-
SQL Denali Official Name = SQL 2012
-
Project Crescent now called “Power View” and it WILL have storyboard and export to PowerPoint features initial release time! This export to PowerPoint allows users to update and interact with the exported reports. Another key announcement is Power View w/Hadoop, more info below...
-
Mobile BI: During the keynote Amir Netz demonstrated Power View on a variety of mobile devices iPad, Windows phone, tablet, etc.
-
The release of Hadoop connector for SQL Server and Hadoop connector for SQL Server Parallel Data Warehouse free to licensed SQL Server customers. These connectors will enable bi-directional data movement across SQL Server and Hadoop enabling customers work effectively with both structured and unstructured data. Also a strategic partnership with Hortonworks to help enable Hadoop to run great on Windows Server and Windows Azure. Related but not shown is
-
Integration of Apache Hadoop and Windows Hadoop versions with Microsoft’s BI Platform to enable users to use Excel, PowerPivot for Excel and Project Crescent/Power View to perform analysis on Hadoop datasets in an immersive and interactive way. Check out the Hive ODBC Driver and Hive Add-in for Excel.
-
New Data Explorer Azure mash ups with multiple data sources and data services types
Big
Data, Hadoop + PDW Better Together: must see for data lovers!
http://www.sqlpass.org/summit/2011/Live/LiveStreaming/LiveStreamingFriday.aspx
Microsoft Big Data Resources
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/big-data-solution.aspx
I just watched the recording of Dr. DeWitt from PASS since I did not get
to go. I thought the points on how/when to use Hadoop and PDW put into
context what the practical future roadmap looks like and how a future
multiple universe data management system will work to bridge both structured
and unstructured data worlds. For current state, the realities of Hadoop
simple join and analysis query performance pains, Hadoop query syntax
impracticality for businesses and how/when PDW analytic queries perform
much better than Hadoop queries are very helpful to understand for data
architects dealing with data explosion. The bottom line seems to be a
better together message: Hadoop + PDW.
September 2011
Playing with New Denali Business Intelligence Features
The Microsoft Product Team recently posted instructions on how to quickly set up an environment with the free Denali CTP 3 downloads that you can refer to to start playing around and testing the new MDS, DQS, SSIS, Business Intelligence Semantic Model Analysis Services Tabular Mode, Project "Crescent", SharePoint Integrated SSRS, and other Denali features. The set up instructions can be found here: http://blogs.msdn.com/b/oneclickbi/archive/2011/07/21/getting-up-and-running-with-sql-server-denali-for-business-intelligence-crescent-and-powerpivot-in-ctp3.aspx. Note these do not cover set up for all Denali features - primarily the Business Intelligence ones. DQS and MDS require some additional set ups/configurations I will be posting soon.
Also Denali sample files are here: http://social.technet.microsoft.com/wiki/contents/articles/sql-server-samples-readme.aspx#Readme_for_Crescent_Samples_Denali_CTP3.
August 2011
Visio Services Data Driven Visualizations in SharePoint
I just gave a quick demo of this powerful and amazing feature that is often overlooked in the SharePoint Business Intelligence visualizations. Note that Visio Services in SharePoint 2010 does not require the viewers to have Visio - the diagrams are rendered as images or Silverlight. These images can be connected to external data sources to provide live, rich visual context. You can also add interactivity into diagrams to enable drill-through and also pass parameters to other web parts. Here are a few samples of a simple heatmap, retail floor plan connected to POS data, hotel room availability, a strategy map, a business process diagram and a map. There are many other examples that overlay images and objects to get even more creative!
To learn more about Visio Services Data Driven Diagram features check out:
- Enhance your Data with Graphics
- Introducing Visio Services
- Publishing Diagrams to Visio Services
- Embedding a Web Drawing in a SharePoint Page
- No Code Mashups with Visio Services and Web Part Connections
- The Visio Services JavaScript Mashup API
Business Intelligence on Mobile Devices Part 2
In my mobile business intelligence testing thus far, I am really enjoying PowerPivot and SharePoint usage on my tablet!!! The SharePoint PowerPivot Gallery works fantastic and so does PowerPivot dashboard display in a tablet browser. It is easy to zoom, change selections and manipulate. The tablet version of PowerPivot also has the same rich feature set as the desktop version. There will be more to come on this topic as I start testing SSRS and PerformancePoint. Also earlier this year I reviewed some mobile Microsoft BI vendors and mentioned I would be further evaluating these tools. Extended Results http://www.workplaceformobile.com/ by far has the best offering to allow you to build once and deploy anywhere. They also have Apple iPad/iPhone apps to make it easy for those users as well as the other mobile devices like Blackberry, Andriod, Windows Phone etc. Here are a few screen shots of their products on my slate and mobile phone.
NOTE: December 2011 Blog Microsoft has improved mobile BI capability with iPad
Extending
Project Server 2010 Business Intelligence
Great white paper for using PerformancePoint Services with
Project Server 2010 written by Emmanuel Fadullon, Delivery Architect
Microsoft Consulting Services. The document provides a detailed guide
for Microsoft Project Server 2010 users who want to extend Project Server
Business Intelligence (BI) features. It provides a few nice visualization
samples - risk matrix, custom KPIs, decomposition tree and strategy
maps to name a few. Note it does not cover the out-of-box Project Server
reports. This is about taking the Project Server data to a whole other
level. Check out
http://blogs.msdn.com/b/chrisfie/archive/2011/08/16/performancepoint-services-for-
microsoft-project-server-2010-white-paper.aspx
Brainware: Automate Unstructured Document Data Extraction
Just
saw Brainware's brilliant usage of data mining neural network technology
to extract and store unstructured data that in turn can be incorporated
into your data warehouse, ERP, SharePoint or enterprise search. Imagine
the possibilities...unstructured data represents 80% of the world’s
document content! Check it out
http://www.brainware.com.
SharePoint BI/Excel Services Tip!!!
If you have multiple pivot tables/charts in a SharePoint EWA web part you can use a slicer as a controller to those multiple objects and pass parameters to the slicer from an EWA filter. To pass multiple values in the EWA filter parameter use a comma separated string. I am going to play with this over the weekend for show and tell. Cool!
July 2011
SQL Server Denali CTP 3 Now Available for Free Download
PowerPivot v 2.0 / Denali
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26721
Project Crescent Denali
http://social.technet.microsoft.com/wiki/contents/articles/project-crescent-overview.aspx
SQL Server Denali
http://blogs.technet.com/b/dataplatforminsider/archive/2011/07/11/
sql-server-code-name-denali-ctp3-is-here.aspx
CTP3 highlights: This preview is packed with additional functionality and core capabilities that deliver against key customer benefits including:
- Greater availability. AlwaysOn, a flexible, integrated high availability and disaster recovery solution that helps businesses increase availability for mission critical applications, lower TCO and simplify setup, configuration and monitoring.
- Project “Apollo,” a new column store index that offers 10-100x star join or similar query performance improvements available for the first customer preview.
- Project “Crescent,” available to customers for the first time. Get your hands on the data exploration and visualization tool that everyone is talking about and enables end users to explore data at the speed of thought.
- Credible, consistent data. Provide a consistent view across heterogeneous data sources with the BI Semantic Model (BISM) a single model for Business Intelligence applications, from reporting and analysis to dashboards and scorecards
- Productive development experience. Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Developer Tools code name “Juneau” for a unified and modern development experience across database, BI, and cloud functions.
- Comprehensive upgrade and migration tools. Upgrade Advisor and Distributed Replay provide thorough analysis and testing of current SQL Server applications before upgrading so DBAs know what to expect. SQL Server Migration Assistant (SSMA) can automate migrations of non-SQL Server databases to SQL Server Code Name “Denali”.
New SQL Server Denali Data Quality Services - "What and How"
Check out all the good free videos on the upcoming SQL Server brand new Data Quality Services features to learn both the "What and How" of this addition to SQL Server. http://msdn.microsoft.com/en-us/sqlserver/hh323832.aspx
Preview Data Impact and Lineage Analysis as it Evolves
Preview Microsoft impact and data flow analysis at http://projectbarcelona.cloudapp.net as it evolves. The preview contains a fictional sample data topology and will be refreshed every few weeks.
June 2011
Using PowerPivot as PerformancePoint Data Sources
I just finished a really fun BI POC build. In this POC, I have been using an Excel PowerPivot .xlsx file as a PerformancePoint data source! I was skeptical but hey it works even better that I thought it might. I have PerformancePoint Filters, PerformancePoint Analytic Charts, "slice/dice", drill downs etc. all sourced from an Excel PowerPivot file that using Tabular data sources versus SSAS OLAP Cubes. It was fast, easy and actually pretty cool. If you want to give this a try for yourself, here is a TechNet link that describes the PowerPivot in PerformancePoint connection string. http://technet.microsoft.com/en-us/library/ff191197.aspx
The
key was to create a data source that points to the URL of the PowerPivot
file in the connection string:
PROVIDER=MSOLAP;
DATA SOURCE=http://SharePoint2010Site/DocumentLibraryName/PowerPivotFileName.xlsx
(Note that I did not need the TechNet mentioned hotfix to do this stuff;
try it first without that hotfix install hoopla.)
A few things that did not seem to work are Parent-Child Hierarchies in Tree Filter Controls and the PerformancePoint specific Time Intelligence fomulas. However, overall it works pertty well.
Undocumented SSRS 2008R2 with SSAS Stricter Parameter Naming Change
There is an undocumented SSRS 2008R2 with SSAS behavior change that
you may encounter with parameter names. Starting in 2008R2, you
can not use reserved words as parameter names. For example, I
have used STRTOSET(@Set) as an SSRS parameter with SSRS 2005 and SSRS
2008 for querying date ranges with Calendar control parameters with
SSAS cube reports. After upgrading to SSRS 2008R2 I could not figure
out what was going on when none of my SSAS cube date range reports were
working. A simple parameter name change from @Set to
@DateSet fixed them all!!!! I hope this tidbit helps
someone else.
SQL Server 2008R2 Data Quality and Master Data Management
Just came across a Data Quality and Master Data Management free ebook
from Solid Quality Mentors at
http://www.solidq.com/ce-en/AboutUS/Documents/DQMDM_SQL2008R2.pdf.
Microsoft Analytics for Twitter
Cool! Interested in querying and monitoring Tweets? Check
out Microsoft Analytics for Twitter http://blogs.msdn.com/b/oneclickbi/archive/2011/06/10/
microsoft-analytics-for-twitter.aspx
Analysis Services Operations Guide
Analysis Services Operations Guide released
http://msdn.microsoft.com/en-us/library/hh226085.aspx .This paper
is a very deep dive into monitoring, capacity plannning, and diagnosing
SQL Server 2008 Analysis Services operations issues.
More
MS BI with SAP
SQL CAT White Paper
http://sqlcat.com/whitepapers/archive/2011/01/26/
using-sql-server-powerpivot-for-excel-to-analyze-sap-data.aspx on
how to use PowerPivot to empower business users to integrate and analyze
SAP and non-SAP data to ease and accelerate analytics. The paper
reviews six scenarios where PowerPivot is used to analyze SAP ERP or
SAP BW data:
- Importing data into PowerPivot via an Excel PivotTable connected to
SAP BW
- Importing data into PowerPivot via SQL Server Reporting Services connected
to SAP BW
- Importing data into PowerPivot from a text file generated using SAP
BW Open Hub Service
- Importing data into PowerPivot from a SQL Server Analysis Services
cube connected to SAP BW created using ERP-Link iNet.BI
- Importing data into PowerPivot using Xtract PPV connected to SAP BW
- Importing data into PowerPivot using Simplement Data Liberator connected
to SAP ERP
May 2011
Tech Ed 2011 Session Videos, Decks and Demos available for FREE!!!
Miss
Tech Ed 2011 but would still love to learn the material, see live demos
of the cool, new interactive dashboarding/reporting tool Project Crescent
among other BI, Azure and Database Technical content? The BI sessions
are posted at
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011?sort=
status&direction=asc&term=&t=database%2B-and-%2Bbusiness%2Bintelligence
Crescent Dashboard Demos check out
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011?sort=
status&direction=asc&term=crescent
Creative PowerPivot Dashboards "Killer Real-World PowerPivot"
at
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011?sort=
status&direction=asc&term=powerpivot
Just
finished watching "Enriching Your BI Semantic Models Using
Data Analysis Expressions (DAX)"
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI408
Demos of PowerPivot features and DAX language enhancements:
- Multiple table relationships
- Role playing dimensions
- Relationship diagrams designer
- Date type table and better Time Intelligence
- Hierarchies / Parent Child
- Restore Excel PowerPivot to BISM Server Model
- DAX server queries and language improvements
- Statistics STDEV, VAR, and more
- Rank, Top N, Switch and more
- Many to many optimizations via DAX
Business Intelligence Roadmap Updates from T.K. Anand
Great
news from TechEd North America 2011 on Denali. Key points: There will
be options of multidimensional or tabular semantic data models, cached
storage or passthrough storage with a highly performant in-memory column
store engine and reporting tools like Project Crescent, SSRS, PerformancePoint
and Excel will be able to consume either model. Get the details at
http://blogs.msdn.com/b/powerpivot/archive/2011/05/16/
analysis-services-vision-amp-roadmap-update.aspx.
Business Intelligence on Mobile Devices
Mobile business intelligence questions seem
to be popping up everywhere!!! If you are using Microsoft Business
Intelligence (SharePoint, PerformancePoint, PowerPivot, SSRS, Excel Services,
Visio Services...) there are some out-of-box mobile features. For
example, here is a great article that contains tips and screen shots on
"PowerPivot on the iPad: Best Practices"
http://performancepointblog.com/2011/05/powerpivot-on-the-ipad-
best-practices/comment-page-1/.
There are also a variety of third-party tools being used in combination with the Microsoft Business Intelligence tools by Fortune 500 companies. For mobile business intelligence, here are a few products to check out:
- Extended
Results PushBI or WorkPlace for Mobile
(EXCELLENT FOR MICROSOFT BI!)
PushBI or the new WorkPlace for Mobile integrates with all the Microsoft tools, SQL, SSAS, SSRS, SharePoint and Excel. Plus it integrates in Active Directory and several other Windows Server and IIS features to provide a very personalized experience. It also delivers other enterprise web applications through its smart business "shell" that is available on all the major mobile os platforms and media tablets. This platform is currently used by several large corporations and is installed and configured in less than one day!!!
http://www.pushbi.com/
http://www.workplaceformobile.com/
- RoamBI
(BOO!!!....for Apple only, just added Blackberry and Torch,...pretty graphics?)
http://www.roambi.com/
- Blue
Granite Nitro (Free basic level displays)
http://www.blue-granite.com/site/Solutions/BlueGraniteNitro/tabid/173/Default.aspx
http://performancepointblog.com/2011/02/business-intelligence-on-windows-phone-7
-a-review-of-bluegranite-nitro-for-wp7/
Fetch! (One to watch...v. 1 features at the moment)
http://www.idvsolutions.com/Products/Fetch/
Events
May is event month or so it seems. If you are attending SQL Rally in Orlando, Florida -or- Tech Ed in Atlanta, Georgia - give me a shout!!!
This month there will be sooooo much exciting Denali BI information being discussed including: Crescent, BISM, Data Quality Services, Master Data Services, SSAS tools changes and the future roadmap. If you do go to Tech Ed, don't miss out on the BI Power Hour. It is one hour jam packed with fun demos of the latest and greatest BI products by the product groups.
The
Data Loading Performance Guide
This guide covers bulk loading design patterns and best practices.
It also talks about how the TPCH ETL World Record was achieved. A MUST
READ for every Microsoft data warehouse ETL developer.
http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx
Analysis Services Performance
Guide
While on the topic performance guides, SSAS also has a similar
MUST READ for SSAS developers.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=
3be0488d-e7aa-4078-a050-ae39912d2e43&displaylang=en
Recently I was asked by a client about Microsoft SSRS on top of SAP/BW. It turns out there are a lot of great demos and links available on this topic. If you are thinking about more than just SSRS - say SSIS, SSAS, PerformancePoint and PowerPivot then the SAP BI interoperability papers are a good overview for the end-to-end offering.
Short older Demo
Video of using SQL Server 2005 Reporting Services with SAP NetWeaver
Business Intelligence
http://download.microsoft.com/download/8/9/8/8989f3db-73a5-4edd-aad7-e9b1cd840250/SAP_SSRS.wmv
Whitepaper Using SQL Server 2008 Reporting Services with SAP NetWeaver
Business Intelligence
http://msdn.microsoft.com/en-us/library/cc974473.aspx
Whitepaper How to use parameterized MDX in Microsoft SQL Server
Reporting Services for SAP BW InfoProvider access
http://download.microsoft.com/download/C/3/9/C398C9EA-065E-4C7F-A208-99ED2D23A987/Parameterized%20MDX%20in%20SQL%20Server%
20Reporting%20Services%20for%20SAP%20BW[2].pdf
Several more SAP BI interoperability papers
http://www.microsoft.com/isv/sap/technology/interop/bi.aspx
April 2011
Data Warehousing Best Practices and Guides
Data Warehouse Fundamentals
http://it.toolbox.com/wiki/index.php/Data_Warehouse_Fundamentals
Data Warehouse Fundamentals
http://www.rkimball.com/html/articlesFundamental.html
Best Practices for Data Warehousing with SQL Server 2008
http://msdn.microsoft.com/library/cc719165.aspx
DWMantra.com
http://www.dwmantra.com/dwconcepts.html
Data Warehouse Maturity Level
http://sharepoint/sites/bpdcxstg/SQLCAT/Documents/Tier%201%20DW%20Toolbox
/Data%20Warehouse%20Maturity%20Model.pptx
SQL Server 2012 RC0 Released
SQL Server 2012 Resources
Download Deep Dive
Decks, Videos and Papers
Mobile BI for Microsoft:
Extended Results
supports a variety of mobile
devices including Windows,
Andriod, BlackBerry, iPad
and iPhone and others. http://www.workplaceformobile.com.
This mobile BI option supports all sorts of data sources, SSRS, PowerPivot, PerformancePoint, documents, ERP, CRM...and on and on. They use a "feeds" type architecture with URL pointers to “push” existing content to mobile devices. Reusable queries for KPIs, scorecards and reporting in a fully interactive environment. Get the most mileage out of what you already own! Check you mobile device "app store" to install a trial version.
