More Power BI API awesomeness, now on PowerShell & SmartCharts

Amazing week for Data lovers & Business Intelligence minds, Power BI Preview is now *globally* available! Be sure to check out the public announcement  for details. And Chris Webb’s BI blog for additional insights.

By now you know that there’s a new & strong developer story for the new Power BI,  and even if at the moment we have a simple API to test drive, it already allows to think of interesting scenarios. Particularly for real-time dashboards or  the click to insights pattern  I happen to obsess so much ….

Really, seems there will be no place for data to hide from Power BI :). When Power BI can’t get there… we will bring it to Power BI in a blink of an eye, in real time if needed, all using the brand new APIs.

Don’t have Power BI Designer? or even Excel? and need to quick load  some data to explore? Real time? Check out DevScope github  & use the awesome Power BI API Powershell modules to load your Data into PowerBI directly from the command line (for more info & a cool real time sample don’t miss  Rui Romano blog post).

Not forgetting we already have NuGet Power BI api modules for .Net, Xamarin,  iOS & Android by Sylvain Pontoreau .  Or more recently new sample web apps for Power BI api scenarios.

Adding that, as of… now :) you can also use SmartCharts to quick send & live sync to Power BI directly from Excel. :)

Start with your data as usual or the sample dataset and just click Send To Power BI.

image

Authenticate & authorize the app for Power BI access,  choose a Dataset and a table name :

image

and your data will be available in your Power BI account ready to more Power BI awesomeness

(note: if using date/time columns we also add some extra time related columns we happen to use in the app).

image

Your data ready to explore in Power BI:

image

image

image

Noting that you should be able to do all this on trial mode without any restrictions.  Got feedback and requests? let us know (there’s a feedback form in the app :) we will get back to you)

Get SmartCharts here, or checkout or other DevScope Labs  Office Apps here.

If you want to know more about the new APIs, some additional recommended reading:

More to come :) stay tuned

Rui

Advertisements

SmartCharts, SmartPivot & Gantt Chart for #Excel -Latest features & releases @DevScope #Apps

We updated some of our apps and add-ins last week. Brief post introducing some of the new features:

SmartPivot – now with Measure Group/Table Filter in search pane, also Table Report & Filter Tools improvements

A much requested feature now available (should have been in the initial Search release honestly…): SmartSearch pane now allows for measure group/table filtering, much like the regular PivotTable fields browser in Excel.

Download the new SmartPivot release here.

image

Fixed some issues also with Table Report & Filter Tools (both Saved Filters & Filter by list)

image

 

SmartCharts-now with real-time Share feature & Free download during SharePoint Conference 2014

You can now share your charts session, opening it in a browser or tablet/mobile window (disclaimer:some safari/OS issues still to fix). You can then collaborate real time with anyone connected to that SmartCharts session.

Also, you can freely download SmartCharts Task Pane in Office Store during #SPC2014. :) feedback will be appreciated!

Download SmartCharts Task Pane in Office Store

image

 

Gantt Chart & SmartCharts for SharePoint

Soon to be published SmartCharts for SharePoint ;) stay tuned.

image

Gantt Chart for Excel on the other hand is already available in Office Store, and free! :)

Download Gantt Chart for Excel

Gantt Chart for Excel

 

Take care,

 

Rui

Introducing SmartCharts Data Discovery App for Excel

Finally! :) time to briefly introduce our SmartCharts app for Excel now available at Office Apps Store (download here).

image  image  image image

So, yet another “chart” app/tool for Excel…what’s the point? :) what’s it for?

Well, beyond being a DevScope research project and a place where we will be test driving lots of #dataviz features using the latest technologies, there were some other drivers to build the app:

  • There’s so much data available these days, but still most people can’t even acknowledge that there’s lot of hidden value in data, being it small, medium or big data… so they don’t even start exploring it :(
  • Provide a data discovery tool that keeps user focus on the data, not modeling, not chart designing, just slice, dice & visual data mining
  • There are a lot of patterns for dataviz, but there seem to be a lack of reusable pre-built analytic models for the most simple data intelligence tasks, time series, pattern recognition, drill down views
  • We are building an excessive number of dashboards (really! we are), repeating the same patterns over and over again, same for data mining… can’t we get reusable analytic modules that quickly adapt to different datasets? Data+Services inter-connectable through already available metadata?
  • An Excel app  seemed an awesome way to continue the research work we started with our Data Insights addin few months ago (same core concepts really, we will be back to that eventually ;) )
  • A tool that we can now use to quickly & easily explore small datasets instantly in Excel (under 100k,150k rows) all kind of log tables, log streams, etl logs, usage logs. 
  • (yes, do not expect much value if you’re using it with small tables, or tables without time/date fields) it’s a data discovery tool, not a chart designing tool

All these are of course “experimental hypothesis” that we can now test and research (and already collecting lots of useful feedback :) ).

And stay tuned, we will be releasing some new features this week ;).

Download here & get us some feedback.

http://www.devscope.net/products/SmartCharts

Finishing this post with a few typical usage scenarios…

… these are from real data , loaded the app with different tables I regularly check (clickstream logs, usage logs, etl logs, ssas query logs,…)

(some values masked, sorry!)

Integration load resource usage (~80k rows dataset)

(side note that the first time I loaded this data on the app I immediately found that I was completely unaware on where integration load resources were being spent, and how that patterns were evolving over time)

image

Integration loads vs extracted rows

image

Drill down view of integration time over time

image

Time of day patterns (integration times)

image

Time of day patterns (rows extracted)

image

Now a completely different dataset(120k rows), obtained from an analysis services query trace table log, instant insights: (again note that no modeling or chart designing was necessary…just click, load & explore)

image

 

image

image

 

http://www.devscope.net/products/SmartCharts

Take care!

 

Rui