Power BI For Data Science

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  R and Power BI with Stagraph (no code)

    Top Contributor
    Posted Jun 26, 2018 10:47 AM
    Hey community,

    I recently discovered a beautiful R GUI tool called <g class="gr_ gr_43 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="43" data-gr-id="43">Stagraph</g>. It allows you to import, manage and visualize data using the power R within a GUI interface and with no code.

    What is also more important, you can connect it with Power BI and create very good dashboards and reports (and not entering a single line of R code).

    <g class="gr_ gr_344 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="344" data-gr-id="344">Stagraph</g> is an example of a general-purpose R GUI application. <g class="gr_ gr_345 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="345" data-gr-id="345">Stagraph</g> focuses on data import, data wrangling <g class="gr_ gr_349 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="349" data-gr-id="349">and</g> data visualization. These are core functions that <g class="gr_ gr_348 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="348" data-gr-id="348">forms</g> the base of any data analysis. Functions are based on R packages from the Tidyverse group. With <g class="gr_ gr_346 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="346" data-gr-id="346">Stagraph</g>, you can use these features without the knowledge of R language. On the other hand, if you are skilled in R language, you can use it on multiple levels.

    The basis is data import. For these purposes, <g class="gr_ gr_356 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="356" data-gr-id="356">Stagraph</g> offers several tools to import data from files on disk or from databases (via ODBC connection). In addition, <g class="gr_ gr_357 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="357" data-gr-id="357">Stagraph</g> integrates into the interface data from selected R packages. An example of this can be map datasets that you can instantly use for your analysis and visualizations. <g class="gr_ gr_372 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="372" data-gr-id="372" style="color: #000000; font-size: 16px;">Stagraph</g> contains 87 built-in functions for data wrangling.

    Cleaned data needs to be understood - visually explored. Statistical graphics <g class="gr_ gr_393 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="393" data-gr-id="393">is</g> in <g class="gr_ gr_390 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="390" data-gr-id="390">Stagraph</g> based on the Grammar of Graphics, implemented in <g class="gr_ gr_392 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" id="392" data-gr-id="392">ggplot2</g> package. With this R package, you can create impressive visualizations very quickly by combining simple functions and objects. For these purposes, you can use 80 geometry layers, 50 statistical functions, 7 annotation layers, 90 scales, 7 coordinate systems, 6 plot faceting options and 28 plot themes. Again, no need to enter one single line of R code.


    Finally, all of your work can be exported from the program as R scripts. You can use these scripts outside the program environment. <g class="gr_ gr_513 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" id="513" data-gr-id="513">As</g> <g class="gr_ gr_517 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep gr-progress" id="517" data-gr-id="517">example</g> can be mentioned R Visuals in Power BI Desktop software. Some examples <g class="gr_ gr_638 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" id="638" data-gr-id="638">bellow</g>:

    <g class="gr_ gr_604 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="604" data-gr-id="604">Stagraph</g> & Power BI - Setup Connection

    YouTube remove preview
    <g class="gr_ gr_600 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="600" data-gr-id="600">Stagraph</g> & Power BI - Setup Connection
    http://stagraph.com This<g class="gr_ gr_686 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Grammar only-ins doubleReplace replaceWithoutSep" id="686" data-gr-id="686"> vid</g>eo-tutorial describes required steps for connecting <g class="gr_ gr_601 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="601" data-gr-id="601">Stagraph</g> with Power BI. Create R visuals for Power BI using Stagraph interface.
    View this on YouTube >


    <g class="gr_ gr_690 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="690" data-gr-id="690">Stagraph</g> & Power BI - Application Examples

    YouTube remove preview
    Stagraph & Power BI - Application Examples
    More info: http://stagraph.com/Post?Id=29&Title=Stagraph+%26+Power+BI+Desktop+%5bPart+2%5d This video presents options of <g class="gr_ gr_692 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="692" data-gr-id="692">Stagraph</g> & Power BI features combination. Create impressive data visualizations in R language for Power BI<g class="gr_ gr_707 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" id="707" data-gr-id="707"> Des</g>ktop in few simple steps.
    View this on YouTube >

      


    Let me share with you a blog that I saw from KDnuggets.com

    <g class="gr_ gr_679 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="679" data-gr-id="679">Stagraph</g> - a general purpose R GUI, for data import, wrangling, and visualization

    ------------------------------
    Pablo Moreno
    Data Intelligence Engineer
    Dell
    Panama
    69444206
    ------------------------------


  • 2.  RE: R and Power BI with Stagraph (no code)

    Top Contributor
    Posted Jun 28, 2018 12:43 PM
    Thank you for sharing I will have a look at it ASAP

    ------------------------------
    Regards
    Mehdi HAMMADI
    ------------------------------