fim business intelligence n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
FIM: BUSINESS INTELLIGENCE PowerPoint Presentation
Download Presentation
FIM: BUSINESS INTELLIGENCE

Loading in 2 Seconds...

play fullscreen
1 / 28

FIM: BUSINESS INTELLIGENCE - PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on

FIM: BUSINESS INTELLIGENCE. Stefano Grazioli. Doing well Extra lab 2-330 on Friday #395, Homework help Easy Meter. Critical Thinking. The processes, technologies, and people to turn data into information in order to drive profitable business action. - Wayne Eckerson, TDWI.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'FIM: BUSINESS INTELLIGENCE' - nomlanga-tate


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
critical thinking
Doing well

Extra lab 2-330 on Friday #395, Homework help

Easy Meter

Critical Thinking
business intelligence
The processes, technologies, and peopleto turn data into informationin order to drive profitable business action.

- Wayne Eckerson, TDWI

Business Intelligence

Source: B. Wixom

bi and analytics
BI and Analytics

Analytics is “the extensive use of data, statistical and quantitative analysis, explanatory and predictive models, and fact-based management to drive decisions and actions” (Davenport and Harris – Competing on Analytics)

“BI refers to the general ability to organize, access and analyze information in order to learn and understand the business.” (Gartner)

b usiness v alue from data
Business Value from Data

Strategy

  • Usable data
  • High quality data
  • Usefuldata

(big)DataUse

  • Accurate
  • Timely
  • Valid
  • Awareness
  • Access
  • Usefulness
  • Security
  • Privacy
  • Meaning
  • Scope
  • Sharing

Business Value

Based on work byB. Wixom

why is d ata bad

No one gets up in the morning and says“I’m going to make lots of errors today”

Why is Data Bad?

Source: T. Redman, Data Driven, 2008

data quality benchmarks
Data Quality Benchmarks
  • Analysts cannot find what they need 50% of the times
  • 10-25% of the records have inaccuracies or missing elements
  • Data frequently misinterpreted
  • Known data loss and theft
  • Most databases implement inconsistent definitions
  • 50% of the stored data is never used
  • 10x duplication of data

Source: T. Redman, Data Driven, 2008

approaches to data quality

Find and Fix

Prevent at the source

Do nothing (3M)

Approaches to Data Quality
homework

Homework

Business Scenario:Google’s Daily Cagr

daily cagr for google
You are an analyst ata broker firm.Daily Cagr for Google

Many of our customers invest for short amounts of time on Google. They sell their shares within a few weeks…. I wonder: do they make any money out of it?

daily cagr for google1
file with~800customers whobought and sold GOOG within thelast two months.

Three steps (and two homework)

Clean data: phones, dates

Compute Daily Cagr = [(final price/initial price)1/days ]-1

Report the Average Daily Cagracross all customers.

Daily Cagr for Google
slide13

UML Activity Diagram - Daily Compound Average Growth of a Security (part I)

When the user presses a button labeled “start”, a file selection windows pops out. The user selects a .csv file. The file is shown starting at “A1”. The start button becomes invisible.

Three more buttons appear: “Clean phone numbers”, “Format Dates”, and “Compute Daily CAGR”.

Select the next column and/or date

[is a date]

Format asmm/dd/yyyy

& clear highlight if any

Highlight the cell in yellow

A

Next homework

[Compute]

[Format Dates]

[Clean ph.no]

[No More Dates in this column]

Select the next phone no. Count its digits

[Exactly 10 digits]

[No more columns]

Format as(xxx)-xxx-xxxx

& clear highlight if any

Highlight the cell in red

A

A

[No More Ph.No]

reading a file into excel
' store the address of the current active sheet, i.e., the ‘target’

DimmyActiveS AsExcel.Worksheet = Application.ActiveSheet

' select a file

DimmyFile AsString= Application.GetOpenFilename()

'get the data in a new temporary workbook

Application.Workbooks.OpenText(myFile, , , Excel.XlTextParsingType.xlDelimited, , , , , True)

' store the address of the temporary workbook

DimmyActiveWB As Excel.Workbook = Application.ActiveWorkbook

' copy the content from the temporary to the ‘target’ sheet

myActiveS.Range("A1:J1000").Value = Application.ActiveSheet.Range("A1:J1000").Value

‘ close the temp workbook

myActiveWB.Close()

Reading a File into EXCEL
finding the last non empty row
Dim lastRow As Integer = Cells(Rows.Count,1).End(Excel.XlDirection.xlUp).RowFinding the last non-empty row
winit

WINIT

What Is NewIn Technology?

strings and characters
DimmyString AsString=“This is a sample string"

DimmyString2 AsString = "s"

DimmyChar AsChar = "s"c

Strings and Characters
testing numbers
DimmyString AsString = "#2344-234-33-3"

Dimtemp AsString = ""

ForEach x AsCharIn myString

If IsNumeric(x) Then

temp = temp + x

EndIf

Next

Testing Numbers
inserting and removing
Dim myS AsString = "This is a sample string"

myS = myS.Insert(4, "xyz")

myS = myS.Remove(4, 3) 'starting where, how many

myString = myS.Replace(" is", " was")

myS = myS.Substring(0, 9) + “ another" + myS.Substring(10, 13) + "."

Inserting and Removing
finding
Dim myS AsString = "This is a sample string"

DimmyPosition AsInteger = 0

myPosition = myS.IndexOf("s")

Finding
trimming and padding
myLenght = myString.Length

myNewString = myString.Trim()

myNewString = myString.TrimEnd()

myNewString = myString.TrimStart()

myNewString = myString.PadLeft(50)

myNewString = myString.PadRight(20)

Trimming and Padding

Total length of the result

you do the talking
Name, major

Learning objectives

Things you like about the class

Things that can be improved

Strengths / Attitude towards the Tournament

You do the talking
dates
Dim myDate AsDate = "11/14/2002“

Year = myDate.Year

Month = myDate.Month

Day = myDate.Day

DOW = myDate.DayOfWeek

DOY = myDate.DayOfYear

...

...

Dates

MyDate

2002

Year

11

Month

14

Day

45

Week

....

...

timespan
DimmyDate1 AsDate

DimmyDate2 AsDate

DimmyTS AsTimeSpan

myDate1 = Range("A1").Value

myDate2 = Range("A2").Value

myTS = myDate2 - myDate1

Range("A3").Value = myTS.Days

TimeSpan

A TimeSpan represents the elapsed time between two dates.

Date1

Date2

TIMESPAN

timespan1
mySpan.Days

gives you the total number of days

mySpan.TotalDays

gives you the total number of days, plus a fraction of day based on the hours

TimeSpan