Dynamite Data Visualization with Power View in Microsoft Excel
Not every business has perfectly structured data. But with managed self-service business intelligence, you can now create rich, powerful analytics solutions that let you glean and share business insights from that data. This walk-through session begins with actual small business data in Excel format and add data from Windows Azure to expand your analytics possibilities and show how to integrate data from SQL or other sources. PowerPivot takes the stage next, joining the data and enhancing it with calculated fields and KPIs. We step through Power View to produce beautiful visualizations and deep exploration functionality. We finish by sharing our solution, publishing it to SharePoint (using both PowerPivot Gallery and Excel Web Services) and via PowerPoint. Whether you’re an IT pro or business user and whatever your data’s structure, after this session, you’ll have the start-to-finish instruction manual to take any data set from drab to DYNAMITE!