Microsoft BI. Microsoft BI. Capabilities Self-service Excel provides new self-service capabilities and empowers users with data discovery, analysis, and visual exploration.
Uncover hidden insights and facilitate ease of collaboration and access from anywhere through HTML5 and mobile applications. Dashboards SharePoint Server provides a full set of rich dashboard and scorecard capabilities including advanced filtering, guided navigation, interactive analytics, and visualizations. Reporting SQL Server Reporting Services is a comprehensive, highly scalable solution providing operational reporting for pixel-perfect printing and browser-based viewing, as well as ad-hoc data exploration and visualization. Analysis SQL Server Analysis Services empowers you to build comprehensive, enterprise-scale analytic solutions that leverage in-memory technology and provide interactive exploration of aggregated data. Predictive analytics. Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX. DAX, which stands for Data Analysis Expressions, comprises the PowerPivot formula language that supports custom calculations in PowerPivot tables and Excel PivotTables.
While many of the functions used in Excel are included within the language, DAX also offers additional functions for carrying out dynamic aggregation and other operations with your data. DAX was introduced with PowerPivot, a free add-in for Excel 2010 that promises true “BI for the masses.” PowerPivot holds much promise for analysts, reporting specialists and other information consumers, particularly those who are “at home” with Excel, and who serve the enterprise outside traditional IT and development roles. PowerPivot offers those who adopt it the capability of creating BI solutions rapidly, and often without the need for the resources required to construct traditional BI solutions. You will also need the appropriate access rights to the sample data sources provided for SQL Server 2008R2. . ( What, When and who? Auditing 101. Whenever the subject of compliance comes up, the first thing that comes to mind is auditing.
What does an audit consist of? Let us look at what auditing means and then concentrate on one small part of auditing in this article. Auditing in the real world is used to ascertain the validity of the information. It is also used to provide an assessment of our systems internal control. So what does audit mean for the IT department? What should we audit? In the perfect world, we would audit everything. Data auditing techniques. Data auditing is the process of doing a profile check and assessing the quality of data, to find how accurate it is. Let us look at some of the different auditing techniques that are available for SQL Server very briefly and then concentrate on one of the techniques available in SQL Server 2008.
Solutions available in all versions of SQL Server. Some of the common options we have for auditing data involve developing an in-house solution or relying on third party tools. Pros: What, when and who? Auditing 101 - Part 2. Introduction In the previous article in the series we talked about Change Tracking (CT).
In this article we will concentrate on another technique available in SQL Server 2008 and higher. This technique is Change Data Capture (CDC). What is CDC? CDC is one of the techniques introduced in SQL Server 2008, and it answers the question as to what row in a table changed. It is very easy to enable CDC. Setup How can we set up CDC? USE master; go IF EXISTS (SELECT * FROM sys.databases WHERE name = 'TestDB') DROP DATABASE TestDB; go CREATE DATABASE TestDB; go It is advisable to have SNAPSHOT ISOLATION On. To ensure that snapshot isolation is on, you need to run the command: SQL. SQL Server. Excel Services delegation « PowerPivotGeek.
By powerpivotgeek (dwickert@microsoft.com), on December 11th, 2009 I am inspired by a recent post from a colleague about the various issues that can come up with Excel Services delegation (see a Denny Lee’s blog here: and I wanted to take it a bit further (and maybe a bit ‘geekie’-er) First, why is this a problem?
After all, as you can see in Denny’s post, you can see the workbook and you even have a thumbnail for it in the Gallery. What’s up here? The core of the problem is that unless you’ve set the connection to refresh when you first open the workbook, Excel Services uses its pivot cache to construct the pivot table and slicers. Ok, so now we’ve hit the problem. The issue is (get your geek-armor ready) is that when accessing data PowerPivot looks like just another data source to both Excel desktop and Excel Services. The setting tells Excel Services what kind of lookup to perform when a new connection is started: A domain controller must be available to validate the logon.