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…
Tag: Design
SQLPASS: Hadoop and BI are better together–we’ll show you how!
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)…
A funky way to do Hive and Hadoop … on Azure
. 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…
The potential of Big Data
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…
Netflix rocks–from great entertainment to showcasing how to develop for the Cloud
. . 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…
At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?
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!
Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010
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…
Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)
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. …