Convert Matrix data in Excel to Tabular Data in Power BI.

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data Read more about Convert Matrix data in Excel to Tabular Data in Power BI.[…]

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure

One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]

Scenarios of Using Calculated Tables in Power BI

Calculated tables first introduced in September 2015 update of Power BI Desktop. The name speak for itself; these are tables created by calculation. As these are in-memory tables their calculation is based on DAX (Data Analysis eXpression language). There are many benefits of using Calculated tables, such as using them for role playing dimensions (for Read more about Scenarios of Using Calculated Tables in Power BI[…]

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

[…]

SQL Saturday Vienna 2015- A Journey to Power BI

To download the Session slides click below link : A-Journey To Power BI My session   God turn out in SQL Saturday Vienna   An Interesting Keynote speech by Mark Souza    Have fun the day after SQL Saturday around Vienna with other Speakers     I have Talked about Power BI in SQL Saturday Vienna , Special Read more about SQL Saturday Vienna 2015- A Journey to Power BI[…]

Power BI Pre-Con; from Rookie to Rockstar

Have you heard about Power BI? Do you know Power BI Components? Have you worked with Power Query Formula language called M? Do you know what are strong capabilities of this language and tool? Have you build PowerPivot models with strong DAX expressions and deployed in Power BI site? Do you know different types of Read more about Power BI Pre-Con; from Rookie to Rockstar[…]