About Course

Unlock the power of data with our comprehensive 120-day online course designed to transform you into a proficient business intelligence (BI) expert. This course is meticulously crafted to provide you with a deep understanding of industry-leading BI tools: Power BI and Tableau. Whether you’re a beginner or looking to enhance your data visualization skills, this course will equip you with the knowledge and practical experience needed to build insightful dashboards and make data-driven decisions.

Introduction to Business Intelligence: Understand the fundamentals of BI and its role in modern business decision-making.
Getting Started with Power BI: Learn to navigate the Power BI interface, import and clean data, and create interactive reports and dashboards.
Advanced Power BI Techniques: Dive into advanced features such as DAX calculations, custom visuals, and real-time data integration.
Introduction to Tableau: Explore the Tableau environment, data connections, and build basic visualizations.
Advanced Tableau Skills: Master complex visualizations, calculations, and dashboard design best practices.
Data Visualization Best Practices: Discover techniques for designing clear, compelling, and actionable dashboards.
Real-World Projects: Apply your skills to hands-on projects, including creating dashboards for various business scenarios.
Capstone Project: Build a comprehensive dashboard using both Power BI or Tableau, showcasing your ability to integrate and apply the concepts learned throughout the course.

Course Content

Course 01 – Power BI Desktop

Draft Lesson

12:52:00
Class 01 Power BI Desktop URL

Class 02 – Install SQL Server

Class 03 – Install SQL Server Management Studio

Class 04 – Install Adventureworks 2022

Class 05 – Academy Vertabello

Class 06 – SQL Server Relationships

Class 07 – Power BI Relationships

Class 08 – Power Query

Class 09 – Dax Measures

Class 10 – Visualizations

Class 11 – Tables

Class 12 – Matrix

Class 13 – Clustered Column Chart

Class 14 – Stacked Column Chart

Class 15 – Clustered Bar Chart

Class 16 – Stacked Bar Chart

Class 17 – Stacked Line and Column Chart

Class 18 – Pie Chart

Class 19 – Line Chart

Class 20 – Maps (Part 1 of 2)

Class 21 – Fill Map

Class 22 – Conditional Format Clustered Column Chart

Class 23 – Conditional Format Table

Class 24 – The Tree Map

Class 25 – The Funnel Chart

Class 26 – Laying Out Report Visuals

Class 27 – Formatting a Report

Class 28 – Final Project

Class 29 – Final Project Continued

Class 30 – Next Steps

About Course

What Will You Learn?

Course Content

Course 01 – Power BI Desktop

Draft Lesson

Class 01 Power BI Desktop URL

Class 02 – Install SQL Server

Draft Lesson

Class 02 Install SQL Server Assignment

Class 03 – Install SQL Server Management Studio

Draft Lesson

Class 03 Install SSMS

Class 04 – Install Adventureworks 2022

Draft Lesson

Class 04 Install Adventureworks URL

Class 04 Install Adventureworks 2022

Class 05 – Academy Vertabello

Draft Lesson

Class 05 Intro to Vertabello

Class 05 Vertabelo Academy Assignment

Class 06 – SQL Server Relationships

Draft Lesson

Class 06 Vertabelo

Class 06 Relationship Model Assignment

Class 07 – Power BI Relationships

Draft Lesson

Class 07 Vertabelo

Class 07 Relationship Assignment

Class 08 – Power Query

Draft Lesson

Class 08 Vertabelo

Class 08 Power Query Assignment

Class 09 – Dax Measures

Draft Lesson

Class 09 Vertabelo

Class 09 Dax Measures Assignment

Class 10 – Visualizations

Class 10 Vertabelo

Class 10 Visuals Assignment

Class 11 – Tables

Draft Lesson

Class 11 Vertabelo

Class 11 Tables Assignment

Class 12 – Matrix

Draft Lesson

Class 12 Vertabelo

Draft Lesson

Class 12 Matrix Assignment

Class 13 – Clustered Column Chart

Draft Lesson

Class 13 Vertabelo

Class 13 Clustered Column Chart Assignment

Class 14 – Stacked Column Chart

Draft Lesson

Class 14 Vertabelo

Class 14 Clustered Bar Chart Assignment

Class 15 – Clustered Bar Chart

Draft Lesson

Class Clustered Bar Chart Assignement

Class 16 – Stacked Bar Chart

Draft Lesson

Class 16 Stacked Bar Chart Assignement

Class 17 – Stacked Line and Column Chart

Draft Lesson

Class 17 Stacked Line and Column Assignment

Class 18 – Pie Chart

Draft Lesson

Class 18 Pie Chart Assignment

Class 19 – Line Chart

Draft Lesson

Class 19 Line Chart Assignment

Class 20 – Maps (Part 1 of 2)

Draft Lesson

Class 20 Maps Visual Assignment

Class 21 – Fill Map

Class Fill Map Visuals Assignment

Class 22 – Conditional Format Clustered Column Chart

Draft Lesson

Class 22 – Conditional Format Conditional Column Assignment

Class 23 – Conditional Format Table