• The SharePoint 2013 Data Model

    October 27, 2013 / No Comments »

    Somehow, this PowerPivot for SharePoint gem escaped my attention but it's a very important deployment enhancement that was more than likely initiated by Power BI and the cloud. Starting with SQL Server 2012 Service Pack 1 and SharePoint 2013, you can set up a dedicated SSAS server in SharePoint mode outside the SharePoint farm and configure the farm to point to it. This was possible as a result of all the integration work done between Excel Calculation Services, SharePoint and AS for the 2013 release. Previously, the SSAS in SharePoint configuration mode instance had to be installed on the SharePoint application server. This brings more flexibility to scaling out your PowerPivot environment outside SharePoint and simplifies the PowerPivot setup. For example, to scale out Analysis Services, you can simply add a new SSAS server configured in SharePoint mode. Excel Calculation Services will balance the load between all available SSAS servers...

  • Presenting at SQL Saturday Charlotte

    October 9, 2013 / No Comments »

    Lots of public appearances this month! I'll be presenting "Best Practices for Implementing an Enterprise BI Solution" at SQL Saturday Charlotte BI Edition on October 19th immediately after SQL Pass. I hope to see you there!

  • Presenting at Visual Analytics Science and Technology Conference

    October 5, 2013 / No Comments »

    I believe that the Pareto 80/20 principle applies well to a sound BI strategy where 80% of the BI needs should be addressed by Organizational BI (data warehouse, semantic layer, dashboards, operational reports, descriptive analytics, predictive analytics, big data, etc.) and 20% should be left for self-service BI. One of the areas where self-service BI excels is to promote lateral thinking. A business users can quickly test ideas and hypotheses by importing, mashing up, and visualizing data. This is why I'm excited to present at the Visual Analytics Science and Technology Conference in Atlanta on October 16th. The session title is "Self Help BI: How Self-service BI Promotes Lateral Thinking" and it's included in the "Using Visual Analytics to Foster Lateral Thinking about Business Problems" workshop. I'll show how a business users can use the Excel reporting and data mining capabilities to test ideas and then share the results by...

  • Oracle Developer Tools for Visual Studio

    October 4, 2013 / No Comments »

    In my previous blog, I was somewhat hard on Oracle for not testing their connectivity software property. On a positive note, I like their effort to integrate Oracle Developer Tools with Visual Studio. This video provides a nice intro to this feature. Basically, Oracle Developer Tools for Visual Studio fulfills the same role as the Visual Studio built-in support for SQL Server, including designing objects, querying databases, and even tuning queries in Server Explorer. It's great to see vendors working together and Oracle Developer Tools for Visual Studio is a true affirmation that times are changing for better.

  • Seeking Oracle

    October 3, 2013 / 2 Comments »

    Getting two mega vendors to work together - always fun. On a positive note, the experience further reinforced my love for SQL Server. Scenario: Installing Oracle 11g 64-bit and 32-bit clients on Windows Server R2 64-bit machine for both development and testing. As you would recall, BIDS (aka SSDS in SQL Server 2012) is a 32-bit application. So, is PowerPivot if it runs in 32 bit Excel. On the other hand, the server products, such as SSRS and SSAS, are x64. So, the changes are that you'll need both the 32-bit and 64-bit OLE DB Oracle providers since Microsoft discontinued its Oracle OLE DB provider support. Issue 1: It looks like this deployment scenario wasn't on the Oracle support radar and probably was never tested. First of all, based on previous experience, you need to install both the 64 bit and 32 bit full Oracle clients with the Administrator option....

  • MVP for a Decade

    October 1, 2013 / No Comments »

    Microsoft awarded me again with the Most Valuable Professional (MVP) Award for SQL Server. This makes it 10 consecutive years as MVP! Where did all this time go? Anyway, I feel honored to be a member of this elite group of dedicated professionals.

  • Atlanta BI Group Meeting Tonight

    September 30, 2013 / No Comments »

    The Atlanta BI Group is meeting tonight. Main Presentation: Dimensional Modeling 101   Level: Beginner Date: Monday, September 30th, 2013 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: So many names! Data warehouse, data mart, star-schema, snowflake schema, dimensional model, Type 1, Type 2, Type 3... What does it all mean? Whether you're a data consumer, ETL specialist, or database designer, it pays to understand the vocabulary and design concepts of dimensional models. In this session, we'll cover the basics of dimensional modeling, including dimensions, facts, and the ways they all come together. We'll talk about why denormalization isn't necessarily a dirty word, some common design challenges, and a few ETL considerations. By the end of the hour, you'll be ready to impress your friends and confound your frenemies with your mad dimensional modeling knowledge!   Speaker: Audrey...

  • IE 11 Issue with Reporting Services

    September 23, 2013 / No Comments »

    I've upgraded to Windows 8.1 and got IE 11. As I've come to expect, a new browser upgrade brings a new set of issues, among which buttons disabled when they shouldn't be and page posts not working. What about reports? This is what I get when I use Report Manager. The report toolbar is all messed up. How to fix this horrible issue? Use the compatibility view of course: Open Internet Explorer, press the Alt key, click Tools on the menu bar, and then click Compatibility View settings. Add the report site, such as localhost, to the list of websites.

  • Flavors of Self-service BI

    September 21, 2013 / No Comments »

    My Fall newsletter entitled "Why a Semantic Layer?" is out and it will be e-mailed to subscribers on Monday. The reason why I wrote is to bring the focus back on organizational BI. Based on my experience, decision are makers are confused about what their company's BI strategy and roadmap should be. I've asked a BI manager recently if he knows that a semantic layer could be a true self-service BI enabler and he said he didn't know. After talking to some well-known BI vendors and listening to their "pure" self-service mantra, the focus was shifted from a comprehensive BI architecture that truly addresses the company needs to selecting a tool that has the most visualization fluff. In general, there are two self-service BI paths your organization can take: Semantic layer + ad hoc reporting – If your organization decides to invest in implementing a comprehensive organizational BI framework (see...

  • Announcing Prologika Validator

    September 15, 2013 / 2 Comments »

    Data is your biggest asset and today's currency but the data can be messy. You know it and we've seen it – many times. The messier the data, the bigger the headache. At Prologika, we believe that data quality issues should be addressed as early as possible and the validation process should start with the source systems. You need a solution to detect data entry issues without ETL, custom validation code, and exhaustively hard-coded rules. This is why I'm excited to announce today the availability of Prologika Validator! Available as a cloud service and on-premises offering, Prologika Validator uses predictive analytics to find data anomalies in order to help you improve data quality. It analyzes historical data and discovers common data patterns and relationships. When the user attempts to save a data entry that is outside the norm, Prologika Validator can detect the outlier. Then, the source system can notify...

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.
For more information or to register click here!

Books

Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Syndication