Now we will be doing all of our data analysis and modelling in Power Pivot.
So first things first. To enable Power Pivot in Excel, go to File -> Options -> Add-ins
In the Manage section at the bottom, choose COM Add-ins -> Go -> and then make sure you select Microsoft Power Pivot for Excel.
Through a series of posts, I will be using the data of a fictitious company called VanArsdel Ltd. to illustrate how you can use the different Microsoft BI tools with business-oriented data, reports and dashboards.
Throughout the series, I will be using Excel to collect and organize the data from different sources (will be Access DB in this case), use PowerPivot to build the data model and finally use Power BI to visualize and further explore the data.
As the title implies, a new add-in has been developed by Microsoft (as a garage project actually) to help transform data in seconds.
It’s mainly targeting Excel users who face problems in data wrangling; that is transforming raw data into a different format so that it can be used for further analysis. Usually this task is one of the most tedious tasks for any Excel user since the data could be coming from different sources in different formats and the cleaning process to make it all "homogeneous" could be a little bit daunting with too many functions and formulas included.
Today, businesses are drowning in data. Companies are generating more data from more data sources than ever before, yet they are struggling to extract actionable insights from this data.
From boardroom executives to frontline operation managers, the uncertain economy has highlighted the necessity—and the benefits—of making informed decisions.
To cut costs, streamline operations, and fuel continual process improvements, employees must be empowered to make better decisions at every level in the organization.
Critical business data needs to be accessible to all employees, so that they can perform their own analyses and freely share insights with team members.
With access to relevant data, employees can find opportunities to operate more efficiently and grow revenues, so the company can emerge stronger from any economic environment.
For many years now, Microsoft has been providing a variety of Business Intelligence (BI) tools that can address key business workloads. In addition to Microsoft, there is a wide range of other BI tool vendors in the market that address the increasing analytics needs of businesses and individuals, including Tableau, Qlik, IBM, Tibco and many others.
However, I've decided to go with Microsoft BI tools, for 5 simple reasons: they are very powerful, affordable, easy to use, accessible to almost everyone with a PC and MS Office, and on top of that, they are leading the BI market. Check out the reports below from Gartner and Forrester - two of the largest technology analysts in the world - comparing different BI platforms in the market today.