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

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 in SQL Server code-named “Denali”. We’ll start with the new Business Intelligence…

Microsoft Big Data

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™ by distributing enterprise class Hadoop based solutions on both Windows Server and Windows Azure. Our solution is also integrated into the Microsoft BI…

PerformancePoint Services SuperFlows

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…      

Reporting Services 2012 SharePoint Service

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 the Service > Install-SPRSService Install the Proxy    > Install-SPRSServiceProxy Start the service (You…

SQL Denali CTP3 is out

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 3 (CTP 3) http://www.microsoft.com/downloads/details.aspx?FamilyId=80edc21c-643e-4e1b-a4c9-7f51f24b6d98

PowerPivot: DAX: Time Intelligence Functions

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

Cascading filters in PPS

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

Twitter Analytics

A new cool FREE tool to gain valuable insight into your tweets using PowerPivot. Download it here

Windows 8

i can think of a few cool BI scenarios with this new UI [View:https://youtu.be/p92QfWOw88I]

Business Intelligence with Cloud Data

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 it also introduces SQL Azure Reporting. The ability to embed SQL Azure reports into on-premises Apps and Windows Azure…