As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft has been updating it frequently. The latest update has many new features, among them:
- Connectivity to Windows Azure Table Storage – You can now import from Windows Azure…
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video). Each of these products have different requirements:
Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.
The October 2013 release contains an updated installer that… Read more
A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power Query, Power Pivot, Power View, Power Map, Power BI sites, Data Management, Power BI Admin center, Power BI for mobile, and Power BI Q&A.
With so many tools it can… Read more
I recorded my first video presentation and demo using the screen recording and video editing software called Camtasia Studio for Windows.
It’s a great product that makes it easy to create videos that includes demos. They also have a nice list of tutorials.
They offer a fully functional… Read more
Last month I blogged that SQL Server Data Tools for SQL Server 2014 CTP2 now available. You can download that here. This will run the SSDT install (not a SQL Server 2014 install). This installs the Visual Studio 2012 shell, and makes available the SQL Server Database Project… Read more
I have been using Power BI the past few weeks after I was invited by Microsoft to test the Power BI for Office 365 Preview (register here). I have to say I am extremely impressed. It allows for a self-service reporting and ETL environment that can be a game-changer.… Read more
While the tabular model in SSAS makes it much easier to build cubes than the multidimensional model, I am not seeing it used as much as I expected. One reason is if you are a BI developer and have been using the multidimensional model for a while, you tend to… Read more
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data Warehouse (FTDW) workload. FTDW is a reference configuration optimized for data warehousing. Not only is there an image for SQL Server 2012 SP1 (rated for 400GB database warehousing workloads), but… Read more
Windows Azure SQL Reporting was the new name of the reporting services component (which was formerly known as SQL Azure Reporting Services) that went live June 12, 2012.
However today, October 31, 2013, notification went out to current Windows Azure SQL Reporting customers that the service will be discontinued in… Read more
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL Server 2014 databases. SQL Server Data Tools for SQL Server 2014 CTP2 is pre-release software, does not support upgrade from an existing SSDT install or upgrading to any new… Read more
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I met over 100 people who were presenters or bloggers (I counted). I made an effort to find them as I wondered around the halls. I also had a lot… Read more
Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
- Enhanced In-Memory OLTP, including new tools which will help you identify and migrate the tables and stored procedures will benefit most from In-Memory OLTP, as well…
As a consultant I am often starting from the ground floor on a new data warehouse/business intelligence project, and usually one of the first tasks is to interview business users from various groups. During these interviews I am doing an assessment – trying to understand the current environment and documenting… Read more
Thanks to everyone who attended my session “Transitioning to a BI role” at the PASS SQL Saturday Charlotte. The abstract is below. Another packed room with a number of people standing!
Here is the PowerPoint presentation: Transitioning to a BI role.
Transitioning to a BI role
Business Intelligence… Read more
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It was a packed room with many people having to stand. Maybe next year I’ll get a bigger room I hope you enjoyed it!
Here is the… Read more
I will be arriving Sunday night in Charlotte and attending a pre-conference session on Monday and Tuesday.… Read more
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into one area and talk about the Data Warehouse Maturity Model. The graphic below, from Wayne Eckerson, is very accurate based on my dozens of interactions with clients:
Business… Read more
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these are two separate disciplines. This is especially true for enterprise data warehouses due to an EDW’s scope, complexity, and large volumes of data.
As seen in the data warehouse… Read more
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my reaction: I’m a Microsoft MVP and I feel great!