Conheça o Power BI

Editor's Notes

• #2 Welcome to this presentation!
• #3 Introduce the module title and topics.
• #4 Key message: Business intelligence, or BI, has come a long way. During the first two waves of business intelligence, IT professionals and business analysts were the keepers of BI. They made BI accessible and consumable for end users. While this approach still applies to complex business intelligence needs, today there is a new wave. This third wave of BI makes BI available to every kind of user. Talking points: Today we’re going to discuss Power BI, which is a third-wave solution. Power BI enables EVERYONE to collect, analyze, visualize and publish data. This third wave has the potential to expand the reach of analytics to more users than ever before. Existing analytics platforms and tools can be extended, instead of being replaced, by full-featured solutions like Power BI. Power BI directly connects to existing on-premises data, such as Analysis Services tabular models that were created by business analysts in collaboration with IT. Microsoft Excel and the new Power BI Desktop work hand-in-hand with Power BI, publishing reports and models created by business analysts and getting them more easily in the hands of the business users who can gain insight and take action.
• #5 Power BI addresses three common business intelligence challenges that an organization may face: Getting an end-to-end view off what is happening — because data is often in disparate locations, it can be difficult for business users to see a complete picture of your business  Managing multiple data sources — Data residing in SaaS solutions and other external locations can be difficult to manage programmatically, or access and refresh securely Making the right data available to the right users at the right time Mobile business users need the latest operational data at their fingertips, no matter where they are or what device they’re using Different roles have different needs and access levels, so a one-size-fits all solution doesn’t work
• #6 Key message: Power BI is a business analytics service. With Power BI you can now see all of your data through a single pane of glass. Live Power BI dashboards and reports show visualizations and KPIs from data residing both on-premises and in the cloud, providing a consolidated view across your business regardless of where your data lives. Talking points: This is Power BI in a nutshell and the overall benefits to your business. We will look at what this means for the IT Pro and the key benefits for IT on the next slide
• #7 Key message: There are several capabilities that differentiate Power BI from other offerings in the market. Talking points: Power BI is a cloud-based analytics service that provides faster time to insight. It is used for visualizing, exploring and extracting insights from data. It brings together data from diverse sources to deliver rich, comprehensive views of business operations. What that means is, with Power BI, you can see all of your data through a single pane of glass, and create an analytics environment in minutes to monitor data and share reports. Live dashboards and reports show visualizations and KPIs from data that reside both on-premises and in the cloud, providing a consolidated view across your business regardless of where your data lives. There are several capabilities that are unique to Power BI – these include: Pre-built dashboards and reports for popular SaaS solutions such as Marketo, Salesforce, GitHub, ZenDesk, Dynamics CRM, and many others Dashboards and visualizations that support real-time updates Secure, live connection to on-premises data sources to drive insight across the entire range of organizational information (Analysis Services, Azure SQL Database, SQL Database Auditing, Azure SQL Data Warehouse) Automated scheduled refresh to keep your Power BI data in sync with on premises data sources Native mobile applications for keeping users connected on the go Easy integration with other Microsoft offerings, from Excel to Azure services Intuitive data exploration, which enables users to ask questions of their data in plain English To summarize, Power BI is a SaaS offering that enables anyone to easily connect to their data, create live operational dashboards and explore data via interactive visualizations
• #9 Let’s walk through an overview of how Power BI works. 1. The Power BI service, sometimes referred to as powerbi.com, is what allows you to: Create beautiful visualizations to tell compelling data stories Build rich, live dashboards that turn BI into business insights Create reports & datasets from which you can create visualizations and dashboards Enjoy the benefits of up-to-date data with real-time, automatic and scheduled refreshes Share dashboards easily with other people in your organization Ask questions of data in plain English with Natural Language Query Stay connected to your data all the time with mobile applications 2. Power BI connects to a variety of data sources. These range across both cloud and on-premises sources, and include: A variety of popular SaaS solutions, such as Marketo, Salesforce, GitHub, Dynamics CRM, Zendesk, and several others On-premises databases – Power BI offers live connectivity to SQL Server Analysis Services, which we’ll cover in more detail later. And using a gateway solution, Power BI can connect to other database solutions. Custom data sources – Power BI can connect to any data source you need it to thanks to its extensibility via REST APIs. This includes both proprietary corporate data sources, as well as external data services. For example, if you are a SaaS solution provider, you can work with Microsoft to connect your solution to Power BI. Other Azure services – Power BI integrates tightly with SQL Azure and Stream Analytics, and will be integrating closely with more Azure services over time Power BI Desktop and Excel files – Excel workbooks can be directly connected to Power BI.com, or may be used with Power BI Desktop. Power BI Desktop is a companion application to the Power BI service – it is a desktop tool that supports data analysis and reporting. Like Excel files, Power BI Desktop files may be uploaded to the Power BI service.
• #10 This slide can be used to categorize the Power BI features into different roles. During this course, different topics will be relevant to different roles – so it is good to define these early on.
• #11 Key message: Get started quickly with the Power BI service (powerbi.com) for faster decision-making by displaying all of your data in one place Talking points: As discussed earlier, you can get started quickly with pre-built content packs for popular SaaS solutions The primary capability of Power BI is that it empowers you to create and customize live dashboards – dashboards that include visualizations from multiple data sources That is, dashboards can show different types of data from a variety of sources, and can use a range of unique visualizations If applicable, you can track status in real-time thanks to support for real-time data sources You have full control over your dashboards – pin any visualization from any report to any dashboard Click through visualizations to access their underlying reports to discover more data and new insights
• #12 Como implantar o Power BI na minha empresa? A redbelt está presenteando x clientes com uma consultoria (4 horas) para ajudar a desenhar possíveis cenários de implementação do Power BI. Nossos especialistas irão até a sua empresa, entender um pouco mais do seu a dia a dia, entendendo as dores que as áreas de negócios tem. Ao final, será entregue um documento com os cenários de possíveis implementações.
• #13 O Projeto A RED BELT através de sua divisão de negócios RED AD implementou um ambiente de Business Intelligence utlizando SharePoint OnLine para a construtora Pacaembu. Situação de Negócio Formado pela Haus Construtora e pela Pacaembu Construtora, que somam mais de 20 anos de experiência no segmento de baixa renda, o Grupo Pacaembu atua na construção de empreendimentos residenciais destinados às classes C e D contempladas no programa “Minha Casa Minha Vida”, do Governo Federal. Buscando maior agilidade na tomada de decisão o Grupo Pacaembu buscou por tecnologia de ponta para agregar em seu dia a dia. A Solução A RED AD implementou uma solução de Business Intelligence (BI) utilizando o ambiente Cloud da Microsoft (Azure), a fim de ampliar e agilizar a tomada de decisão da organização. Com a solução o Grupo Pacaembu possui relatórios gerenciais customizados e exclusivos, que permitem analisar os dados do seu ERP com uma visão que o próprio ERP não disponbiliza. Os cubos criados pela redbelt, possibilita que o usuário crie inúmeras combinações de informações (visões), facilitando a compreensão dos resultados. Com esta solução, foi possível reverter o tempo que os usuários “perdiam” criando relatórios no Excel concilando varios relatórios do ERP. Tecnologias: Microsoft Integration Services (SSIS) Microsoft Analysis Services (SSAS) Windows Azure SharePoint OnLine Office 365 Power BI Benefícios: Criação de novas visões (indicadores) Tomada de decisão pro ativa Agilidade no acesso de dados gerenciais Dados personalizados