-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpowerbi.html
137 lines (125 loc) · 8.11 KB
/
powerbi.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.2/css/bootstrap.min.css" integrity="sha384-Smlep5jCw/wG7hdkwQ/Z5nLIefveQRIY9nfy6xoR1uRYBtpZgI6339F5dgvm/e9B" crossorigin="anonymous">
<title>data.world and Microsoft Power BI</title>
<link href="https://fonts.googleapis.com/css?family=Roboto:400,400i,700,700i" rel="stylesheet">
</head>
<body style="color:#333D49;">
<!--jumbotron header-->
<div class="header" style="background:#333D49; max-height:150px;">
<div class="container p-responsive py-6 py-lg-10 text-center" style="color:#fff;">
<img src="dw+pbi_light.png" class="mb-3 mb-sm-5 col-6 col-sm-12" style="max-width:550px;">
</div>
</div>
<!--first intro-->
<div class="container align-items-center text-center form-group align-items-center" style="padding-bottom:1em;padding-top:4em;">
<h1 style="font-weight:400"> You've enabled Microsoft Power BI, now what?</h1>
<p class="h5" style="font-weight:300"> Microsoft Power BI gives you a powerful platform to analyze, manipulate, and visualize your data..
</p>
</div>
<!--first section-->
<div class="container" style="padding-bottom:1em;padding-top:2em;">
<div class="row">
<div class="col">
<h2 style="font-weight:400"> Connect data.world to Microsoft Power BI.</h2>
<p class="h5" style="font-weight:300"> Using the data.world connector from Power BI desktop, you can easily retrieve data from data.world:</p>
<ol style="list-style-position: inside;">
<li style="padding-bottom:1em; font-weight:300; padding-top:3em;"><a href="https://powerbi.microsoft.com/en-us/desktop/" target="_blank">Download</a> Power BI Desktop.
</li>
<div class="alert alert-warning col-sm-9" style="margin-top:1em; font-weight:300;">
<i>Please note that Microsoft Power BI is currently available only on Windows. You'll need to be running a Windows OS or a virtual machine on your Mac OS.</i>
</div>
<li style="padding-bottom:1em; font-weight:300; padding-top:1em;">Open Power BI and choose <b>Get Data</b>, then select <b>data.world</b> and connect.
</li>
<div class="col-sm-9" style="padding-top:2em;">
<img src="powerbi_connect.png" class="img-fluid rounded" style="box-shadow:7px 7px 30px grey;">
</div>
<li style="padding-bottom:1em; font-weight:300; padding-top:3em;">Configure your data, you'll need to enter the Owner, Dataset ID, and any desired queries, and click <b>OK</b>.
<div class="alert alert-secondary col-sm-8" style="margin-top:2em;">
<b>Example:</b> <i>Using <a href="https://data.world/associatedpress/foreign-exchange-rates" target="_blank">https://data.world/associatedpress/foreign-exchange-rates</a>.</i>
<div class="alert alert-light col-sm-8" style="margin-top:1em;">
<ul style="list-style-position: inside;"">
<li style="font-weight:300; padding-top:1em;"><b>Owner:</b> <code>associatedpress</code></li>
<li style="font-weight:300;"><b>Dataset ID:</b> <code>foreign-exchange-rates</code></li>
<li style="padding-bottom:1em; font-weight:300;"><b>Query:</b> <code>SELECT * FROM quarterly</code></li>
</ul>
</div>
</div>
<div class="col-sm-9" style="padding-top:2em;">
<img src="powerbi_get-data.png" class="img-fluid rounded" style="box-shadow:7px 7px 30px grey;">
</div>
</li>
<li style="padding-bottom:1em; font-weight:300; padding-top:1em;">Log in with either your API token (from <a href="https://data.world/settings/advanced" target="_blank">dataworld advanced settings</a>) or using OAuth sign-in.
</li>
</ol>
</div>
</div>
</div>
<!--second section-->
<div class="container" style="padding-bottom:1em;padding-top:2em;">
<div class="row">
<div class="col">
<h2 style="font-weight:400"> Preview and refine your data.</h2>
<p class="h5" style="font-weight:300"> Preview your data and use the query editor to apply any desired changes before loading data into Microsoft Power BI. </p>
</div>
</div>
</div>
<div class="container">
<div class="row">
<div class="col">
<ol style="list-style-position: inside;">
<li style="font-weight:300; padding-top:3em;">When your data preview appears, click <b>Edit</b> to make any changes to your query. You can now make changes including removing rows & columns, merging queries, grouping data, and more.
</li>
<div class="row">
<div class="col-sm-9" style="padding-top:2em; padding-bottom:3em;">
<img src="powerbi_edit-data.png" class="img-fluid rounded" style="box-shadow:7px 7px 30px grey;">
</div>
</div>
<li style="font-weight:300;">When you're satisfied with your query, select <b>Close & Apply</b> from the top left corner of your window.
</li>
<li style="font-weight:300; padding-top:1em;">Start creating reports!
</li>
<div class="col-sm-9" style="padding-top:2em;">
<img src="powerbi_chart.png" class="img-fluid rounded" style="box-shadow:7px 7px 30px grey;">
</div>
</ol>
</div>
</div>
</div>
<!--what's next-->
<hr style="margin-top:4em;">
<div class="container" style="padding-bottom:1em; padding-top:1em;">
<div class="row">
<div class="col">
<h2 style="font-weight:400; padding-top:1em;"> What next?</h2>
<p class="h5" style="font-weight:300"> Here are a few things you can do with Microsoft Power BI and data.world:</p>
<ul style="list-style-position: inside; padding-top:2em;">
<li style="padding-bottom:1em; font-weight:300;">Publish your report to the Power BI community, embed it into your website, or share it back to data.world using the <b>Power BI report URL</b>.
</li>
<li style="padding-bottom:1em; font-weight:300;">
Configure a scheduled refresh for data.world queries so they're always up to date.
</li>
<li style="font-weight:300;">Customize your queries to make them ideal for analytics, including pivoting or un-pivoting the data, adding date calculations, and more.</b>.
</div>
</li>
</ul>
</div>
</div>
</div>
<!--footer-->
<div class="jumbotron-fluid text-center align-items-center border-top" style="margin-top:3em; padding-top:3em; padding-bottom: 3em; background-color:#F2F2F2; color:#36454f">
<h4 style="font-weight:300"> Want to see more information on the data.world + Microsoft Power BI Integration? <u><a href="https://powerbi.microsoft.com/en-us/blog/connect-to-tens-of-thousands-of-datasets-on-data-world-with-the-new-connector-for-power-bi-desktop-and-join-the-webinar/" style="color:#36454f; font-weight:600;" target="_blank">check it out here</a></u>.
</h4>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.2/js/bootstrap.min.js" integrity="sha384-o+RDsa0aLu++PJvFqy8fFScvbHFLtbvScb8AjopnFD+iEQ7wo/CG0xlczd+2O/em" crossorigin="anonymous"></script>
</body>
</html>