Search results “Sql server text mining and data”
Full-Text Search in SQL Server 2012 - practical introduction
It is an introduction to Full-Text Search in SQL Server 2012. It walks through installation, configuration and usage of a powerful database engine component for searching in texts. The video contains examples of SQL queries using contains, freetext, freetexttable functions.
Views: 38530 DBA presents
Advanced Analytics with R and SQL
R is the lingua franca of Analytics. SQL is the world’s most popular database language. What magic can you make happen by combining the power of R and SQL for Data Science and Advanced Analytics? Imagine the power of exploring, transforming, modeling, and scoring data at scale from the comfort of your favorite R environment. Now, imagine operationalizing the models you create directly in SQL Server, allowing your applications to use them from T-SQL, executed right where your data resides. Come learn how to build and deploy intelligent applications that combine the power of R, SQL Server, thousands of open source R extension packages, and high-performance implementations of the most popular machine learning algorithms at scale.
Data Mining in SQL Server Analysis Services
Presenter: Brian Knight
Views: 96954 PASStv
SAP HANA Academy - Text Mining: Using SQL to access Text Mining Functions [SPS 10]
Text Mining existed in SAP HANA SPS09, but it is easier to use in SPS10. In this video, Tahir Hussain Babar (Bob) shows how easy it is to use some of the Text Mining functions in SAP HANA SPS10. These are accessed via SQL, and in the video, Bob gives some examples of the possibilities of Text Mining in SAP HANA SPS10. Scripts ; https://github.com/saphanaacademy/TextAnalysis_Search_Mining/blob/master/TextMining_SPS10.txt Thank you for watching. Video by the SAP HANA Academy. SOCIAL MEDIA Feel free to connect with us at the links below: LinkedIn: https://linkedin.com/saphanaacademy Twitter: https://twitter.com/saphanaacademy Facebook: https://www.facebook.com/saphanaacademy/ Google+: https://plus.google.com/u/0/111935864030551244982 Github: https://github.com/saphanaacademy
Views: 3492 SAP HANA Academy
Data cleaning with SSIS - Part1
Data cleaning with SSIS - Part1 (using SQL Server 2012) by Gideon Ogongo and LGIT Smart Solutions.
Views: 16287 LGIT Smart Solutions
Lead and Lag functions in SQL Server 2012
In this video we will discuss about Lead and Lag functions. Lead and Lag functions Introduced in SQL Server 2012 Lead function is used to access subsequent row data along with current row data Lag function is used to access previous row data along with current row data ORDER BY clause is required PARTITION BY clause is optional Syntax LEAD(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) LAG(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) Offset - Number of rows to lead or lag. Default_Value - The default value to return if the number of rows to lead or lag goes beyond first row or last row in a table or partition. If default value is not specified NULL is returned. We will use the following Employees table for the examples in this video SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 1000) Insert Into Employees Values (2, 'John', 'Male', 2000) Insert Into Employees Values (3, 'Pam', 'Female', 3000) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 5000) Insert Into Employees Values (6, 'Mary', 'Female', 6000) Insert Into Employees Values (7, 'Ben', 'Male', 7000) Insert Into Employees Values (8, 'Jodi', 'Female', 8000) Insert Into Employees Values (9, 'Tom', 'Male', 9000) Insert Into Employees Values (10, 'Ron', 'Male', 9500) Go Lead and Lag functions example WITHOUT partitions : This example Leads 2 rows and Lags 1 row from the current row. When you are on the first row, LEAD(Salary, 2, -1) allows you to move forward 2 rows and retrieve the salary from the 3rd row. When you are on the first row, LAG(Salary, 1, -1) allows us to move backward 1 row. Since there no rows beyond row 1, Lag function in this case returns the default value -1. When you are on the last row, LEAD(Salary, 2, -1) allows you to move forward 2 rows. Since there no rows beyond the last row 1, Lead function in this case returns the default value -1. When you are on the last row, LAG(Salary, 1, -1) allows us to move backward 1 row and retrieve the salary from the previous row. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (ORDER BY Salary) AS Lag_1 FROM Employees Lead and Lag functions example WITH partitions : Notice that in this example, Lead and Lag functions return default value if the number of rows to lead or lag goes beyond first row or last row in the partition. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lag_1 FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server_5.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 45410 kudvenkat
Explore FileTables, Full-Text Search and Semantic Search Across Unstructured Data in SQL Server 2012
Michael Rys, Principal Program Manager, Microsoft,
Views: 5625 sqlserver
SAP HANA: Using SQL to access Text Mining Functions SPS 10
Learn more about Text Mining with this informative video about SAP HANA! Visit us at http://www.blueoceansys.com.sg for more information on SAP Business One and SAP HANA! SAP Business One provides small to medium sized enterprises (SMEs) the opportunity to grow their company, reduce costs and improve efficiencies with a comprehensive and affordable enterprise resource planning (ERP) system. SAP HANA helps you dramatically accelerate analytics, business processes, predictive analysis, and sentiment data processing -- all on a single in-memory computing platform. With SAP Business One HANA, you will be one step ahead of your competition, all in real time. If you liked this video subscribe to our YouTube channel and follow us on our other social media channels! Facebook: http://www.facebook.com/blueoceansystems Twitter: http://twitter.com/BOS_SG LinkedIn: http://www.linkedin.com/company/blue-... Pinterest: http://www.pinterest.com/blueoceansystem Credits to SAP AG.
Working with Very Large Tables Like a Pro in SQL Server 2016 Part 1
Working with Very Large Tables Like a Pro in SQL Server 2016 Part 1
Visualizing Sql Data with Orange Data Mining
Showcase of Orange (http://orange.biolab.si/orange3/) visualization widgets on data stored in a PostgreSQL (http://www.postgresql.org/) database. The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2013) under grant agreement no 318633
Views: 7583 Anže Starič
Introduction to Data Mining  (1/3)
http://www.creativecommit.com. This video gives a brief demo of the various data mining techniques. The demo mainly uses Microsoft SQL server 2008, BIDS 2008 and Excel for data mining
Views: 149936 creativecommIT
How to Load Data from Text file to SQL Server Table
In This Video you can learn How to Load Data from Text file to SQL Server Table using SSIS Package. Facebook Link: https://www.facebook.com/SASI2233/?ref=aymt_homepage_panel
Views: 995 SQL DBA
Text Mining
Views: 417 RapidMiner, Inc.
VoC Analysis through Text Mining
Join executives from Taco Bell and Megaputer Intelligence as they present a compelling case study focused on analysis of Voice of Customer data that allowed Taco Bell to improve the operation of their restaurants nationwide. For over 3 years, Taco Bell Corporation collected Voice of Customer data through multiple channels and analyzed it using Megaputer’s PolyAnalyst™, a leading data and text analytics software. Over two million individual customer comments were analyzed to provide rich insights on product, service and facility topics. The impact of overall satisfaction was measured for each topic area in order to provide focus for the operations of the restaurant. Speakers: Sergei Ananyan (CEO) Megaputer Intelligence Jon Frey (Retired Dir of Operations Intelligence) Taco Bell
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA If your manager needs the report very frequently then you need to do the same task again and again. Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager. Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel. You can read our blog to go through instructions as well as download working and code files, Click here: http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/ You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials CHECK SOME OF THE FREE COURSES WE OFFER http://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! http://www.facebook.com/yodalearning http://www.twitter.com/yodalearning
Views: 76609 Excel Yoda learning
Text Mining: Sentiment Analysis in R
This tutorial will walk you through three different types of Sentiment application to a data set. It will strip text into single words and allow you to apply a sentiment match to each word (if its available in R). We use the three sentiments; bing, nrc, & afinn. Connect to SQL Server: https://youtu.be/DwzIx7CEn0Y Create data set: https://github.com/ProfessorPitch/ProfessorPitch/blob/master/SQL/Sentiment.sql Sentiment Script: https://github.com/ProfessorPitch/ProfessorPitch/blob/master/R/Sentiment.R
Views: 3044 ProfessorPitch
MSBI - SSAS - Data Mining - Time Series
MSBI - SSAS - Data Mining - Time Series
Views: 463 M R Dhandhukia
What Is Data Mining in SQL Server 2008/R2 Analysis Services?
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 In this video Scott will go over data mining, this is a big buzzword right now. This video is a brief overview data mining, there is a chapter later in the course that will go into data mining more in depth. Highlights from this video: - Data mining and MDBs -* What is data mining? - Finding patterns - Manual data analysis - Find "known unknowns" - Key influencers and much more...
Views: 4900 LearnItFirst.com
Data Cleansing With SQL And R - Kevin Feasel
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set. NDC Conferences https://ndcsydney.com https://ndcconferences.com
Views: 916 NDC Conferences
Using SQL Server Data Tools SSDT
Demos showing how to use SSDT
Views: 100958 Lynn Langit
Data Mining with SQL Server 2012 (Part I)
This is a part of SQL Server Dataming videos, this the part I. Introduction to the concepts.
Views: 13847 Rodrigo Ramos Dornel
Data Mining - Decision Tree
Use a view to make predictions about bike purchases.
Views: 10843 Mike
How to quickly generate connection string using Excel for SQL Server or Analysis Services
In this video you will learn how to create connection string for SQL Server or Analysis services in Excel and then you can use in Applications or such as Microsoft Dynamics to make connection to Analysis services. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 14515 TechBrothersIT
Tutorial de Text Mining
Views: 51 Linc ufpa
Week 7: Text Mining Conceptual Overview of Techniques
Carolyn Rose discusses text mining conceptual overview of techniques for week 7 of DALMOOC.
MSBI - SSAS - Data Mining - Naive Bayes
MSBI - SSAS - Data Mining - Naive Bayes
Views: 144 M R Dhandhukia
Data Mining Practical
using sql server - 2012
Views: 753 Sandip Upadhyay
SQL Server 2012 Database Engine Tuning Advisor step by step [HD]
Description: This video is about SQL Server 2012 Database Engine Tuning Advisor step by step [HD]. You can refer complete Text Tutorial on my website: www.SQLServerLog.com You can join me on social networks: Facebook: http://www.facebook.com/SQLServerLog Linkedin: http://in.linkedin.com/in/SQLServerLog Google+: http://www.google.com/+SQLServerLogs Twitter: http://www.twitter.com/SQLServerLog
Views: 14825 SQLServer Log
Learn Microsoft SQL for Data Analysis
Learning SQL is one of the greatest career decisions you could make. This may be a bold statement, but it also means that once you know SQL, you do not have to rely on other for information. Once you can write SQL queries, there are literally no questions you cannot ask to your data. To learn SQL - you have 3 options: a) Attend a local workshop - take a day off and gulp everything the instructor talks. or b) Watch YouTube videos - Which is unstructured with no learning path or c) Ask your busy friend to explain you all I would like you to introduce to the fourth option - Online Video Course. The effectiveness of Classroom workshop and flexibility to watch it anytime/anywhere. Click here to learn more about the course: http://courses.yodalearning.com/p/ms-sql-tutorial
Views: 1671 Excel Yoda learning
Data Mining with ScreenScraper - Semalt
Visit us - https://semalt.com/?ref=y #mining, #with, #data, #upupup_with, #mining_social, #data_and, #gtamovieshort_with, #piechart_data, #with_hayden, #sorteiotirolplus_data, #data_in, #oscars_with, #clash_with, #data_transfer screenscraper data mining with python screenscraper flight screenscraper screenscraper com www screenscraper c# screenscraper screenscraper flights ga screenscraper screenscraper software holiday screenscraper a screenscraper screenscraper sdk php screenscraper screenscraper car screenscraper for data mining data mining data mining java screenscraper asp.net screenscraper screenscraper studio c screenscraper big data with data mining data mining with unstructured data data mining with big data screenscraper holidays screenscraper zip data mining data mining data mining mining data data data mining mining data mining with sas data mining with sql data mining with ruby implementing data mining with r with data mining data mining with exaple data mining with clustering issues with data mining data mining with log data mining with optimization data mining with rattle data mining with spss data mining with examples data mining with r data mining with excel data mining with facebook problem with data mining data mining with weka data mining with hadoop data mining with oracle visualization with data mining data mining with access data mining with python data mining with xbrl problems with data mining data mining with mysql data mining with php data mining with rapidminer data mining with example data mining with java data mining with perl data mining with microsoft data mining with matlab data mining with ppt companies with data mining data mining with clementine healthcare with data mining ga screenscraper zip screenscraper studio serial screenscraper studio keygen screenscraper car hire screenscraper studio review data mining visual data mining data mining download data mining data mining with big data documentation wu data mining with big data data mining with r tutorial data data mining with big data modules data mining problems with data sets data mining with big data pdf data mining with big data projections data mining with big data doc data mining with big data project data mining with big data slideshare data mining challenges with big data data mining with big data abstract data mining with big data pdf995 data mining examples with weka data data mining with big data ieee data mining with big data paper data mining with big data ppt data mining with big data projects data mining with big data wikipedia data mining with big data ppts data mining with big data pptx data mining with big data wiki data mining with big data abstractions data mining data www screenscraper com screenscraper studio crack screenscraper studio download data data mining data mining data-mining mining data mining/data data - mining ubiquitous mining with interactive data mining agents data mining with rapid miner text mining launch screenscraper studio car hire screenscraper screenscraper studio key data mining twitter with r data mining with r download data mining with r ppt data mining applications with r data mining projects with abstract data mining with python tutorialspoint data mining with weka moochie consumer concerns with data mining data mining with matrix decompositions data mining with microsoft sql intrusion detection with data mining data mining with confidence spss learning data mining with r predictive analytics with data mining data mining with crystal reports data mining with r pdf data mining with sql 2005 data mining with sql server data mining with weka moocher mining data with complex structures data mining techniques with ppt data mining with r downloader data mining with rapidminer pdf data mining with weka moochies data mining with weka ppt facebook data mining with python data mining concepts with examples pdf data mining with r data mining tasks with examples data mining with association rules data mining with excel 2007 data mining with r ebook data mining with r kumaran data mining with weka mooc text mining with weka data data mining algorithms with examples data mining with apache pig data mining with criminal intent make money with data mining data mining with decision tree data mining with weka mooching data mining with weka pptp data mining with weka tutorial data mining approach with network data mining examples with wekay data mining with python tutorials
Views: 3 Uju Chakma
Вебинар "Data Mining и Text Mining: примеры решения реальных задач"
Огромное количество информации представлено в неструктурированном виде, и научиться ее использовать, значит повысить эффективность работы с клиентами, увеличить продажи, быстро реагировать на жалобы, уметь оценивать результаты маркетинговых кампаний.В вебинар по Data Mining и Text Mining вам откроют дополнительные возможности для роста и расширения бизнеса. В ходе Вебинара по Data Mining и Text Mining рассмотрены возможности продуктов STATISTICA Data Miner, STATISTICA Text Miner, которые используя технологию располагают широким инструментарием для автоматического извлечения знаний из больших объемов информации. После чего в вебинаре по Data Mining и Text Mining основное внимание уделено разбору актуальных кейсов: анализу текстовой информации из веб-страниц, построению скоринговых моделей и др. Обращаем внимание, что на вебинаре по Data Mining и Text Mining дается только общий обзор методов и решений - подробная информация доступна на специализированных курсах по Data mining. http://www.statsoft.ru/products/STATISTICA_Data_Miner/ http://www.youtube.com/channel/UCmskG7TLLnSNsnwRg_lfzSA
Views: 2300 StatSoftRussia
Solution - Twitter Sentiment Analytics
This vlog presents a solution for sentiment analytics from Twitter data. Using a #Tag as an input, the R code get the tweets using tweetR package. The data upon cleaning is scored for polarity and sentiment. Post scoring this feeds into a data mart which inturn is transformed into a tabular cube. this tabular cube using a live connections forms the back bone of a self served and interactive Power BI dashboard.
Views: 1227 Keshav Singh
David Itzhak:  Practical SQL 2014 Data Mining and introduction to R
Microsoft have acquired Revolution Analytics in order to help customers to find their "Big Data" value. Revolution Analytics is the leading commercial provider of software and services for R, the world’s most widely used programming language for statistical computing and predictive analytics. R will be integrated to SQL 2016 BI. I will give introduction to R and the advantages it gives to Microsoft Data Mining. • An introduction to data mining • SQL Server Data Tools (SSDT) Installations • Demo : Creating a data mining solution with Microsoft association rules • DEMO : Decision Trees example- In short • Prediction with MDX queries , No need to know the syntax . • Identifying Data Patterns – Predictive Models in SSAS
Import Data and Analyze with Python
Python programming language allows sophisticated data analysis and visualization. This tutorial is a basic step-by-step introduction on how to import a text file (CSV), perform simple data analysis, export the results as a text file, and generate a trend. See https://youtu.be/pQv6zMlYJ0A for updated video for Python 3.
Views: 187667 APMonitor.com
Mining Structured and Unstructured Data
Oracle Advanced Analytics (OAA) Database Option leverages Oracle Text, a free feature of the Oracle Database, to pre-process (tokenize) unstructured data for ingestion by the OAA data mining algorithms. By moving, parallelized implementations of machine learning algorithms inside the Oracle Database, data movement is eliminated and we can leverage other strengths of the Database such as Oracle Text (not to mention security, scalability, auditing, encryption, back up, high availability, geospatial data, etc.. This YouTube video presents an overview of the capabilities for combing and data mining structured and unstructured data, includes several brief demonstrations and instructions on how to get started--either on premise or on the Oracle Cloud.
Views: 2165 Charlie Berger
Applying Data Mining Models with  SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) can be used to apply Data Mining predictions. This tutorial demonstrates how to use the SSIS "Data Mining Query" to predictive the risk of having a vehicle using profile information stored in a SQL Server table. I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 7336 Steve Fox
Store data from PowerApps in sql, approve it in flow and use it in Power bI
In today's video we will create a PowerApp that will store stopwords in a SQL table on an on-prem server. The PowerApp will log the user of the app and a timestamp. After the stopword is sent to sql, a flow will be started to approve the new word. The data will then be imported in Power BI where the words will be excluded from the Word Cloud for test analysis. A 360 solution for text analytics! Download pbix file: https://gofile.me/2kEOD/jcs4nM0Pu Frequency count video: https://www.youtube.com/watch?v=YOmL57g3RMg SQL statement with key and autogenerate id: CREATE TABLE [dbo].[Stopwords]( [Id] [int] IDENTITY(1,1) NOT NULL, [Stopword] [nvarchar](150) NULL, [Timestamp] [nvarchar](17) NULL, [Created by] [nvarchar](150) NULL, CONSTRAINT [PK_StopwordsId] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO _____________________________________________ Giacomo blog: https://baizini-it.com/blog/index.php/2017/08/29/powerapps-user-function-cache-current-user-onstart/ Want to know more about PowerApps? Follow: @ArtsyPowerApper and @dchristian19 Want to know more about Flow? Follow: @PNWAdventureGuy Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP
Views: 7454 Curbal
SQL Server 2017: Advanced Analytics with Python
In this session you will learn how SQL Server 2017 takes in-database analytics to the next level with support for both Python and R; delivering unparalleled scalability and speed with new deep learning algorithms built in. Download SQL Server 2017: https://aka.ms/sqlserver17linuxyt
Views: 12093 Microsoft Cloud
Import Data and Analyze with MATLAB
Data are frequently available in text file format. This tutorial reviews how to import data, create trends and custom calculations, and then export the data in text file format from MATLAB. Source code is available from http://apmonitor.com/che263/uploads/Main/matlab_data_analysis.zip
Views: 333485 APMonitor.com
SiilatsFinancePart2 Stock Data into Excel.mp4
Financial Data Mining, Part 1 -- Portfolio Management in Microsoft SQL, Data mining with Excel Keith Siilats, 2/4/2012 CS246 Mining of Massive Datasets 1. Download Microsoft VHD for Mac/Windows/Unix http://www.microsoft.com/download/en/details.aspx?id=26113 2. Download VirtualBox and configure it for HyperV http://dynamicsnavax.blogspot.com/2011/04/how-to-run-ax2012-hyperv-on-virtualbox.html 3. Start your VHD and log in with Username Administrator Password [email protected] 4. Install Guest additions from VirtualBox Menu 5. Install shared folders 6. When the 10 day trial period finishes you can rearm up to 4 times a. Click Start, and then click Command Prompt. b. To reset the activation period, type slmgr.vbs --rearm, and then press ENTER. 7. Install Office http://technet.microsoft.com/en-us/evalcenter/ee390818 8. Get some stock data. Key is to get both sector and market cap info, sp500 is the largest 500 companies a. http://www.stockmarketsreview.com/companies_sp500/ b. http://www.cboe.com/products/snp500.aspx 9. Sign up with www.tdameritrade.com It will take you 3 days to sign up and you will get $500. You will see in the video how to export sector data from tdameritrade, it's easier than using the links above. 10. Get an excel macro to download latest prices. You need excel to clean up all the junk prices. Going through text files is no fun. Hoping that machine learning algorithms know how to deal with rubbish data is optimistic. http://code.google.com/p/finance-data-to-excel/ 11. Install Analysis Server samples http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases See how Microsoft does basket analysis, recommendations and all the other algorithms we have covered in class (hint, it's a lot of point and click and very little code). 12. Watch the video on how to create a VBA script to generate data and export it to SQL server (this is the Map step). In practice you will have multiple pricing servers running complex derivative pricing monte carlos and clustered sql server over several machines with hot backup. If you would like to build a machine like this instructions are http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp Microsoft Analysis server will work with any SQL source including Oracle. 13. In class we will create a custom portfolio management cube. This is the Reduce step, but its kind of a universal reduce. Once you have the cube you connect to it from Excel Pivot Table and can create any Reduce real time. Tutorial on PivotTables http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data 14. Here is a tutorial connecting excel to sql server http://newtech.about.com/od/tutorials/ss/How-To-Configure-Excel-2010-Pivot-Table-For-Business-Intelligence.htm 15. Here is a tutorial how to connect Excel to the Analysis Server http://blogs.office.com/b/microsoft-excel/archive/2008/08/28/using-excel-excel-services-with-sql-server-analysis-services-2008.aspx 16. In the second part I will show you how to create cubes on tick data (trades and quotes) and do high frequency trading.
Views: 1110 siilats
text mining and olap
Views: 221 rajan10000
Power BI direct connect to SQL database (7-3)
This video is part of the Analyzing and Visualizing Data with Power BI course available on EdX. To sign up for the course, visit: http://aka.ms/pbicourse. To read more: Power BI service https://aka.ms/pbis_gs Power BI Desktop https://aka.ms/pbid_gs Power BI basic concepts tutorial: https://aka.ms/power-bi-tutorial To submit questions and comments about Power BI, please visit community.powerbi.com.
Views: 35035 Microsoft Power BI
Setting up Full text index on database table
In this video I will show you how to setup up full text index on database tables..
Views: 1714 Adlai King
Excel at Data Mining - Your First Predictions
In this video, Billy Decker of StatSlice Systems shows you how to start data mining in 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a set of predictions for new customers using a Logistic Regression models based upon old customers. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 20663 StatSlice Systems
SQL Server Data Compression
Have you heard of the data compression feature in Enterprise Editions of SQL Server 2008 and later? It promises great savings on storage space. But did you know it can also improve I/O performance and enhance SQL Server memory? It also has costs too, in particular, it costs additional CPU to compress data on the fly. But how much CPU is spent on data compression overhead? Is it too much to be worth your time? Or is it an acceptable cost for the big gains in storage space, I/O performance, and memory improvements? To find out all about this cool technology, join Kevin Kline (@kekline) and Melissa Connors (@melikanokaoi) for this case study webinar. They’ll show how data compression works, how to choose the tables and indexes to compress, and the positive and negative performance impact of implementing data compression. Attend this webinar to learn the important ways that data compression affects workloads.
Views: 1928 SentryOne
Text Mining using Machine Learning (Lecture 12: Business Data Mining 2-2017)
เรื่อง Text Mining using Machine Learning ในรายวิชาการทำเหมืองข้อมูลเชิงธุรกิจ (Business Data Mining) ภาควิชาการจัดการเทคโนโลยีสารสนเทศ คณะเทคโนโลยีสารสนเทศ มหาวิทยาลัยเทคโนโลยีพระจอมเกล้าพระนครเหนือ
Views: 224 Phayung Meesad