Masterji Degree and P.

G College
BUSINESS ANALYTICS

UNIT I: INTRODUCTION TO BUSINESS ANALYTICS

Business Analytics: Definition, evolution, and importance- The business analytics
lifecycle: data collection, preparation, analysis, visualization, and communication -
Applications of business analytics across business functions (e.g., marketing, finance,
operations, HR).
Big Data Concepts: volume, variety, velocity, veracity, and value - Differences between
data analytics and business intelligence - Career opportunities in business analytics and
key skills required.

UNIT – II: POWER BI

Power BI: Overview, Phases, Role– Power BI Desktop Vs. Power BI Service – Installing
Power BI and exploring the interface – Connecting to various data sources: Data Sources
– Connection modes: Import, Direct Query, Mixed mode, Connect Live – Importing Data
– Dealing with errors

UNIT – III: DATA PREPARATION WITH POWER QUERY

Splitting Columns - Renaming Columns – Adding Columns – Removing Columns –
Changing Data Types – Transformation Steps – Renaming an applied step – Viewing
transformation step changes – Adding a step between an applied step – Reordering
applied steps – Editing an existing step – Deleting an applied step

UNIT – IV: DATA MODELLING AND RELATIONSHIPS IN POWER BI

Relationships in Data Modelling – Identifying key columns in Power Query: Primary and
Foreign Key – Star and Hierarchal Schema Design - Creating relationships in Power BI –
Creating calculated tables, columns and measures with DAX (Data Analysis Expressions)
– Building calculated tables and advanced DAX calculations.

UNIT – V: DATA VISUALIZATION AND REPORTING

Building, basic and advanced visualizations (Bar, Line, Pie Charts, etc.) – Visualization
interactivity - Formatting and Customizing Visuals – Using filters, Slicers, and drill-
through features – Designing, interactive reports and dashboards – Publishing reports
to Power BI Service – Sharing Dashboards and Collaborating with Stakeholders – Setting
up row-level security and permissions – Scheduling data refresh and managing
workspaces

1
 Masterji Degree and P.G College
UNIT I: INTRODUCTION TO BUSINESS ANALYTICS
Business Analytics: Definition, evolution, and importance- The business analytics
lifecycle: data collection, preparation, analysis, visualization, and communication -
Applications of business analytics across business functions (e.g., marketing, finance,
operations, HR).
Big Data Concepts: volume, variety, velocity, veracity, and value - Differences between
data analytics and business intelligence - Career opportunities in business analytics and
key skills required.
===================================================================
INTRODUCTION:
Business Analytics (BA) refers to the systematic exploration of an
organization’s data using statistical, computational, and predictive techniques to inform
decision-making and improve performance.
At its core, business analytics involves analysing data to uncover patterns,
trends, and insights that drive informed decisions. Unlike traditional approaches to
decision-making, which often rely on experience or intuition, business analytics uses
facts and data as the foundation for strategy.
It combines statistical methods, data science, and technology to deliver
actionable insights that can transform an organisation’s performance. The importance
of business analytics lies in its ability to turn raw data into a powerful asset, helping
organisations gain a competitive edge in their industries.
“Business analytics focuses on developing new insights and understanding of
business performance based on data and statistical methods.”

FOUR TYPES OF ANALYTICS:

The four types of analytics based on value and complexity
1. Descriptive analytics Descriptive analytics answers the question “What happened?”.
This simple form of analytics uses basic math, such as averages and percent changes, to
show what has already happened in a business. Descriptive analytics, also called
traditional business intelligence (BI), is the first step in the analytics process, creating a
jumping-off point for further investigation.
2. Diagnostic analytics Diagnostic analytics answers the question “Why did something
happen?”. It takes descriptive analytics step further, using techniques such as data
2
discovery, drill-down, and correlations to dive deeper into data and identify the root causes of
events and behaviors.
3. Predictive analytics Predictive analytics answers the question “What is likely to
happen in the future?”. This branch of advanced analytics uses findings from descriptive
and diagnostic analytics – along with sophisticated predictive modeling, machine
learning, and deep learning techniques – to predict what will happen next.
4. Prescriptive analytics Prescriptive analytics answers the question “What action
should we take?”. This state-of-the-art type of analytics builds on findings from
descriptive, diagnostic, and predictive analytics and uses highly advanced tools and
techniques to assess the consequences of possible decisions and determine the best
course of action in a scenario.

COMPONENTS OF BUSINESS ANALYTICS

Business analytics is a broad field with many different components and tools.
Some of the most common ones include:
  Data aggregation: Before data can be analyzed, it must be collected from many
different sources, organized, and cleaned up. A solid data management strategy
and modern data warehouse are essential for analytics.
 Data mining: Data mining uses statistical analysis and machine learning
algorithms to sift through large databases, analyze data from multiple angles,
and identify previously unknown trends, patterns, and relationships.
 Big Data analytics: Big Data analytics uses advanced techniques – including data
mining, predictive analytics, and machine learning – to analyze massive sets of
structured and unstructured data in databases, data warehouses, and Hadoop
systems.
 Text mining: Text mining explores unstructured text data sets such as
documents, e-mails, social media posts, blog comments, call center scripts, and
other text-based sources for qualitative and quantitative analysis.
 Forecasting and predictive analytics: Forecasting uses historical data to make
estimates about future outcomes, and predictive analytics uses advanced
techniques to determine the likelihood these outcomes will occur.
 Simulation and what-if analysis: Once forecasts and predictions have been
created, simulation and what-if analysis can test out different scenarios and
optimize potential decisions before they’re made.
 Data visualization and storytelling: Data visualizations – like charts and
graphs – provide an easy way to understand and communicate trends, outliers,
and patterns in data. These visualizations can be strung together to tell a bigger
data story and guide decision-making.

EVOLUTION OF BUSINESS ANALYTICS

Business Analytics has evolved through distinct technological and methodological
phases. It is classified into the following:

BA in the 1800s The need to stay ahead

The first use of data to stay ahead of his competitor’s dates back to 1865. During
this time, Mr Richard Miller Devens described in his book how Sir Henry Furnese, a
banker, was always one step ahead by actively gathering information and acting on it
before any of his competitors. This makes it clear that professionals such as Sir Furnese
relied more on data and empirical evidence, rather than gut instinct.

BA in the late 1800s – The Advent of Scientific Management

During this time, Frederick Taylor introduced the first-ever system of business
analytics in the United States of America, which he called scientific management. The
purpose of this system was to analyze production techniques and labourers’ body
movements to identify greater efficiencies.

BA in the early 1900s – The Transformation of the Manufacturing Industry

Frederick Taylors’ scientific management system inspired Henry Ford, who hired
Taylor as his consultant. Ford was willing to measure the time each component of his
Ford Model T took to complete on his assembly line. This analysis transformed his work
and the manufacturing industry across the globe.

BA in the 1950s – The first hard drive disk by IBM

Computers were not accessible in the early 1900s but were massively demanded
during World War II. As they were still rudimentary, punch cards or tapes were used to
store information. However, in 1956, the tech giant IBM invented the first hard disk
drive. This allowed users to save a vast amount of data with better flexibility.

BA in the late 1900s – The Emergence of Business Intelligence

Owing to the lower prices for storage space and better databases, the next
generation of business intelligence solutions was all set to step in. By now, there was a
considerable amount of data available but not a centralized place to store it. To address
this problem, Ralph Kimball and Bill Inmon proposed similar strategies to build data
warehouses (DW).

BA in the New Millennium – Availability of different analytical solutions

By this time, medium and large-sized businesses had already realized the value
of business intelligence solutions. Companies such as IBM, Microsoft, SAP, and Oracle
were at the forefront of offering such solutions to change the way businesses function.
BA in 2005 – Accessibility of Data for the Common People
Considering the extensive usage of data, companies started directing their efforts
on improving the speed at which the information was available. New business analytics
tools were introduced to ensure technical as well as non-technical people were able to
mine the data and gain insights.
Around this time, the increasing interconnectivity of the business world led to
the need for real-time information. This was when Google Analytics was introduced.
Google wanted to provide a free and accessible way for users to analyze their website
data.

BA from 2005 to 2022 – The Bread and Butter for Companies Globally
With the internet and increasing data available to almost everyone, companies
needed better solutions to store and analyze all the information. Building computers
with more storage capacity and better speed wasn’t possible for many, so companies
resorted to using several machines simultaneously. This was the beginning of cloud
computing.
Since the last decade, big data, cloud computing, and business analytics have become
integral for almost all companies. The new advancements have made these technologies
even better. Now, data analytics and science are known to be the future. From
advertising and marketing to recruiting and planning operational activities, these terms
are tossed around in every field.

BA in 2023 – The New Emerging Technologies

In 2023, there was a notable shift in the realm of business analytics, spurred by
the escalating data volumes and the heightened demand for data-centric decision-
making. Companies adopted novel technologies to delve deeper into insights and tap
into untapped potentials. This era marked a transition from conventional techniques
towards a more focused and cooperative methodology, enabling businesses to harness
the full potential of data in unprecedented ways.

“The current evolution of business analytics can be traced back to automation and big
data, enabling scalable and powerful tools.”
IMPORTANCE OF BUSINESS ANALYTICS:
Data analytics in business is an indispensable tool for transforming this raw data
into meaningful insights. By leveraging advanced analytical techniques, businesses can
optimize operations, enhance profitability, and make well-informed decisions. Below,
we explore the importance of business analytics for modern enterprises.

Improve Operational Efficiency:

Business analytics plays a crucial role in streamlining operations, reducing costs,
and improving service delivery. By looking at the business and analytics data,
companies can identify bottlenecks, inefficiencies, and areas for improvement.
For example, a manufacturing company can use analytics to pinpoint delays in
the production line, enabling it to optimize workflows and reduce downtime. By
identifying the specific stages where delays occur, managers can implement targeted
interventions, such as adjusting machine maintenance schedules or reallocating labor
resources. Similarly, a retail business can analyze checkout processes to reduce
customer wait times, enhancing overall productivity and service delivery. Insights from
data can help in rearranging staff schedules or redesigning store layouts to ensure a
smoother customer experience.

Optimize Profit
Business analytics can help companies develop strategies that directly contribute
to profitability. By analyzing pricing strategies, reducing costs, and optimizing business
processes, analytics helps businesses make informed decisions that maximize profit
margins.
An e-commerce platform can use data analytics to adjust prices based on real-
time market demand, increasing sales while maintaining competitive pricing. This might
involve dynamic pricing algorithms that adjust prices in response to competitor activity
or customer purchasing patterns. Additionally, a logistics company might identify cost-
saving opportunities in their supply chain, such as optimizing delivery routes to save on
fuel costs. By using route optimization software, companies can minimize travel
distances and reduce fuel consumption, leading to significant cost savings.
Make Informed Decisions
Business analytics empowers leaders with data-driven insights, enabling them to
make better strategic decisions. By leveraging comprehensive data analysis, executives
can understand market trends, customer behavior, and operational performance.
A tech company, for example, might analyze user data to decide which new
features to develop for their software, ensuring alignment with customer needs and
preferences. This data-driven approach reduces the risk of errors and ensures that
business strategies are aligned with actual data and market conditions. Executives can
base their decisions on business analytics, meaning solid evidence rather than intuition,
leading to more reliable and successful outcomes.

Identify New Opportunities

Analytics can uncover new market opportunities and suggest areas for
expansion. By analyzing market trends and customer data, businesses can identify
untapped segments, emerging markets, and potential areas for growth.
For instance, a fashion retailer might discover a growing demand for sustainable
clothing through data analytics, prompting them to expand their product line to include
eco-friendly options. This proactive approach allows companies to stay ahead of the
competition and capitalize on new opportunities before others do. By continuously
monitoring market conditions and consumer preferences, businesses can adapt their
strategies to capture new growth areas effectively.

Spearhead Growth
Business analytics drives business growth by identifying trends and forecasting
future growth areas. With accurate predictions and insights, companies can develop
strategies to scale effectively.
Picture a startup in the tech industry using predictive analytics to forecast
demand for its product and to plan its production and marketing efforts accordingly.
This includes understanding which products or services are likely to succeed, where to
invest resources, and how to expand into new markets while managing risks effectively.
By leveraging predictive models, businesses can anticipate future market conditions
and position themselves strategically for sustained growth.
Evaluate and Measure Performance
Analytics tools are essential for measuring the performance of various business
initiatives and operations. By continuously monitoring key performance indicators
(KPIs), businesses can ensure that objectives are met and identify areas for
improvement.
For example, a digital marketing agency can track the performance of its
campaigns in real-time, making adjustments to maximize ROI. By analyzing metrics
such as click-through rates, conversion rates, and customer engagement, the agency can
refine its strategies to achieve better results. This facilitates continuous improvement
and helps maintain a competitive edge by ensuring that business activities are aligned
with strategic goals.

Leverage Patterns and Trends

Business analytics helps detect patterns and trends within big data, enabling
organizations to anticipate market changes and adapt quickly. By understanding
company analytics, businesses can make proactive adjustments to their strategies.
For instance, a financial services firm might use trend analysis to anticipate shifts
in the stock market, allowing them to adjust their investment strategies accordingly. By
identifying emerging trends, businesses can stay ahead of industry shifts and better
meet customer demands. This proactive approach helps companies to remain
competitive and responsive to changing market conditions.

Greater Insights into Customer Behavior and Habits

Analytics tools analyze customer data to improve marketing strategies, enhance
customer engagement, and tailor products and services to better meet customer needs.
By understanding customer behavior and habits, businesses can create more
personalized experiences.
For example, a streaming service might analyze viewing habits to recommend
content that aligns with individual preferences, increasing customer satisfaction and
retention. This ultimately drives loyalty and revenue growth by building strong
customer relationships. By continuously gathering and analyzing customer data,
businesses can refine their offerings and provide exceptional value to their customers.
Enhance Risk Management
Business analytics is also crucial in enhancing risk management. By analyzing
historical data and identifying patterns, businesses can predict potential risks and
develop strategies to mitigate them.
A financial institution can use analytics to detect fraudulent activities by
identifying unusual transaction patterns. Similarly, a supply chain company can
anticipate potential disruptions by analyzing geopolitical events, weather patterns, and
supplier performance. By proactively managing risks, businesses can avoid costly
disruptions, protect their assets, and ensure smoother operations.

GROWING IMPORTANCE OF BUSINESS ANALYTICS ACROSS INDUSTRIES

The rise of business analytics has been driven by the need to adapt to a fast-
paced and highly competitive environment. Organisations across industries are now
investing heavily in analytics to achieve better outcomes. Here’s how business analytics
is making a difference:
Retail and E-commerce
Retailers use analytics to study customer buying behaviours, personalise
shopping experiences, and forecast inventory needs. The importance of business
analytics in this sector is evident in how it optimises everything from product
placement to dynamic pricing strategies.
Healthcare
In healthcare, analytics improves patient outcomes by predicting disease trends,
optimising resource allocation, and enhancing treatment plans. The ability to process
large amounts of medical data is transforming how care is delivered.
Finance
Financial institutions use analytics for risk management, fraud detection, and
investment optimisation. By recognising patterns in transactional data, they can make
smarter, faster decisions.
Logistics and Supply Chain
The importance of business analytics in logistics lies in its ability to optimise
routes, reduce delivery times, and predict demand fluctuations, ensuring smooth
operations.
FUTURE OUTLOOK OF BUSINESS ANALYTICS
Looking ahead, the future of business analytics holds several exciting prospects
and developments. Here are some key future outlooks:
1. Real-Time Analytics: The focus will shift towards real-time analytics, which will
enable businesses to make instant decisions based on live data streams,
enhancing agility and competitiveness.
2. Explainable AI: There will be a greater emphasis on explainable AI, which will
ensure transparency and interpretability in AI-driven decision-making processes
and build trust and credibility.
3. Ethical Data Governance: With data privacy concerns rising, ethical data
governance frameworks will play a crucial role in ensuring responsible data
usage and compliance with regulations.
4. Augmented Analytics: Augmented analytics tools incorporating natural
language processing (NLP) and augmented data discovery capabilities will
empower non-technical users to derive insights effortlessly.
5. Blockchain Integration: Blockchain technology will be integrated into analytics
platforms to enhance data security, integrity, and trust in data transactions,
particularly in sectors like finance and supply chain management.

BUSINESS ANALYTICS LIFE CYCLE:

The Business Analytics Lifecycle is a systematic, iterative process involving data

collection, where raw information is gathered; data preparation, where it's cleaned and
transformed; data analysis, where patterns are identified and models are built; data
visualization, where insights are communicated through visuals; and communication, to
share actionable findings with stakeholders for informed decision-making. This
lifecycle, often based on frameworks like CRISP-DM, ensures that data-driven projects
are efficient, accurate, and aligned with business objectives.

Here are the phases of the Business Analytics Lifecycle:

1. Data Collection: The foundational stage where relevant data is gathered from
various sources. This sets the basis for the entire analytics process, ensuring
enough information is available to address the business problem.
 2. Data Preparation: Raw data is cleaned, transformed, and organized into a
structured format suitable for analysis. This critical step ensures data quality
and accuracy, which directly impacts the reliability of the insights.
3. Data Analysis: This phase involves applying statistical and modeling
techniques to the prepared data to find patterns, make predictions, and
generate insights. It moves from basic exploration to advanced modeling to
discover deeper trends.
4. Data Visualization: Information is presented visually using charts, graphs, and
dashboards to make complex findings more accessible and understandable to
decision-makers. This helps in quickly grasping key trends and patterns.
5. Communication: The final step where the results and insights derived from
the analysis are presented to stakeholders. This communication ensures that
the actionable insights guide strategic decision-making and lead to desired
business outcomes.

IMPORTANCE OF THE LIFECYCLE

 Ensures Relevance: The lifecycle ensures that the entire process is focused on
solving specific business problems and achieving defined goals.
 Promotes Accuracy: By including data cleaning and preparation, it ensures
the reliability of the insights gained from the data.
 Facilitates Decision-Making: The structured process, from analysis to
communication, translates complex data into actionable information that
supports strategic business decisions.
 Iterative & Flexible: The lifecycle is not linear; it's iterative, allowing for
refinement and feedback at each stage, leading to continuous improvement.

APPLICATIONS OF BUSINESS ANALYTICS ACROSS BUSINESS FUNCTIONS:

Business Analytics (BA) empowers organizations to make data-driven decisions
by extracting actionable insights from vast datasets. Its applications span every major
business function, transforming traditional practices into intelligent, adaptive systems.
1. Marketing
Business Analytics revolutionizes marketing by enabling precision targeting, campaign
optimization, and customer-centric strategies.
Key Applications:
 Customer Segmentation: Clustering customers by behavior, demographics, or
preferences for tailored campaigns.
 Predictive Modeling: Forecasting customer lifetime value, churn probability,
and purchase likelihood.
 Campaign Performance Analysis: Measuring ROI, click-through rates, and
conversion metrics in real time.
 Sentiment Analysis: Mining social media and reviews to gauge brand
perception.
 Dynamic Pricing: Adjusting prices based on demand, competitor actions, and
customer behavior.
Example: Netflix uses analytics to personalize content recommendations, increasing
user engagement.

2. Finance
In finance, analytics enhances forecasting, risk management, and strategic planning.
Key Applications:

 Risk Assessment: Evaluating credit, market, and operational risks using

statistical models.
 Fraud Detection: Identifying anomalies in transactions with machine learning
algorithms.
 Financial Forecasting: Using time-series analysis to predict revenue, expenses,
and cash flow.
 Scenario Analysis: Simulating economic conditions to test financial resilience.
 Portfolio Optimization: Balancing risk and return in investment strategies.
Example: Banks use predictive analytics to assess loan default risk and optimize lending
decisions.
 3. Operations
Analytics in operations drives efficiency, reduces waste, and enhances supply chain
responsiveness.
Key Applications:
 Demand Forecasting: Predicting product demand to optimize inventory and
production.
 Process Optimization: Identifying bottlenecks and improving throughput using
simulation models.
 Quality Control: Monitoring defect rates and process deviations in real time.
 Logistics & Routing: Optimizing delivery routes and schedules using geospatial
data.
 Capacity Planning: Aligning resource availability with projected workloads.
Example: Zara uses real-time analytics to accelerate design-to-shelf cycles, staying
ahead in fast fashion.

4. Human Resources (HR)

HR analytics transforms workforce management into a strategic, data-driven function.
Key Applications:
 Talent Acquisition: Predicting candidate success and reducing hiring bias.
 Employee Engagement: Monitoring satisfaction and designing personalized
retention strategies.
 Attrition Prediction: Forecasting turnover risks and implementing preventive
measures.
 Performance Management: Linking KPIs to business outcomes for fair
evaluations.
 Workforce Planning: Anticipating skill gaps and succession needs using
predictive models.
Example: Organizations use HR analytics to align talent strategies with institutional goals
and improve retention.
CONCEPT OF BIG DATA
Big Data refers to extremely large and complex datasets that traditional data
processing tools cannot efficiently handle. It encompasses structured, semi-structured,
and unstructured data generated at high speed from diverse sources such as sensors,
social media, transactions, and digital platforms.
Core Definition:
“Big Data is a collection of data that is huge in volume, yet growing exponentially with
time. It is so large and complex that traditional data management tools cannot store or
process it efficiently.”

Types of Big Data

 Structured: Organized in relational databases (e.g., employee records)
 Semi-structured: JSON, XML, logs with partial schema
 Unstructured: Text, images, videos, audio files

Big Data enables:

 Smarter decisions through trend analysis
 Personalized experiences via behavioral insights
 Operational efficiency by identifying bottlenecks
 Innovation through pattern discovery and forecasting
“Big Data transforms raw information into actionable insights that help companies gain a
competitive edge.”

The 5 V’s Framework

Big Data is defined not just by its size, but by its complexity and potential to
generate insights. The 5 V’s—Volume, Variety, Velocity, Veracity, and Value—serve
as a foundational framework to understand its characteristics and challenges.

1. Volume – Amount of Data

 Refers to the massive quantity of data generated every second—from sensors,
social media, transactions, and more.
 Organizations now deal with terabytes to zettabytes of data.
 Requires scalable storage solutions like Hadoop, NoSQL, and cloud platforms.
Example: Facebook users upload over 350 million photos daily.
2. Variety – Diversity of Data
 Encompasses structured, semi-structured, and unstructured data.
 Includes text, images, videos, audio, logs, sensor readings, and more.
 Challenges include data integration, interoperability, and semantic
consistency.
Example: E-commerce platforms collect product reviews (text), images, and clickstream data
simultaneously.
3. Velocity – Speed of Data Generation
 Refers to the rate at which data is generated, transmitted, and processed.
 Real-time data streams from IoT devices, financial transactions, and social media.
 Requires technologies like stream processing (Apache Kafka, Spark
Streaming).
Example: Stock exchanges process millions of trades per second, demanding instant
analytics.
4. Veracity – Accuracy / Trustworthiness of Data
 Addresses data quality, accuracy, and reliability.
 Big Data often contains noise, biases, and inconsistencies.
 Requires robust data governance, cleansing, and anomaly detection
protocols.
Example: Sensor data may include faulty readings due to hardware glitches or
environmental interference.
5. Value – Worth of Data / Business Impact and Insight
 The ultimate goal: extracting meaningful, actionable insights.
 Value is derived through analytics, visualization, and decision support
systems.
 Drives innovation, efficiency, and strategic advantage.
Example: Retailers use predictive analytics to optimize inventory and personalize
customer experiences.
 DIFFERENCES BETWEEN DATA ANALYTICS AND BUSINESS INTELLIGENCE –
Business Intelligence:
Traditionally, business intelligence has been defined as the use of data to manage
day-to-day operational management within a business. Leaders employ business
intelligence tools and experts when they want to collect and house data about current
operations, maximize workflow, produce informative reports, and achieve their current
business goals.
Business intelligence tools can include a variety of software tools and other
systems. Some of these include spreadsheets, online analytical processing, reporting
software, business activity monitoring software, and data mining software. Some
experts would also argue that business intelligence tools also include the more
predictive and statistical tools used in business analytics.
Overall, business intelligence helps leaders navigate organizational and industry-
related challenges and ensures that companies stay focused on their primary target to
successfully get where they want to go.

Business Analytics:
Business Analytics has generally been described as a more statistical-based field,
where data experts use quantitative tools to make predictions and develop future
strategies for growth. For example, while business intelligence might tell business
leaders what their current customers look like, business analytics might tell them what
their future customers are doing. Some experts use business analytics as a term to
describe a set of predictive tools used within the realm of business intelligence.

Business analytics tools are employed for many functions, including correlational
analysis, regression analysis, factor analysis, forecasting analysis, text mining, image
analytics, and others. Many of these tools require companies to hire or contract data
scientists and have increased the demand for training in business analytics.

When trying to understand the differences between business intelligence and

data analytics, it's also important to know their key similarities. Here are some areas
where BI and data analytics overlap:

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Data utilization: Both BI and data analytics utilize data to extract insights from
data.
 Decision-making support: Both disciplines provide valuable insights that guide
strategic and operational decisions within organizations.
 Drives data-driven culture: BI and data analytics emphasizes the importance of
leveraging data to drive business success.

Despite their similarities, BI and data analytics have some key distinctions. Here's a
table that summarizes these differences:
Point of Difference Business Intelligence Data Analytics
Focus Making better decisions Extracting insights from data
Audience Business leaders, executives, Data scientists and analysts
and decision-makers
Objectives Performance tracking and Forecast future outcomes and
making data-driven optimize decision-making
decisions
Techniques Reporting, dashboards, and Statistical modeling and
data visualization predictive analysis
Data type Structured and semi- Structured, semi-structured,
structured data and unstructured data
Time horizon Past and present Past, present, and future
Methodologies Descriptive analytics Descriptive, diagnostic,
predictive, and prescriptive
analytics
Decision-making Tactical and operational Strategic and operational
level decisions decisions
Answers the "What" and "why" "How"
questions
Outcomes Insights that can be used to Insights from data to improve
make better decisions BI

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 CAREER OPPORTUNITIES IN BUSINESS ANALYTICS:
Business analytics offers dynamic career opportunities across industries by
transforming data into strategic insights. Professionals in this field play pivotal roles in
decision-making, performance optimization, and digital transformation. With growing
reliance on data-driven strategies, roles such as business analyst, data scientist, and BI
consultant are in high demand. This domain blends analytical rigor with business
acumen, making it ideal for those seeking impactful, interdisciplinary careers.

Business Analyst
A Business Analyst serves as the bridge between data insights and strategic
decision-making. They work closely with stakeholders to understand business needs,
analyze processes, and recommend data-driven solutions. This role is critical in
translating analytical findings into actionable business strategies, especially in sectors
like retail, healthcare, and education. Business Analysts often lead requirement
gathering, process mapping, and performance tracking initiatives.

Data Analyst
Data Analysts focus on collecting, cleaning, and interpreting data to uncover
trends and patterns. They use tools like Excel, SQL, Python, and Power BI to generate
reports and visualizations that support operational and strategic decisions. In academic
institutions, Data Analysts can support accreditation efforts, student performance
tracking, and institutional benchmarking. Their work is foundational to any analytics-
driven organization.

Business Intelligence (BI) Analyst

BI Analysts specialize in creating dashboards, scorecards, and data visualizations
that help organizations monitor key performance indicators (KPIs). They work with
tools like Tableau, Power BI, and Qlik to provide real-time insights. In higher education,
BI Analysts play a pivotal role in tracking faculty workload, research output, and quality
assurance metrics aligned with frameworks like NAAC and NIRF.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 Data Scientist
Data Scientists apply advanced statistical models, machine learning algorithms,
and predictive analytics to solve complex business problems. They work with large
datasets and use programming languages like Python and R to build models that
forecast trends, classify behaviors, and optimize outcomes. This role is especially
valuable in domains requiring high-level forecasting, such as finance, healthcare, and HR
analytics.

Analytics Consultant
Analytics Consultants advise organizations on how to implement and scale
analytics solutions. They assess current capabilities, design analytics roadmaps, and
guide digital transformation initiatives. In academic settings, consultants may help
institutions i n t e g r a t e a n a l y t i c s i n t o curriculum design, faculty development,
and
strategic planning. Their cross-functional expertise makes them valuable in both
corporate and educational environments.

Marketing Analyst
Marketing Analysts use data to understand customer behavior, segment
audiences, and optimize campaigns. They analyze metrics like conversion rates,
customer lifetime value, and engagement trends. With the rise of digital platforms, this

role has become central to brand strategy and customer experience. Marketing Analysts
often collaborate with product teams to align messaging with market insights.

Financial Analyst
Financial Analysts apply analytics to budgeting, forecasting, and investment
planning. They use historical data and predictive models to assess financial health and
guide resource allocation. In institutions, they support grant management, cost
optimization, and financial reporting aligned with regulatory standards. Their insights
are crucial for long-term sustainability and strategic growth.

HR Analyst

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 HR Analysts leverage data to improve workforce planning, employee
engagement, and talent management. They analyze attrition trends, performance

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 metrics, and training outcomes to inform HR strategies. In your domain of emotional
intelligence and job satisfaction, HR analytics can reveal deep insights into
organizational culture and employee well-being—making it a powerful tool for
institutional development.

Chief Data Officer (CDO)

The CDO is a senior executive responsible for data governance, analytics
strategy, and digital transformation. They oversee data infrastructure, compliance, and
innovation across the enterprise. In universities and large institutions, CDOs ensure that
data is used ethically and effectively to drive research, accreditation, and policy-making.
This role combines leadership with deep technical and strategic expertise.

KEY SKILLS REQUIRED FOR BUSINESS ANALYTICS

Success in business analytics demands a blend of technical proficiency, analytical
thinking, and business acumen.

Technical Skills
 Data Analysis & Visualization: Excel, Power BI, Tableau, Python (Pandas,
Matplotlib)
 Statistical Modeling: Regression, hypothesis testing, probability theory
 Database Management: SQL, NoSQL, ETL pipelines
 Programming: Python, R, and basic scripting
 Machine Learning: Classification, clustering, forecasting models
 Big Data Tools: Hadoop, Spark, cloud platforms (AWS, Azure)

Soft Skills
 Critical Thinking: Ability to interpret data and challenge assumptions
 Communication: Presenting insights clearly to non-technical stakeholders
 Problem-Solving: Translating data into actionable solutions
 Business Understanding: Domain knowledge in marketing, finance, HR, etc.
 Collaboration: Working with cross-functional teams and clients

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 UNIT – II: POWER BI
Power BI: Overview, Phases, Role– Power BI Desktop Vs. Power BI Service – Installing
Power BI and exploring the interface – Connecting to various data sources: Data Sources
– Connection modes: Import, Direct Query, Mixed mode, Connect Live – Importing Data
– Dealing with errors
===================================================================
Overview:
Microsoft Power BI is a collection of apps, software services and connectors that
come together to turn unrelated data into visually impressive and interactive insights.
Power BI can work with simple data sources like Microsoft Excel and complicated ones
like cloud-based or on-premises hybrid Data warehouses. Power BI has the capabilities to
easily connect to your data sources, visualise and share and publish your findings with
anyone and everyone.

Power BI is simple and fast enough to connect to an Excel workbook or a local

database. It can also be robust and enterprise-grade, ready for extensive modeling and
real time analytics. This means it can be used in a variety of environments from a personal
report and visualisation tool to the analytics and decision engine behind group projects,
divisions, or entire corporations.

As Power BI is a Microsoft product and has built in connections to Excel, there are
many functions that will be familiar to an Excel user.

Key Components
 Power BI Desktop – Windows application for data modeling and report creation
 Power BI Service – Cloud-based platform for sharing, collaboration, and
dashboard creation
 Power BI Mobile – Mobile app for viewing reports and dashboards
 Power BI Gateway – Bridges on-premises data with cloud services
 Power BI Embedded – Embeds analytics into custom applications

Phases of Power BI Workflow:

The Power BI lifecycle typically follows these five phases:

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 Phase Description
1. Data Acquisition Connect to various data sources (Excel, SQL, cloud services)
2. Data Transformation Cleanse and shape data using Power Query Editor
3. Data Modelling Define relationships, hierarchies, and calculated
columns/measures using DAX
4. Report Creation Build interactive visuals, charts, and dashboards
5. Publishing and Publish reports to Power BI Service for collaboration and
Sharing access control

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 Role of Power BI in Organizations
Power BI plays a pivotal role across multiple organizational functions:
 Decision Support: Empowers executives with real-time dashboards and KPIs
 Operational Monitoring: Tracks performance metrics across departments
 Strategic Planning: Enables forecasting and trend analysis
 Collaboration: Facilitates team-based report editing and sharing
 Data Governance: Supports role-based access and compliance via Microsoft
Purview integration

Power BI Desktop vs Power BI Service

Feature Power BI Desktop Power BI Service
Platform Windows application Cloud-based (browser access)
Primary Use Data modeling and report Report sharing, dashboard creation,
creation collaboration
Data Sources Wide range, including local files Limited to cloud and published
and databases datasets
Data Full access to Power Query Not available
Transformation Editor
DAX & Measures Full support for calculated Limited editing capabilities
columns and measures
Offline Access Yes No (requires internet)
Collaboration Individual use; .pbix file sharing Multi-user editing, workspaces, apps
Licensing Free to use Requires Pro or Premium license for
full features
Report Storage Local system (.pbix files) Cloud storage with version control
Dashboard Not supported Supported (single-page dashboards
Creation from multiple reports)

For report creation, Power BI Desktop is recommended due to its robust

modeling and transformation tools. Power BI Service excels in sharing, collaboration,
and dashboarding.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 Connection Modes
Power BI supports multiple data connectivity modes, each with distinct
performance, flexibility, and refresh characteristics:
1. Import Mode
 Data is loaded into Power BI’s in-memory engine (VertiPaq).
 Offers fast performance due to compressed, cached data.
 Supports full Power Query transformations and DAX modeling.
 Ideal for static or periodically refreshed datasets.
 Requires scheduled refresh in Power BI Service.
2. DirectQuery Mode
 Queries are sent live to the data source on user interaction.
 No data is stored in Power BI; relies on source performance.
 Suitable for large datasets or real-time analytics.
 Limited support for complex transformations and DAX features.
 Requires data gateway for on-premises sources.
3. Live Connection
 Used exclusively with SQL Server Analysis Services (SSAS) or Power BI datasets.
 Similar to DirectQuery but more restrictive:
 No data modeling or transformation in Power BI Desktop.
 All logic resides in the source model.
 Ideal for centralized semantic models managed by BI teams.
4. Mixed Mode (Composite Model)
 Combines Import and DirectQuery in a single model.
 Enables hybrid scenarios:
 Frequently used data can be imported.
 Real-time data can be queried live.
 Requires careful relationship management and performance tuning.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
Importing Data in Power BI Steps:
1. Launch Power BI Desktop
2. Click “Get Data” → Choose source (Excel, SQL, Web, etc.)
3. Use Power Query Editor to:
o Cleanse and shape data
o Apply filters, transformations, and column operations
4. Load data into the model
5. Model relationships and create measures using DAX
Power BI supports over 200 connectors, including cloud services (Azure,
Salesforce), databases (SQL, Oracle), and files (CSV, Excel, JSON).

Dealing with Errors during Import

Common Errors & Solutions
Error Type Cause Resolution
Credential Errors Invalid or missing Re-enter credentials or
authentication configure gateway
Data Type Mismatch Inconsistent column Use Power Query to enforce
formats consistent types
Missing Columns Schema changes in source Refresh schema or update
queries
Timeouts Large datasets or slow Filter data, optimize queries,
source or increase timeout settings
Gateway Errors Gateway offline or Restart gateway service or
misconfigured check network settings
Refresh Failures Scheduled refresh issues Check refresh logs, validate
source availability

Best Practices:
 Use Query Diagnostics to trace performance bottlenecks.
 Apply error-handling functions in Power Query (e.g., try...otherwise).
 Validate data types and relationships before loading.
 Monitor refresh history in Power BI Service for recurring issues.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 UNIT – III: DATA PREPARATION WITH POWER QUERY
Splitting Columns - Renaming Columns – Adding Columns – Removing Columns – Changing
Data Types – Transformation Steps – Renaming an applied step – Viewing transformation
step changes – Adding a step between an applied step – Reordering applied steps – Editing
an existing step – Deleting an applied step

Introduction:
Power Query is a powerful ETL (Extract, Transform, Load) tool embedded in
Power BI Desktop. It allows users to connect to various data sources, clean and
transform raw data, and prepare it for analysis—all without altering the original source.
Think of Power Query as your data refinery: it turns messy, inconsistent, or
incomplete data into structured, analysis-ready datasets.

Key Steps in Data Preparation with Power Query

1. Connecting to Data Sources
 Supports Excel, CSV, SQL Server, Web APIs, SharePoint, Azure, and more.
 Use “Get Data” to initiate connections.
 Choose between Import, DirectQuery, or Live Connection depending on
performance and refresh needs.

2. Previewing and Profiling Data

 Use Column Quality, Column Distribution, and Column Profile tools.
 Identify nulls, errors, duplicates, and outliers.
 Assess data types and value ranges before transformation.

3. Cleaning and Transforming Data

Common transformations include:
 Remove duplicates or errors
 Filter rows based on conditions
 Split or merge columns (e.g., full name → first & last)
 Change data types (text, number, date)
 Trim or format text (remove whitespace, capitalize)

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Pivot/Unpivot columns for reshaping data

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Replace values (e.g., “N/A” → null)
Power Query supports over 300 transformation functions, many of which can be combined
using the M language for advanced logic.

4. Creating Custom Columns

 Use “Add Column” tab to create calculated columns.
 Apply conditional logic (e.g., IF statements).
 Derive new metrics or flags for segmentation.

5. Combining Data
 Append Queries: Stack datasets vertically (e.g., monthly sales files).
 Merge Queries: Join datasets horizontally (e.g., customer info + transactions).
 Choose join types: Inner, Left Outer, Right Outer, Full Outer.

6. Loading Data
 Load to Power BI model for visualization.
 Option to load only selected columns or disable loading for intermediate steps.

Column Operations in Power Query

1. Splitting Columns

Used to divide a single column into multiple columns based on a delimiter or character count.
Steps:
 Go to Transform Data → Power Query Editor.
 Select the column to split.
 Click Split Column on the ribbon.
 Choose:
o By Delimiter (e.g., comma, space)
o By Number of Characters
 Configure delimiter and split options.

Result: New columns created with split values.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 Use Cases:Splitting full names into first and last names, dates into day/month/year.

2. Renaming Columns
Improves clarity and consistency in data models.
Steps:
 Right-click the column header → Select Rename.
 Or, select the column → Click Transform tab → Rename.
 Type the new name and press Enter.
Best Practice:Use meaningful names aligned with business terminology or analysis
goals.

3. Adding Columns
Create new columns based on transformations or calculations.
Steps:
o Go to Add Column tab.
o Choose:
 Custom Column: Use M code for logic (e.g., if [Sales] > 1000 then "High"
else "Low").
 Conditional Column: GUI-based logic builder.
 Index Column: Adds sequential numbering.
 Duplicate Column: Creates a copy for isolated transformations.

4. Removing Columns
Eliminates unnecessary or sensitive data.
 How to Use:
o Select column(s) → Right-click → Remove, or use Remove Columns from
the ribbon.
 Tip:Use Choose Columns to explicitly retain only needed fields.

5. Changing Data Types

Ensures correct interpretation of values (e.g., text, number, date).
 How to Use:

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 o Select column → Transform tab → Data Type dropdown.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Common Types:Text, Whole Number, Decimal Number, Date/Time, Boolean.

Managing Transformation Steps (Applied Steps)

Power Query records each transformation as a step in the Applied Steps pane.
These steps are sequential and editable.

6. Renaming an Applied Step

Improves readability and documentation.
 How to Use:
o Right-click the step in Applied Steps → Rename.
 Example:Rename “Renamed Columns” to “Standardized Column Names”.

7. Viewing Transformation Step Changes

Helps track and audit data cleaning actions / Allows inspection of data at each stage.
Steps:
o Each transformation creates a step in the Applied Steps pane.
o Click on any step to preview data at that stage.
o Use this to verify intermediate results.
How to Use:Click on any step in Applied Steps to preview the dataset at that point.

8. Adding a Step between Applied Steps

Insert logic without disrupting the flow.
How to Use:Use Advanced Editor to manually insert M code between steps.
Steps:
o Click the step before where you want to insert.
o Perform the transformation (e.g., filter, add column).
o Power Query will insert the new step automatically.
o If needed, manually adjust M code in the formula bar.
Caution:Ensure dependencies are respected to avoid breaking downstream steps.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 9. Reordering Applied Steps
Rarely recommended due to dependency risks.
How to Use:Only possible via Advanced Editor by rearranging M code.
Steps:
o Not directly drag-and-drop.
o Instead:
o Copy M code from the step.
o Delete the step.
o Paste the code in a new Advanced Editor position.
o Or manually reorder logic in Advanced Editor.
Tip:Validate each step after reordering to ensure integrity.

10. Editing an Existing Step

Modify logic or parameters of a transformation.
How to Use:Click the gear icon next to the step (if available), or use Advanced Editor.
Steps:
o Click the step in Applied Steps.
o Modify the formula in the formula bar.
o Press Enter to apply changes.
Example:Change delimiter in a split column step.

11. Deleting an Applied Step

Removes unwanted or erroneous transformations.
How to Use:Click the “X” next to the step name in Applied Steps.
Steps:
- Right-click the step in Applied Steps.
- Select Delete.
- Confirm deletion
Tip:Deleting a step may affect subsequent steps—review dependencies.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 UNIT – IV: DATA MODELLING AND RELATIONSHIPS IN POWER BI
Relationships in Data Modelling – Identifying key columns in Power Query: Primary and
Foreign Key – Star and Hierarchal Schema Design - Creating relationships in Power BI –
Creating calculated tables, columns and measures with DAX (Data Analysis Expressions)
– Building calculated tables and advanced DAX calculations.

INTRODUCTION:
Power BI’s data modelling capabilities allow users to transform raw data into
meaningful insights by establishing logical relationships between tables. This unit
focuses on understanding how to identify key columns, define relationships, and design
schema models that enhance analytical performance.
Relationships in Data Modelling
In Power BI, relationships connect tables so that data can be analyzed across multiple
sources. These relationships are defined using keys and are visualized in the Model
View.

TYPES OF RELATIONSHIPS:
 One-to-Many (1:*): Most common; one record in a dimension table maps to
many in a fact table.
 Many-to-One (*:1): Reverse of the above; often used in reverse lookups.

 Many-to-Many (:): Used cautiously; requires composite models or bridge tables.

Relationships ensure that filters, calculations, and visuals behave logically across
datasets.

IDENTIFYING KEY COLUMNS IN POWER QUERY

Before defining relationships, it's essential to identify Primary Keys and Foreign Keys:
 Primary Key: A unique identifier for each row in a table (e.g., CustomerID in a
Customers table).
 Foreign Key: A column that refers to the primary key in another table (e.g.,
CustomerID in an Orders table).
In Power Query, these keys are used to merge tables, simulate joins, and prepare data
for modelling.
Asst. Prof. Zeenath Jahan
Masterji Degree & P.G College
 STAR SCHEMA DESIGN
The Star Schema is the recommended modelling approach in Power BI due to its
simplicity and performance benefits.
⭐ Structure:

 Fact Table: Central table containing measurable data (e.g., sales, transactions).
 Dimension Tables: Surrounding tables with descriptive attributes (e.g., product,
customer, date).
This design minimizes joins, improves query speed, and simplifies DAX calculations.
“Star schema is a mature modeling approach widely adopted by relational data
warehouses. It requires modelers to classify their model tables as either dimension or
fact.” — Microsoft Learn

HIERARCHICAL SCHEMA DESIGN

A Hierarchical Schema organizes data in a tree-like structure, often used to represent
nested relationships such as:
 Geography: Country → State → City
 Organization: Division → Department → Team
 Time: Year → Quarter → Month → Day
In Power BI, hierarchies are created using calculated columns or custom hierarchies
in the Model View. They enhance drill-down capabilities in visuals and support multi-
level analysis.

CREATING RELATIONSHIPS IN POWER BI

Relationships in Power BI define how tables connect and interact, enabling seamless
cross-table analysis. These relationships are established using primary and foreign
keys, and are visualized in the Model View.

Steps to Create Relationships:

 Autodetect: Power BI automatically identifies relationships based on matching
column names.
 Manual Creation: Drag a column (e.g., CustomerID) from one table to its
counterpart in another.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Edit Relationship Properties:

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Cardinality: One-to-One, One-to-Many, Many-to-One, Many-to-Many
 Cross-filter direction: Single or Both
 Active/Inactive status: Determines if the relationship is used in calculations
For optimal performance, aim for a Star Schema design where fact tables are
surrounded by dimension tables.

CREATING CALCULATED TABLES, COLUMNS, AND MEASURES WITH DAX

DAX (Data Analysis Expressions) is the formula language used in Power BI to create
custom calculations.
Calculated Columns
 Created within existing tables using row-level logic.
 Example:
FullName = Customers[FirstName] & " " & Customers[LastName]
 Used for categorization, flags, or derived fields.
Measures
 Aggregations calculated dynamically based on filter context.
 Example:
TotalSales = SUM(Sales[Amount])
 Ideal for KPIs, dashboards, and visual summaries.

Building Calculated Tables in Power BI

Calculated tables are user-defined tables created using DAX (Data Analysis
Expressions) rather than imported from external sources. They allow you to reshape,
filter, or combine existing data within the Power BI model.
How to Create a Calculated Table:
1. Go to Model View or Table Tools in Power BI Desktop.
2. Click New Table.
3. Enter a DAX expression that returns a table.
Examples:
 Union of Tables:
CombinedSales = UNION(Sales2020, Sales2021)
 Filtered Table:

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
 HighValueCustomers = FILTER(Customers, Customers[TotalSpend] > 100000)

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
  Summarized Table:
SalesSummary = SUMMARIZE(Sales, Sales[Region], "TotalSales", SUM(Sales[Amount]))
Calculated tables are ideal for intermediate aggregations, segmentation, and scenario
modeling.

Advanced DAX Calculations:

DAX enables powerful, context-aware calculations that go beyond simple aggregations.
These are essential for dynamic dashboards, KPI tracking, and predictive modeling.

Key Concepts:
 Row Context: Used in calculated columns; evaluates each row individually.
 Filter Context: Used in measures; evaluates based on filters applied in visuals or
slicers.
 Context Transition: Occurs when CALCULATE() modifies row context into filter
context.

Advanced DAX enables powerful analytics through:

 Time Intelligence:
SalesLastYear = CALCULATE(SUM(Sales[Amount]),
SAMEPERIODLASTYEAR(Date[Date]))
 Context Transition: Using CALCULATE() to shift filter context.
 Dynamic Ranking:
RankCustomers = RANKX(ALL(Customers), [TotalSales], , DESC)
 Cohort Analysis, Rolling Averages, and Custom Filters using FILTER(), ALL(),
REMOVEFILTERS(), etc.

DAX is optimized for columnar data models and supports both row and filter context,
making it ideal for scalable analytics.

Asst. Prof. Zeenath Jahan

Masterji Degree & P.G College
UNIT – V: DATA VISUALIZATION AND REPORTING
Building, basic and advanced visualizations (Bar, Line, Pie Charts, etc.) – Visualization
interactivity - Formatting and Customizing Visuals – Using filters, Slicers, and drill-
through features – Designing, interactive reports and dashboards – Publishing reports
to Power BI Service – Sharing Dashboards and Collaborating with Stakeholders – Setting
up row-level security and permissions – Scheduling data refresh and managing
workspaces
===================================================================
Introduction:
Power BI transforms raw data into interactive, insightful visuals that support decision-
making across business functions. Its visualization capabilities range from simple charts
to advanced analytical graphics, all integrated into dynamic dashboards.
Building Visualizations in Power BI
Creating visuals in Power BI involves selecting the appropriate chart type from the
Visualizations pane, dragging relevant fields from the Fields pane, and customizing
formatting through the Format pane.
Steps to Build a Visualization:
1. Select a visual type (e.g., Bar Chart, Line Chart).
2. Drag and drop fields into Axis, Values, Legend, etc.
3. Customize using filters, slicers, and formatting options.
4. Combine visuals into dashboards for storytelling and reporting.
Basic Visualizations
These are foundational chart types used for descriptive analytics and simple
comparisons.
These visuals are ideal for introductory analytics and executive summaries.

Advanced Visualizations
Advanced visuals support deeper analysis, interactivity, and multi-dimensional insights.

Power BI also supports custom visuals from the marketplace for niche use cases.

Reporting Features
Power BI reports are interactive, customizable, and shareable across platforms.
 Slicers: Filter visuals dynamically by category, date, or metric.
 Drill-through: Navigate from summary to detailed views.
 Bookmarks: Save report states for storytelling.
 Tooltips: Display contextual data on hover.
 Export Options: Share reports via PDF, PowerPoint, or cloud services.

VISUALIZATION INTERACTIVITY IN POWER BI:

Power BI offers rich interactivity that allows users to explore data dynamically
and intuitively. Interactivity enhances user engagement and supports deeper insights by
enabling real-time filtering, cross-highlighting, and drill-down capabilities.
Key Interactive Features:
 Cross-filtering: Selecting a data point in one visual filters related visuals
automatically.
 Cross-highlighting: Highlights relevant data across visuals without removing
context.
 Drill-down: Allows users to explore hierarchical data (e.g., Year → Quarter →
Month).
 Drill-through: Navigates to a detailed report page based on a selected data
point.
Example: Clicking on a region in a map visual filters the bar chart to show sales only for
that region.

FORMATTING AND CUSTOMIZING VISUALS –

Power BI provides extensive formatting options to enhance readability, aesthetics, and
clarity of data visuals.

Customization Options:
 Title, Labels, and Legends: Modify font, size, color, and alignment.
 Data Colors: Apply conditional formatting based on values or categories.
 Gridlines and Borders: Adjust visibility and styling for better layout control.
 Tooltips: Add contextual information that appears on hover.
 Themes: Apply consistent color palettes across the report.
These formatting tools help tailor visuals to institutional branding or pedagogical
clarity.

USING FILTERS, SLICERS, AND DRILL-THROUGH FEATURES:

Filters
Power BI supports three levels of filters:
 Visual-Level Filters: Apply only to a specific chart or visual.
 Page-Level Filters: Affect all visuals on a report page.
 Report-Level Filters: Apply across all pages in the report.
 Slicers
Slicers are interactive controls that allow users to filter data by selecting values from a list,
range, or hierarchy.
 Types: List, dropdown, date, numeric range, hierarchy
 Use Case: Filter by department, time period, or product category
 Customization: Format slicers with custom fonts, colors, and orientation
Slicers act as dynamic filters that empower users to segment and isolate data across
dimensions.

Drill-Through
Drill-through enables users to navigate from a summary visual to a detailed report page
focused on a selected data point.
 Setup: Create a target page with a drill-through field (e.g., CustomerID)
 Use Case: Click on a customer name to view their full transaction history
 Benefits: Supports layered analysis and storytelling

DESIGNING, INTERACTIVE REPORTS AND DASHBOARDS –

Interactive reports and dashboards in Power BI empower users to explore data
dynamically, uncover insights, and make informed decisions. They combine visual
storytelling with analytical depth, tailored to specific audiences and business contexts.

Key Elements of Interactive Report Design

1. Clear Objective
Define the purpose of the report—whether it's tracking KPIs, analyzing trends, or
supporting strategic decisions.
2. Audience-Centric Layout
Design with the end-user in mind. Use intuitive navigation, logical grouping, and
relevant metrics.
3. Consistent Visual Hierarchy
Apply consistent fonts, colors, and spacing. Highlight key metrics using cards, gauges,
or conditional formatting.
4. Responsive Design
Ensure visuals adapt across devices—desktop, tablet, and mobile.
Building Interactive Dashboards
Dashboards in Power BI are collections of visuals pinned from reports, offering a high-
level overview with drill-down capabilities.

Features That Enhance Interactivity:

 Slicers: Filter data by categories, dates, or hierarchies.
 Drill-through Pages: Navigate from summary to detailed views.
 Bookmarks: Save report states for storytelling or guided analysis.
 Tooltips: Display contextual data on hover.
 Q&A Visuals: Allow users to ask natural language questions and get instant
visuals.

Best Practices for Dashboard Design:

PUBLISHING REPORTS TO POWER BI SERVICE:

The Power BI Service is Microsoft’s cloud-based platform where users can publish,
share, and collaborate on reports and dashboards. It enables real-time access, scheduled
data refreshes, and secure sharing across teams and institutions.
Steps to Publish a Report from Power BI Desktop
1. Open Your Report
Launch Power BI Desktop and open the .pbix file you want to publish.
2. Click “Publish”
On the Home ribbon, click the Publish button. Alternatively, go to File > Publish
> Publish to Power BI.
3. Sign In
Log in using your organizational Power BI account. Note: Public domains like
Gmail or Yahoo are not supported.
4. Select Workspace
Choose a destination workspace (e.g., My Workspace or a shared team
workspace). You can create multiple workspaces for different departments or
projects.
5. Upload and Confirm
Power BI uploads the report to the selected workspace. Once complete, you’ll
receive a link to open the report in the Power BI Service.

Benefits of Publishing to Power BI Service

 Collaboration: Share reports with stakeholders via Teams, Outlook, or
embedded links.
 Scheduled Refresh: Automate data updates from cloud or on-premise sources.
 Access Control: Manage permissions with row-level security and workspace
roles.
 Mobile Access: View reports on tablets and smartphones via the Power BI app.
 Integration: Embed reports in SharePoint, Teams, or web portals.
“Publishing from Power BI Desktop has the same effect as using ‘Get Data’ in Power BI
Service to upload a file. Changes made in the service won’t reflect back in the Desktop
file.” — Microsoft Learn

SHARING DASHBOARDS AND COLLABORATING WITH STAKEHOLDERS:

Power BI enables seamless sharing and collaboration, allowing stakeholders
across departments and institutions to access, interact with, and act on data insights.
Whether you're presenting accreditation metrics, faculty performance dashboards, or
strategic KPIs, effective sharing ensures transparency, alignment, and informed
decision-making.

Methods of Sharing Dashboards

1. Direct Sharing via Power BI Service
 Use the Share button in Power BI Service to send dashboards or reports to
individuals or groups.
 Choose from options like:
o People in your organization
o Specific people (including Microsoft Entra B2B guests)
o People with existing access
 Set permissions:
 View only
 Allow reshare
 Allow build (to create new reports from shared datasets)
Shared dashboards appear in the recipient’s “Shared with me” section.
2. Workspaces for Team Collaboration
 Create workspaces to co-author and manage content with roles like Admin,
Member, Contributor, and Viewer.
 Ideal for departmental collaboration on dashboards related to NAAC, NIRF, or
curriculum benchmarking.
3. Publishing as Power BI Apps
 Package dashboards and reports into an app for consistent, read-only
distribution.
 Share with large groups or entire institutions.
 Useful for leadership dashboards or accreditation readiness reports.
4. Microsoft Teams Integration
 Embed dashboards directly into Teams channels or chats.
 Collaborate in real time, discuss insights, and tag colleagues using @mentions.
Power BI automatically bookmarks the report view when comments are added,
preserving filters and slicers.
Best practices for Stakeholder collaboration:

For optimal collaboration, define stakeholder roles early and align dashboard design
with their decision-making needs.

SETTING UP ROW-LEVEL SECURITY AND PERMISSIONS:

Row-Level Security (RLS) in Power BI restricts data access at the row level,
ensuring that users only see the data relevant to their role, department, or identity. This

is essential for maintaining confidentiality, especially in multi-user environments like universities,

hospitals, or corporate teams.
For example, a department head may only view performance data for their
faculty, while institutional leadership sees aggregated metrics across all departments.
Steps to Set Up RLS in Power BI Desktop
1. Load Your Data
Import your dataset into Power BI Desktop and ensure it includes a column that can be used
to filter data by user (e.g., Department, Region, or UserEmail).
2. Define Roles
 Go to the Modeling tab.
 Click Manage Roles.

Dr. K. Phanindra Kumar

Workshop on “Data Driven Teaching – Business Analytics & Power BI for Educators”

 Create a new role and name it (e.g., HR_Viewer or Faculty_Head).

3. Apply Filters
 Select the table and column to filter.
 Use either the default interface or switch to DAX editor for advanced logic.
 Example DAX filter:
[Department] = "Business Analytics"
4. Dynamic RLS (Optional)
For user-specific filtering:
[UserEmail] = USERPRINCIPALNAME()
This ensures each user sees only their own data based on login credentials.
5. Validate Roles
 Use View As Roles to test how the report looks for different roles.
 Confirm that filters are working as expected.
Publishing and Permissions in Power BI Service
Once published to the Power BI Service:
 RLS roles are retained from Power BI Desktop.
 Assign users to roles via Security settings in the dataset.
 Note: RLS applies only to users with Viewer permissions. Admins, Members, and
Contributors bypass RLS filters

SCHEDULING DATA REFRESH AND MANAGING WORKSPACES

Scheduled data refresh ensures that your reports and dashboards reflect the
most current data without manual intervention. This is essential for maintaining data
integrity, especially in institutional settings where performance metrics, accreditation
data, or faculty KPIs must remain up to date.

Steps to Set Up Scheduled Refresh

1. Publish the Report
Upload your .pbix file to the Power BI Service via File > Publish > Publish to
Power BI.
2. Navigate to Dataset Settings
In the Power BI Service, go to the workspace containing your report. Locate the
dataset and click the ellipsis (...) > Settings.
 3. Configure Data Source Credentials
Ensure credentials are entered correctly for cloud or on-premises sources. If
using a gateway, verify that it’s online and authorized.
4. Set Refresh Schedule
Under Scheduled Refresh, define:
o Frequency (daily, weekly)
o Time slots (e.g., off-peak hours)
o Failure notifications
5. Enable Gateway (if needed)
For on-premises data, configure a personal or enterprise gateway to facilitate
secure refreshes.
Power BI Premium allows up to 48 refreshes per day, while Pro users typically get 8
refreshes daily.

Best Practices for Refresh Scheduling

Managing Workspaces in Power BI
Workspaces are collaborative environments where teams can build, publish, and
manage reports and datasets.

Workspace Roles

Workspace Management Tasks

 Organize Reports: Group related reports (e.g., NAAC metrics, faculty
dashboards) into thematic workspaces.
 Assign Roles: Control access based on stakeholder responsibilities.
 Monitor Usage: Track report views, refresh status, and performance.
 Publish Apps: Package workspace content into a Power BI App for broader
distribution.

Efficient workspace management ensures data governance, collaboration, and report

lifecycle control.