Lesson 1: Welcome and Course Overview
Introduction to Analytics - Why every organization run on 2 system
Introduction to Data Literacy - Data Generation
Understanding Data Storage
Understanding Data Structure and the 7 golden rule of data management
Overview of Data Analysis
Data Fundamentals
Lesson 1: Getting Started with Power BI
Downlaod Course Materials
Secret to building amazing dashboard with Power BI
Data Preparation with Power BI
Understanding Data Modelling in Power BI
Introduction to Dax Framework - Anchor
Introduction to Dax Framework – Time Intelligence
Introduction to Dax Framework – Variance Measures
Dashboard design with Power BI – Home Page Design
Dashboard design with Power BI – Product Page Design
Dashboard design with Power BI – Deep Insight Page Design
Dashboard design with Power BI – Trends Analysis Page Design
How to create Power BI Tooltips to enhance your report
Sharing your report with Power BI Service
Chapter Quiz
Overview
Downlaod Course Material
How to build an amazing dashboard in Excel using Pivot Table and Pivot Chart
SQL Course Overview
Overview of SQL Language
Setting up the tools required to learn SQL
How to create a Database and Table in SQL
Inserting Data into a Table in SQL
Read Update and Delete
Altering a Table with SQL
Introduction to the Case Study
Importing Data with SQL
Comparism in SQL Case Study
Text Manipulations in SQL Case Study
Understanding Aggregations in SQL
Mastering Wildcard in SQL
Understanding Nulls in SQL
Understanding Case in SQL
Date Manipulation in SQL
Guide to Mastering Join in SQL
Understanding SubQuery in SQL
Creating your own Capstone Project with SQL
Feedback
