Over the course of the next few weeks we're going to be releasing a series of videos in our "Complete Introduction to" series. The idea behind the series is to provide a comprehensive introduction to a variety of different data analysis and business intelligence tools and techniques so that business users can fully understand the tools available to them, and how they can work smarter not harder.
The first video for the series will introduce you to Microsoft Power BI.
One of the biggest selling points of Microsoft Power BI is that, because it's based on the Excel platform, the millions of Excel users working with data on a daily basis will find it easy to navigate and not be intimidated by this incredibly powerful tool.
You will see how quickly and easily I produce an interactive report from an Excel spreadsheet using Microsoft Power BI. An Excel spreadsheet of Sales data has been used as the source of the data, but data from many different sources such as databases, .csv and Web sources can just as easily be used.
In the video you'll see how easy it is to format tables of data, perform more advanced functions, like cross filtering, and add visualisations, such as column charts, line graphs and pie graphs, resulting in a detailed, interactive sales report emerging in minutes!
The Microsoft Power BI Query Editor gives you a wide variety of options that allow you to transform, manipulate and prepare your data. It allows for perform simple and advanced tasks such as:
A big component of Power BI is it's unique programming formula language called DAX but don't be put off because, as I said at the beginning, Power BI is based on Excel, so many of the DAX formulas are the same and when you start using Power BI you should find yourself picking it up very quickly.
At the end of the video I show you how to publish the report into the Power BI Service. The Power BI Service allows you to share the report to other users using a web browser, smartphones or tablets. I also show how to create a dashboard in the Power BI Service which makes it easier to access your content through mobile devices.
Last but not least, I demonstrate how to use natural language queries (Q&A) to ask questions of your data. This powerful feature allows you to type in questions in a natural way and have Power BI provide the answers to them. I can ask 'What is my total Sales?' or 'What is my Sales in Italy?'and take it even further by asking 'What is my Sales by Product Category in Italy as a Column graph? This function fundamentally changes that way that users can interact and ask questions of their data.
In the fourth video of our Power BI series we will show you how to easily edit data in Power BI.
Power BI Desktop puts visual analytics at your fingertips with intuitive reports and dashboards.
Using drag-and-drop to place content exactly where you want it on the canvas allows you to quickly discover patterns as you explore a single view of linked, interactive visualizations.
Discover how Power BI makes data analysis much simpler!
There is no shortage of data available today, with huge amounts of it being constantly generated by ERP systems, POS systems, PLC systems and Biometric systems, to name but a few.
Companies are needing to find ways to effectively analyse the data, to leverage the information and make informed decisions, however many of the options available are very expensive and require a lengthy period of implementation, plus human natures makes most staff resistant to learning new systems so all in all, decision makers are faced with a challenge on many levels.
Excel has become the main tool for manipulating and analyzing data, and developing reports in business today, and with the release of Excel 2013, Microsoft introduced even more powerful business intelligence tools.
To understand how the Excel Business Intelligence tools work together in Excel 2013, you need to understand the function of each tool and how it fits into the “traditional” Excel model.
Extract, Transform, Load
Power Query is an intuitive, easy to use tool for importing, transforming and working with data.
Spreadsheets are the basic feature of Excel. Launched in 1985, there are now over 700 million Excel users worldwide.
Tables were introduced in Excel 2007, they allow you to do quick sorting and analysis of your data.
Power Pivot was introduced as a free add-in for Excel 2010, it gives you the ability to access, process and handle well over a million rows of data, more than a standard spreadsheet can process.
Pivot Tables are an easy and convenient way to build intelligent, flexible summary tables, allowing you to quickly derive insight from your business data.
Pivot Charts enable you to visualize a PivotTable. You can quickly change a portion of data displayed, making PivotChart ideal for presentation of data in reports.
Power View is an interactive data exploration, visualisation and presentation tool that gives you strong insight in to your business .
So what is the bottom line?
Before spending time and money on new data analysis tools, find out exactly how learning how to use all the Excel Business Intelligence Tools effectively will allow you to quickly and easily analyse your data and gain insight into it without any major resource investments.
Over a billion people around the world use Excel today, far more users than any other BI vendor can claim.
This is the first video in a five-part series showing you how powerful the Excel "Power" tools are and how learning to use them can vastly improve your productivity, while at the same time giving you insight into your business far beyond anything you ever imagined.
‘five seconds to sign up, five minutes to wow!’
Following six months of public preview and a continuous flow of user-driven enhancements from their rapidly growing community, Friday 24 July marked an exciting milestone for Microsoft as they officially released the new Power BI service and Power BI Desktop.
Over 500,000 unique users from 45,000 companies across 185 countries helped shape the new Power BI. Add to the already impressive list of features and capabilities the advances in their Power BI service and the new Power BI Desktop, there really is plenty to talk about!
But the news doesn’t stop there.
They’re rolling out new content packs weekly, ensuring that business users can connect to and experience data without technical setup. This means you can connect to your data in popular services like Quickbooks and Salesforce, and view a curated collection of dashboards and reports that continuously update with the latest data from these services.
They’ve also contributed their Power BI visualization framework and its complete library of visuals to the open source community to enable everyone to easily extend and build custom visuals. The project is available on GitHub, and in the future, anyone will be able to extend and bring custom visuals into Power BI for use in their dashboards, reports and content packs.
Power BI sets the standard for modern business intelligence and Microsoft wants us to change the way we do business and experience the cloud-hosted, business intelligence and analytics service for ourselves.
At the Boys & Girls Clubs of Greater Fort Worth in Texas they are using Power BI to understand how their various programs are performing and their impact on the kids they serve. With a mission to change each kid’s life for the better, the leaders at the Boys and Girls Club use Power BI to see their data update in real time and discover new insights visually to take action.
At Metro Bank in London, the team is using Power BI to quickly and accurately provide information to guide analysis and decision-making as they set out to create fans, not customers.
With all the new features and capabilities they’re delivering today, plus their commitment to a weekly release cadence, it’s time to join the 500,000+ people who have tried Power BI to start discovering the stories your data will tell.
Find out more, watch our Power BI Intro now.
The business world has changed fundamentally over the past few years.The speed of change means that mangers need to be able to make decisions quicker, but at the same time need to be able to process far more data to be able to make an informed decision.
Business today has no lack of data – transactional systems record every part of the business process. The key challenge for managers is how to turn the vast quantities of data into useful insight and information.
In recent years new technologies has allowed vast quantities of data to be processed, analysed and increasingly visualised. The new technologies allow management to understand trends, identify outliers and to see new patterns in the data that could not be processed previously.
Excel as a Business Intelligence Tool
Excel has become the main tool for manipulating and analysing data, and developing reports in business today. With the release of Excel 2013, Microsoft introduced even more powerful business intelligence tools.
To understand how the Excel Business Intelligence tools work together in Excel 2013, you need to understand the function of each tool and how it fits into the “traditional” Excel model:
How is this relevant to Business Users?
If you work with Excel, using Spreadsheets and Tables to build reports, you probably find yourself regularly copying and pasting data between worksheets then clicking the same sequence of buttons to clean and shape the data.
You’ve probably found that complex formulas, dirty data and inevitable errors take up a lot of your time, making month end reports a nightmare that consumes large portions of time you don’t have.
Learning how to use all the Excel Business Intelligence Tools effectively will free you from the dull, repetitive tasks and give you time to focus on what’s important, analyzing your data and gaining insight into it.
This will enable you to make good decisions about your business.