Data Architecture

Data Architecture

Issued by Southern Alberta Institute of Technology

By earning this credential, you've gained insights into data solution delivery. You have used Power BI for data analysis and querying databases and you explored on-premise solutions like SSIS and SSAS. To cap it off, you delved into real-time data analytics and examined data-analytics pipelines.

Skills

Earning Criteria

  • Perform data analytics in Azure to ingest, process, transform, and analyze large datasets, in order to produce visualizations and reports.
  • Build a simple Power BI dashboard.
  • Present the Power BI dashboard so that value of the data is communicated to the organization.
  • Differentiate SSIS, SSAS, and SSRS as part of an on-prem solution.
  • Perform data analysis through Excel, using basic worksheet modeling, creating and managing range names, employing Lookup functions, and INDEX and MATCH functions
  • Assignment 1: Explore Data Analytics in Azure
  • Assignment 2: Build Power BI Dashboard
  • Assignment 3: Present Data Visually to an Audience
  • Quiz: SSIS, SSAS, and on-prem concept
  • Assignment 4: Excel Spreadsheet using Open Data