Microsoft BI

Microsoft Business Intelligence from the field

Posts
  • 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

    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

    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 Server 2012 Product Guide

    • 1 Comments
    Just released a new SQL Server 2012 Product Guide ready to download.
  • 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

    Project Barcelona

    • 1 Comments
    Another cool project starting up at Microsoft. Looks interesting. Find out more here http://blogs.msdn.com/b/project_barcelona_team_blog/archive/2011/04/11/introduction-to-project-barcelona.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

    Business Intelligence with Cloud Data

    • 0 Comments
    This walkthrough discusses how businesses can take business intelligence to the cloud with SQL Azure. The video covers the benefits of SQL Azure—including the ability to establish business intelligence without adding hardware costs or IT overhead—and...
  • Microsoft BI

    Windows 8

    • 0 Comments
    i can think of a few cool BI scenarios with this new UI p92QfWOw88I
  • 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

    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

    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

    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

    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

    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

    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

    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

    Project Barcelona (again)

    • 0 Comments
    check this out for what is coming...btw, it is in CTP1 release now. http://projectbarcelona.cloudapp.net/
  • Microsoft BI

    Launch BISM File (.bism) in Excel

    • 0 Comments
    BI semantic model connections from Excel require that you have Excel 2010 and the MSOLAP.5 OLE DB provider installed on your workstation For connections to succeed you must have Excel 2010 and the MSOLAP.5.dll installed on the client computer. You...
  • Microsoft BI

    SharePoint Summit

    • 0 Comments
    For those in Toronto, I will be presenting a session at the SharePoint Summit on May14-16th on Building Better Dashboards http://www.sharepointsummit.org/Toronto/conference-day2.htm#session_9_2 Hope to see you there!
  • 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

    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

    Welcome

    • 0 Comments
    moving content from http://howardmorgenstern.wordpress.com
  • Microsoft BI

    SQL Server 2008 R2 Business Intelligence Training Course

    SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights), a new self-paced online training course brought to you by Microsoft Developer and Platform Evangelism. This is a is a great resource for developers, consultants and evangelists...
  • Microsoft BI

    PerformancePoint 2010 Content Deployment Tool

    It’s a command-line tool that allows you to deploy PerformancePoint content using an existing ddwx file and can be used to migrate content from development to production or between site collections on the same SharePoint server. http://ppscd.codeplex...
Page 1 of 2 (44 items) 12