Course Overview:
The Full Stack Power BI Course is designed to equip participants with comprehensive skills to leverage the full potential of Microsoft Power BI for end-to-end business intelligence solutions. This course covers a range of topics, from basic concepts to advanced techniques, enabling participants to become proficient in both the technical and business aspects of Power BI development.
Capstone Project: Participants will work on a hands-on capstone project that integrates all the skills learned throughout the course. This project will simulate a real-world scenario where participants can showcase their ability to develop end-to-end Power BI solutions.
Assessment and Certification: Participants will be assessed through quizzes, assignments, and the successful completion of the capstone project. Upon completing the course, participants will receive a certification indicating their proficiency in Full Stack Power BI.
This Full Stack Power BI Course is suitable for business analysts, data analysts, BI professionals, and anyone interested in harnessing the power of Microsoft Power BI for comprehensive business intelligence solutions. The course combines theoretical knowledge with practical applications to ensure participants are well-prepared for real-world challenges in the field of business intelligence.
Curriculum
- 16 Sections
- 201 Lessons
- 30 Hours
- Power Bi Instructed Led Online Course7
- Connecting to various data sources17
- 2.02.1 Load Data from CSV in Power BI and Power BI Cloud Service
- 2.12.2 How to Connect PBI Desktop and Cloud Service to Microsoft SQL Server
- 2.22.3 How to invoke a SQL Server Stored Procedure from Power BI
- 2.32.4 Folder connector: Combining multiple sheets from multiple files in one-go
- 2.42.5 Combine Multiple csv files in one-go using folder connector in Power BI
- 2.52.7 Connecting to OneDrive via Power BI
- 2.62.8 Loading data from Github to Power BI
- 2.72.9 How to connect to DataVerse using Power BI
- 2.83.1 Types of Data Storage Modes & Import Mode in Power Bi
- 2.93.2 Types of Storage Mode – Direct Query in Power BI
- 2.103.3 Types of Storage Mode – Live Connection in Power BI
- 2.113.4 Types of Storage Mode – Dual Storage Mode in Power BI
- 2.123.5 Working with PBDIS file (Live Connection Mode)
- 2.133.6 What is Rest API , & how to connect to Web Page to bring in data into Power BI
- 2.14QUIZ: Introducing Microsoft Power BI Desktop15 Minutes7 Questions
- 2.15Start Quiz : Profiling10 Minutes2 Questions
- 2.16QUIZ: Connecting & Shaping Data with Power BI Desktop15 Minutes12 Questions
- Power Query Editor21
- 3.14.1 Data Transformation using Power Query Editor
- 3.25.1 Data Profiling
- 3.35.2 Transpose , Pivoting and Unpivoting
- 3.45.3 How to append datasets in Power Query
- 3.55.4 How to merge datasets in Power Query
- 3.65.5 Creating Index in Power Query Editor
- 3.76.0 Enable Load , Include Report Refresh in Power Query Editor
- 3.87.1 Query Parameter in Power Query
- 3.97.2 Custom Column Creation
- 3.107.3 Conditional Column in Power BI
- 3.117.4 Column from Examples in Power BI
- 3.127.5 Custom Function in Power BI
- 3.137.6 Custom Function Assignments
- 3.148.2 Case Study Converting multiple currencies into single currency
- 3.158.1 Group by and Fuzzy grouping in Power BI
- 3.168.3 Row Level Security , Dynamic Row Level & Object Level Security
- 3.178.4 Incremental Data Refresh in Power BI
- 3.18Parameters in Power BI
- 3.19What is a Data warehousing & Data Lake? Star Schema Snow-flake Schema
- 3.20Power Query Assignment
- 3.21Quiz 3: QUIZ: Cleaning, Transforming & Loading12 Minutes8 Questions
- Data Modeling12
- 4.19.1 Introduction to Data Modeling in Power BI
- 4.210.1 Data Modeling | Types of Relationships
- 4.310.2 Active and Inactive Relationship in Power BI
- 4.4Alternative to inactive relationship in Power BI – Role Playing Dimension
- 4.5Types of cardinalities, Active , & Inactive relationship
- 4.6Cross Filter Direction in Power BI
- 4.7Quiz 4: QUIZ: Data Modeling5 Minutes9 Questions
- 4.8Data Modeling Assignment
- 4.9QUIZ: Creating Table Relationships & Data Models in Power BI20 Minutes11 Questions
- 4.10Many to Many Relationship – Covering two Scenarios
- 4.11Many to Many relationship Assignment
- 4.12Custom Date Dimension Table creation using CALENDAR() & CALENDARAUTO() in Power BI
- Data visualization26
- 5.112.1 Data visualization
- 5.212.3 Types of Chart
- 5.312.4 Line Chart
- 5.412.5 Area Chart
- 5.512.6 Bar & Column Chart
- 5.612.7 Combo Chart
- 5.712.8 Pie & Doughnut Chart in Power BI
- 5.812.9 Scatter plots & Bubble Chart
- 5.912.10 Matrix Visual
- 5.1013.1 Custom Visual – Heat map
- 5.1113.2 Table Visual
- 5.1213.3 Slicer
- 5.1314.2 Types of Slicer in Power BI
- 5.1413.4 Tree Maps
- 5.1513.5 Ribbon Chart
- 5.1613.6 Funnel Chart
- 5.1713.7 Gauge chart
- 5.1813.8 Waterfall Chart
- 5.1913.9 Key Influencer Visual
- 5.2016.0 Decomposition Tree , Q & A Visual
- 5.2116.2 Drill Through and Cross Report Drill Through in Power BI
- 5.2217.0 Bookmark in Power BI
- 5.2317.2 Custom Tooltip in Power BI
- 5.2418.0 Power BI Interview Questions
- 5.25Start Quiz 6: QUIZ: Creating Reports & Dashboards10 Minutes8 Questions
- 5.26QUIZ: Visualizing Data with Power BI Reports10 Minutes10 Questions
- Data Analytics Expresssion (DAX)49
- 6.118.1 Introduction to DAX
- 6.218.2 Calculated Column in DAX
- 6.318.3 Calculated Measure in DAX
- 6.418.4 Data types in DAX
- 6.518.5 Value Encoding in DAX
- 6.618.6 Hash Encoding in DAX
- 6.718.7 Run length Encoding in DAX
- 6.818.8 Operators and Built-in Functions
- 6.918.9 Rounding Functions
- 6.1018.10 Information Functions
- 6.1119.1 Logical Function : Switch in DAX
- 6.1219.2 SUM and SUMX
- 6.1319.3 Average Functions in DAX
- 6.1419.4 Variables in DAX
- 6.1519.5 Evaluation Context in DAX
- 6.1619.6 CALCULATE Function in DAX
- 6.1719.7 Evaluation Order of CALCULATE
- 6.1819.8 Filter in DAX
- 6.1919.9 CALCULATETABLE function in DAX
- 6.2019.10 ALL Function in DAX
- 6.2119.11 ALLSELECTED Function in DAX
- 6.2220.0 ALLEXCEPT in DAX
- 6.2320.1 KEEPFILTER & REMOVEFILTER IN DAX
- 6.2420.2 AddColumns() in Power BI
- 6.2520.3 CROSSFILTER in DAX
- 6.2620.4 SELECTEDVALUE in DAX
- 6.2720.5 Summarize, Summarizecolumns functions in DAX & how to use DAX Studio
- 6.2820.6 DATATABLE , UNION, INTERSECT, EXCEPT, & INTERSECT IN DAX
- 6.2920.7 LOOKUPVALUE in DAX
- 6.3020.8 RELATED Function in DAX
- 6.3120.9 RELATEDTABLE in DAX
- 6.3220.10 TREATAS function in DAX
- 6.3320.11 Rankx & TopN in DAX
- 6.3421.1 Dynamic TopN in DAX
- 6.3521.2 Recap of Dynamic TopN in DAX and Disconnected table
- 6.3621.3 DataTable, GenerateSeries, & Table Functions
- 6.3721.4 Time Intelligence Functions
- 6.3821.5 Display last N months Sales Dynamically
- 6.3921.6 Rolling / Moving Average, What-if Parameter in DAX
- 6.4021.7 Capstone Project – Retail Analytics Part – 1
- 6.4121.8 Capstone Project -1 Retail Analytics
- 6.4221.9 Capstone Project – 2
- 6.4321.10 Capstone Project Retail Analytics Part 2
- 6.442.11 Creating calculation group in tabular editor
- 6.45Report Design in Power BI
- 6.46Quiz 6: QUIZ: DAX Calculations10 Minutes10 Questions
- 6.47QUIZ: Analyzing Data with DAX Calculations15 Questions
- 6.48DAX Assignments
- 6.49DAX Best Practices
- Power BI Cloud Service3
- Microsoft SQL Server25
- 9.0Installation of SQL Server
- 9.1Installation of SSMS
- 9.2Introduction to Microsoft SQL Server
- 9.3Data Types in SQL Server
- 9.4Built in functions in SQL Server
- 9.5Constraints in SQL Server
- 9.6DDL & DML Hands-on
- 9.7How to create Views in SQL Server
- 9.8SQL Server – Hands on Session Day 2
- 9.9SQL Queries – Hands on Session Day 3
- 9.10How to clone or duplicate a table in SQL Server
- 9.11What is Correlated Subquery and Plain Subquery in SQL Server
- 9.12SET Operators in SQL Server
- 9.13Joins in SQL Server
- 9.14IN Operator in SQL Server
- 9.15Exists Operator in SQL Server
- 9.16How to find and Remove Duplicate Records in SQL
- 9.17How to find the Nth Maximum Salary
- 9.18Grouping sets and rollup functions in SQL Server
- 9.19CUBE function
- 9.20How to Pivot and Unpivot the data
- 9.21Stored Procedure
- 9.22Transaction Control Statements in SQL Server
- 9.23Stored Procedure and Stored Function in SQL Server
- 9.24Common Table Expression (CTE) in SQL Server
- Power BI Interview Question & Answers9
- 10.0Power BI Sample preview questions
- 10.1Power BI General Interview Question & Answers
- 10.2Power BI DAX Interview Question & Answers
- 10.3Power BI Power Pivot Interview Question & Answers
- 10.4Power BI Power Query Interview Question & Answers
- 10.5Power BI Power Map Interview Question & Answers
- 10.6Power BI Additional Interview Question & Answers
- 10.7SSIS Interview Question & Answers
- 10.8MySQL Interview Question & Answers
- Power BI Study Materials11
- DA-100 Certification Dumps1
- Data Analytics Using Python46
- 13.0Introduction to Python
- 13.1Quiz : Python Basic20 Questions
- 13.2Quiz 1 : Introduction to Programming10 Minutes2 Questions
- 13.3Python Study Material
- 13.4Quiz 2: Why Python?10 Minutes0 Questions
- 13.5Quiz 3: Using Arithmetic Operators in Python10 Minutes0 Questions
- 13.6String Manipulation in Python
- 13.7Quiz 4: Variables10 Minutes1 Question
- 13.8Boolean Data Type in Python
- 13.9Quiz 6 : Numbers and Boolean Values in Python10 Minutes1 Question
- 13.10List Data Structure in Python
- 13.11Quiz 7: Python Strings10 Minutes3 Questions
- 13.12Quiz 8 : Add Comments10 Minutes1 Question
- 13.13Quiz 9 : Indexing Elements10 Minutes1 Question
- 13.14Tuple in Python
- 13.15Quiz 10 : Structuring with Indentation10 Minutes1 Question
- 13.16Dictionary in Python
- 13.17Quiz 11 : Comparison Operators10 Minutes2 Questions
- 13.18Quiz 10 : The IF Statement10 Minutes1 Question
- 13.19Sets and Conditional Programming in Python
- 13.20Quiz 11 : A Note on Boolean Values10 Minutes1 Question
- 13.21Conditional Flow and Control Structures
- 13.22Python list25 Questions
- 13.23Quiz 12 : Lists10 Minutes1 Question
- 13.24Quiz 13 : Python Functions10 Minutes2 Questions
- 13.25Quiz 13 : Functions10 Minutes2 Questions
- 13.26Functions in Python
- 13.27Quiz 14 : Using Methods10 Minutes1 Question
- 13.28Quiz 15 : Dictionaries10 Minutes1 Question
- 13.29Numpy (Arrays, & Matrices) in Python
- 13.30Quiz 16 : For Loops10 Minutes1 Question
- 13.31Quiz 17 : Lists with the range() Function10 Minutes1 Question
- 13.32Introduction to Pandas in Python
- 13.33Quiz 18 : Importing Modules in Python10 Minutes2 Questions
- 13.34Pandas Assignments
- 13.35Dowload Pandas Assignment Data Sets
- 13.36Data pre processing assignments
- 13.37Data exploration assignments
- 13.38DATASETS
- 13.39Pandas Quiz10 Minutes22 Questions
- 13.40Numpy Quiz20 Questions
- 13.41Python Set25 Questions
- 13.42Python Tuples20 Questions
- 13.43QUIZ FOR GLOBAL & LOCAL VARIABLES10 Questions
- 13.44Python Dictionary19 Questions
- 13.45While & For Loop15 Questions
- Azure Data Factory Introduction2
- Understanding Adf Basic Object Model5
- Azure Data Factory Deployment3
- Data Transformation4