Power BI is my favourite BI and visualization tool as it is very simple yet powerful. It doesn’t only support traditional data sources like databases, CSV, JSON, XML and etc., but also supports emerging sources that are available in HDFS, Spark, R, Salesforce, Google Analytics and cloud platforms and etc. It is extremely easy for users that are only familiar with tools like Excel. It has desktop, mobile and online service versions. The desktop version is free to everyone.

Google Analytics provides hundreds of measures and dimensions you can use to create insightful dashboards. Google already provides a number of reports and dashboards that you can customize in the website. However it could not connect to your website databases or other data sources. When combing your own data with Google Analytics data, you can generate even deeper insights.

In this series, I’m going to show you how to create powerful dashboard using Power BI. The data are sourced from Google Analytics and the backend SQL Azure database of this website.

Sample dashboard

Eventually, you will be able to generate a similar dashboard like the following screenshot:

image

* The above charts are just some demos which you can do quickly with Power BI but it doesn't mean they are the best practices. It only took me a couple hours to create the above live dashboard.

* The dashboard can be deployed into Power BI service where you can configure automatic refresh.

* The dashboard is highly interactive as it provides slicers and drill-through functionalities.

Download and install Power BI

Download Power BI desktop from the following website:

https://powerbi.microsoft.com/en-us/downloads/

You can also use Power BI Service if you have an account available to use.

Outline

I will continuously update this page when the new tutorial is ready.

Power BI Analytics - Connect to DBMS and Card

Follow this page to setup DBMS connections and to create a Card visualization:

Power BI Analytics - Connect to DBMS and Card

image

Power BI Analytics - Line Chart and Running Total (Quick Measures)

To be added.  Stay tuned.

Power BI Analytics - Clustered Bar chart and drill-through

To be added. Stay tuned.

Power BI Analytics - Treemap

To be added. Stay tuned.

Power BI Analytics - Line and Column Chart

To be added. Stay tuned.

Power BI Analytics - Filled map

To be added. Stay tuned.

Power BI Analytics - Donut chart

To be added. Stay tuned.

Power BI Analytics - Gauge

To be added. Stay tuned.

Power BI Analytics - Stacked bar chart

To be added. Stay tuned.

Power BI Analytics - Table

To be added. Stay tuned.

Power BI Analytics - KPI

To be added. Stay tuned.

Power BI Analytics - Slicers

To be added. Stay tuned.

Power BI Analytics - Data Models

To be added. Stay tuned.

Power BI Analytics - Summary and others

To be added. Stay tuned.

info Last modified by Raymond at 3 years ago * This page is subject to Site terms.

More from Kontext

local_offer Azure local_offer power-bi

visibility 1870
thumb_up 1
access_time 2 years ago

Microsoft Azure provides a number of data analytics related products and services. It allows users to tailor the solutions to meet different requirements, for example, architecture for modern data warehouse, advanced analytics with big data or real time analytics. The following diagram sho...

open_in_new Azure

Use Google Cloud BigQuery as Data Source in Power BI

local_offer plot local_offer power-bi local_offer bigquery

visibility 6923
thumb_up 0
access_time 2 years ago

BigQuery is Google’s serverless data warehouse in Google Cloud. Power BI can consume data from various sources including RDBMS, NoSQL, Could, Services, etc. It is also easy to get data from BigQuery in Power BI. In this article, I am going to demonstrate how to connect to BigQuery to create...

open_in_new Power BI

local_offer power-bi

visibility 269
thumb_up 0
access_time 3 years ago

DATATABLE StaticTable1 = DATATABLE("IntCol",INTEGER,"StringCol",STRING,{{1,"User1"},{2,"User2"}}) The above expression generates a table with two columns IntCol and StringCol : ...

open_in_new Power BI

Power BI Analytics - Connect to DBMS and Card

local_offer plot local_offer power-bi

visibility 438
thumb_up 0
access_time 3 years ago

Power BI supports connecting to most of the DBMS databases such as SQL Server, Oracle, Teradata, MySQL, DB2, Sybase, Snowflake, Google BigQuery, Impala and etc. This page summarizes the steps to connect to SQL Azure and to create the following part of the sample dashboard of this series: ...

open_in_new Power BI

info About author

comment Comments (0)

comment Add comment

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

No comments yet.

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.


Learn more arrow_forward