Microsoft BI

Microsoft Business Intelligence from the field

Posts
  • Microsoft BI

    connect PowerPivot to an Oracle database

    • 2 Comments
    Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle client installed and the TNS names configured. In PowerPivot the server name to connect to the Oracle instance is host:port/service_name . If port number...
  • Microsoft BI

    Use PowerPivot To Analyze Your Outlook Calendar

    • 0 Comments
    Calendar Analytics is a FREE time management application that pulls information from Exchange and visualizes that data in a very easy to use Excel PowerPivot dashboard. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4c13a670-3356-4d4a...
  • Microsoft BI

    Microsoft Business Intelligence 2012 - Single Server Install Guide

    • 2 Comments
    I just put this together for a customer and thought I would share it. It goes through the entire install and configuration process screen by screen, to build a stand alone server with all the server side components of the Microsoft Business intelligence...
  • Microsoft BI

    SQL Server 2012 Developer Training Kit

    • 1 Comments
    This is truly excellent content. Kudos to the MS Team. Links to presos and videos below. http://social.technet.microsoft.com/wiki/contents/articles/6982.sql-server-2012-developer-training-kit-bom-en-us.aspx
  • Microsoft BI

    Demo Image XII: SQL 2012

    • 0 Comments
    Latest and greatest All up Microsoft BI Demo image is located here http://www.microsoft.com/betaexperience/pd/BIVHD/enus/ . Also hosted version is here http://fs.mssalesdemos.com
  • Microsoft BI

    Reporting Services 2012 and Dashboard Designer

    • 0 Comments
    Alot of confusion on how to integrate the new SharePoint integrated mode of Reporting Services 2012 into your Performance Point Dashboards. If Reporting Services is configured to use Trusted Account authentication in SharePoint Server, then the server...
  • Microsoft BI

    PowerPivot models as a datasource for Report Builder and PPS

    • 0 Comments
    PowerPivot models, aka xlsx files can be used as datasources for report builder reports, also performance point analytics. The connection string is of type Analysis Services Data Source=http://<servername>/PowerPivot Gallery/<Powerpivot_filename>...
  • Microsoft BI

    Microsoft BI on an ipad

    • 0 Comments
    Microsoft has released new guidance on viewing reports and scorecards on Apple iPad devices, and a SharePoint Cumulative Update to enable it. http://technet.microsoft.com/en-us/library/hh697482.aspx
  • Microsoft BI

    Fuzzy Lookup Add-in for Microsoft Excel 2010

    • 0 Comments
    New Project from MS Labs. Takes the fuzzy lookup functionality out of SSIS and puts into Excel 2010. Could be useful for cleansing PowerPivot models. More info here http://www.microsoft.com/bi/en-us/Community/BILabs/Pages/FuzzyLookupAddInforExcel.aspx...
  • Microsoft BI

    Reporting Services 2012 SharePoint Service

    • 0 Comments
    There are couple of post install manual configs you need to do in order to get the reporting services Sharepoint service to show up in your sharepoint farm. First of all, you NEED SharePoint 2010 SP1. In SharePoint PowerShell, as admin: Install...
  • Microsoft BI

    64 bit version of the Data Mining Add-in for Excel 2010

    • 0 Comments
    FINALLY!!!! and updated for SQL Server 2012. http://www.microsoft.com/en-us/download/details.aspx?id=29061
  • Microsoft BI

    Cascading filters in PPS

    • 0 Comments
    here is a little known PPS feature add for SP1 for SharePoint 2010 http://technet.microsoft.com/en-us/library/hh272541.aspx
  • Microsoft BI

    How to build dashboards using PerformancePoint Services 2010

    • 0 Comments
    Here are some free PPS training videos to get up to speed on how to build dashboards using PerformancePoint Services 2010 Video 1: Introducing Dashboard Designer (5:48) Video 2: Tour Dashboard Designer (11:17) Video 3: Creating a basic dashboard...
  • Microsoft BI

    PowerPivot: DAX: Time Intelligence Functions

    • 0 Comments
    Useful list of time calcs for powerpivot and soon to be tabular bi models. http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-dax-time-intelligence-functions.aspx
  • Microsoft BI

    SharePoint Diagnostics Studio

    • 0 Comments
    The SharePoint Diagnostics Studio available in the SharePoint 2010 Administration Toolkit v2.0, presents server diagnostic information in a visual and structured way that enables Developers and IT Professionals to quickly diagnose and act upon intermittent...
  • Microsoft BI

    Twitter Analytics

    • 0 Comments
    A new cool FREE tool to gain valuable insight into your tweets using PowerPivot. Download it here
  • Microsoft BI

    PerformancePoint Services SuperFlows

    • 0 Comments
    It's like a help file on steroids. There are 2. IT configuration - how to configure Performance Point Services Dashboard creation - how to create Performance Point content: kpi, scorecards, reports, filters, dashboards, etc...
  • Microsoft BI

    DAT279 New Business Intelligence Functionality in Microsoft SQL Server Code-Named "Denali"

    • 0 Comments
    I am doing a session next week at our local techdays event. http://www.techdays.ca . I hope to see some folks there. here is what I am covering... In this session we dive into some of the new Business Intelligence capabilities that are being introduced...
  • Microsoft BI

    SQL Server 2012 Product Guide

    • 1 Comments
    Just released a new SQL Server 2012 Product Guide ready to download.
  • Microsoft BI

    Microsoft SAP Resources

    • 2 Comments
    Here are some great Microsoft SAP resources SAP and SAP BW data in PowerPivot using-sql-server-powerpivot-for-excel-to-analyze-sap-data.aspx . SAP HANA data in PowerPivot http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26747 . Microsoft...
  • Microsoft BI

    SQL Denali CTP3 is out

    • 0 Comments
    latest and greatest denali bits. http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx and you will need this too Microsoft® SQL Server® Code-Named 'Denali' PowerPivot for Microsoft® Excel Community Technology Preview...
  • Microsoft BI

    SSAS Benchmark

    • 0 Comments
    Found a nice benchmark doc from Unisys. It is SQL Server 2005 however but still very good. http://www9.unisys.com/eprise/main/admin/corporate/doc/02_21_08_DW_whitepaper_for_Wn_Sv_launch_final_for_web.pdf
  • Microsoft BI

    Microsoft Big Data

    • 0 Comments
    Unlock business insights from all your structured and unstructured data, including large volumes of data not previously activated, with Microsoft’s Big Data solution. Microsoft’s end-to-end roadmap for Big Data embraces Apache Hadoop™...
  • Microsoft BI

    Windows 8

    • 0 Comments
    i can think of a few cool BI scenarios with this new UI p92QfWOw88I
  • Microsoft BI

    Project Barcelona (again)

    • 0 Comments
    check this out for what is coming...btw, it is in CTP1 release now. http://projectbarcelona.cloudapp.net/
Page 1 of 2 (44 items) 12