By Alex Ludden alex@ludden.com MyDataWrangler.com Getting MORE Out - PowerPoint PPT Presentation

By Alex Ludden alex@ludden.com MyDataWrangler.com

Getting MORE Out Of Your DATA! What do I mean? Mostly, we enter data into the system … and IDX?GECB handles the big picture

But, there’s lots of other things you can do!

DBMS

DBMS Query

Excel Import

MS Access Import

EDI Processing

Capitation

Custom Modules - Points

Reports

Microsoft SQL Server � Load into a Data Warehouse or Data Mart � Could easily contain all your data � Lots of Business Intelligence tools

SQL Server Integration Services - SSIS

SQL Server Reporting Services - SSRS

SQL Server Analysis Services - SSAS

PowerPivot

LightSwitch

Chances are you own some of these tools already! � PowerPivot is free if you have Excel 2010. � Access is part of Microsoft Office (or add-on). � You probably already have SQL Server � It includes SSIS, SSRS, SSAS � SQL Server Express is free � Lightswitch – costs $299

DBMS

DBMS Query

SSIS – Business Intelligence Development Studio

SSIS – Add tasks visually

SSIS – Settings (properties)

SSIS

SSIS

SSIS

SSIS – Data Flow Task

SSIS – Flat File

SSIS

SQL Server Reporting Services

SSRS

SSRS � Demo …

Main Take-Aways � You can use DBMS to extract data for those processes that you need to do outside of the box � There are a lot of free tools or tools that you may already own to process this data � These are graphical tools that allow your power users to create the solutions you need � You can do it!

Resources � Your friendly local DBMS guru ☺ � Powerpivot: http://www.powerpivot.com/ � Access: http://office.microsoft.com/en-us/access/ � SQL Server: http://www.microsoft.com/sqlserver � Lightswitch: http://www.microsoft.com/visualstudio/en- us/lightswitch

Questions? � Email: alex@ludden.com � Web and Blog: www.MyDataWrangler.com � Intro to SSIS blog entries � These slides � If you have MCA, talk to us about our recovery solutions!