The Microsoft Data Insights Summit is back – check out our full session catalog today!

In February, we announced that our Microsoft Data Insights Summit will return for the second year, and invited you to register and join us June 12-13, 2017 in Seattle, WA. This is THE user conference for Power BI, SQL Server BI, Excel, PowerApps, and Flow.

Building on last year’s success, we are expanding the content for this year’s event to include:

A pre-day on June 11 to provide in-depth technical training on:

  • Advanced Data Visualization and Modeling: full-day workshop covering the art and science of data visualization
  • App-in-a-Day with PowerApps, Flow, and Common Data Service: full-day workshop on creating business applications using PowerApps and Flow without writing a line of code!
  • Dashboard-in-a-Day 101: full-day workshop on connecting to data, creating interactive reports/dashboards, exploring data with visualization, and sharing insights with others
  • Data Modeling with Power BI: full-day workshop introducing techniques of shaping data models in Power BI
  • Modern Analytics in Excel: full-day workshop on extracting, transforming, and modeling data using shared advanced analytics features in Excel and Power BI—by Rob Collie, founder of PowerPivotPro
  • Power BI Dev-in-a-Day: full-day workshop for app developers to author interactive reports in Power BI Desktop, provision them in Azure, and embed them in an application

9 tracks:

  • Administration and Governance: sessions on managing modern BI while continuing to meet your organization’s unique regulatory, security, and policy requirements
  • Advanced Analytics: sessions on predictive and prescriptive analytics transforming data into intelligent action
  • Business Applications for Connected Data: sessions on leveraging Power BI and additional data sources to automate processes, enhancing collaboration and increasing productivity—using PowerApps and Flow
  • Customer Stories: sessions on best practices, successes, failures and course corrections from customers who have ben early adopters of Power BI
  • Dashboards/Reports and Design: sessions on designing interactive dashboards and visual reports to monitor and analyze your most important data
  • Data Prep and Modeling: sessions on cleaning and preparing data for visualization and analytics
  • Developers: sessions on developing apps and services leveraging Power BI, Excel, etc.
  • Distribution and Deployment: sessions on deploying Power BI solutions including deep dives on critical considerations like security and capacity planning
  • General Overview / Intro: sessions on Microsoft’s comprehensive set of tools and services that are helping organizations develop a data culture and democratize access to data and insights

4 hands-on workshops:

  • DAX 101: 2-hour workshop introducing the basics of the DAX language—by Alberto Ferrari.
  • Mini App-in-a-Day with PowerApps, Flow, and Common Data Service: 2-hour workshop on creating business applications using PowerApps and Flow without writing a line of code!
  • Mini Dashboard-in-a-Day: 2-hour workshop on connecting to data, creating interactive reports/dashboards, exploring data with visualization, and sharing insights with others
  • Mini Modern Analytics in Excel: 2-hour workshop on extracting, transforming, and modeling data using shared advanced analytics features in Excel and Power BI—by Rob Collie

View our full session catalog here on our event website today, and check back often for the latest updates!

We hope you’ll join us at the Microsoft Data Insights Summit in Seattle this June 12 – 13. Be sure to register today as space is limited and filling up quickly!

from Business Intelligence Blogs https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/03/30/the-microsoft-data-insights-summit-is-back-check-out-our-full-session-catalog-today/

Advertisements

Five reasons to run SQL Server 2016 on Windows Server 2016 – No. 2: Performance and cost

This is the second blog in a five-part series. Keep an eye out for upcoming posts and read the first post in the series, Five reasons to run SQL Server 2016 on Windows Server 2016, part 1.

Imagine you’ve just bought a super powerful car with built-in advanced technology to make it perform at its highest. You want to take full advantage of all that horsepower and even turbocharge it, while at the same time get great mileage. That’s what you get when you run SQL Server 2016 on Windows Server 2016: unmatched performance at the lowest cost.

By modernizing both your SQL Server data platform and your Windows Server OS, you can gain major cost savings and unprecedented performance boosts for workloads such as storage, business intelligence, and analytics. The strength of this combination has been shown in independent benchmark testing. As you can see in Figure 1, SQL Server 2016 on Windows Server 2016 leads the industry in both performance and price/performance ratio.

Figure 1: Best-in-class performance and price/performance ratio [1]

figure-1

You can get these amazing results from a few key features that are built into the new versions:

  • On the data platform side, SQL Server 2016 delivers in-memory performance, which gives you the power to run queries faster than ever before.
  • Windows Server 2016 turbocharges this with Persistent Memory (aka Storage Class Memory), which provides 3x latency improvement.
  • Storage Spaces Direct in Windows Server 2016 allows use of industry-standard servers with local storage as a highly available, scalable alternative to expensive storage area networks (SANs) — with read speeds that can exceed 25 GB/second.

SQL Server 2016 in-memory OLTP and 24 TB of Windows Server 2016 memory built in

In-memory processing was introduced in SQL Server 2014, and improvements in SQL Server 2016 make it much easier to accelerate your new, and now also your existing, applications. Revving up the speed potential of in-memory, Windows Server 2016 has built-in capability to provide in-memory with 24 terabytes of available server memory. Plus, new CPU maximums have been increased by three times so that you can run up to 640 CPU cores.

Windows Server 2016 Persistent Memory and Storage Spaces Direct

SQL Server professionals know that database transactions can be gated by log write speed. If the log is faster, more database updates are possible. Windows Server 2016 helps solve this with Persistent Memory, again adding direct value when you run SQL Server 2016 on Windows Server 2016.

When you think about significant cost savings over traditional storage, you’ll be interested to know that the new Windows Server 2016 Storage Spaces Direct lets you use local storage to create highly scalable and flexible storage solutions as shown in Figure 2. The ability to aggregate locally attached storage across the nodes in a failover cluster means you can deploy very large and highly available pools of storage from types of devices that you could not use before, such as inexpensive SATA SSD, and cutting-edge solutions like NVMe flash, which can plug directly into the PCIe bus inside the machine to create an NVMe fabric. Now SQL Server can scale to huge memory.

Figure 2: Enormous cost savings and blazing speed with Storage Spaces Direct

storage-spaces-direct-with-sql-server

Persistent memory is a state-of the-art new technology, and Windows Server 2016 is exposing it for the first time. SQL Server is in lockstep with the innovation so you can exploit it to gain the fastest speed at the lowest cost. If you’re tied to hugely expensive third-party solutions, you can certainly appreciate the enormous value this brings.

Get it all!

SQL Server 2016 features are built in. You get great performance at less than one-tenth of the total cost of using Oracle to run the same transactional, data warehouse, data integration, business intelligence, and advanced analytics workloads. [2] With a Windows Server 2016 license, you also get everything built in: Hyper-V and advanced storage capabilities with no need to buy separate third-party storage solutions or virtualization technologies.

sql-server-2016-industry-leading-tco

It’s all built right in. By listening to customers and creating new capabilities in both SQL Server 2016 and Windows Server 2016, Microsoft is tuning up your super vehicle to help get top performance and winning efficiency. Let ‘er rip!

To learn more, read the SQL Server + Windows Server Better Together white paper. Or try it out for yourself:

Don’t miss the earlier blog post in this series: Five reasons to run SQL Server 2016 on Windows Server 2016, part 1.

_____________________________________________________

[1] Qualifications and references for TPC-H results: These are for nonclustered TPC-H results and are valid as of March 1, 2017. The first bar is for the Cisco result . The second bar is for the Lenovo result. The third bar is for the HPE result. The price/performance references are valid as of March 1, 2017, and details on the referenced results can be found at:
#1 nonclustered 1TB performance
#1 nonclustered 3TB performance
#1 nonclustered 30TB performance
#1 nonclustered 1TB price/performance
#1 nonclustered 3TB price/performance
#1 nonclustered 10TB price/performance
#1 nonclustered 30TB price/performance
#1 TPC-E price/performance

[2] http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

from Business Intelligence Blogs https://blogs.technet.microsoft.com/dataplatforminsider/2017/03/30/five-reasons-to-run-sql-server-2016-on-windows-server-2016-part-2/

Turn insight into deep, meaningful action using Microsoft Flow and Power BI

Turn insight into deep, meaningful action using Microsoft Flow and Power BI

from Business Intelligence Blogs https://powerbi.microsoft.com/en-us/blog/turn-insight-into-deep-meaningful-action-using-microsoft-flow-and-power-bi-2/

Turn insight into deep, meaningful action using Microsoft Flow and Power BI

Turn insight into deep, meaningful action using Microsoft Flow and Power BI

from Business Intelligence Blogs https://powerbi.microsoft.com/en-us/blog/turn-insight-into-deep-meaningful-action-using-microsoft-flow-and-power-bi-2/

Announcing the new Power BI Video Gallery and Ask a Partner Anything live event

Ready to take a quick break and learn a new Power BI trick? We’ve got you covered! Announcing the latest community resource, the Power BI Video Gallery! The Video Gallery is a place for community rockstars like you to share their knowledge and provide tips and tricks for all things related to Power BI, including data analysis and modelling, custom visual development, using DAX, and more.

from Business Intelligence Blogs https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-bi-video-gallery-and-ask-a-partner-anything-live-event/

Webinars 3/30-5/31: R Script, Marketing Insights, Modeling Deep Dive, New Flow Features, Power BI Embedded, and Visualization Best Practices from Marco Russo

We have an exciting selection of webinars coming up over the next few months! Whether you’re a Power BI modelling expert, a PowerApps developer, or someone who is curious about Microsoft Flow — or anyone in-between — we’ve got a free webinar for you, featuring experts from both within Microsoft and your community. Come see what we have planned for April and May.

from Business Intelligence Blogs https://powerbi.microsoft.com/en-us/blog/webinars-r-script-marketing-insights-modeling-deep-dive-new-flow-features-power-bi-embedded-and-visualization-best-practices-from-marco-russo/

Build intelligent applications with help from Microsoft App Accelerate

Today’s exec is rudely awakened daily to ever-changing customer expectations. Last year’s huge investments were popular for a few months, but suddenly the “next big thing” is turning attention—and attracting budgets—elsewhere. How do you stay competitive with data and security? How do you ensure your applications scale across cloud and mobile?

Microsoft unveiled a new program, Microsoft App Accelerate, that targets such issues for application creators and ISVs (independent software vendors). Whatever cutting-edge commercial solution your company delivers, the program will provide product and technical resources to help you plan, deploy, launch, and grow your applications.

Still imagining your application? Find strategic planning resources to help you determine what investments can make the most impact. Utilize e-books and analyst reports to assess the technical and data opportunities driving the market, financial tools to help you determine ROI, and real-world examples of other app innovators and the steps they took to succeed.

Beginning to build, test, and deploy? You can connect directly with engineers and design experts who’ll bring the skills to match your vision. You’ll even have access to exclusive offers to help jump-start your development cycles.

For example:

  • Technical guidance from expert engineers across Microsoft’s flagship cloud and data solutions, including Azure, SQL Server, and Power BI.
  • Access to design sessions and deployment programs, such as the Data Accelerator and Power BI Embedded Accelerator offers.
  • Testing and certification services to drive accelerated app innovation and deployment.

Ready to launch your application? Here’s where Microsoft’s enterprise scale and global reach really deliver. Distribution channels like AppSource and Azure Marketplace help you find your customers. Co-selling and co-marketing opportunities from Microsoft’s go-to-market (GTM) services extend your impact. In-depth resources on marketing and sales strategy help you keep momentum and repeat success.

Visit Microsoft App Accelerate to learn more; but if you’re ready to jump right in, register today.

from Business Intelligence Blogs https://blogs.technet.microsoft.com/dataplatforminsider/2017/03/28/build-intelligent-applications-with-help-from-microsoft-app-accelerate/