Day 01 - Introduction To Analytics

Business Analytics &
Data Analytics
Business Analytics
• Combination of skills, technologies, and practices used to examine
an organization's data and performance as a way to gain insights
and make data-driven decisions in the future using statistical
analysis
• The goal of BA is to narrow down which datasets are useful and

which can increase revenue, productivity, and efficiency
Business Analytics - Process
Understand the
Business Need
Make a Data
Decision Collection
Business
Analytics
- Process
Get the Right or Analyze
Best Solution Data
Predict Analysis
Data Analytics
• Process of exploring and analyzing large datasets
• Focus on extracting insights from raw data using specialized Tools

or Softwares
• Helps in improving the speed and efficiency of your business

Business Intelligence
• Business Intelligence is a set of processes, architectures, and
technologies or tools that convert raw data into meaningful, presentable
reports or information
• Business intelligence combines business analytics, data mining, data

visualization, data tools and infrastructure, and best practices to help
organizations to make more data-driven decisions
• It is a process to transform data into actionable intelligence and
knowledge
• BI supports fact-based decision making using historical data rather than

assumptions
Business Intelligence - Process
• Data mining • Data Visualization
• Reporting • Visual Analysis
• Performance Metrics & Benchmarking • Data Preparation
• Descriptive analytics
• Querying
• Statistical Analysis
Why Business Intelligence?
• Business intelligence can help companies make better decisions by
showing present and historical data within their business context
o Identify ways to increase profit o Optimize operations
o Analyze customer behavior o Predict success
o Compare data with competitors o Spot market trends
o Track performance o Discover issues or problems

Business Intelligence Tools
• BI tools are types of software used to gather, process, analyze, and visualize
large volumes of past, current, and future data in order to generate actionable
business insights, create interactive reports, and simplify the decision-making
processes
• They include key features such as data visualization, visual analytics, interactive
dashboarding and KPI scorecards
• They enable users to utilize automated reporting and predictive analytics
features based on self-service
Different BI Tools
• Power BI • ZOHO Analytics
• Tableau • MicroStrategy
• QlikView • IBM Cognos Analytics
• Datapine • Yellowfin BI
• Clear Analytics • SAP Business Intelligence
• DOMO • Pentaho:
• Metric Insights • TIBCO Jaspersoft
Power BI
Power BI
• Power BI is a business analytics service by Microsoft
• It aims to provide interactive visualizations and business intelligence

capabilities with an interface simple enough for end users to create
their own reports and dashboards
• It is part of the Microsoft Power Platform

Power BI
• Power BI provides cloud-based BI (business intelligence) services,
known as "Power BI Services", along with a desktop based interface,
called "Power BI Desktop“
• It offers data warehouse capabilities including data preparation,

data discovery and interactive dashboards
Power BI
Components
Power BI – Key Components
• Power BI Desktop
o The Windows-desktop-based application for PCs and desktops,

primarily for designing and publishing reports to the Service.
• Power BI Service
o The SaaS-based (software as a service) online service. This was

formerly known as Power BI for Office 365, now referred to as
PowerBI.com, or simply Power BI
• Power BI Mobile Apps
o The Power BI Mobile apps for Android and iOS devices, as well as for
Windows phones and tablets
• Power BI Gateway
o Gateways used to sync external data in and out of Power BI and are
required for automated refreshes. In Enterprise mode, can also be
used by Flows and PowerApps in Office 365
• Power BI Embedded
o Power BI REST API can be used to build dashboards and reports into
the custom applications that serves Power BI users, as well as non-
Power BI users
• Power BI Report Server
o An On-Premises Power BI Reporting solution for companies that

won't or can't store data in the cloud-based Power BI Service
• Power BI Premium
o Capacity-based offering that includes flexibility to publish reports

broadly across an enterprise, without requiring recipients to be
licensed individually per user. Greater scale and performance than
shared capacity in the Power BI service
• Power BI Visuals Marketplace
o A marketplace of custom visuals and R-powered visuals

Power BI
Installation
Power BI – Installation
Power BI
Architecture
Power BI – Architecture
Data Source
Power BI Desktop Power BI Service Client/End User
o MS Excel
o CSV/TXT
o SQL Server
o MS Access
o MySQL
o Web
o SAP HANA
o Oracle
o PDFs
Connect
Data Source
Connect Data Source
• You can connect Power BI Desktop to many types of data sources, including
on-premises databases, Microsoft Excel workbooks, and cloud services
• Currently, there are about 60 Power BI-specific connectors to cloud services
such as GitHub and Marketo
• You can also connect to generic sources through XML, CSV, text, and ODBC.
Power BI will even extract tabular data directly from a website URL.
Click here for more details

Power
Query Editor
Power Query Editor
• Power Query is a data transformation and data preparation engine
• Power Query comes with a graphical interface for getting data from sources
• Power Query Editor for applying transformations
• Because the engine is available in many products and services, the destination
where the data will be stored depends on where Power Query was used
• Using Power Query, you can perform the extract, transform, and load (ETL)
processing of data
DAX Functions
DAX Functions
• Data Analysis Expressions (DAX) is a formula expression language used in
Analysis Services, Power BI, and Power Pivot in Excel
• DAX formulas include functions, operators, and values to perform advanced
calculations and queries on data in related tables and columns in tabular data
models

BY PROFESSIONALS
TO MAKE YOU EXPERT
NOT ONLY TEACH, WE MAKE YOU EXPERTS

Day 01 - Introduction To Analytics

Uploaded by

Copyright:

Available Formats

Day 01 - Introduction To Analytics

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Day 01 - Introduction To Analytics

Uploaded by

Copyright:

Available Formats

Business Analytics &

• The goal of BA is to narrow down which datasets are useful and

• Focus on extracting insights from raw data using specialized Tools

• Helps in improving the speed and efficiency of your business

• Business intelligence combines business analytics, data mining, data

• BI supports fact-based decision making using historical data rather than

• Reporting • Visual Analysis

• Performance Metrics & Benchmarking • Data Preparation

o Identify ways to increase profit o Optimize operations

o Analyze customer behavior o Predict success

o Compare data with competitors o Spot market trends

o Track performance o Discover issues or problems

• It aims to provide interactive visualizations and business intelligence

• It is part of the Microsoft Power Platform

• It offers data warehouse capabilities including data preparation,

o The Windows-desktop-based application for PCs and desktops,

o The SaaS-based (software as a service) online service. This was

• Power BI Report Server

o An On-Premises Power BI Reporting solution for companies that

o Capacity-based offering that includes flexibility to publish reports

• Power BI Visuals Marketplace

o A marketplace of custom visuals and R-powered visuals

Click here for more details

Click here for more details

You might also like