Browse by Tags

Tagged Content List
  • Wiki Page: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links...
  • Wiki Page: Calendar Analytics for PowerPivot: Feature Requests & Changes

    This wiki article exists is to capture feature requests, design changes, and bug fix requests for Calendar Analytics. Please leave a comment with your feature or design change requests (or add them by using the Edit tab). For bugs, please check http://social.technet.microsoft.com/wiki...
  • Wiki Page: HDInsight Services For Windows

    This article is the main portal for technical information about HDInsight Services for Windows and related Microsoft technologies. It provides a brief overview of Apache Hadoop, as well as information for the HDInsight Services provided by Microsoft for deployment on both Windows and Windows Azure...
  • Wiki Page: PowerPivot Overview

    Microsoft’s Analysis Services product team (in the SQL Server division) has developed a new product that provides self-service BI (Business Intelligence) functionality for users of Microsoft Office. This product is generally referred to as PowerPivot , and it consists of both a client-side component...
  • Wiki Page: PowerPivot Measures

    This article shows you how to create a measure based on data in the Data Analysis Expressions (DAX) sample workbook. The workbook includes bike-related data from the AdventureWorks database. For information about where to get the sample workbook, see Get Sample Data for PowerPivot in the TechNet Library...
  • Wiki Page: SharePoint 2010: PowerPivot - Scheduled Refresh to Netezza

    How to create a Scheduled Refresh to a Netezza Database in PowerPivot: Configure SSS target application in SharePoint If you have not already created Secure Store Service (SSS) applications in SharePoint 2010, then refer to the MSDN article to configure it. In Central Administrator...
  • Wiki Page: SharePoint 2010: Data Refresh Failed: "String was not recognized as a valid DateTime" (PowerPivot)

    Table of Contents Issue If "Enable" has not been checked, you are able to enter the "Schedule Refresh…" screen. Cause Workaround Issue When clicking on “Manage Refresh”, you can see the scheduled refreshes are succeeding. However, when you click on "Schedule...
  • Wiki Page: DAX Resource Center

    Table of Contents You can contribute! Introduction to DAX Microsoft DAX Documentation Most Valuable Resources Samples DAX formulas in measures DAX functions Credits Welcome to the DAX Resource Center Wiki - your one stop shop for all things DAX This Wiki includes articles, whitepapers, videos...
  • Wiki Page: SharePoint 2010: "Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'."

    To create a Power View report, first we need to create a BI Semantic Model Connection: But If we did not deploy PowerPivot Web Application to the SharePoint application, we will get the following error Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'...
  • Wiki Page: Analytics for Twitter: Known Issues

    This Wiki article documents some known issues with version 1.3 of Analytics for Twitter. Click here to download the latest version of Analytics for Twitter. Analytics for Twitter is being refreshed for Office 2013. For updates & status please visit the Analytics for Twitter 2013...
  • Wiki Page: Custom Calculations for Invoice & Returns Using a PowerPivot DAX Formula

    This is from the thread in the SQL Server PowerPivot for Excel forum. Table of Contents Problem Description Solution Step 1 Step 2 Step 3 Conclusion Problem Description Here's the sample data: STATUS WEEK SALES CUSTOMER INVOICE W01 $150...
  • Wiki Page: Showing a 100% Progress Gauge in Power View

    by Paul Turley , Mentor, SolidQ from SQLServerBiBlog.com What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. That was easy …now that I see how to do it.” Power View sets the maximum value for a chart series based on the maximum...
  • Wiki Page: PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables

    Note: Here's a more current topic about working with Dates in PowerPivot . For more information, read: The PowerPivot for Excel 2010 overview. or The PowerPivot for Excel 2013 overview. When you create a PivotTable that is based on Excel data, you can group the data in the...
  • Wiki Page: Calendar Analytics for PowerPivot: Known Issues 2

    This Wiki article documents some known issues with version 1.0 of Calendar Analytics. There is a new Wiki article for version 2.0 Calendar Analytics. The new Wiki article outlines new features, bug fixes, and Office 15 compatibility in version 2.0 found here: http://social.technet.microsoft...
  • Wiki Page: Troubleshooting PowerPivot Data Refresh

    Applies to: SQL Server 2008 R2 and SQL Server 2012 This article consists of troubleshooting tips and techniques for working through PowerPivot data refresh problems in SharePoint. Table of Contents Where to get information about data refresh failures What to check for first Data Refresh Errors...
  • Wiki Page: DAX: Returning the Nth Selected Value in a Slicer

    by Paul Turley , Mentor, SolidQ A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn’t solved before using a tabular model and DAX. She had cost information for several hospitals in a PowerPivot model. Using an Excel pivot...
  • Wiki Page: Analytics for Twitter 2013

    Analytics for Twitter 2013 (version 1.2) is now available for download at http://extendedresults.com/products/twitteranalytics/ This version has been enhanced to utilize twitter's version 1.1 api for downloading user profile images and was built for Office 2013 with PowerView. As a reminder...
  • Wiki Page: PowerPivot Glossary

    Microsoft SQL Server PowerPivot provides features that span many technology areas, from relational databases, to analytics, to Web publishing. This article provides definitions for some PowerPivot terms and provides links to related content in the TechNet Library. Add words and tweak the definitions...
  • Wiki Page: Set Up a VM Test Server for Power View and PowerPivot

    Want to use Power View to display your own data in charts and use the cool filtering available in slicers and chart series and page filters, but you're not a SharePoint guru, or a systems admin, or even a SQL Server dba? Never heard of a document library? No problem …. You – Want to visualize...
  • Wiki Page: Compare Analysis Services and PowerPivot

    NOTE : This page was translated from this Spanish version by St. Joseph Lopez . This article is available in other languages: Spanish More and more customers are getting to know about PowerPivot and seek more guidance on when to use it with SQL Server...
  • Wiki Page: PowerPivot: Data Analysis Expressions (DAX) Language

    Table of Contents Types of DAX Functions Overview of DAX Where to Use Formulas Creating Formulas by Using the Formula Bar Tips for Using AutoComplete Basic DAX Syntax Using Multiple Functions in a Formula DAX Data Types Formulas and the Relational Model Introduction to Context Updating the Results of...
  • Wiki Page: PowerPivot: Import Data from a SQL Server Database (Video)

    This video is third in a series about using PowerPivot to import data into an Excel workbook. In this video, Michele shows you how to import data from a SQL Server relational database. Tutorial video by Michele Hart , Microsoft SQL Server Technical Writer. View all the PowerPivot videos...
  • Wiki Page: How to Use the SQL Server Data Mining Add-ins with PowerPivot for Excel

    Table of Contents Introduction Overview of Data Mining with the Add-Ins Installation Prerequisites Installing the Data Mining Add-ins Installing PowerPivot for Excel Performance and Memory Considerations for 32-bit vs. 64-bit Versions Technical Considerations Data Stores for the PowerPivot and Data Mining...
  • Wiki Page: PowerPivot: Install the PowerPivot Add-In for Excel

    PowerPivot for Excel is a free download that significantly expands the data analysis capabilities of Excel. PowerPivot is made up of the Excel free add-in and the SharePoint server component. Video tutorial by Michele Hart , Technical Writer for Microsoft SQL Server. View all the PowerPivot...
  • Wiki Page: PowerPivot Introduction Videos

    PowerPivot - A world of data on a single screen, in real time! Inviting viewers to discover the power and usability of Microsofts Business Intelligence tools, we present these fun and engaging animations to introduce you to Microsoft PowerPivot for Excel 2010. Trying to convince your boss to change...
Page 1 of 4 (91 items) 1234
Can't find it? Write it!