Curriculum
- 12 Sections
- 187 Lessons
- 30 Hours
Expand all sectionsCollapse all sections
- 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