Omaha SQL/BI User Group Meeting: Nov 6th 2013
Speaker:Jeff Magsamen Technology Specialist - Analytics and BI Solutions, Microsoft CorporationJeff joined Microsoft in 2007 as a Senior Consultant in the Communications Sector and moved to a Regional Architect role in August of 2010. In April of 2012 Jeff transitioned to his present Technology Specialist role where he serves customers in Iowa, Kansas, Nebraska and Missouri as a pre-sales Technical Specialist. He has over 17 years of data warehousing and business intelligence experience implementing solutions at Fortune 500 corporations, including financial, sales and marketing, operational and media and entertainment systems. While at Microsoft he has led the delivery of solutions involving telecom and cable company customer, technical operations, provisioning & sales and churn data. Prior to Microsoft, Jeff was a Manager of Financial Systems at Sprint Corporation where he led the development of financial, billing and customer data warehousing and business intelligence systems. Before Sprint, Jeff was a Consultant with Symmetry Corporation where he was responsible for successfully implementing business intelligence and analytical systems at Gartner, Level3 Communications, Palm, Clorox, Hewlett Packard, UUNET and MFS Communications. Jeff began his career in Internal Audit at Sprint Corporation and has a BA in Accounting from the University of Nebraska. He currently lives in Overland Park, KS with his wife Christy and two daughters Claire and Ellie
TopicPower BI for Office 365 provides everyone with powerful new ways to work with data in Excel and Office 365. Easily search, discover, and access data within and outside your organization and, with just a few clicks, shape and transform data.Analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device. Discover and Combine Data· Search and access public data and your organization’s data.· Clean, transform, and merge data from multiple sources.
Model and Analyze· Create relationships, custom measures, hierarchies, and KPIs.· Perform lightning-fast analytics with in-memory technology.
Visualize· Bring your data to life with stunning interactive data visualizations.· Add depth to your analyses with 3D geospatial analysis.· Present with interactive data views and tours.
Share Data and insights· Create Power BI Sites to share live interactive reports.· Share and manage data sets for others.· Control and monitor data usage.
Access Anywhere· Browse Excel and Power View reports with HTML 5.· Stay connected with the touch-optimized Power BI mobile app.
Sponsor:DataVailCompanies everywhere are feeling greater pressure to compete more efficiently within today’s economic landscape. IT departments are encouraged to find ways to do more with less. Retention issues threaten the health of your database environment. DBAs quit and take with them years of indispensable knowledge of your company’s database environment. One is left to wonder, "There has to be a better way."Whether it is helping a company to prevent downtime through a managed database service, boost a team’s ability to troubleshoot through a specific project or give an in-house team the much-needed relief they deserve – Datavail is the reliable, focused team of on-demand DBA experts that a company trusts.At Datavail, you will find the flexibility and personal focus of a boutique database consultancy, delivering the excellence and professionalism you would expect to see in the largest outsourcers in the world with lower-cost, labor arbitrage, more hours and no compromises of quality or security. While other database experts boast only of technical expertise, it is our mission to combine world-class talent with a reliable ITIL process, executive sponsorship, an effective communication strategy and a set of operating principles, delivering consistent results lasting long after the initial kickoff.