SQL BI Professionals – Let your voice be heard!

by dennyglee Categories: Analysis ServicesTags: · Leave a comment

As recently announced by T.K. Anand on the Analysis Services and PowerPivot, the SQL BI development team are looking for your thoughts and opinions on the tools and capabilities for SQL Server Analysis Services Development. If you want your voice to be heard – now is a great time to do it!  Follow through with the BI Professional Survey for more information and link to the survey. The voice of the SQL community has a huge impact on how and what the SQL BI team develops.   After all, it was due to strong SQL BI community feedback that helped push…

Rate this:

SQLPASS: Hadoop and BI are better together–we’ll show you how!

by dennyglee Categories: Analysis Services · BigDataTags: · · Leave a comment

This is going to be yet another exciting SQLPASS Summit!  Lots of great sessions, focus groups, and craziness – definitely one of the funner times of the job! Over the last few years, I have had the honor to speak at the SQLPASS summits with the various themes surrounding large volume / complex Enterprise Business Intelligence. Last year I had the honor to introduce Hadoop on Azure and Windows during the 2011 PASS Summit Keynote with Ted Kummert.  As it was recently announced during this year’s Strata Conference, Hortonworks Powers Microsoft HDInsight. For this year’s PASS Summit, Dave Mariani (@dmariani)…

Rate this:

A funky way to do Hive and Hadoop … on Azure

by dennyglee Categories: BigDataTags: · · · · Leave a comment

. Funny how you can say something in your head and it sounds fine — Doctor Who (Matt Smith in Amy’s Choice) . Recently I had posted the wiki article: Hadoop on Azure Scenario: Query a web log via HiveQL. In it described how to analyze a sample web log using HiveQL on the Hadoop on Azure CTP (HadoopOnAzure.com) using Interactive Hive console, Interactive Javascript console, Secure FTP using curl to transfer data to HDFS Creating an EXTERNAL table against compressed log files Executing some simple HiveQL queries. Screenshot of the Hadoop on Azure Interactive Hive Console executing a HiveQL…

Rate this:

The potential of Big Data

by dennyglee Categories: BigDataTags: · 4 Comments

To better understand the excitement around Big Data, there is an informative  report by McKinsey Global Institute – Big data: The next frontier for innovation, competition, and productivity.   I encourage you to read this report and there are some key call outs that showcase the potential of Big Data.   Big Data call outs! It’s about the next wave of jobs with the main domains of Big Data being Healthcare, Public Sector, Retail, Manufacturing, and Telecommunications. 140,000-190,000 more deep analytical talent positions and 1.5 million more data-savvy managers needed to take full advantage of big data in the United States…

Rate this:

Netflix rocks–from great entertainment to showcasing how to develop for the Cloud

by dennyglee Categories: BigData · CloudTags: Leave a comment

. . A partial screenshot of my Netflix Top 10 selections – which of course includes Doctor Who and Stargate Universe. . . . . As a subscriber, I’m definitely a fan of Netflix.  I’m watching Netflix on my PC, Windows Media Center PC, XBox 360, iPad, iPhone, and Windows Phone 7 – its just awesome that I can pretty much watch whatever I want on any device.  Yet, it isn’t just the ability to watch Doctor Who and Battlestar Galactica on demand that impresses me on Netflix – it is that they also showcase how to develop and work…

Rate this:

At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?

by dennyglee Categories: PowerPivotTags: · Leave a comment

Are you coming to TechReady and interested in getting yourself a PowerPivot Technical Diagram: PowerPivot Client/Server Architecture? Well, make sure to come to Dave Wickert and my session for a chance to get a printed copy of this awesome diagram!: BIN403: PowerPivot for SharePoint Power Hour…so powerful its 75min 7/30 10:30-11:45am, Sheraton Metro B You’ll also get a chance to win one of two copies of the Professional Microsoft PowerPivot for Excel and SharePoint book as well! Enjoy and see ya there!

Rate this:

Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010

by dennyglee Categories: PowerPivotTags: Leave a comment

There are many reasons to go to TechEd North America 2010 in New Orleans this year.  After all, it is THE event for developers and IT Professionals.  And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There will be a raffle to win a signed copy of the PowerPivot Architecture Technical Diagram (screenshot below) in each of five PowerPivot sessions (five diagrams in total). The sessions are: BIE04-INT – Building Custom Extensions to the PowerPivot Management Dashboard (Mon 6/7 1:00pm-2:15pm, Room 241) BIC06-INT – SQLCAT: PowerPivot Best Practices and Enterprise Case…

Rate this:

Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)

by dennyglee Categories: PowerPivotTags: 7 Comments

I had a great question from a customer concerning something weird happening with PowerPivot relationships.  In this example, we have two tables such as city and state. State Mapping Table City-State Mapping Table With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA.  Even though the relationship makes sense (as per below) the output doesn’t!   I wish we had hierarchies! Alas, one of the biggest wishes in PowerPivot was that we had in hierarchies and we just were not able to put them in. …

Rate this: