Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Wednesday, 5 July 2017

Microsoft Power BI Desktop and Service - Walk through with a report development

This post will walk you through the fundamentals in Power BI and the source for the example is taken from the reference link from Power BI tutorials.

The idea for writing this post is, one of my friends who was from a different technology stack in a need to know BI concepts, terminologies to understand the counter part BI demonstrations in his project in which BI stack is Power BI

Hence, taking Jasper and Pentaho BI concepts into considerations, today we have explored few topics in Power BI and thought of putting together the explored points for community folks.




Below presentation has step by step images and pointers to understand below Indexed topics.

 Click Me to Download PPT

Index
1) Create a web data source
2) Editing web data source
3) Removing a column
4) Split a column ( .  and  left parenthesis )
5) Replace a character
6) Change query name and save the query
7) Edit the saved query to add a custom field
8) How the query fields looks like in Fields Editor
9) Report creation using visualizations
10) Adding a Table component and formatting
        (row banding and increasing font size)
11) Adding Bar+Line Visualization 
12) Adding donut visualizations to complete IMDB report.
13) Saving and publishing report to power service

Download PPT

The outcome of the report looks something as shown in below image.
 (Click on image to get best view)
This example is shared to public which is a feature in Power BI and it can be accessible by clicking on below link.  

Example for Public (Only available 50 days from the date of posting this article)

References :  https://www.youtube.com/watch?v=ByIUx-HmQbw

7 comments:

  1. I like your blog, I read this blog please update more content on hacking,Nice post
    Power BI Online Training Hyderabad

    ReplyDelete
  2. Graet article with very unique content.
    keep sharing it more concepts.
    Thank you....

    Power BI Training

    ReplyDelete
  3. I have found great and massive information on. Thanks for sharing
    Power BI Training
    Power BI Course

    ReplyDelete
  4. The article is very interesting and effective
    Informative blog and it was up to the point describing the information very effectively.
    Visit:Best power bi training institute in Hyderabad

    ReplyDelete
  5. Thanks for sharing this informative article on Microsoft Power BI Desktop and Service - Walk through with a report development. If you want to Power BI development Company for your project. Please visit us.

    ReplyDelete