Data Storytelling with PowerBI
- Description
- Curriculum
- FAQ
- Reviews
The ability to weave data stories using data and visuals – is the future of the modern workplace.
Data storytelling is developing as an essential skill in the modern workplace and one of the main means of delivering insights from analytics. In this course we will explore data storytelling to extract, understand and effectively communicate insights in a compelling manner. The goal is positive business outcomes, strategic insights and improved team collaboration.
Stories have historically been the tool of leaders and influencers – simplifying the world around us, uniting communities and making a lasting impact. Your favorite series, brands, marketers and leaders use stories to build engagement and to communicate key values and insights. Similarly in the complex world of data – stories combining data visuals and key insights – cut through the clutter – engage with logic and emotion and drive actionable outcomes. Data storytelling is a powerful means to share insights and drive change within an organization.
In this course we will use the 7-step data storytelling framework to find the value in data and tailor it to the needs of stakeholders using visuals and a compelling narrative. This is a simple step-by-step framework to delve into data – find those underlying questions and communicate an actionable outcome.
You will use the Microsoft PowerBI data visualization tool to create practical solutions with techniques you can tailor to your needs. The solutions will be quick and easy to implement requiring no coding knowledge. Remember – this course is designed for anyone – requiring no practical experience.
Join thousands embracing exciting modern data literacy skills and make a practical impact on your life.
-
1Why is data storytelling importantVideo lesson
"There is a story in your data waiting for you to reveal it".
In this lecture you will uncover the relevance of data storytelling in extracting, understanding and communicating insights tailored to your audience.
-
2The magic of data storytellingVideo lesson
This lecture focuses on the mechanics of data storytelling which allows it to appeal to stakeholders on a mental and emotional level. We will uncover the benefits of data storytelling.
-
3The role of the data storytellerVideo lesson
"Data stories amplify the effectiveness of a team"
The data storyteller is a modern data literacy skill. Uncover the relevance of the role in the modern workplace.
-
5Building your hypothesisVideo lesson
"A great data story starts with uncovering a story to tell."
In this lecture we will uncover methods to frame your hypothesis and actionable outcome.
-
6Framing your visual with insightsVideo lesson
In this course we will learn to frame and shape data visualizations based on hypothesis questions.
-
7Transforming your data for visualsVideo lesson
"Transforming data unlocks its value"
We will explore data transformation to create business friendly datasets and visuals.
-
8The fall of Enron scenarioVideo lesson
"Investors don't like uncertainty" - Kenneth Lay
Enron was a Wall Street corporation that collapsed overnight due to fraudulent accounting practices. In this lesson we will walk through the trials and tribulations - and gain insight into the structure of a data story.
-
9Tools for focusing insightsVideo lesson
-
10Exercise: Visualizing social network relationshipsVideo lesson
In this exercise you will create the Enron chord chart visualization.
A chord chart is a great simplified circular layout to link relationships. In this exercise you will depict the significant relationships in a dataset containing the communication of 600000 Enron employees. Investigate potential fraudulent relationships, uncover hidden relationships - you will be the investigator.
-
11Exercise: Minard mapVideo lesson
In this exercise you will replicate one of the greatest visualizations of all time and explore the power of a multidimensional data visualization.
The Minard map depicts the plight of Napoleon's troops in Russia. Get a glimpse of the action, events and factors influencing the movement and welfare of the troops.
-
12IntroductionVideo lesson
"Knowledge is the rediscovering of our own insight"
The introduction will walk through some of the data mining use cases you will explore and create.
-
13Why data mining is importantVideo lesson
In this lecture we explore the importance of data mining and how it can uncover hidden insights for your data stories.
-
14Relationship visualsVideo lesson
In this lesson we will explore data visualizations used for relationships in our data. We will explore how to highlight relationships discovered in our data in a way that conveys our message effectively.
-
15Parts to whole visualsVideo lesson
"The whole is greater than the sum of its parts" - Aristotle
In this lecture we will explore part to whole visual which are effective for showing proportions and quickly highlighting trends for key insights and elements.
-
16Visual data miningVideo lesson
"Design is thinking made visual"
In this session we will look at visual techniques for supervised and unsupervised data mining. This will help you use data stories to bring hidden insights discovered by machines to life.
-
17Scenario: World happiness indexVideo lesson
Does money buy happiness? In this scenario we explore this question through visual trend analysis.
-
18Clustering and visualizing associations in dataVideo lesson
In this lesson we will explore k-means clustering to find associations in your data. This is one of the simplest and popular unsupervised machine learning algorithms. Visualizing techniques can help bring these associations to life by appealing to our mind's pattern matching tendencies.
-
19Exercise: Exploring relationships with correlation plotVideo lesson
In this exercise you will create a correlation plot. This is a quick way to visualize correlations and potentially find causations and new insights.
-
20Exercise: K-means clustering unsupervised learningVideo lesson
In the exercise we will create a K-means clustering visual built on machine learning to colorfully depict associations in a way that is simple and engaging for an audience. You can tailor this solution to build clusters of relationships in your dataset.
-
21Exercise: Root cause analysis with decomposition treeVideo lesson
In this exercise we will create a decomposition tree. This is an AI powered visual that lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. AI can highlight the next dimension to drill through based on predefined criteria. This tool is valuable for data stories with ad hoc exploration and intelligently performing root cause analysis.
-
22Exercise: Hidden insights with key influencersVideo lesson
The key influencers visual breaks down metrics and variables into factors. It is AI driven - analysing your data, , ranking the factors that matter as key influencers.
This can form a powerful data story - using machine-driven insights to support your hypothesis and highlight key factors influencing a particular outcome.
-
23Exercise: Analytics dashboard - Chicago crimeVideo lesson
In this exercise you will be a sleuth - understanding the crime dynamics in Chicago using an analytical dashboard. Combining dashboard visual design techniques and the power of machine learning to combine human and machine insights to vast potential.
-
24Exercise: Smoothing data pointsVideo lesson
In this exercise you will create the health and wealth data visualization using a spline visualization. A spline smooths out the relationships in noisy scatterplot data to simplify insights for quick perception.
-
25Exercise: Boxplot analysisVideo lesson
In this exercise you will create a boxplot - a powerful visual for quick summarization and exploration of a dataset.
A boxplot gives an idea of data symmetry, skewness and shows outliers. It also grants the power of comparing categories across dataset for quick analysis.
-
26What is Gestalt?Video lesson
"Seeing is believing"
In this session we will look at Gestalt - the principle that underlies the art of data visualization to trigger human perception and quickly pave the way to insights.
-
27Visual design principlesVideo lesson
"Good design is good business" - Thomas Watson
The session will introduce visual design principle to understand its role and importance in heightening emotion and design stories for visual impact.
-
28ProximityVideo lesson
In this session we look at the Gestalt principle of proximity and how our eyes magically associate elements for key insights.
-
29SimilarityVideo lesson
In this session we look at the Gestalt principle of similarity and how effective it is across a wide range of visuals.
-
30Closure, connection and orderVideo lesson
As humans we perceive closure, connection and order in the world around us. See the effects of these techniques in quickly highlighting patterns for rapid insights and conclusions.
-
31Isomorphic correspondence and contrastVideo lesson
In this session we look at:
The Gestalt principle of isomorphic correspondence and how can use it appeal to the emotions and subconsciousness of people.
The use of contrast to highlight differences and emphasize insights in a really exciting way.
-
32Hierarchy patternsVideo lesson
-
33Exercise: Real-time dashboard - load dataVideo lesson
-
34Exercise: Real-time dashboard - transform dataVideo lesson
The Stock Performance dashboard siphons data from Yahoo finance to gather real time insights on stock market performance using hierarchical dashboard design.
In this exercise you transform data for the visual to prepare the data model for visualization and incorporate key metrics.
-
35Exercise: Real-time dashboard - visualize dataVideo lesson
The Stock Performance dashboard siphons data from Yahoo finance to gather real time insights on stock market performance using hierarchical dashboard design.
In this exercise you will bring the dashboard to life with metrics for key insights and visuals and arrangement according to Gestalt and visual design principles.
-
36Exercise: Force network graphs for social networksVideo lesson
"May the force be with you"
A force-directed graph is a visualization technique that focuses on relationships between elements of interest. In this exercise you will create this aesthetic visual and use machine learning to intelligently link related entities.
This is a powerful tool in network visualization, social media representation, complex graph visualization, knowledge networks and complex system representation.
-
37The role of the narrativeVideo lesson
In this session I will introduce the role of the narrative in your data story.
-
38The comic style narrativeVideo lesson
In this session we will explore the comic style narrative - a framework to connect insights and make them exciting and memorable.
-
39The eight visual story typesVideo lesson
The eight visual story types serve as a foundation for your narrative and helps emphasize key insights using the appropriate charts and graphs.
-
40Scenario: Health and wealth of nationsVideo lesson
-
41Zooming through your narrativeVideo lesson
-
42The contrasting storyVideo lesson
-
43An intersection of insightsVideo lesson
In this session we explore intersections where different sources of information align and may bring forth new insights. This is a more complex form of data story but highly effective in building new actionable outcomes.
-
44Shock and aweVideo lesson
The shock and awe data story™ technique aim to provide insights in a rapid manner to keep the audience emotionally engaged and to maintain their sense of perception.
In this session we will explore this creation of this narrative type.
-
45Hooking your audienceVideo lesson
In this session we will delve into the hook. This is often the most important part of the data story - to build the stakeholder's energy and to set the frame and context.
-
46Springing tensionVideo lesson
In this session we will explore the Shock and Awe Data Story™ in motion - slowly uncoiling tension to engage and improve retention.
-
47The ingredients for powerful insightsVideo lesson
Creating powerful insights follows basic ingredients and a formula. In this session we will explore the building blocks and impacts of insights. In this way you will be able to leverage insights more effectively.
-
48The cliffhangerVideo lesson
The cliffhanger is a classic storytelling technique. In this session we explore it in the world of data stories. You will gain insight into weaving cliffhangers into your data stories to build suspense and make insights more memorable,
-
49Exercise: Multifaceted small multiplesVideo lesson
Small multiples are an effective way to visualize data with multiple dimensions - creating snapshots of graphs across these dimensions.
In this exercise you will create these little data stories to tell all sides of a story and make a big impact.
-
50Exercise: Narrative over timeVideo lesson
Narrative over time is the most common data story yet very powerful.
In this exercise you will create a narrative over time graph and effectively annotate it to deliver you message effectively.
-
51Exercise: Stepper narrative - Facebook IPO launchVideo lesson
In this session you will create frame by frame insights - in a comic-style narrative - to link insights to an actionable conclusion.
-
52Exercise: Dynamic narrative over time - Health and wealth data loadVideo lesson
-
53Exercise: Dynamic narrative over time - Health and wealth transformationVideo lesson
You will create a data story in motion - mimicking the famous health and wealth of nations data story.
-
54Exercise: Dynamic narrative over time - Health and wealth visualizationVideo lesson
You will create a data story in motion - mimicking the famous health and wealth of nations data story.
In this exercise we bring the data story to life.
-
55Exercise: Zoom and filter - Navigating stock hierarchiesVideo lesson
Treemaps are a powerful to for complex dataset - able to depict multiple hierarchies and dimensions and simplify big data.
In this exercise you will create a product treemap to delve into a product hierarchy - and truly see the trends of stock sales.
External Links May Contain Affiliate Links read more