{"version":1,"pages":[{"id":"OrFMLUJTowsDP1SvoeY9","title":"Python Installation","pathname":"/","siteSpaceId":"sitesp_wySi9","description":"Installation guide","breadcrumbs":[{"label":"Python"}]},{"id":"UPEx3JV6bRiEm2M0Hyzb","title":"Pandas and SQL","pathname":"/python/pandas-and-sql","siteSpaceId":"sitesp_wySi9","description":"","breadcrumbs":[{"label":"Python"}]},{"id":"2suOvjmJO0vdWuKrLwP7","title":"Data Analytics Project","pathname":"/projects/data-analytics-project","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"}]},{"id":"vsHIljIfcMAwHQpVdXln","title":"Courier Analytics Challenge","pathname":"/projects/data-analytics-project/courier-analytics-challenge","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"},{"label":"Data Analytics Project"}]},{"id":"TtA0Z5KJv1nTRGFbvpy6","title":"Solution","pathname":"/projects/data-analytics-project/solution","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"},{"label":"Data Analytics Project"}]},{"id":"0MRVOcHH9YolVSxQU9NZ","title":"Skytrax Airline Review Analysis Pipeline","pathname":"/projects/skytrax-airline-review-analysis-pipeline","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"}]},{"id":"DJKcYersFhBhZpy2vFkX","title":"Setting up Azure SQL Database","pathname":"/projects/skytrax-airline-review-analysis-pipeline/setting-up-azure-sql-database","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"},{"label":"Skytrax Airline Review Analysis Pipeline"}]},{"id":"AYiqY3km57mTsRwm2U1e","title":"SkyTrax Web Scraping","pathname":"/projects/skytrax-airline-review-analysis-pipeline/skytrax-web-scraping","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"Projects"},{"label":"Skytrax Airline Review Analysis Pipeline"}]},{"id":"-MjTZnGIwJhBWsnrrwCn","title":"Power BI","pathname":"/reporting/powerbi","siteSpaceId":"sitesp_wySi9","description":"Overview","breadcrumbs":[{"label":"Reporting"}]},{"id":"-MjTn5AcPYs1YQhWZ5jS","title":"Installation","pathname":"/reporting/powerbi/installation","siteSpaceId":"sitesp_wySi9","description":"","breadcrumbs":[{"label":"Reporting"},{"label":"Power BI"}]},{"id":"-MjTnygNByH9dZ9Yx6DC","title":"Data Sources","pathname":"/reporting/powerbi/data-sources","siteSpaceId":"sitesp_wySi9","description":"","breadcrumbs":[{"label":"Reporting"},{"label":"Power BI"}]},{"id":"EKSD1V0ljIBTNWhtbDSj","title":"Important Links","pathname":"/reporting/powerbi/important-links","siteSpaceId":"sitesp_wySi9","description":"Microsoft learn courses","breadcrumbs":[{"label":"Reporting"},{"label":"Power BI"}]},{"id":"DmoqP0PXkRmxUUOdQcbx","title":"Spark vs Hadoop","pathname":"/pyspark-and-databricks/spark-vs-hadoop","siteSpaceId":"sitesp_wySi9","description":"In this document we will try to understand why spark is better than hadoop","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"Ti4HdNnERn83b2wg2iH5","title":"Cluster Computing","pathname":"/pyspark-and-databricks/cluster-computing","siteSpaceId":"sitesp_wySi9","description":"In this document we will try to understand what is cluster computing","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"AXPcaDAvuOXUqT9FMIjd","title":"PySpark","pathname":"/pyspark-and-databricks/pyspark","siteSpaceId":"sitesp_wySi9","description":"Introduction","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"A3HHlS7w0n1hIyGu0dT9","title":"Databricks Introduction","pathname":"/pyspark-and-databricks/databricks-introduction","siteSpaceId":"sitesp_wySi9","description":"In this page we will look at a brief introduction about Databricks","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"EouoI7KRcxRhBSaZw3Bq","title":"PySpark in Databricks","pathname":"/pyspark-and-databricks/pyspark-in-databricks","siteSpaceId":"sitesp_wySi9","description":"In this tutorial, we will see how we can get started with Databricks","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"AObPLdfurUKclWey6SCr","title":"Reading Data with PySpark","pathname":"/pyspark-and-databricks/reading-data-with-pyspark","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we will see how we can read data in PySpark","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"nh69CMW1Txc6c9wSYIov","title":"PySpark Transformation Methods","pathname":"/pyspark-and-databricks/pyspark-transformation-methods","siteSpaceId":"sitesp_wySi9","description":"In this tutorial, we will try to explore some of the common data transformation methods in PySpark","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"HwNfFL6OaDGqqwiDQWEz","title":"Handling Duplicate Data","pathname":"/pyspark-and-databricks/handling-duplicate-data","siteSpaceId":"sitesp_wySi9","description":"In this tutorial, we will see some common methods for how we can handle duplicate data.","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"9ACHRGaMd74GmnFND4YY","title":"PySpark Action Methods","pathname":"/pyspark-and-databricks/pyspark-action-methods","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we will try to look at some of the common action methods in PySpark","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"IJlfPsG0gtTMwJT93gZk","title":"PySpark Native Functions","pathname":"/pyspark-and-databricks/pyspark-native-functions","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we will explore some common PySpark native functions","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"OPllbvo0AdPx49AMtbMR","title":"Partitioning","pathname":"/pyspark-and-databricks/partitioning","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we will learn about Partitioning strategy in PySpark","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"GPgMjCsuc6KuzYoCDtgC","title":"Bucketing","pathname":"/pyspark-and-databricks/bucketing","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we learn about Bucketing strategy in PySpark","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"ork9FhSwYZG3i3z76Z16","title":"Partitioning vs Bucketing","pathname":"/pyspark-and-databricks/partitioning-vs-bucketing","siteSpaceId":"sitesp_wySi9","description":"In this tutorial we will try to understand the difference between Partitioning and Bucketing","breadcrumbs":[{"label":"PySpark & Databricks"}]},{"id":"-MhK7HtSsnVCMGeJrXKQ","title":"Spark Streaming","pathname":"/live-data-streaming/master","siteSpaceId":"sitesp_wySi9","description":"A to-the-point Instruction/Guide for any Spark enthusiast","breadcrumbs":[{"label":"Live Data Streaming"}]},{"id":"WHON6oTm4sepQFmJ2l9h","title":"Installation Issues","pathname":"/live-data-streaming/master/installation-issues","siteSpaceId":"sitesp_wySi9","description":"This page addresses some common errors and issues that you might have while installing Spark on your system.","breadcrumbs":[{"label":"Live Data Streaming"},{"label":"Spark Streaming"}]},{"id":"5aSQ1Gxel8PGoXgNo6Kv","title":"Jupyter Notebook Setup","pathname":"/live-data-streaming/master/jupyter-notebook-setup","siteSpaceId":"sitesp_wySi9","description":"In this guide you will see how to setup jupyter notebook as a default editor for PySpark","breadcrumbs":[{"label":"Live Data Streaming"},{"label":"Spark Streaming"}]},{"id":"xuArGbgBMIoYd3izhWeL","title":"Azure Data Factory","pathname":"/data-pipeline/azure-data-factory","siteSpaceId":"sitesp_wySi9","description":"","breadcrumbs":[{"label":"Data Pipeline"}]},{"id":"HmH79x4Ec3Op7Nwz7rC0","title":"Smart Contract Guide","pathname":"/blockchain/smart-contract-guide","siteSpaceId":"sitesp_wySi9","description":"A simple guide for developing and deploying smart-contracts for Blockchain Beginners inspired by the OpenZeppelin Guide","breadcrumbs":[{"label":"Blockchain"}]},{"id":"pZxxHtwLNsGaCbsgxwcu","title":"Setting up a Node project","pathname":"/blockchain/smart-contract-guide/setting-up-a-node-project","siteSpaceId":"sitesp_wySi9","description":"Setting up a Node project for smart-contracts","breadcrumbs":[{"label":"Blockchain"},{"label":"Smart Contract Guide"}]},{"id":"ObiCXZT70QQvvUSjNY47","title":"Developing smart contracts","pathname":"/blockchain/smart-contract-guide/developing-smart-contracts","siteSpaceId":"sitesp_wySi9","description":"This guide will let you get started writing Solidity contracts","breadcrumbs":[{"label":"Blockchain"},{"label":"Smart Contract Guide"}]},{"id":"pb1qxn6WCWNKFcjRgo3K","title":"SQL Interview Questions","pathname":"/interview-questions/sql-interview-questions","siteSpaceId":"sitesp_wySi9","description":"In this document, you can find the list of some commonly asked SQL interview questions.","breadcrumbs":[{"label":"Interview Questions"}]},{"id":"C3mxkMLBsNQVMWISVbp5","title":"Power BI Interview Questions","pathname":"/interview-questions/power-bi-interview-questions","siteSpaceId":"sitesp_wySi9","description":"This document will try to highlight some of the most common interview questions asked in Power BI","breadcrumbs":[{"label":"Interview Questions"}]},{"id":"6H4gSJMJW2IEPPaBlpVW","title":"Exercise 0","pathname":"/t-sql-exercises/exercise-0","siteSpaceId":"sitesp_wySi9","description":"Function in SQL","breadcrumbs":[{"label":"T-SQL Exercises"}]},{"id":"RhuHy4YlKRgMAaffuDlz","title":"Exercise 1","pathname":"/t-sql-exercises/exercise-1","siteSpaceId":"sitesp_wySi9","description":"","breadcrumbs":[{"label":"T-SQL Exercises"}]},{"id":"bAerLb4q644C6Zf32WRN","title":"Exercise 2","pathname":"/t-sql-exercises/exercise-2","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"T-SQL Exercises"}]},{"id":"nilNn0txZtWYi8MPTvRS","title":"Exercise 3","pathname":"/t-sql-exercises/exercise-3","siteSpaceId":"sitesp_wySi9","breadcrumbs":[{"label":"T-SQL Exercises"}]},{"id":"u9tU4BLgJYYxxukvLxAt","title":"Ultimate SQL Server Cheat Sheet","pathname":"/cheat-sheet/ultimate-sql-server-cheat-sheet","siteSpaceId":"sitesp_wySi9","description":"This ultimate SQL Server cheat sheet is designed to be a quick reference guide for database administrators, developers, and data analysts. It covers fundamental commands, concepts, and best-practices.","breadcrumbs":[{"label":"CHEAT SHEET"}]}]}