This is a series of on going video tutorials. Starting from the basics, in each video we will cover python topics one by one. If you intend to learn Python as a bigginer from start, we suggest you start this course. Python Lesson 001: Introduction, Installation and OptionsPython Lesson 002: Communicating with Python using Print()…
Traditionally, custom functions in Excel were created using VBA, a programming language. However, Microsoft introduced the LAMBDA function in 2020, allowing users to create custom functions without coding. Inspired by lambda calculus, LAMBDA functions are defined with a name, parameters, and a formula. They can be used directly or named for future reference. By using…
This tutorial provides a comprehensive overview of Power Pivot in Excel, covering topics such as data modeling, creating relationships, working with measures and KPIs, using OLAP tools, calculated columns, perspectives, and synonyms. It also demonstrates how to enable Power Pivot, connect to external data sources, and create pivot tables and charts. Additionally, the tutorial explains…
This tutorial provides a comprehensive guide to pivoting and unpivoting data within SQL Server. We’ll delve into the process of transforming data from a row-based to a column-based format, and vice versa. You’ll learn how to pivot data based on single or multiple columns, as well as how to unpivot pivoted data to restore its…
This tutorial demonstrates how to create a comprehensive Power BI report using data from a SQL Server database. We’ll delve into various analytical techniques, including geographic analysis, branch-wise performance, and deposit movement. The report will feature interactive dashboards with visualizations like maps, charts, and tables. By the end, you’ll be able to create insightful reports…
This video tutorial introduces SQL views and demonstrates how to create and use them for data analysis. It begins by explaining what views are and their purpose, then proceeds to use a hypothetical bank database, Nexus Bank, as an example. The tutorial covers creating tables, importing data from CSV files, and building various views to…
This video tutorial introduces time intelligence calculations and their visualization using Power BI dashboards. It covers various time intelligence concepts, including time series, time bucketing, year-over-year comparison, moving averages, and year-to-date analysis. The tutorial demonstrates how to import data into Power BI, create different visualizations like pie charts and line charts, and perform calculations to…
This tutorial demonstrates how to generate HTML documents using SQL queries. By embedding HTML code within SQL queries, you can create dynamic reports containing text, charts, and other elements. This approach eliminates the need for separate applications and streamlines the report generation process. The tutorial covers topics such as creating SQL tables, inserting data, using…
The video tutorial demonstrates how to use Gemini to analyze data using SQL without writing SQL queries manually. It covers topics such as describing scenarios in text or providing pictures to Gemini for query generation, modifying queries to achieve desired results, creating views for permanent query results, and using Gemini to create tables and insert…
The video tutorial demonstrates how to create a comprehensive report in MS Excel using a drop-down list. The tutorial begins by explaining how to set up a data set with quarterly sales information, including location details. It then guides viewers through the process of creating a drop-down list, which allows users to select specific countries,…