http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/tags/Business+Intelligence/business intelligencehttp://channel9.msdn.com/tags/Business+Intelligence/en-usFri, 18 Sep 2009 21:01:28 GMTFri, 18 Sep 2009 21:01:28 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<img src="http://ecn.channel9.msdn.com/o9/ch9/6/3/8/2/9/4/TKC021MicrosoftBI_85_ch9.png" border="0" />BI, or "Business Intelligence" allows businesses to make better use of their data, and resources in order to make better decisions related to how to grow and improve their business. For the PDC09 in Los Angeles, <a href="http://microsoftpdc.com/Speakers/Andrew-Brust">Andrew Brust </a>and <a href="http://microsoftpdc.com/Speakers/Don-Demsak">Don Demsak</a> will be presenting a special day-long workshop on November 16th which will show developers how to easily leverage Microsoft tools and technologies to solve the BI needs of their companies.<br /> <br /> I invited Andrew and Don to discuss their workshop with me, but since they live on the East Coast I relied on Peter Laudati, special correspondent for The Knowledge Chamber, to conduct the interview for me.<br /> <br /> You can find more information about the workshop that Andrew and Don will be doing here:<br /> <br /> <strong> <ul> <li><strong>PDC09: <a href="http://microsoftpdc.com/Sessions/Developing-Microsoft-BI-Applications-The-How-and-The-Why"><strong>Developing Microsoft BI Applications - The How and The Why</strong></a></strong> </li> </ul> </strong>And information about Microsoft BI technologies in general here:<br /> <ul> <li><a href="http://www.microsoft.com/bi/"><strong>Microsoft Business Intelligence</strong></a> </li> </ul><img src="http://channel9.msdn.com/492836/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/shows/The+Knowledge+Chamber/PDC09-Workshop-Developing-Microsoft-BI-Applications-The-How-and-The-Why/http://channel9.msdn.com/shows/The+Knowledge+Chamber/PDC09-Workshop-Developing-Microsoft-BI-Applications-The-How-and-The-Why/Sat, 19 Sep 2009 01:35:00 GMThttp://ecn.channel9.msdn.com/o9/ch9/6/3/8/2/9/4/TKC021MicrosoftBI_2MB_ch9.wmv27014http://channel9.msdn.com/492836/WebViewBug.aspx?EVT=0BI, or "Business Intelligence" allows businesses to make better use of their data, and resources in order to make better decisions related to how to grow and improve their business. For the PDC09 in Los Angeles, Andrew Brust and Don Demsak will be presenting a special day-long workshop on November 16th which will show developers how to easily leverage Microsoft tools and technologies to solve the BI needs of their companies.Robert Hess0http://channel9.msdn.com/shows/The+Knowledge+Chamber/PDC09-Workshop-Developing-Microsoft-BI-Applications-The-How-and-The-Why/RSS/http://channel9.msdn.com/492836/Trackback.aspxBusiness IntelligencePDC09<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/1/4/0/9/2/4/SQLInterview4updated_small_ch9.jpg" border="0" />マイクロソフト デベロッパーエバンジェリストの小高です。<br /> SQL Server 2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回はSharePoint ServerにおけるSQL Server 2008 の対応と開発について、マイクロソフトのデベロッパーエバンジェリストであり、SharePoint Server開発を中心に担当している松崎に話を聞きました。<br /> 9分07秒のビデオになります。<img src="http://channel9.msdn.com/429041/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/SQLInterview4Japanese/http://channel9.msdn.com/posts/ZachSkylesOwens/SQLInterview4Japanese/Fri, 26 Dec 2008 18:06:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/1/4/0/9/2/4/SQLInterview4updated_2MB_ch9.wmv7754http://channel9.msdn.com/429041/WebViewBug.aspx?EVT=0マイクロソフト デベロッパーエバンジェリストの小高です。 SQL Server 2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回はSharePoint ServerにおけるSQL Server 2008 の対応と開発について、マイクロソフトのデベロッパーエバンジェリストであり、SharePoint Server開発を中心に担当している松崎に話を聞きました。 9分07秒のビデオになります。Zach Skyles Owens1http://channel9.msdn.com/posts/ZachSkylesOwens/SQLInterview4Japanese/RSS/http://channel9.msdn.com/429041/Trackback.aspxBusiness IntelligenceGeneralSQL Behind the Scenes – JapaneseSQL Server 2008<img src="http://channel9.msdn.com/Link/d7201378-94e3-47fe-9509-c58d4250ecca/" border="0" />更多樣化及進階的圖表功能，讓使用者可快速洞察複雜的資料，此外，在示範會顯示簡單的步驟來建立關鍵業績指標。<img src="http://channel9.msdn.com/430111/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/ReportingServicesVisualization2/http://channel9.msdn.com/posts/ZachSkylesOwens/ReportingServicesVisualization2/Sun, 28 Sep 2008 18:47:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/ReportingServicesVisualization2/2462http://channel9.msdn.com/430111/WebViewBug.aspx?EVT=0更多樣化及進階的圖表功能，讓使用者可快速洞察複雜的資料，此外，在示範會顯示簡單的步驟來建立關鍵業績指標。Zach Skyles Owens1http://channel9.msdn.com/posts/ZachSkylesOwens/ReportingServicesVisualization2/RSS/http://channel9.msdn.com/430111/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://channel9.msdn.com/Link/8e7d206c-b041-4051-b3d3-1d698d82836b/" border="0" />有了異動數據記錄，任何的變更都可被記錄，並放置在異動資料表中。它能捕捉完整的內容並維護跨資料 表的一致性，甚至於結構描述異動後仍可執行。這是第一部分的示範，解說如何使用此功能去記錄數據的變化。<img src="http://channel9.msdn.com/430108/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/ChangeDataCapture4/http://channel9.msdn.com/posts/ZachSkylesOwens/ChangeDataCapture4/Sun, 28 Sep 2008 18:46:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/ChangeDataCapture4/1909http://channel9.msdn.com/430108/WebViewBug.aspx?EVT=0有了異動數據記錄，任何的變更都可被記錄，並放置在異動資料表中。它能捕捉完整的內容並維護跨資料 表的一致性，甚至於結構描述異動後仍可執行。這是第一部分的示範，解說如何使用此功能去記錄數據的變化。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/ChangeDataCapture4/RSS/http://channel9.msdn.com/430108/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/0/8/5/9/2/4/SQLServerAnalysisServices_small_ch9.jpg" border="0" />В докладе дается краткое введение в OLAP и рассказывается об основных новшествах в текущей версии SQL Server.<img src="http://channel9.msdn.com/429580/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008AnalysisServices/http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008AnalysisServices/Sat, 27 Sep 2008 11:27:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/0/8/5/9/2/4/SQLServerAnalysisServices_2MB_ch9.wmv3182http://channel9.msdn.com/429580/WebViewBug.aspx?EVT=0В докладе дается краткое введение в OLAP и рассказывается об основных новшествах в текущей версии SQL Server.Zach Skyles Owens2http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008AnalysisServices/RSS/http://channel9.msdn.com/429580/Trackback.aspxBusiness Intelligenceru-RUSQL Behind the Scenes – RussianSQL Server 2008<img src="http://channel9.msdn.com/Link/4c2a92f3-8f44-406a-91f2-a04ef6b10b52/" border="0" />Доклад носит вводный характер, рассказывается о Data Mining в целом, об алгоритмах в составе SQL Server 2005 и практических сценариях их применения, а также о новшествах в области Data Mining в SQL Server 2008.<img src="http://channel9.msdn.com/429581/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining--SQL-Server-2008/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining--SQL-Server-2008/Sat, 27 Sep 2008 07:29:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining--SQL-Server-2008/1966http://channel9.msdn.com/429581/WebViewBug.aspx?EVT=0Доклад носит вводный характер, рассказывается о Data Mining в целом, об алгоритмах в составе SQL Server 2005 и практических сценариях их применения, а также о новшествах в области Data Mining в SQL Server 2008.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining--SQL-Server-2008/RSS/http://channel9.msdn.com/429581/Trackback.aspxBusiness Intelligenceru-RUSQL Behind the Scenes – RussianSQL Server 2008<img src="http://channel9.msdn.com/Link/3cd06e62-4565-43b6-973f-48b96611f70d/" border="0" />我们将在这段视频中为大家演示SQL Server 2008报表服务在图表方面的一些改进，例如在柱状图中的刻度跳跃以及辅助刻度，我们还会演示在一张图表中如何混合不同的图表类型。<img src="http://channel9.msdn.com/429687/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/18ChartEnhancements/http://channel9.msdn.com/posts/ZachSkylesOwens/18ChartEnhancements/Sat, 27 Sep 2008 04:21:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/18ChartEnhancements/1784http://channel9.msdn.com/429687/WebViewBug.aspx?EVT=0我们将在这段视频中为大家演示SQL Server 2008报表服务在图表方面的一些改进，例如在柱状图中的刻度跳跃以及辅助刻度，我们还会演示在一张图表中如何混合不同的图表类型。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/18ChartEnhancements/RSS/http://channel9.msdn.com/429687/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese SimplifiedSQL Server 2008<img src="http://channel9.msdn.com/Link/04f71ac7-9111-4c48-b791-3a7ba004838e/" border="0" />我们将在这段视频中为大家介绍SQL Server 2008集成服务中一项新的控制流任务——数据探查任务，以及这项任务是如何帮助我们了解数据质量的。<img src="http://channel9.msdn.com/429686/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/17DataProfileTask/http://channel9.msdn.com/posts/ZachSkylesOwens/17DataProfileTask/Sat, 27 Sep 2008 04:20:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/17DataProfileTask/1660http://channel9.msdn.com/429686/WebViewBug.aspx?EVT=0我们将在这段视频中为大家介绍SQL Server 2008集成服务中一项新的控制流任务——数据探查任务，以及这项任务是如何帮助我们了解数据质量的。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/17DataProfileTask/RSS/http://channel9.msdn.com/429686/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese SimplifiedSQL Server 2008<img src="http://channel9.msdn.com/Link/8fc98f15-d5df-4af5-80b0-479d02f41d01/" border="0" />Una panoramica sulle novità legate all’introduzione della cache per i componenti di lookup negli Integration Services di SQL Server 2008.<img src="http://channel9.msdn.com/429537/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Ottimizzazioni-sui-lookup-in-SQL-Server-2008-Integration-Services/http://channel9.msdn.com/posts/ZachSkylesOwens/Ottimizzazioni-sui-lookup-in-SQL-Server-2008-Integration-Services/Thu, 25 Sep 2008 22:31:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Ottimizzazioni-sui-lookup-in-SQL-Server-2008-Integration-Services/2087http://channel9.msdn.com/429537/WebViewBug.aspx?EVT=0Una panoramica sulle novità legate all’introduzione della cache per i componenti di lookup negli Integration Services di SQL Server 2008.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Ottimizzazioni-sui-lookup-in-SQL-Server-2008-Integration-Services/RSS/http://channel9.msdn.com/429537/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – ItalianSQL Server 2008<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/7/8/3/7/2/4/90MandarinHanyingFeng_small_ch9.jpg" border="0" /><span id="UniqueID1221260920709">冯涵颖讲述测试组长的工作，中国团队和微软总部团队之间的合作以及一些独特的挑战。</span><img src="http://channel9.msdn.com/427387/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/90MandarinHanyingFeng/http://channel9.msdn.com/posts/ZachSkylesOwens/90MandarinHanyingFeng/Thu, 25 Sep 2008 17:30:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/7/8/3/7/2/4/90MandarinHanyingFeng_2MB_ch9.wmv3399http://channel9.msdn.com/427387/WebViewBug.aspx?EVT=0冯涵颖讲述测试组长的工作，中国团队和微软总部团队之间的合作以及一些独特的挑战。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/90MandarinHanyingFeng/RSS/http://channel9.msdn.com/427387/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/9/8/8/7/2/4/76KoreanHeaKyung_small_ch9.jpg" border="0" />이번 세션에서는 SQL Server 릴리즈 프로그램 매니저인 박해경이 마이크로소프토 SQL Server 2008 기능팩 개발활동에 대한 개요를 소개한다.<img src="http://channel9.msdn.com/427889/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/76KoreanHeaKyung/http://channel9.msdn.com/posts/ZachSkylesOwens/76KoreanHeaKyung/Thu, 25 Sep 2008 17:18:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/9/8/8/7/2/4/76KoreanHeaKyung_2MB_ch9.wmv1207http://channel9.msdn.com/427889/WebViewBug.aspx?EVT=0이번 세션에서는 SQL Server 릴리즈 프로그램 매니저인 박해경이 마이크로소프토 SQL Server 2008 기능팩 개발활동에 대한 개요를 소개한다.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/76KoreanHeaKyung/RSS/http://channel9.msdn.com/427889/Trackback.aspxBusiness IntelligenceGeneralSQL Behind the Scenes – KoreanSQL Server 2008<img src="http://channel9.msdn.com/Link/a12b5588-178f-4c11-998e-c4b5ead0cc30/" border="0" />En SQL Server 2005, se encuentra presente la realización de prediciones para series de tiempo, con el algoritmo ARTXP. En SQL Server 2008, se ha agregado ARIMA, lo que permite contar con predicciones estable y confiable tanto para el corto como para el largo plazo.<img src="http://channel9.msdn.com/429529/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Mineria-de-datos-y-series-de-tiempo--ARIMA/http://channel9.msdn.com/posts/ZachSkylesOwens/Mineria-de-datos-y-series-de-tiempo--ARIMA/Thu, 25 Sep 2008 12:57:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Mineria-de-datos-y-series-de-tiempo--ARIMA/2013http://channel9.msdn.com/429529/WebViewBug.aspx?EVT=0En SQL Server 2005, se encuentra presente la realización de prediciones para series de tiempo, con el algoritmo ARTXP. En SQL Server 2008, se ha agregado ARIMA, lo que permite contar con predicciones estable y confiable tanto para el corto como para el largo plazo.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Mineria-de-datos-y-series-de-tiempo--ARIMA/RSS/http://channel9.msdn.com/429529/Trackback.aspxBusiness Intelligencees-esSQL Behind the Scenes – SpanishSQL Server 2008<img src="http://channel9.msdn.com/Link/5f53164c-0297-4485-95b8-22ae53db4063/" border="0" />Aprende a desarrollar soluciones de análisis de datos de una forma rápida y dinámica con el nuevo Cube Designer.<img src="http://channel9.msdn.com/429527/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Diseo-de-cubos-con-Analysis-Services-por-Juan-Alvarado/http://channel9.msdn.com/posts/ZachSkylesOwens/Diseo-de-cubos-con-Analysis-Services-por-Juan-Alvarado/Thu, 25 Sep 2008 12:55:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Diseo-de-cubos-con-Analysis-Services-por-Juan-Alvarado/1786http://channel9.msdn.com/429527/WebViewBug.aspx?EVT=0Aprende a desarrollar soluciones de análisis de datos de una forma rápida y dinámica con el nuevo Cube Designer.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Diseo-de-cubos-con-Analysis-Services-por-Juan-Alvarado/RSS/http://channel9.msdn.com/429527/Trackback.aspxBusiness Intelligencees-esSQL Behind the Scenes – SpanishSQL Server 2008<img src="http://channel9.msdn.com/Link/76177659-c2e2-469c-b4c1-86fd78b59d22/" border="0" />Weise sollte eine Überprüfung ständig stattfinden, bzw. im ETL vorgenommen werden. Allerdings kann auch eine Ac-Hoc Prüfung notwendig sein. Die Funktion „Explore Data“ im Data Source View eine BI Projektes im Visual Studio bietet einige Möglichkeiten zur Analyse an. In diesem Screencast erfahren sie die Data Explore Funktion nutzbringend einsetzen.<img src="http://channel9.msdn.com/429521/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-im-Data-Source-View/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-im-Data-Source-View/Thu, 25 Sep 2008 12:53:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-im-Data-Source-View/1171http://channel9.msdn.com/429521/WebViewBug.aspx?EVT=0Weise sollte eine Überprüfung ständig stattfinden, bzw. im ETL vorgenommen werden. Allerdings kann auch eine Ac-Hoc Prüfung notwendig sein. Die Funktion „Explore Data“ im Data Source View eine BI Projektes im Visual Studio bietet einige Möglichkeiten zur Analyse an. In diesem Screencast erfahren sie&#8230;Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-im-Data-Source-View/RSS/http://channel9.msdn.com/429521/Trackback.aspxBusiness Intelligencede-deSQL Behind the Scenes – GermanSQL Server 2008<img src="http://channel9.msdn.com/Link/73ce08ed-f446-4f19-89fa-af0f0cbc9691/" border="0" />Data Mining bietet weitreichende Möglichkeiten in der Anwendung. Mit SQL Server 2008 erschließen sie sich dieses Potenzial auf einfache Weise. Dieser Screencast zeigt wie sie die erstellten  Data Mining Modelle auf ihre Leistungsfähigkeit überprüfen und miteinander vergleichen.<img src="http://channel9.msdn.com/429519/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Validieren-von-Data-Mining-Modellen/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Validieren-von-Data-Mining-Modellen/Thu, 25 Sep 2008 12:52:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Validieren-von-Data-Mining-Modellen/1098http://channel9.msdn.com/429519/WebViewBug.aspx?EVT=0Data Mining bietet weitreichende Möglichkeiten in der Anwendung. Mit SQL Server 2008 erschließen sie sich dieses Potenzial auf einfache Weise. Dieser Screencast zeigt wie sie die erstellten  Data Mining Modelle auf ihre Leistungsfähigkeit überprüfen und miteinander vergleichen.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Validieren-von-Data-Mining-Modellen/RSS/http://channel9.msdn.com/429519/Trackback.aspxBusiness Intelligencede-deSQL Behind the Scenes – GermanSQL Server 2008<img src="http://channel9.msdn.com/Link/4a72a925-4eda-4dcd-bf66-403ec08b72b2/" border="0" />A volte anche un semplice strumento per l’analisi della qualità dei dati da utilizzare per l’alimentazione di un data warehouse può servire a prevenire una vasta serie di problemi e di costi in uno stadio successivo. Il Task di Data Profiling in Integration Services di SQL Server 2008 può aiutare proprio a raggiungere questo obiettivo.<img src="http://channel9.msdn.com/429541/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling/Thu, 25 Sep 2008 12:51:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling/1772http://channel9.msdn.com/429541/WebViewBug.aspx?EVT=0A volte anche un semplice strumento per l’analisi della qualità dei dati da utilizzare per l’alimentazione di un data warehouse può servire a prevenire una vasta serie di problemi e di costi in uno stadio successivo. Il Task di Data Profiling in Integration Services di SQL Server 2008 può aiutare&#8230;Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling/RSS/http://channel9.msdn.com/429541/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – ItalianSQL Server 2008<img src="http://channel9.msdn.com/Link/eca54e41-b14b-417b-8a69-d446364808ba/" border="0" />Data Mining bietet weitreichende Möglichkeiten in der Anwendung. Mit SQL Server 2008 erschließen sie sich dieses Potenzial auf einfache Weise. Dieser Screencast zeigt wie sie Data Mining Modelle erstellen und mit Daten aus einer Datenquelle trainieren. Es wird gezeigt wie sie die Datenquelle integrieren, filtern, in Test- und Trainingsdaten aufteilen. Außerdem erfahren sie wie die Daten zum Trainieren vorbereitet werden und wie das Deployment an einen Analysis Server erfolgt.<img src="http://channel9.msdn.com/429517/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Erstellen-von-Data-Mining-Modellen/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Erstellen-von-Data-Mining-Modellen/Thu, 25 Sep 2008 12:51:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Erstellen-von-Data-Mining-Modellen/1210http://channel9.msdn.com/429517/WebViewBug.aspx?EVT=0Data Mining bietet weitreichende Möglichkeiten in der Anwendung. Mit SQL Server 2008 erschließen sie sich dieses Potenzial auf einfache Weise. Dieser Screencast zeigt wie sie Data Mining Modelle erstellen und mit Daten aus einer Datenquelle trainieren. Es wird gezeigt wie sie die Datenquelle&#8230;Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Mining-Erstellen-von-Data-Mining-Modellen/RSS/http://channel9.msdn.com/429517/Trackback.aspxBusiness Intelligencede-deSQL Behind the Scenes – GermanSQL Server 2008<img src="http://channel9.msdn.com/Link/0e7e57c1-a842-49cf-8d2e-34ed937a031c/" border="0" />Die Datenqualität spielt beim ETL und Data Mining eine entscheidende Rolle. Deshalb ist es zielführend die Qualität der Daten zu prüfen. Idealer Weise sollte eine überprüfung ständig stattfinden, bzw. im ETL vorgenommen werden. SQL Server 2008 unterstützt diesen Vorgang durch einen neunen SSIS Task "Data Profiling". In diesem Screencast erhalten Sie eine Übersicht wie der DataProfiling Task genutzt werden kann und welche Informationen Sie dadurch erhalten.<img src="http://channel9.msdn.com/429516/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-mit-SQL-Server-Integration-Services-2008/http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-mit-SQL-Server-Integration-Services-2008/Thu, 25 Sep 2008 12:50:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-mit-SQL-Server-Integration-Services-2008/1774http://channel9.msdn.com/429516/WebViewBug.aspx?EVT=0Die Datenqualität spielt beim ETL und Data Mining eine entscheidende Rolle. Deshalb ist es zielführend die Qualität der Daten zu prüfen. Idealer Weise sollte eine überprüfung ständig stattfinden, bzw. im ETL vorgenommen werden. SQL Server 2008 unterstützt diesen Vorgang durch einen neunen SSIS Task&#8230;Zach Skyles Owens1http://channel9.msdn.com/posts/ZachSkylesOwens/Data-Profiling-mit-SQL-Server-Integration-Services-2008/RSS/http://channel9.msdn.com/429516/Trackback.aspxBusiness Intelligencede-deSQL Behind the Scenes – GermanSQL Server 2008<img src="http://mschnlnine.vo.llnwd.net/d1/ch9/9/7/5/9/2/4/IvanKosyakov20001_small_ch9.jpg" border="0" />Новые возможности SQL Server 2008 Analysis Services для построения систем интеллектуального анализа данных (data mining), включая новые возможности предективного анализа и интеграцию с Office 2007.<img src="http://channel9.msdn.com/429579/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008DataMining/http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008DataMining/Thu, 25 Sep 2008 12:39:00 GMThttp://mschnlnine.vo.llnwd.net/d1/ch9/9/7/5/9/2/4/IvanKosyakov20001_2MB_ch9.wmv1922http://channel9.msdn.com/429579/WebViewBug.aspx?EVT=0Новые возможности SQL Server 2008 Analysis Services для построения систем интеллектуального анализа данных (data mining), включая новые возможности предективного анализа и интеграцию с Office 2007.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/SQLServer2008DataMining/RSS/http://channel9.msdn.com/429579/Trackback.aspxBusiness Intelligenceru-RUSQL Behind the Scenes – RussianSQL Server 2008<img src="http://channel9.msdn.com/Link/95103f84-ad9a-45a7-aef0-d3a7cfb3a699/" border="0" />獨特的 Tablix 資料格式來製作任何結構的報表，讓企業能夠提供整個組織的相關資訊。<img src="http://channel9.msdn.com/429562/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/TablixReportBuilder2/http://channel9.msdn.com/posts/ZachSkylesOwens/TablixReportBuilder2/Thu, 25 Sep 2008 12:20:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/TablixReportBuilder2/1128http://channel9.msdn.com/429562/WebViewBug.aspx?EVT=0獨特的 Tablix 資料格式來製作任何結構的報表，讓企業能夠提供整個組織的相關資訊。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/TablixReportBuilder2/RSS/http://channel9.msdn.com/429562/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://channel9.msdn.com/Link/f13b5387-8d2c-4dbd-8ad6-6ea2d932a273/" border="0" />利用 SQL Server Reporting Services於各種關聯式和多維度企業資料來源取得內容，製作報表，同時利用微軟 Report Viewer內嵌於使用者介面中。<img src="http://channel9.msdn.com/429559/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/DotNetReportViewer/http://channel9.msdn.com/posts/ZachSkylesOwens/DotNetReportViewer/Thu, 25 Sep 2008 12:17:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/DotNetReportViewer/1592http://channel9.msdn.com/429559/WebViewBug.aspx?EVT=0利用 SQL Server Reporting Services於各種關聯式和多維度企業資料來源取得內容，製作報表，同時利用微軟 Report Viewer內嵌於使用者介面中。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/DotNetReportViewer/RSS/http://channel9.msdn.com/429559/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://channel9.msdn.com/Link/2755fc6b-b9da-4b83-9cd7-cc73954b0f23/" border="0" />資料採礦(Data Mining) 是在龐大的資料庫中找出有價值的隱藏事件，加以分析、歸納出有用的結構， 作爲企業進行決策的依據。示範中更會使用Microsoft Excel作為用戶平台編制報表。<img src="http://channel9.msdn.com/429557/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/DataMining/http://channel9.msdn.com/posts/ZachSkylesOwens/DataMining/Thu, 25 Sep 2008 12:16:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/DataMining/1261http://channel9.msdn.com/429557/WebViewBug.aspx?EVT=0資料採礦(Data Mining) 是在龐大的資料庫中找出有價值的隱藏事件，加以分析、歸納出有用的結構， 作爲企業進行決策的依據。示範中更會使用Microsoft Excel作為用戶平台編制報表。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/DataMining/RSS/http://channel9.msdn.com/429557/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://channel9.msdn.com/Link/244a3479-9686-4cc4-8ab0-d86b02c6f24a/" border="0" />通過異動數據記錄此功能，併合SQL Server Integration Services (SSIS) 這讓企業可將最新的信息整合至數據倉 庫，提升了查閱的效能來支援您最大型的資料表。<img src="http://channel9.msdn.com/429556/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/CDCSSISPart2of2/http://channel9.msdn.com/posts/ZachSkylesOwens/CDCSSISPart2of2/Thu, 25 Sep 2008 12:14:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/CDCSSISPart2of2/1395http://channel9.msdn.com/429556/WebViewBug.aspx?EVT=0通過異動數據記錄此功能，併合SQL Server Integration Services (SSIS) 這讓企業可將最新的信息整合至數據倉 庫，提升了查閱的效能來支援您最大型的資料表。Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/CDCSSISPart2of2/RSS/http://channel9.msdn.com/429556/Trackback.aspxBusiness IntelligenceSQL Behind the Scenes – Chinese TraditionalSQL Server 2008<img src="http://channel9.msdn.com/Link/8571fd2e-f225-496d-9df5-549a9685a9de/" border="0" />Trabajar en cualquier operación de integración de datos siempre supone un reto: El de que los datos cumplen con reglas d enegocio. Pero si no es así, los tiempos de desarrollo se extienden. En este screencast veremos como comprender la naturaleza de los datos antes de comenzar un esfuerzo de integración.<img src="http://channel9.msdn.com/429530/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/SSIS--Perfilamiento-de-datos/http://channel9.msdn.com/posts/ZachSkylesOwens/SSIS--Perfilamiento-de-datos/Thu, 25 Sep 2008 10:10:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/SSIS--Perfilamiento-de-datos/1604http://channel9.msdn.com/429530/WebViewBug.aspx?EVT=0Trabajar en cualquier operación de integración de datos siempre supone un reto: El de que los datos cumplen con reglas d enegocio. Pero si no es así, los tiempos de desarrollo se extienden. En este screencast veremos como comprender la naturaleza de los datos antes de comenzar un esfuerzo de integración.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/SSIS--Perfilamiento-de-datos/RSS/http://channel9.msdn.com/429530/Trackback.aspxBusiness Intelligencees-esSQL Behind the Scenes – SpanishSQL Server 2008<img src="http://channel9.msdn.com/Link/94ac6e27-d1e3-4390-8dcc-c64135ae87f0/" border="0" />Una imagen vale mas que mil palabras. Pero y si la imagen es muda? Observa en este screencast los cambios en Report Builder alrededor de las opciones de visualización, y todo lo que podrás hacer con ellas.<img src="http://channel9.msdn.com/429531/WebViewBug.aspx?EVT=0" height="1" width="1" alt="" />http://channel9.msdn.com/posts/ZachSkylesOwens/Novedades-en-Report-Builder-v2-Grficos/http://channel9.msdn.com/posts/ZachSkylesOwens/Novedades-en-Report-Builder-v2-Grficos/Thu, 25 Sep 2008 10:08:00 GMThttp://channel9.msdn.com/posts/ZachSkylesOwens/Novedades-en-Report-Builder-v2-Grficos/1488http://channel9.msdn.com/429531/WebViewBug.aspx?EVT=0Una imagen vale mas que mil palabras. Pero y si la imagen es muda? Observa en este screencast los cambios en Report Builder alrededor de las opciones de visualización, y todo lo que podrás hacer con ellas.Zach Skyles Owens0http://channel9.msdn.com/posts/ZachSkylesOwens/Novedades-en-Report-Builder-v2-Grficos/RSS/http://channel9.msdn.com/429531/Trackback.aspxBusiness Intelligencees-esSQL Behind the Scenes – SpanishSQL Server 2008