it f business intelligence
Download
Skip this Video
Download Presentation
IT&F: BUSINESS INTELLIGENCE

Loading in 2 Seconds...

play fullscreen
1 / 28

IT&F: BUSINESS INTELLIGENCE - PowerPoint PPT Presentation


  • 130 Views
  • Uploaded on

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

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 ' IT&F: BUSINESS INTELLIGENCE' - marion


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
Critical Thinking
  • Doing well
  • Extra lab 2-330 on Friday #395, Homework help
  • Easy Meter
business intelligence
Business Intelligence

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

- Wayne Eckerson, TDWI

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 by B. Wixom

why is d ata bad
Why is Data Bad?

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

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
Approaches to Data Quality
  • Find and Fix
  • Prevent at the source
  • Do nothing (3M)
homework

Homework

Business Scenario:Google’s Daily Cagr

daily cagr for google
You are an analyst at a 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
cleaning phone n umbers
Cleaning Phone Numbers
  • From:#2-345-3-48565
  • To:(234)-534-8565
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 l ast n on empty r ow
Dim lastRow As Integer = Cells(Rows.Count,1).End(Excel.XlDirection.xlUp).RowFinding the Last Non-empty Row
suggestions
Suggestions
  • Video available
  • Come to the Lab
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
ad