Untitled presentation descriptive analytics.pdf

descriptive analytics

1. DESCRIPTIVE ANALYTICS
INTM589
NAME- PIYUSH DHANDA
REG NUMBER- 12113237

2. Table of
contents

1.Day 1: Analytics Overview…
2.Day 2: Excel Dashboard & Prompting
in Reports…
3.Day 3: Dashboard creation & Data
grouping…
4.Day 4: Story & Exploration in
Cognos…
5.Day 5: Power BI Visualizations &
Dashboard…

3. Report creation using
IBM Cognos Analytics

●Uploading data
●Creating Data Module
●Using Sample Data
●Creating New Report
●Final Output

4. Day 1 : REPORT AND ITS OUTPUT

5. Day 1
Learnings
●Explored Data: Learned about Structured
& Unstructured data, Big Data concepts.
●Tool Usage: Created an IBM Cognos
Analytics account with a UI featuring
Dashboard, Exploration, and Story
components.
●Dashboard Creation: Uploaded and
transformed data into modules for
dashboard creation.
●Excel Skills: Revised Excel functions -
Filtering, Sorting, Pivot Tables.
●Cognos Features: Explored 38
visualizations within IBM Cognos
Analytics.

6. Excel Dashboard

7. Prompting Tools

8. Day 2
Learnings
●We delved into reports, focusing on 9
types of prompts for efficient data
access.
● Main tools included text box prompts,
date prompts, time prompts, and
prompt buttons.
●Making of dashboard in excel using
pivot chart.

9. Dashboard on amazon

10. Grouping & Sum

11. Day 3
Learnings
●We gained insights into enhancing
dashboards by adding backgrounds.
● Exploring filters, data formatting, property
adjustments, and grouping /sorting
techniques,
● we created dashboard that provided a
visually enriched perspective on the data.
●Used data grouping and number formatting
into currency to get the final output.

12. HR Employee attrition data

13. Exploration

14. Join Query

16. Day 4
Learnings
●Worked on queries .
●Normal query, joint, union query
●Worked in exploration , help in
automatic charts creation

17. Power BI Dashboard

18. Day 5
Learnings
●Data cleaning
●Data mining
●Data transformation
●Data modeling- filter
●Data visualisation
●Data bi server (sharing)