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

▶

Jan 07, 2023 161 likes •541 views

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, theres lots of other things you can do! DBMS DBMS

SLIDE 1

By Alex Ludden alex@ludden.com MyDataWrangler.com

SLIDE 2

Getting MORE Out Of Your DATA! What do I mean?

Mostly, we enter data into the system … and IDX?GECB handles the big picture

SLIDE 3

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

SLIDE 4

DBMS

SLIDE 5

DBMS Query

SLIDE 6

Excel Import

SLIDE 7

MS Access Import

SLIDE 8

EDI Processing

SLIDE 9

Capitation

SLIDE 10

Custom Modules - Points

SLIDE 11

Reports

SLIDE 12

Microsoft SQL Server

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

SLIDE 13

SQL Server Integration Services - SSIS

SLIDE 14

SQL Server Reporting Services - SSRS

SLIDE 15

SQL Server Analysis Services - SSAS

SLIDE 16

PowerPivot

SLIDE 17

LightSwitch

SLIDE 18

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

SLIDE 19

DBMS

SLIDE 20

DBMS Query

SLIDE 21

SSIS – Business Intelligence Development Studio

SLIDE 22

SSIS – Add tasks visually

SLIDE 23

SSIS – Settings (properties)

SLIDE 24

SSIS

SLIDE 25

SSIS

SLIDE 26

SSIS

SLIDE 27

SSIS – Data Flow Task

SLIDE 28

SSIS – Flat File

SLIDE 29

SSIS

SLIDE 30

SQL Server Reporting Services

SLIDE 31

SSRS

SLIDE 32

SSRS

Demo …

SLIDE 33

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!

SLIDE 34

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

SLIDE 35

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!

SLIDE 36