Database Analysis and Design - PDF

CRICOS 00111D
TOID 3059
Database Analysis and Design
Week 04
Power BI - Importing Data, Visualizations, and
Access and Power BI functions

Microsoft Power BI 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

Microsoft 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.

Microsoft Power BI Desktop Business Intelligence software.
•Power BI Desktop is a Windows
only application.
Problem:
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.

Microsoft Power BI help 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?
https://support.office.com/en-us/article/What-version-of-Office-am-I-using-932788b8-
a3ce-44bf-bb09-e334518b8b19
Resolve Issues Importing Access Databases in Power BI Desktop
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-
errors/
Download Microsoft Power BI Desktop
https://www.microsoft.com/en-in/download/details.aspx?id=45331

Microsoft Power BI DesktopIn 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.

Microsoft Power BI Desktop 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).
We will concentrate on connecting to Access
Database sources.
If you cannot connect to Access (usually because of the 32bit
vs 64 bit problem), then you will need to export data from
tables to a CSV files. Finally you will import the CSV files into
Power BI Desktop. A bit messy – but easily done.

Microsoft Power BI Desktop Typically, you will have to choose which tables you want to connect to.
You can also connect to queries (or views as they are called in other RDBMSs)
There is no difference between a Table and a Query from the Power BI point of view.
Both present data as a collection of records made up of multiple fields.