Day Number of Year, Power Query Custom Function

0

There are number of Date and DateTime built-in functions in Power Query which are really helpful. There is also a function for DayNumberOfYear. However I’ve thought it would be a good example to go through writing a function that uses Generators, Each singleton function, and error handling all inside a custom function. Through this post you will also learn;

  • how to create Custom Function
  • how to use Generators as loop structure
  • and how to user Error Handling.

[…]

SSAS Tabular Live Power BI Connection

4

When Power BI 2.0 released as General Availability I’ve published a post that highlights all new features in this product. One of the features was SSAS Tabular Live Power BI Connection. In this post I want to explore more what the Live connection means and what are advantages of this type of connection. Power BI Designer (Previous version of Power BI Desktop) was supporting offline connection to SSAS. The new SSAS Live connection of Power BI only works with SSAS Tabular at the moment.

[…]

Power BI: How to Analyze FIFA 2014 Worldcup

2405348_xbig-lnd

It was sometimes ago that I’ve posted some data analysis that I’ve done with Power BI Designer on FIFA 2014 Worldcup results. In this post I want to take you through the process of how to achieve that analysis. This post is an introduction to Power BI features with the example of FIFA 2014 Worldcup result set. Through this post you will learn how to connect to web based data sets and mash up the data with Power Query component of Power BI Desktop. And finally how to model it and visualize it in the Power BI report. Most of the data for this example comes from data sets in FIFA 2014 Worldcup official website: http://www.fifa.com/worldcup/archive/brazil2014/index.html

[…]

All in One: What’s New in Power BI Desktop 2.0 GA

32

The Breaking news of General Availability of Power BI 2.0 in now everywhere all around the world. In this post I’ll illustrate some great new features of Power BI. if you would like to see a real world example of Power BI you can read FIFA 2014 Worldcup Data Analysis with Power BI, I’ll update that example later on with the new Power BI version. It has been a while that Power BI was on Preview, and with the great effort from Microsoft product team it is now available fully released. As per Microsoft blog post on 21st of July 2015 Microsoft mentioned some great features that will be available in this release, in this post we will go through them one by one. […]

Self Service BI- Power Query-Section 1: Search for Data

In this Video I tried to gather some information about Dog Breeds from different 3 websites : http://www.mans-best-friend.org.uk/dog-breeds-alphabetical-list.htm http://www.dogbreedslist.info/ https://en.wikipedia.org/wiki/List_of_dog_breeds I have explained how to get data from these websites even they don’t provide any API.    

Introduction to Power BI Designer

blog

Power BI Designer is the new Editor for Power BI main components which are: Power Query, Power Pivot, and Power View. Power BI Designer made building Power BI solutions easier with an integrated solution. Power BI Designer’s files can be easily uploaded into Power BI site. In this tutorial video you will learn basics of Power BI Designer, some demos of this product, getting data from FIFA 2014 World Cup website, and creating charts and dashboards. In the demo you will also learn how to deploy the report to Power BI site, and how to view the dashboard and report from Power BI app.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 5: Power BI

pbi

Power BI is not a strange word these days, there are many blog posts, videos, news, and speakings about it. Power BI is Microsoft Cloud BI services that released recently. Power BI is not only Cloud BI but also it offers good self-service BI stack as well. Power BI has five main components which are:

  • Power Query: For data extraction, transformation, and load into model.
  • Power Pivot: Data Modelling tool.
  • Power View: Data Visualization tool
  • Power Map: 3D Geo-spatial data visualization tool.
  • Power Q&A: Engine for natural language questions and answering

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 4: Data Visualization

logo

Data Visualization is the front end of your BI system. It will be seen from the user’s point of view as the whole BI system! The reason for that is users only will see this part of the BI system, they won’t see Data Warehouse, ETL,  andData Governance… What they see is only dashboards and charts explaining data values. So it is essential to do the data visualization right and effective. A good data visualization should be able to tell story behind the data. A bad data visualization won’t help users even if you have a good data warehouse or ETL design. So you should spent time to analyze ever dashboard, chart, and table and make that a good story teller to the user.

[…]

FIFA 2014 World Cup Data Analysis with Power BI

2405348_xbig-lnd

Fifa 2014 is not a hot topic these days, but it was the headline news June 2014. With new capabilities in Power BI Designer I tempted to use FIFA 2014 Worldcup data as a demo of it, and play with the tool to see how it works. Fortunately I was able to build some interesting dashboards with it. The demo work was interesting enough to say that I probably would write detailed information about how to build such demo, and would use it in some of my conference speakings.

I’ve used data from official Fifa.com website for most parts of this demo. you can reach FIFA.com official site for 2014 Brazil from here:

[…]