https://wiki.measure.chat/index.php?title=BI-Tools&feed=atom&action=historyBI-Tools - Revision history2024-03-29T15:19:12ZRevision history for this page on the wikiMediaWiki 1.34.1https://wiki.measure.chat/index.php?title=BI-Tools&diff=320&oldid=prevMikeharmanos: Getting started with BQ2019-01-28T17:18:48Z<p>Getting started with BQ</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 17:18, 28 January 2019</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l29" >Line 29:</td>
<td colspan="2" class="diff-lineno">Line 29:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Tableau ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Tableau ==</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Big Query (BQ) ==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">''How does one get started with BigQuery?</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">''</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">@simoahava answered "Take the SQL track on Mode Analytics. The From Data To Insights specialization on Coursera has quite a bit of BigQuery lessons (it’s self-paced and you’re in charge of how much you want to apply your learnings in the labs), but it does require a solid grasp of SQL basics.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">That’s the only course for BQ I’m familiar with - and it was pretty good in diving into its idiosyncrasies."</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">https://mode.com/sql-tutorial/</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">https://www.coursera.org/specializations/from-data-to-insights-google-cloud-platform</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">@simoahava then says "The Data Engineering on GCP specialization on Coursera also has BQ lessons but they’re more about how BQ fits into the entire data pipeline and less about how BQ works. But the idiosyncrasies aren’t that far removed from standard sql. It’s the columnar table format that requires the biggest mind shift from working with relational tables. Get well acquainted with how to work with structs and repeated fields, and how analytical window functions work. These are covered in the Coursera specialization."</ins></div></td></tr>
</table>Mikeharmanoshttps://wiki.measure.chat/index.php?title=BI-Tools&diff=124&oldid=prevMikorotkov: Undo revision 123 by Mikorotkov (talk)2018-06-07T07:47:18Z<p>Undo revision 123 by <a href="/index.php/Special:Contributions/Mikorotkov" title="Special:Contributions/Mikorotkov">Mikorotkov</a> (<a href="/index.php?title=User_talk:Mikorotkov&action=edit&redlink=1" class="new" title="User talk:Mikorotkov (page does not exist)">talk</a>)</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 07:47, 7 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6" >Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi Analyzing and Visualizing Data with Power BI] - The eDX course is free and good as a first overview, but doesn't go in-depth on DAX or M.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi Analyzing and Visualizing Data with Power BI] - The eDX course is free and good as a first overview, but doesn't go in-depth on DAX or M.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[http://enterprisedna.co/ EnterpriseDNA] - have a good/great YouTube channel for specific examples but also have a Complete Beginners training for Power BI and one for DAX which are good groundings and free. <del class="diffchange diffchange-inline"><ref> Suggested by Tim Stewart, [http://www.trsdigital.com/] </ref></del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[http://enterprisedna.co/ EnterpriseDNA] - have a good/great YouTube channel for specific examples but also have a Complete Beginners training for Power BI and one for DAX which are good groundings and free.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Books ===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Books ===</div></td></tr>
</table>Mikorotkovhttps://wiki.measure.chat/index.php?title=BI-Tools&diff=123&oldid=prevMikorotkov at 07:46, 7 June 20182018-06-07T07:46:42Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 07:46, 7 June 2018</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6" >Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi Analyzing and Visualizing Data with Power BI] - The eDX course is free and good as a first overview, but doesn't go in-depth on DAX or M.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi Analyzing and Visualizing Data with Power BI] - The eDX course is free and good as a first overview, but doesn't go in-depth on DAX or M.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[http://enterprisedna.co/ EnterpriseDNA] - have a good/great YouTube channel for specific examples but also have a Complete Beginners training for Power BI and one for DAX which are good groundings and free.</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[http://enterprisedna.co/ EnterpriseDNA] - have a good/great YouTube channel for specific examples but also have a Complete Beginners training for Power BI and one for DAX which are good groundings and free. <ins class="diffchange diffchange-inline"><ref> Suggested by Tim Stewart, [http://www.trsdigital.com/] </ref></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Books ===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Books ===</div></td></tr>
</table>Mikorotkovhttps://wiki.measure.chat/index.php?title=BI-Tools&diff=122&oldid=prevMikorotkov: Created BI tools page and Power BI section2018-06-07T07:43:40Z<p>Created BI tools page and Power BI section</p>
<p><b>New page</b></p><div>If it is about Tableau and other BI tools (Cognos, Microstrategy, Pentaho, Domo, Qlikview, Power BI) it lives here.<br />
<br />
<br />
== Power BI ==<br />
=== Video Tutorials ===<br />
[https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi Analyzing and Visualizing Data with Power BI] - The eDX course is free and good as a first overview, but doesn't go in-depth on DAX or M.<br />
<br />
[http://enterprisedna.co/ EnterpriseDNA] - have a good/great YouTube channel for specific examples but also have a Complete Beginners training for Power BI and one for DAX which are good groundings and free.<br />
<br />
=== Books ===<br />
<br />
[https://www.sqlbi.com/books/the-definitive-guide-to-dax/ The Definitive Guide to DAX (Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI)] by Marco Russo and Alberto Ferrari<br />
<br />
[https://www.amazon.com/Power-Pivot-BI-Excel-2010-2016/dp/1615470395 PowerPivot and PowerBI The Excel Users Guide to DAX] by Rob Collie and Avichal Singh<br />
<br />
[https://www.amazon.com/Data-Monkey-Guide-Language-Excel/dp/1615470344 M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query] by Ken Puls and Miguel Escobar<br />
<br />
[https://www.goodreads.com/book/show/17707018-powerpivot-alchemy PowerPivot Alchemy: Patterns and Techniques for Excel] by Bill Jellen and Rob Collie<br />
<br />
=== Blogs ===<br />
<br />
[https://powerpivotpro.com/ powerpivotpro] - a general go to source. You tend to find a lot of the other industry experts contribute or help out in the comments.<br />
<br />
[https://www.sqlbi.com/ sqlbi] - Marco Russo and Alberto Ferrari covering DAX/SSAS/MDX<br />
<br />
[https://www.excelguru.ca/blog/ Excelguru] - blog by Ken Puls (M and Excel related topics)<br />
<br />
[https://www.kasperonbi.com/ Kasper on BI] - All about BI, Modelling, DAX and MS BI by Kasper de Jonge<br />
<br />
== Tableau ==</div>Mikorotkov