SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is...

Performance Point Services Over the last few years Microsoft has been releasing a serious of new capabilities in in Business Intelligence offering. SQL Server has always been the central technology around the MSBI offerings and that makes sense. Now the current emphasis is...

Excel Dashboard. In previous videos, I demonstrated the use of PowerView when creating dashboards. Now, I going to demonstrate dashboard creation with a more familiar tool, Excel. Despite the release of several visualization tools by Microsoft, Excel still represents Microsoft...

Creating PowerPivot data sources As I have demonstrated there are a lot of things about PowerBI to get excited about. One of these is Microsoft’s adaption of the technology xVelocity. The true power behind PowerPivot is the xVelocity in-memory analytics engine. Why XVelocity is...

Creating Calculations Now that you have a solid understanding of creating some basic PowerView dashboards. You are ready to extend the model with custom calculations. In this next demonstration, I will introduces the Data Analysis Expressions (DAX) language and explains how to...

Adding Maps For those that have experience with the Map capabilities in SQL Reporting Services, you know Microsoft defiantly had a lot of room for improvement. With PowerBI, Power Map greatly increases the mapping visualizations at your disposal. It can produce visualizations by...

Using Images in PowerView Images give your dashboards a professional look and provide more ease of use. PowerView allows you to use images in about every possible way. One of the most effective usages of images in PowerView is with the Card object. In the last section you saw how...

Creating KPIs KPIs are a staple of many dashboards and provide a great way to quickly see trends and spot areas that need further analysis. One of the nice features about KPIs in PowerBI when it comes to creating KPIs that it allows you enhance existing measures and not create a...

Introduction to PowerView Microsoft has been a leader in the Business Intelligence (BI) space. With SQL Server and Excel having been on the market for over 20 years it has always had a presence in data management. Today, one of the new initiatives in BI is self-service BI.  I...