Data Science

Module 9: Enhance reports for usability and storytelling in Power BI

This module will teach you about paginated reports, including what they are how they fit into Power BI. You will then learn how to build and publish a report.

Lessons

Paginated report overview

Create Paginated reports

Lab : Creating a Paginated report in Power BI Desktop

Use Power BI Report Builder

Design a multi-page report layout

Define a data source

Define a dataset

Create a report parameter

Export a report to PDF

Module 10: Perform Advanced Analytics in Power BI

This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.

Lessons

Advanced Analytics

Data Insights through AI visuals

Lab : Data Analysis in Power BI Desktop

Create animated scatter charts

Use the visual to forecast values

Work with Decomposition Tree visual

Work with the Key Influencers visual

Module 11: Manage Datasets in Power BI

In this module you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.

Lessons

Parameters

Datasets

Security in Power BI

Module 12: Create and Manage Workspaces in Power BI

This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.

Lessons

Creating Workspaces

Sharing and Managing Assets

Lab : Publishing and Sharing Power BI Content

Map security principals to dataset roles

Share a dashboard

SQL

1. Introduction & Setup
   • Understanding SQL and databases
   • Key concepts of schema, tables, columns, primary keys, and foreign keys
   • Installation of SQL Server
   • Installation of SQL Server Management Studio (SSMS)
   • Sample company-wide DB setup (Adventure Works Cycle)
2. Introduction to relational and non-relational databases
   • Relational databases like MS SQL, MySQL, and PostgreSQL
   • Non-relational databases
   • SQL is useful across all,  including big data platforms
3. Building a relational SQL DB Table from scratch
   • CREATE TABLE to build from scratch
   • ALTER TABLE to modify table structure
   • DROP TABLE to delete table
   • INSERT INTO statement to add new rows of records
   • UPDATE statement modify existing rows of records
   • DELETE statement to remove rows of records
4. SELECT statement for data analysis
   • Basic SELECT statement
   • SELECT DISTINCT
   • SELECT TOP
   • WHERE clause
   • Multiple WHERE conditions
   • ORDER BY
   • GROUP BY
   • HAVING
   • Understanding when to use WHERE vs. HAVING
5. Logical Operators
   • AND
   • OR
   • NOT
   • IN
   • BETWEEN
   • LIKE
   • CASE
6. Advanced data manipulation
   • Carrying out mathematical operations
   • Using alias
   • JOIN and the different types
   • UNION, INTERSECT and EXCEPT
   • LIKE wildcards
   • Subqueries
   • Common Table Expressions (CTE)
   • String functions
   • Numbers formatting
   • Date formatting
7. Views and stored procedures
   • Use of views
   • How to create views
   • Use of stored procedures
   • How to create stored procedures
   • Exporting tables as stored procedures
8. Understanding SQL and database performance
9. Extensive practical tasks