PG Program in Business Analytics

• Overview_Excel
• How To Write Down Data In Excel
• Basic Formula

• Overview_Function_ppt
• Upper_lower_Function(All Basic Function Write Down)
• Simple_if_Function,Sum_if(Simple_Conditional Formating)
• Text_column and Multiple _if
• Sum_if and Sum_ifs
• Average_if and Average_ifs
• Use Referances

• LOOKUP
• OverView Of Vlookup, Index, Hlookup
• HLOOKUP, COMMENT
• vlookup + match
• vlookup
• VLOOKUP WITH WILDCARD
• VLOOKUP+CHOOSE+DSUM+DCOUNT
• MATCH
• INDEX_MATCH
• IMAGE_LOOKUP

• DATE_FUNCTION
• DATE_DIFF
• work_days and Network_days Function
• CONSOLIDATE_REMOVE DUPLICATE
• DATA TABLE
• DATA_VALIDATION
• FLASH_FILL+FREEZE PEN
• GOAL SEEK AND SCEANIRYO
• INDIRET_DEP
• PIVOT_TABLE PPT
• TIME
• PIVOT_TABLE PRATICAL1
• PIVOT_TABLE PRATICAL2
• DOUBLE_VLOOKUP
• FINANCIAL_FUNCTION
• PIVOT_TABLE
• PIVOT_TABLE_OPTION
• PIVOT_TABLE_+REPORTFILTER
• CHARTS_USING CONDITIONAL FORMATING
• SPARKLINE
• PIVOT_CHARTS
• filter_pivottable
• SUB_TOTAL
• VISIBLE_CELLS_ONLY
• PIVOT_TABLE_GROUP
• GROUPING+CHARTS
• WORKING WITH _OBJECTS
• ONE_PIVOTTABLE WITH TWO SLICERS
• DASHBOARD

• MACRO
• MACRO+CODING
• MACRO EXAMPLES
• CUSTOM_FORMATING
• ADVANCE_FILTER
• PIVOT_TABLE_NEW
• MACRO_PPT
• MACRO_DATABASE
• ADVANCEFILTER+MACRO
• RELATIVE_REFRENCES
• MACRO_BASIC
• form_contro
• Option_control(checkbox+option)
• DIFFERENCE_BETWEEN(ACTIVEX+FORM CONTROL)
• COMBOBOX VALUE
• FORM WITHOUT VBA
• RELATIONSHIP_PIVOTTABLE
• PASTE SPECIAL

Tableau is a visual platform for business intelligence and analytics which allows users to monitor, comprehend, observe, and make choices with a range of data. It allows you to produce any kind of graph, plot, or chart without scripting.

You can learn how to handle various types of data, plot, analyze, sort, and summarise the entire data.

Tableau Reports are a built-in feature of Tableau that allows users to display data from different sources into reports to better comprehend how far they have progressed toward their goals, better understand their customers' needs, and forecast future plans.

You will use calculated fields to generate new data from existing data in your data source. When you build a calculated field in your data source, you are efficient in including a new field (or column) whose values or members are determined by a computation that you control.

Table computations are modifications that can be applied to the data in a display. They are a kind of calculated field that works with Tableau's local data based on what is already in view.

Parameters let you change a reference line, band, or box dynamically. For instance, reference a parameter rather than a reference line at a defined position on the axis. The reference line could be moved using parameter control.

An interactive dashboard allows you to dive down and filter operational data, allowing you to see data from multiple angles or in more depth. Dashboards allow data-driven business choices by providing a simplified and clear overview of overall business information.

A narrative in Tableau is a set of visuals that work together to present data. You can use tales to convey a data story, offer context, display how steps affect results or make a strong argument.

In this module, you will learn to join the tables, data blending and make connections, etc.

In this module, you will learn to share Workbooks, Publish to Reader/PDF and Publish to Tableau Server and share on the web.

Power BI is an analytics tool that enables business users to analyze data and distribute insights throughout the organization at all levels. Through interactive and easy dashboards, Power BI offers an end-to-end view of important metrics and key performance indicators, all in real-time and in one place.

In this module, you will learn how to find Power BI services and apps that interact. Investigate how Power BI can help you to run your business more effectively, and figure out how to make eye-catching graphics and reports.

You will use Power BI to connect to data in text-based files, third-party directories, Microsoft Azure directories, along with web services like Google Analytics and SalesForce, among others. You will learn about how you can get the data in Power BI.

Power Query offers a series of capabilities designed to help you in cleaning and preparing your data for analysis. For deeper analytics, you will learn ways to simplify a complicated model, alter data types, and rename items.

It is about simplifying the chaos with regard to creating an outstanding data model. In this module, you will find out about the vocabulary and implementation of star schemas, which is one technique to simplify a data type. You will also learn why selecting the right data granularity is vital for Power BI report efficiency and readability.

Visualizations are representations of data insights. A Power BI report may have a single page with a single graphic or a lot of pages with multiple visuals. Visuals from reports can be connected to dashboards in the Power BI service.

Data Analysis Expressions (DAX) is a scripting language that is used to create custom tables, measurements, or calculated columns in Microsoft Power BI. It is a set of capabilities, operators, and also constants that can be used to calculate and return one or more values using a formula, or expression.

Dashboards enable report users to make a single object of directed data that is created for particular requirements. Dashboards could be made up of different graphics pulled from various reports.

Each service combines gateways differently and administration choices can change. This module pertains to the manage gateways page in Power BI, also, you will deal with gateways from any service.

With Power BI, Row-Level Security (RLS) can be used to restrict data access for users. You can add filters inside roles to limit data access at the row level. In this module, you will learn how to set up RLS.

With Power BI, row-level security (RLS) can be used to limit data access for users. You can build filters inside roles to restrict data access at the row level. With this module, you will learn how to set up RLS.

Paginated reports, as the name implies, can span many pages. They are formatted in a certain way and allow for exact modification. They are used to create paginated reports. The Power BI Report Server web portal, like the SQL Server Reporting Services (SSRS) website, allows you to save and control paginated reports.

You will also get a chance to focus on multiple use cases that will enable you to improve your analytical.