Midlands SQL Server User Group - 17th September 2015, 6.30pm
Session 1: Adam Aspin - Power BI as your data warehousing proof of concept toolkit
Session 2: Prathy Kamasani - Dive into the SSIS Catalog and SSISDB using PowerBI
6.15pm – 6:30pm Meet & Greet
6:30pm - 7:30pm Adam Aspin - Power BI as your data warehousing proof of concept toolkit
We have all been through the Business Intelligence / Data Warehouse development cycle.
Endless theoretical cycles, data mapping exercises, wire-frames for reports. Excel and possibly Visio as the only tools in our armoury. Cheery scrum masters intent on convincing management and users that anything can be refactored in a few hour’s work – even a 20 dimension Terabyte data warehouse and 50 reports that were signed off months ago but that now need “revisiting” given the “new input” from users – who, now that they have finally got their hands on something to play with can begin to imagine what they really want.
Well, perhaps Power BI can help you laugh rather than cry when developing your next data warehouse. Instead of starting out with the industrial-strength tools in the SQL Server toolkit consider:
- Testing data sources and load processes with Power Query.
- Building your initial star schema and aggregations and KPIs with Power Pivot.
- Creating reports based on real data using Power View.
- Delivering proof of concept via the Cloud with Power BI.
Use this toolset to get the feedback that lets you make core adjustments – and potentially discover fundamental issues - sooner rather than later in the development cycle. Then build the solution that you always knew was possible, having scoped and planned more accurately.
This short talk takes you through the Power BI product set and explains how you can get analyse, experiment and iterate during the first stages of data warehouse development using Excel and Power BI. You will see how to give users an instant feel for the possibilities, make the concepts more intuitive and specify the required outputs, aggregations and KPIs more efficiently.
7:30pm - 8:00pm Break & Food
8:00pm – 9:00pm Prathy Kamasani - Dive into the SSIS Catalog and SSISDB using PowerBI
If you have worked with SQL Server Integration Services (SSIS) 2012 or above for few years then you already familiar with SSIS Catalog reports that help you to monitor projects that have been deployed to the server. By using these reports, we can quickly find information related to executions, logging and other interesting things with few mouse clicks.
But have you ever wondered how to design an SSIS Project so we can take maximum benefit of SSIS Catalog and SSIS DB? How to troubleshoot SSIS Project executions from Catalog? How to navigate your way around the built-in catalog reports? This session will focus on these scenarios by diving into SSISDB catalog views and discuss how we can extend metadata captured by SSISDB. We will also discuss how we can create our SSIS Monitoring tool using PowerBI
We'll be at the Midlands Art Centre (MAC Birmingham), B12 9QH.
It's directly opposite Edgebaston Cricket Ground in Birmingham
Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground
Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.
The 45 & 47 are the best options, which depart from outside Boots in the Bullring, opposite where the main entrance to New Street station was, on Smallbrook Queensway.
Room: When you get there, we're in the 'Pincent Masons 1' room. On the 1st floor, above the main entrance.
We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.
Dress code: relaxed
If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email Alex@SQLMidlands.com
Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for seventeen years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.
A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SharePoint and PowerBI.
Business Intelligence has been his principal focus for the last ten years. He has applied his skills for a range of clients, including J.P. Morgan, The Organisation for Economic Co-operation and Development (OECD), Tesco, Centrica, Harrods, Vodafone, Crédit Agricole, Cartier, EMC Conchango, Alfred Dunhill, The RAC, Willis Insurance, TNT and Signet.
Adam is a frequent contributor to SQLServerCentral.com and Simple-Talk. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years.
He is the author of “SQL Server Data Integration Recipes” – Apress, November 2012, and High Impact Data Visualization with Power View, Power Map, and Power BI– Apress, June 2014 and Business Intelligence with SQL Server Reporting Services– Apress, March 2015.
Prathy Kamasani - TBC
When & Where
SQLMidlands - Bringing the West Midlands SQL Server community together
We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.
We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.
If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!
This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!