background preloader

Microsoft BI

Facebook Twitter

Best Practices for Developing Real-Time Dashboards. Stream Analytics Power BI Dashboard. One of the common use case for Azure Stream Analytics is to analyze high volume streaming data in real time and get the insight in a live dashboard (a dashboard that updates in real time without user having to refresh the browser).

Stream Analytics Power BI Dashboard

Microsoft Power BI is perfect for building live dashboard in no time. Here is an example video to illustrate the scenario. In this article, learn how to use Power BI as an output for your Azure Stream Analytics job. Note- Azure Stream Analytics is Generally Available however at this point, Power BI output is a preview feature of Azure Stream Analytics. Big Data, Small Data, All Data, la nouvelle offre Microsoft - Big Data France. Depuis la mise en ligne de ce blog, nous avons eu l’occasion d’échanger à maintes reprises sur ce que sont les #BigData et discuter de l’intérêt d’exploiter ce déluge de données.

Big Data, Small Data, All Data, la nouvelle offre Microsoft - Big Data France

Le 15 avril dernier lors de la conférence Accelerate your insights, notre nouveau PDG Satya Nadella a pu réaffirmer et préciser la stratégie de Microsoft orientée vers la donnée (Si vous avez manqué l’évènement, n’hésitez pas à visionner les webcasts disponibles au niveau de ce lien.) S’il semble aujourd’hui de plus en plus avéré, et au-delà du buzzword, que la vague Big Data constitue un tournant à ne pas manquer pour rester compétitif, il convient néanmoins dans le même temps de ne pas perdre de vue qu’une approche Big Data doit intervenir en complément d’une analyse classique de la donnée.

A One Hour Data Analysts Toolkit: using R and PowerBI with Jennifer Stirrup. Jen Stirrup is a Gigaom industry analyst, an author, SQL Server MVP, a data strategist and practitioner in Business Intelligence, Big Data and Data Visualisation.

A One Hour Data Analysts Toolkit: using R and PowerBI with Jennifer Stirrup

Jen is joint owner of a boutique consultancy firm that offers strategic advice and implementation in data technologies. With nearly 20 years’ experience in delivering artificial intelligence, business intelligence and data visualisation projects, Jen has focused on delivering business value for organisations of various sizes globally. Jen is an elected member of the Board of Directors for the Professional Association of SQL Server, holding the seat for Europe and holder of the Virtual Chapters portfolio worldwide. Data Science Labs – Analyze Twitter data with Excel and Power Query.

A typical Big Data architecture is able to handle structured data and unstructured data.

Data Science Labs – Analyze Twitter data with Excel and Power Query

Databases are great to handle large amounts of structured data, which can be queried very efficient and fast. But databases are not an appropriate store for unstructured data like text, xml, logs, etc. The challenge with unstructured data is, that every row could looks a little bit differently which makes it very hard to handle during ETL and for modeling. Filtering and Custom Maps arrive to Power Map with September update - PowerBI. Today Microsoft announced a new Power Map update that includes two of the most requested features by our users: Filtering and Custom Maps.

Filtering and Custom Maps arrive to Power Map with September update - PowerBI

As usual, all of the new features we incorporate into these monthly updates are based on your feedback to make Power Map a better story telling and data visualization tool. At the same time, we are always looking to make Power Map easier to use and more exciting, taking advantage of all the data visualization and analysis tools available in Excel. Watch this video to see these new features in action: Filtering will allow you to refine your Power Map tours, seeing individual portions of your data set, removing noise and outliers, and comparing how different factors can alter your data.

Custom Maps extends all the existing features of Power Map, so you can tell rich and interactive stories using any map. To find out more about how to use these new features, visit the announcement at the Office Blog. Convert SSRS Charts to Highcharts (Dynamic) Graphs. SSRS is an awesome framework as part of a whole BI solution for report authoring, delivery and interaction.

Convert SSRS Charts to Highcharts (Dynamic) Graphs

One problem though is that the reports produced through Visual Studio or Report Builder are too static, there is no hover-over effect in SSRS reports, and you cannot do dynamic filtering once the report finished rendering. This posts goes through building a converter that takes the ATOM output of an SSRS chart (1 y-axis Line Graph), and returns a dynamic Highcharts graph the represent the same data points. This article is a part 1 of 2, in the next article I give a working example of how to inject and display a Highcharts graphs right into an SSRS report. It is important to remember that SQL Server 2012 (project name: Denali) has the ability to generate dynamic charts (delivered through Silverlight) using its latest report authoring framework which is being called PowerView (or project name: Crescent).

Options.xAxis.categories.push($(category).text()); SQL Server Reporting Services Basics: Building SSRS Reports. SQL Server Reporting Services is one of the most popular components of SQL Server, but it has always been surprisingly difficult to get from one place all the basic facts you need to get up and running from scratch, to the point of producing reports.

SQL Server Reporting Services Basics: Building SSRS Reports

Here Kathi Kellenberger quickly describes the basics of SSRS before showing how to build quick, simple reports. SQL Server Reporting Services (SSRS) is a server-based reporting platform that allows us to create and manage a wide variety of different types of report, and deliver them in a range of formats. We can create basic reports containing tables and graphs, or more complex data visualizations, using charts, maps and sparklines.

Oracle Databases with SQL Server Reporting Services. Internally, SSRS uses the Oracle Data Provider for .NET (ODP.NET) to interact with Oracle databases.

Oracle Databases with SQL Server Reporting Services

Hence, the ODP.NET's restrictions apply to SSRS as well. Unlike SQL Server, Oracle returns resultant rows in a cursor. To use a stored procedure for data retrieval within SSRS, consider the following things: 1.The rows must be returned with an OUT REF CURSOR. 2.Only one OUT REF CURSOR can be returned from a stored procedure. In case of multiple OUT REF CURSORs, SSRS considers only the first one and simply ignores the rest. Note: ADO.NET provides the capability to interact with multiple OUT CURSORs. 3.By default, the data source type is set to OLE DB. TechEd 2014 : Azure embrasse big data et Internet des objets. Tap into Oracle Databases with SQL Server Reporting Services. The data-retrieval layer of Microsoft SQL Server Reporting Services (SSRS) supports a variety of data sources, including MS SQL Server, Oracle, ODCB, OLE DB, as well as several custom ones.

Tap into Oracle Databases with SQL Server Reporting Services

The product has been optimized for MS SQL Server, so SSRS interacts seamlessly with that data source option. Connecting to other data sources, however, involves some additional subtleties. This article examines SSRS interaction with Oracle databases. Under the hood, SSRS uses ADO.NET classes. Power BI : coup de fouet pour l'offre analytique de Microsoft. Reporting Services Parameters and Oracle - Martyn Bullerwell's blog. Recently a colleague of mine needed to access Oracle to build a report but did not have the rights to create a stored procedure, which would be the obvious method of choice.

Reporting Services Parameters and Oracle - Martyn Bullerwell's blog

We therefore need to pass parameters from Reporting Services to Oracle using the "Query Type" of text. To do this in SQL Server it is relatively intuitive. Create a shared Data Source - I have used Adventure Works. Then add a DataSet: This query will return all records from the Adventure Works 'people' table, showing the following fields; FirstName, MiddleName, LastName and Email Address. Consuming RESTful Web Services in an SSIS Script Transformation. RESTful (Representational State Transfer) web services such as YQL are tremendously useful tools for building client-side mash-ups, and can be just as useful when building ETL processes. Unfortunately SSIS (SQL Server Integration Services) does not provide any native support for consuming RESTful web services. In this post I’ll show you how to create a Script Transformation Task that calls Yahoo’s PlaceFinder web API to validate user supplied postal addresses.

2012 Demo Scripts - SQLskills.com. 2014 | 2013 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | Pre-2005 As used in many conference sessions, these sample databases are useful for learning and reproducing the behavior of most demos. Credit is used in many performance-related demos. SalesDB is used in many “online operations” demos. Unzip and restore (possibly, WITH MOVE) to use. Tech Head Brothers - Portail d'informations et d'articles techniques sur les technologies Microsoft .NET.

Tech Head Brothers - Auteurs.

SSAS

SSIS. Automated Defragmentation of SQL Indexes - The ADoSI Script - Benefic. Business Intelligence Archives - Benefic. Webcast Power Query et Data Management Gateway. Dax Patterns. Dax Patterns. La BI ça vous gagne! Mise à jour 02/05/2014 : cet article existe aussi maintenant en webcast! Merci le GUSS ;) Vous le savez surement, Power Query est l’add-in Excel publié par Microsoft via son offre Power BI, dédié à l’import de données de sources multiples. On en avait déjà parlé pour importer des fichiers identiques dans un même XLSX, une grosse galère sous Excel nature, une balade avec Power Query. Si nous sommes nombreux à voir en Power Query un outil avec un potentiel exceptionnel, il y a un domaine où il est encore assez faible : l’import de données affichées sur une page web. Enfin ce n’est pas vraiment Power Query qui est faible, c’est plutôt qu’après 2500 lignes de JavaScript, le HTML final des sites est souvent complétement inexploitable…

Recherchez les vidéos et les slideshare des sessions 2014 - Page 1. Le reporting BI dans tous ses états / quel outil pour quel usage. IT Pro Camps. Présentations techniques gratuites, ouvertes et interactives animées par des architectes Microsoft ! PowerBI. SQL Server 2012 content from SQL Server Pro. If there’s one thing you can’t have too many of, it’s free tools—especially if they help to solve problems or make your work more productive. I’ll point you to eight cool, useful, and free SQL Server tools that can make your job easier. SQL Sentry Plan Explorer 2.0 SQL Sentry’s Plan Explorer helps you to better analyze the graphical plan view that SQL Server Management Studio (SSMS) query plan analysis produces. Plan Explorer adds color coding to highlight potential problem areas. The Pro version adds query tuning tips. SQL check 3.5. SCRIPT: Find the row count of all tables and views. Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and views in a SQL Server database.

Count Rows In All Tables: This query returns the count of rows from all tables in a database. The results can be seen instantaneously without causing any blocking or locking. It is safe to run this in production. ; WITH A AS ( SELECT TableName = O.Name , SchemaName = SCHEMA_NAME(O.Schema_id) , [Rows] = P.Rows FROM sys.objects O INNER JOIN sys.partitions P ON O.OBJECT_ID = P.OBJECT_ID WHERE TYPE = 'U' ) SELECT SchemaName , TableName , SUM([Rows]) FROM A GROUP BY SchemaName , TableName ; Decisions: PowerPivot, SSAS Tabular, or SSAS Multidimensional Model in SQL Server 2012 — SQL Chick.

A big thanks: First thing first. I need to thank my good friend Javier Guillen (Blog | Twitter) for proofreading the decision matrix below & providing additional input. If you are interested in PowerPivot or Analysis Services, be sure to follow Javier. E90E50charts - Excel Charts Gallery. SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code - Dave does Data. This "How to" guide provides ideas & code samples on using color to improve your users understanding of the data in your reports. It includes using gradients of color in your tables & charts. Microsoft TechDays'14.