Excel BI
ONLY FOR LOGGED-IN USERS
Easy
Video
Excel BI
12 Lessons
0% Not started
Ready?
Excel BI
ONLY FOR LOGGED-IN USERS
Big Data - actionable business intelligence
ONLY FOR LOGGED-IN USERS
Business Intelligence is about transforming your data into actions. The end game: Improve productivity and or return on investment.
ONLY FOR LOGGED-IN USERS
Power Query is a tool that allows you to extract and important data into Excel for further analysis. For example, websites, CRM, accounting software, databases to name just a few.
ONLY FOR LOGGED-IN USERS
Microsoft Power Pivot is a tool to build relationships between database tables. Doing so enables us to ask powerful questions of our data. To clarify our objective for Power Pivot. We are appending merging, combining tables into a data model but I should emphasis our tables remain separate. The key learning point here is we are building relationships to allow us, to interrogate our, data.
ONLY FOR LOGGED-IN USERS
Excel Maps, applied to MS Power BI
ONLY FOR LOGGED-IN USERS
Like Power Query and Power Pivot, Power View is another Excel self-service tool. Like Power Pivot we can build tables, charts, maps in Power View. However, Power View takes it a step further by allowing us to create remarkably integrated and multifaceted reports.
ONLY FOR LOGGED-IN USERS
MS Power BI gives us the ability to share power query and power view data with others who may be members of the team or with members who work with different teams.
ONLY FOR LOGGED-IN USERS
Modelling Your Data using Power Pivot
ONLY FOR LOGGED-IN USERS
A pivot table is a data visualisation tool to summarise data. Users can control pivot table and or chart data by dragging and dropping fields graphically.
ONLY FOR LOGGED-IN USERS
Expanding the data model in Microsoft Excel 2016 power pivot In this presentation I use Microsoft Contoso free retail database.
ONLY FOR LOGGED-IN USERS
Presenting data graphically can help an audience to easily grasp complex numerical data.
ONLY FOR LOGGED-IN USERS
Building and formatting power view reports.
Follow
About the teacher
Christopher Bird
Building your own Power App, BI solution, or automated workflow can be a mind-blowing experience. It can also be a nightmare. Particularly when you begin with a blank screen. My advice, get professional help as and when you need it. That's what successful people do.