Watch the video demonstration of how to create Power Pivot model that helps you create report not just on calendar month and year but also on financial month and year. Introducing Date Table (Date Dimension) In BI technology it is a common practice to have a separate role playing date […]
Read MoreTraining
DAX Calculation – YTD or Running Total in Power Pivot
Watch the video demonstration of creating Year to Date (YTD) measure using DAX in Power Pivot. What is DAX? DAX is a formula language to create calculations in Power Pivot and Tabular Model. It is similar to excel formula and is used to create calculated columns or calculated fields 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 More
Power BI Designer – Another tool?
Watch the video demonstration of building reports using Power BI Designer. Yes, Power BI Designer (download steps) is one more tool (desktop based) introduced by Microsoft to create Model and Report for Power BI dashboard. Now you may not feel good about it considering the fact that you are still scratching […]
Read More Power BI – Beyond Introduction
Watch the video demonstration of adding Excel Dataset in Power BI. If you have signed-up for PowerBi, here is the link to access the app https://app.powerbi.com/ Power BI supports varied types of Data sources which can be defined as Dataset. We can connect to or import datasets from a variety of sources: […]
Read More Introduction to Power BI
Watch the official video on Power BI PowerBI (still in Preview mode) is Microsoft self-service business intelligence solutions for Office 365 that includes features like Excel 2013 – Power Pivot, Power View, Power Query and Power Map on SharePoint 2013 environment. PowerBI in-short is a Cloud based BI service that […]
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 More
Introduction 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 More Introduction 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 More