Source Training - Team #3

Last Modified: October 08, 2021 by Alloway,Hunter

Power BI

Resource: https://www.youtube.com/watch?v=TmhQCQr_DCA

Key Points: Shaping Data and Building a Data Model from it Merge multiple tables and draw relations between the two depending on column names and associated values

Lean Power BI-Microsoft https://docs.microsoft.com/en-us/learn/modules/introduction-power-bi/1-introduction

Key Points: Datasets, reports and dashboards Purpose of a dashboard: See all information at a glance Monitor important info Ensure all team members have a reviewed a revision Personalized view to monitor defined system “health”

These are organized into workspaces and created on capacities. These capacities are the way in which the content of the organized data is delivered. Workspaces are also a collaborative environment that enable users to work together on projects similar to the “issues” feature on Github. All member require a pro license

Datasets that can be imported represent single sources of data. For example, a spreadsheet outlining the cookie sales for a corporation within the past month, including elements such as stock, sale price, shipping destination etc. Built-In Text/CSV File Import from the home ribbon:

ELK Stack

Resource 1:Crash Course to ELK stack using “Terminal” https://www.youtube.com/watch?v=gS_nHTWZEJ8

GitHub Resource that Lisa Created that Includes: Beginner Crash Course to Elk stack Step-by-step coding tutorial youtube playlist Free Elastic Cloud Trial Link General Instructions Blog post 1 & 2 for how to use ELK stack Recording of live workshop https://github.com/LisaHJung/Part-1-Intro-to-Elasticsearch-and-Kibana

Discover Screen: Time Stamped data intake from most recent document We can view the most recent ingested data log files Elasticsearch adds data as a JSON (values and arrays stored using human wording to assign values to objects) known as a document