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
- 12 Sections
- 187 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 ServiceCopy
- 2.12.2 How to Connect PBI Desktop and Cloud Service to Microsoft SQL ServerCopy
- 2.22.3 How to invoke a SQL Server Stored Procedure from Power BICopy
- 2.32.4 Folder connector: Combining multiple sheets from multiple files in one-goCopy
- 2.42.5 Combine Multiple csv files in one-go using folder connector in Power BICopy
- 2.52.7 Connecting to OneDrive via Power BICopy
- 2.62.8 Loading data from Github to Power BICopy
- 2.72.9 How to connect to DataVerse using Power BICopy
- 2.83.1 Types of Data Storage Modes & Import Mode in Power BiCopy
- 2.93.2 Types of Storage Mode – Direct Query in Power BICopy
- 2.103.3 Types of Storage Mode – Live Connection in Power BICopy
- 2.113.4 Types of Storage Mode – Dual Storage Mode in Power BICopy
- 2.123.5 Working with PBDIS file (Live Connection Mode)Copy
- 2.133.6 What is Rest API , & how to connect to Web Page to bring in data into Power BICopy
- 2.14QUIZ: Introducing Microsoft Power BI DesktopCopy15 Minutes7 Questions
- 2.15Start Quiz : ProfilingCopy10 Minutes2 Questions
- 2.16QUIZ: Connecting & Shaping Data with Power BI DesktopCopy15 Minutes12 Questions
- Power Query Editor21
- 3.14.1 Data Transformation using Power Query EditorCopy
- 3.25.1 Data ProfilingCopy
- 3.35.2 Transpose , Pivoting and UnpivotingCopy
- 3.45.3 How to append datasets in Power QueryCopy
- 3.55.4 How to merge datasets in Power QueryCopy
- 3.65.5 Creating Index in Power Query EditorCopy
- 3.76.0 Enable Load , Include Report Refresh in Power Query EditorCopy
- 3.87.1 Query Parameter in Power QueryCopy
- 3.97.2 Custom Column CreationCopy
- 3.107.3 Conditional Column in Power BICopy
- 3.117.4 Column from Examples in Power BICopy
- 3.127.5 Custom Function in Power BICopy
- 3.137.6 Custom Function AssignmentsCopy
- 3.148.2 Case Study Converting multiple currencies into single currencyCopy
- 3.158.1 Group by and Fuzzy grouping in Power BICopy
- 3.168.3 Row Level Security , Dynamic Row Level & Object Level SecurityCopy
- 3.178.4 Incremental Data Refresh in Power BICopy
- 3.18Parameters in Power BICopy
- 3.19What is a Data warehousing & Data Lake? Star Schema Snow-flake SchemaCopy
- 3.20Power Query AssignmentCopy
- 3.21Quiz 3: QUIZ: Cleaning, Transforming & LoadingCopy12 Minutes8 Questions
- Data Modeling12
- 4.19.1 Introduction to Data Modeling in Power BICopy
- 4.210.1 Data Modeling | Types of RelationshipsCopy
- 4.310.2 Active and Inactive Relationship in Power BICopy
- 4.4Alternative to inactive relationship in Power BI – Role Playing DimensionCopy
- 4.5Types of cardinalities, Active , & Inactive relationshipCopy
- 4.6Cross Filter Direction in Power BICopy
- 4.7Quiz 4: QUIZ: Data ModelingCopy5 Minutes9 Questions
- 4.8Data Modeling AssignmentCopy
- 4.9QUIZ: Creating Table Relationships & Data Models in Power BICopy20 Minutes11 Questions
- 4.10Many to Many Relationship – Covering two ScenariosCopy
- 4.11Many to Many relationship AssignmentCopy
- 4.12Custom Date Dimension Table creation using CALENDAR() & CALENDARAUTO() in Power BICopy
- Data visualization26
- 5.112.1 Data visualizationCopy
- 5.212.3 Types of ChartCopy
- 5.312.4 Line ChartCopy
- 5.412.5 Area ChartCopy
- 5.512.6 Bar & Column ChartCopy
- 5.612.7 Combo ChartCopy
- 5.712.8 Pie & Doughnut Chart in Power BICopy
- 5.812.9 Scatter plots & Bubble ChartCopy
- 5.912.10 Matrix VisualCopy
- 5.1013.1 Custom Visual – Heat mapCopy
- 5.1113.2 Table VisualCopy
- 5.1213.3 SlicerCopy
- 5.1314.2 Types of Slicer in Power BICopy
- 5.1413.4 Tree MapsCopy
- 5.1513.5 Ribbon ChartCopy
- 5.1613.6 Funnel ChartCopy
- 5.1713.7 Gauge chartCopy
- 5.1813.8 Waterfall ChartCopy
- 5.1913.9 Key Influencer VisualCopy
- 5.2016.0 Decomposition Tree , Q & A VisualCopy
- 5.2116.2 Drill Through and Cross Report Drill Through in Power BICopy
- 5.2217.0 Bookmark in Power BICopy
- 5.2317.2 Custom Tooltip in Power BICopy
- 5.2418.0 Power BI Interview QuestionsCopy
- 5.25Start Quiz 6: QUIZ: Creating Reports & DashboardsCopy10 Minutes8 Questions
- 5.26QUIZ: Visualizing Data with Power BI ReportsCopy10 Minutes10 Questions
- Data Analytics Expresssion (DAX)49
- 6.118.1 Introduction to DAXCopy
- 6.218.2 Calculated Column in DAXCopy
- 6.318.3 Calculated Measure in DAXCopy
- 6.418.4 Data types in DAXCopy
- 6.518.5 Value Encoding in DAXCopy
- 6.618.6 Hash Encoding in DAXCopy
- 6.718.7 Run length Encoding in DAXCopy
- 6.818.8 Operators and Built-in FunctionsCopy
- 6.918.9 Rounding FunctionsCopy
- 6.1018.10 Information FunctionsCopy
- 6.1119.1 Logical Function : Switch in DAXCopy
- 6.1219.2 SUM and SUMXCopy
- 6.1319.3 Average Functions in DAXCopy
- 6.1419.4 Variables in DAXCopy
- 6.1519.5 Evaluation Context in DAXCopy
- 6.1619.6 CALCULATE Function in DAXCopy
- 6.1719.7 Evaluation Order of CALCULATECopy
- 6.1819.8 Filter in DAXCopy
- 6.1919.9 CALCULATETABLE function in DAXCopy
- 6.2019.10 ALL Function in DAXCopy
- 6.2119.11 ALLSELECTED Function in DAXCopy
- 6.2220.0 ALLEXCEPT in DAXCopy
- 6.2320.1 KEEPFILTER & REMOVEFILTER IN DAXCopy
- 6.2420.2 AddColumns() in Power BICopy
- 6.2520.3 CROSSFILTER in DAXCopy
- 6.2620.4 SELECTEDVALUE in DAXCopy
- 6.2720.5 Summarize, Summarizecolumns functions in DAX & how to use DAX StudioCopy
- 6.2820.6 DATATABLE , UNION, INTERSECT, EXCEPT, & INTERSECT IN DAXCopy
- 6.2920.7 LOOKUPVALUE in DAXCopy
- 6.3020.8 RELATED Function in DAXCopy
- 6.3120.9 RELATEDTABLE in DAXCopy
- 6.3220.10 TREATAS function in DAXCopy
- 6.3320.11 Rankx & TopN in DAXCopy
- 6.3421.1 Dynamic TopN in DAXCopy
- 6.3521.2 Recap of Dynamic TopN in DAX and Disconnected tableCopy
- 6.3621.3 DataTable, GenerateSeries, & Table FunctionsCopy
- 6.3721.4 Time Intelligence FunctionsCopy
- 6.3821.5 Display last N months Sales DynamicallyCopy
- 6.3921.6 Rolling / Moving Average, What-if Parameter in DAXCopy
- 6.4021.7 Capstone Project – Retail Analytics Part – 1Copy
- 6.4121.8 Capstone Project -1 Retail AnalyticsCopy
- 6.4221.9 Capstone Project – 2Copy
- 6.4321.10 Capstone Project Retail Analytics Part 2Copy
- 6.442.11 Creating calculation group in tabular editorCopy
- 6.45Report Design in Power BICopy
- 6.46Quiz 6: QUIZ: DAX CalculationsCopy10 Minutes10 Questions
- 6.47QUIZ: Analyzing Data with DAX CalculationsCopy15 Questions
- 6.48DAX AssignmentsCopy
- 6.49DAX Best PracticesCopy
- Power BI Cloud Service3
- Microsoft SQL Server25
- 8.0Installation of SQL ServerCopy
- 8.1Installation of SSMSCopy
- 8.2Introduction to Microsoft SQL ServerCopy
- 8.3Data Types in SQL ServerCopy
- 8.4Built in functions in SQL ServerCopy
- 8.5Constraints in SQL ServerCopy
- 8.6DDL & DML Hands-onCopy
- 8.7How to create Views in SQL ServerCopy
- 8.8SQL Server – Hands on Session Day 2Copy
- 8.9SQL Queries – Hands on Session Day 3Copy
- 8.10How to clone or duplicate a table in SQL ServerCopy
- 8.11What is Correlated Subquery and Plain Subquery in SQL ServerCopy
- 8.12SET Operators in SQL ServerCopy
- 8.13Joins in SQL ServerCopy
- 8.14IN Operator in SQL ServerCopy
- 8.15Exists Operator in SQL ServerCopy
- 8.16How to find and Remove Duplicate Records in SQLCopy
- 8.17How to find the Nth Maximum SalaryCopy
- 8.18Grouping sets and rollup functions in SQL ServerCopy
- 8.19CUBE functionCopy
- 8.20How to Pivot and Unpivot the dataCopy
- 8.21Stored ProcedureCopy
- 8.22Transaction Control Statements in SQL ServerCopy
- 8.23Stored Procedure and Stored Function in SQL ServerCopy
- 8.24Common Table Expression (CTE) in SQL ServerCopy
- Power BI Interview Question & Answers9
- 9.0Power BI Sample preview questionsCopy
- 9.1Power BI General Interview Question & AnswersCopy
- 9.2Power BI DAX Interview Question & AnswersCopy
- 9.3Power BI Power Pivot Interview Question & AnswersCopy
- 9.4Power BI Power Query Interview Question & AnswersCopy
- 9.5Power BI Power Map Interview Question & AnswersCopy
- 9.6Power BI Additional Interview Question & AnswersCopy
- 9.7SSIS Interview Question & AnswersCopy
- 9.8MySQL Interview Question & AnswersCopy
- Power BI Study Materials11
- 10.0Introduction to Power BICopy
- 10.1Data ExtractionCopy
- 10.2Shaping and combining DataCopy
- 10.3Data ModellingCopy
- 10.4Data VisualizationCopy
- 10.5Power BI ServiceCopy
- 10.6Power BI Solutions and Direct ConnectivityCopy
- 10.7Development With Power BICopy
- 10.8Introduction to Power BI PremiumCopy
- 10.9Power bi AssignmentCopy
- 10.10SQL Query AssignmentCopy
- DA-100 Certification Dumps1
- Data Analytics Using Python45
- 12.0Introduction to PythonCopy
- 12.1Quiz : Python BasicCopy20 Questions
- 12.2Quiz 1 : Introduction to ProgrammingCopy10 Minutes2 Questions
- 12.3Python Study MaterialCopy
- 12.4Quiz 2: Why Python?Copy10 Minutes0 Questions
- 12.5Quiz 3: Using Arithmetic Operators in PythonCopy10 Minutes0 Questions
- 12.6String Manipulation in PythonCopy
- 12.7Quiz 4: VariablesCopy10 Minutes1 Question
- 12.8Boolean Data Type in PythonCopy
- 12.9Quiz 6 : Numbers and Boolean Values in PythonCopy10 Minutes1 Question
- 12.10List Data Structure in PythonCopy
- 12.11Quiz 7: Python StringsCopy10 Minutes3 Questions
- 12.12Quiz 8 : Add CommentsCopy10 Minutes1 Question
- 12.13Quiz 9 : Indexing ElementsCopy10 Minutes1 Question
- 12.14Tuple in PythonCopy
- 12.15Quiz 10 : Structuring with IndentationCopy10 Minutes1 Question
- 12.16Dictionary in PythonCopy
- 12.17Quiz 11 : Comparison OperatorsCopy10 Minutes2 Questions
- 12.18Quiz 10 : The IF StatementCopy10 Minutes1 Question
- 12.19Sets and Conditional Programming in PythonCopy
- 12.20Quiz 11 : A Note on Boolean ValuesCopy10 Minutes1 Question
- 12.21Conditional Flow and Control StructuresCopy
- 12.22Python listCopy25 Questions
- 12.23Quiz 12 : ListsCopy10 Minutes1 Question
- 12.24Quiz 13 : Python FunctionsCopy10 Minutes2 Questions
- 12.25Quiz 13 : FunctionsCopy10 Minutes2 Questions
- 12.26Functions in PythonCopy
- 12.27Quiz 14 : Using MethodsCopy10 Minutes1 Question
- 12.28Quiz 15 : DictionariesCopy10 Minutes1 Question
- 12.29Numpy (Arrays, & Matrices) in PythonCopy
- 12.30Quiz 16 : For LoopsCopy10 Minutes1 Question
- 12.31Quiz 17 : Lists with the range() FunctionCopy10 Minutes1 Question
- 12.32Introduction to Pandas in PythonCopy
- 12.33Quiz 18 : Importing Modules in PythonCopy10 Minutes2 Questions
- 12.34Pandas AssignmentsCopy
- 12.35Dowload Pandas Assignment Data SetsCopy
- 12.36Data pre processing assignmentsCopy
- 12.37Data exploration assignmentsCopy
- 12.38DATASETSCopy
- 12.39Pandas QuizCopy10 Minutes22 Questions
- 12.40Numpy QuizCopy20 Questions
- 12.41Python SetCopy25 Questions
- 12.42Python TuplesCopy20 Questions
- 12.43QUIZ FOR GLOBAL & LOCAL VARIABLESCopy10 Questions
- 12.44Python DictionaryCopy19 Questions