Microsoft introduces new tools for hybrid data solutions. The new face of Microsoft consists of Data Sources, Data integration, Streaming & Transform methods, Modern Data Warehouse & Big Data, Database Modelling, Advanced Analytics and Visualization & Self Service BI. Architect them on premise, APIs and on cloud to enhance the business needs.
A data sources can source from an Enterprise Data, Web Logs, Social Data, Sensors, Kiosks, Retail etc. The data can be on Premise or it can be on cloud or data can be anywhere. The data sources can be unstructured, semi structured, Structured, Relational. Analysis of such data needs fine tuning building a decision tables. Such data can be modified transformed and store then in a blob or data store. Microsoft can transform data to intelligence and to action.
Microsoft Cortana intelligence is now adding values to the business intelligence world with voice commands. NLQ (Natural Language Query) is the core processing engine which is now transforming the data to life. The solution for such for such analytics is leveraging advanced analytics.
How do we leverage such advanced methods in Analyzing the data?. The answer could be by detecting subtle patterns and insights by analyzing massive amounts of data from many sources. Shape new business outcomes by predicting what may happen in the future. Automate decision-making to accelerate business and aid competitive advantage.
Cortana Intelligence suite for Transforming data to intelligent action. First thing to bring data into cloud and start analyzing it. Let me give you an example, if you are running a shipping or logistics company there are many data flows into the system. May be an events, or it can be logs. When we connect these data sources to a data lake. This can be done by creating, scheduling, orchestrate and manage data pipelines. If you are having such extensive data growth you can connect them to SQL Data warehouse, Event Hub and start connecting to Power BI, HD Insight. If some data flows through any device or machine. Such real-time engines can be managed using Stream Analytics and Event Hubs.
Visualization of the data is most important for day to day business decisions. Microsoft now jumped into the new self-service data analysis space with Power BI. Power BI is offering new capabilities like Power Query, Power Pivot, Power Map and lets you create interactive visualizations, reports and dashboards with few clicks or drag and drops. The new feature of NLQ Natural Language Questions about your data on a dashboard will handle large data to represent in a better way.
I would suggest to try out the new features that are evolving at Microsoft Azure platform towards data and Business Intelligence.