إضغط لتفاصيل الإعلانات



Results 1 to 9 of 9
Share
  1. #1

    Thumbs up Data Analysis Using SQL and Excel




    The first chapter, “A Data Miner Looks at SQL,” introduces SQL from the
    perspective of data analysis. This is the querying part of the SQL language, where data stored in databases is extracted using SQL queries.


    The second chapter, “What’s In a Table? Getting Started with Data Exploration,” introduces Excel for exploratory data analysis and presentation. Of many useful capabilities in Excel, perhaps the most useful are charts.

    Chapter 3, “How Different Is Different?”, explains some key concepts of descriptive statistics, such as averages, p-values, and the chi-square test.The purpose of this chapter is to show how to use such statistics on data residing in tables.

    Chapter 4, “Where Is It All Happening? Location, Location, Location,” explains geography and how to incorporate geographic information into data analysis. Geography starts with locations, described by latitude and longitude.

    Chapter 5, “It’s a Matter of Time,” discusses another key attribute of customer behavior, when things occur. This chapter describes how to access features of dates and times in databases, and then how to use this information to understand customers.

    Chapters 6 and 7, “How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value” and “Factors Affecting Survival: The What and Why of Customer Tenure,” explain one of the most important analytic techniques for understanding customers over time.

    Chapter 8 covers everything about the purchase—when it occurs, where it occurs, how often —except for the particular items being purchased. Purchases contain a lot of information, even before we dive into the details of the items.

    Chapter 9 explains association rules, which are combinations of products purchased at the same time or in sequence. Building association rules in SQL is rather sophisticated, usually requiring intermediate tables.

    Chapter 10, “Data Mining Models in SQL,” introduces the idea of data mining modeling and the terminology associated with building such models. It also discusses some important types of models that are well-suited to business problems and the SQL environment.

    Chapter 11, “The Best Fit Line: Linear Regression Models,” covers a more traditional statistical technique, linear regression. Several variants of linear regression are introduced, including polynomial regression, weighted regression, multiple regression, and exponential regression.

    The final chapter, “Building Customer Signatures for Further Analysis,” introduces the customer signature. This is a data structure that summarizes what a customer looks like at a particular point in time.
    this is the link for download this ebook

    http://www.mediafire.com/?b6xy3ssgmn8



  2. Facebook Comments - تعليقـك على الفيس بوك يسعدنا ويطور مجهوداتنـا


  3. Forum Ads:

  4. Forum Ads:

    اضفط هنا لمعرفة تفاصيل الإعلانات بالموقع


  5. Forum Ads:

    -->

  6. #2
    Join Date
    Nov 2007
    Location
    Arab world!
    Posts
    6,169
    Blog Entries
    4
    Rep Power
    10

  7. #3

  8. Forum Ads:

  9. #4
    Join Date
    Jan 2008
    Location
    Egypt
    Posts
    3,946
    Blog Entries
    1
    Rep Power
    16

  10. #5

  11. Forum Ads:

  12. #6

  13. #7

    Default

    قال صلى الله عليه وسلم:
    "من قال: أستغفر الله الذي لا اله إلا هو الحي القيوم وأتوب إليه ـ ثلاثاً ـ غفرت ذنوبه وإن كان فارا من الزحف".

  14. #8

    Default



    أستغفر الله الذي لا اله الا هو الحي القيوم و أتوب اليه

    أستغفر الله الذي لا اله الا هو الحي القيوم و أتوب اليه

    أستغفر الله الذي لا اله الا هو الحي القيوم و أتوب اليه

    جزاكم الله مثله

  15. #9

Similar Threads

  1. I have a problem in Excel 2007 , I need help
    By Ramysameh in forum Microsoft
    Replies: 9
    Last Post: 24-07-2011, 09:10 PM
  2. BI Vacancies in Excel Systems
    By mohamadoz in forum Programming
    Replies: 0
    Last Post: 15-11-2010, 07:51 PM
  3. Advanced Excel & V.B instructors
    By mohamadoz in forum Programming
    Replies: 0
    Last Post: 16-09-2010, 11:48 PM
  4. System Analysis / Programmer
    By mohamadoz in forum Programming
    Replies: 1
    Last Post: 20-07-2009, 11:27 PM
  5. VTC TCP-IP Packet Analysis-CFE
    By Mohamed Fouad in forum Cisco
    Replies: 3
    Last Post: 11-10-2008, 06:17 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

أقسام المنتدى

الروابط النصية

تابع جروبنا على الفيس بوك

صفحة Egypt Engineers على الفيس بوك

تابعنا على linkedin

جروبنا على الياهو جروب