Giter Site home page Giter Site logo

awesome-power-bi's Introduction

Awesome Power BI!

Join the chat at https://gitter.im/awesome-power-bi

A collection of awesome Power BI frameworks, libraries, tools, resources, and software. This project is envisioned, designed and maintained by Akvelon volunteer development team. If You would like Akvelon to develop a Power BI dashboard or custom visual, please, contact me via rustem.mustafin [at] akvelon.com or twitter: @Rulikkk or check out visuals we've developed.

Inspired by awesome, awesome-dotnet, awesome-nodejs, frontend-dev-bookmarks.

Contributions are always welcome!

Thanks to all contributors, you're awesome and wouldn't be possible without you! The goal is to build a categorized community-driven collection of very well-known resources.

Contents

General

Apps

Official Pages

Development

This chapter covers topics related to building custom visuals and other ways to develop with Power BI. You can also check visuals developed by Akvelon and by Microsoft, which are open-source and serve as good samples of how to implement a custom visual.

Custom Visuals Development

  • Power BI Visuals — A step-by-step tutorial of developing your first Power BI visual by Microsoft.

Utils

Power BI utils are set of tools that allow developer of Power BI visual to easily implement most common capabilities of visualizations.

Connectors

Power BI connectors and other tools that allow you to connect to various data sources.

  • SSASQueryProxy - simple proxy for getting MDX query results from Analysis Services (SSAS) instance accessed by using MSMDPUMP HTTP interface to Power BI Desktop / Service WITH support for scheduled refresh

Other Development Resources

  • Power BI for Developers Overview — Answer to "What can developers do with Power BI?" question and a good starting point for developing with Power BI.
  • Power BI and R — Video-tutorial about Power BI and R, including R Scripts and R Visuals.
  • Power BI C# — .NET developer community for Power BI.
  • Power BI Javascript — JavaScript library for embedding Power BI into your apps.
  • Charticulator enables you to create bespoke and reusable chart layouts without writing any code. The constructor allows to export chart as Power BI visual.

Leaders

Independent powerBI technology leaders

  • Kerry Kolosko. A passionate data visualization enthusiast from Australia, actively engaged in PowerBI community. Here is an example of her review of PlotlyJS custom visual which was created by the Akvelon team. If you're interested in her work, you can find a collection of her own data visualization templates on her website. She also shares her knowledge and expertise on her YouTube channel.

  • Dave Gibbon. A pioneer of using 3D visualization tools. He is an experienced individual in the data visualization industry, who has provided a comprehensive review of the PlotlyJS custom visual, which you can try following the link.

  • Daniel Marsh-Patrick is a consultant and producer of Power BI custom visuals from New Zealand. He has created numerous visuals of his own, which are available on his website. Additionally, you can visit his GitHub for more information about his visuals and projects.

Visuals

Visuals Developed by Akvelon

  • Bubble Chart by Akvelon (source) — Bubble Chart by Akvelon provides efficient way to visualize your data that has one numeric dimension and one or two categories. This chart is simplified version of Scatter chart with tightly packed bubbles - this way you can show more categories in a given space. Additionally, Bubble chart allows creating groups of bubbles by providing additional second category field bucket.
  • Custom Calendar by Akvelon — Akvelon’s Custom Calendar for Power BI is the best way to view and display daily data from any source.
  • Hierarchy Chart by Akvelon — This Power BI add-on is perfect for ranking different departments, jobs, and employees who make up an organization. It can also be used to show family history and visualize genealogy information. If your data can be visualized in a tree structure, the Hierarchy Chart can display it in an easy-to-read format.
  • KPI Chart by Akvelon — KPI Chart by Akvelon is a single visualization for illustrating and efficiently analyzing the correlation between two measures and it combines a line chart and a column chart with the same X-axis. Column and line charts show representation of the distribution of numerical data. Additionally, KPI Chart by Akvelon allows showing static and dynamic background KPI regions that can characterize, for example, the level of success before reaching the target.
  • Scatter Chart by Akvelon — Scatter Chart by Akvelon is similar to other two-dimensional chart visuals and allows you to assess your units using multiple measures - X and Y axes coordinates, point size and saturation. Additionally, it supports rectangle selection - such filtering allows to select multiple points of the scatter within rectangle area. This feature will help you to filter specific cluster within your data and update your report to show information about that specific data points.
  • PlotlyJS by Akvelon - The Plotly.js integration combines Plotly.js, Chart Studio and Power BI to provide a comprehensive data visualization experience. It leverages the capabilities of ploty.js to offer a chart editor, empowering users to create and customize over 40 types of charts. This powerful tool enables the creation of various visualizations, ranging from simple Scatter charts to intricate 3D charts, Finance charts, and specialized visuals. You may find review of this visual by one of the independent powerBI technology leaders, such as Kerry Kolosko or Dave Gibbon

MS Open-Source Visuals

Akvelon developers are actively supporting and have contributed to the large list of custom open-source, MIT-licensed visuals and tools, started by Microsoft:

  • Visuals Tools — Tools for building/packaging Power BI visuals. Every Power BI custom visuals developer uses these tools.

  • Webpack plugin - The plugin allows for developing custom visuals by using webpack to build a visual package.

  • Aster — An Aster plot is a twist on a standard donut chart, using a second value to drive sweep angle.

  • Bullet Chart — A bullet chart that includes four orientations and a few customization options. Use to feature a single measure against a qualitative range.

  • Cartogram — Displays a hierarchical map set as a circle for each location, with size/color from specified values.

  • Chiclet Slicer — Use this slicer to display image and/or text buttons that act as an in-canvas filter. Define additional properties for the layout & selection to customize this slicer to meet your specific needs.

  • Chord Diagram — A chord diagram is a graphical method of displaying the interrelationships between data in a matrix.

  • Choropleth — Displays a hierarchical map set with each location filled in a color from specified values.

  • Dotplot — A dot plot is used to show a representation of the distribution of frequencies. It is most often used to show counts of an occurrence.

  • Drilldown Player — Animates report components like a slicer on autopilot.

  • Dual KPI — A visual for displaying two correlated KPIs within a single visual.

  • Enhanced Scatter — A few more properties were added to the existing scatter chart visual, including shapes as markers, background image support, and developer crosshairs for positioning elements onto an image background.

  • Force Graph — Allows to visualize the relationship between items, the weightage of the relationship and the flow often brings out the untold insights into limelight, which are otherwise not very evident.

  • Funnel — Find outliers in your data, using a funnel plot.

  • Gantt Chart — A Gantt chart is a type of bar chart which illustrates a project timeline or schedule.

  • Globe Map — A 3D visual using WebGL for plotting locations, with category values displayed as bar heights and heat maps.

  • Heatmap — Use this custom visual to build a table heat map that can be used to visualise and compare data values in an easy and intuitive way.

  • Histogram — A histogram chart plots data ranges into intervals. Useful for estimating density.

  • Line Dot Chart — The LineDot chart is an animated line chart with fun animated dots. Use the LineDot chart to engage your audience especially in a presentation context.

  • Mekko Chart — A mix of a 100% stacked column chart and a 100% stacked bar chart combined into one view. Similar to a treemap, the dimensional values are represented by length and width of each rectangle. The width of a column is proportional to the total value of the column.

  • Pulse Chart — Pulse chart shows a line chart annotated with key events. Each event can be selected to filter and cross highlight other visuals to reveal insights or help tell a story.

  • Radar — A simple radar chart supporting multiple measures plotted over a categorical axis. Also known as a web chart, spider chart, or star chart. Use to display performance metrics for quality improvement.

  • Sample Bar Chart — A sample bar chart visual, used for tutorial purposes.

  • Sample Slicer — A sample slicer visual for tutorials, demonstrating the use of the Advanced Filtering API introduced in the version 1.7 of PowerBI Visuals Tools.

  • Sankey — Type of flow diagram in which the width of the series is in proportion to the quantity of the flow. Use it to find major contributions to an overall flow.

  • Stream Graph — A stacked area chart with smooth interpolation. Often used to display values over time.

  • Sunburst — Sunburst is a multilevel donut chart, used to visualize hierarchical data, depicted by concentric circles.

  • Timeline — Graphical date range selector used as a filtering component in the report canvas.

  • Tornado — A bar chart with category values listed vertically. Use for comparing the relative importance of a variable between two distinct groups.

  • Word Cloud — Word Cloud is a visual representation of word frequency and value. Use it to get instant insight into the most important terms in a set.

  • Charticulator - Charticulator (charticulator.com) is the no-code way to create custom and reusable chart designs. Now you can create a custom chart right within Power BI using the Microsoft Charticulator Visual, either from scratch or using a template.

Power BI in AppSource

Courses

  • Akvelon's PowerBI Custom Visual Workshop — In this five-days hands-on online training workshop you will learn how to build a new Power BI Custom Visual. Our Custom Visual developers have experience in creating many types of Power BI visualizations and will help you learn how you can achieve your goals in visualizing your data and take your Power BI reports to the next level.
  • Analyzing and Visualizing Data with Power BI — Learn from the Power BI product team at Microsoft with a series of short, lecture-based videos, complete with demos, quizzes, and hands-on labs.
  • Microsoft Power BI - A Complete Introduction — Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Service, and PowerBI Developer.
  • Power BI Training — A 5-minute hands-on video-introduction to Power BI.

Communities

Tutorials

This section contains tutorials about using Power BI. If You are looking for development resources and tutorials, please head to development section.

awesome-power-bi's People

Contributors

bullet03 avatar ilfatgaliev avatar jmarsik avatar rulikkk avatar zbritva avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

awesome-power-bi's Issues

New tool allowing MDX query connection to SSAS instance outside of AD domain with scheduled refresh support

Hello,

I have put together a small tool which allows users to connect to SSAS instance that sits outside of AD domain (probably published to the outside world with MSMDPUMP HTTP interface) from Power BI Service and supports scheduled refresh. It's not a complete connector, it only allows execution of MDX queries, but it's better than nothing. If someone has SSAS instance with this configuration and wants some of the data from this instance available in Power BI to create reports, dashboards, access them from mobile devices, all of that with scheduled refresh, it's a way to go.

Could you include it somewhere in your list? Probably some new Tools or Connectors section?

Link and description from GitHub:

https://github.com/jmarsik/SSASQueryProxy
Simple proxy for getting MDX query results from Analysis Services (SSAS) instance accessed by using MSMDPUMP HTTP interface to Power BI Desktop / Service WITH support for scheduled refresh!

Or is there a better way to send new links to you to put them into this awesome list?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.