Showing posts with label R2. Show all posts
Showing posts with label R2. 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

Monday, August 23, 2010

Webcast Reminder: Self-Service BI with Microsoft PowerPivot


This Thursday, Andrew Brust of twentysix New York will be providing a 60 min webcast on the newly released PowerPivot.  Find out what this “in-memory” operational model is all about.

Thursday, Aug 26
10-11am (PST)
Click here for more info

 

Contact Us to learn more about PowerPivot and our BI QuickStart packages

.

Tuesday, August 10, 2010

August 2010 v.38 – Business Intelligence Update


HOT TOPICS

Executive Breakfast Briefing
Hosted by CapstoneBI
Aug 12, San Jose, CA
Click here for more info

Using SharePoint 2010 to Monitor & Analyze K12 Student Assessment Scores
Hosted by CapstoneBI
Aug 25, 1pm
Click here to register

Blog: Microsoft Based Planning and Budgeting solutions revisited

Where Social Media Meets Strategy
Microsoft Reports 48% Increase in Profits

Bringing Data Mining Into the Mainstream
Blog: Jamie’s Junk – continuing whatever comes to mind on data mining and predictive analytics
Blog: DM(X) – bogdanc on SQL Server Data Mining

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

Quick Deployment of Enterprise-Level Executive Dashboards
Hosted by Strategy Companion
Aug 12, 2pm
Click here for more info

Metrics to Understand Your Brand and Help it Thrive
Hosted by Tableau Software
Aug 18, 2pm
Click here for more info

Using SharePoint 2010 to Monitor & Analyze K12 Student Assessment Scores
Hosted by CapstoneBI
Aug 25, 1pm
Click here to register

SaaS and BI
Hosted by Strategy Companion
Aug 26, 2pm
Click here for more info

Self-Service Business Intelligence with Microsoft PowerPivot
Hosted by Andrew Brust of 26NY
Aug 26, 1pm
Click here for more info

Powerful Budgeting, Planning and Forecasting with CLARITY 7 using Microsoft technology
Hosted by Clarity Systems
Sep 16, 2pm
Click here for more info

EVENTS

Executive Breakfast Briefing
Hosted by CapstoneBI
Aug 12, San Jose, CA
Click here for more info

TDWI BI Executive Summit
Aug 16-18, San Diego, CA
Click here for more info

2010 Tableau Customer Conference
Aug 30-Sep 2, Seattle, WA
Click here for more info

Minnesota Microsoft BI User Group 2010 Q3 Meeting
Sep 1, Bloomington, MN
Click
here for more info

SoCal BI User Group
Sep 2, Mission Viejo, CA
Click here for more info


TRAINING

Web-based Training
SQL Server: Training Portal, eLearning
SharePoint 2007: Training Portal
SharePoint 2010: Getting Started with SharePoint 2010, Introducing SharePoint Designer
PerformancePoint 2010: Up to Speed with PerformancePoint Dashboards and Web Parts

Instructor Led Training
Presenting Data and Information
Edward Tufte
Sep 29 & 30 Arlington, VA
Oct 1, Arlington, VA
Click here for more info

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Accelebrate
Aug 25-27, Online
Click here for more info

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 & 2008
Solid Quality Mentors
Sep 13-17, Sacramento, CA
Click here for more info

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

SQL Server Reporting Services (SSRS) Training
Intertech
Aug 25-27, Minneapolis, MN
Click here for more info

Business Intelligence Training
Hosted by QuickStart
Click here for more info

Microsoft PerformancePoint Planning Training
Hosted by CapstoneBI
Click here for more info

RESOURCES
Microsoft BI

SQL Server
Business Intelligence:
SQL 2005, SQL 2008
SSAS: list of front end applications
Data Mining: SQL 2005, SQL 2008
StreamInsight: Versions and SQL Server SKUs, Developers Training Kit
Book: Microsoft SQL Server 2008 Analysis Services Unleashed
Book: Data Mining with SQL Server 2008

SQL 2008 R2: Home, Parallel Data Warehouse
Download: SQL Server 2008 R2
Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction, SQL Server 2008 Virtual Labs
Hands On Lab: PowerPivot in SQL Server 2008 R2
Whitepaper: Best Practices for Data Warehousing with SQL Server 2008
Whitepaper: Develop Reporting Services reports using Analysis Services data
Blog Post: Reporting Services Bing Map – Unable to connect to the remote server

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 2010
Microsoft SharePoint Team Blog
Blog: SharePoint 2010 – Top 10 Resources to get you started…
Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas
Excel Services in SharePoint 2010 Feature Support, Dashboard Improvements, Planning for Upgrade from SharePoint Portal Server 2003 to SharePoint Server 2010
MSDN Virtual Lab: Developing Business Intelligence Applications

Office 2010
www.PowerPivot.com
PowerPivot Team Blog
The Great PowerPivot FAQ
Download: PowerPivot for Excel 2010
Book: PowerPivot for the Data Analyst: Microsoft Excel 2010
Book: Microsoft PowerPivot for Excel 2010: Give Your Data Meaning
Book: Professional PowerPivot for Excel and SharePoint
Demo: Using PowerPivot to analyze MS Dynamics NAV
Blog: Load data from SAP into PowerPivot for Excel
Blog: The Business User’s Perspective
Blog: Thoughts on 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
Exam: 78-702

Related BI Resources
Notes from the Field
Professional Association for SQL Server
SSAS-info
FUTURESULTS – Microsoft web parts, add-ons, customizations
Panorama Software Releases NovaView 6.2: Integration with Office/SharePoint 2010…
Dundas Dashboard Wins “Best of TechEd” Award
Article: Microsoft PowerPivot vs.. Tableau
Blog: Using a Data Warehouse for CRM
Blog: Thoughts on: Who are the BI Personas?


NEWS AND PRESS RELEASES

Ballmer Outlines Mobile Strategy at Microsoft Event
The Promise of PowerPivot in Excel 2010
PowerPivot vs.. Native SSAS
PowerPivot Fast Track
Microsoft SQL Server 2008 R2: What’s New with PowerPivot?
Microsoft Office 2010 adds depth while making things easier
Light-up Your Dashboards with Silverlight
Download PivotViewer Extension for Reporting Services CTP1
Northridge Announces Numerous SharePoint 2010 Enterprise Implementations

BI’s Corporate Challenge
IT Market Starting to Heat Up
Business Intelligence: maximising data collation for end users
Buying BI? Talk to Users, not Technologists

.

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, November 6, 2009

November 2009 v.31 - Business Intelligence Update

.

HOT TOPICS

SQL Pass - Seattle, Nov 2-5

SQL Server 2008 R2 - Managed Self Service Business Intelligence
http://www.powerpivot.com/ for Excel 2010
Blog: Excel 2010, Interacting with Slicers
Bruno Aziza interviews Stephon Elop, President of Microsoft's Business Division

deFacto... a new alternative to PerformancePoint Planning?


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

Emerge Stronger with Microsoft Business Intelligence
Hosted by Microsoft
Nov 9, 2pm
Click here for more info

deFacto Performance Management Webinar
Hosted by deFacto Global
Nov 10, 12pm
Nov 19, 2pm
Nov 24, 12pm
Click here for more info

Increase Transparency Through Business Intelligence
Hosted by MicroLink LLC
Nov 12, 2pm
Click here for more info

Emerge Stronger with Microsoft BI: Operational Improvement
Hosted by Microsoft
Nov 17, 2pm
Click here for more info

How Hospitals Use Microsoft Technology to Manage Clinical Trials
Hosted by Quilogy
Nov 18, 1pm
Click here for more info

Turn insight into a winning strategy with cost-effective BI solutions
Hosted by twentysix New York
Dec 1, 2pm
Click here for more info

Emerge Stronger with Microsoft BI: Sales and Marketing
Hosted by Microsoft
Jan 26, 2pm
Click here for more info


EVENTS

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

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


SharePoint Unleashed
Hosted by Microsoft
Nov 3, Irvine, CA
Click here for more info

Discover Business Intelligence Capabilities within SharePoint
Hosted by Microsoft
Nov 3, Denver, CO
Click here for more info

SoCal BI User Group
Hosted by Xelleration
Nov 5, Irvine, CA
Click here for more info

Data Warehousing and Business Intelligence Strategies for the New Economy
Hosted by Hitachi Consulting
Nov 5, Denver, CO
Nov 10, San Francisco, CA
Nov 11, Los Angeles, CA
Click here for more info

Los Angeles SQL Server Professionals Group
Nov 19, Los Angeles, CA
Click here for more info

Microsoft Reporting Services and Business Intelligence
Hosted by CSG Professionals
Nov 24, Portland, OR
Click here for more info


TRAINING

Web-based Training

SQL Server: Training Portal
SharePoint Server 2007: Training Portal
PerformancePoint Monitoring & Analytics: Dashboard basics I, Dashboard Basics II
Excel 2007: Training Courses


In-Person Training

Enterprise ETL with SSIS
Solid Quality Mentors
Nov 9, Beaverton, OR
Click here for more info

SQL Server 2008 Fast Track Data Warehouse
Solid Quality Mentors
Nov 13, Irving, TX
Nov 17, Reston, VA
Nov 19, Iselin, NJ
Nov 20, Chicago, IL
Click here for more info

SQL Server 2008 End-to-End Business Intelligence Workshop
Solid Quality Mentors
Dec 7, Bellevue, WA
Click here for more info

Microsoft BI Bootcamp
Solid Quality Mentors
Dec 14, Beaverton, OR
Click here for more info


RESOURCES
Microsoft BI
CapstoneBI Architects
Notes from the Field

SQL Server
Business Intelligence: SQL 2005, SQL 2008
Data Mining: SQL 2005, SQL 2008
Whitepaper: New Data Warehouse Scalability Features in SQL Server
Whitepaper: Predictive Analysis with SQL Server 2008
Whitepaper: Introducing Microsoft StreamInsight
OLAP Heartbeat - monitor activity on Analysis Services

SQL Server 2008: Project "Madison"
Blog: Introduction to SQL Server Project Madison

SSIS: Kimball Method SSIS Slowly Changing Dimension Component
Blog: Formatting Linked Server MDX Query Results Using CTEs

SSAS: SQL Sentry, Performance Optimization Software
SSAS: list of front end applications


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

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


Related BI Resources
Caveman Forecaster - great resource for data mining/time series formatting
Federal IT Dashboard
http://it.usaspending.gov/ - track Stimulus Spending
Data.gov Catalogs, FAQ


NEWS AND PRESS RELEASES

Microsoft sets SQL Server 2008 R2 preview
Q&A: Business Intelligence gets a facelift in SQL Server 2008 R2
Microsoft Previews SQL Server Upgrades, In-Memory Analysis
End of life comes for SQL Server 2005 SP2

DBA career paths could lead to business intelligence

Peter Drucker as Life Coach: Book Shares His Wisdom


.