SQL Server Analysis Services

RSS

Data mining, online analytical processing (OLAP), security, XML, and more.

Taking SQL Server Analysis Services Data Mining Further with Predixion Insight

  • Jul 23, 2014
    Education

    Session 1: Power BI Platform: Technical Overview  

    Running Time: 64 minutes | In this session, Jen will introduce the Power BI Platform components from a BI professional perspective. She will cover key differences from the prior Power BI release, various BI delivery use cases, and deployment models. Best practices and recommendations also will be shared....More
  • Jul 23, 2014
    Education

    Session 2: Authoring Power BI Content  

    Running Time: 61 minutes | In this session, we will walk through the full BI development lifecycle. We will talk about loading and preparing data with Power Designer from enterprise data sources. Then we will develop reports and dashboards using Power Designer and the new Power BI site....More
  • Jul 23, 2014
    Education

    Session 3: Power BI Development  

    Running Time: 63 minutes | In the final session, Jen will walk you through the Power BI REST APIs to create custom datasets, reports, and push data directly from SQL Server and a variety of applications into real-time dashboards. We will review the available GitHub code samples, introduce the APIARY web code snippets and show how a simple real-time dashboard can be created....More
  • Dec 13, 2013
    blog

    Taking SQL Server Analysis Services Data Mining Further with Predixion Insight

    Predixion is a Microsoft partner solution that supplements the base SSAS Data Mining offering with many features that have long been on my wish list. The Predixion Insight solution also has exceptional support and far greater capabilities than the base Microsoft solution....More
  • business intelligence word cloud
    Oct 21, 2013
    Article

    Building Real-World Microsoft BI Dashboards Today 10

    I know all the Microsoft buzz is about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real world requirements today....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Sep 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×