In the fourth video of our Power BI series we will show you how to easily edit data in Power BI.
Power BI has the ability to create Tables and Reports in minutes, which can then be shared via the cloud.
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.
Power BI for Office 365 is Microsoft's latest Business Intelligence solution. It is cloud-based and works from within Excel and Office 365, to analyse and visualise data quickly and easily.
The BI solution is designed to help business users gain insights from their data and, according to Microsoft, includes the following:
- Power Query
- Power Map
- Power Pivot
- Power View
Discover how Power BI makes data analysis much simpler!
Find out how the Excel "Power" Tools - Power Pivot, Power Query and Power View - can change your life!
Learn more about Excel Pivot Tables and how they can make you 80% more productive in 20% of the time.
Many people worry that creating a PivotTable is time consuming, but if you have a well-organised data source, you can create a PivotTable in a snap.
Tables and PivotTables are a great match! When you use a table as source data for a PivotTable, Excel will automatically expand and shrink the table as you add or remove data, so your PivotTable will always stay in sync with your data.
You might think you have to be working with numbers to use a PivotTable but, by default, a PivotTable will count any text field.
When you've created a PivotTable from data in the same worksheet, you can remove the data if you like and the PivotTable will continue to function. Each PivotTable has a pivot cache that contains an exact duplicate of the data used to create the PivotTable.
Although PivotTables can automatically group data in many ways, you can also group items manually.
One of the most powerful features of PivotTables is the ability to group data by numbers. You can use this feature to group by age range, price range, or any numerical range that makes sense in your data.
When you add fields to a PivotTables, the PivotTable will display the name that appears in the source data. Value field names appear with "Sum of" or "Count of" at the start.
It may seem counterintuative, but you can add the same field to a PivotTable more than once. In fact, there are situations where you'll want to do just that.
Anytime you add a value field to a PivotTable, make sure you set the number format on the field itself.
Anytime you see a subtotal or grand total in a PivotTable, you can easily get to the exact data that makes up that value using the "drill down" feature built in to any PivotTable.
ExcelBusinessIntelligence.com offers two Pivot Tables courses
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.
What did he mean?
A young man approached the foreman of a logging crew and asked for a job.
“Let’s see you fell this tree first” said the foreman. The young man stepped forward and skillfully felled the large tree. The foreman was impressed and said to the young man: “You can start on Monday.”
Monday, Tuesday and Wednesday came and went. On Thursday afternoon the foreman came to the young man and said: “You can pick up your pay-check on your way out today.” Startled the young man exclaimed, “But I thought you paid on Friday!” “That’s right,” said the foreman, “but we are letting you go today because you have fallen behind. Our daily felling charts show that you have dropped from first place on Monday to last place today.”
“But I work really hard,” said the young man. “I arrive early, I leave late and I even work through my breaks. Please don’t just fire me.”
The foreman knew this to be true, and sensing the young man’s integrity, stopped and thought for a bit. Then he asked: “Have you been sharpening your axe?”
The young man replied: “No sir. I have been working too hard to take time for that.
Work smarter, not harder.
At ExcelBusinessIntelligence.com we will show you how to make Excel do the work for you instead of you doing the work for Excel.
Ian Littlejohn worked as a Management Consultant for 15 years and is passionate about teaching business people to analyze data and understand business data.