PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

CHAPTER 01

INTRODUCTION TO POWER BI

Power BI is a business analytics software developed by Microsoft that enables you to visualize your
data, collaborate with others, and make informed data-driven decisions. It's part of the Microsoft Power
Platform and has integration with multiple data sources, such as Excel, SQL Server, cloud services,
and many others.

Key Components of Power BI:

1. Power BI Service:

• A PC application utilized for generating reports and dashboards.

• It enables users to connect to different data sources, shape data, produce visuals, and construct
interactive reports
• Power BI Desktop is free and is where most of the report design and data modeling occurs.

2. Power BI Mobile:

• A mobile application that allows you to view and engage with Power BI reports and dashboards on your
tablet or smartphone.
• Available for both iOS and Android.

3. Power BI Gateway:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 1

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

• It is utilized to refresh on-premises data sources to the Power BI service.

• Two types of gateways: Personal Gateway for individual usage, and Enterprise Gateway for
organizations and teams.

4. Power BI Report Server:

• A report server that you can host on-premises to publish, manage, and share Power BI reports and
classic paginated reports.

 Major Power BI Features:

• Connectivity: Power BI supports connection to numerous data sources, such as databases, Excel, cloud
(Azure, Google Analytics), and web data.

• Transformation: With the Power Query Editor, data can be cleaned, transformed, and shaped to have the
correct format for analysis.

• Data Modelling: Power BI enables users to establish relationships between the various tables, create
calculated columns, and create advanced measures through DAX (Data Analysis Expressions).

• Visualizations: Power BI offers a diverse range of built-in visualizations such as bar charts, line graphs,
scatter plots, pie charts, maps, and much more. Users can also add custom visuals from the marketplace.

• Dashboards: You can have customized dashboards that show important metrics and KPIs, allowing users to
easily get an overview of the status of their business.

• Collaboration: Power BI enables you to easily share reports and dashboards with others within your
organization, and it also supports integration with Microsoft Teams and other collaboration software.

• Data Refresh: You can have data refreshes scheduled so that your reports and dashboards are based on the
latest information.

• Artificial Intelligence: Power BI includes embedded AI capabilities to assist with data insights, such as
automatic insights, machine learning models, and natural language processing (Q&A).

 ADVANTAGES OF POWER BI:

 User-Friendly: Power BI is developed to be user-friendly for technical and non-technical users. The
drag-and-drop feature makes it possible for users to create complex reports without writing code.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 2

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Affordable: The Power BI Desktop is free, and the Power BI Service offers a relatively priced model
according to your company's requirements.
 Integration: Power BI has good integration with other Microsoft tools such as Excel, SharePoint, and
Teams, among a host of other third-party data sources and cloud services.
 Real-Time Analytics: Since it can connect to live data sources and schedule data refreshes, Power BI
enables real-time data analysis.

COMMON USE CASES:

• Business Intelligence: Power BI assists companies in evaluating sales performance, customer

activity, and market patterns to make decisions based on data.
• Reporting: Organizations use Power BI for financial reporting, operational reporting, and executive
dashboards to provide insights to key stakeholders.
• Data Visualization: Power BI enables users to visualize complex information in an understandable
manner using charts, graphs, and other visualization tools.

Power BI is a must-have application for anyone engaged in data analysis, offering powerful means of analyzing,
visualizing, and distributing data to companies. Whether you are an individual or an organization, Power BI can
assist you in making wise decisions based on accurate and up-to-date information.

PASSENGER FLOW AND OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 3

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

In the fast-paced world of aviation, ensuring smooth passenger flow and operational efficiency is essential for
delivering exceptional service and maintaining high performance. Airports and airlines face a multitude of
challenges, from managing passenger crowds during peak times to optimizing flight schedules and resource
allocation. To tackle these challenges, data-driven decision-making plays a pivotal role in streamlining
operations.

Power BI, with its powerful data visualization and analytics tools, provides a comprehensive solution for
analyzing passenger flow and operational efficiency within the aviation industry. By connecting to diverse data
sources from check-in systems and baggage tracking to flight schedules and security checkpoints Power BI
enables stakeholders to gain real-time insights into every aspect of airport and airline operations. With
interactive dashboards and detailed reports, it becomes easier to identify trends, predict bottlenecks, and make
informed decisions to enhance both the passenger experience and operational performance.

Through this approach, aviation professionals can continuously monitor key metrics such as wait times, staff
allocation, flight punctuality, and passenger satisfaction, ultimately driving improvements across the entire
aviation ecosystem.

IMPORTANCE OF THE TRAINING UNDERGOME

The importance of Power BI training can be highlighted in ways that directly connect with both personal growth
and organizational success. Here are some humanized points that emphasize the value of mastering Power BI:

1. Empowering Individuals with Data Literacy

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 4

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

Power BI training gives individuals the ability to understand and make sense of data in a way that is meaningful
and impactful. In a world where data is everywhere, being able to confidently navigate and analyze it is a skill
that sets people apart. For many, learning Power BI is the key to not just performing their job but excelling at it,
turning data into insights that drive better decisions every day.

2. Unlocking New Career Opportunities

In today’s job market, data skills are in high demand. Power BI training can open doors to new career paths or
promotions by equipping you with a sought-after skill. Whether you’re looking to advance within your current
role or pivot to a new career, knowing Power BI allows you to stand out as someone who can harness data to
create value, which is something employers are actively looking for.

3. Saving Time and Boosting Productivity

Training helps you become more efficient with Power BI, cutting down on time spent manually gathering and
processing data. Instead of wasting hours searching for reports or creating them from scratch, you can
automate tasks and get real-time insights in a fraction of the time. This means more time for making impactful
decisions and less time spent on mundane, repetitive tasks.

4. Fostering a Data-Driven Culture in Organizations

When employees are well trained in Power BI, it sparks a data-driven culture where decisions are based on
facts and trends, rather than gut feeling or guesswork. This shift can transform how an organization operates,
leading to better outcomes and smarter decisions at all levels. Power BI training is key to ensuring that
everyone in the organization—from top executives to team members—has access to the right insights, enabling
collaboration and alignment across departments.

5. Improving Decision-Making with Confidence

Having Power BI skills means you can trust your data and the insights it provides. Instead of feeling uncertain or
overwhelmed by numbers, trained users can confidently interpret complex data sets, create meaningful
visualizations, and make decisions based on solid, actionable information. This confidence translates to more
strategic, thoughtful, and effective decision-making, whether it’s in a boardroom or day-to-day operations.

6. Bridging the Gap Between Technical and Non-Technical Roles

One of the greatest strengths of Power BI is that it’s accessible to both technical and non-technical users.
Training helps bridge the gap, enabling everyone—from analysts to business managers—to understand and

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 5

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

work with data. This makes it easier for teams to collaborate, as everyone speaks the same language when it
comes to data, fostering better communication and understanding.

7. Enhancing Job Satisfaction and Engagement

Knowing that you have the tools and skills to analyze and interpret data effectively can make your work more
engaging. Power BI training not only makes you more efficient but also empowers you to uncover insights that
can influence strategic decisions, boosting your sense of accomplishment and contribution to the organization’s
success. For many, this leads to greater job satisfaction and a more fulfilling work experience.

8. Building Long-Term Organizational Success

For organizations, investing in Power BI training means they are investing in the future. It allows companies to
make smarter, data-driven decisions that can improve processes, enhance customer experiences, and drive
growth. In a competitive market, organizations that leverage their data effectively are better positioned to stay
ahead, innovate, and thrive. Power BI training ensures that the entire team is aligned in using the best tool to
turn data into a strategic asset.

In essence, Power BI training is not just about learning a tool; it’s about transforming the way people and
organizations approach data. It empowers individuals, fosters collaboration, boosts productivity, and ultimately
drives better outcomes, whether on a personal or organizational level.

Need of the training undergone

Power BI training can really pay off if you're working on data analysis, reporting, or creating dashboards. There
are a number of reasons Power BI training would be necessary below:

1. Data-Driven Decision Making

Power BI makes it possible for you to derive meaningful insights out of raw data so that businesses can make
clear decisions based on actual-time information.

2. Ease of Use

Power BI's interface is intuitive, but unless you receive training, you will not be able to unlock its potential.
Training will make you learn how to efficiently use the tool from data import to visualization and reporting.

3. Data Connectivity

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 6

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

Power BI allows connection to a wide range of data sources, including Excel, databases, cloud-based
platforms, and more. Learning how to connect, transform, and clean your data properly can be a game changer.

4. Advanced Features

With training, you will learn advanced features like DAX (Data Analysis Expressions) for custom calculations,
Power Query for data transformation, and how to build interactive dashboards that convey your data story
effectively.

5. Collaboration and Sharing

Knowing how to share reports and work with teams on various platforms (like Power BI Service) means that you
can share your insights quickly and securely.

6. Time Efficiency

Power BI's automation and data refresh capabilities save time on mundane tasks. With training, you will be able
to schedule data updates and use shortcuts to automate your work.

7. Career Development

Power BI is highly sought in most industries (financial, healthcare, marketing, etc.). Knowledge of Power BI is a
plus for your resume, enhances your chances of getting better employment, and improves your overall
professional capabilities.

 Getting Started with Power BI Training:

 Online courses : Online platforms such as Coursera, Udemy, LinkedIn Learning, and edX provide
structured courses from beginners to advanced learners.
 Microsoft Learn : The Microsoft learning platform has free modules and learning paths for Power
BI.
 Practice : Hands-on practice is important. Begin by practicing with datasets you know or find public
datasets to create dashboards.
 Webinars/Workshops : Online training classes or workshops present a chance to engage live with
experts and get answers in the moment.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 7

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

CHAPTER 02

Description of the training

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 8

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

2.1 TYPES OF TRAINING UNDERGONE

The training process was planned with practical and theoretical learning methods. A significant portion of the
training included hands-on practice, where students worked with real-time queries to retrieve and pre-process
data for absenteeism. Technical training included learning advanced Excel procedures like regression analysis
and moving averages in an effort to enhance prediction accuracy. Besides, the training also included a data
analytics training module that discussed identifying key patterns of absenteeism and their general implications
on workforce management. By incorporating all these elements, the training offered a balanced approach that
enabled the participants to be able to apply their knowledge in real-life scenarios.

The usefulness of the training undergone

From a learner's point of view, this training was highly beneficial in terms of improving technical and analytical
skills. The most significant part of the training was enhancing data analysis skills, which enabled me to work
with large datasets using SQL and Excel confidently.

Being able to extract, clean, and manipulate data effectively was a major learning that will be useful in academic
projects as well as future career prospects. The training also taught predictive modelling. which allowed me to
look at trends and predict absenteeism, which was a cool and real-world application of data science.

The training also enhanced my decision-making and problem-solving skills by promoting a data-driven solution
to the problem of absenteeism. Understanding how to visualize and interpret data with Excel charts and
statistical software gave me a better idea of the application of analytics in actual workforce management.

Aside from the technical, the training also enhanced my critical thinking and ability to manage structured data
effectively, competencies that are useful in any course or line of work. Overall, this training was a valuable

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 9

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

experience that taught me both the theoretical aspects as well as the practical skills in data analysis and
predictive modelling.

Benefits of Advanced Excel Training:

Excel is an incredibly powerful software for data handling and analysis, and Advanced Excel training enables
you to tap into its full potential.

 Improved Data Handling:

 Data Organizing: Advanced Excel trains you in structuring and arranging data better. This makes you
able to work with even larger data sets without feeling overloaded.
 Example: Let's consider a huge sales report containing tens of thousands of rows. Such Advanced
Excel abilities as sort and filter will make you speed up organizing and isolating significant data.

 Enhanced Decision Making:

 Using Formulas & Functions: Advanced formulas such as `SUMIFS`, `VLOOKUP`, `IFERROR`, and
`INDEX/MATCH` enable you to automatically perform more intricate calculations, saving time and
minimizing errors.
 Example: You can automatically calculate sales figures for various regions or determine which product
is selling the best without adding up numbers manually.

 Handling Big Data with Ease:

 Pivot Tables: Pivot tables help condense large data sets into bits that are easy to manage, so you can
easily tell trends and patterns.
 Example: If you have year-long sales data, you can use a Pivot Table to easily tell which months sold
most or which products sold the most.

 Creating Visual Insights:

 Charts & Graphs: Advanced Excel allows you to create more advanced charts like heat maps,
histograms, and sparklines, which makes it easier to spot trends and patterns in your data.
 Example: You could create a line graph to show how your sales numbers have grown over the
past year, making it easier for others to understand your analysis.
 Automating Tasks:
 Macros & VBA: You can automate tasks using Macros and Visual Basic for Applications (VBA) in
Excel. That means things you repeatedly do, such as formatting or data analysis, can be done
automatically, giving you plenty of time to save.
 Example: If you are required to format reports on a weekly basis, you can create a basic macro to
perform the task for you with the touch of a button.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 10

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Data Preparation and Cleaning:

Power Query: Advanced Excel shows you how to prepare and clean data before analyzing it. With
Power Query, you can eliminate duplicates, correct errors, and reshape data into the correct format for
analysis.

- Example: If your data contains errors such as missing values or inconsistent date formats, Power Query can
automatically correct that.

 Usefulness of Power BI Training:

Power BI is an effective tool for visualizing and sharing data insights. Why Power BI training is important:

1. Build Interactive Dashboards:

- Visual Reports: Power BI enables you to develop interactive dashboards and reports that enable you to
visualize data in different manners (e.g., bar charts, line graphs, maps). These are simple to comprehend and
enable users to navigate the data themselves.

- Example: You can design a sales dashboard where the user will be able to click on a particular region or
product category to drill down into deeper data.

2. Easy Data Connections:

- Multiple Data Sources: Power BI supports connecting to many data sources (Excel, databases, cloud
services, etc.). This allows you to consolidate all your data in one location for analysis.

- Example: If your information is in Excel, but you have other data online in a database, Power BI can connect
both, pulling them into the same report where you can compare them.

3. Powerful Data Analysis with DAX:

- Advanced Calculations: Power BI employs DAX (Data Analysis Expressions), an advanced formula language,
to compute complicated calculations such as totals, averages, percentages, and others. With the ability of DAX,
you can define bespoke metrics that are more than simple formulas.

- Example: You may develop a measure that computes year-over-year growth rate for sales, adjusting
accordingly when data changes.

4. Real-Time Data Insights:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 11

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

- Automatic Data Refresh: Once your data is set up in Power BI, you can make updating it an automated
process. That way, your reports and dashboards are always displaying the latest data without having to
manually update them.

- Example: Your sales dashboard can be automatically refreshed on a daily basis, so that when you look at it in
the morning, it already contains the latest sales data.

5. Sharing and Collaboration:

- Cloud-Based Sharing: Power BI enables you to publish your reports to the cloud and share them with
colleagues. Several individuals can view and interact with the same report simultaneously, facilitating
collaboration.

- Example: By generating a month-over-month sales report in Power BI, your team or manager can view and
share it across your organization anywhere, anytime so you can make intelligent decisions.

6. Improved Business Decision Making:

- Interactive Charts and Dashboards: With the interactive charts and dashboards that come with Power BI,
you are able to instantly identify patterns and outliers with the ability to make intelligent decisions.

- Example: You can easily identify what's selling the most or what areas are not performing, and make informed
data decisions for betterments.

7. Simpler Data Transformation:

- Power Query for Data Prep: Power BI comes with an inbuilt feature called Power Query that assists you in
cleaning and transforming your data, making analysis simpler.

- Example: If you possess customer data of various types (e.g., dates in a certain type, numbers in a different
type), Power Query enables you to cleanse that data in a way you can analyze.

8. Scalability and Flexibility:

- Large Data Sets Management: Power BI can process vastly larger data sets than Excel and is more
productive for distributing these large sets within a consumable format.

- Example: When you're working with millions of rows of data, Power BI makes it easier to visualize and get
familiar with that data compared to Excel.

How Both Advanced Excel and Power BI Training Are Useful:

1. Complementary Skills:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 12

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

- Excel is great for in-depth data analysis, calculations, and working with smaller data sets, whereas Power BI is
meant for developing interactive, high-level dashboards and reports that can be shared with others. Mastering
both provides you with the capability to work with data from all sides—from intense analysis in Excel to sharing
insights in Power BI.

2. Increased Job Opportunities:

- Most companies use both Excel and Power BI for data management and analysis. To be proficient in both can
help you become a better candidate for the job market, particularly data analyst, business analyst, or financial
analyst jobs.

3. Improved Productivity:

- Automating Excel tasks and building real-time dashboards in Power BI can save you a lot of effort and time.
This gives you more time to concentrate on decision-making and data analysis instead of wasting time on
manual work.

4. Better Decision-Making:

- Whether you do it in Excel or Power BI, being able to analyze data effectively translates into making better,
data-driven decisions, which means improved results for your team or company.

Key Advantages:

• Improved Technical Skills: Acquired skills in SQL for data retrieval and Excel for data visualization.

• Knowledge of Predictive Analysis: Acquired knowledge on how to predict absenteeism patterns and use
predictive models.

• Preparation for Future Professions: Acquired key data analytics skills that can be used across different
industries.

Conclusion:

Learning Advanced Excel and Power BI enables you to handle, analyze, and report data in a more efficient
way. These enable you to become more productive, efficient, and better equipped to provide insights to make
business decisions better. Learning both of these exposes you to new career prospects and enhances your
data literacy overall.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 13

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

CHAPTER 03

TRAINING OUTCOMES

3.1 KNOWLEDGE ACQUIRED

As a trainee in this training program, I have gained beneficial skills and expertise to evaluate and predict trends
of employee absenteeism through data analysis and forecasting techniques. Through experiential training and
practical case studies, I have gained proficiency in using SQL Workbench and Excel for the retrieval, analysis,
and presentation of data. I have also gained critical thinking and problem-solving skills to meaningfully interpret
data on absenteeism and make knowledgeable decisions. This report summarizes my learning achievements,
skills mastered, and evidence of competence, testifying to my preparedness to implement these concepts in the
workplace.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 14

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

In this training I gained a solid understanding of the theory and practice of HR software, its ability to dramatically
boost operational efficiency. The major knowledge areas were proficiency in fundamental software functions,
such as management of employee information and leave balances; skills in precise data input and upkeep for
data integrity; capability to produce tailored reports to support data-driven decision-making; and familiarity with
workflow automation to streamline processes like onboarding and performance appraisals. Participants learned
to make use of self-service portals to empower employees and minimize administrative burden. They also
gained an insight into how recruitment can be optimized using applicant tracking and streamlined onboarding
processes. In addition, the training stressed the significance of compliance and security in the HR software, and
how performance management capabilities can monitor employee goals and feedback. Ultimately, we are now
able to effectively make use of HR software to enhance overall HR operations.

Knowledge Gained in Excel Training

 Data entry, sorting, and filtering

 Creating and using formulas/functions
 Data analysis with pivot tables and charts
 Data validation and cleaning
 Conditional formatting

Knowledge Gained in Power BI Training

 Connecting and transforming data

 Data modeling with relationships and DAX
 Visualizing data with interactive reports and dashboards
 Advanced visualization techniques (e.g., drill-downs, custom visuals)
 Sharing reports and collaborating in Power BI service
 Integration with Excel for seamless data handling

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 15

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

3.2 SKILLS MASTERED

Power BI Skills:Power BI is a tool used for visualizing data and creating reports that are easy to understand.
Here are some key skills that I have learned during training period:

1. Data Importing and Cleaning:

 I have skilled how to extract data from different sources such as Excel, SQL databases, and web
sources (web pages, cloud storage).
 How to clean the data (de-duplication, error correction, formatting data properly) to be utilized in your
reports.

2. Data Transformation with Power Query:

 Power Query is a feature within Power BI that assists you in transforming the way data appears. For
instance, you can filter data, reorder columns, split or combine columns, and create new calculated
columns.

3. Building Data Models:

 In Power BI, you will be taught how to structure your data into tables and establish relationships
between them (such as linking customer data with sales data). This simplifies the handling of lots of
data from various sources.

4. Creating Visualizations:
 You'll become an expert at making various types of visualizations (graphs, charts, tables, etc.) that
facilitate presenting data in a form that is easy to comprehend.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 16

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 For example, making pie charts for proportions, line graphs for trends over time, and bar charts for
comparing categories.

5. DAX (Data Analysis Expressions):

 This is a formula language used to perform calculations in Power BI. You’ll learn how to write DAX
formulas to create new data columns, measures, and perform complex calculations.
 For instance, year-over-year growth or the overall sales of a specific product.

6. Dashboards and Reports Creation:

 You'll be able to create interactive dashboards where users can click on a particular section of the
report to view filtered data or view further details.
 Power BI further enables you to publish such reports on the web or share them with others.

7. Power BI Service:
 I understood how to share your reports and collaborate with others through the Power BI cloud service.
 I can automate data refresh, handle security, and monitor usage of the reports.

8. Publishing and Sharing:

 You will understand how to publish your reports to the Power BI service and share them with others
within your company or with external users.

Advanced Excel Skills:

Excel is a robust spreadsheet program, and mastering advanced features simplifies handling, analyzing, and
presenting data. Below is the skill breakdown:

1. Advanced Formulas and Functions:

 I have become proficient in more advanced Excel formulas such as VLOOKUP, INDEX/MATCH, IF
statements, and SUMIFS, which assist you in searching, calculating, and manipulating data in large
datasets.
 Array formulas are also explained, which enable you to do several calculations on one or more items
within an array (range of cells).
2. Data Validation:
 Discover how to establish rules regarding what kind of data can be entered into the cells, so that the
data is valid (e.g., to make sure a phone number has only numbers or to create dropdown lists).

3. The use of Pivot Tables and Pivot Charts:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 17

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Pivot tables enable you to summarize large volumes of data neatly and clearly.
 Master grouping, filtering, and re-arranging data with a mere click or two, and making charts from your
summarized data.

4. Advanced Charting Techniques:

 Learn to generate dynamic and informative charts (such as waterfall, funnel, or combo charts) to make
your data storytelling more precise and effective.

5. Conditional Formatting:
 This enables you to change the look of a cell automatically (e.g., color cells red if the value exceeds a
limit). This makes it easy to highlight trends or spot important data points.

6. Macros and VBA (Visual Basic for Applications):

 Using Macros, you have the ability to automate tasks like formatting, entering data, or creating reports,
which are time-consuming.
 Using VBA, you can create personalized scripts to automate more advanced-level tasks or add
personal Excel functions.

7. Power Query in Excel:

 Just like Power BI, Excel also has a Power Query feature for importing, massaging, and cleansing data
before using it.
 With Power Query, you can merge information from various sources, reformat it, and clean it out
without having to go through every line manually.

Summary of Key Differences Between Power BI and Advanced Excel:

- Power BI is more centered around data visualization and dashboard development, with support for connecting
to multiple data sources and developing interactive reports.

- Advanced Excel is more centered around data manipulation, analysis, and calculation within a spreadsheet,
with features such as pivot tables, advanced formulas, and macros to increase productivity.

- Both applications are capable in themselves, but Power BI is ideal to use with huge datasets, design dynamic
reports, and publish dashboards on the web, and Excel is great at doing detailed analysis, calculation, and
everyday data management.

3.3 Proof for operations using skills

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 18

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 19

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 20

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 21

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 22

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

CHAPTER 04

PLACEMENT ANALYSIS

4.1 PLACEMENT OPPORTUNITIES IN INDIA

With Power BI and advanced Excel abilities, you could play roles such as Business Intelligence Analyst, Data
Analyst, Data Visualization Specialist, or even Power BI Developer, with potential to work in many industries
such as finance, healthcare, e-commerce, and technology.

1. Data Analytics
 Job Description: Core role for Excel and Power BI users.Companies use them to find insights, trends,
and create dashboards.
 Job Title: Analyze workforce statistics, determine employee behavior trends, and forecast
absenteeism patterns based on SQL and Excel.

Average Salary Package: ₹6-12 LPA

2. Business Intelligence (BI) Analyst

 Job Description:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 23

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Examine complex data to inform business decisions. Uses Power BI to design reports and
visualizations to tell stories to stakeholders.
 Business analyst major role is Capturing, checking and recording business requirements.
 Representing business processes and determining prospects for process refinements.
 Determining existing and proposed solutions' issues, risks and advantages and detailing business eff
ects.

 Critical thinking, problem solving and decision making are three crucial strengths that are required from
a good business analyst.

3. MIS Executive / MIS Analyst

 Job Description:

• MIS (Management Information System) Executive plays a crucial role in an organization

• Create reports for management, track KPIs, automate dashboards.
• They're used to generate valuable reports that inform decision-makers.
• Excel is heavily used Power BI is a plus.

 Average Salary Package: ₹2.5 – ₹5 LPA

4. Financial Analyst

 Job Description:
 Financial analyst Produce financial modeling to investors to identify the profitable investment.
 Make recommendations of individual investments as well as investments in sets.
 Evaluate the performance of bonds, stocks, as well as other investments.
 Power BI is used for financial dashboards and reporting
 Use Excel for modeling and forecasting.

 Average Salary Package: ₹6 L PA

5. Operations Analyst

 Job Description:

 Analyze operational efficiency, create reports on logistics, supply chain, etc.

 Use Excel and Power BI for real-time tracking.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 24

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Salary Package:

 Entry-Level/Junior: ₹2.84 lakhs to ₹3 lakhs per year

 Mid-Level: ₹8 lakhs to ₹12 lakhs per year
 Senior-Level: Above ₹15 lakhs per year
 Average Salary: ₹5.72 lakhs per year in Bengaluru

6. Sales / Marketing Analyst

 Job Description:

 Track campaign performance, sales targets, conversions.

 Create dashboards and reports to support decision making.

 Salary Package:

 Entry-level:₹3.2 lakhs per year.

 Average Salary:₹500,000 per year.
 Experience:₹1.32 million per year.
 Digital Marketing Analyst:₹5,00,000 per year, with an average salary of ₹4,50,000 per year.

7. Reporting Analyst / Data Visualization Specialist

 Job Description:
 Data Visualization Specialist convert raw data into a graphical form.
 Employing their visualisation tools, software, and skills, they will subsequently transform the data
into suitable visual representations based on the purposes of the data.
 Build dashboards and automated reports using Power BI.
 Create storytelling with data.
 Salary Package:
 Average Salary: ₹6.0 Lakhs per annum.
 Fresher Salaries:₹2.4 to ₹8.3 Lakhs per year, depending on the company, location, and skill set.
 Experience:
 Mid-Level: ₹8.0 to ₹12.0 Lakhs annually
 Senior-Level: ₹15.0 Lakhs.

8. Freelancer / Consultant

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 25

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 they are employed to give their skills and experience in order to enable businesses achieve objectives
and fix challenges.
 businesses engage consultants to conduct everyday operations and complement or add personnel
without the burden that comes with hiring a full-time worker.
 Many small businesses need dashboards, data clean-up, Excel automation.
 You can get freelance projects via platforms like Upwork, Freelancer, Fiverr.

 Salary Package:

 Average Salary: ₹17.0lakhs per year to ₹50.0lakhs per year

 Top Companies Hiring in India

 IT & Tech: TCS, Infosys, Wipro, HCL, Cognizant, Tech Mahindra, Accenture
 Finance & Consulting: Deloitte, KPMG, EY, PwC, Genpact
 Retail & FMCG: Reliance Retail, BigBasket, Flipkart, Amazon, HUL
 Start-ups: Zomato, Swiggy, Ola, BYJU’S, Meesho, Razor pay
 Banking & Insurance: HDFC, ICICI, SBI, Axis Bank, Kotak, Bajaj Allianz
 Healthcare & Pharma: Dr. Reddy's, Apollo, Cipla, etc.

Role Salary Range (INR per

annum)
Data Analyst ₹3.5 – ₹7 LPA
MIS Executive ₹2.5 – ₹5 LPA
Business Analyst ₹4 – ₹8 LPA
Reporting Analyst ₹3 – ₹6.5 LPA
Power BI Developer ₹5 – ₹9 LPA

Best Job Portals to Find These Jobs

 LinkedIn
 Naukri.com
 Indeed
 Monster India
 Shine.com
 Internshala (for internships/fresher roles)
 Turing, Upwork, Fiverr (for freelance gigs)

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 26

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

4.2 GLOBAL PLACEMENT OPPORTUNITIES

Power BI is a widely used business intelligence (BI) tool for data analysis and visualization, and its application
in organizations across the globe has provided a range of global placement options for Power BI professionals.
The jobs fall across industries like finance, healthcare, retail, and technology and include analyzing data and
presenting insights in an intuitive and easily comprehensible manner.

1. Power BI Developer

 Job Description: Using Power BI, you will design, implement, and maintain business intelligence
solutions, including data models, reports, and dashboards that give actionable insights.
 Average Salaries:

 United States: Approximately $96,492 per year.

 United Kingdom: £45,085 per year.
 Australia: AUD 112,542 per year.
 Canada: CAD 87,986 per year.
 India: ₹6,90,000 per year.

2. Business Intelligence (BI) Analyst

 Job Description: Analyse complex data sets to help businesses make decisions. Use Power BI to
generate interactive reports and dashboards that communicate insights to stakeholders.
 Average Salaries:

 United States: Approximately $70,000 per year.

 United Kingdom: £30,156 per year.
 Australia: AUD 65,188 per year.
 Canada: CAD 62,024 per year.
 India: ₹6,50,000 per year

3. Data Analyst

 Job Description: Collect, process, and analyse massive datasets. Use Power BI to visualize data
trends and make smart business decisions.
 Average Salaries:

 United States: Approximately $77,720 per year.

 United Kingdom: £29,619 per year.

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 27

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

 Australia: AUD 65,188 per year.

 Canada: CAD 54,384 per year.
 India: ₹5,00,000 per year.

4. Data Scientist

 Job Description: Use advanced analytics and machine learning to comprehend difficult data. Utilize
Power BI to visualize data and deliver insights.
 Average Salaries:

 United States: Approximately $96,492 per year.

 United Kingdom: £45,085 per year.
 Australia: AUD 112,542 per year.
 Canada: CAD 87,986 per year.
 India: ₹8,50,000 per year.

5. Power BI Consultant

 Job Description: Offer experienced guidance on deploying and optimizing Power BI solutions. Work
with clients to tailor Power BI apps to their specific business requirements.
 Average Salaries:

 United States: Approximately $96,492 per year.

 United Kingdom: £45,085 per year.
 Australia: AUD 112,542 per year.
 Canada: CAD 87,986 per year.
 India: ₹6,50,000 per year.

Top Companies Hiring Globally

 Tech Giants: Microsoft, Amazon, Google, IBM, Dell

 Consulting Firms: Deloitte, PwC, EY, KPMG, Accenture
 Finance/Insurance: JPMorgan, Citi, HSBC, Allianz, AXA
 E-commerce & Retail: Amazon, eBay, Walmart, IKEA, Zalando
 Startups & SaaS: Canva, Atlassian, Hubspot, Monday.com

Global Salary Estimates

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 28

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

Country Entry-Level Salary

USA $55,000 – $85,000
UK £28,000 – £45,000
Canada CAD 50,000 – 75,000
UAE AED 8,000 – 15,000/month
Australia AUD 60,000 – 90,000
Germany €45,000 – €65,000
Remote Freelance $20 – $100/hour

 Certifications to Make You Stand Out Worldwide

 Microsoft Certified Data Analyst Associate (Power BI)
 Microsoft Excel Expert Certification (MO-201)
 Google Data Analytics Certificate
 Tableau or SQL (as added skills)

 Where to Apply for Global Jobs

a. LinkedIn Jobs
b. Indeed Worldwide
c. Glassdoor
d. Toptal, Upwork, Fiverr (freelance)
e. AngelList (for startup jobs)
f. Job portals by country (e.g., Seek in Australia, Bayt for UAE)

CHAPTER 05

LEARNING EXPERIENCE

5.1 LEARNING EXPERIENCE

The Excel and Power BI learning experience is one that begins from the ground level and builds incrementally
to doing more advanced work. It takes trial and error, overcoming of obstacles, and confidence as you master
the use of the tools. With each step, there is a sense of achievement, whether it's cracking a formula or creating
an interactive report. The experience is rewarding and challenging, and the more you learn, the more
empowered and excited you are by the potential these tools provide.

SKILLS LEARNED

Data Analysis:

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 29

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

Advanced Excel Formulas: Master and use advanced formulas such as VLOOKUP, INDEX-MATCH, and array
formulas to handle complicated data manipulation.

Data Cleaning and Transformation: Recognize how to get the data ready for analysis, including the handling of
missing values, discrepancies, and format.

Power BI Fundamentals:

Data Modeling: Understand how to develop proper data models within Power BI, such as among tables and
dimensions.

Data Analysis Expressions (DAX): Master DAX for building calculated columns, measures, and filters in Power
BI.

Visualizations: Learn about different chart types and methods to effectively visualize data and communicate
insights.

Interactive Dashboards: Learn to create interactive dashboards that enable users to explore data and make
informed decisions.

Connecting and Importing Data:

Data Sources: Learn how to connect Power BI to different data sources such as Excel files, databases, and
cloud storage.

Importing Data: Learn to import data from Excel and other sources into Power BI.

Power BI Service:

Publishing and Sharing: Learn to publish reports and dashboards to the Power BI service and share them with
others.

Collaboration: Learn to collaborate with others on Power BI reports and dashboards.

5.2 Overcoming Challenges

Even with these obstacles, participants found ways to persevere using a few effective strategies:

➢ Engaging in hands-on exercises helped solidify new concepts, particularly those tricky advanced Excel
techniques.

➢ Group discussions fostered a collaborative environment where participants could share ideas and clarify any
uncertainties, creating a truly supportive learning space.

➢ Thanks to personalized guidance from trainers, participants were able to address their unique challenges
and fully understand the tools by the end of the training

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 30

 PASSENGER FLOW & OPERATIONAL EFFICIENCY ANALYSIS IN AVIATION USING POWER BI

RJS INSTITUTE OF MANAGEMENT STUDIES pg. 31