Big Picture Review & some common questions about SQL Server 2012 Power View answered


 

IMG_0215It has been a while since I have blogged and this has been due to my recent involvement with the Big Picture event that took place in Melbourne and Sydney. I was busy with the technical setup and developing a demo scenario for the Insights 24/7 area – a name inspired by the famous TV show “24”. The best moment for me was setting up the bullpit area – the office of my dreams with many large screens hanging of the wall. Everyone who visited the event quite liked this setup, and this has inspired me to build a much bigger one for the next event (if we still have budget for one Smile).

At this event we were able to provide visitors with immersive experiences rather than death by PowerPoint. It was experiences in all our technologies from consumer side of things with Xbox to our Enterprise products such as BI, Server monitoring, Private cloud, etc. At the Insights 24/7 we had a demo scenario of a Auto Car manufacturer that is using our Dynamics AX ERP system from which they detect an issue using the Role Center feature – built in SQL Server Reporting Services reports, Analysis Services cubes and SharePoint delivery.

Once a problem was detected the demo moved to the business analyst (played by me) in which I show cased the use of Power Pivot and Power View to conduct analysis using a web browser. Once this was done and I showed the new animated Scatter plot, this was well received by the audiences, I then conducted a Lync video call with the marketing team to showcase how our collaboration platform can assist in decision making process.

The marketing team then took the data that was in Power Pivot and applied Data Mining algorithms to derive insights. This was all using the Predixion addins to Excel and sending the data to their cloud infrastructure, it can also be done on premise using the data mining algorithms in the Analysis Services engine. If you want more information about Predixion, please contact their resellers in Australia BizData – nadav.rayman@bizdata.com.au.

Once the marketing team figured out an effective marketing campaign then we moved to the use of Twitter Analytics using Power Pivot to analyse the effectiveness of it via social media. For more information on this see my previous blog post.

We also had the HP BI Appliance, the Business Decision Appliance showcasing how quick it is to implement a BI solution based on Excel Power Pivot and publish it onto the SharePoint 2010 and PowerPivot SQL Server integrated on the appliance.

A big Thank You to the team that put together the demos and delivered them so well.

IMG_0235

 

 

 

 

 

 

 

 

 

At the event I got lots of positive reaction on the new data visualisation tool called Power View in SQL Server 2012, especially when I showcased the Scatter plot animated over time. Below is a screen shot of Power View – think of it like Power Point for your data, create rich visualisation of your data through dragging and dropping interface. You can see it in action in a video – https://www.youtube.com/watch?v=J5fwphWxNoE

After showcasing Power View I received the below 2 common questions at the Big Picture event, and as such I thought it would be worthwhile to blog about them.

Do I need SharePoint 2010 to use Power View?

The short answer to this question is Yes you do need to have SharePoint 2010 Enterprise to be able to take advantage of the new Power View visualization capability that is part of SQL Server 2012 Reporting Service running in SharePoint integrated mode.

For more information on this refer to the SQL Server 2012 RC0 documentation:

How do I make these dashboards, reports work on my iPad/Phone, mobile devices?

To answer this question I am referring you to the blog post from the SQL Server Reporting Services team – http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/10/13/power-view-pass-and-mobile.aspx. Below is the snippet from it referring to Microsoft’s mobile BI strategy.

After looking at market trends and industry expectations, we crafted our long term Mobile BI strategy that covers all of the Microsoft BI assets. It is a 3 phase strategy:

Phase 1 – 1HCY12:

Enable our existing SharePoint based BI assets (SSRS Operational report, Excel Services, Performance Point) to run on various browsers (including IOS).

Phase 2 – 2HCY12:

Provide touch based and touch optimized experiences on multiple devices. Prototypes of these were shown by Amir on stage on a set of WP7, Android and iPad devices. Some in the audience have assumed that this
demo did mean that this capability would be available with Denali as a result. That is NOT the case. We announced a timeline for it, not a release vehicle. At this point, we are also not disclosing the technology choices we
are making in order to enable these experiences.

You can see this prototypes in action at – https://www.youtube.com/watch?v=0vLLAdjGtrU

clip_image001clip_image003clip_image005

Phase 3 – Windows 8 Wave:

Provide an immersive experience on Windows 8 device. A prototype of what this experience could look like was shown by Amir on stage during the keynote. Again this demo DID NOT suggest that this would be available in the Denali timeframe. Timeline is TBD on this as we will look to align with Windows 8 itself. We are also at this point not disclosing the technology choices we are making in order to enable this immersive experience on Win8 devices.

What about doing Mobile BI today using Microsoft BI?

Now Customers looking to deploy and use Microsoft BI on mobile devices today have a broad host of Microsoft partners available to them. These partner solutions support a broad range of mobile devices and are built off of
the Microsoft BI solution stack.

Examples include:

Comments (4)

  1. Guneet Kalra says:

    Hi Shashank ,

    I tried opening Power view reports on my Ipad after upgrading test env. to sharepoint 2010 SP1 with June CU , still none of the reports open on Ipad , i checked the same using Safari 5

  2. WQ says:

    http://www.fashionclothing.mex.com/ Sure,
    http://www.louisvuitton.so/ the process
    http://www.burberryonlineshop.de/ of flinging
    http://www.nikefree-run.org.uk/ a spinnerbait
    http://www.harrods-london.co.uk/ may
    http://www.airmax-90.org/ catch
    http://www.pradashoes.com.co/ a http://www.lululemoncanada.ca/ rogue fish off
    http://www.nike-air-max.com.de/ of
    http://www.yoga-pants.ca/ nothing http://www.rayban.com.de/ here and
    http://www.longchampoutlet.com.co/ there,
    http://www.babyliss.us.org/ but
    http://www.nike-air-max.ca/ I’ve found that
    http://www.nike-roshe-run.de/ during the
    http://www.nike-air-max.com.au/ course
    http://www.the-north-face.ca/ of the http://www.longchamp.us.org/ average true
    http://www.ghdhairstraightener.com.co/ cover-seeking day, your
    http://www.newbalance.com.es/ only looking
    http://www.nike-rosherun.nl/ for a
    http://www.burberry-outlet.me.uk/ few extra bites
    http://www.abercrombie-hollister.nl/ from “between”
    http://www.rolex-watches-canada.ca/ bass.
    http://www.christianlouboutin.org.uk/ I’d
    http://www.swarovski-australia.com.au/ rather
    http://www.hollister-abercrombie.com.se/ be
    http://www.converse.com.de/ locked http://www.tiffany-und-co.de/ and
    http://www.truereligionjeans.net.co/ loaded for
    http://www.bcbgdresses.in.net/ the
    http://www.ralphlaurenoutletonline.in.net/ gentle
    http://www.the-northface.com.co/ pitch, then
    http://www.coachoutlet-online.com.co/ carelessly
    http://www.louis-vuittonoutletcanada.ca/ unleashing
    http://www.longchamp.com.de/ the http://www.mmoncler-outlet.com/ firing
    http://www.montblanc–pens.in.net/ squad.
    http://www.ralphlaurenoutletonline.us.org/ What
    http://www.guccioutlet.us.org/ I
    http://www.uggs.co.nl/ mean
    http://www.cheapoakleysunglasses.ar.com/ is that
    http://www.pandorajewellery.com.au/ in most cases
    http://www.nikeshoesoutlet.org.uk/ I’d
    http://www.handbagsoutlet.com.co/ rather
    http://www.uggbootsclearance.com.co/ be putting along “between”
    http://www.horloges-rolex.nl/ at http://www.toryburchsale.com.co/ a
    http://www.michaelkorsoutlet.ar.com/ moderate pace
    http://www.celinebags.org/ with
    http://www.bcbg-max-azria.ca/ the
    http://www.louisvuitton-outlet.com.co/ same
    http://www.designerhandbagsoutlet.com.co/ jig
    http://www.michaelkors.co.nl/ in my
    http://www.michaeljordan.com.de/ hand that I
    http://www.nike-air-max.com.se/ had
    http://www.thenorthfacejackets.in.net/ success with on
    http://www.burberry–outlet.com.co/ the http://www.prada.com.de/ docks
    http://www.cheapjerseys.us.org/ all
    http://www.maccosmetics.gr.com/ day, and
    http://www.michael-kors.com.co/ looking
    http://www.louboutin.jp.net/ for
    http://www.swarovski-online-shop.de/ that
    http://www.vans-schuhe.com.de/ unique
    http://www.michaelkorsoutletonline-sale.us.com/ cast/pitch
    http://www.cheap-uggboots.in.net/ to
    http://www.mcmhandbags.com.co/ something

  3. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much
    http://www.lokerjobindo.com lokerius
    http://www.kerjabumn.com somone
    http://www.lokerjobindo.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html I need
    http://www.kerjabumn.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html beberapa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru.html langka sebenaernua
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-nindya-karya.html ada rasa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-cimb-niaga.html sama kita
    http://www.lokerjobindo.com/2015/11/info-kerja-bumn-pt-sarana-multi.html tapi sebenarnya
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-pt-citilink.html tahukan anda
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3-s1-pt-hk-realtindo.html sebutan dari
    http://www.lokerjobindo.com/2015/11/info-kerja-bank-bri-frontliner.html kita adalah
    http://www.lokerjobindo.com/2015/11/info-lowongan-kerja-staf-hubungan.html anugrah yang

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-pertamina-retail.html dapat kita
    http://www.lokerjobindo.com/2015/11/info-kerja-professional-insurance.html capai

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-it-programmer.html sebenarnya
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-bca-syariah.html rahasia itu
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-danamon.html hanya ada
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3.html dalam sebuah cerita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-bni-life-insurance.html tentang kita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-axa-mandiri.html yah begitulah hidup
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-sinamrmas.html hidup itu cuma sekali
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-mandiri-syariah.html tidak ada keduakalinya
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-btn.html maksudnya cuma hidup di dunia
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pt-astra-international.html rahasia semua kediupan
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-adira-finance.html semuanya akan

    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pertamina-geothermal.html ada saatnya di mana
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-bca.html semua akan melakkan
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-jatim.html langkah satu persatu
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-icon-pln.html demi mengjar suksesnya
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-s1-kalbe.html rahasia hidup

  4. aw says:

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-kementerian-lingkungan.html Lowongan Kerja Kementerian Lingkungan Hidup dan Kehutanan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CIKUPA Lowongan Kerja CIKUPA
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pln-tingkat.html Lowongan Kerja PLN Tingkat SMK/STM/Sederajat
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D1 Lowongan Kerja D1
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-management-trainee.html Lowongan Kerja Management Trainee
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D2 Lowongan Kerja D2
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-management-trainee.html Lowongan Kerja Management Trainee
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3 Lowongan Kerja D3
    http://www.lokerjobindo.com/2015/11/info-kerja-bank-bri-frontliner.html Info Kerja Bank BRI Frontliner
    http://www.lokerjobindo.com/2015/11/loker-keuangan-ar-ap.html Loker Keuangan AR-AP
    http://www.lokerjobindo.com/2015/11/loker-pdam-kabupaten-tapin-smk-d3-s1.html Loker PDAM Kabupaten Tapin SMK D3 S1
    http://www.lokerjobindo.com/2015/11/loker-terbaru-pt-bank-negara-indonesia.html Loker Terbaru PT. Bank Negara Indonesia (Persero)
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-accounting-staff-pt.html Lowongan Kerja Accounting Staff PT. Kimia Farma Tbk
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-adaro-energy-tbk.html Lowongan Kerja Adaro Energy Tbk
    http://www.lokerjobindo.com/2015/12/lowongan-kerja-admin-multimedia-officer.html Lowongan Kerja Admin & Multimedia Officer Bank BII
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bpjs-kesehatan.html Lowongan Kerja BPJS Kesehatan
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-barata-indonesia.html Lowongan Kerja BUMN PT Barata Indonesia
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-kereta-api.html Lowongan Kerja BUMN PT Kereta Api Indonesia
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-bca-syariah.html Lowongan Kerja Bank BCA Syariah
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-cimb-niaga.html Lowongan Kerja Bank CIMB Niaga
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bulan-desember-pt-hm.html Lowongan Kerja Bulan Desember PT HM Sampoerna Tbk
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3.html Lowongan Kerja D3

Skip to main content