Power BI - Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog/product/power-bi/ Official News from Microsoft’s Information Platform Tue, 13 Aug 2024 14:41:18 +0000 en-US hourly 1 http://approjects.co.za/?big=en-us/sql-server/blog/wp-content/uploads/2018/08/cropped-cropped-microsoft_logo_element-150x150.png Power BI - Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog/product/power-bi/ 32 32 Microsoft Azure at Data Platform Virtual Summit 2020 http://approjects.co.za/?big=en-us/sql-server/blog/2020/11/19/microsoft-azure-at-data-platform-virtual-summit-2020/ Thu, 19 Nov 2020 17:00:48 +0000 Data Platform Virtual Summit 2020 (DPS 2020) is just a couple of weeks away. A global learning event for data professionals, DPS 2020 features a keynote from Rohan Kumar, Microsoft Corporate Vice President of Azure Data, as well as 200 breakout sessions and 30 training classes delivered by Azure Data engineering, partner organizations, and community

The post Microsoft Azure at Data Platform Virtual Summit 2020 appeared first on Microsoft SQL Server Blog.

]]>
Data Platform Virtual Summit 2020 (DPS 2020) is just a couple of weeks away. A global learning event for data professionals, DPS 2020 features a keynote from Rohan Kumar, Microsoft Corporate Vice President of Azure Data, as well as 200 breakout sessions and 30 training classes delivered by Azure Data engineering, partner organizations, and community leaders. With content delivered around-the-clock, DPS 2020 empowers Azure Data professionals worldwide with the deep technical skills they need to move ahead in their careers and digitally transform their organizations.

This year, DPS 2020 features five parallel tracks focusing on Azure Data:

  • Advanced Analytics
  • Artificial Intelligence
  • Azure Data Administration
  • Azure Data Development
  • Power BI

The virtual platform offers live Q and A, a networking lounge, a community zone, and technical round tables. Additionally, attendees will receive 12 month on-demand access to session recordings.

DPS 2020 offers an incredible opportunity to learn directly from our engineering teams, who will share the latest advances and insights on the Azure Data platform.

  • Rohan Kumar will deliver the keynote. Rohan will highlight the latest innovations across the Microsoft Azure Data platform and share customer case studies. The keynote will also feature demos from multiple Microsoft engineers, including Anitha Adusumilli, Anna Hoffman, Buck Woody, Travis Wright, and Vasiya Krishnan.
  • Microsoft Azure Data engineering teams will deliver over 35 sessions at DPS 2020. Hear the latest from the people who develop the tools you use every day, and engage in live discussions.
  • Visit the virtual expo hall where you can connect with our team across SQL Server, Azure SQL, Azure Synapse Analytics, Power BI, and more.

Register now for a week of training at Data Platform Virtual Summit and receive twelve months of on-demand access to the DPS 2020 sessions.

The post Microsoft Azure at Data Platform Virtual Summit 2020 appeared first on Microsoft SQL Server Blog.

]]>
SQL Server Management Studio 18.0 Release Candidate 1 is now available http://approjects.co.za/?big=en-us/sql-server/blog/2019/03/28/sql-server-management-studio-18-0-release-candidate-1-is-now-available/ http://approjects.co.za/?big=en-us/sql-server/blog/2019/03/28/sql-server-management-studio-18-0-release-candidate-1-is-now-available/#comments Thu, 28 Mar 2019 18:00:09 +0000 As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on what’s included, please see the Release Notes. This SQL Server Management Studio 18 RC1

The post SQL Server Management Studio 18.0 Release Candidate 1 is now available appeared first on Microsoft SQL Server Blog.

]]>
As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build.

You can download SSMS 18.0 RC1 today and for more details on what’s included, please see the Release Notes.

This SQL Server Management Studio 18 RC1 build has some important updates as seen below:

SSMS improvements:

  • Enabling XMLA endpoint connectivity to Power BI datasets: XMLA endpoints provide access to the Analysis Services engine in the Power BI Service. This allows tools such as SSMS and SQL Profiler to connect to Power BI datasets for monitoring, management, and debugging etc. For more details, please review XMLA endpoint connectivity in the Power BI blog.

SQL Server Management Objects (SMO)

  • Added cascade delete support to “Edge Constraints” in both SMO and SSMS.
  • Added support for data classification “read-write” permissions.

Audit Files

  • Updated the list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP

In addition, we also have several bug fixes in the following areas:

SSMS:

  • Fixed an issue which was preventing MFA authentication when user ids belonged to multiple tenants.
  • Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that could not found in sub-reports.
  • Fixed an issue which resulted in an “Index out of range” exception when clicking on the grid.
  • Fixed an issue where the grid result background color was being ignored. For more details, you can review Azure feedback.

Managed Instance support

  • Improved the display of Managed Instances server specific properties (hardware generation, service tier, storage used, and reserved).

Azure SQL Database

  • Fixed an issue where Service Level Objectives (SLO) were hard-coded, making it harder for SSMS to support newer SQL Azure SLOs. Now users can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size).

For a full list of changes, please see the Release Notes.

As usual, if you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 RC1 can be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.

We’d love to hear from you! Please let us know if you have any questions, comments or feature suggestions.

The post SQL Server Management Studio 18.0 Release Candidate 1 is now available appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2019/03/28/sql-server-management-studio-18-0-release-candidate-1-is-now-available/feed/ 3
Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK! http://approjects.co.za/?big=en-us/sql-server/blog/2019/02/20/join-us-at-sql-bits-2019-february-27-march-2-in-manchester-uk/ Wed, 20 Feb 2019 17:00:50 +0000 Data never rests, nor does the data platform. It keeps evolving as more organizations turn to data driven insights to stay ahead and prepare for the future. Be a part of the largest SQL Server professional gathering in Europe at SQL Bits 2019. At SQL Bits, you have the unique opportunity to meet with community

The post Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK! appeared first on Microsoft SQL Server Blog.

]]>
Data never rests, nor does the data platform. It keeps evolving as more organizations turn to data driven insights to stay ahead and prepare for the future.

Be a part of the largest SQL Server professional gathering in Europe at SQL Bits 2019. At SQL Bits, you have the unique opportunity to meet with community leaders sharing their real world experience and Microsoft product teams providing deep insights into Microsoft data solutions.

For those attending this year, we’ve put together a quick guide below on some of the Data and AI sessions you can look forward to. Can’t wait until SQL Bits? Check out the conference sessions to get a taste of what you won’t want to miss at SQL Bits 2019.

SQL Bits is also running a promotion right now to share their love for data. Save 50% when you add an extra day using the code: welovedata

Keynote

Friday, March 1

Data Never Rests

Speaker: Buck Woody and Bob Ward

In today’s world, the growth of data is ushering in an era of rapid innovation. Microsoft’s goal is to bring the best hybrid data platform to help data professionals in building a data infrastructure that supports their organization now and into the future.  Join Buck Woody, Bob Ward, Anna Thomas, Alain Dormehl, and Adam Saxton as they demonstrate the latest advances from Microsoft across SQL Server, Azure Data Services, Business Analytics, and AI.

Pre-conference activities (training days)

Wednesday, February 27

Modernize your database with SQL Server 2019

Speaker: Bob Ward

Earlier in September, we announced SQL Server 2019 preview, the first release of SQL Server to create a unified data platform by packaging Apache SparkTM and Hadoop Distributed File System (HDFS) together with SQL Server as a single, integrated solution. In this session, come join us for a deep dive into SQL Server 2019.

Building a modern database architecture with Azure

Speaker: Jes Borland

This session will review the key foundations of Azure and introduce various Azure database options like SQL Server MI, Azure SQL DB, Cosmos DB, etc.

Thursday, February 28

Microsoft SQL Server Big Data Clusters architecture

Speaker: Buck Woody

This session is a  deep dive into the concepts of big data analytics and data virtualization in SQL Server 2019. You will also learn about the architecture to enable machine learning to train your models within SQL Server 2019.

Data science from scratch with Azure Machine Learning

Speaker: Mithun Prasad

This will be a crash course to create data science solutions and apply machine learning algorithms to real world scenarios.

SELECT * FROM Azure Cosmos DB

Speaker: Theo van Kraay

This pre-conference session will provide in-depth training on Azure Cosmos DB. At the end of the training, you will be equipped to build your applications on Cosmos DB.

Deep dive into Azure Data Factory with SSIS

Speaker: Sandy Winarko

This session will focus on modernizing your extract, transform, and load (ETL) workloads with a deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF).

Highlighted sessions during the conference March 1st and 2nd

Inside SQL Server 2019

Speakers: Bob Ward, Buck Woody, Anna Thomas

Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team.

What’s New – Query Performance Insights

Speaker: Pedro Lopes

Come and be a rockstar at troubleshooting query performance with all the latest innovations in intelligent query processing.

Hyperscale for Azure SQL DB   

Speaker: Kevin Farlee

In this session you’ll learn how the Hyperscale service tier in Azure SQL DB removes many of the practical limits traditionally seen in cloud.

A dive into the architecture that is Azure SQL DW Gen2. How does it work?

Speaker: Philip Beaumont, Neil Millington

Come learn how you can turbocharge your query performance and concurrency with a fully managed cloud data warehouse.

Getting intimate with the Power BI desktop

Speaker: Patrick LeBlanc, Adam Saxton

Join us in this session, where we will dive deep into the Power BI desktop.

Enterprise BI with Power BI Premium and SSAS

Speaker: Christian Wade

Join the two-part series to learn about the new features landing in SQL Server Analysis services and also learn how to use Power BI premium to create semantic models.

There are over 44 sessions from Microsoft data platform speakers, and we invite you to come hear from Microsoft and community experts at SQL Bits 2019.

The post Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK! appeared first on Microsoft SQL Server Blog.

]]>
Announcing Power BI Report Server http://approjects.co.za/?big=en-us/sql-server/blog/2017/05/03/announcing-power-bi-report-server/ http://approjects.co.za/?big=en-us/sql-server/blog/2017/05/03/announcing-power-bi-report-server/#comments Wed, 03 May 2017 15:00:17 +0000 This post was authored by the Power BI Team Today Microsoft announced Power BI Premium — a capacity-based licensing model that increases flexibility for how users access, share and distribute content in Power BI. The new offering also introduces the ability to manage Power BI Reports on-premises with the included Power BI Report Server. Power

The post Announcing Power BI Report Server appeared first on Microsoft SQL Server Blog.

]]>
This post was authored by the Power BI Team

Today Microsoft announced Power BI Premium — a capacity-based licensing model that increases flexibility for how users access, share and distribute content in Power BI. The new offering also introduces the ability to manage Power BI Reports on-premises with the included Power BI Report Server.

Power BI Report Server will be generally available late in the second quarter of 2017.

Read the Power BI Report Server announcement and learn more about Power BI Report Server on the Power BI website.

pbi-sales-report

 

 

The post Announcing Power BI Report Server appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2017/05/03/announcing-power-bi-report-server/feed/ 2
Microsoft Business Intelligence – our reporting roadmap http://approjects.co.za/?big=en-us/sql-server/blog/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap/ http://approjects.co.za/?big=en-us/sql-server/blog/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap/#comments Thu, 29 Oct 2015 18:38:00 +0000 While each year has seen advances across our product line, this past year’s progress is truly unprecedented. We firmly believe Microsoft now offers the industry’s most complete and modern business intelligence product family – with unmatched breadth and depth. At first approach, this depth can be overwhelming – how do all the components fit together?

The post Microsoft Business Intelligence – our reporting roadmap appeared first on Microsoft SQL Server Blog.

]]>
While each year has seen advances across our product line, this past year’s progress is truly unprecedented. We firmly believe Microsoft now offers the industry’s most complete and modern business intelligence product family – with unmatched breadth and depth.

At first approach, this depth can be overwhelming – how do all the components fit together? Where are things heading in the future? These are frequent questions from our customers and partners.

As we approach the release of SQL Server 2016 it’s a great time to tackle those questions in a definitive blog.

Where we are heading

Our goal is simple – we want to put the power of data in the hands of every business and person on the planet. It is our objective to serve over a billion users with the Microsoft business intelligence (BI) platform.

Data is coming at us from every direction. From traditional sources – on-premises enterprise applications and databases. From sources developed over the last decade – websites, mobile applications, social media and SaaS business applications. And from sources still emerging – data from the “Internet of Things.”

Maximizing the potential of one’s data requires a platform that can work with data from on-premises systems and from the cloud – of any shape, size and arrival velocity, that can deliver insights wherever users may be, and in a form most convenient and accessible; and that offers deployment options that best fit the needs of an organization, at any point in its journey.

To achieve these requirements, we are aligning our cloud and on-premises solutions. It is our intent that your reporting technology investments and expertise will transfer across these deployment modalities so you can easily mix and match on-premises and cloud components, and benefit from our unique hybrid scenarios.

Harmonizing report types

We intend to standardize reporting content types across Microsoft on-premises, cloud and hybrid systems. Our reporting path forward focuses on four report types:

  • Paginated reports built with SQL Server Report Builder or SQL Server Data Tools. Paginated reports allow for exact placement of elements on a page and are capable of complex display logic for creating printed reports or online operational reports. Paginated/operational reports have been a popular, invaluable foundation for day-to-day reporting and analytics for over a decade. These reports will continue to be a standard report type.
  • Interactive reports built with Power BI Desktop. Power BI Desktop is a contemporary visual data discovery application and the next generation of our Power View technology. It generates HTML5-based reports, ensuring compatibility across all modern browsers.
  • Mobile reports are based on Datazen technology. We believe dedicated reports optimized for mobile devices and form factors provide an optimal experience for users accessing BI reports on mobile devices. By specifically designing reports for different mobile form factors, we deliver on our promise and enable users to get business insights, any way, anywhere and from any device.
  • Analytical reports and charts created with Excel. Excel is the most widely used analytical tool today and it will continue to be an important report type, critical to our solution on-premises and in the cloud.

Reporting Services is our on-premises solution for BI report delivery

SQL Server Reporting Services (SSRS) to date has focused on paginated reports and offers class-leading capabilities for that format. With SQL Server 2016 we are taking a leap forward by adding support for mobile reports. The addition of this new report type in SSRS is accompanied by an entirely new web experience for Reporting Services allowing users to access both paginated and mobile reports in one centralized location.

This modernized SSRS web experience delivers the foundation for centralized report consumption, embedding and sharing of BI reports for those organizations that desire an on-premises option (versus using Power BI in the cloud).

Publish Power BI Desktop Reports on-premises

Power BI Desktop is a data discovery and interactive reporting tool allowing business analysts to connect, prepare, and visually explore data across a freeform canvas. It combines the strengths of Power Query to connect to a vast spectrum of data sources and easily shape data, Power Pivot for rich data blending and modeling, and next generation Power View to intuitively perform visual analytics and author compelling reports.

Based on the same technology as Power View, Power BI Desktop supports existing Power View reports and provides the future path to a HTML5 based interactive report experience on-premises.

Just as we’ve added mobile report delivery to SSRS in SQL Server 2016, we intend to add governed Power BI Desktop report delivery in the future. Today Power BI Desktop supports publishing of reports to Power BI; Power BI Desktop is free to use, experience it yourself today.

Unified Mobile BI experience

Whether using SQL Server Reporting Services on-premises, Power BI in the cloud, or both as your report delivery solution, we’ll have a single mobile application (for each of Windows, iOS and Android) for consumption of all report types. At PASS Summit 2015 we demonstrated a single Power BI mobile application delivering a combination of report types from both SQL Server Reporting Services 2016 and the Power BI service. All of your BI content will be at your fingertips from within a single, unified mobile app to deliver insights any way, anywhere and from any device.

Symmetry across on-premises and cloud

As we continue to harmonize our offerings across cloud and on-premises, we continue to align technologies and tools across all parts of our BI platform.

Mirroring technologies across on-premises and the cloud enables one to easily switch between the two. Our approach also offers unique hybrid capabilities needed in a big data world where data lives in many locations.

For example, you can use your existing on-premises SSAS multi-dimensional models with enforced row-level security as a data source for Power BI without moving your data to the cloud; or directly connect to data in an on-premises SQL Server database without requiring SSAS, again without requiring your data move to the cloud.

You can choose, manage and monitor on-premises-to-Power BI data connections using our forthcoming enterprise gateway capability. Pin your favorite chart from an operational SSRS report to a Power BI dashboard to leverage your existing reporting investments in SQL Server Reporting Services.

It’s your data. We are here to empower you to drive your business based on insights gained from that data, whether your data is on-premises, in the cloud or a combination of the two.

The future is bright

Let us know what you think, share your comments about our future direction, and of course try out the latest SQL Server 2016 CTP, and Power BI Desktop to experience the future of SQL Server BI today.

Lastly, if you are attending PASS Summit this week, join us for our on-premises BI sessions today and tomorrow:

Oct. 29, 2015 at 1:30 pm PST: What’s New in SQL Server 2016 Reporting Services [BIA-321-M] in TCC 304 by Riccardo Muti
Oct. 30, 2015 at 11:15 am PST: The Analysis Services Evolution [BID-311-M] in TCC 303 by Kasper de Jonge
Oct. 30, 2015 at 3:30 pm PST: Datazen Technical Deep Dive [BID-312-M] in TCC 304 by Chris Finlan and Paul Turley

The post Microsoft Business Intelligence – our reporting roadmap appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap/feed/ 31
Come hear CVP James Phillips speak about advances in Microsoft Business Intelligence http://approjects.co.za/?big=en-us/sql-server/blog/2015/10/23/come-hear-cvp-james-phillips-speak-about-advances-in-microsoft-business-intelligence/ Fri, 23 Oct 2015 16:00:00 +0000 We are thrilled to have one of our PASS Summit Foundation Sessions presented by Corporate Vice President, James Phillips! He will share Microsoft Business Intelligence strategies, including an integrated view with Power BI, SSAS, and SSRS. James Phillips began his career writing software for the Apple II, TRS-80 and IBM PC platforms. In 1984, at

The post Come hear CVP James Phillips speak about advances in Microsoft Business Intelligence appeared first on Microsoft SQL Server Blog.

]]>
We are thrilled to have one of our PASS Summit Foundation Sessions presented by Corporate Vice President, James Phillips! He will share Microsoft Business Intelligence strategies, including an integrated view with Power BI, SSAS, and SSRS.

James Phillips began his career writing software for the Apple II, TRS-80 and IBM PC platforms. In 1984, at age 17, he co-founded his first software company, Fifth Generation Systems.  In 2004 James co-founded and served as CEO of Akimbi, a virtualization management software company acquired by VMware in 2006 for $60 million generating 250% and 500% IRR for series A and B investors, respectively. James has held executive leadership roles in software engineering, product management, marketing and corporate development at large public companies including Microsoft, Intel and VMware and with venture-backed software startups.  James holds a BS in Mathematics and earned his MBA, with honors, from the University of Chicago.

Phillips joined Microsoft in 2012 as a strategy advisor to Satya Nadella, then president of Microsoft’s Cloud and Enterprise division. His teams build and operate a wide range of products and services, contributing approximately two billion USD in aggregate annual revenue, including the Power BI cloud (SaaS) analytics service and its supporting iPhone, iPad, Android and Windows apps; Microsoft SQL Server Analysis and Reporting Servers; and offerings spanning Visual Studio, Microsoft Office, Office 365, SharePoint and SharePoint Online.

We are looking forward to seeing all of you at the event. Please register, if you have not already, at – www.sqlpass.org/summit/2015/RegisterNow.aspx.

The post Come hear CVP James Phillips speak about advances in Microsoft Business Intelligence appeared first on Microsoft SQL Server Blog.

]]>
New Year’s Resolution? Free BI and Big Data Training http://approjects.co.za/?big=en-us/sql-server/blog/2015/01/20/new-years-resolution-free-bi-and-big-data-training/ http://approjects.co.za/?big=en-us/sql-server/blog/2015/01/20/new-years-resolution-free-bi-and-big-data-training/#comments Tue, 20 Jan 2015 21:32:00 +0000 Interested in growing your BI and Big Data skills in 2015? Maybe your new year’s resolution is all about learning something new or taking your analytics knowledge to the next level? See what BI and Big Data training courses were your peers’ favorites in 2014: Faster Insights to Data with Power BI Jumpstart From Data

The post New Year’s Resolution? Free BI and Big Data Training appeared first on Microsoft SQL Server Blog.

]]>
Interested in growing your BI and Big Data skills in 2015? Maybe your new year’s resolution is all about learning something new or taking your analytics knowledge to the next level?

See what BI and Big Data training courses were your peers’ favorites in 2014:

And last but not least, check out the brand new Big Data with the Microsoft Analytics Platform Services.

Learn more about Microsoft’s big data solutions or find training opportunities on the Microsoft Virtual Academy.

The post New Year’s Resolution? Free BI and Big Data Training appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2015/01/20/new-years-resolution-free-bi-and-big-data-training/feed/ 1
Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 http://approjects.co.za/?big=en-us/sql-server/blog/2014/12/16/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3/ http://approjects.co.za/?big=en-us/sql-server/blog/2014/12/16/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3/#comments Tue, 16 Dec 2014 17:00:00 +0000 This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft’s big data in a box appliance for serving the needs of relational data warehouses at massive scale.

The post Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 appeared first on Microsoft SQL Server Blog.

]]>
This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team

Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft’s big data in a box appliance for serving the needs of relational data warehouses at massive scale. With this release, the APS appliance supports new scenarios for utilizing Power BI modeling, visualization, and collaboration tools over on premise data sets. In addition, this release extends the PolyBase to allow customers to utilize the HDFS infrastructure in Hadoop for ORC files and directory modeling to more easily integrate non-relational data into their data insights.

The AU3 release includes:

  • PolyBase recursive Directory Traversal and ORC file format support
  • Integrated Data Management Gateway enables query from Power BI to on premise APS
  • TSQL compatibility improvements to reduce migration friction from SQL Server SMP
  • Replatformed to Windows Server 2012 R2 and SQL Server 2014

PolyBase Directory Traversal and ORC File Support

PolyBase is an integrated technology that allows customers to utilize the skillset that they have developed in TSQL for querying and managing data in Hadoop platforms. With the AU3 release, the APS team has augmented this technology with the ability to define an external table that targets a directory structure as a whole. This new ability unlocks a whole new set of scenarios for customers to utilize their existing investments in Hadoop as well as APS to provide greater insight into all of the data collected within their data systems. In addition, AU3 introduces full support for the Optimized Row Column (ORC) file format – a common storage mechanism for files within Hadoop.

As an example of this new capability, let’s examine a customer that is using APS to host inventory and Point of Sale (POS) data in an APS appliance while storing the web logs from their ecommerce site in a Hadoop path structure. With AU3, the customer can simply maintain a structure for their logs in Hadoop in a structure that is easy to construct such as year/month/date/server/log for simple storage and recovery within Hadoop that can then be exposed as a single table to analysts and data scientists for insights.

In this example, let’s assume that each of the Serverxx folders contains the log file for that server on that particular day. In order to surface the entire structure, we can construct an external table using the following definition:

CREATE EXTERNAL TABLE [dbo].[WebLogs]
(
	[Date] DATETIME NULL,
	[Uri] NVARCHAR(256) NULL,
	[Server] NVARCHAR(256) NULL,
	[Referrer] NVARCHAR(256) NULL
)
WITH
(
	LOCATION='//Logs/',
	DATA_SOURCE = Azure_DS,
	FILE_FORMAT = LogFileFormat,
	REJECT_TYPE = VALUE,
	REJECT_VALUE = 100
);

By setting the LOCATION targeted at the //Logs/ folder, the external table will pull data from all folders and files within the directory structure. In this case, a simple select of the data will return data from only the last 10 entries regardless of the log file that contains the data:

SELECT TOP 5
	*
FROM
	[dbo].[WebLogs]
ORDER BY
	[Date]

The results are:

Note: PolyBase, like Hadoop, will not return results from hidden folders or any file that begins with an underscore (_) or period(.).

Integrated Data Management Gateway

With the integration of the Microsoft Data Management Gateway into APS, customers now have a scale-out compute gateway for Azure cloud services to more effectively query sophisticated sets of on-premises data.  Power BI users can leverage PolyBase in APS to perform more complicated mash-ups of results from on-premises unstructured data sets in Hadoop distributions. By exposing the data from the APS Appliance as an OData feed, Power BI is able to easily and quickly consume the data for display to end users.

For more details, please look for an upcoming blog post on the Integrated Data Management Gateway.

TSQL Compatibility improvements

The AU3 release incorporates a set of TSQL improvements targeted at richer language support to improve the types of queries and procedures that can be written for APS. For AU3, the primary focus was on implementing full error handling within TSQL to allow customers to port existing applications to APS with minimal code change and to introduce full error handling to existing APS customers. Released in AU3 are the following keywords and constructs for handling errors:

In addition to the error handling components, the AU3 release also includes support for the XACT_STATE scalar function that is used to indicate the current running transaction state of a user request.

Replatformed to Windows Server 2012 R2 and SQL Server 2014

The AU3 release also marks the upgrade of the core fabric of the APS appliance to Windows Server 2012 R2 and SQL Server 2014. With the upgrade to the latest versions of Microsoft’s flagship server operating system and core relational database engine, the APS appliance takes advantage of the improved networking, storage and query execution components of these products. For example, the APS appliance now utilizes a virtualized Active Directory infrastructure which helps to reduce cost and increase domain reliability within the appliance helping to make APS the price/performance leader in the big data appliance space.

APS on the Web

To learn more about the Microsoft Analytics Platform System, please visit us on the web at http://approjects.co.za/?big=aps.

The post Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2014/12/16/relational-data-warehouse-big-data-analytics-analytics-platform-system-aps-appliance-update-3/feed/ 1
Microsoft adds forecasting capabilities to Power BI for O365 http://approjects.co.za/?big=en-us/sql-server/blog/2014/05/08/microsoft-adds-forecasting-capabilities-to-power-bi-for-o365/ http://approjects.co.za/?big=en-us/sql-server/blog/2014/05/08/microsoft-adds-forecasting-capabilities-to-power-bi-for-o365/#comments Thu, 08 May 2014 16:15:00 +0000 The PASS Business Analytics Conference — the event where big data meets business analytics – kicked off today in San Jose. Microsoft Technical Fellow Amir Netz and Microsoft Partner Director Kamal Hathi delivered the opening keynote, where they highlighted our customer momentum, showcased business analytics capabilities including a new feature update to Power BI for

The post Microsoft adds forecasting capabilities to Power BI for O365 appeared first on Microsoft SQL Server Blog.

]]>
The PASS Business Analytics Conference — the event where big data meets business analytics – kicked off today in San Jose. Microsoft Technical Fellow Amir Netz and Microsoft Partner Director Kamal Hathi delivered the opening keynote, where they highlighted our customer momentum, showcased business analytics capabilities including a new feature update to Power BI for Office 365 and spoke more broadly on what it takes to build a data culture.

To realize the greatest value from their data, businesses need familiar tools that empower all their employees to make decisions informed by data. By delivering powerful analytics capabilities in Excel and deploying business intelligence solutions in the cloud through Office 365, we are reducing the barriers for companies to analyze, share and gain insight from data. Our customers have been responding to this approach through rapid adoption of our business analytics solutions — millions of users are utilizing our BI capabilities in Excel and thousands of companies have activated Power BI for Office 365 tenants.

One example of how our customers are using our business analytics tools is MediaCom, a global advertising agency which is using our technology to optimize performance and “spend” across their media campaigns utilizing data from third party vendors. With Power BI for Office 365, the company now has a unified dashboard for real-time data analysis, can share reports, and can ask natural-language questions that instantly return answers in the form of charts and graphs. MediaCom now anticipates analyses in days versus weeks and productivity gains that can add millions of dollars in value per campaign.

One of the reasons we’re experiencing strong customer adoption is because of our increased pace of delivery and regular service updates. Earlier this week we released updates for the Power Query add-in for Excel and today we are announcing the availability of forecasting capabilities in Power BI for Office 365. With forecasting users can predict their data series forward in interactive charts and reports. With these new Power BI capabilities, users can explore the forecasted results, adjust for seasonality and outliers, view result ranges at different confidence levels, and hindcast to view how the model would have predicted recent results.

In the keynote we also discussed how we will continue to innovate to enable better user experiences through touch-optimized capabilities for data exploration. We are also working with our customers to make their existing on-premises investments “cloud-ready”, including the ability for customers to run their SQL Server Reporting Services and SQL Server Analysis Services reports and cubes in the cloud against on-premises data. For cross-platform mobile access across all devices we will add new features to make HTML5 the default experience for Power View.

To learn more about the new forecasting capabilities in Power BI for O365, go here. If you’re attending the PASS Business Analytics Conference this week, be sure to stop by the Microsoft booth to see our impressive Power BI demos and attend some of the exciting sessions we’re presenting at the event.

The post Microsoft adds forecasting capabilities to Power BI for O365 appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2014/05/08/microsoft-adds-forecasting-capabilities-to-power-bi-for-o365/feed/ 1
ICYMI: Data platform momentum http://approjects.co.za/?big=en-us/sql-server/blog/2014/04/28/icymi-data-platform-momentum/ http://approjects.co.za/?big=en-us/sql-server/blog/2014/04/28/icymi-data-platform-momentum/#comments Mon, 28 Apr 2014 16:00:00 +0000 The last couple months have seen the addition of several new products that extend Microsoft’s data platform offerings. At the end of January, Quentin Clark outlined his vision for the complete data platform, exploring the various inputs that are driving new application patterns, new considerations for handling data of all shapes and sizes, and ultimately

The post ICYMI: Data platform momentum appeared first on Microsoft SQL Server Blog.

]]>
The last couple months have seen the addition of several new products that extend Microsoft’s data platform offerings.

At the end of January, Quentin Clark outlined his vision for the complete data platform, exploring the various inputs that are driving new application patterns, new considerations for handling data of all shapes and sizes, and ultimately changing the way we can reveal business insights from data.

 In February, we announced the general availability of Power BI for Office 365, and you heard from Kamal Hathi about how this exciting release simplifies business intelligence and how features like Power BI sites and Power BI Q&A, Power BI helps anyone, not just experts, gain value from their data. You also heard from Quentin Clark about how Power BI helps make big data work for everyone by bringing together easy access to data, robust tools that everyone can use, and a complete data platform.

In March, we announced that SQL Server 2014 would be general available beginning April 1, and shared how companies are already taking advantage of in-memory capabilities and hybrid cloud scenarios that SQL Server enables. Shawn Bice explored the platform continuum, and how with this latest release, developers can continue to use SQL Server on-premises while also dipping their toes into the possibilities with the cloud using Microsoft Azure. Additionally, Microsoft Azure HDInsight was made generally available to support Hadoop 2.2, making it easy to deploy Hadoop in the cloud.

 And earlier this month at the Accelerate your insights event in San Francisco, CEO Satya Nadella discussed Microsoft’s drive towards a data culture. In addition, we announced two other key capabilities to extend the robustness of our data platform: the Analytics Platform System, an evolution of the Parallel Data Warehouse with the addition of a Hadoop region for your unstructured data, and then a preview of the Microsoft Azure Intelligent Systems Service to help tap into the Internet of Your Things.

On top of our own announcements, we’ve been recently honored to be recognized by Gartner as a Leader in the 2014 Magic Quadrants for Data Warehouse Database Management Systems and Business Intelligence and Analytics Platforms. And SQL Server 2014, in partnership with Hewlett Packard, set two world records for data warehousing performance and price/performance.

With these enhancements across the entire Microsoft data platform, there is no better time than now to dig in. Learn more about our data platform offerings. Brush up on your technical skills for free on the Microsoft Virtual Academy. Connect with other SQL Server experts through the PASS community. Hear from Microsoft’s engineering leaders about Microsoft’s approach to developing the latest offerings. Read about the architecture of data-intensive applications in the cloud computing world from Mark Souza, which one commenter noted was a “great example for the future of application design/architecture in the Cloud and proof that the toolbox of the future for Application and Database Developers/DBAs is going to be bigger than the On-Prem one of the past.” And finally, come chat in-person – we’ll be hanging out at the upcoming PASS Business Analytics and TechEd events and are eager to hear more about your data opportunities, challenges, and of course, successes. You can watch the keynotes on-demand.

What can your data do for you?

The post ICYMI: Data platform momentum appeared first on Microsoft SQL Server Blog.

]]>
http://approjects.co.za/?big=en-us/sql-server/blog/2014/04/28/icymi-data-platform-momentum/feed/ 1