CRICOS 00111D TOID 3059 INF10002 Database Analysis and Design Week 04 Power BI - Importing Data, Visualizations, and Access and Power BI functions
Introduction and Getting Started Power BI | Versions | Issues | Start Up
Microsoft have a number of Business Intelligence (BI) products / applications Power BI is a suite of desktop & cloud based web application that allows you to analyze datasets The datasets can be local or cloud based and may be connected to / imported from RBDMSs, Spreadsheets, on-line data services etc. Power BI can be added to the Office 365 suite of applications. Through Power BI web app, users can analyze data with various visualizations and dashboards . One dataset may produce many different visualizations – Best performing customers – Worst preforming sales people – Upward trending products – Complimentary product sales Introducing MS Power BI
Power BI Desktop is a different product from Power BI web app Desktop is a Windows application It must be installed on a computer running Windows (or via a virtual Windows OS on a MAC or Linux) Importing data / manipulating data / writing formula / creating measures is done using the Desktop app Once visualizations / reports / dashboards have been created, then they are deployed to a cloud service so that Power BI web app can be utilized. Power BI Desktop is most often used by BI analysts & developers Power BI web app is used by end-users and BI analysts . Desktop vs. Web Version
Power BI Desktop is a Windows only application One known problem exists when PBI connects to an Access Database: Both apps must be the same OS version – If Access is 32bit then download Power BI 32 bit – If your Access is 64 bit then download Power BI 64 bit All Swinburne labs have 64bit Access and 64 bit Power BI Desktop installed. Version Problem
Setup Help with Power BI If you plan to install a version of Power BI on your own computer, then these links may be useful: What version of Office am I using? – - a3ce-44bf-bb09-e334518b8b19 Resolve Issues Importing Access Databases in Power BI Desktop – - errors/ Download Microsoft Power BI Desktop –
Our Scope In the next week or two, we will concentrate on Power BI Desktop. We will create datasets, reports, dashboards. We will not deploy / upload reports & dashboards to a cloud service yet.
Getting Started Begin the Power BI Desktop application Start with selecting the Get Data option The application can connect to / import data from many popular sources (including non-Microsoft applications).
You've reached the end of your free preview.
Want to read all 41 pages?
- One '18
- Visualization, 64-bit