So here i was learning about Business Intelligence, I viewed many sites and in the end i was able to write a short but quick-learning facts about PowerQuery, PowerPivot, PowerView and PowerReports in EXCEL.
I
gathered up some good information from other blogs which are referenced
below, and made a blog which helps you differentiate between PowerView and PowerPivot.
Please Read and give you reviews :)
What is Power Query?
- Power Query is a free Power BI feature that provides a highly useful data query and shaping experience. In addition to standard data sources, Power Query supports querying File System (“From Folder” option), and databases: Oracle, DB2, MySQL, PostgreSQL and Teradata. It can also tap into public and private data sources including an organizations’ local data, Active Directory, SharePoint Lists, Windows Azure Marketplace, and Facebook account. Power Query can use “big data” implementations such as Windows Azure HDInsight or Hadoop. A core capability of Power Query is to filter and combine queries from different data sources by merging or appending them. Any such data mash-up is expressed with Power Query Formula Language expressions, used to store (data modification) steps in Excel for repeatable data mash-up.
- Power Query is a powerful tool that can extract Facebook data and shape it into valuable information. Power View works hand-in-hand with Power Query to create meaningful visualizations based on defined query. Both Power Query and Power View open optimal routes for data exploration, sharpening self-service BI skills and having fun with what is very familiar to many of us: Facebook activity.
What is Power View
- Power View is an interactive data exploration, visualization, and presentation feature. Power View offers a variety of useful visualizations, from tables and matrices to pie charts, bar graphs, and bubble charts. For more sophisticated tasks, Power View also offers features such as slicers, tiles, vertical/horizontal multiples, and scatter chart play axis.
PowerPivot vs. PowerView, What is the Difference?
- First Understand that Power Pivot is kind of like Two Things : 1st is the Power Pivot window, and 2nd is the Excel window.
While looking
at the visualization layer (Excel), rather than the Power Pivot window.
The lines blur a bit there, yes, but essentially we still have the Model (data,
tables, relationships, calc columns, measures, etc.) and we have the
reports/visualizations (pivots, charts, etc.) in Excel.
Power View is Purely an Alternative to the Excel Visualization Layer
Example: The User Group Maps
You know those maps of Power Pivot/Excel
user group interest I’ve been posting the past couple of
days? Well those are Power View visualizations in Excel 2013:
Now… could I have used a PivotTable for this? Maybe. But
here’s the trick: locations don’t always match in the data even though
they match in the real world.
Example:
Two Problems: “GA” is the Same as “Georgia,” and Alpharetta
is Part of Metropolitan Atlanta
They Should All Be One User Group – I Need All of Those to Be Considered the Same Place!
They Should All Be One User Group – I Need All of Those to Be Considered the Same Place!
So in some sense you can think of
this Map visualization in PV as a smart “grouping” feature, since it uses the
Bing Maps engine to plop all of those dots in the same place:
Power View Geographically Charts All of Those Rows as a Cluster On
the Map, Just Like I Need!
Compare that to a pivot, which
treats them as 3 separate locations:
A Pivot Will Treat Those Locations Just as Distinctly as it Does
Athens Greece
In Both Cases Though..
- Both the pivot and the PV map connect to the same Power Pivot model and use the same measures (like Response Count). It’s just that in 2013 we get to choose different visualizations for different purposes.
- In other words, ideally we would all view Power View as just a new type of Excel Chart, whereas today it admittedly feels like an alien transplanted into the Excel box. (I’m providing a lot of feedback to MS along those lines and so far it has been warmly received, which always feels nice).
- We also now have GeoFlow, which honestly I’ve yet to experiment with, but will soon. In true MS fashion we now have two competing map-charts hosted in the same product! Woo hoo! Let’s hope they unify those two, and THEN unify both of those with the rest of Excel.
PowerView Offers More than Maps
- There’s also a “Card View” (pictured below) and everyone’s favorite, the
animated bubble chart.
- More on these later. It is not my intent to taunt people with things they can’t use, and honestly I don’t enjoy working with 2013 that much due to a number of cosmetic issues. So I’m keeping the blog firmly rooted in 2010 for the forseeable future.
References
Hope it helps :)
No comments:
Post a Comment