Understanding Microsoft Power BI – Self Service Solutions
This article discusses Microsoft Power BI, different tools under the Microsoft Power BI umbrella and when each of them can be used.
2013-11-26
3,880 reads
Business Intelligence
Building Real-World Microsoft BI Dashboards Today
There is a lot of Microsoft buzz about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real-world requirements today. In this article, Jen Underwood shares what technologies were used to develop a dashboard solution for a Fortune Global 500 company using Microsoft Business Intelligence technologies, and why. Some of the decisions may surprise you and the lessons learned are sure to be of value.
2013-11-07
5,745 reads
Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
2012-09-14
3,452 reads
ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-14 (first published: 2012-06-19)
9,040 reads
Big Data
Are you prepared for Big Data? A short piece from Henrico Bekker that talks about what Big Data might mean to many people.
2012-04-16
560 reads
Kimball University: Extreme Status Tracking For Real Time Customer Analysis
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
2010-07-01
2,416 reads
Business Intelligence is a Growing Field
How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.
2010-05-14
4,902 reads
Self-Service BI with PowerPivot for Excel 2010
Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.
2010-01-22
4,580 reads
Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective
BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.
2009-12-16
2,465 reads
Come and Get it! Making Business Intelligence More Consumable
This, the first in a series of three articles, describes the history of information workers and discusses their characteristics. The next article will describe how to leverage the latest BI technologies, and the final article will address how to improve information consumability.
2009-11-03
2,375 reads
Blogs
Making a PostgreSQL Backup in a Container
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Forums
RLS Causing RBAR
Hi all, First I want to ask just a generic question. Does RLS in...
SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
Having issues installing SSIS extension for VS 2022 Community
I have installed the SSIS extension for VS 2022 community. When I go into...
Question of the Day
A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers