Course curriculum

    1. Introduction: Module Introduction

    2. Introduction: Instructor

    3. Introduction: AI Sciences

    4. Introduction: Course Outline

    5. Introduction: Case Study

    6. Power BI Desktop: Module Introduction

    7. Power BI Desktop: Power BI Introduction

    8. Power BI Desktop: Advantages

    9. Power BI Desktop: Excel vs PowerBI

    10. Power BI Desktop: Installation

    11. Power BI Desktop: Settings

    12. Power BI Desktop: Interface

    13. Power BI Desktop: Workflow

    14. Power BI Desktop: Resources and Ribbon

    15. Power BI Desktop: Report View Tabs

    16. Analyzing Sales: Introduction

    17. Analyzing Sales: Understanding Data

    18. Analyzing Sales: Data in Power BI

    19. Analyzing Sales: Date Format

    20. Analyzing Sales: Sales Calculation

    21. Analyzing Sales: Formatting

    22. Analyzing Sales: Yearly, Quarterly and Monthly Analysis

    23. Analyzing Sales: Visualizing With Charts

    24. Analyzing Sales: Country Representation With Slicers

    25. Preparing and Analyzing P&L: Module Introduction

    26. Preparing and Analyzing P&L: Profit Loss Statement

    27. Preparing and Analyzing P&L: Gross Profit

    28. Preparing and Analyzing P&L: Operating Profit

    29. Preparing and Analyzing P&L: Net Progit, EBITDA and PBIT

    30. Preparing and Analyzing P&L: Visualising Gross and Net Profit

    31. Preparing and Analyzing P&L: Analysis and Adding Slicers

    1. Introduction: What is Business Intelligence

    2. Introduction: Importance of Business Intelligence

    3. Introduction: Design of the Course

    4. Introduction: What to Cover

    5. Introduction: Who should take this course

    6. Introduction: Introduction to the Projects

    7. Introduction: Introduction of the Instructor

    8. BI Applications and Tools: Adhoc Analysis in Business Intelligence

    9. BI Applications and Tools: Online Analytical Processing in Business Intelligence

    10. BI Applications and Tools: Mobile Business Intelligence

    11. BI Applications and Tools: Real Time Business Intelligence

    12. BI Applications and Tools: Operational Business Intelligence

    13. BI Applications and Tools: Open Source Business Intelligence

    14. BI Applications and Tools: Embedded Business Intelligence

    15. BI Applications and Tools: Collaborative Business Intelligence

    16. BI Applications and Tools: Location Business Intelligence

    17. BI Applications and Tools: Vendors and Market of Business Intelligence Tools

    18. An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of Statistics

    19. An overview of Statistics for Business Intelligence Needs and Requirements: Types of Statistics

    20. An overview of Statistics for Business Intelligence Needs and Requirements: Descriptive Statistics along with Types of Data

    21. An overview of Statistics for Business Intelligence Needs and Requirements: Levels of Measurement used in Statistical Data

    22. An overview of Statistics for Business Intelligence Needs and Requirements: Examples of Measurement Levels

    23. An overview of Statistics for Business Intelligence Needs and Requirements: Data Visualization using Histogram

    24. An overview of Statistics for Business Intelligence Needs and Requirements: Data Correlation using Scatter Plots

    25. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Scatter Plot

    26. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Scatter Plot

    27. An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of a Cross Table

    28. An overview of Statistics for Business Intelligence Needs and Requirements: Measures of Central Tendency

    29. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Data with Outliers

    30. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Data with Outliers

    31. An overview of Statistics for Business Intelligence Needs and Requirements: Correlation, Covariance and Skewness in Data

    32. An overview of Statistics for Business Intelligence Needs and Requirements: Spread of Data

    33. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Standard Deviation and Variance

    34. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Standard Deviation and Variance

    35. An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of Inferential Statistics

    36. An overview of Statistics for Business Intelligence Needs and Requirements: Distribution of Data and Standard Error

    37. An overview of Statistics for Business Intelligence Needs and Requirements: Estimators, Estimates and Central Limit Theorem

    38. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution to Distribution of Data

    39. An overview of Statistics for Business Intelligence Needs and Requirements: Z-Score and T-Score

    40. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution What to Select Z-score or T-score

    41. An overview of Statistics for Business Intelligence Needs and Requirements: Hypothesis Testing

    42. An overview of Statistics for Business Intelligence Needs and Requirements: Significance Levels and Critical Regions

    43. An overview of Statistics for Business Intelligence Needs and Requirements: Confidence Interval and Margin of Errors

    44. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution to Significance Interval

    45. An overview of Statistics for Business Intelligence Needs and Requirements: Dependent Sample Two Mean Test

    46. An overview of Statistics for Business Intelligence Needs and Requirements: Independent Sample Two Mean Test

    47. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Which Test to Perform if Population Variance Known

    48. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Answer Which Test to Perform if Population Variance Known

    49. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Which Test to Perform if Population Variance unknown

    50. An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Answer Which Test to Perform if Population Variance unknown

    51. An overview of Statistics for Business Intelligence Needs and Requirements: Summary Statistics in One Go

    52. Statistical Practices Using Excel: Descrptive Statistics in Excel

    53. Statistical Practices Using Excel: Quiz Descriptive Statistics

    54. Statistical Practices Using Excel: Quiz Solution Descriptive Statistics

    55. Statistical Practices Using Excel: Measures of Central Tendency in Excel

    56. Statistical Practices Using Excel: Quiz Mean, Median and Mode in Excel

    57. Statistical Practices Using Excel: Quiz Solution of Mean, Median and Mode in Excel

    58. Statistical Practices Using Excel: Measuring Data Spread using Excel

    59. Statistical Practices Using Excel: Correlation in Excel

    60. Statistical Practices Using Excel: Quiz Correlation

    61. Statistical Practices Using Excel: Quiz Solution Correlation

    62. Statistical Practices Using Excel: Data Visualization using Excel

    63. Statistical Practices Using Excel: Paired Sample t Test in Excel

    64. Statistical Practices Using Excel: Quiz T Test Paired Sample

    65. Statistical Practices Using Excel: Quiz Solution T Test-Paired Samples

    66. Statistical Practices Using Excel: t Test for Equal and Unequal Variances in Excel

    67. Statistical Practices Using Excel: Quiz Two Sample T Test

    68. Statistical Practices Using Excel: Quiz Solution Two Sample T Test

    69. Statistical Practices Using Excel: Hypothesis Testing using Excel

    70. Statistical Practices Using Excel: Confidence Interval in Descriptive Statistics using Data Analysis Tab in Excel

    71. Statistical Practices Using Excel: Quiz Z Test

    72. Statistical Practices Using Excel: Quiz Solution Z Test

    73. Statistical Practices Using Excel: Project Question How to Perform Regression in Excel

    74. Statistical Practices Using Excel: Project of Performing Regression in Excel

    75. Power BI: Introduction What we will learn in Power BI

    76. Power BI: An Overview of Power BI

    77. Power BI: Downloading or Installing Power BI Desktop Free

    78. Power BI: Getting Started with Power BI

    79. Power BI: One Simple Click to Get Data into Power BI

    80. Power BI: Working with Query Editor The Kitchen of Power BI

    81. Power BI: Refreshing Data Sources

    82. Power BI: Star vs Snowflake Schema

    83. Power BI: More About Schema

    84. Power BI: Look Up vs Data Tables

    85. Power BI: Making Relationships Among Data Table and Look Up Tables

    86. Power BI: Active vs Inactive Relationships

    87. Power BI: Setting Cardinality in Relatinships

    88. Power BI: Cross Filter Direction of Data Model

    89. Power BI: Definning Measure By Using Existing Measure

    90. Power BI: Final Data Model

    91. Power BI: Starting with the Measures Explicit and Implicit

    92. Power BI: Simple DAX to Define a Measure

    93. Power BI: DAX Quiz

    94. Power BI: DAX Quiz Solution

    95. Power BI: Another DAX Practice

    96. Power BI: Quiz Write Explicit Measures

    97. Power BI: Quiz Solution Write Explicit Measures

    98. Power BI: Quiz Create Explicit Measure to Calculate Sum of Sales

    99. Power BI: Solution Create Explicit Measure to Calculate Sum of Sales

    100. Power BI: Quiz Implicit or Explicit

    101. Power BI: Quiz Solution Implicit or Explicit

    102. Power BI: Quiz Defining Explicit Measure

    103. Power BI: Quiz Solution Defining Explicit Measure

    104. Power BI: Combining Multiple Functions Under Single Measure

    105. Power BI: Quiz Creating Hybrid Measure

    106. Power BI: Quiz Solution Creating Hybrid Measure

    107. Power BI: Complex Function

    108. Power BI: Multiple Functions Together

    109. Power BI: Defining Quick Measure

    110. Power BI: Quiz Put Visual and Add Measure Result

    111. Power BI: Quiz Solution Put Visual and Add Measure Result

    112. Power BI: Quiz Adding Fields to the Visual

    113. Power BI: Quiz Solution Adding Fields to the Visual

    114. Power BI: Quiz Apply Basic Filtering

    115. Power BI: Quiz Solution Apply Basic Filtering

    116. Power BI: Quiz Slice and Dice as Per Month

    117. Power BI: Quiz Solution Slice and Dice as Per Month

    118. Power BI: Quiz Applying Sort on the Month Field

    119. Power BI: Quiz Solution Applying Sort on the Month Field

    120. Power BI: Defining New Column using Find Function

    121. Power BI: New Column using if Condition

    122. Power BI: Quiz Adding New Column

    123. Power BI: Quiz Solution Adding New Column

    124. Power BI: Quiz Format the Measure Output

    125. Power BI: Quiz Solution Format the Measure Output

    126. Power BI: Time Intelligence in Power BI

    127. Power BI: Defining Day Date Function

    128. Power BI: Time Intelligence More Functions

    129. Power BI: Making Your Own Date Table in Power BI

    130. Power BI: Career Opportunities with Power BI

    131. Power BI: Making Report in Power BI

    132. Power BI: Adding Charts in Reports

    133. Power BI: Publishing Data to Workspace and Dashboarda

    134. Tableau: An Overview of the Module

    135. Tableau: What is Tableau

    136. Tableau: Why Tableau

    137. Tableau: Features of Tableau

    138. Tableau: Advantages of Using Tableau

    139. Tableau: Website of Tableau

    140. Tableau: Downloading Tableau

    141. Tableau: Which Tableau Platform to Use

    142. Tableau: Openning Tableau

    143. Tableau: Adding Data, Connecting Tables, Adding Fields and Applying Cardinality

    144. Tableau: Refrential Integrity and Relationships in Different Tables

    145. Tableau: Data Modelling Using Multiple Fields to Develop Valid Relationship

    146. Tableau: Union of Multiple Tables

    147. Tableau: Understanding Data Forms in Sheet View of Tableau

    148. Tableau: Simplified Bin Chart of Sales

    149. Tableau: Making Various Charts in Just a Click in Different Colours and Size

    150. Tableau: Combining Multiple Fiels Under One Axis as Dual Axis

    151. Tableau: Lollipop Chart

    152. Tableau: Creating Calculated Field to Find Profit Margin

    153. Tableau: Quiz Calculated Field

    154. Tableau: Quiz Solution Calculated Field

    155. Tableau: Calculation with Condition Writing

    156. Tableau: Quiz Total Revenue

    157. Tableau: Quiz Solution Total Revenue

    158. Tableau: Discrete and Continuous Data in Tableau

    159. Tableau: Mapping in Tableau

    160. Tableau: Data Joining

    161. Tableau: Inner Join

    162. Tableau: Full Outer Join

    163. Tableau: Left Join, Right Join and Discussion on Data Modelling

    164. Tableau: Quiz Creating Bin Field

    165. Tableau: Quiz Solution Creating Bin Field

    166. Tableau: Aggregation and Granularity

    167. Tableau: Another Chart with Parameters

    168. Tableau: Sales Chart with Adding Filters to Tooltip

    169. Tableau: Joining vs Blending

    170. Tableau: Using Pivot Function

    171. Tableau: Project Quiz Forecasting your Sales

    172. Tableau: Solution to the Project

    173. Tableau: Working with Data Interpreter

    174. Tableau: Adding Sheets to the Dashboard

    175. Tableau: Quiz Project Designing Dashboard

    176. Tableau: Solution to the Project Dashboard

    177. Tableau: Quiz Project Making Story

    178. Tableau: Solution to the Project Story

    179. Tableau: Tableau vs Excel

    180. Tableau: Power BI vs Tableau

    181. Tableau: Final Video to Sum Up All

    182. Project: Starting the Project Adding Slicer

    183. Project: Adding Cards with Various Fields

    184. Project: Applying Various Filters

    185. Project: Formatting Visuals and Adding Chart

    186. Project: Adding Charts to Dashboard

    187. Project: Adding More Charts to Dashboard

    188. Project: Final Dashboard

    189. Project: Project Customer Analysis

    190. Project: Importing Data

    191. Project: Revenue Per State

    192. Project: Revenue Per Month

    193. Project: Revenue Per Age

    194. Project: Quantity Discount Correlation

    195. Project: Revenue Per Region

    196. Project: Revenue Per Category

    197. Project: Dashboard

    198. Career Development: Career Growth in Business Intelligence

    199. Career Development: OLTP and OLAP

    200. Career Development: Your Grip on BI Tool

    201. Career Development: Data Mart and Data Warehouse

    202. Career Development: BI Developer

    203. Career Development: Universe in Business Analytics

    204. Career Development: Dashboard and SAS BI

    205. Career Development: Agile Software Developement and BI Projects

    206. Career Development: Benchmarks

    207. Career Development: Granularity, BI Elements and BI Reports

    208. Career Development: RAGGED Hierracrchy and SSBI

    209. Career Development: Building Blocks in Power BI and Concept of INVEST

    210. Career Development: BRD and SRS

    211. Career Development: Business Modelling and Personas

    212. Career Development: General Questions

    213. Career Development: Open Ended Experience Based Questions

    214. Career Development: BI Roles and Annual Salaries

About this course

  • $199.99
  • 245 lessons
  • 13.5 hours of video content