INSTITUTE VISION AND MISSION

VISION
To emerge as a premier institution for technical education in the country through academic
excellence and to be recognized as a Center for Excellence in Research & Development

MISSION
To establish a strong institution by consistently maintaining state of the art infrastructure & a
cohesive world class team by providing need based technical education

DEPARTMENT VISION AND MISSION

Vision:
To be recognized as a Centre of Excellence in Data Science to meet the ever growing needs
of Industry and Society.

Mission:

To empower students with innovative and cognitive skills to gain expertise in the field of
Data science.

To Inculcate the seeds of knowledge by providing industry conducive environment to enable

students excel in the field of Data Science.

To provide an appropriate ambience to nurture the young Data Science [Link]

Objectives:
● Effective use of Business Intelligence (BI) technology (Power BI) to apply data
visualization
● To discern patterns and relationships in the data.
● To build Dashboard applications.
● To communicate the results clearly and concisely.
● To be able to work with different formats of data sets.

Course Outcomes: At the end of the course a student should be able to

● Show how to import data into Power BI
● Illustrate Power BI concepts of Dimensions and Measures.
● Develop Programs and understand how to map Visual Layouts and Graphical Properties.
● Create a Dashboard that links multiple visualizations.
● Use graphical user interfaces to create Frames for providing solutions to real world proble
ms.

Lab Problems:

EXPERIMENT 1
Understanding Data, What is data, where to find data, Foundations for building Data Visualiz
ations, Creating Your First visualization?

EXPERIMENT 2
Getting started with Power BI Software using Data file formats, connecting your Data to
power BI, creating basic charts(line, bar charts, Tree maps),Using the Show me panel.

EXPERIMENT 3
Power BI Calculations,Overview of SUM, AVR, and Aggregate features, Creating custom ca
lculations and fields.

EXPERIMENT 4
Applying new data calculations to your visualizations, Formatting Visualizations, Formatting
Tools and Menus, Formatting specific parts of the view.

EXPERIMENT 5
Editing and Formatting Axes, Manipulating Data in Power BI data, Pivoting Power BI data.

EXPERIMENT 6
Structuring your data, Sorting and filtering Power BI data, Pivoting Power BI data.

EXPERIMENT 7
Advanced Visualization Tools: Using Filters, Using the Detail panel, using the Size panels, c
ustomizing filters, Using and Customizing tool tips, Formatting your data with colors.

EXPERIMENT 8.
Creating Dashboards & Storytelling, creating your first dashboard and Story, Design for
different displays, adding interactivity to your Dashboard, Distributing & Publishing you
r Visualization.

EXPERIMENT 9
Power BI file types, publishing to Power BI Online, Sharing your visualizations, printing, and
Exporting.

EXPERIMENT 10
Creating custom charts, cyclical data and circular area charts, Dual Axis charts.
 DATA VISUALIZATION - R PROGRAMMING/ POWER BI

INTRODUCTION:

Installation of Power BI Desktop:

AIM:How to install power bi

PROCEDURE:

STEPS:-
1. Go to the Microsoft Power BI website.
2. Click on the "Get started for free" button.
3. Sign in with a Microsoft account or create a new one.
4. Choose the Power BI plan that you want to use and click on "Start free".
5. Download the Power BI installer for your laptop.
6. Double-click on the installer to start the installation process.
7. Follow the on-screen instructions to complete the installation.
8. Once the installation is complete, launch the Power BI application.
9. Sign in with your Microsoft account and start using Power BI.
10. Explore the different features and tools that Power BI has to offer.

OUTPUT:
WEEK 1:
AIM:
Understanding data,what is data,where to find data,foundation for building data visuali
sations,creating your first visualisation.
DESCRIPTION:
power BI is a collection of software services, apps, and connectors that work together to turn
your unrelated sources of data into coherent, visually immersive, and interactive insights. Yo
ur data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid
data warehouses. Power BI lets you easily connect to your data sources, visualize and discove
r what's important, and share that with anyone or everyone you want.
What is Data?

Data refers to raw facts, statistics, or information collected or stored in a structured or

unstructured form. Data can take various forms, such as text, numbers, images, videos, and
more. It is the foundation of all information and knowledge and is used in various fields for
analysis, decision-making, and understanding trends and patterns.

Data can be categorized into two main types:

 Structured Data: This type of data is organized into a specific format, such as tables or
databases, and is easily searchable and analyzable. Examples include spreadsheets,
relational databases, and CSV files.
 Unstructured Data: Unstructured data lacks a specific format and can include text
documents, social media posts, images, audio recordings, and more. Analyzing
unstructured data often requires advanced techniques like natural language processing
and image recognition.

Semi-structured data is a type of data that is not purely structured, but also not completely
unstructured. It contains some level of organization or structure, but does not conform to a
rigid schema or data model, and may contain elements that are not easily categorized or
classified.

 Semi-structured data is typically characterized by the use of metadata or tags that provide
additional information about the data elements. For example, an XML document might
contain tags that indicate the structure of the document, but may also contain additional
tags that provide metadata about the content, such as author, date, or keywords.
 Other examples of semi-structured data include JSON, which is commonly used for
exchanging data between web applications, and log files, which often contain a mix of
structured and unstructured data.

Where to Find Data?

You can find data from various sources, depending on your specific needs:
 Open Data Portals: Many governments and organizations provide free access to a wide
range of data through open data portals. Examples include [Link] (United States) and
[Link] (United Kingdom).
 Data Repositories: Academic institutions, research organizations, and data enthusiasts
often share datasets on platforms like Kaggle, GitHub, and the UCI Machine Learning
Repository.
 APIs (Application Programming Interfaces): Some websites and services offer APIs that
allow you to programmatically access and retrieve data. Examples include Twitter API,
Google Maps API, and financial market APIs.
 Web Scraping: You can extract data from websites using web scraping tools and libraries
like BeautifulSoup and Scrapy. However, be mindful of the website's terms of use and
legal restrictions.
 Surveys and Surveys: You can conduct your own surveys or collect data through
questionnaires and interviews.
 IoT Devices: Internet of Things (IoT) devices generate vast amounts of data that can be
used for various purposes.
 Commercial Data Providers: Some companies specialize in selling datasets for specific
industries, such as market research, finance, and healthcare.
Foundations for Building Data Visualizations:

Creating effective data visualizations requires a strong foundation in several key areas:
 Data Analysis: Before creating visualizations, you should thoroughly analyze your data
to understand its structure, relationships, and any patterns or trends. Exploratory data
analysis (EDA) techniques can help with this.
 Statistical Knowledge: Understanding basic statistics is essential for making meaningful
interpretations of data. Concepts like mean, median, standard deviation, and correlation
are commonly used in data visualization.
 Domain Knowledge: Having knowledge of the specific domain or subject matter related
to your data is crucial for creating contextually relevant visualizations. It helps you ask
the right questions and provide valuable insights.
 Visualization Tools: Familiarize yourself with data visualization tools and libraries such
as matplotlib, Seaborn, ggplot2, [Link], and Power BI. Each tool has its strengths and can
be used for different types of visualizations.
 Design Principles: Study design principles, including color theory, typography, and
visual hierarchy, to create visually appealing and effective visualizations. Avoid common
pitfalls like misleading visualizations.
 Interactivity: Learn how to add interactive elements to your visualizations to engage
users and allow them to explore the data. This can be achieved using tools like
JavaScript, Python libraries, or dedicated visualization software.

PROCEDURE:
1. Create your first report by connecting to a data source, selecting the appropriate visuali
zations, and customising the layout.
2. Use Power Query to clean and transform your data before importing it into Power BI. E
xperiment with different filters and slicers to analyse your data from different angles.
3. Share your reports with others by publishing them to the Power BI service or embeddi
ng them in other applications.
4. Collaborate with your team by creating workspaces and assigning roles and permission
s. Stay up-to-date with the latest trends and insights by using Power BI's built-in AI capab
ilities, such as natural language queries and automated insights.
5. Join the Power BI community to learn from other users, share your own experiences, a
nd get support from Microsoft experts.