Showing posts with label Demo. Show all posts
Showing posts with label Demo. Show all posts

Monday, November 15, 2010

Webcast Update - Offering PowerPivot as a Service - Best Practices from Microsoft IT

 

MICROSOFT TECH ED DEMO VIDEO:
Offering PowerPivot as a Service - Best Practices from Microsoft IT :: 2010 :: Europe :: Microsoft Tech·Ed

Recorded:
Sanjay Soni, Microsoft
Thomas Pagel, Avanade

Length: 58 min

Agenda:
See how Microsoft IT is deploying PowerPivot as a service for Microsoft, and how it is being used to enable self-service BI from EDW. We will share best practices, in collaboration with SQLCAT, for technical architecture, configurations, on-boarding, training and evangelizing across the enterprise. We will also provide in-depth technical details surrounding some complex case studies surrounding PowerPivot, specifically: providing PowerPivot as an Online Service, and PowerPivot High Availability and Scalability.

Content:
00:00 – 05:30   Opening Slides
- Microsoft IT EDW Architecture and BI Engineering Platform Slide (01:30)
- “Business power users encouraged to create reports and were provided capability to publish their reports”

05:31 – 9:30   CBI Demo
- Logging In (05:31)
- Enterprise Report Catalog – metadata (07:00)
- Open PowerPivot report (08:30)

09:30 – 16:00   CBI Slides
- Building the Enterprise Data Warehouse (09:30)
- Using Excel for Data Warehouse reporting (11:45)
- Introducing PowerPivot (13:30)

16:00 – 23:30   PowerPivot in 10 minutes
- Selecting Data from multiple sources (16:30)
- Create Linked Table (17:30)
- Create Relationships (18:45)
- Create Cube (19:45)
- PowerPivot Slicers (20:30)
- Publish to SharePoint (22:00)

23:30 – 26:00   Questions & Answers

26:00 – 40:00   EDW PowerPivot Sandbox and Data Services Layer
Architecture Slide (26:50)
Architecting the EDW PowerPivot Sandbox Environment Slide (30:00)
EDW PowerPivot Sandbox Onboarding Process (32:30)
CBI Onboarding Demo (34:00)
CBI Video Channel – Academy Live (36:45)

40:00 – 44:00   PowerPivot Service Architecture
IT Got Out of the Box BI Dashboards (40:50)
The Result (41:45)
Today, and In the future (42:10)
Data as a Service – Enterprise Data Distribution Platform (43:10)

44:00 – 46:00   Data as a Service (DSL) Demo

46:00 – 47:30   PowerPivot - SAP Integration Experience

47:30 – 54:30   Top 10 Lessons learned
- Build your BI reporting infrastructure in parallel with (or even before) the enterprise data warehouse
- Architect with the enterprise vision in mind (security, scalability,…)
- Evangelize to achieve enterprise adoption
- Support users to find relevant data
- Empower users to create their own business intelligence
- PowerPivot is no Enterprise Data Warehouse replacement
- Remember that PowerPivot has “digital” security: “Access” or “No Access”
- PowerPivot supports flat organizations: There are no hierarchies!
- Effective performance with 64bit version of Excel client
- Start using PowerPivot now….

55:00 -  Resources, Questions & Answers

Refer to CapstoneBI for Metadata and PowerPivot solutions
www.CapstoneBI.com

Wednesday, April 14, 2010

Microsoft BI Demo, VPC 7.1 - Expiry

A couple years ago, Microsoft made available a pre-built, virtual demo environment (BI VPC 7.1) that included demo scenarios for fictitious businesses called 'Contoso' and 'AdventureWorks'.  This demo environment consisted of Excel 2007, SharePoint 2007, SQL Server 2005, PerformancePoint Server and ProClarity.

Several BI consultants (and internal MS field teams) have used this virtual image over the years.  Many folks have further customized this environment to showcase sample data sets and scenarios, and to build Proof of Concepts.

This week I heard from one such consultant whom I have been in touch with for several years, Eliot MacDonald (Director of Consulting Services, Market Forte).  Eliot works with SSAS and ProClarity quite a bit, and he has used the BI VPC 7.1 extensively. 

Eliot emailed me yesterday to mention the Expiration Date of the environment... 

the latest “BI-VPC” has a deadline of 2 days from now. For me, that’s a big deal since I’ve used it for development purposes and have a ton of stuff contained within that virtual hard drive that may well have been lost had I not marked a warning on my calendar.

Since it had a 2-year-plus time frame on it (the 7.1 version), there may be others out there who have just been happily using it daily and will suddenly be unable to access it in a couple of days. So thought it might be worth sending such a warning to others.


He was smart, he set a calendar reminder in Outlook to assure he didn't miss the deadline.  If he hadn't paid attention to expiry, he would have lost the work he'd done and would have to rebuild the demo environment and reconfigure all of his customizations.
 
Thought I'd post a mention of this for everyone out there who are using BI VPC 7.1
 
Thank you Eliot, for the insight!
.

Tuesday, April 6, 2010

April 2010 v.36 – Business Intelligence Update


.
HOT TOPICS
President Obama Appoints Edward Tufte – Big Victory for Data Visualization And Transparent Government
Obama’s Data Visionary

Why Predictive Analytics Is A Game-Changer

SQL Server 2008 R2 gets an official date
Microsoft ships the final Technology Preview for SQL 2008 R2 Parallel Data Warehouse
Overview: Parallel Data Warehouse
New Data Visualizations in SQL Server Reporting Services 2008 R2

Tableau Public – How it Works Blog: Tableau Public - A Powerful New Tool for Democratizing Data

Kerberos SPN Generation Setup Tool – RobertLambrecht.com

WEBCASTS
All webcast times are in Eastern Time Zone unless otherwise specified

System Center Service Manager 2010: The CMDB, Connectors, and Data Warehouse
Hosted by Microsoft
Apr 2, 2pm
Click here for more info

Unleash the Power of PowerPivot
Hosted by Panorama
Apr 20, 10am
Click here for more info

Insight Through Microsoft Business Intelligence Solutions
Hosted by ComFrame
Apr 22, 10am
Click here for more info

Visualizing Success – Visualization with SharePoint PerformancePoint Services
Hosted by Mariner
Apr 29, 8:30am
Click here for more info

EVENTS

Executive Business Intelligence Roundtable
Hosted by ComFrame
Apr 13, Jackson, MS
Click here for more info

Business Insight Lunch and Learn
Hosted by MPS Partners and Microsoft
Apr 20, Granger, IN
Click here for more info

Convergence 2010
Hosted by Microsoft
Apr 24-27, Atlanta, GA
Click here for more info

SQL Saturday #39 NYC
Hosted by NJ SQL Server User Group in NYC
Apr 24, New York, NY
Click here for more info

Microsoft Business Intelligence
Hosted by Quilogy
May 4, Naperville IL
Click here for more info

TechFuse 2010
Hosted by Benchmark Learning
May 6, Bloomington, MN
Click here for more info

Microsoft Business Intelligence Conference
Hosted by Microsoft
Jun 7-10, New Orleans, LA
Click here for more info

TRAINING

Web-based Training
SQL Server: Training Portal
SharePoint 2007: Training Portal
SharePoint 2010: Getting Started with SharePoint 2010
PerformancePoint Monitoring and Analytics: Dashboard basics I,  Dashboard basics II
Up to Speed with PerformancePoint Dashboards and Web Parts
Excel 2007: Training Courses

Instructor Led Training
SQL Server and Business Intelligence Training
Pragmatic Works
April Courses, Online
Click here for more info

SQL Server Reporting Services (SSRS) Training
Intertech
Apr 7-9, Minneapolis, MN
Click here for more info

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Accelebrate
Apr 12-14, Online
Click here for more info

Solving Business Problems with MDX in SQL Server 2008
Solid Quality Mentors
Jun 15-17, Minneapolis, MN
Click here for more info

RESOURCES

Microsoft BI
2010 Betas are here, including Office, SharePoint, Project, Visio

SQL Server Business Intelligence: SQL 2005, SQL 2008
SSAS: SQL Sentry, Performance Optimization Software
SSAS: list of front end applications
Data Mining: SQL 2005, SQL 2008
StreamInsight: Versions and SQL Server SKUs, Developers Training Kit
SQL Server 2008 R2 gets an official date

Download: SQL Server 2008 R2 November CTP
Hands On Lab: PowerPivot in SQL Server 2008 R2
SQL 2008 R2: Home, Parallel Data Warehouse
Whitepaper: Best Practices for Data Warehousing with SQL Server 2008

SQL 2008 Books Online: Planning and Architecture (Analysis Services – Data Mining)
SQL 2008 Books Online: Architecture of Integration Services
Whitepaper: Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions
Blog: SQL Server 2008 for Oracle DBA

SharePoint Server 2007
Business Intelligence: Overview, Using BI Features
PerformancePoint:
Technical Library
Download: PerformancePoint SP2 (64-bit or 32-bit) Blog: Using Excel Services Reports with PerformancePoint Server (PPS)
Online Book: SharePoint guidance for SQL Server database administrators

SharePoint Server 2010
Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas
New Features in PerformancePoint Services 2010

Excel Services in SharePoint 2010 Feature Support, Dashboard Improvements, Upgrading PerformancePoint Server 2007 to PerformancePoint 2010
Planning for Upgrade from SharePoint Portal Server 2003 to SharePoint Server 2010
Blog: What is Time Intelligence?

Office 2010
www.PowerPivot.com
PowerPivot Team Blog
The Great PowerPivot FAQ

Download: PowerPivot for Excel 2010
Blog: The Business User’s Perspective
Blog: How PowerPivot and SSAS could work together
Blog: Diagnostic Guide for Usage and the PowerPivot Management Dashboard
Screencast: Using datamining with PowerPivot in Excel

Microsoft BI Certifications
Blog: New 2008 Microsoft BI Certifications Reviewed
Blog: Obtaining Microsoft BI Certification
Learning Plan: BI Developer
Exam: 70-448
Exam: 70-452

Related BI Resources
Notes from the Field

Article: Microsoft PowerPivot vs. Tableau
Blog: Using a Data Warehouse for CRM
Blog: Thoughts on: Who are the BI Personas?

Strategy Companion’s Analyzer Named 2009 EDITOR’S BEST Award by SQL Server Magazine

NEWS AND PRESS RELEASES

A High Level Comparison Between Oracle and SQL Server
SharePoint 2010 Steps Up to the ECM Plate
SharePoint 2010: A More Viable Cloud Option
SharePoint 2010: An Evolutionary Step Toward Content-Centric Middleware

Launching an Analytics Practice: Ten Steps to Success
Zen BI: The Wisdom of Letting Go
It Takes a Village to Drive Predictive Analytics

Blog: PowerPivot/Excel/SharePoint and SSRS – should they merge?
Blog: Comparing Analysis Services and PowerPivot
Blog: Great Visualizers: Mike Deal Charts the Beatles
.

Wednesday, December 2, 2009

December 2009 v.32 - Business Intelligence Update

.

HOT TOPICS

2010 Betas are here, including Office, SharePoint, Project & Visio

PowerPivot Team Blog
Download: PowerPivot for Excel 2010
Blog: The Business User's Perspective

Demo: Extended Outlook - Put your business intelligence reporting inside Microsoft Outlook

CapstoneBI Blog: Analysis Services 2008 Metadata Report Pack


WEBCASTS
All webcast times are in Eastern Time Zone unless otherwise specified

Beat the Competition with the Power of Analytics
Hosted by Panorama
Dec 3, 2pm
Click here for more info

FEDSPUG December Meeting (Webcast)
Hosted by Microsoft
Dec 3, 2pm
Click here for more info

SharePoint 2010 Preview
Hosted by Gig Werks
Dec 8, 1pm
Click here for more info

Is Your Data Warehousing Project Doomed from the Beginning?
Hosted by B2B Technologies
Dec 10, 12:30pm
Click here for more info

Best Practices for Pervasive BI
Hosted by Strategy Companion
Dec 10, 1pm
Click here for more info

Build More Powerful Solutions with Bing Maps
Hosted by Microsoft
Dec 10, 1pm
Click here for more info

Portfolio Management and Capital Planning with Microsoft Solutions
Hosted by Projility
Dec 12, 1pm
Click here for more info

Looping, Moving Files, and Splitting Data Streams: Intermediate SSIS Tasks for the DBA
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Tim Mitchell
Dec 15, 12pm
Click here to attend

Zero to Cube in 60 minutes
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Adam Jorgensen
Dec 18, 12pm
Click here to attend

The Many-to-Many Compression Algorithm
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Eugene Asahara
Dec 21, 12pm
Click here to attend


EVENTS

SoCal BI User Group - featuring Bob Abernathy of Strategy Companion
Hosted by Xelleration
Dec 3, Irvine, CA
Click here for more info


IN-PERSON TRAINING

Deploying, Operating, and Tuning an Analysis Services 2008 Solution
Hosted by Solid Quality Mentors
Feb 1, Minneapolis, MN
Click here for more info

SQL Server 2008 End-to-End Business Intelligence Workshop
Hosted by Solid Quality Mentors
Feb 15, Minneapolis, MN
Click here for more info


RESOURCES
Microsoft BI

SQL Server
Business Intelligence: SQL 2005, SQL 2008
Data Mining: SQL 2005, SQL 2008
Whitepaper: New Data Warehouse Scalability Features in SQL Server
Whitepaper: Introducing Microsoft StreamInsight

Blog: Formatting Linked Server MDX Query Results Using CTEs

SharePoint Server 2007
Business Intelligence: Overview, Using BI Features
PerformancePoint: Technical Library
Download PerformancePoint SP2 (64-bit or 32-bit)
Whitepaper: Publishing PerformancePoint Server in Extranet Scenarios
Whitepaper: Accessing large scale ROLAP environments with PerformancePoint 2007

SharePoint Server 2010
Blog: Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas
Blog: New Features in PerformancePoint 2010
Blog: Excel Services in SharePoint 2010 Feature Support, Dashboard Improvements

Office 2010
PowerPivot
http://www.powerpivot.com/
Blog: Using PowerPivot with Excel 2010

Related BI Resources
Notes from the Field


NEW AND PRESS RELEASES

Microsoft Elevates Mission-Critical Commitment With New SQL Server 2008 R2 Premium Editions, Delivery of November CTP
Bruno Aziza interviews Stephon Elop, President of Microsoft's Business Division

BIDN Launches:  Business Intelligence Developer Network (http://www.bidn.com/)

Crossing the Chasm II - Departmental to Enterprise BI
Gartner enters into Agreement to Acquire AMR Research, Inc.
Gartner Says Performance Driven Culture Is One of Four Disciplines Required for a Successful Pattern-Based Strategy

.


Friday, October 30, 2009

deFacto... a new alternative to PerformancePoint Planning?

Last week, I had the pleasure of spending a few days in Las Vegas for Microsoft's SharePoint Conference.  I have to admit, I came away drinking the Microsoft 'kool aid' after seeing great attention being paid to the new Business Intelligence (BI) capabilities within SharePoint and Excel.  After all, in his keynote speech Ballmer included a demo of PerformancePoint Services within SharePoint and the new PowerPivot capabilities within Excel... over 7,000 attendees were exposed to some very cool BI right there...

BUT, perhaps the most pleasant surprise of the session was discovering deFacto Global, who had a vendor booth and used the SharePoint Conference as an opportunity to "launch" their brand new product, defacto Performance Management.

Here is more information sent to me by the principals at deFacto, including mention of PerformancePoint Planning Migration that is worth checking out if your organization currently uses PerformancePoint Planning and is considering alternatives that align with your current infrastructure...


deFacto Performance Management fulfills the original mission of Microsoft PerformancePoint Server 2007 Planning: a Microsoft-centric budgeting, forecasting, consolidation, reporting and analysis tool that is powerful, scalable, easy to use and implement, and affordable. Built from the ground up by experts behind world-class products from Hyperion Solutions, OutlookSoft, and SAP®, deFacto delivers best-of-the-best performance management capabilities in a single, fully unified product.


deFacto is a highly scalable solution that supports the full range of planning and analysis applications from sophisticated enterprise wide to much more straightforward department level . Built using the vast features of Microsoft’s Excel, and the Relational and Multi-dimensional capabilities of SQL Server, deFacto represents a critical component of any organization’s Microsoft-centric Business Intelligence or Performance Management strategy. It goes far beyond the usual slicing-and-dicing of data to allow instant reporting of user-specific financial and operational data such as finance, marketing, human resources, supply chain, capital planning, profitability, sales, and many others.


deFacto is a completely unified, OLAP-based, analysis and planning product that offers the full range of capabilities users need, including modeling, forecasting, drill-down, drill-through, what-if analysis, reporting, and more. It empowers business users who drive planning processes throughout an organization with the ability to perform real-time analysis by enabling Excel and even SharePoint with data submission capability to its centralized data store. deFacto also complements Microsoft SharePoint Monitoring and Analytics components with powerful capabilities such as cube building, user security, advanced logic, data entry and what-if – all of which can be managed by the business user through the deFacto Modeler.


Migrating to deFacto is Easy….


deFacto offers PerformancePoint Server 2007 Planning customers a straightforward and cost-effective way to realize dramatic improvements in the usability, performance, scalability and support of their investment. Planning customers find moving to deFacto is the best and easiest way to transition to a tool that offers critical, must-have functionality and performance, as well as an exciting future. Since deFacto’s core technology is Microsoft-centric, much like PPS Planning, it offers the added benefit of capitalizing on your’ investment in organization-specific assets such as models, dimensions, business rules, data structures, reports, templates, ETL, security, and others.


Whether they are setting-up a new performance management environment from scratch or migrating from another tool, our customers are up and running quickly and efficiently. deFacto provides all of the functionality user’s need while setting a new standard for performance management.


For more information about deFacto Performance Management please visit http://www.defactoglobal.com/.





Tuesday, September 1, 2009

September 2009 v.29 - Business Intelligence Update

.

HOT TOPICS

Office 2010: Project "Gemini"
Demo: Overview
Demo: Creating table relationships in MS Gemini Self-Service Business Intelligence

Microsoft ships the first technology preview for Project code-named "Madison"
SQL Server 2008: Project "Madison"

Federal IT Dashboard
Commentary: Federal CIO Dashboard: We Can and Should Do Better Than This

NY Times: For Today’s Graduate, Just One Word: Statistics


WEBCASTS
All webcast times are in Eastern Time Zone unless otherwise specified

Putting Microsoft BI Tools in the Hands of Business Users
Hosted by Gig-Werks
Sept 2, 1pm
Click here for more info

Best Practices for Pervasive BI
Hosted by Strategy Companion
Sept 3, 2pm
Click here for more info

Building the Business Case for BI/Analytics
Hosted by Xcelligent
Sept 11, 11:45am
Click here for more info

Complete Business Intelligence Solution for your Microsoft Platform
Hosted by Panorama
Sept 15, 1pm
Click here for more info

Using Microsoft Office for Business Intelligence
Hosted by Microsoft
Sept 16, 2pm
Click here for more info

Microsoft Business Intelligence for Oracle Financials
Hosted by Microsoft
Sept 23, 1pm
Click here for more info

Better Operational Efficiency with Business Intelligence
Hosted by Gig Werks
Sept 30, 1pm
Click here for more info

Transforming Analytics in Financial Services
Hosted by Tableau Software
Sept 30, 2pm
Click here for more info

How to Create a Clear Vision for your Business Intelligence Needs
Hosted by Neudesic
Oct 20, 2pm
Click here for more info

Jumpstart Sales with Business Intelligence
Hosted by Gig Werks
Oct 28, 1pm
Click here for more info


EVENTS

SharePoint Conference 2009
Hosted by Microsoft
Oct 18, Las Vegas, NV
Click here for more info

TDWI World Conference
Hosted by The Data Warehouse Institute
Nov 1, Orlando, FL
Click here for more info

SQL PASS
Hosted by Microsoft
Nov 2, Seattle, WA
Click here for more info


TRAINING

Web: SQL Server Training Portal
Web: SharePoint Server 2007 Training Portal

Web: PerformancePoint Monitoring and Analytics:
Dashboard basics I,  Dashboard basics II

PerformancePoint Monitoring and Analytics
Solid Quality Mentors
Sept 9, Beaverton, OR
Click here for more info

SQL Server 2008 End-to-End BI Workshop
Solid Quality Mentors
Sept 14, Minneapolis, MN
Click here for more info

Microsoft BI Bootcamp
Solid Quality Mentors
Sept 21, Beaverton, OR
Click here for more info

Deploying, Operating, and Tuning an SSAS 2008 Solution
Solid Quality Mentors
Oct 5, Minneapolis, MN
Click here for more info

Enterprise ETL with SSIS
Solid Quality Mentors
Oct 19, Minneapolis, MN
Click here for more info

Designing and Developing Solutions with SSAS 2008
Solid Quality Mentors
Oct 26, Beaverton, OR
Click here for more info


RESOURCES
Microsoft BI
CapstoneBI Home page

SQL Server
Business Intelligence: SQL 2005, SQL 2008
Data Mining: SQL 2005, SQL 2008
Whitepaper: New Data Warehouse Scalability Features in SQL Server
Whitepaper: Predicative Analysis with SQL Server 2008
OLAP Heartbeat – monitor activity on Analysis Services
Complex Event Processing

SharePoint Server
Business Intelligence: Overview, Using BI Features

PerformancePoint
Technical Library
Download: PerformancePoint SP2 (64-bit or 32-bit)
Whitepaper: Publishing PerformancePoint Server in Extranet Scenarios
Whitepaper: Accessing large scale ROLAP environments with PerformancePoint Server 2007


NEWS AND PRESS RELEASES
Preview SQL Server 2008 R2
Microsoft Unveils Preview Code for Next SQL Server
Microsoft issues SQL Azure, CEP platform previews

Can Business Intelligence Help Save Healthcare?
4 Technologies That Are Reshaping Business Intelligence
Kimball University: Five Alternatives for Better Employee Dimension Modeling

White House set to unleash 100,000 federal data sources via data.gov


.