In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to hopefully make things easy for you: Power BI Made Simple. It is a presentation that covers all the products under the Power … Continue reading →
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012 (order). Much thanks goes to my co-author and friend Bill Anton. Below is a brief overview or check out the … Continue reading →
“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). Power BI is an Office 365 marketing offering (see pricing). Each of … Continue reading →
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, … Continue reading →
I have been using Power BI the past few weeks (see my video of all the features) 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. … Continue reading →
Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365: Power BI for Office 365 is a cloud-based business intelligence (BI) solution that enables customers to easily gain insights from their data, working within Excel to analyze and visualize … Continue reading →
As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via SQL Server 2012 Service Pack 1 Cumulative Update 4. So you can now create Power View reports against multidimensional models … Continue reading →
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model). Note that any reporting tool that supports the … Continue reading →
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data from tabular models. At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to … Continue reading →
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL PASS?): PASS Summit 2012 had 3,894 delegates – up 13% from last year’s previous record attendance – and 1,717 pre-conference … Continue reading →
The requirements for Power View state that it can only use tabular models as data sources. So if you want to use Power View against a multidimensional cube, you are stuck. But there is a work-around: Create a PowerPivot for SharePoint … Continue reading →
Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”. This is a newer version of the add-in that is installed with SharePoint 2010, with … Continue reading →
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a … Continue reading →
Some announcements and notes from SQL PASS Summit 2011, going on this week: It was announced that the official name of the SQL Server “Denali” product is SQL Server 2012 and will be released in the first half of the year 2012. There … Continue reading →
CTP3 of SQL Server Code 2012, code name “Denali”, was made available for download this morning. You can download the 32-bit and 64-bit versions here. Official announcement from the SQL Server team blog and the announcement from the Analysis Services … Continue reading →
Power View (code name “Project Crescent”) is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server 2012, code-named “Denali”. It will offer a fun, visual, and powerful drag-and-drop ad hoc reporting experience. It is an web-based end-user … Continue reading →