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 part of the SQL […]
Read MoreArticles by: Melvin Black
Create a Performance Point Dashboard
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 evangelizing the self-service BI trend where we […]
Read MoreBuilding Excel Dashboards
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 most common tool for dashboard development. In this video, I […]
Read MoreIntroduction To Building PowerPivot Datasource
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 important Before Microsoft’s introduction of xVelocity […]
Read MoreIntroduction to PowerView Creating Calculations
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 create calculated columns within PowerView What is DAX? […]
Read MoreIntroduction to PowerView Maps
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 plotting up to a million data points […]
Read MoreIntroduction to Adding Images in PowerView Dashboards
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 […]
Read MoreIntroduction to PowerView Creating KPIs by Melvin Black
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 […]
Read MoreIntroduction to PowerView by Melvin Black
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 will […]
Read More